Administrator can't login

Management and Administration
#1

hello;
I’m new in openemr
by accident I unchecked the ‘Provider’ check box(active) from the administrator and now I cannot login again.

#2

you’ll have to issue a sql statement like

UPDATE `users` SET `active` = 1 WHERE username = 'yourusername';
#3

Hi Stephen;
I issue a sql statement
UPDATE ‘users’ SET ‘active’ = 1 WHERE username = ‘yourusername’;
but no result , i can’t login.

Capture du 2022-06-01 10-34-50
Capture du 2022-06-01 10-34-501346×623 85.9 KB

#4

hard to read that output but looks like the query was successful

you could post the output of

SELECT username, active FROM `users` WHERE username != ''

if you still can’t login then you’ll have to look at the log table after you try to log in to get more info