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

DB2 suddenly become unable to NIS authenticate?

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.