The username or password supplied is incorrect

Stephen Childress

unread,

Jan 2, 2002, 9:48:39 PM1/2/02

to

I've installed DB2 Personal Edition on my Red Hat Linux 7.1 system. I can
access the sample database from the local machine provided I'm logged on as
db2inst1. The trouble is that when I try to connect using the syntax

db2 connect to sample user db2inst1 using password

I get the following message:

SQL1403N The username and/or password supplied is incorrect.
SQLSTATE=08004

I get this even though I know password is right because I used it to log in
as user db2inst1. I get the same message whether connecting from a
networked PC or from the local machine. Is there somewhere I can look to
see a log of why the user/password is being rejected? Thanks for any help.

Steve Childress

rl_cotterill

unread,

Jan 3, 2002, 7:54:46 AM1/3/02

to

Stephen,
When connecting remotely this can happen if you have 'authentication
client' defined in the config file but not sure why you get it when all done
locally.

I have Db2 on linux installed (on another machine - I will try tomorrow -
getting a bit late here)

Richard

Wallendroad

unread,

Jan 3, 2002, 8:38:44 AM1/3/02

to

This has happened once for me on Solaris. I stopped the instance and did a
'db2iupdt' and started the instance and everything was OK again.

HTH

susa...@starhawk.torolab.ibm.com

unread,

Jan 3, 2002, 10:45:21 AM1/3/02

to

In article <a10gp3$it0$1...@bob.news.rcn.net>,

Check the ownership and permissions on ~/sqllib/security/db2ckpw for
db2inst1. They should be:

-rwsr-s--x 1 root build 15950 Jan 2 15:35 db2ckpw

(the "build" should be your default group.) If they are not correct,
do the following as root:

chown root db2ckpw
chmod ug+s db2ckpw

WW
--
Susan Williams
Technical Lead, DB2 on Linux
susa...@vnet.ibm.com

Stephen Childress

unread,

Jan 6, 2002, 10:09:55 PM1/6/02

to

<susa...@starhawk.torolab.ibm.com> wrote in message
news:a11uah$ftq$1...@starhawk.torolab.ibm.com...

> Check the ownership and permissions on ~/sqllib/security/db2ckpw for
> db2inst1. They should be:
>
> -rwsr-s--x 1 root build 15950 Jan 2 15:35 db2ckpw
>
> (the "build" should be your default group.) If they are not correct,
> do the following as root:
>
> chown root db2ckpw
> chmod ug+s db2ckpw

Thank you for the suggestion. I changed the permissions to the following
(it lacked the 'w' for owner and the 's' for group) :
$ ls -l db2ckpw
-rwsr-s--x 1 root db2iadm1 16053 Jan 6 20:49 db2ckpw

I also tried Wallendroad's suggestion of using db2iupdt, but all to no
avail. Here is what I get when logged on as user db2inst1:

$ db2 "connect to sample user db2inst1 using ibmdb2"

SQL1403N The username and/or password supplied is incorrect.
SQLSTATE=08004

The authentication is set to Server. I have tried setting it to
Server_Encrypt, but get the same result. I reinstalled DB2 using all the
default settings.

Any further help would be appreciated, since I am hoping to do most of my
programming on a remote computer, so I need to be able to connect.

Stephen Childress

unread,

Jan 6, 2002, 11:10:07 PM1/6/02

to

I've found the solution to the problem. The /home partition was mounted
nosuid, so changing the permissions on the db2ckpw file didn't do anything.
I remounted with suid enabled and now everything works fine! Thank you all
for all of your help.

Steve C.

<susa...@starhawk.torolab.ibm.com> wrote in message
news:a11uah$ftq$1...@starhawk.torolab.ibm.com...