| 19 | Then set up apache, see /etc/apache2/sites-available/piwik.transitionnetwork.org and run the web installer and: |
| 20 | |
| 21 | {{{ |
| 22 | cd /web/piwik.transitionnetwork.org/piwik/ |
| 23 | chown -R www-data:www-data tmp/ |
| 24 | chown -R www-data:www-data config/ |
| 25 | }}} |
| 26 | |
| 27 | Then a MySQL user and database was added using phpMyAdmin which ran the following SQL: |
| 28 | |
| 29 | {{{ |
| 30 | CREATE USER 'piwik'@'localhost' IDENTIFIED BY '********'; |
| 31 | GRANT USAGE ON * . * TO 'piwik'@'localhost' IDENTIFIED BY '********' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; |
| 32 | CREATE DATABASE IF NOT EXISTS `piwik` ; |
| 33 | GRANT ALL PRIVILEGES ON `piwik` . * TO 'piwik'@'localhost'; |
| 34 | }}} |
| 35 | |
| 36 | |
| 37 | |