Message-ID: <1457691613.15621.1711714227190.JavaMail.confluence@ip-172-16-1-18.us-west-2.compute.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_15620_514808643.1711714227189" ------=_Part_15620_514808643.1711714227189 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Installation Cheat Sheet

Installation Cheat Sheet

=20
=20
=20
=20
 S= etup Step
 C= onfiguration
Zoola Minimum Technical Requiremen= ts Click 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&nb= sp;

4. SSL Enabled &= 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 ##DBNA=
ME## TO zoolauser;
GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA ##DBNAME## T= O zoolauser;

6. PostgreSQL Specific Steps

Adjust hot standby server configuration (if a= pplicable)

Update server connection timeout settings

  • tcp_keepalives_idle=3D60
  • tcp_keepalives_interval=3D10
7. Zoola Connection Test Install the Zoola Block (block_zoo= la) and visit Site Adminsitration > Plugins > Blocks > Zoo= la > Database settings

8. Install Moodle or Totara Plu= gins: 

Click Here


=20
=20 =20
=20
------=_Part_15620_514808643.1711714227189 Content-Type: application/octet-stream Content-Transfer-Encoding: base64 Content-Location: file:///C:/1a3b73fd68208cff0407c461ed44a342 iVBORw0KGgoAAAANSUhEUgAAAOEAAADhCAMAAAAJbSJIAAAAdVBMVEUzMzP///8nJycwMDCQkJAj IyMtLS2tra2UlJQ2NjYqKir4+Pjy8vL8/Py4uLjX19dhYWHR0dFmZmbt7e1TU1Pj4+OEhIRAQEDE xMRbW1t8fHxtbW10dHSLi4tISEilpaUcHBycnJxCQkLIyMgWFha8vLwdHR1464+1AAAJbElEQVR4 nO2da3erKhCGDaNUjWIuUpPYaM3l/P+feMzu7o4aL1zVYt9PXV2r6lNgZmBgsFamy5r6A7Trl/Dn 65fw5+uX8Ofrl1CtwnUQBOtw1HeOQbin2+vhcCfkLS/ss13kb4TcD4frlu5HeLtewn10ILl7SuNL 4mHkOOhL5Q/YSy5xenJzcoj0cuojpPcS7ZglGPkYAKymyt9hH+EkO5agd6rtO/QQhld7FyfgY9yC 1gTF2Ick3tlXPeNTPWEYFRsPGNianOBtikg9pVrCMKDu5YYwD1wFE6PbxaWBWkqVhAElKUJidP8o EUoJDRR+lTrC6H7OkC+F9yUfZed7pOy7VBFuiw1INt9T5ZM2xVbRl6kh3NqxjxXhfQn7sa2GUQVh 9J6BWr4/jJC9q+ir8oQ09bgcA7sAvFQ+EpAkDKP05uvh+8Po31JZFylFGFLXUmE9++RbLpVilCHc k6My89ktQEciE5tLEB5OGuxLmzCcDhMQ0iJDo/A9hLJC2OQIEoZko8mAtgtgQwRHoxhhYHvjdNCn sGeLRatChFHsjNmAXwInFgoABAjXZCQL0xQGsh6DkLqf4zfgl+DT5Tc43ITbdDwT+iqUcofjnIRr Ek/TQ7+FY96eyke4zi/TApaIl5wPkY/QtaYagk+B5WojDD8mcBKvAueDx/lzEAY7Z2q4v3J2HM6f nZDudE+U2OXv2L0GM2G0m9rGVIV3zPENK2G0mRNgibhhRWQkpLNqwYcwa0dlIwxmB/hAZDM3TITh jIzMU/6OyWkwEX7MxU3U5XwoIly78wQsEV2GAG6YcJ3PIFRrF1gMMeowIbnMFbBEvBB5wu3E06V+ 4XhwvjhESNM5A5aIg5mNAcK1O+WMnkVoyNoMEJLPqQkG9TkwFPsJo1GXfcUE0B+h9hIGs7Yy38Jx b/jWRxjaKl29vt7g2H3hWx8h8dR9lW8l6D9NVgu8vqHYQ0gVTgnhTCnduprWefCmx2X0EBbqPsd5 //PEMLL0DGwoRAgPmbLtMf7790OjREsrQtadQu0k3J9UjRqwzv+eui70jEV06kyEdxGGRFkLelVT t9XTiBZ0JlC7COlR0YgBz626K11xLj52GZsOwlBVPNoAXO3fNS2IILejETsII0UOGsCuB8baQnmA jnlUB2Gq6D+N3pv/2VzXkoi/4yGkNyUvBfT+8ug3bYs+t/YIvJ1QTRMCvAJqJPRTdsJISUBadxP6 CcFrHYmthO9qAFtn3/oILTixEm5VxGtNNzEGYdbWiG2EtgpAq2MLk0ZCC2w2QiXrh/65wwHrJGxd W2whLBQYUqfFiuontPyChVBBLrTVTYxB2JY3fSW8S4/C0k10AuoltOA+TBicZQPHDjcxCiE6v9i3 F0Iq6yq63MQ4bZi9TKKahCGRbEKwegE1E1rOy0y4SRjIhqT43J9H0EyI0+b/t0lIJZuw202MQ2g5 zW7aJJSboAIeAtROiJp2vEEYSiV8q6tqUxFC0hiIDcJIZurb7yZGInyZCDcIZZYzB9zEWISo6CWU iNjYAPUT4k0fYSgxuW+uqnUR3hCzhM6Eg1f/jjrhVRxw0E18v+Jss+qcejeBw3Fw7SG0RTtpJfmi VOuC//gRrvuLOqHoFkQWNyGoaMdNWF84rRHSWLAYQuuqmiLtPzjjSIhrYU2N8C6WGGK0oqLiXVWB pJb0rhG6cwRchbnH+UG1Axk1wpPIvOIl+aJcV87B49fWTauEe6Hc3mvyRbV4c444rSaEq4SRQFa0 LfmiWiFnzhEfq6FplVBgb0Lfqpo6uXyE9X0LVULCbUq1uomnbE77kLx1EOa8nZRpujQBIc47CHnn 97rdhDAhqvasCuGe01l0Jl8mJ/Sru2sqhLxGuTP5Mjlh7cRQhXDL51hZp0sTEEI1B1UhvPKsQo3j JkQJk4q7qBAeOJxFb/JlekKvg5A9wB3LTQgSWlYlBVUhvDMbmtHchCih307InJMZSr5MT+hUZohV QtZ1vqHky2wJWVcyR3QTwoSVwPRJGOZMvZQh+TI9IcqfwciTkG2DssZVNZWExXMcPQkDm4EQklHd hDBhJWKuELJsUYDOzcbzIjy3EhrfhuaPQ/Ntqfn+cAExjflxqflzC/Pnh+bP8c1fpzF/rc389VLz 17zNz1ssIPdkfv7Q/Byw+Xl88/dimL+fZgF7oszf12b+3kTz95cuYI+w+fu8zd+rb/55iwWcmTH/ 3JP5Z9fMP3+4gDOk5p8DNv8st/nn8RdQU8H8uhgLqG1ifn2aBdQYMr9O1AJqfZlfr20BNffMr5u4 gNqXGuuXaiPkq1+qrwZtqKkYNHcNWm11hIPzTOoIa6sFzbvhg1XctaC11fOOBJM/g2/hruetqSY7 +xZPPgnUZNdUV196GajjDSJ19XXcjbAK3vX4CrG7EVTfb7GnNEr1AIreb6H2jpLkGGdIjx0VvqNE 7T0zANruHRK/Z8b8u4IWcN/TAu7sWsC9a+bfnbeA+w8XcIflAu4hNf8u2ZX59wEv4U5n8+/lXsDd 6krypkrVlguVI1xFs2pFvGMFZCcsO+p8zI3P2kW5CEtzMxen4TAaGV7CVfih6R5RPoHzwbNvnodw tXJnEMCB5Q5/qDDhOr9MbW/whSEWFSdcrcnEkykcE84zSJyE5XwxnXLWj9LB+aA04Yq6n1MNRvh0 +QsA8ROWPRWm6akYeHuoIOEjRTaB2wAnZo5jpAlXgc1/WEdS2BM8Gy9GuArJZtTFYoBNZwpUD2Fp cIpsPKOKskK4xpgw4Wp1OI1kcTCcuhOgOglXe3IUOFrGK0BH0pnC1ky4CqkLuqdUPrhU6oCqFGHJ uN3dfH3tCP5tt5U8gCtJWCpKPU1mFcBLhVygYsIyVD1lGmwOhuzEHYS2SAVhyWjHvlpG7Me2Cj5V hCVjsQFlhrV80qZQw6eOsByP93PmqGhI7GTnu/z4+5Y6wjJapSR1JBsSkJMSqrJEg0rC0nkE1E5u YmewH+cz0S2xaaC2PoNawofCqNh4gDGXC4HHH3ibIlJffUI94UPrq72LE/AZOB9sPiTxzr7qKQKj h/AhStxTeswSjHzcth+q/B32EU6yY3pyib7yxPoIH9pHh7fcPpXt6Vm+4zh/ayWUP/mWV7bbyc7f DpFMXD0svYR/FO7p9nC43wl5ywv7bBf5GyH3++GwpfsRKoWNQFhRuA6CYD1WMcIvjUs4hX4Jf75+ CX++fgl/vn4Jf77+B/LRy6ZzSfJlAAAAAElFTkSuQmCC ------=_Part_15620_514808643.1711714227189--