How do I access the site as none of my passwords work anymore?

Next topic

Author	Message
Stuart Fenton	Thursday 27 March 2003 5:40:40 am I have installed the latest release of ez (3.0-1) fantastic!!. But I have locked myself out from using any of the usernames and passwords. How can I get access to the site by maybe removing md5_hash and resetting it.? Your help is appreciated. Thanks in advance. Stuart
Bård Farstad	Thursday 27 March 2003 5:50:30 am To generate a new password you need to do the following: Create a new md5 hash. This can be done with the command (linux): echo "mypassword" \| md5sum Which will print the md5sum: d84c7934a7a786d26da3d34d5f7c6c86 You then need to reset the values in the SQL database for your user. update ezuser set password_hash_type='1' , password_hash='d84c7934a7a786d26da3d34d5f7c6c86' where contentobject_id= 10; Replace 10 with the id of your user. PS: take backup of your database before you start. --bård Documentation: http://ez.no/doc
Sergiy Pushchin	Friday 28 March 2003 2:31:52 am If you aren't sick about security you can use more simple way to update password update ezuser set password_hash_type='5' , password_hash='your _plain_text_password' where contentobject_id= 10; Replace 10 with the id of your user. Password will be changed to md5_hash after your first login automatically.

Author

Message

Thursday 27 March 2003 5:40:40 am

I have installed the latest release of ez (3.0-1) fantastic!!.

But I have locked myself out from using any of the usernames and passwords. How can I get access to the site by maybe removing md5_hash and resetting it.?

Your help is appreciated.

Thanks in advance.

Stuart

Bård Farstad

Thursday 27 March 2003 5:50:30 am

To generate a new password you need to do the following:
Create a new md5 hash. This can be done with the command (linux):
echo "mypassword" | md5sum
Which will print the md5sum:
d84c7934a7a786d26da3d34d5f7c6c86

You then need to reset the values in the SQL database for your user.
update ezuser
set
password_hash_type='1' , password_hash='d84c7934a7a786d26da3d34d5f7c6c86'
where
contentobject_id= 10;

Replace 10 with the id of your user.

PS: take backup of your database before you start.

--bård

Documentation: http://ez.no/doc

Sergiy Pushchin

Friday 28 March 2003 2:31:52 am

If you aren't sick about security you can use more simple way to update password
update ezuser
set
password_hash_type='5' , password_hash='your _plain_text_password'
where
contentobject_id= 10;
Replace 10 with the id of your user.
Password will be changed to md5_hash after your first login automatically.