Failure during database access

OpenEMR Development
1

ijaraho wrote on Saturday, August 24, 2013:

hi,

  1. I export all the tables of database db1
  2. I installed the last version of openemr4.1.2 in anther site with another name
  3. I imported tables of db1 to db2
    but when it access it give an error massage “Failure during database access! Check server error log.”
    can help me please
2

openemrdev wrote on Saturday, August 24, 2013:

Can you post an error log?So that we can assist you better!

Please let me know by an email,if its an emergency

openemrdev@gmail.com

3

ijaraho wrote on Saturday, August 24, 2013:

in error log of server it give this massage:
Sat Aug 24 17:44:09.811347 2013] [core:warn] [pid 8168:tid 240] AH00098: pid file C:/xampp/apache/logs/httpd.pid overwritten – Unclean shutdown of previous Apache run?
[Sat Aug 24 17:44:10.326148 2013] [ssl:warn] [pid 8168:tid 240] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Sat Aug 24 17:44:10.419748 2013] [mpm_winnt:notice] [pid 8168:tid 240] AH00455: Apache/2.4.2 (Win32) OpenSSL/1.0.1c PHP/5.4.4 configured – resuming normal operations
[Sat Aug 24 17:44:10.419748 2013] [mpm_winnt:notice] [pid 8168:tid 240] AH00456: Server built: May 13 2012 14:10:15
[Sat Aug 24 17:44:10.419748 2013] [core:notice] [pid 8168:tid 240] AH00094: Command line: ‘c:\xampp\apache\bin\httpd.exe -d C:/xampp/apache’
[Sat Aug 24 17:44:11.137349 2013] [mpm_winnt:notice] [pid 8168:tid 240] AH00418: Parent: Created child process 412
[Sat Aug 24 17:44:13.929754 2013] [ssl:warn] [pid 412:tid 252] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Sat Aug 24 17:44:14.007754 2013] [mpm_winnt:notice] [pid 412:tid 252] AH00354: Child: Starting 150 worker threads.

4

openemrdev wrote on Saturday, August 24, 2013:

Please check the database credentials on openemr/sites/yoursite/sqlconf.php.

send me some screens of what you have done…

5

ijaraho wrote on Saturday, August 24, 2013:

I think there is mismatch in credentials between my new database db2 and the old one db1
because as I told I import db1 in site1 to db2 in site2

6

openemrdev wrote on Saturday, August 24, 2013:

please let us know the versions of db1 and db2

did u get a login screen of openemr on new db

7

ijaraho wrote on Saturday, August 24, 2013:

yes get a login screen of openemr on new db
Apache 2.4.2

  • MySQL 5.5.25a
8

openemrdev wrote on Saturday, August 24, 2013:

Would like to help you more!

Please send me an email offline.if interested

openemrdev@gmail.com

9

fsgl wrote on Saturday, August 24, 2013:

Hi Issam,

MySql 5.5.25a may be incompatible with OpenEMR 4.1.2. Please note that the new XAMPP-OpenEMR has MySql 5.5.32.

Try re-installing the package, copy and replace the 4 Default folders in 4.1.2 with the 4 Default folders from 4.1.1, do Steps 4 and 5 of the Upgrade, copy and replace the 4.1.2 database with the 4.1.1 database and then do Steps 6 and 7 of the Upgrade.

You may need to do Step 6 more than once.

If you are successful, please let us know so that we can change the instructions in the Wiki.

10

ijaraho wrote on Sunday, August 25, 2013:

I installed openemr-4.1.1 in new site, then import my data, it success, and I logged to the application.