956: Client is not in /etc/hosts.equiv on the remote host.

[testhandle]

Hi,

Trying to select records from different database on the same machine(cctest01) with the error

select count(*) from testdb@testdbservername:table1;


'956: Client is not in /etc/hosts.equiv on the remote host. '

Following are entries from .rhosts file

# Hostnames
#
cctest01
#
# Aliases
#
testdb
testdbservername
#

Any solution please?

Thanks
John Jayaseelan

 

[tungaw2003]

create a file named hosts.equiv on your /etc directory and add the ff:

your_remote_machine your_user


or
verify your $INFORMIXSERVER if correct.

 

[testhandle]

Thanks for the reply.

'your_remote_machine your_user'

At present the entry in the /etc/hosts.equiv is just the <server name>. The situation is source and targer informix instances are running in the same server.


'verify your $INFORMIXSERVER if correct'

Do you mean 'INFORMIXSERVER' UNIX env variable? Should I set the actual UNIX server name or DBservername specified in the config file.

 

[testhandle]

Hi,

This error is intermittent. The following select

select count(*) from <dba>@<dbserver>:<table>

sometimes gives the result and sometimes error '956: Client is not in /etc/hosts.equiv on the remote host.'.

Thanks

 

[breizhti]

Hi,
to provide a fast answer, please provide :
- sqlhosts file
- DBSERVERNAME and DBSERVERALIASES in your ONCONFIG file
- /etc/hosts
- uname -, or hostname result

jean

 

[testhandle]

Hi,

Following are the info aksed.

sqlhosts file
_______
cctrain01 tcp cctest01 training
ccnewcor01 tcp cctest01 tstprod
________

DBSERVERNAME=cctrain01,ccnewcor01
No DBSERVERALIASES in your the TBCONFIG file

/etc/hosts
________
<IP address> cctest01 cctest01x
_______

hostname = cctest01

Thanks

 

[breizhti]

You CANNOT have two values for your DBSERVERNAME parameter.

You have to set one value in DBSERVERNAME and the others will be listed in the DBSERVERALIASES, with a comma as separator.

Then you set the variable INFORMIXSERVER to the value of
DBSERVERNAME or to one of the values of DSERVERALIASES.
In IDS release < 9.4, the maximum number of aliases is
10 and begining with 9.4 it's now 32.

It's a little strange that your IDS server accept your
config file with different value in DBSERVERNAME !!



(In your sqlhosts, I presume that you have onsoctcp and
not tcp only)

Regards,

jean

 

[testhandle]

Hi,

The DBSERVERNAME value is one only, The values given are from different config file, Source and target server are in the same system.

The informix version is online 5.0, i.e why sqlhosts has tcp.

Thanks

 

[breizhti]

Sorry I didn't notice that you were in release 5.

INFORMIXSERVER is only for IDS 7.x or 9.x

In release 5.X, sqlhosts should be like this :

dbservername protocol hostname servicename

with:
dbservername similar to the one in $TBCONFIG
protocol: olsoctcp or oltlitcp
hostname: should be listed in /etc/hosts
servicename: should be listed in /etc/services and used as parameter for the daemon $INFORMIXDIR/lib/sqlexecd

Concerning your error -956 :
- is the .rhosts in the $HOMEDIR of the user informix or root ?
- who is starting the two daemons sqlexecd ?
- did you check the environment for you two sqlexecd ?

jean

 

[tungaw2003]

Hi All,

I've already resolved the problem. The problem is not on sqlhosts nor .netrc. The problem is on setting up the php.ini file. INFORMIXSERVER,username and password should have default values instead of null strings.

Thanks anyways..

tungaw

 

[testhandle]

Hi,

The sqlhosts file has 'tcp' for prtocol, all other parameters are fine.

- The .rhosts files are availbe in both $HOMEDIR of root & Informix.

- Sqlexecd is startes using root account.

- Env for the sqlexcd are
SQLEXEC=/opt/informix/lib/sqlturbo
PATH=/usr/sbin:/usr/local/bin:/usr/bin:/usr/ccs/bin:/usr/contrib/bin:/opt/nettln
TERMCAP=/opt/informix/etc/termcap
INFORMIXTERM=termcap
INFORMIXDIR=/opt/informix

Thanks

 

[testhandle]

Tungaw,

Plese tell where php.ini file can be found.

Searched the entire system with no result.

find / -name php.ini -print

Thanks

 

[tungaw2003]

You can find it in /u/

http://www/conf/php/php.ini.

This is the default directory where the php.ini initially installed. Use &quot;$ locate php.ini&quot; if you're using linux.

 

[testhandle]

find / -name php.ini -print

did not return any results.

 

[tungaw2003]

Did you install the php?.

do not use $find, instead use $locate php.ini

 

[testhandle]

Not sure php installed. Any help to check php installation and why this needs to be installed.
The O/S is HP-UX so 'locate' command is not available.

Thanks

 

[testhandle]

Any solution please?