status, summary changed

chris — Tue, 04 Mar 2014 07:38:03 GMT

status changed from new to accepted
summary changed from Piwik 2.1 upgtate for stats.ttansitionnetwork.org to Piwik 2.1 upgrade for stats.tansitionnetwork.org

summary changed

chris — Tue, 04 Mar 2014 07:38:36 GMT

summary changed from Piwik 2.1 upgrade for stats.tansitionnetwork.org to Piwik 2.1 upgrade for stats.transitionnetwork.org

hours, totalhours changed

chris — Tue, 04 Mar 2014 13:48:29 GMT

hours changed from 0.0 to 0.85
totalhours changed from 0.0 to 0.85

According to the blog post about Piwik 2.1:

The cron script http://piwik.org/docs/setup-auto-archiving/ you can setup to automatically process your reports will now create new processes to perform asynchronous archiving instead issuing CURL http requests.

Full details are in the Piwik 2.1.0 Changelog.

Following the last upgrade, ticket:672 and the wiki:PiwikServer#Updates notes and updating these as we go:

Switch off the recording of stats by setting record_statistics to 0 in /web/stats.transitionnetwork.org/piwik/config/config.ini.php:

[Tracker]
record_statistics = 0

Backup the config file:

cd /web/stats.transitionnetwork.org/
cp piwik/config/config.ini.php .

Download, extract, and update the database and restart php-fpm:

export PIWIK=0.1.2
wget "http://builds.piwik.org/piwik-$PIWIK.tar.gz"
tar -zxvf piwik-$PIWIK.tar.gz
cp config.ini.php piwik/config/
chown -R www-data:www-data piwik/
php /web/stats.transitionnetwork.org/piwik/index.php -- "module=CoreUpdater"
  PHP Warning:  require_once(./modules/testMinimumPhpVersion.php): failed to open stream: No such file or directory in /web/stats.transitionnetwork.org/piwik/index.php on line 20
  Warning: require_once(./modules/testMinimumPhpVersion.php): failed to open stream: No such file or directory in /web/stats.transitionnetwork.org/piwik/index.php on line 20
  PHP Fatal error:  require_once(): Failed opening required './modules/testMinimumPhpVersion.php' (include_path='.:/usr/share/php:/usr/share/pear') in /web/stats.transitionnetwork.org/piwik/index.php on line 20
  Fatal error: require_once(): Failed opening required './modules/testMinimumPhpVersion.php' (include_path='.:/usr/share/php:/usr/share/pear') in /web/stats.transitionnetwork.org/piwik/index.php on line 20

Oh dear...

The site displays:

Do'h, my fault, that was with the wrong version, should have looked closer at the list at http://builds.piwik.org/ trying again:

export PIWIK=2.1.0
wget "http://builds.piwik.org/piwik-$PIWIK.tar.gz"
tar -zxvf piwik-$PIWIK.tar.gz
cp config.ini.php piwik/config/
chown -R www-data:www-data piwik/
php /web/stats.transitionnetwork.org/piwik/index.php -- "module=CoreUpdater"
  *** Update ***
      Database Upgrade Required
      Your Piwik database is out-of-date, and must be upgraded before you can continue.
      Piwik database will be upgraded from version 2.0.3 to the new version 2.1.0.
  *** Note: this is a Dry Run ***
      ALTER TABLE user ADD COLUMN `superuser_access` tinyint(2) unsigned NOT NULL DEFAULT '0' AFTER token_auth;
      UPDATE `option` SET option_value = '2.0.4-b8' WHERE option_name = 'version_core';
  *** End of Dry Run ***

So doing this manually:

mysql stats
  mysql> ALTER TABLE user ADD COLUMN `superuser_access` tinyint(2) unsigned NOT NULL DEFAULT '0' AFTER token_auth;
  Query OK, 10 rows affected (1.20 sec)
  Records: 10  Duplicates: 0  Warnings: 0
  mysql> UPDATE `option` SET option_value = '2.0.4-b8' WHERE option_name = 'version_core';
  Query OK, 1 row affected (0.00 sec)
  Rows matched: 1  Changed: 1  Warnings: 0

And the site is up and running again, phew!

https://stats.transitionnetwork.org/

Sort out the logo:

cp /web/penguin.transitionnetwork.org/www/favicon.ico /web/stats.transitionnetwork.org/piwik/plugins/CoreHome/images/favicon.ico
cp /web/penguin.transitionnetwork.org/www/favicon.ico /web/stats.transitionnetwork.org/piwik/favicon.ico
cp /web/penguin.transitionnetwork.org/www/logo.png /web/stats.transitionnetwork.org/piwik/plugins/Morpheus/images/logo.png
cp /web/penguin.transitionnetwork.org/www/logo-header.png /web/stats.transitionnetwork.org/piwik/plugins/Morpheus/images/logo-header.png

But Piwik now uses a SVG logo so that doesn't work:

https://stats.transitionnetwork.org/plugins/Morpheus/images/logo.svg

According to http://dev.piwik.org/trac/ticket/4563 there is now a config option for this.

However the password for the admin account appears to have changed, I'll follow this up with Ed.

Switch recording of stats back on by setting record_statistics to 1 in /web/stats.transitionnetwork.org/piwik/config/config.ini.php:

[Tracker]
record_statistics = 1

hours, status, totalhours changed; resolution set

chris — Tue, 04 Mar 2014 14:58:10 GMT

hours changed from 0.0 to 0.35
status changed from accepted to closed
resolution set to fixed
totalhours changed from 0.85 to 1.2

Looking at:

http://piwik.org/faq/how-to/#faq_191

This seems to be out of date and also the admin user doesn't exist!

So I have made myself a superuser:

mysql stats
mysql> update user set superuser_access="1" where login="chris";

I have got a big logo from https://www.transitionnetwork.org/support/branding

https://www.transitionnetwork.org/sites/www.transitionnetwork.org/files/uploaded/u5857/TransitionNetwork-Logo-Web.jpg

And uploaded that, and recreated the admin account and gave it superuser status via the database as above and updated the wiki page, wiki:PiwikServer

I think this is done, so closing.

Transition Technology: Ticket #697: Piwik 2.1 upgrade for stats.transitionnetwork.org

status, summary changed

summary changed

hours, totalhours changed

hours, status, totalhours changed; resolution set