473,322 Members | 1,493 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

DB2 auth problem

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
1 3047
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: jsWalter | last post by:
I have an extension Class to Auth and I'm looking for some folks to hammer on it a bit and give feed back. Class: AuthUser - add user (well, Auth does that now, so its gone) - remove user...
3
by: Dan Stromberg | last post by:
If I wanted to write a python script that performs basic auth, gets a cookie, and then does an http POST using the cookie for authentication, what would be the best python API to write to? Does...
0
by: Alex Hunsley | last post by:
I've recently started integrating PHP Auth (http://php.rufy.com/) into my PHP application. I've had a few problem with it though: I've fixed two bugs, one of which was quite glaring - it basically...
0
by: Ciaran McAuliffe | last post by:
Hey, I have a bit of a tricky problem, here is a quick overview. I have a website which connects to a webservice, this web service is a front for access to the Reporting Services Web Service, the...
4
by: 23s | last post by:
I had this problem in the past, after a server reformat it went away, and now after another server reformat it's back again - no clue what's doing it. Here's the flow: Website root is public, no...
10
by: Henk van Lingen | last post by:
Hi, docs say (19.2.1): When trust authentication is specified, PostgreSQL assumes that anyone who can connect to the server is authorized to access the database as whatever database user he...
3
by: Thomas.Firnschrott | last post by:
i have a problem concerning a php script i worte some time ago. It is a rather simple thing. On a Site you login via a html form which points to a php that checks the username and password, and...
0
by: kevin bailey | last post by:
I have a framework working where I have multiple pages each checking the authentication status. Unauthorised users are redirected to a login page - otherwise the requested page is shown. ...
1
by: kevin bailey | last post by:
I have used the PEAR Auth package to successfully set up authentication. <code> // Details of where the authentication details are stored. $options = array( 'dsn'...
3
by: hakan | last post by:
I've started playing with the Auth module, and I have a quick question before I go any deeper. Is it possible to embedd the Auth login form in an HTML page? I would like to put a login form in a...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.