469,323 Members | 1,365 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,323 developers. It's quick & easy.

DB2 suddenly become unable to NIS authenticate?

DB2 UDB 7.2 WSE
Fixpak 9
Linux Red Hat 7.3

A very strange thing just happened w/ my DB2 server. I am on Linux and
using NIS - the instance owner is in the servers /etc/passwd file.

Suddenly, DB2 would not authenticate any NIS-based logins, but it
*would* authenticate the local non-NIS instance owner. This was
happening not only w/ local connections on the server, but also
connections across the network (I am using JDBC and db2jstrt daemon)

When I tried to login w/ a NIS login, I got:
SQL1403N The username and/or password supplied is incorrect.
SQLSTATE=08004
Even though I was using a good login and password.

NIS logins have been working just fine for months and months. No
configuration has been changed. Here are the relevant config
settings:

Database manager authentication (AUTHENTICATION) = SERVER
Cataloging allowed without authority (CATALOG_NOAUTH) = NO
Trusted client authentication (TRUST_CLNTAUTH) = CLIENT

I stopped and started NIS on the server, but no help. "ypcat passwd"
output looked correct..

So in desperation I did a db2stop and a db2start and suddenly NIS
logins could be used again...

Bringing the database down around here is a very big deal, so now I
will need to debrief you-know-who on why it happened.

Any ideas? Why would DB2 suddenly become unable to NIS
authenticate?

TIA
allen
Nov 12 '05 #1
2 2981
Allen,

DB2 does not perform the authentication. DB2 throws the user name and
password over the wall to UNIX LOGIN processing and waits for a YES or NO
response. It sounds like you had a temporary glitch between DB2 and the
LOGIN interface and DB2 didn't recover correctly.
<al****@ndr.com> wrote in message
news:40*****************@news.supernews.com...
DB2 UDB 7.2 WSE
Fixpak 9
Linux Red Hat 7.3

A very strange thing just happened w/ my DB2 server. I am on Linux and
using NIS - the instance owner is in the servers /etc/passwd file.

Suddenly, DB2 would not authenticate any NIS-based logins, but it
*would* authenticate the local non-NIS instance owner. This was
happening not only w/ local connections on the server, but also
connections across the network (I am using JDBC and db2jstrt daemon)

When I tried to login w/ a NIS login, I got:
SQL1403N The username and/or password supplied is incorrect.
SQLSTATE=08004
Even though I was using a good login and password.

NIS logins have been working just fine for months and months. No
configuration has been changed. Here are the relevant config
settings:

Database manager authentication (AUTHENTICATION) = SERVER
Cataloging allowed without authority (CATALOG_NOAUTH) = NO
Trusted client authentication (TRUST_CLNTAUTH) = CLIENT

I stopped and started NIS on the server, but no help. "ypcat passwd"
output looked correct..

So in desperation I did a db2stop and a db2start and suddenly NIS
logins could be used again...

Bringing the database down around here is a very big deal, so now I
will need to debrief you-know-who on why it happened.

Any ideas? Why would DB2 suddenly become unable to NIS
authenticate?

TIA
allen

Nov 12 '05 #2
There is some doc about db2 and NIS here.

http://publib.boulder.ibm.com/infoce...help/index.jsp
search : NIS
(returns about 20 links)

see NIS installation considerations and other related links.
<snip>
In environments that include security software, such as NIS or NIS+, there
are some installation considerations.
The DB2 installation scripts will attempt to update things that are under
the control of the security packages,
such as users and groups, and will not be able to do so.
<snip>
etc...
PM
<al****@ndr.com> a écrit dans le message de
news:40*****************@news.supernews.com...
DB2 UDB 7.2 WSE
Fixpak 9
Linux Red Hat 7.3

A very strange thing just happened w/ my DB2 server. I am on Linux and
using NIS - the instance owner is in the servers /etc/passwd file.

Suddenly, DB2 would not authenticate any NIS-based logins, but it
*would* authenticate the local non-NIS instance owner. This was
happening not only w/ local connections on the server, but also
connections across the network (I am using JDBC and db2jstrt daemon)

When I tried to login w/ a NIS login, I got:
SQL1403N The username and/or password supplied is incorrect.
SQLSTATE=08004
Even though I was using a good login and password.

NIS logins have been working just fine for months and months. No
configuration has been changed. Here are the relevant config
settings:

Database manager authentication (AUTHENTICATION) = SERVER
Cataloging allowed without authority (CATALOG_NOAUTH) = NO
Trusted client authentication (TRUST_CLNTAUTH) = CLIENT

I stopped and started NIS on the server, but no help. "ypcat passwd"
output looked correct..

So in desperation I did a db2stop and a db2start and suddenly NIS
logins could be used again...

Bringing the database down around here is a very big deal, so now I
will need to debrief you-know-who on why it happened.

Any ideas? Why would DB2 suddenly become unable to NIS
authenticate?

TIA
allen

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Dean Speir | last post: by
5 posts views Thread by db2sysc | last post: by
2 posts views Thread by Nils Hedström | last post: by
reply views Thread by Nachi | last post: by
3 posts views Thread by =?Utf-8?B?R3JlZw==?= | last post: by
3 posts views Thread by =?Utf-8?B?V2luRGV2?= | last post: by
1 post views Thread by Benedict Verheyen | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by Gurmeet2796 | last post: by
reply views Thread by mdpf | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.