New Implementation

Management and Administration
1

justincpu wrote on Wednesday, April 02, 2014:

I have taken over a company that uses OpenEMR. The initial setup process has been done by another IT company with no information provided. I am new to this so bare with me. The only thing I am needing at this point is a way to determine the Login Credentials that were created during initial setup. I am continuing my research to figure this out but some help would be much appreciated. Thanks in advance. Have a great day.

2

sunsetsystems wrote on Wednesday, April 02, 2014:

You can run a SQL query to reset the (hashed) admin password to a known value. Details depend on which release of OpenEMR it is. This would be a good thing to write up as a wiki article.

For OpenEMR 4.0 and up, to set the admin password to “pass”:

update users set password = ‘9d4e1e23bd5b727046a9e3b4b7db57bd8d6ee684’, active = 1 where username = ‘admin’;

and if the table users_secure exists then you must also do this:

delete from users_secure where username = ‘admin’;

Rod
http://www.sunsetsystems.com/

3

yehster wrote on Wednesday, April 02, 2014:

Another solution to your problem would be to modify the password hashes in the database to known new passwords rather than try to determine the existing password.

Alternately, you could also use the existing hashes in the database and use rainbow table tools available on the internet to determine the password. (assuming the password is something “common”.)

Consider this my last piece of technical support on the forum for getting into your existing system, as

  1. I am unwilling to provide more details without financial compensation.
  2. I don’t really want to describe the mechanism in complete detail on the forum as to how to “hack” into a system.
4

justincpu wrote on Wednesday, April 02, 2014:

I understand. I must mention that my knowledge of this is very limited. It is also helpful to mention that it runs XAMPP. I am contemplating contracting a company to manipulate this for me. I am just in the beginnings of this and am looking for help and direction.

5

fsgl wrote on Wednesday, April 02, 2014:

For Windows, the username and password can be found by going to C:\xampp\security\xamppdirpasswd.txt

Unable to provide path for a Linux machine.

6

anonymous wrote on Wednesday, April 02, 2014:

Why can’t you ask the company you acquired from for login credentials? I assume if you don’t have login credentials, you have not been given the MySQL root pass which would be needed to take the above steps. Your best bet would be to contact someone from the professional support link to help walk you through he process.

http://www.open-emr.org/wiki/index.php/OpenEMR_Professional_Support

7

fsgl wrote on Wednesday, April 02, 2014:

I would think that asking the previous user for the login information is not an option.

Locating the info in the security folder requires access to the xampp directory, which for the ordinary user, necessitates having the device in one’s hands.

The MySQL root password is in the same folder.