473,385 Members | 1,492 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,385 software developers and data experts.

DB2 authentication : how it works ?

Hello,
I had a strange situation with a DB2 access.
The db2 is set with "server authentication" type.
I don't know the reason but I was in front of the following situation
:
The user ID used to connect to the DB2 on a Solaris have a well
defined password.
If I try to connect to the DB as this user and with the "good"
password, the access is refused.
Same case if I give a wrong password. In this case it is what I
expected.
The username/password is 100% correct. I can log in on to the Unix
server with.
But what it more strange is if I give a "blank" password, just type
return to the password prompt, I'm connected to the DB.

Of course it is a special situation.
I can not find the reason of this comportment.

I re-install all the DB and now it is correct.
But what can be wrong ?

Thank a lot for any advices
Nov 12 '05 #1
1 4477
Hi,
I think you have lost the SUID and GUID bits on the modules in
.../sqllib/adm.
Some of them are responsible for the authentification.

"Kona" <ko*******@yahoo.fr> schrieb im Newsbeitrag
news:a1**************************@posting.google.c om...
Hello,
I had a strange situation with a DB2 access.
The db2 is set with "server authentication" type.
I don't know the reason but I was in front of the following situation
:
The user ID used to connect to the DB2 on a Solaris have a well
defined password.
If I try to connect to the DB as this user and with the "good"
password, the access is refused.
Same case if I give a wrong password. In this case it is what I
expected.
The username/password is 100% correct. I can log in on to the Unix
server with.
But what it more strange is if I give a "blank" password, just type
return to the password prompt, I'm connected to the DB.

Of course it is a special situation.
I can not find the reason of this comportment.

I re-install all the DB and now it is correct.
But what can be wrong ?

Thank a lot for any advices

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Michael Foord | last post by:
#!/usr/bin/python -u # 15-09-04 # v1.0.0 # auth_example.py # A simple script manually demonstrating basic authentication. # Copyright Michael Foord # Free to use, modify and relicense. #...
6
by: Billy Jacobs | last post by:
I have a website which has both secure and non-secure pages. I want to uses forms authentication. How do I accomplish this? Originally I had my web.config file in the root with Forms...
4
by: David Moore | last post by:
Hello I am using the System.DirectoryServices namespace classes to access Active Directory. We connect using the LDAP://DOMAIN method. The code works on local dev boxes, and in staging, but...
4
by: Paul M | last post by:
hi there, i've got a website i created, that i've put onto my test server on the web. I have a login page, that when the user comes to it, it first pops up a windows authentication dialog box,...
0
by: Simon Smith | last post by:
Hi I have a small ASP.NET application that is running on a dedicated web server. This application is attempting to make a remote DCOM call to another server in order to log into another system as...
3
by: Patrick Fogarty | last post by:
I am programming what is to be a web service client that will use an HTTP-POST to request and retrieve data. The remote server (written in java for what it's worth) requires basic authentication...
3
by: KNC | last post by:
Hi all, I'm developing a website and deployed on webserver, it always display an authentication dialog that user must login with valid Windows user. Would anyone helps to instruct how to...
2
by: Frank Swarbrick | last post by:
I am trying to understand "client authentication" works. My environment is DB2/UDB LUW 8.2 on zSeries SLES9 as the database server and DB2 for VSE 7.4 as the client. We currently have DB2/LUW set...
16
by: rogerjames1 | last post by:
How would I go about protecting a whole directory, e.g. http://www.example.com/members/ and all sub-directories with login protection? I wouldn't like to put a .php script in each directory and...
4
by: =?Utf-8?B?R3V1czEyMw==?= | last post by:
Hi, I created a web site on a remote server. To logon the user must enter a user id and password. The site is uses Forms Authentication. The web config file looks as follows: ...
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...
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...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.