I would like to set up a distributed environment using Ubuntu and the LAMP stack, where the OEMR application server is on one LAMP installation and the MySQL database is on a separate LAMP server. Is this possible and how would I configure OEMR to point to the remote MySQL instance?
Database connection parameters in sites directory.
Please refer the below steps:
- Grant the required permissions to the server(containing the database) and the mysql, so that the server which contains the openemr can access.
- Change the crendetials at openemr/sites/default/sql_conf.php with appropriate details.
- Check whether the ports are open.
Also refer the link given.
Let us know for further clarifications.