473,698 Members | 2,491 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

Similar topics

2
6400
by: Carlos G Benevides | last post by:
I have a ASP.Net web application that has two assemblies that run under com+. Under Windows 2000 the two assemblies are added to com+ automatically when instantiated from the web site. For this to happen we had to change the context in which asp.net runs from machine to SYSTEM by modifying the machine.config file. Under Windows 2003 no matter how asp.net is set to run as either machine or system. I get the following error: ...
8
3103
by: Dean Speir | last post by:
Hi... I've been referred to this Newsgroup by the W3C Markup Validator FAQ. I've been happily using this Validator <http://validator.w3.org> for the past 18 months with great success, but suddenly I cannot get it to "read" my HTML documents by the "Validate by File Upload" method. It keeps giving me the following message: Sorry, I am unable to validate this document
5
3914
by: db2sysc | last post by:
All: This is becoming a big problem for us. Whenever we are using control center it asks for the userid/passwd and when we provide the admin userid/passwd we get a error "Administrative Server failed to authenticate SQL22201N with reason code 6." We are unable to use the GUI.. Any help???? The database in on Windows
0
4048
by: Jim M | last post by:
For about a year and a half now I have been working in Access 2002 at home and converting to Access 2000 for work (I need both versions). I made a few changes to forms and queries then converted to Access 2000 a (as I had done many times before). After this last conversion I tried to open the database in Access 2000 and got the following error when I tried to open the Access 2000 database from Access 2000. "Microsoft Access was unable to...
2
4152
by: Nils Hedström | last post by:
Today my stateserver (running at the same computer at the web-server) suddenly stopped responding (after 10 days working perfectly). I did not see any entry in the eventlog indicating that the service stopped responding. This is the entry in web.config --- <sessionState mode="StateServer" stateConnectionString="tcpip=localhost:42424" cookieless="false" timeout="20"/>
0
2007
by: Nachi | last post by:
I have installed SQL Server 2000 with VS 2005 - did not install SqlExpress\Sql 2005. I have a remote Sql Server Instance locally. The normal application connectes to this Sql Server. When I run Asp.Net Configuration from VS 2005 it gives this error. I have removed 'LocalSqlServer' in machine.Config and added in web.config as following.
3
1123
by: =?Utf-8?B?R3JlZw==?= | last post by:
The opening movie is suddenly blurry in Rise of Nations. I think I've either accidently deleted a Windows System filter or one or more video filters has become corrupted. I've checked and I suddenly cannot see "avi" or "mpg" video files either - in Nero. But WMP still plays these fine. What's up?
3
2341
by: =?Utf-8?B?V2luRGV2?= | last post by:
I have a weird one. My users will be on the system and suddenly get logged out. I have forms authentication turned on with a 1200 minute logout (I raised it that high to test this out.) Session timeout is also 1200 minutes. It's almost acting as if its happening when IIS is cycling memory because it get's to be to much memory. (I've been working with Microsoft on this problem and they essentially say that have the system chew up memory is...
1
5696
by: Benedict Verheyen | last post by:
Hi, i get an "Unable to relay for" when trying to send an email from within my network to an email address not on my domain. I don't understand why it says "relaying" as i'm sending from an internal domain user to an external user. Email server is exchange 2003 See this trace
0
9161
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9029
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8897
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8867
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7732
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
4370
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4619
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3050
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2332
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.