Lost Admin Password

[neil.benn]

Hello,

We have lost the admin password for our openemm install. I followed the instructions on inserting the md5 of the password directly into the mysql db as follows:

mysql -u root [-p if password exists]
use openemm
select md5("secret");
update admin_tbl set pwd_hash = 0x5ebe2294ecd0e0f08eab7690d2a6ee69 where username = "admin";
exit

However that is not working - it still says 'bad password'. Our resin version is 5.3.1 but this is just not working for us. Is there something we are doing wrong here?

Cheers,

Neil

[neil.benn]

Looking at the logs it seems that the MD5 hash which is being scanned for in the db is not the same MD5 that I get from mysql or md5sum. Looking at that - is the login page doing some kind of 'funky' md5 cacluculation?

Neil

[eshine]

No direct answer to your question but install openemm on a different server or only database, enter there your password and copy that md5 hash to your current installation. Kind of a workaround I recently used with wordpress