Hello all
I have been trying to upgrade my Version 4.1.2 running on a XAMPP server on Windows 10. I get to the login screen but on entering user name and password am presented with: Failure during database access! Check server error log.
My apache error log:
[Sun Aug 20 16:09:51.583285 2017] [mpm_winnt:notice] [pid 2804:tid 704] AH00422: Parent: Received shutdown signal – Shutting down the server.
[Sun Aug 20 16:09:53.684254 2017] [mpm_winnt:notice] [pid 5512:tid 620] AH00364: Child: All worker threads have exited.
[Sun Aug 20 16:09:55.491540 2017] [mpm_winnt:notice] [pid 2804:tid 704] AH00430: Parent: Child process 5512 exited successfully.
[Sun Aug 20 16:47:55.785136 2017] [ssl:warn] [pid 16120:tid 772] AH01909: RSA certificate configured for www.example.com:443 does NOT include an ID which matches the server name
[Sun Aug 20 16:47:56.685213 2017] [ssl:warn] [pid 16120:tid 772] AH01909: RSA certificate configured for www.example.com:443 does NOT include an ID which matches the server name
[Sun Aug 20 16:47:59.338360 2017] [mpm_winnt:notice] [pid 16120:tid 772] AH00455: Apache/2.4.4 (Win32) OpenSSL/0.9.8y PHP/5.4.16 configured – resuming normal operations
[Sun Aug 20 16:47:59.338360 2017] [mpm_winnt:notice] [pid 16120:tid 772] AH00456: Server built: Feb 23 2013 13:07:34
[Sun Aug 20 16:47:59.338360 2017] [core:notice] [pid 16120:tid 772] AH00094: Command line: ‘C:\xampp\apache\bin\httpd.exe -d C:/xampp/apache’
[Sun Aug 20 16:47:59.363398 2017] [mpm_winnt:notice] [pid 16120:tid 772] AH00418: Parent: Created child process 2324
[Sun Aug 20 16:48:01.773505 2017] [ssl:warn] [pid 2324:tid 524] AH01909: RSA certificate configured for www.example.com:443 does NOT include an ID which matches the server name
[Sun Aug 20 16:48:02.807150 2017] [ssl:warn] [pid 2324:tid 524] AH01909: RSA certificate configured for www.example.com:443 does NOT include an ID which matches the server name
[Sun Aug 20 16:48:02.993424 2017] [mpm_winnt:notice] [pid 2324:tid 524] AH00354: Child: Starting 150 worker threads.
[Sun Aug 20 17:06:45.117143 2017] [:error] [pid 2324:tid 2076] [client ::1:61066] script ‘C:/xampp/htdocs/openemr/interface/login/login_frame.php’ not found or unable to stat
[Sun Aug 20 19:38:37.509834 2017] [auth_basic:error] [pid 2324:tid 2056] [client ::1:62461] AH01618: user rayaz not found: /xampp/
My php error log:
[20-Aug-2017 07:27:46 America/Los_Angeles] Executing as user:openemr Statement failed:select users.id,users.username,users_secure.password,users_secure.id FROM users,users_secure WHERE users.id = ? AND users.username=users_secure.username AND users.active=1:Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’==>C:\xampp\htdocs\openemr\library\auth.inc at 133:privQuery
[20-Aug-2017 07:45:01 America/Los_Angeles] Executing as user:openemr Statement failed:select users.id,users.username,users_secure.password,users_secure.id FROM users,users_secure WHERE users.id = ? AND users.username=users_secure.username AND users.active=1:Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’==>C:\xampp\htdocs\openemr\library\auth.inc at 133:privQuery
[20-Aug-2017 07:54:06 America/Los_Angeles] Executing as user:openemr Statement failed:select users.id,users.username,users_secure.password,users_secure.id FROM users,users_secure WHERE users.id = ? AND users.username=users_secure.username AND users.active=1:Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’==>C:\xampp\htdocs\openemr\library\auth.inc at 133:privQuery
[20-Aug-2017 08:12:13 America/Los_Angeles] Executing as user:openemr Statement failed:select users.id,users.username,users_secure.password,users_secure.id FROM users,users_secure WHERE users.id = ? AND users.username=users_secure.username AND users.active=1:Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’==>C:\xampp\htdocs\openemr\library\auth.inc at 133:privQuery
Any help is appreciated
Regards