OpenEMR and MirthConnect on Windows 10

Arun · September 4, 2019, 2:20am

Hi,

I am trying to create a development environment on my Windows desktop that includes OpenEMR and MirthConnect.

I am using XAMPP for Windows 7.3.8. The control panel version is 3.2.4.

The Database server window in phpMyAdmin shows the folowing:

Server: 127.0.0.1 via TCP/IP
Server type: MariaDB
Server connection: SSL is not being used
Server version: 10.4.6-MariaDB - mariadb.org binary distribution
Protocol version: 10
User: root@localhost
Server charset: cp1252 West European (latin1)

The Webserver window in phpMyAdmin shows the following:

Apache/2.4.39 (Win64) OpenSSL/1.1.1c PHP/7.3.8
Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 - $Id:
PHP version: 7.3.8

From the above configuration, I understand that the database is MariaDB and not regular MySQL. I do not want to use MariaDB since latest version of MirthConnect is not recognizing MariaDB. I have installed another instance of MySQL (ocalhost:13306). This instance works fine with MySQL Workbench as well as MirthConnect.

When I try using this instance for installing OpenEMR locally, OpenEMR is not able to recognize. Error shown is “Invalid Credentials”

brady.miller · September 4, 2019, 4:39am

Hi @Arun ,
What version of mysql are you using?
-brady

Arun · September 4, 2019, 5:50pm

Hi Brady.

Ver 8.0.17 for Win64 on x86_64 (MySQL Community Server - GPL)

Above information was obtained by executing mysqld -V in command line.

Regards,
Arun

brady.miller · September 4, 2019, 9:58pm

Hi @Arun,

Mysql 8 does not work out of box with php unless use following mysql default-authentication-plugin setting:

github.com

openemr/openemr/blob/master/contrib/util/docker/docker-compose.yml#L185


    MYSQL_ROOT_PASSWORD: root
mariadb-very-very-old:
  restart: always
  image: mariadb:10.1
  command: ['mysqld','--character-set-server=utf8']
  environment:
    MYSQL_ROOT_PASSWORD: root
mysql:
  restart: always
  image: mysql:8
  command: ['mysqld','--character-set-server=utf8','--default-authentication-plugin=mysql_native_password']
  ports:
  - 8220:3306
  environment:
    MYSQL_ROOT_PASSWORD: root
mysql-old:
  restart: always
  image: mysql:5.7
  command: ['mysqld','--character-set-server=utf8']
  environment:
    MYSQL_ROOT_PASSWORD: root

Arun · September 5, 2019, 1:44am

Screenshot of my.ini from C:\ProgramData\MySQL\MySQL Server 8.0

At the time of installing MySQL 8, I had chosen native password as the default authentication.

Is there any other file that I need to make changes?