| Author |
Recover/Reset admin password after initial install
|
|
| Gennadiy Civil 2004-10-20, 5:51 pm |
| 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
>
| |
| L D Jones 2004-10-21, 2:49 am |
| 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.
| |
| Gennadiy Civil 2004-10-21, 7:48 am |
| 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.
| |
| L D Jones 2004-10-22, 5:55 pm |
| > "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
| |
|
| 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
|
|
|
|