Cannot login with reset password

jason0 wrote on Tuesday, October 19, 2010:

Hello,

I have an instance of openemr 3.0 whose admin account is locked out.  I have direct database access, and have set the password string to a known value.  No matter what, I cannot login.  Heck, I have reloaded a known password from seven months ago.  I keep getting “invalid username or password”.

It’s as if I need to run “flush privileges” on the database, only I know that won’t have an effect here.  I HAVE restarted the database.  It’s just not making sense.

Does anyone have any ideas what might do this?

Thanks in advance…

-jason

uhsarp wrote on Tuesday, October 19, 2010:

Go to PhpmyAdmin (or) any mysql query tool,

Go to “Users”, edit the admin user and set the password to “e10adc3949ba59abbe56e057f20f883e” (without the “”)

that’s the encrypted pass for “123456” (without the “”)

Login with the admin account and change your pass.

Hope this helps!

-Uhsarp

jason0 wrote on Thursday, October 21, 2010:

Hi, I fixed this:  It turns out that the database username and password were hard-coded in gacl.class.php and were not being overridden by the values in the gacl.ini.php.  Not good.  Once fixed, my woes went away.

-jason