Read about OpenEMR's Response to the COVID-19 Pandemic at https://www.open-emr.org/covid19/

Unable to login in newly installed OpenEMR 5.0.2 on localhost

Observing all the instructions, I successfully installed OpenEMR on localhost in Windows 10 for the first time. Installation was perfect. But I get ‘Invalid username or password’ message when I attempt to login.
I also reset password to ‘pass’ using the database but no login success.
I’ve installed the latest AMPPS 3.9 (apache, mysql, php-7.3). Suggestions please.

look at your logs
what version of mysql?

Hi Sandra,
MySQL 8.0.18
Apache 2.4.41
PHP 7.3.11

and your logs? what do they say?

One point may be important to mention. The php.ini does not have register_globals = Off by default. The setup required that it should be off, but it was already detected as ‘off’. So I didn’t add it manually.
I do not understand the logs syntax. Could you please identify the problem from the logs? I am posting them here.

MySQL log
2020-07-25T00:48:07.495000Z 0 [System] [MY-010116] [Server] C:\Program Files\Ampps\mysql\bin\mysqld.exe (mysqld 8.0.18) starting as process 6204

2020-07-25T00:48:25.489392Z 0 [ERROR] [MY-011947] [InnoDB] Cannot open ‘C:\Program Files\Ampps\mysql\data\ib_buffer_pool’ for reading No such file or directory

2020-07-25T00:48:25.700241Z 0 [Warning] [MY-010075] [Server] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: b6b8a2ba-ced9-11ea-9602-b4b686b9db27.

2020-07-25T00:48:29.925644Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.

2020-07-25T00:48:31.554365Z 0 [System] [MY-010931] [Server] C:\Program Files\Ampps\mysql\bin\mysqld.exe: ready for connections. Version: ‘8.0.18’ socket: ‘’ port: 3306 MySQL Community Server - GPL.

2020-07-25T00:48:31.810301Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: ‘::’ port: 33060

Apache log
[Sat Jul 25 06:47:27.791364 2020] [mpm_winnt:notice] [pid 7216:tid 744] AH00455: Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.11 configured – resuming normal operations

[Sat Jul 25 06:47:27.791364 2020] [mpm_winnt:notice] [pid 7216:tid 744] AH00456: Apache Lounge VS16 Server built: Aug 9 2019 16:46:32

[Sat Jul 25 06:47:27.791364 2020] [core:notice] [pid 7216:tid 744] AH00094: Command line: ‘apache\bin\httpd.exe -d C:/Program Files/Ampps/apache’

[Sat Jul 25 06:47:27.791364 2020] [mpm_winnt:notice] [pid 7216:tid 744] AH00418: Parent: Created child process 14036

[Sat Jul 25 06:47:28.279319 2020] [mpm_winnt:notice] [pid 14036:tid 752] AH00354: Child: Starting 64 worker threads.

These are just the standard general logs
The logs above look fine

The other problem may be the issue with MySQL8. It may not have accepted your change to pass. It normally should not accept a 4 letter password I think.
Also, It is hard to get openemr to work with Mysql 8. At least it was for me. Check out other threads here. check the database logs. I don’t know how to check those. Those are in the tables themselves.

Thanks Sandra for your support. I will update you if I find a solution.

~Shashpal

1 Like