If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > SQL30082N 24 08001 after change sysadm_group!!!! help!!

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-10-09, 13:21
petitof petitof is offline
Registered User
 
Join Date: Apr 2004
Posts: 54
SQL30082N 24 08001 after change sysadm_group!!!! help!!

Hello!
I have a very big problem when I tried to change group permission (sysadm_group) of the instance, that is:

before:
"
SYSADM group name (SYSADM_GROUP) = DB2GRP1
SYSCTRL group name (SYSCTRL_GROUP) =
SYSMAINT group name (SYSMAINT_GROUP) =
SYSMON group name (SYSMON_GROUP) =
"
after:
"
SYSADM group name (SYSADM_GROUP) = DB2SYSADM
SYSCTRL group name (SYSCTRL_GROUP) = DB2SYSCTRL
SYSMAINT group name (SYSMAINT_GROUP) = DB2SYSMAINT
SYSMON group name (SYSMON_GROUP) = DB2SYSMON
"
I write follow statements (as db2inst1 user):
update dbm cfg using sysadm_group db2sysadm
update dbm cfg using sysctrl_group db2sysctrl
update dbm cfg using sysmaint_group db2sysmaint
update dbm cfg using sysmon_group db2sysmon

then I add groups:
groupadd db2sysadm
ecc..
and I lanch in my home (db2inst1):
chown db2inst1.db2sysadm * -R

Now my client don't connect to database and I keep this message error:

SQL30082N Attempt to establish connection failed with security reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001

I really need your help..

Best regards
Fabio
Reply With Quote
  #2 (permalink)  
Old 02-10-09, 14:23
petitof petitof is offline
Registered User
 
Join Date: Apr 2004
Posts: 54
Sorry!
I forgot to specify the environment:

Suse 64-bit, RAM 2GB with kernel parameters:

# Added for 64-bit DB2
kernel.sem=250 256000 32 1024
kernel.msgmni=1024
kernel.shmmax=1610612736
kernel.shmall=400000
kernel.shmmni=4096
#end additions for DB2

and DB2 Udb Enterprise Server 8.2.6 .

Thank you.
Fabio
Reply With Quote
  #3 (permalink)  
Old 02-10-09, 14:46
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
Quote:
Originally Posted by petitof
Sorry!
I forgot to specify the environment:

Suse 64-bit, RAM 2GB with kernel parameters:
What you forgot to specify are the most relevant details:
- what kind of client
- local or remote
- the exact command line when you are trying to connect
Reply With Quote
  #4 (permalink)  
Old 02-10-09, 15:09
petitof petitof is offline
Registered User
 
Join Date: Apr 2004
Posts: 54
Ok, thank you!
I have these parameters in Database Manager Configuration:

"
Database manager authentication (AUTHENTICATION) = SERVER
Cataloging allowed without authority (CATALOG_NOAUTH) = NO
Trust all clients (TRUST_ALLCLNTS) = YES
Trusted client authentication (TRUST_CLNTAUTH) = CLIENT
Bypass federated authentication (FED_NOAUTH) = NO
"

and I can't connect with a remote client, also after resetting parameters (SYSADM_GROUP, SYSCTRL_GROUP, SYSMAINT_GROUP and SYSMON_GROUP) and privileges in the home path of the user instance with:
sudo chown db2inst1.db2grp1 * -R

I suspect that the problem is the previous command "chown db2inst1.db2sysadm * -R" ...can privileges break the layer between DB2 and OS authentication??

thank you very much!
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On