Error creating user

kkappiah · January 7, 2025, 9:58am

Situation
I am unable to create a new user in OpenEMR. I get the error

This is the server error

Executing as user:emr_app Statement failed:insert into users set username = &#039;Meh-FD&#039;, password = &#039;NoLongerUsed&#039;, fname = &#039;Meh&#039;, mname = &#039;&#039;, lname = &#039;Ashioq&#039;, suffix = &#039;&#039;, google_signin_email = &#039;&#039;, valedictory = &#039;&#039;, federaltaxid = &#039;&#039;, state_license_number = &#039;&#039;, newcrop_user_role = &#039;&#039;, physician_type = &#039;&#039;, main_menu_role = &#039;standard&#039;, patient_menu_role = &#039;standard&#039;, weno_prov_id = &#039;&#039;, authorized = &#039;1&#039;, info = &#039;&#039;, federaldrugid = &#039;&#039;, upin = &#039;&#039;, npi  = &#039;&#039;, taxonomy = &#039;207Q00000X&#039;, facility_id = &#039;3&#039;, billing_facility_id = &#039;3&#039;, specialty = &#039;&#039;, see_auth = &#039;1&#039;, default_warehouse = &#039;&#039;, irnpool = &#039;main&#039;, calendar = &#039;1&#039;, portal_user = &#039;1&#039;, supervisor_id = &#039;0&#039;:==>/home/openemr/interface/usergroup/usergroup_admin.php at 388:updatePassword

OpenEMR Version
I’m using OpenEMR version 7.0.2(1)

Browser:
I’m using: Chrome

Operating System
I’m using: Windows

Valcz · January 7, 2025, 6:40pm

It seems DB user access issue.

I can help you to solve it

kkappiah · January 7, 2025, 8:56pm

Alright.

Can you outline the steps?

Valcz · January 8, 2025, 7:41am

From the MySQL you need to GRANT access to your DB user.

If you have PHPMYADMIN then you can do from there.

From PHPMYADMIN : How To Create a New User and Grant Permissions in MySQL | DigitalOcean

From Commandline SSH access :

Let me know if more help needed.

kkappiah · January 10, 2025, 1:48pm

Hi @Valcz ,

thanks for your suggestion but the database user exists with the correct privileges on the database.

Infact, i tried to login to mysql server with the same database connection credentials being used in OpenEMR and the manually inserted a new user from the command line which was successful.

kkappiah · January 14, 2025, 5:23pm

I finally got it to work.

I had to enter an email for the user.