Cannot login - "Invalid username or password" - password expired

Support
1

Situation
I cannot login on my OpenEMR

OpenEMR Version
I’m using OpenEMR version 7.0.2

Browser:
I’m using: Firefox 121.0

Operating System
I’m using: Windows 11 64bit

Search
Did you search the forum for similar questions? Yes

After running

select * from log order by date DESC limit 10;

and base64 decoding the result I’m getting

failure: fe80::2a0:3990:6b2d:e14. user password is expired

I’m locked out. Please help!

2

Your has been expired please check with system admin to update password

3

I am the sole admin and user, how do I go about updating the password (windows-xampp)

4

Do you have the DB access

5

Issue was resolved with the help of @Nilesh_Hake . Many thanks!

The solution was to acces MySQL config and in users_secure table of the openemr db change the last_update_password date to yesterday and clear the login_fail_counter and total_login_fail_counter fields. Then the old password worked as normal.

2 Likes
6

Your Welcome @Eyedoc

7

HEllo Nilesh ,
I am have the same issue can you assist?

8

@Richardburt below is sql you can use for it

UPDATE users_secure set login_fail_counter = 0, last_update_password = “2024-01-16 12:53:00”, last_update = “2024-01-16 12:53:00” WHERE id = 1;

1 Like
Passwords expired and unable to access appliance
Login screen shows "Invalid username or password" for all users despite using the correct passwords
Cannot log in as admin in Ubuntu OpenEMR
9

Many thanks for your assistance .
I was able to solve the issue.

10

Fantastic thanks.
But I find that for mysql I had to change from ““ to ‘‘ for the string literals.

Now to disable the password ageing. Or at least have an option to reset.

11

This didn’t worked for me. Is there any other solution?

12

What version DB are you running? I see there is a choice of MariaDB and MySQL.

Can you share your screenshot with private info blanked out?