2. Enable Remote Connections to the LMS database

Similar to a firewall’s IP Whitelisting, databases also include options that control access and permissions to the database system. Enabling Remote Access is a feature of the database that needs to be enabled in order for Zoola to successfully connect and access the data stored within the database.

Below are some instructions associated with the different hosting options.

Self Hosted

Out of the box, MySQL and PostgreSQL will only allow access from the localhost address or the address 127.0.0.1. To change this, you need to open and edit the MySQL or PostgreSQL configuration files to allow access from external connections.

MySQL

For MySQL, the configuration file can typically be found at the following server location:

/etc/mysql/mysql.conf.d/mysqld.cnf

Once this file has been opened, you will need to change the line:

bind-address = 127.0.0.1

to:

bind-address = 0.0.0.0

Save and close that file. Restart the MySQL server with the command:

/etc/init.d/mysql restart

PostgreSQL

For PostgreSQL, the configuration file can typically be found at the server location below:

/etc/postgresql/##ADD VERSION NUM##/main/postgresql.conf
E.g /etc/postgresql/9.4/main/postgresql.conf

Once this file has been opened, you will need to change the line:

listen_addresses='localhost'

to

listen_addresses='*'

Save and close that file. Restart the PostgreSQL server with the command:

/etc/init.d/postgresql restart

Cloud Hosted

If you are using a Cloud hosting platform such as Amazon Web Services to host your Moodle or Totara, you will need to make sure that the database is accessible to public connections. This process differs for each hosting provider; however, it is typically associated with network and security settings related to the Moodle or Totara database.

Please consult your hosting provider if you have questions associated with enabling this feature.

Moodle or Totara Partner

If your LMS services are managed through a Moodle or Totara partner, you will need to contact them and make sure that they can allow Remote connections to your LMS database.