nursejeff wrote on Tuesday, May 26, 2015:
localhost/openemr is pulling up “index of /openemr”
I need it to go to sign in page of Openemr.
Please help
Jeff Guillory
visolveemr wrote on Tuesday, May 26, 2015:
Please check for the index.php file inside your openemr root directory and also make sure the PHP and Apache services are running
Thanks
OpenEMR Customization/Support Team,
ViSolve Inc
services@visolve.com | Phone: 408-850-2243
Demo’s @ ViSolve Demo Library
nursejeff wrote on Tuesday, May 26, 2015:
Thanks ViSolve,
I’m in bigger trouble now.
I had a problem with my linux computer. I think a memory problem. It now gets locked up at the login screen. I don’t want to worry about that now.
I need some help setting up my new Windows 7. I have downloaded the xampp package and can open openemr. My present trouble is with converting the backed up database into the new machine.
From the command box I am using this command:
mysql -u root -ppassword openemr < c:\xampp\tmp\openemr.sql
I am trying to restore my mysql and am getting the following error:
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ using password = yes
please help.
Jeff Guillory
nursejeff wrote on Tuesday, May 26, 2015:
When trying to go to localhost this is the error I now get:
ERROR: query failed: SELECT * FROM lang_definitions JOIN lang_constants ON lang_definitions.cons_id = lang_constants.cons_id WHERE lang_id=? AND constant_name = ? LIMIT 1
Error: Table ‘openemr.lang_definitions’ doesn’t exist
C:\xampp\htdocs\openemr\library\translation.inc.php at 36:sqlStatementNoLog
C:\xampp\htdocs\openemr\interface\globals.php at 311:xl((More))
C:\xampp\htdocs\openemr\interface\login\login_frame.php at 3:include_once(C:\xampp\htdocs\openemr\interface\globals.php)
Jeff
fsgl wrote on Tuesday, May 26, 2015:
Try importing old data as explained here. Dumpfile.sql = openemr.sql. Move openemr.sql to C:\ (out of xampp\tmp) before import.
Linux does not use UTF-8 for collation, hence the second error. Try this.
nursejeff wrote on Tuesday, May 26, 2015:
Hi fsgl,
I have realized that I am using a backup from 4.1.1 and am trying to get it running on a fresh 4.2.0 xampp download, hopefully I can fix it.
The files I have to restore are: mysql_backup_2015-05-25.tar and
oemrbackup_20150525.gzip and
mysql_backup_2015-05-25.log
Can I do a restore from these files?
If not, I have another issue to resolve.
Jeff
twosmartbits wrote on Tuesday, May 26, 2015:
Try 4.1.2, that could work: http://www.open-emr.org/wiki/index.php/OpenEMR_4.1.2_XAMPP_Package_Installation
nursejeff wrote on Tuesday, May 26, 2015:
I have loaded xampp on another computer and have done the restore and am now trying to restore the openemr database. I am getting the following error.
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ using password = yes
I know I am using the correct computer administrator password. Is there another password I should be using?
Jeff
fsgl wrote on Tuesday, May 26, 2015:
As explained here; when you use the backup utility in Linux, the result is emr_backup.tar. This file consists of a zipped file of the web directory, openemr.tar.gz & the mysqldump, openemr.sql.gz.
I assume that your first file is the mysqldump while the second is the web directory, both in zipped format. Don’t think you will need the third file.
So, unzip both & use the first link, then change the collation to UTF-8 with the Moodle link.
We’ll work on other problems after import of old data & collation change.
nursejeff wrote on Tuesday, May 26, 2015:
Hi TwoSmartBits,
Are you saying that the 4.1.1 will not work?
Which version was the last to come out? I know I didn’t upgrade to 4.2.0 but I was up to date before that even up to patch (7).
Jeff
fsgl wrote on Tuesday, May 26, 2015:
Jeff,
It will be fine to use the 4.2.0 Package. TSB didn’t see the exchange I had with Stephen Waite in his MU2 Compliance thread. I’ll send him an email with a link.
twosmartbits wrote on Tuesday, May 26, 2015:
Jeff,
If you’re still having the password issue, are you using the Windows administrator account password? I’m fairly certain the MySQL root password will be different. I hope I’m not unnecessarily creating confusion.
nursejeff wrote on Wednesday, May 27, 2015:
I understand from fsgl that the openemr.sql will not work on a Windows system from a linux dump.
I am reading moodle to try to figure out how to use it and convert my data so that it can be used. I am worried I may not be able to do it. It is going to be a long night.
If another option is available please let me know.
I either need to fix my linux machine that is stuck on the login screen or get this Windows system running.
I am willing to hire someone to help me.
Jeff
nursejeff wrote on Wednesday, May 27, 2015:
Does anyone know how to make phpMyAdmin accept a database that is greater than 30MiB’s?
Mine is 784,966KBs.
Jeff
fsgl wrote on Wednesday, May 27, 2015:
Jeff,
You can import the openemr.sql into Windows. A mysqldump is the same regardless of whether it’s from Linux or Windows.
If you are more likely to be successful after a good night’s sleep, perhaps you may want to tackle this tomorrow. There is always the option of using paper charting in office until you resolve this.
You definitely can do this without paid help.
sapiens110 wrote on Saturday, May 30, 2015:
Hi Jeff,
Try to locate your PHP.ini file. If your are using Xampp you can easily locate it via xampp both by xampp control or in xampp/php directory
Second step is to find these and edit them:(in your case go for 90M)
upload_max_filesize = 90M
post_max_size = 90M
save and make sure to restart your web server.You might get a time out. If true, edit this:
memory_limit = 512M
Be sure to give the db a proper name and update your sqlconfig (db name,user and pass) if necessary after the successful import.