I need to connect some client software (SDK based) to an Informix 7.3 server running on a Linux box. when I've started tweaking the server was rejecting connections on the service port. now I narrowed down the problem to a -952 error "User's password is not correct for the database server.".
here I've noticed a strange behaviour of dbaccess, which I use locally (on Linux). I go to the "Connection" option, select a database server and just press ENTER for the user name to get a valid connection. but when I enter a user name, I am asked for the password, I am entering the password and get the same 952 error.
sqlhosts looks like:
fsrDBserver onipcshm fsr shmIDSservice
netDBserver onsoctcp 18.104.22.168 netDBservice
the behaviour is the same for both fsr and net servers.
Pinned topic connecting to Informix 7.3 on Linux problem
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-08-22T06:21:21Z at 2012-08-22T06:21:21Z by jemanfu
andreasl 100000CHVU401 Posts
Re: connecting to Informix 7.3 on Linux problem2012-08-18T11:09:15ZThis is the accepted answer. This is the accepted answer.Hello,
your Linux box (which flavor and version?) using any fancy, non-trivial authentication or password encryption method, or the user you're trying to connect as not a local user?
Is this happening with any user, e.g. user informix as well? And has it worked already?
Re: connecting to Informix 7.3 on Linux problem2012-08-19T06:09:24ZThis is the accepted answer. This is the accepted answer.
- andreasl 100000CHVU
I am new to this job and I was concentrating on db issues. I was told it is a RedHat. I am (almost) certain there is no fancy authentication. I am using PuTTY to connect to the server, usually ssh. I've checked with several accounts. here is what I can tell:
root@fsr /root# cat /proc/version
Linux version 2.4.2-2 (firstname.lastname@example.org) (gcc version 2.96 20000731 (Red Hat Linux 7.1 2.96-79)) #1 Sun Apr 8 20:41:30 EDT 2001
yes, it happens will all accounts, including informix. no, nobody has ever cared to install a remote client software. the previous IT guy had no skills on unix/networking so what I got is a pretty old and never approached problem.
Re: connecting to Informix 7.3 on Linux problem2012-08-22T06:21:21ZThis is the accepted answer. This is the accepted answer.after several epic attempts to solve the problem, including strace-ing both server and dbaccess, I've remembered that the main goal was to quickly establish a client server connection so I went for a trusted one (security is not an important issue). so I can declare the problem solved.
one useful note: I am using IBM client SDK 3.70.TC5DE. I got a Setnet32 "Could not open Registry" error. the solution was from datadirect's knowledgebase site, article 3008:
"Check the INFORMIXSQLHOSTS variable in the Enviroment section of Setnet32 and confirm the value is correct. If the value is correct, clear the value and then try to set the Server and Host information."