Unable to login as Administrator

Situation
Unable to log in as Administrator. How can I troubleshoot this issue at both the application and database levels

OpenEMR Version
I’m using OpenEMR version 7.0.3

Browser:
I’m using: Google Chrome

Operating System
I’m using: Ubuntu 24.04

Search
Did you search the forum for similar questions?

Logs
error log

[Fri May 23 05:08:21.644744 2025] [php:warn] [pid 7273] [client 27.116.21.242:49924] PHP Warning: Undefined array key
“form_pid” in /var/www/html/smartemr/interface/main/calendar/add_edit_event.php on line 716, referer: http://smart-em
r.com/interface/main/calendar/add_edit_event.php?date=20250701&eid=36&prov=true
[Fri May 23 05:08:21.644776 2025] [php:warn] [pid 7273] [client 27.116.21.242:49924] PHP Warning: Undefined array key
“form_room” in /var/www/html/smartemr/interface/main/calendar/add_edit_event.php on line 720, referer: http://smart-e
mr.com/interface/main/calendar/add_edit_event.php?date=20250701&eid=36&prov=true
[Fri May 23 05:23:01.286995 2025] [php:warn] [pid 8781] [client 27.116.21.242:50012] PHP Warning: Undefined array key
“form_pid” in /var/www/html/smartemr/interface/main/calendar/add_edit_event.php on line 716, referer: http://smart-em
r.com/interface/main/calendar/add_edit_event.php?date=20250523&eid=7&prov=true


access.log

122.162.230.20 - - [23/May/2025:01:18:59 +0000] “POST /library/ajax/dated_reminders_counter.php HTTP/1.1” 200 446 “htt
p://smart-emr.com/interface/main/tabs/main.php?token_main=YzVim0AV8Rb5DWI7XPTzCsFvtldwfc8J6TczgtKR” “Mozilla/5.0 (Wind
ows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36 Edg/136.0.0.0”
122.162.230.20 - - [23/May/2025:01:18:59 +0000] “POST /interface/main/dated_reminders/dated_reminders.php HTTP/1.1” 20
0 446 “http://smart-emr.com/interface/main/messages/messages.php?form_active=1” “Mozilla/5.0 (Windows NT 10.0; Win64;
x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36 Edg/136.0.0.0”
106.119.167.146 - - [23/May/2025:01:25:40 +0000] “GET / HTTP/1.1” 302 219 “-” “Mozilla/5.0 (iPhone; CPU iPhone OS 13_2
_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1”
106.119.167.146 - - [23/May/2025:01:25:40 +0000] “GET /interface/login/login.php?site=default HTTP/1.1” 200 3325 “http
://smart-emr.com” “Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) V
ersion/13.0.3 Mobile/15E148 Safari/604.1”
134.209.190.226 - - [23/May/2025:01:26:19 +0000] “GET / HTTP/1.1” 302 256 “-” “Mozilla/5.0 (X11; Linux x86_64; rv:136.
0) Gecko/20100101 Firefox/136.0”
134.209.190.226 - - [23/May/2025:01:26:20 +0000] “GET /interface/login/login.php?site=default HTTP/1.1” 200 3363 “-” "
Mozilla/5.0 (X11; Linux x86_64; rv:136.0) Gecko/20100101 Firefox/136.0"
134.209.190.226 - - [23/May/2025:01:26:20 +0000] “GET /public/images/logos/core/favicon/favicon.ico HTTP/1.1” 200 1538
9 “OpenEMR Login” “Mozilla/5.0 (X11; Linux x86_64; rv:136.0) Gecko/20100
101 Firefox/136.0”
199.244.88.232 - - [23/May/2025:02:21:30 +0000] “GET / HTTP/1.1” 302 200 “-” “Mozilla/5.0 (X11; Linux x86_64) AppleWeb
Kit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36”
199.244.88.232 - - [23/May/2025:02:21:30 +0000] “GET /interface/login/login.php?site=default HTTP/1.1” 200 3309 “http:
//smart-emr.com” “Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.3
6”
217.113.194.36 - - [23/May/2025:02:51:02 +0000] “GET /robots.txt HTTP/1.1” 200 310 “-” “Mozilla/5.0 (compatible; Barkr
owler/0.9; +https://babbar.tech/crawler)”

Need to check some basic things first.
When was the last time your ‘admin’ login worked?
Is it possible that the password was changed, by someone else who knows the admin account credentials?
Is it possible that the password expired?
If you know how to access and query values in your database, examine the rows for the ‘admin’ user in the ‘users’ , and ‘user_settings’ tables, in particular make sure the user account is active, make sure the account isn’t locked, and verify that the date of last password change isn’t outside the expiration window (depending on your local security policies and grace period for password changes).