control/superdba password recovery

[Former Member]

Hi All

we are running ECC6.0 on MAXdb 7.6. Our basis guy has left. now we do not have password of user control/superdba.

Any body can guide how we can recover the passwords. we do not have any user id/password information of maxdb.

Thanks in advance.

Regards

Kapur

[lbreddemann · Accepted solution]

>

> Hi All

>

> we are running ECC6.0 on MAXdb 7.6. Our basis guy has left. now we do not have password of user control/superdba.

> Any body can guide how we can recover the passwords. we do not have any user id/password information of maxdb.

> Thanks in advance.

As you're a SAP customer, I'd suggest to run

xuser list

to check whether the XUSER entries have been maintained correctly.

If they are maintained, just logon via XUSER key 'c' and 'w' to change the passwords for CONTROL and SUPERDBA.

regards,

Lars

[Former Member · Accepted solution]

Hi lars

we have performed following steps

1) C:\Documents and Settings\e53adm>xuser

-

---

XUSER Entry 1

-

---

Key :DEFAULT

Username :SAPE53

UsernameUCS2:S.A.P.E.5.3. . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :E53

Nodename :d6dusap

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

-

---

XUSER Entry 2

-

---

Key :c

Username :CONTROL

UsernameUCS2:C.O.N.T.R.O.L. . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :E53

Nodename :d6dusap

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

-

---

XUSER Entry 3

-

---

Key :c_J2EE

Username :CONTROL

UsernameUCS2:C.O.N.T.R.O.L. . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :E53

Nodename :d6dusap

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

-

---

XUSER Entry 4

-

---

Key :w

Username :SUPERDBA

UsernameUCS2:S.U.P.E.R.D.B.A. . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :E53

Nodename :d6dusap

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

-

---

XUSER Entry 5

-

---

Key :control

Username :CONTROL

UsernameUCS2:C.O.N.T.R.O.L. . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :E53

Nodename :d6dusap

Sqlmode :<unspecified>

Cachelimit :-1

Timeout :-1

Isolation :-1

Charset :<unspecified>

2) C:\Documents and Settings\e53adm>xuser -c c

FATAL: Open xuser entry file failed: could not get logon USER name [1332]

3) xuser -d E53 -n hostname -U control -u control,control set

then updated the xuser file also

xuser set -U e53adm -d E53 -u control,control

still we are unable to change the password. can u please guide us what we need to do.

Regards

kapur

[lbreddemann · Accepted solution]

>

> Hi lars

>

> we have performed following steps

>

> 1) C:\Documents and Settings\e53adm>xuser

> -

---

> XUSER Entry 1

> -

---

> Key :DEFAULT

> XUSER Entry 2

> -

---

> Key :c

> Username :CONTROL

> XUSER Entry 3

> -

---

> Key :c_J2EE

> Username :CONTROL

> UsernameUCS2:C.O.N.T.R.O.L. . . . . . .

> XUSER Entry 4

> -

---

> Key :w

> Username :SUPERDBA

> XUSER Entry 5

> -

---

> Key :control

> Username :CONTR

> 2) C:\Documents and Settings\e53adm>xuser -c c

> FATAL: Open xuser entry file failed: could not get logon USER name [1332]

>

> 3) xuser -d E53 -n hostname -U control -u control,control set

> then updated the xuser file also

> xuser set -U e53adm -d E53 -u control,control

>

> still we are unable to change the password. can u please guide us what we need to do.

Oh, come on!

What did I wrote before?

You should use the XUSER data to logon to the DBMCLI and change the passwords then.

E.g.

dbmcli -U c

or 

dbmcli -U c -USQL w

What's so difficult about that???

Maybe it's time to re-read the documentation about XUSER...

regards,

Lars

[Former Member · Accepted solution]

Hi lars

i have already tried this

C:\Documents and Settings\e53adm>dbmcli -U c

Error! Connection failed to node d6dusap for database E53:

-24950,ERR_USRFAIL: User authorization failed

C:\Documents and Settings\e53adm>dbmcli -U c E53 w

Error! Connection failed to node d6dusap for database E53:

-24950,ERR_USRFAIL: User authorization failed

Regards

Sumeet kapur

[Former Member · Accepted solution]

C:\Documents and Settings\e53adm>dbmcli -U c -U E53 c

Error! XUser not found!

C:\Documents and Settings\e53adm>dbmcli -U c -U E53 c_J2EE

Error! XUser not found!

C:\Documents and Settings\e53adm>dbmcli -U c -U E53 control

[lbreddemann · Accepted solution]

>

> C:\Documents and Settings\e53adm>dbmcli -U c -U E53 c
> Error! XUser not found!
> 
> C:\Documents and Settings\e53adm>dbmcli -U c -U E53 c_J2EE
> Error! XUser not found!
> 
> C:\Documents and Settings\e53adm>dbmcli -U c -U E53 control

Sorry, but these are nonsense commands!

You specify one dbm-user-XUSER-key with the -U switch.

regards,

Lars

[lbreddemann · Accepted solution]

> i have already tried this

>

> C:\Documents and Settings\e53adm>dbmcli -U c

> Error! Connection failed to node d6dusap for database E53:

> -24950,ERR_USRFAIL: User authorization failed

Well, that means:

The XUSER entries are not correct (anymore). Somebody changed the control password without changing the XUSER entry as well.

So, time to tryout the other entries as well!

>

> C:\Documents and Settings\e53adm>dbmcli -U c E53 w

> Error! Connection failed to node d6dusap for database E53:

> -24950,ERR_USRFAIL: User authorization failed

Do you actually know the DBMCLI command line syntax?

The above is again just nonsense...

Try

dbmcli -U w

instead!

regards,

Lars

[Former Member · Accepted solution]

Hi lars

as suggested by you

C:\Documents and Settings\e53adm>dbmcli -U w

Error! Connection failed to node d6dusap for database E53:

-24950,ERR_USRFAIL: User authorization failed

regards

kapur

[Former Member · Accepted solution]

Hi Kapur,

Have you resolved the issue , we are stucked with same issue ,

Could you please share the solution if you found .

Regards