Connecting from Windows to Informix on Unix
Posted in 2017
Is there any naming convention used to identify a Windows dektop or server in
the $INFORMIXDIR/etc/hosts.equiv and $INFORMIXDIR/etc/users.equiv file?
Details below.
I am troubleshooting a Windows SSO login using ODBC to connect to HPUX hosting
an Informix instance. The test connection from my colleague's desktop
(sussman-l@nikeseclp.com) fails with the following lines in the Online log:
Test 1
07:03:57 listener-thread: err = -951: oserr = 0: errstr =
@sussman-l.nikeseclp.com[SUSSMAN-L.nikeseclp.com]: Incorrect password or user
@sussman-l.nikes
eclp.com[SUSSMAN-L.nikeseclp.com] is not known on the database server.
07:03:57 listener-thread: err = -951: oserr = 0: errstr =
@sussman-l.nikeseclp.com[SUSSMAN-L.nikeseclp.com]: Incorrect password or user
@sussman-l.nikes
eclp.com[SUSSMAN-L.nikeseclp.com] is not known on the database server.
Test 2
07:05:04 listener-thread: err = -951: oserr = 0: errstr =
leesussman@sussman-l.nikeseclp.c@sussman-l.nikeseclp.com[SUSSMAN-L.nikeseclp.com
]: Incorrect pas
sword or user
leesussman@sussman-l.nikeseclp.c@sussman-l.nikeseclp.com[SUSSMAN-L.nikeseclp.com
] is not known on the database server.
07:05:04 listener-thread: err = -951: oserr = 0: errstr =
leesussman@sussman-l.nikeseclp.c@sussman-l.nikeseclp.com[SUSSMAN-L.nikeseclp.com
]: Incorrect pas
sword or user
leesussman@sussman-l.nikeseclp.c@sussman-l.nikeseclp.com[SUSSMAN-L.nikeseclp.com
] is not known on the database server.
when
/home/muralip > onstat -c | grep -i CFG
REMOTE_SERVER_CFG hosts.equiv
REMOTE_USERS_CFG users.equiv
S6_USE_REMOTE_SERVER_CFG 0
/home/muralip > more $INFORMIXDIR/etc/hosts.equiv
drux
drux1
sussman-l.nikeseclp.com
SUSSMAN-L.nikeseclp.com
/home/muralip > more $INFORMIXDIR/etc/users.equiv
informix
dbuser
dbreader
leesussman
FYI, hosts.equiv does NOT match /etc/hosts as in the *nikeseclp.com entries
are not in /etc/hosts. Expect this should not matter for database connectivity.
Test 1: where is the '@' coming from (in
@sussman-l.nikeseclp.com[SUSSMAN-L.nikeseclp.com]).
Test 2, with a slightly different connection string I get a different unknown
username
Is there a naming convention used to identify a Window dektop or server in the
$INFORMIXDIR/etc/hosts.equiv and $INFORMIXDIR/etc/users.equiv file?