Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


 Setup Step
 

 Configuration
Zoola Minimum Technical RequirementsClick Here
  1. IP Whitelist
  • 52.60.195.209

  • 52.60.242.178

  • 34.242.104.105
50
  • 18.
64
  • 162.
100
  • 86.
15
  • 89
  • 184.68.156.110

2. Port Numbers

MySQL: 3306 (default)
PostgreSQL: 5346

3. Allow Remote/Public Connections

Enabled 

4. SSLEnabled & required

5. Database configuration

MySQL
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;
PostgreSQL
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)

Update server connection timeout settings

  • tcp_keepalives_idle=60
  • tcp_keepalives_interval=10
7. Zoola Connection TestInstall the Zoola Block (block_zoola) and visit Site Adminsitration > Plugins > Blocks > Zoola > Database settings

8. Install Moodle or Totara Plugins: 

Click Here