Hi I’m setting up an emergy EMR for the covid-patients. I need to add many users. I thought to be smart and was going to write directly in the mysql-DB. I do an insert into ‘users’, ‘users_secure’ and ‘gacl_aor’. I made my own salt and blowfish password for each user, based on the code of the op…

Hi Pieter, that is a really interesting question. If I recall correctly there are some length and complexity requirements for a username and password. The username and password might also need to be different. “Password does not meet minimum requirements and should contain at least each of the fo…

Nevermind on the authorized value. I’m able to login without it. After a new user added this way isn’t able to log in can you check the logs table in the database? When I type an incorrect password intentionally I see the below under the comments column: failure: 10.0.2.2. user password incorrec…

Hi Rachel Thx for the responses! This is in the log: failure: 81.240.22.101 (81.240.22.101). user not in group: Default So, in which table do I need to a change? I can’t figure it out at the moment.

Problem solved. You need to add a row into tables -users -users_secure -gacl_aro -gacl_groups_aro_map -groups Thx for the support! $sqlusers .= “INSERT INTO users (id, username, password, authorized, info, source, fname, mname, lname, suffix, federaltaxid, federaldrugid, upin, facility, faci…

Great, glad you were able to get this figured out. Maybe we should consider making it easier to batch add new users. I imagine doing it one at a time can get pretty tedious. Feel free to ping the community on slack chat if you’d like to discuss further support for batch addititions of users. htt…

[image] Pihos: INSERT INTO gacl_groups_aro_map (group_id, aro_id) VALUES (‘13’, ‘“.$id.”’) thank you for this, I was struggling with this and this post helped!

OpenEMR Community

Add users directly in SQL

Management and Administration

covid19, question

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled