hours, estimatedhours, status, totalhours changed

chris — Fri, 08 May 2015 10:45:02 GMT

hours changed from 0.0 to 0.25
estimatedhours changed from 0.25 to 0.5
status changed from new to accepted
totalhours changed from 0.0 to 0.25

vi /web/stats.transitionnetwork.org/piwik/config/config.ini.php
cd /web/stats.transitionnetwork.org/
cp piwik/config/config.ini.php .
export PIWIK="2.13.1"
wget "https://builds.piwik.org/piwik-$PIWIK.tar.gz"
  HTTP request sent, awaiting response... 404 Not Found
wget "https://builds.piwik.org/piwik-$PIWIK.tar.gz.asc"
  HTTP request sent, awaiting response... 404 Not Found

Checking at https://builds.piwik.org/?C=M;O=D it looks like there is a .zip file but no .tgz, so:

wget "https://builds.piwik.org/piwik-$PIWIK.zip"
wget "https://builds.piwik.org/piwik-$PIWIK.zip.asc"
gpg --verify piwik-$PIWIK.zip.asc
  gpg: Signature made Thu May  7 00:52:31 2015 BST using RSA key ID 5590A237
  gpg: BAD signature from "Matthieu Aubry <matt@piwik.org>"

This bad sigs has been raised in this ticket and the missing .tgz files in this ticket.

Resetting the record stats variable and waiting for the two Piwik tickets on Github to be resolved.

vi /web/stats.transitionnetwork.org/piwik/config/config.ini.php

hours, status, totalhours changed; resolution set

chris — Tue, 19 May 2015 09:28:17 GMT

hours changed from 0.0 to 0.15
status changed from accepted to closed
resolution set to fixed
totalhours changed from 0.25 to 0.4

The GPG sigs and TGZ files have now been uploadfed, see the links to the tickets in the comment above.

Following wiki:PiwikServer#Updates

sudo -i
cd /web/stats.transitionnetwork.org/
vi /web/stats.transitionnetwork.org/piwik/config/config.ini.php
cp piwik/config/config.ini.php .
export PIWIK="2.13.1"
wget "https://builds.piwik.org/piwik-$PIWIK.tar.gz"
gpg --verify piwik-$PIWIK.tar.gz.asc
gpg: Signature made Tue May 12 13:56:25 2015 BST using RSA key ID 5590A237
gpg: Good signature from "Matthieu Aubry <matt@piwik.org>"
gpg: aka "Matthieu Aubry <matt@piwik.pro>"
gpg: aka "Matthieu Aubry <matthieu.aubry@gmail.com>"
gpg: WARNING: This key is not certified with a trusted signature!
gpg: There is no indication that the signature belongs to the owner.
Primary key fingerprint: 814E 346F A01A 20DB B04B 6807 B5DB D592 5590 A237
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/console core:update
*** 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.13.0 to the new version 2.13.1.
*** Note: this is a Dry Run ***
delete from `option` where option_name like '%defaultReport%' and option_value='';
*** End of Dry Run ***
A database upgrade is required. Execute update? (y/N) y
Starting the database upgrade process now. This may take a while, so please be patient.
*** 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.13.0 to the new version 2.13.1.
The database upgrade process may take a while, so please be patient.
Executing delete from `option` where option_name like '%defaultReport%' and option_value=''... Done. [1 / 1]
****************************************
Piwik has been successfully updated!
****************************************
/etc/init.d/php5-fpm restart
vi /web/stats.transitionnetwork.org/piwik/config/config.ini.php

The system check was done using the web interface and everything seems fine, colsing this ticket.

Transition Technology: Ticket #850: Piwik 2.13.1

hours, estimatedhours, status, totalhours changed

hours, status, totalhours changed; resolution set