[Experience Summary] solve the problem of user authentication in DB2 9.5.2 (sql30082n)

DB2 express-C v9.5.2 is installed on ubutun 8.10 64bit server, and the Mars server program is transplanted, but the database cannot be connected. The error message is as follows:

Error:

Sql30082n Security Processing failed with reason "15" ("processing failure"). sqlstate = 08001

 

Having spent half an hour, I found that I had logged on with the instance owner db2inst1. When I joined the database, I set the password and username to be empty and the connection was successful. That's really strange.

 

The answer (http://www.ibm.com/developerworks/forums/thread.jspa? Messageid = 14174958)

 

Solution proposed by tamers:

I had the same problem on Ubuntu v8.10. I replaced the following line in/etc/PAM. d/common-Password passwordsuccess = 1 default = ignorepam_unix.so obscure sha512with the line below:
Passwordsuccess = 1 default = ignorepam_unix.so obscure MD5 then, reset the passwords of the DB2 users using "passwd" command. And the problem solved.
Thanks for the clue abve.

 

Step 1 set the following line in the/etc/PAM. d/common-password file:

Password success = 1 default = ignore pam_unix.so obscure sha512

Replace:

Password success = 1 default = ignore pam_unix.so obscure MD5

Step 2

Run the passwd command in shell to change the password.

OK!

Why do we need to do this:

I am referring to the one the operating system is using to compute the hash for the password.
It is very likely producing a hash that is bigger than what DB2 supports and that is why you are seeing the error.

The operating system uses different hash algorithms for passwords. It is likely that the length of the hash password string exceeds the maximum length supported by DB2.

Therefore, the suggestions for _ Mihai _ are:

You are likely using sha512, change it to sha256 or MD5, it shoshould work fine.

Change the hash algorithm of sha512 to sha256 or MD5.