Installation Cheat Sheet – Zoola

Setup Step	Configuration
Zoola Minimum Technical Requirements	Click Here
IP Whitelist	North America 3.97.107.205 35.182.6.254 15.222.130.43 Europe 34.242.104.105 63.32.84.57 54.78.105.90
2. Port Numbers	MySQL: 3306 PostgreSQL: 5346
3. Allow Remote/Public Connections	Enabled
4. SSL	Enabled & required
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;`
5. Database configuration	`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`
7. Zoola Connection Test	Install the Zoola Block (block_zoola) and visit Site Adminsitration > Plugins > Blocks > Zoola > Database settings
8. Install Moodle or Totara Plugins:	Click Here

Related articles