Re: Slow ODBC Connection

On 11/12/05, Ekstrand, Pam <Pam.Ekstrand@oneneck.com> wrote: > We have users who have just starting connecting to our informix 9.40FC4 > database using informix ODBC drivers and they are experiencing 20 to > 30-second connect times. When they try to connect, the online.log shows > a -952 message: > > Password validation for user (xxx) failed. > Check for password aging/account lock-out. Where are the users connecting from? The Unix server, or from PCs? When they connect, are they specifying user name and password? But the user then does end up connecting successfully to the database. > > Any thoughts on where I might look for causes? It seems that it must be > trying to validate the password in the wrong place first, and then > eventually does validate it. Look at whether you have a PAM authorization setup. Look at whether you have some networked password authentication service in place. Are you on HP-UX? I'm a little worried about that 'the user then does end up connecting successfully' information; if you get an error like that, you should not be connecting. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/ sending to informix-list