I have the subject system set up, and can connect to it with several
userids. I can login to it (ssh) with a new userid I created, but when I
try to use those credentials to connect to db2, I get password invalid.
I have checked the groups of the new userid and made its password the
same as one of the successful userids with the same results. This one
baffles me. I'm obviously missing something very elementary, but I can't
figure out what. Any ideas, rtfm references, etc. greatly appreciated. 11 2048
Bob Stearns wrote: I have the subject system set up, and can connect to it with several userids. I can login to it (ssh) with a new userid I created, but when I try to use those credentials to connect to db2, I get password invalid. I have checked the groups of the new userid and made its password the same as one of the successful userids with the same results. This one baffles me. I'm obviously missing something very elementary, but I can't figure out what. Any ideas, rtfm references, etc. greatly appreciated.
Q1: Does the ID have connect privileges? I think that's in SYSCAT.DBAUTH
Q2: How is authentication set up? Server, Client, .. ? I think that's
part of the DBM CONFIG.
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
IOD Conference http://www.ibm.com/software/data/ond...ness/conf2006/
Serge Rielau wrote: Bob Stearns wrote:
I have the subject system set up, and can connect to it with several userids. I can login to it (ssh) with a new userid I created, but when I try to use those credentials to connect to db2, I get password invalid. I have checked the groups of the new userid and made its password the same as one of the successful userids with the same results. This one baffles me. I'm obviously missing something very elementary, but I can't figure out what. Any ideas, rtfm references, etc. greatly appreciated.
Q1: Does the ID have connect privileges? I think that's in SYSCAT.DBAUTH Q2: How is authentication set up? Server, Client, .. ? I think that's part of the DBM CONFIG.
Cheers Serge
1 I checked, an is has connect authority
2 Server, I think. Where do I find DBM CONFIG to verify
3 db2diag gives check password failed with rc = -2146500502. That is
800F006A in 32 bit hex.
I'm not sure how you are trying to connect but here is what I would to
to troubleshoot this thing.
1 - Ssh to the db2 server using the userid (not with another id and
su-ing to the user - the user account may be set to change the password
on next login if you just created it that way), load the database
db2profile for the user and connect from there, which rules out the
database authorization
2 - From the client machine catalog the node and the database (if you
haven't done so) - use command line instead of the control center, it's
faster and better to troubleshoot.
3 - Test the connection using the command line from the client machine
with a userid you know it works
4 - Test using the new userid using the command line
To check the authentication type (doesn't sound like this is the
problem because you said you were able to connect using another
user....)
$ db2 get dbm cfg | grep AUTHENTICATION
Database manager authentication (AUTHENTICATION) = SERVER
To check if your user has connect privileges (just in case)
$ db2 "select grantee from syscat.dbauth where connectauth='Y'"
Lastly either change the password to something extremely easy to type,
or start over creating a new user.
If still doesn't work go have a beer, take some time off and get back
to it later....
Leo wrote: I'm not sure how you are trying to connect but here is what I would to to troubleshoot this thing.
1 - Ssh to the db2 server using the userid (not with another id and su-ing to the user - the user account may be set to change the password on next login if you just created it that way), load the database db2profile for the user and connect from there, which rules out the database authorization
2 - From the client machine catalog the node and the database (if you haven't done so) - use command line instead of the control center, it's faster and better to troubleshoot.
3 - Test the connection using the command line from the client machine with a userid you know it works
4 - Test using the new userid using the command line
To check the authentication type (doesn't sound like this is the problem because you said you were able to connect using another user....)
$ db2 get dbm cfg | grep AUTHENTICATION Database manager authentication (AUTHENTICATION) = SERVER
To check if your user has connect privileges (just in case)
$ db2 "select grantee from syscat.dbauth where connectauth='Y'"
Lastly either change the password to something extremely easy to type, or start over creating a new user.
If still doesn't work go have a beer, take some time off and get back to it later....
1 I did and works.
2 It is.
3 I'm using a Windows machine and I've never user the command line to
access db2 (can you believe it :-), so I need a pointer for this.
4 Likewise
5 Authentication is server
6 the userid was shown by the select
7 I tried making it the same as mine, which I type many time a day.
All to no avail.
First you catalog the node
db2 "catalog tcpip node <nodename> remote <server hostname> server
<port>"
Then you catalog the database on that node
db2 "catalog database <dbname> at node <nodename>"
Check your catalogs:
db2 "list node directory"
db2 "list db directory"
Then you connect...
db2 connect to <dbname>
Leo wrote: First you catalog the node
db2 "catalog tcpip node <nodename> remote <server hostname> server <port>"
Then you catalog the database on that node
db2 "catalog database <dbname> at node <nodename>"
Check your catalogs:
db2 "list node directory"
db2 "list db directory"
Then you connect...
db2 connect to <dbname>
I didn't even know I had a db2 executable on my windows box. However it
is not happy: DB21061E Command line environment not initialized. What now?
You have to initialize the profile.
The easy painless way. Start -> Programs -> IBM DB2 -> Command Line
Tools -> Command Line Processor
Just remember to remove the quotes from the commands and the starting
"db2" keyword, since you are in the clp already.
Bob Stearns wrote: Leo wrote:
First you catalog the node
db2 "catalog tcpip node <nodename> remote <server hostname> server <port>"
Then you catalog the database on that node
db2 "catalog database <dbname> at node <nodename>"
Check your catalogs:
db2 "list node directory"
db2 "list db directory"
Then you connect...
db2 connect to <dbname> I didn't even know I had a db2 executable on my windows box. However it is not happy: DB21061E Command line environment not initialized. What now?
type: db2cmd
It will open a new shell with the environment.
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
IOD Conference http://www.ibm.com/software/data/ond...ness/conf2006/
Serge Rielau wrote: Bob Stearns wrote:
Leo wrote:
First you catalog the node
db2 "catalog tcpip node <nodename> remote <server hostname> server <port>"
Then you catalog the database on that node
db2 "catalog database <dbname> at node <nodename>"
Check your catalogs:
db2 "list node directory"
db2 "list db directory"
Then you connect...
db2 connect to <dbname> I didn't even know I had a db2 executable on my windows box. However it is not happy: DB21061E Command line environment not initialized. What now?
type: db2cmd It will open a new shell with the environment.
Cheers Serge
I uncataloged until there was nothing, then cataloged my server/database.
I then tried to connect with: connect to animals using U00001 using
pwd00001. It failed with "USERNAME AND/OR PASSWORD INVALID". I
immediately tried ssh with those credentials and they worked. I then
tried db2 with another userid/passwd and got in with no problem.
Check if you have '@' or '!' in your password.
I had the same problem and removing the ! (bang) fixed it
Bob Stearns wrote: I have the subject system set up, and can connect to it with several userids. I can login to it (ssh) with a new userid I created, but when I try to use those credentials to connect to db2, I get password invalid. I have checked the groups of the new userid and made its password the same as one of the successful userids with the same results. This one baffles me. I'm obviously missing something very elementary, but I can't figure out what. Any ideas, rtfm references, etc. greatly appreciated.
MY wrote: Check if you have '@' or '!' in your password. I had the same problem and removing the ! (bang) fixed it
Bob Stearns wrote:
I have the subject system set up, and can connect to it with several userids. I can login to it (ssh) with a new userid I created, but when I try to use those credentials to connect to db2, I get password invalid. I have checked the groups of the new userid and made its password the same as one of the successful userids with the same results. This one baffles me. I'm obviously missing something very elementary, but I can't figure out what. Any ideas, rtfm references, etc. greatly appreciated.
No. All alphanumeric. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Google Mike |
last post by:
After a lot of thought and research, and playing with FreeTDS and
InlineTDS, as well as various ODBC connections, I have determined that
the fastest and cheapest way to get up and going with PHP on...
|
by: Wayne Happ |
last post by:
I'm a new Oracle user.
I've installed Oracle 9i on a Linux RedHat machine V9.0 and it's running.
I took a Windows XP machine and installed the Oracle client on it along with
PL/SQL developer...
|
by: Wayne Happ |
last post by:
I have Oracle 9 running on a Linux RedHat Box V9.0.
But I'm having trouble connecting from a windows machine via PL/SQL
Develover. When I startup the application the instance name appears but...
|
by: Dan |
last post by:
Hi,
I'm planning to develop a small intranet to provide our organization
with documents online. I've decided to do this using jsp/servlets
using a tomcat server. For an operating system, I...
|
by: Maurice LING |
last post by:
Hi,
I've been using FB1.5 and access the database using Kinterbasdb +
Python. My connection is established using kinterbasdb.connect() method
and the parameters host, dns, database, user,...
|
by: kamilla |
last post by:
I have a mysql 3.5 server installed on a suse linux 8.1, with address 10.0.0.100.
Now I want to access that db from a W2K pc, address 10.0.0.200.
I am able to ping 10.0.0.100, but I cannot connect...
|
by: Robert Stearns |
last post by:
I have a persistent but not consistent error occurring in db2 / php
under apache running on two different servers. I rebuilt the database
from the ground up, starting with creates and sequential...
|
by: mm |
last post by:
I have several korn shell scripts I use with a MySQL database on the
same server (Solaris). I am moving to a Linux environment where the
MySQL database is on another server. I would like to...
|
by: mairhtin o'feannag |
last post by:
Hello,
I'm having problems connecting to my new v9 db box. The pertinent
information is below:
DB2_db2inst1 60000/tcp
DB2_db2inst1_1 60001/tcp
DB2_db2inst1_2 60002/tcp
DB2_db2inst1_END...
|
by: malooga |
last post by:
Hello,
I'm having a problem connecting to DB2 on a remote iSeries host from a Linux server, both of which reside on my company's internal network. I'm using the IBM Linux Client V9.1. When I try...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
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...
|
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...
|
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,...
| |