Page History

1. IP Whitelist

• 52.60.195.209

• 52.60.242.178

• 34.242.104.105
• 18.162.86.89
• 184.68.156.110

2. Port Numbers

MySQL: 3306 (default)
PostgreSQL: 5346

3. Allow Remote/Public Connections

Enabled 

5. Database configuration

GRANT SELECT ON ##DBNAME##.* TO 'zoolauser'@'52.60.195.209' IDENTIFIED BY '##PASSWORD##' REQUIRE SSL;
GRANT SELECT ON ##DBNAME##.* TO 'zoolauser'@'52.60.242.178' IDENTIFIED BY '##PASSWORD##'  REQUIRE SSL;

GRANT SELECT ON 

ALL TABLES IN SCHEMA ##DBNAME## TO 

zoolauser;
GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA ##DBNAME## TO zoolauser;

6. PostgreSQL Specific Steps

Adjust hot standby server configuration (if applicable)

• https://www.postgresql.org/docs/9.4/static/hot-standby.html
• https://www.postgresql.org/docs/9.4/static/runtime-config-replication.html#GUC-HOT-STANDBY

Update server connection timeout settings

• tcp_keepalives_idle=60

• tcp_keepalives_interval=10

8. Install Moodle or Totara Plugins: 

Click Here