Similar to a firewall’s IP Whitelisting, databases also include options that control access and permission to the database system. Enabling Remote Access is 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 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 below server location:
| Code Block | ||
|---|---|---|
| ||
/etc/mysql/mysql.conf.d/mysqld.cnf |
Once this file has been opened you will need to change the line:
| Code Block |
|---|
bind-address = 127.0.0.1 |
to:
| Code Block |
|---|
bind-address = 0.0.0.0 |
Save and close that file. Restart the MySQL server with the command:
| Code Block |
|---|
/etc/init.d/mysql restart |
PostgreSQL
For PostgreSQL the configuration file can typically be found at the below server location:
| Code Block |
|---|
/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:
| Code Block |
|---|
listen_addresses='localhost' |
to
| Code Block |
|---|
listen_addresses='*' |
Save and close that file. Restart the PostgreSQL server with the command:
| Code Block |
|---|
/etc/init.d/postgresql restart |
Cloud Hosted
If you are using a Cloud hosting platforms 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.
