A bit of an odd one here... We recently got supplied an Umbraco databse to restore but it did not contain any users in the users table, including the main "admin" user. As you can understand, this casuses some difficulties.
We tried to add the admin user back in the users table but this doesn't work. Is there a manual way of recreating the admin user? Does someone have a script handy or any pointers that may help?
Yes source db however if you have access to a dB with existing amin and you know password use that as source and insert that ensure in target is is 0 as admin is always 0
if he does that won't the hashes be different and therefore he'd have the user but not the password, and then he could use the steps described in the link i posted earlier..
ATM in target he has no users so from a know db get admin
User record with hashed password main thing is you k ow the password insert that
Record it will work I have done it in the past
If you can't get access to the database, then you'll be out of luck. As easy as that. If there's no root user (id 0) then somebody has been messing directly with the db + constraints and the whole db is corrupt. Hard to solve without db access.
Recreate the admin user
Hi,
A bit of an odd one here... We recently got supplied an Umbraco databse to restore but it did not contain any users in the users table, including the main "admin" user. As you can understand, this casuses some difficulties.
We tried to add the admin user back in the users table but this doesn't work. Is there a manual way of recreating the admin user? Does someone have a script handy or any pointers that may help?
Thanks!
Bij
There is a post about resetting the admin user, I think this will be a stage of your process.. http://our.umbraco.org/forum/using/ui-questions/4790-ouch-forgot-admin-password-how-to-reset?p=1
Take a copy of the admin row from source and insert into target should all work
When you say source, do you mean the database source? Unfortunately we don't have access to that :( Nor will we get access it...sucks!
Yes source db however if you have access to a dB with existing amin and you know password use that as source and insert that ensure in target is is 0 as admin is always 0
if he does that won't the hashes be different and therefore he'd have the user but not the password, and then he could use the steps described in the link i posted earlier..
Ravi,
ATM in target he has no users so from a know db get admin User record with hashed password main thing is you k ow the password insert that Record it will work I have done it in the past
Hi,
I tried copying a row from a known umbraco database and inserting the user to this database but it does not insert a row into the table with id 0
Poornima
Poornima,
If you already have existing admin user then just update the hashed password.
I have done this on a number of occasions btw i did it using sql server mamangment tool opened the cmsusers table in edit mode
Regards
Ismail
If you can't get access to the database, then you'll be out of luck. As easy as that. If there's no root user (id 0) then somebody has been messing directly with the db + constraints and the whole db is corrupt. Hard to solve without db access.
is working on a reply...