By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,236 Members | 1,449 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,236 IT Pros & Developers. It's quick & easy.

DB2 auth problem

P: n/a
Hiya.

I'm running DB28.2 on a X86_64 SuSE machine, and when I try to login on
the database as the instance user, I get the next entry in db2diag:

2006-10-02-10.17.15.746251+120 I1246607E262 LEVEL: Severe
PID : 6019 TID : 47922449246592
FUNCTION: DB2 Common, Security, Users and Groups, secLogMessage, probe:20
DATA #1 : String, 44 bytes
check password failed with rc = -2146500507

The polite notice is that my username/password is incorrect.
I'm not sure what's going wrong, a local login is no problem, I'm the
instance user there aswell, but as soon as I try to do a remote login
with authentication it does not get accepted. I suspect the password is
not checked properly. Does DB2LUW use PAM auth?
The normal rc for wrong password would end in 02, not in 07.
So anyone any idea?

ty.

-R-
Oct 2 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
What OS are you logging in from? What mechanism are you using to connect
to DB2 (CLI, ODBC, JDBC type n)? What was specified for the
authorization parameter for the database and client? All of these are
areas that could effect authorization results.

If you can log in locally, then authorization is working normally. I'd
suspect that the userid and/or password is being folded to upper case
before being transmitted to DB2. Verify this by setting up a userid that
is all caps with an all caps password. If that one works remotely, you
can try entering parts of it in lower case and determine what is happening.

Phil Sherman
Jurgen Haan wrote:
Hiya.

I'm running DB28.2 on a X86_64 SuSE machine, and when I try to login on
the database as the instance user, I get the next entry in db2diag:

2006-10-02-10.17.15.746251+120 I1246607E262 LEVEL: Severe
PID : 6019 TID : 47922449246592
FUNCTION: DB2 Common, Security, Users and Groups, secLogMessage, probe:20
DATA #1 : String, 44 bytes
check password failed with rc = -2146500507

The polite notice is that my username/password is incorrect.
I'm not sure what's going wrong, a local login is no problem, I'm the
instance user there aswell, but as soon as I try to do a remote login
with authentication it does not get accepted. I suspect the password is
not checked properly. Does DB2LUW use PAM auth?
The normal rc for wrong password would end in 02, not in 07.
So anyone any idea?

ty.

-R-
Oct 4 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.