Jared Ottley

We use Gallery2 for our family photo gallery and we are quite happy with it. For the past day or two we have been unable to login and it has been quite annoying. Password resets wouldn’t work. I kept getting stuck in the password recovery mode, where it required me to enter a captcha along with the password, but never corrected itself.

A little google search helped me with reseting the database password hash. Then a few SQL queries and all was good again.
Here is what I needed to do:

1. Get a new password hash

In a php console (php -a) type:

echo md5(’password’);

copy the hash that is returned.

2. Update the users password in the database.

Connect to your gallery database and execute:

update g2_User set g_hashedPassword=”the_password_hash” where g_userName=”the_user”;

3. Clear the recovered password map

execute:

delete from g2_recoverPasswordMap

You should be able to access the gallery again