Utilities in xampp-openemr-3.0.1

Management and Administration
1

physmed wrote on Thursday, April 30, 2009:

This message is for Sam Bowen.

Sam have you ever used the utilities in the contrib folder in Windows?  Also in the installation instructions on the wiki you put that the Mysql user was openemr and the password was SOurc3_FOrg3! Is that correct? and are they the username and password that are to be plugged into the utilities?  I have used these utilities under Ubuntu without modification and they have always worked, but now under Windows XP using Active Perl 5.10 they keep denying me access to the database and as such will not insert the ICD9 codes or anything else for that matter on my test box that I am using to see if I can migrate to Windows.

Thanks

Rick

2

anojgoel wrote on Thursday, April 30, 2009:

hi rick
i did not mean to let the thread go. i have been busy. i would reinstall using a simpler password. may be perl in windows does not like complicated passwords.
regards.

3

bradymiller wrote on Thursday, April 30, 2009:

hey,

The password thing would be a bummer. I’m hoping this is not the case. To test this don’t reinstall, just use the mysql command to change to a simple password (below should change password to openemr):
mysqladmin -u openemr -h localhost -p SOurc3_FOrg3! ‘openemr’

Note this will break your openemr (can fix by putting this password in interface/globals.php, gacl/gacl.ini.php, and gacl/gacl.class.php or change back to the initial password after the test)

-brady

4

physmed wrote on Thursday, April 30, 2009:

Thanks guys!

I will give this a try and get back to you with the results!

Rick

5

physmed wrote on Thursday, April 30, 2009:

Brady

For the learning impaired among us a question!  Where do I enter the mysql command and if the answer is on the command line which directory do I have to be in to make this happen?

Thanks again

Rick

6

bradymiller wrote on Thursday, April 30, 2009:

ouch,

Your using the wrong password (using ‘O’ instead of ‘0’)
try this as password:
S0urc3_F0rg3!

Also, as an aside the change password command would be following (again, no need to do this):
C:\xampp\mysql\bin\mysqladmin -u openemr -h localhost --password=S0urc3_F0rg3! ‘openemr’

-brady

7

physmed wrote on Thursday, April 30, 2009:

OK Brady YOU THE MAN!

I did not read those characters as zeros!

Works like a charm now!

I will get back to you after I try all of the pertinent utilities!

Rick

8

anojgoel wrote on Friday, May 01, 2009:

a simple passw0rd err0r.

anyway to change mysql password without command line in windows or linux

http://localhost/phpmyadmin/
click privilages
locate user "openemr" and click edit privilages (last button)
scroll down and fill new password, click corresponding "go" button on the right.

have fun

9

blankev wrote on Friday, May 01, 2009:

All those passwords… can’t we include finger print or iris recognition…

Sorry might seem like just another stupid idea…

But how do you stay on top of all passwords if you have more than some clients with different ideas about passwords?

Pimm

10

tmccormi wrote on Friday, May 01, 2009:

I use an open source tool, like this,  to keep track of all those passwords.

KeePass Password Safe

KeePass Password Safe is a free, open source, light-weight and easy-to-use
password manager for Windows. You can store your passwords in a
highly-encrypted database, which is locked with one master password or key
file.

-Tony