Informix Authentication failure with Hp-Unix
User on Informix 12.10.FC4W1X3/HP-Unix experienced authentication failures (error 951) when connecting via JDBC/ODBC to a specific SDS node, despite valid credentials working locally and with other instances. Direct password authentication failed while trusted connections worked. A PMR was opened with IBM but no resolution was recorded in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
IDS 12.10.FC4W1X3 on HP-Unix B.11.31 U ia64 (configured to work in trusted
mode, NO shadowing)
This issue is pertianing to connection with one of the sds nodes
I am facing a very weird issue of connectivity with one of the java
application trying to connect to informix database using correct user id and
password and still getting the below error in online.log
14:45:39 Password Validation for user [ind9appl] failed!
14:45:39 Check for password aging/account lock-out.
14:45:39 listener-thread: err = -952: oserr = 0: errstr =
vikas@prodbcc: User (vikas@prodbcc)'s password is not correct
for the database server.
The Java application log file shows following error
[2015-08-20 14:45:39,652] WARN AdviserConnectionPool:179 - Exception
Occured while getting Connection. You may be need to increase the pool.
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (Incorrect password or user com.informix.asf.
IfxASFRemoteException: vikas@prodbcc is not known on the database
server.)
With user "vikas" and valid password I am able to login to database server
host and do dbaccess successfully but it does not work with the JDBC string
We even tried writting a small java connection code program but there too it
fails.
String DbUrl =
"jdbc:informix-sqli://200.200.165.165:2000/test:informixserver=prod1;user=vikas;
password=xxxxxxx;";
Even with ODBC connectino from my machine to this server with different user
id's including "informix" user does not work and gives the same error "user
not known on database server"
surprisingly this app when configured to point ot another SDS instance or the
primary instance, the connneciton is successfull.
Checked all the corresponing /etc/hosts, hosts.equiv and even tried .rhosts
entries but nothing seems to be working
Checked the permissions of oninit file and confirmed that the instance was
started with user "informix" only.
Checked with a 6 character password (less than 8) but did not work.
Checked out the following IBM links for similar issue but did not help
http://www-01.ibm.com/support/docview.wss?uid=swg21141697
http://www-01.ibm.com/support/docview.wss?uid=swg21177527
Any more checks or suggesstions can be helpful.
Regards,
Vikas
Hello.
You didn't mention, but.. what Java driver version are you using ???
Maybe you are using an old version, that might be facing some bug.
The latest version is Informix JDBC 4.10.JC5, check it out.
If you are using a recommended/compatible JDBC driver, you should be guided to
open a PMR in IBM support.
Hope it helps.
Regards.
Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
IBM Information Management Informix Technical Professional
IBM Certified Developer - Informix Genero
BRIUG website administrator
Informix independent consultant
> To: ids@iiug.org
> From: vikas.hivarkar@gmail.com
> Subject: Informix Authentication failure with Hp-Unix [35620]
> Date: Fri, 21 Aug 2015 06:41:06 -0400
>
> IDS 12.10.FC4W1X3 on HP-Unix B.11.31 U ia64 (configured to work in trusted
> mode, NO shadowing)
>
> This issue is pertianing to connection with one of the sds nodes
>
> I am facing a very weird issue of connectivity with one of the java
> application trying to connect to informix database using correct user id and
> password and still getting the below error in online.log
>
> 14:45:39 Password Validation for user [ind9appl] failed!
> 14:45:39 Check for password aging/account lock-out.
> 14:45:39 listener-thread: err = -952: oserr = 0: errstr =
> vikas@prodbcc: User (vikas@prodbcc)'s password is not correct
> for the database server.
>
> The Java application log file shows following error
> [2015-08-20 14:45:39,652] WARN AdviserConnectionPool:179 - Exception
> Occured while getting Connection. You may be need to increase the pool.
> org.apache.commons.dbcp.SQLNestedException: Cannot create
> PoolableConnectionFactory (Incorrect password or user com.informix.asf.
> IfxASFRemoteException: vikas@prodbcc is not known on the database
> server.)
>
> With user "vikas" and valid password I am able to login to database server
> host and do dbaccess successfully but it does not work with the JDBC string
>
> We even tried writting a small java connection code program but there too it
> fails.
> String DbUrl =
>
"jdbc:informix-sqli://200.200.165.165:2000/test:informixserver=prod1;user=vikas;
password=xxxxxxx;";
>
> Even with ODBC connectino from my machine to this server with different user
> id's including "informix" user does not work and gives the same error "user
> not known on database server"
>
> surprisingly this app when configured to point ot another SDS instance or the
> primary instance, the connneciton is successfull.
>
> Checked all the corresponing /etc/hosts, hosts.equiv and even tried .rhosts
> entries but nothing seems to be working
> Checked the permissions of oninit file and confirmed that the instance was
> started with user "informix" only.
> Checked with a 6 character password (less than 8) but did not work.
>
> Checked out the following IBM links for similar issue but did not help
> http://www-01.ibm.com/support/docview.wss?uid=swg21141697
> http://www-01.ibm.com/support/docview.wss?uid=swg21177527
>
> Any more checks or suggesstions can be helpful.
>
> Regards,
> Vikas
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Hi,
On the database server when I try to do
dbaccess >>
CONNECTION: Connect >>
SELECT DATABASE SERVER >> sds1
USER NAME >> vikas
PASSWORD >> xxxxxx
951: Incorrect password or user vikas@dbserver is not known on the databaseserver
And because I have a trust based connection establised for this user I can
simply enter and query the database by doing "dbaccess sds1" with out any
error.
I am trying all this with user that is valid (unlocked) on the database server
it self.
Have raised a PMR with IBM but no help as of now. Kinda weird and troubling a
lot.
Regards,
Vikas
================================================================================
===========================
>>Hello.
>>You didn't mention, but.. what Java driver version are you using ???
>>Maybe you are using an old version, that might be facing some bug.
>>The latest version is Informix JDBC 4.10.JC5, check it out.
>>
>>If you are using a recommended/compatible JDBC driver, you should be guided
to open a PMR in IBM support.
>>
>>Hope it helps.
>>Regards.
>>
>>Alexandre Marini
>>IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
>>
>>IBM Information Management Informix Technical Professional
>>
>>IBM Certified Developer - Informix Genero
>>BRIUG website administrator
>>Informix independent consultant
> To: ids@iiug.org
> From: vikas.hivarkar@gmail.com
> Subject: Informix Authentication failure with Hp-Unix [35620]
> Date: Fri, 21 Aug 2015 06:41:06 -0400
>
> IDS 12.10.FC4W1X3 on HP-Unix B.11.31 U ia64 (configured to work in trusted
> mode, NO shadowing)
>
> This issue is pertianing to connection with one of the sds nodes
>
> I am facing a very weird issue of connectivity with one of the java
> application trying to connect to informix database using correct user id and
> password and still getting the below error in online.log
>
> 14:45:39 Password Validation for user [vikas] failed!
> 14:45:39 Check for password aging/account lock-out.
> 14:45:39 listener-thread: err = -952: oserr = 0: errstr =
> vikas@prodbcc: User (vikas@prodbcc)'s password is not correct
> for the database server.
>
> The Java application log file shows following error
> [2015-08-20 14:45:39,652] WARN AdviserConnectionPool:179 - Exception
> Occured while getting Connection. You may be need to increase the pool.
> org.apache.commons.dbcp.SQLNestedException: Cannot create
> PoolableConnectionFactory (Incorrect password or user com.informix.asf.
> IfxASFRemoteException: vikas@prodbcc is not known on the database
> server.)
>
> With user "vikas" and valid password I am able to login to database server
> host and do dbaccess successfully but it does not work with the JDBC string
>
> We even tried writting a small java connection code program but there too it
> fails.
> String DbUrl =
>
"jdbc:informix-sqli://200.200.165.165:2000/test:informixserver=prod1;user=vikas;
password=xxxxxxx;";
>
> Even with ODBC connectino from my machine to this server with different user
> id's including "informix" user does not work and gives the same error "user
> not known on database server"
>
> surprisingly this app when configured to point ot another SDS instance or the
> primary instance, the connneciton is successfull.
>
> Checked all the corresponing /etc/hosts, hosts.equiv and even tried .rhosts
> entries but nothing seems to be working
> Checked the permissions of oninit file and confirmed that the instance was
> started with user "informix" only.
> Checked with a 6 character password (less than 8) but did not work.
>
> Checked out the following IBM links for similar issue but did not help
> http://www-01.ibm.com/support/docview.wss?uid=swg21141697
> http://www-01.ibm.com/support/docview.wss?uid=swg21177527
>
> Any more checks or suggesstions can be helpful.
>
> Regards,
> Vikas
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
The problem is solved. It was interesting problem and hence sharing it=20
with you all:
Vikas has a trusted system setup which doesn't maintain /etc/shadow file.=20
For HP, Informix checks if the system is trusted or not using a function=20
iscomsec(). If it returns 1, its a trusted system and informix skip=20
password validation and if it returns 0, informix checks for /etc/shadow=20
file.
iscomsec determines if the system is a trusted system or not by checking=20
the file, /tcb/files/auth/system/default. If the file exists, the system=20
is a trusted system. If the file does not exist, the system is not a=20
trusted system.
On Vikas's system, the /tcb/files/auth directory had 700 root:sys=20
permission and hence even though /tcb/files/auth/system/default file was=20
present, iscomsec was not able to read and was returning 0.
By changing permission of /tcb/files/auth to 771 root:sys and ensuring=20
permission of /tcb/files/auth/system also is same, the problem is fixed.
To know more about iscomsec -=20
http://docstore.mik.ua/manuals/hp-ux/en/B2355-60130/iscomsec.2.html
Regards,
Vaibhav S Dantale
IBM Informix CTE Lead
Mobile - +91-9503161335
email- vdantale@in.ibm.com
Twitter - @dantalevs
Blog - http://timeseriesibm.blogspot.in/ (Works better in firefox)
From: "VIKAS HIVARKAR" <vikas.hivarkar@gmail.com>
To: ids@iiug.org
Date: 08/24/2015 04:54 PM
Subject: Re: RE: Informix Authentication failure with Hp-Un [35642]
Sent by: ids-bounces@iiug.org
Hi,=20
On the database server when I try to do=20
dbaccess >>=20
CONNECTION: Connect >>=20
SELECT DATABASE SERVER >> sds1=20
USER NAME >> vikas=20
PASSWORD >> xxxxxx=20
951: Incorrect password or user vikas@dbserver is not known on the=20database=20
server=20
And because I have a trust based connection establised for this user I can =
simply enter and query the database by doing "dbaccess sds1" with out any=20
error.=20
I am trying all this with user that is valid (unlocked) on the database=20
server=20
it self.=20
Have raised a PMR with IBM but no help as of now. Kinda weird and=20
troubling a=20
lot.=20
Regards,=20
Vikas=20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=20
>>Hello.=20
>>You didn't mention, but.. what Java driver version are you using ???=20
>>Maybe you are using an old version, that might be facing some bug.=20
>>The latest version is Informix JDBC 4.10.JC5, check it out.=20
>>=20
>>If you are using a recommended/compatible JDBC driver, you should be=20
guided=20
to open a PMR in IBM support.=20
>>=20
>>Hope it helps.=20
>>Regards.=20
>>=20
>>Alexandre Marini=20
>>IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10=20
>>=20
>>IBM Information Management Informix Technical Professional=20
>>=20
>>IBM Certified Developer - Informix Genero=20
>>BRIUG website administrator=20
>>Informix independent consultant=20
> To: ids@iiug.org=20
> From: vikas.hivarkar@gmail.com=20
> Subject: Informix Authentication failure with Hp-Unix [35620]=20
> Date: Fri, 21 Aug 2015 06:41:06 -0400=20
>=20
> IDS 12.10.FC4W1X3 on HP-Unix B.11.31 U ia64 (configured to work in=20
trusted=20
> mode, NO shadowing)=20
>=20
> This issue is pertianing to connection with one of the sds nodes=20
>=20
> I am facing a very weird issue of connectivity with one of the java=20
> application trying to connect to informix database using correct user id =
and=20
> password and still getting the below error in online.log=20
>=20
> 14:45:39 Password Validation for user [vikas] failed!=20
> 14:45:39 Check for password aging/account lock-out.=20
> 14:45:39 listener-thread: err =3D -952: oserr =3D 0: errstr =3D=20
> vikas@prodbcc: User (vikas@prodbcc)'s password is not correct=20
> for the database server.=20
>=20
> The Java application log file shows following error=20
> [2015-08-20 14:45:39,652] WARN AdviserConnectionPool:179 - Exception=20
> Occured while getting Connection. You may be need to increase the pool.=20
> org.apache.commons.dbcp.SQLNestedException: Cannot create=20
> PoolableConnectionFactory (Incorrect password or user com.informix.asf.=20
> IfxASFRemoteException: vikas@prodbcc is not known on the database=20
> server.)=20
>=20
> With user "vikas" and valid password I am able to login to database=20
server=20
> host and do dbaccess successfully but it does not work with the JDBC=20
string=20
>=20
> We even tried writting a small java connection code program but there=20
too it=20
> fails.=20
> String DbUrl =3D=20
>=20
"jdbc:informix-sqli://200.200.165.165:2000/test:informixserver=3Dprod1;user=
=3Dvikas;password=3Dxxxxxxx;";=20
>=20
> Even with ODBC connectino from my machine to this server with different=20
user=20
> id's including "informix" user does not work and gives the same error=20
"user=20
> not known on database server"=20
>=20
> surprisingly this app when configured to point ot another SDS instance=20
or=20
the=20
> primary instance, the connneciton is successfull.=20
>=20
> Checked all the corresponing /etc/hosts, hosts.equiv and even tried=20
.rhosts=20
> entries but nothing seems to be working=20
> Checked the permissions of oninit file and confirmed that the instance=20
was=20
> started with user "informix" only.=20
> Checked with a 6 character password (less than 8) but did not work.=20
>=20
> Checked out the following IBM links for similar issue but did not help=20
> http://www-01.ibm.com/support/docview.wss?uid=3Dswg21141697=20
> http://www-01.ibm.com/support/docview.wss?uid=3Dswg21177527=20
>=20
> Any more checks or suggesstions can be helpful.=20
>=20
> Regards,=20
> Vikas=20
>=20
>=20
>=20
***************************************************************************=
****=20
> Forum Note: Use "Reply" to post a response in the discussion forum.=20
>=20
***************************************************************************=
****=20
Forum Note: Use "Reply" to post a response in the discussion forum.=20
Forgot to mention that Jonathan Leffler was really helpful in debugging=20
the issue. Thanks Jonathan.
Regards,
Vaibhav S Dantale
IBM Informix CTE Lead
Mobile - +91-9503161335
email- vdantale@in.ibm.com
Twitter - @dantalevs
Blog - http://timeseriesibm.blogspot.in/ (Works better in firefox)
From: Vaibhav S Dantale/India/IBM
To: ids@iiug.org
Date: 08/25/2015 12:48 AM
Subject: Re: RE: Informix Authentication failure with Hp-Un [35642]
The problem is solved. It was interesting problem and hence sharing it=20
with you all:
Vikas has a trusted system setup which doesn't maintain /etc/shadow file.=20
For HP, Informix checks if the system is trusted or not using a function=20
iscomsec(). If it returns 1, its a trusted system and informix skip=20
password validation and if it returns 0, informix checks for /etc/shadow=20
file.
iscomsec determines if the system is a trusted system or not by checking=20
the file, /tcb/files/auth/system/default. If the file exists, the system=20
is a trusted system. If the file does not exist, the system is not a=20
trusted system.
On Vikas's system, the /tcb/files/auth directory had 700 root:sys=20
permission and hence even though /tcb/files/auth/system/default file was=20
present, iscomsec was not able to read and was returning 0.
By changing permission of /tcb/files/auth to 771 root:sys and ensuring=20
permission of /tcb/files/auth/system also is same, the problem is fixed.
To know more about iscomsec -=20
http://docstore.mik.ua/manuals/hp-ux/en/B2355-60130/iscomsec.2.html
Regards,
Vaibhav S Dantale
IBM Informix CTE Lead
Mobile - +91-9503161335
email- vdantale@in.ibm.com
Twitter - @dantalevs
Blog - http://timeseriesibm.blogspot.in/ (Works better in firefox)
From: "VIKAS HIVARKAR" <vikas.hivarkar@gmail.com>
To: ids@iiug.org
Date: 08/24/2015 04:54 PM
Subject: Re: RE: Informix Authentication failure with Hp-Un [35642]
Sent by: ids-bounces@iiug.org
Hi,=20
On the database server when I try to do=20
dbaccess >>=20
CONNECTION: Connect >>=20
SELECT DATABASE SERVER >> sds1=20
USER NAME >> vikas=20
PASSWORD >> xxxxxx=20
951: Incorrect password or user vikas@dbserver is not known on the=20database=20
server=20
And because I have a trust based connection establised for this user I can =
simply enter and query the database by doing "dbaccess sds1" with out any=20
error.=20
I am trying all this with user that is valid (unlocked) on the database=20
server=20
it self.=20
Have raised a PMR with IBM but no help as of now. Kinda weird and=20
troubling a=20
lot.=20
Regards,=20
Vikas=20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=20
>>Hello.=20
>>You didn't mention, but.. what Java driver version are you using ???=20
>>Maybe you are using an old version, that might be facing some bug.=20
>>The latest version is Informix JDBC 4.10.JC5, check it out.=20
>>=20
>>If you are using a recommended/compatible JDBC driver, you should be=20
guided=20
to open a PMR in IBM support.=20
>>=20
>>Hope it helps.=20
>>Regards.=20
>>=20
>>Alexandre Marini=20
>>IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10=20
>>=20
>>IBM Information Management Informix Technical Professional=20
>>=20
>>IBM Certified Developer - Informix Genero=20
>>BRIUG website administrator=20
>>Informix independent consultant=20
> To: ids@iiug.org=20
> From: vikas.hivarkar@gmail.com=20
> Subject: Informix Authentication failure with Hp-Unix [35620]=20
> Date: Fri, 21 Aug 2015 06:41:06 -0400=20
>=20
> IDS 12.10.FC4W1X3 on HP-Unix B.11.31 U ia64 (configured to work in=20
trusted=20
> mode, NO shadowing)=20
>=20
> This issue is pertianing to connection with one of the sds nodes=20
>=20
> I am facing a very weird issue of connectivity with one of the java=20
> application trying to connect to informix database using correct user id =
and=20
> password and still getting the below error in online.log=20
>=20
> 14:45:39 Password Validation for user [vikas] failed!=20
> 14:45:39 Check for password aging/account lock-out.=20
> 14:45:39 listener-thread: err =3D -952: oserr =3D 0: errstr =3D=20
> vikas@prodbcc: User (vikas@prodbcc)'s password is not correct=20
> for the database server.=20
>=20
> The Java application log file shows following error=20
> [2015-08-20 14:45:39,652] WARN AdviserConnectionPool:179 - Exception=20
> Occured while getting Connection. You may be need to increase the pool.=20
> org.apache.commons.dbcp.SQLNestedException: Cannot create=20
> PoolableConnectionFactory (Incorrect password or user com.informix.asf.=20
> IfxASFRemoteException: vikas@prodbcc is not known on the database=20
> server.)=20
>=20
> With user "vikas" and valid password I am able to login to database=20
server=20
> host and do dbaccess successfully but it does not work with the JDBC=20
string=20
>=20
> We even tried writting a small java connection code program but there=20
too it=20
> fails.=20
> String DbUrl =3D=20
>=20
"jdbc:informix-sqli://200.200.165.165:2000/test:informixserver=3Dprod1;user=
=3Dvikas;password=3Dxxxxxxx;";=20
>=20
> Even with ODBC connectino from my machine to this server with different=20
user=20
> id's including "informix" user does not work and gives the same error=20
"user=20
> not known on database server"=20
>=20
> surprisingly this app when configured to point ot another SDS instance=20
or=20
the=20
> primary instance, the connneciton is successfull.=20
>=20
> Checked all the corresponing /etc/hosts, hosts.equiv and even tried=20
.rhosts=20
> entries but nothing seems to be working=20
> Checked the permissions of oninit file and confirmed that the instance=20
was=20
> started with user "informix" only.=20
> Checked with a 6 character password (less than 8) but did not work.=20
>=20
> Checked out the following IBM links for similar issue but did not help=20
> http://www-01.ibm.com/support/docview.wss?uid=3Dswg21141697=20
> http://www-01.ibm.com/support/docview.wss?uid=3Dswg21177527=20
>=20
> Any more checks or suggesstions can be helpful.=20
>=20
> Regards,=20
> Vikas=20
>=20
>=20
>=20
***************************************************************************=
****=20
> Forum Note: Use "Reply" to post a response in the discussion forum.=20
>=20
***************************************************************************=
****=20
Forum Note: Use "Reply" to post a response in the discussion forum.=20
err.... that's why oninit is owned by root and setuid.... or was this a
non-root informix installation?
On Aug 24, 2015 8:31 PM, "Vaibhav S Dantale" <vdantale@in.ibm.com> wrote:
> Forgot to mention that Jonathan Leffler was really helpful in debugging=20
> the issue. Thanks Jonathan.
>
> Regards,
> Vaibhav S Dantale
> IBM Informix CTE Lead
> Mobile - +91-9503161335
> email- vdantale@in.ibm.com
> Twitter - @dantalevs
> Blog - http://timeseriesibm.blogspot.in/ (Works better in firefox)
>
> From: Vaibhav S Dantale/India/IBM
> To: ids@iiug.org
> Date: 08/25/2015 12:48 AM
> Subject: Re: RE: Informix Authentication failure with Hp-Un [35642]
>
> The problem is solved. It was interesting problem and hence sharing it=20
> with you all:
>
> Vikas has a trusted system setup which doesn't maintain /etc/shadow
> file.=20
> For HP, Informix checks if the system is trusted or not using a function=20
> iscomsec(). If it returns 1, its a trusted system and informix skip=20
> password validation and if it returns 0, informix checks for /etc/shadow=20
> file.
>
> iscomsec determines if the system is a trusted system or not by checking=20
> the file, /tcb/files/auth/system/default. If the file exists, the system=20
> is a trusted system. If the file does not exist, the system is not a=20
> trusted system.
>
> On Vikas's system, the /tcb/files/auth directory had 700 root:sys=20
> permission and hence even though /tcb/files/auth/system/default file was=20
> present, iscomsec was not able to read and was returning 0.
>
> By changing permission of /tcb/files/auth to 771 root:sys and ensuring=20
> permission of /tcb/files/auth/system also is same, the problem is fixed.
>
> To know more about iscomsec -=20
> http://docstore.mik.ua/manuals/hp-ux/en/B2355-60130/iscomsec.2.html
>
> Regards,
> Vaibhav S Dantale
> IBM Informix CTE Lead
> Mobile - +91-9503161335
> email- vdantale@in.ibm.com
> Twitter - @dantalevs
> Blog - http://timeseriesibm.blogspot.in/ (Works better in firefox)
>
> From: "VIKAS HIVARKAR" <vikas.hivarkar@gmail.com>
> To: ids@iiug.org
> Date: 08/24/2015 04:54 PM
> Subject: Re: RE: Informix Authentication failure with Hp-Un [35642]
> Sent by: ids-bounces@iiug.org
>
> Hi,=20
>
> On the database server when I try to do=20
> dbaccess >>=20
> CONNECTION: Connect >>=20
> SELECT DATABASE SERVER >> sds1=20
> USER NAME >> vikas=20
> PASSWORD >> xxxxxx=20
>
> 951: Incorrect password or user vikas@dbserver is not known on the=20> database=20
> server=20
>
> And because I have a trust based connection establised for this user I can
> =
>
> simply enter and query the database by doing "dbaccess sds1" with out
> any=20
> error.=20
>
> I am trying all this with user that is valid (unlocked) on the database=20
> server=20
> it self.=20
>
> Have raised a PMR with IBM but no help as of now. Kinda weird and=20
> troubling a=20
> lot.=20
>
> Regards,=20
> Vikas=20
>
>
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
>
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
>
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
>
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
> =3D=3D=3D=3D=3D=3D=3D=20
>
> >>Hello.=20
> >>You didn't mention, but.. what Java driver version are you using ???=20
> >>Maybe you are using an old version, that might be facing some bug.=20
> >>The latest version is Informix JDBC 4.10.JC5, check it out.=20
> >>=20
> >>If you are using a recommended/compatible JDBC driver, you should be=20
> guided=20
> to open a PMR in IBM support.=20
> >>=20
> >>Hope it helps.=20
> >>Regards.=20
> >>=20
> >>Alexandre Marini=20
> >>IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10=20
> >>=20
> >>IBM Information Management Informix Technical Professional=20
> >>=20
> >>IBM Certified Developer - Informix Genero=20
> >>BRIUG website administrator=20
> >>Informix independent consultant=20
>
> > To: ids@iiug.org=20
> > From: vikas.hivarkar@gmail.com=20
> > Subject: Informix Authentication failure with Hp-Unix [35620]=20
> > Date: Fri, 21 Aug 2015 06:41:06 -0400=20
> >=20
> > IDS 12.10.FC4W1X3 on HP-Unix B.11.31 U ia64 (configured to work in=20
> trusted=20
> > mode, NO shadowing)=20
> >=20
> > This issue is pertianing to connection with one of the sds nodes=20
> >=20
> > I am facing a very weird issue of connectivity with one of the java=20
> > application trying to connect to informix database using correct user id
> =
>
> and=20
> > password and still getting the below error in online.log=20
> >=20
> > 14:45:39 Password Validation for user [vikas] failed!=20
> > 14:45:39 Check for password aging/account lock-out.=20
> > 14:45:39 listener-thread: err =3D -952: oserr =3D 0: errstr =3D=20
> > vikas@prodbcc: User (vikas@prodbcc)'s password is not correct=20
> > for the database server.=20
> >=20
> > The Java application log file shows following error=20
> > [2015-08-20 14:45:39,652] WARN AdviserConnectionPool:179 - Exception=20
> > Occured while getting Connection. You may be need to increase the
> pool.=20
> > org.apache.commons.dbcp.SQLNestedException: Cannot create=20
> > PoolableConnectionFactory (Incorrect password or user
> com.informix.asf.=20
> > IfxASFRemoteException: vikas@prodbcc is not known on the database=20
> > server.)=20
> >=20
> > With user "vikas" and valid password I am able to login to database=20
> server=20
> > host and do dbaccess successfully but it does not work with the JDBC=20
> string=20
> >=20
> > We even tried writting a small java connection code program but there=20
> too it=20
> > fails.=20
> > String DbUrl =3D=20
> >=20
> "jdbc:informix-sqli://
> 200.200.165.165:2000/test:informixserver=3Dprod1;user=
> =3Dvikas;password=3Dxxxxxxx;";=20
>
> >=20
> > Even with ODBC connectino from my machine to this server with
> different=20
> user=20
> > id's including "informix" user does not work and gives the same error=20
> "user=20
> > not known on database server"=20
> >=20
> > surprisingly this app when configured to point ot another SDS instance=20
> or=20
> the=20
> > primary instance, the connneciton is successfull.=20
> >=20
> > Checked all the corresponing /etc/hosts, hosts.equiv and even tried=20
> ..rhosts=20
> > entries but nothing seems to be working=20
> > Checked the permissions of oninit file and confirmed that the instance=20
> was=20
> > started with user "informix" only.=20
> > Checked with a 6 character password (less than 8) but did not work.=20
> >=20
> > Checked out the following IBM links for similar issue but did not help=20
> > http://www-01.ibm.com/support/docview.wss?uid=3Dswg21141697=20
> > http://www-01.ibm.com/support/docview.wss?uid=3Dswg21177527=20
> >=20
> > Any more checks or suggesstions can be helpful.=20
> >=20
> > Regards,=20
> > Vikas=20
> >=20@@