User can't log on

OpenEMR Development Data Analysis
#1

I have a user who couldn’t log on. I changed the password as an administrator and he still can’t log on.

#2

Hi @tjbarr, check the log after a failed attempt.

#3

Thanks it was the last_updated date in the user_secured table.

1 Like
#4

Now this is happening to me. What logs should I check. I can get in with my admin account but not my clinical id. I updated the password and still can’t get in. I also updated the last_updated in the user_secure table and still can’t log on.

#5

hi @tjbarr, after you fail to login run this mysql command:
select * from log order by date DESC limit 10;

and then decode the base64 comments field to see the error that is related to the failed login in the log

Lost admin password
Invalid username or password
#6

Thanks. How do you decode the comments?

#7

I tried a decoder and it is still unreadable.

#8

try this site, https://www.base64decode.org/

#9

I receive failure user stored pa for one admin account and empty username for the other account when checking the logs on the decoder site

#10

hi @harmone75 , you’re receiving this message user stored password hash is invalid?

#11

Well the decoder doesn’t display that full content, but i’m assuming you are right regarding that message

#12

haven’t seen that before, have you tried setting the password to pass like this command does for username admin

UPDATE users_secure SET `password` = '$2a$05$MKtnxYsfFPlb2mOW7Qzq2Oz61S26s5E80Yd60lKdX4Wy3PBdEufNu' WHERE `username` = 'admin';
#13

Thank you, that worked

1 Like