Hello:

We installed WSP on one of the machines and after the lengthy

installation

process lost the admin user name and password.

Is there a way to reset/recover it without reinstall?


Thanks


>

[ Post a follow-up to this message ]

Gennadiy Civil wrote:
> Hello:
>
> We installed WSP on one of the machines and after the lengthy
>
> installation
>
> process lost the admin user name and password.
>
> Is there a way to reset/recover it without reinstall?

Add a user whose password you know. Update the password of the admin
user to the same value of the jus-added user's password. I don't have
the SQL at the moment and have only done it on Cloudscape but it ought
to work on other dbs.

[ Post a follow-up to this message ]

Thank you, I have been trying to find where in the DB the password is stored
with no luck.

I am using Cloudscape as well - would you remember what table it was in?

Thanks
Gennadiy


"L D Jones" <345623@yahoo.de> wrote in message
news:cl7arq$65jm$1@news.boulder.ibm.com...
> Gennadiy Civil wrote: 
>
> Add a user whose password you know. Update the password of the admin user
> to the same value of the jus-added user's password. I don't have the SQL
> at the moment and have only done it on Cloudscape but it ought to work on
> other dbs.

[ Post a follow-up to this message ]

> "L D Jones" <345623@yahoo.de> wrote in message
> news:cl7arq$65jm$1@news.boulder.ibm.com...
> 
>
>
>

Gennadiy Civil wrote:

> Thank you, I have been trying to find where in the DB the password is
stored
> with no luck.
>
> I am using Cloudscape as well - would you remember what table it was in?
>
> Thanks
> Gennadiy
>
>

My notes say it's something like this

update wmmuserreg set logonpassword = (select logonpassword from
wmmuserreg where user_id = 1554), salt = (select salt from wmmuserreg
where user_id = 1554) where user_id = 1313

1313 is admin user
1554 is the user whose password is known (unless I've got them backward)

I cannot guarantee this will work

[ Post a follow-up to this message ]

This should work for DB only install. If you alread configured LDAP,
wmmuserreg is not used. Password should be changed in LDAP. Depending on how
many different user IDs were used in security configuration, there are
potentially multiple files involved.

"L D Jones" <345623@yahoo.de> wrote in message
news:clbkn3$6q0e$1@news.boulder.ibm.com... 
user[vbcol=seagreen] 
on[vbcol=seagreen] 
>
> Gennadiy Civil wrote:
> 
> stored 
in?[vbcol=seagreen] 
>
> My notes say it's something like this
>
> update wmmuserreg set logonpassword = (select logonpassword from
> wmmuserreg where user_id = 1554), salt = (select salt from wmmuserreg
> where user_id = 1554) where user_id = 1313
>
> 1313 is admin user
> 1554 is the user whose password is known (unless I've got them backward)
>
> I cannot guarantee this will work

[ Post a follow-up to this message ]