Zoola
Page tree
Skip to end of metadata
Go to start of metadata
 Setup Step
 Configuration
Zoola Minimum Technical RequirementsClick Here
  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 

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


Installation Steps

Zoola Technical Requirements

Installing Zoola Analytics

1. Whitelist Zoola Analytics IP Addresses

2. Enable Remote Connections to the LMS database

SSL Certificates

3. Grant Database Access to Zoola User

Optional - Enabling a Database Read Replica

PostgreSQL Specific Connection Information

4.1. Zoola Connection

4.2. Zoola Analytics Plugins

Useful Information

Installation Cheat Sheet

  • No labels

Copyright Lambda Zoola™