Transition Technology

Ticket #924 (Sheffield Server Shutdown Timetable?) updated

chris — Mon, 21 Nov 2016 10:50:50 GMT

I see that http://reconomy.org/ is no longer pointing to ParrotServer and that https://patterns.transitionresearchnetwork.org/ is now static HTML, (with a missing HTTPS certificate) and not running on PenguinServer -- does this mean that the Transition Network would like these two servers and the backups of them deleting?

Ticket #692 (Debian Updates) updated

chris — Mon, 21 Nov 2016 10:44:55 GMT

Add Hours to Ticket, Total Hours changed

Debian LTS sudo security update, mysql-5.5 security update and curl security update applied last week on PenguinServer:

2016-11-17      chris
        *       curl/wheezy libcurl3/wheezy libcurl3-gnutls/wheezy : updated
2016-11-16      chris
        *       libmysqlclient-dev/wheezy libmysqlclient18/wheezy mysql-client-5.5/wheezy mysql-common/wheezy mysql-server-5.5/wheezy mysql-server-core-5.5/wheezy sudo/wheezy : updated

And ParrotServer:

2016-11-17      chris
        *       curl/wheezy libcurl3/wheezy libcurl3-gnutls/wheezy : updated
2016-11-16      chris
        *       libmysqlclient18/wheezy mysql-client-5.5/wheezy mysql-common/wheezy mysql-server/wheezy mysql-server-5.5/wheezy mysql-server-core-5.5/wheezy : updated
2016-11-14      chris
        *       sudo/wheezy : updated

Ticket #701 (Emails & Telephone calls) updated

paul — Thu, 17 Nov 2016 12:29:27 GMT

Add Hours to Ticket, Total Hours changed

No drupal security updates need to be applied this week.

There maybe an update later in the week:

View online: https://www.drupal.org/SA-CORE-2016-005

Advisory ID: DRUPAL-SA-CORE-2016-005
Project: Drupal core [1]
Version: 7.x, 8.x
Date: 2016-November-16
Security risk: 13/25 ( Moderately Critical) AC:None/A:None/CI:Some/II:None/E:Theoretical/TD:Uncommon [2]
Vulnerability: Multiple vulnerabilities

Ticket #701 (Emails & Telephone calls) updated

paul — Thu, 10 Nov 2016 14:21:43 GMT

Add Hours to Ticket, Total Hours changed

No drupal security updates need to be applied this week.

Ticket #692 (Debian Updates) updated

chris — Thu, 10 Nov 2016 11:18:12 GMT

Add Hours to Ticket, Total Hours changed

Debian LTS python-imaging security update on PenguinServer:

2016-11-10      chris
        *       python-imaging/wheezy : updated

Ticket #692 (Debian Updates) updated

chris — Sun, 06 Nov 2016 11:06:20 GMT

Add Hours to Ticket, Total Hours changed

Debian LTS tzdata new upstream version on PenguinServer:

2016-11-06      chris
        *       tzdata/wheezy : updated

And ParrotServer:

2016-11-06      chris
        *       tzdata/wheezy : updated

Ticket #692 (Debian Updates) updated

chris — Sun, 06 Nov 2016 09:40:56 GMT

Add Hours to Ticket, Total Hours changed

Debian LTS libxslt security update on PenguinServer:

2016-11-06      chris
        *       libxslt1.1/wheezy : updated

Ticket #924 (Sheffield Server Shutdown Timetable?) updated

chris — Fri, 04 Nov 2016 10:30:15 GMT

It's a month today since you said the sites would be migrated off ParrotServer and PenguinServer within a week, ticket:924#comment:6 -- is there any progress to report or a new date by which you think this work will be completed?

Ticket #692 (Debian Updates) updated

chris — Thu, 03 Nov 2016 10:10:47 GMT

Add Hours to Ticket, Total Hours changed

The Debian LTS libwmf security update email and last night bind9 security update on ParrotServer:

2016-11-02      chris
        *       bind9-host/wheezy dnsutils/wheezy libbind9-80/wheezy libdns88/wheezy libisc84/wheezy libisccc80/wheezy libisccfg82/wheezy liblwres80/wheezy : updated

Ticket #701 (Emails & Telephone calls) updated

paul — Thu, 03 Nov 2016 09:59:30 GMT

Add Hours to Ticket, Total Hours changed

No drupal security updates need to be applied this week.

Ticket #692 (Debian Updates) updated

chris — Wed, 02 Nov 2016 13:48:38 GMT

Add Hours to Ticket, Total Hours changed

Debian LTS libwmf update (no email announcement yet) on PenguinServer:

2016-11-02      chris
        *       libwmf-dev/wheezy libwmf0.2-7/wheezy : updated

And ParrotServer:

2016-11-02      chris
        *       libwmf0.2-7/wheezy : updated

Ticket #692 (Debian Updates) updated

chris — Wed, 02 Nov 2016 13:32:48 GMT

Add Hours to Ticket, Total Hours changed

Debian LTS tiff3 security update and tiff security update on PenguinServer:

2016-11-02      chris
        *       libtiff4/wheezy libtiff4-dev/wheezy libtiffxx0c2/wheezy : updated

And ParrotServer:

2016-11-02      chris
        *       libtiff4/wheezy : updated

Ticket #692 (Debian Updates) updated

chris — Mon, 31 Oct 2016 16:32:26 GMT

Add Hours to Ticket, Total Hours changed

Oops on the last comment I missed reporting Debian LTS tre security update on PenguinServer:

2016-10-27      chris
        *       libtre5/wheezy : updated

Ticket #692 (Debian Updates) updated

chris — Mon, 31 Oct 2016 16:29:33 GMT

Add Hours to Ticket, Total Hours changed

Debian LTS tar security update, cairo security update and ghostscript regression update on PenguinServer:

2016-10-31      chris
        *       libxml2/wheezy libxml2-dev/wheezy libxml2-utils/wheezy tar/wheezy : updated
2016-10-28      chris
        *       libcairo-gobject2/wheezy libcairo-script-interpreter2/wheezy libcairo2/wheezy libcairo2-dev/wheezy : updated
2016-10-28      chris
        *       ghostscript/wheezy libgs9/wheezy libgs9-common/wheezy : updated

And ParrotServer:

2016-10-31      chris
        *       libxml2/wheezy tar/wheezy : updated
2016-10-28      chris
        *       libcairo2/wheezy : updated
2016-10-28      chris
        *       ghostscript/wheezy libgs9/wheezy libgs9-common/wheezy : updated

Ticket #692 (Debian Updates) updated

chris — Thu, 27 Oct 2016 10:24:29 GMT

Add Hours to Ticket, Total Hours changed

Debian LTS libx11 security update, libxi security update and libxtst security update on PenguinServer:

2016-10-27      chris
        *       libx11-6/wheezy libx11-data/wheezy libx11-dev/wheezy libx11-xcb1/wheezy libxi-dev/wheezy libxi6/wheezy libxtst6/wheezy : updated

And ParrotServer:

2016-10-27      chris
        *       libx11-6/wheezy libx11-data/wheezy libxi6/wheezy : updated

Ticket #701 (Emails & Telephone calls) updated

paul — Wed, 26 Oct 2016 22:55:21 GMT

Add Hours to Ticket, Total Hours changed

No drupal security updates need to be applied this week.

Ticket #692 (Debian Updates) updated

chris — Wed, 26 Oct 2016 20:08:04 GMT

Add Hours to Ticket, Total Hours changed

Debian LTS bash security update and TZ update on PenguinServer:

2016-10-26      chris
        *       tzdata/wheezy : updated
2016-10-26      chris
        *       bash/wheezy : updated

And ParrotServer:

2016-10-26      chris
        *       tzdata/wheezy : updated
2016-10-26      chris
        *       bash/wheezy : updated

Ticket #924 (Sheffield Server Shutdown Timetable?) updated

chris — Tue, 25 Oct 2016 13:20:26 GMT

Any news on the progress made on the migration of https://patterns.transitionresearchnetwork.org/ and http://reconomy.org/ to new servers and when PenguinServer and ParrotServer are to be switched off?

Replying to chris:

Has any progress been made on this?

Replying to chris:

Replying to chris:

What is the plan for the two main sites running on PenguinServer and ParrotServer?

https://patterns.transitionresearchnetwork.org/
http://reconomy.org/

Replying to sam:

We're in the process of migrating them to a Hetzner server. It should be
complete and tested by this time next week. I'll confirm with you when
we're ready to switch them off at your end.

Any update on this?

Ticket #692 (Debian Updates) updated

chris — Tue, 25 Oct 2016 13:17:15 GMT

Add Hours to Ticket, Total Hours changed

Debian LTS ghostscript security update on PenguinServer:

2016-10-25      chris
        *       ghostscript/wheezy libgs9/wheezy libgs9-common/wheezy : updated

And ParrotServer:

2016-10-25      chris
        *       ghostscript/wheezy libgs9/wheezy libgs9-common/wheezy : updated

Ticket #692 (Debian Updates) updated

chris — Thu, 20 Oct 2016 18:15:17 GMT

Add Hours to Ticket, Total Hours changed

Debian LTS bind9 security update on ParrotServer:

2016-10-20      chris
        *       bind9-host/wheezy dnsutils/wheezy libbind9-80/wheezy libdns88/wheezy libisc84/wheezy libisccc80/wheezy libisccfg82/wheezy liblwres80/wheezy : updated

Ticket #701 (Emails & Telephone calls) updated

paul — Thu, 20 Oct 2016 12:11:20 GMT

Add Hours to Ticket, Total Hours changed

There were drupal security updates that needed to be applied this week:

Issue status update for:
https://www.drupal.org/node/2820535

#2 -- October 19, 2016 - 17:34 : dsnopek
https://www.drupal.org/node/2820535#comment-11738607

Issue changes:

Status: Active

+ Status: Fixed
Committed to repo!

Current issue values:
Status: Fixed
Priority: Normal
Category: Task
Component: Code
Assigned: Unassigned
Project: Drupal 6 Long Term Support
Files: SA-CONTRIB-2016-053.patch [1]
Reporter: dsnopek [2]
Created: October 19, 2016 - 17:33
Updated: October 19, 2016 - 17:34

[1] https://www.drupal.org/files/issues/SA-CONTRIB-2016-053.patch
[2] https://www.drupal.org/u/dsnopek

transx@dedi2835:~/public_html/sites/all/modules/contrib/webform$ wget https://www.drupal.org/files/issues/SA-CONTRIB-2016-053.patch
--2016-10-20 13:41:14-- https://www.drupal.org/files/issues/SA-CONTRIB-2016-053.patch
Resolving www.drupal.org (www.drupal.org)... 151.101.13.133
Connecting to www.drupal.org (www.drupal.org)|151.101.13.133|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1631 (1.6K) [text/plain]
Saving to: ‘SA-CONTRIB-2016-053.patch’

SA-CONTRIB-2016-053.patch 100%[=========================================================================>] 1.59K --.-KB/s in 0s

2016-10-20 13:41:14 (41.6 MB/s) - ‘SA-CONTRIB-2016-053.patch’ saved [1631/1631]

transx@dedi2835:~/public_html/sites/all/modules/contrib/webform$ ls
CHANGELOG.txt css includes LICENSE.txt SA-CONTRIB-2016-053.patch tests views webform.info webform.module
components images js README.txt templates THEMING.txt webform.api.php webform.install
transx@dedi2835:~/public_html/sites/all/modules/contrib/webform$ patch -p1 < SA-CONTRIB-2016-053.patch
patching file webform.module

Downloaded a recent copy of the database. Shall I check that we can recover from these database backups on my local network?

Ticket #924 (Sheffield Server Shutdown Timetable?) updated

chris — Thu, 20 Oct 2016 09:42:50 GMT

Has any progress been made on this?

Replying to chris:

Replying to chris:

What is the plan for the two main sites running on PenguinServer and ParrotServer?

https://patterns.transitionresearchnetwork.org/
http://reconomy.org/

Replying to sam:

We're in the process of migrating them to a Hetzner server. It should be
complete and tested by this time next week. I'll confirm with you when
we're ready to switch them off at your end.

Any update on this?

Ticket #692 (Debian Updates) updated

chris — Thu, 20 Oct 2016 09:36:55 GMT

Add Hours to Ticket, Total Hours changed

Debian LTS linux security update on PenguinServer:

2016-10-20      chris
        *       libxv1/wheezy linux-libc-dev/wheezy : updated

And ParrotServer:

2016-10-20      chris
        *       linux-libc-dev/wheezy : updated

Ticket #692 (Debian Updates) updated

chris — Tue, 18 Oct 2016 19:24:41 GMT

Add Hours to Ticket, Total Hours changed

Debian LTS libgd2-xpm update on PenguinServer:

2016-10-18      chris
        *       libgd2-xpm/wheezy : updated

And ParrotServer:

2016-10-18      chris
        *       libgd2-xpm/wheezy : updated

Ticket #692 (Debian Updates) updated

chris — Tue, 18 Oct 2016 14:28:26 GMT

Add Hours to Ticket, Total Hours changed

Debian LTS libxrender security update on PenguinServer:

2016-10-18      chris
        *       libxrender-dev/wheezy libxrender1/wheezy : updated

And Parrot:Server:

2016-10-18      chris
        *       libxrender1/wheezy : updated

Ticket #692 (Debian Updates) updated

chris — Mon, 17 Oct 2016 16:51:02 GMT

Add Hours to Ticket, Total Hours changed

Debian LTS libxrandr2 security update on PenguinServer:

2016-10-17      chris
        *       libxrandr-dev/wheezy libxrandr2/wheezy : updated

And ParrotServer:

2016-10-17      chris
        *       libxrandr2/wheezy : updated

Ticket #692 (Debian Updates) updated

chris — Mon, 17 Oct 2016 08:06:36 GMT

Add Hours to Ticket, Total Hours changed

Debian LTS libsystemd-login update on PenguinServer:

2016-10-17      chris
        *       libsystemd-login0/wheezy : updated

ParrotServer:

2016-10-17      chris
        *       libsystemd-login0/wheezy : updated

Ticket #692 (Debian Updates) updated

chris — Sat, 15 Oct 2016 16:47:38 GMT

Add Hours to Ticket, Total Hours changed

Debian LTS libdbd-mysql-perl security update on PenguinServer:

2016-10-15      chris
        *       libdbd-mysql-perl/wheezy : updated

And ParrotServer:

2016-10-15      chris
        *       libdbd-mysql-perl/wheezy : updated

Ticket #924 (Sheffield Server Shutdown Timetable?) updated

chris — Fri, 14 Oct 2016 09:41:38 GMT

Replying to chris:

What is the plan for the two main sites running on PenguinServer and ParrotServer?

https://patterns.transitionresearchnetwork.org/
http://reconomy.org/

Replying to sam:

We're in the process of migrating them to a Hetzner server. It should be
complete and tested by this time next week. I'll confirm with you when
we're ready to switch them off at your end.

Any update on this?

Ticket #692 (Debian Updates) updated

chris — Fri, 14 Oct 2016 09:35:43 GMT

Add Hours to Ticket, Total Hours changed

Debian LTS libxfixes security update on PenguinServer:

2016-10-14      chris
        *       libxfixes-dev/wheezy libxfixes3/wheezy : updated

And ParrotServer:

2016-10-14      chris
        *       libxfixes3/wheezy : updated

Ticket #701 (Emails & Telephone calls) updated

paul — Thu, 13 Oct 2016 14:48:01 GMT

Add Hours to Ticket, Total Hours changed

There were drupal security updates that needed to be applied this week:

Issue status update for:
https://www.drupal.org/node/2817359

Current issue values:
Status: Needs review
Priority: Normal
Category: Task
Component: Code
Assigned: Unassigned
Project: Drupal 6 Long Term Support
Files: elysia_cron-sa-contrib-2016-052.patch [1]
Reporter: dsnopek [2]
Created: October 12, 2016 - 17:15
Updated: October 12, 2016 - 17:15
An SA was just published for elysia_cron:

https://www.drupal.org/node/2817211 [3]

The D6LTS vendors backported the patch to D6 which is attached

[1] https://www.drupal.org/files/issues/elysia_cron-sa-contrib-2016-052.patch
[2] https://www.drupal.org/u/dsnopek
[3] https://www.drupal.org/node/2817211

One of the hunks failed. The function was different to what was expected; the update was manually applied.

transx@dedi2835:~/public_html/sites/all/modules/contrib/elysia_cron$ patch -p1 < elysia_cron-sa-contrib-2016-052.patch
patching file elysia_cron.admin.inc
Hunk #1 FAILED at 99.
Hunk #2 succeeded at 554 (offset -46 lines).
1 out of 2 hunks FAILED -- saving rejects to file elysia_cron.admin.inc.rej
transx@dedi2835:~/public_html/sites/all/modules/contrib/elysia_cron$ cat elysia_cron.admin.inc.rej

--- elysia_cron.admin.inc
+++ elysia_cron.admin.inc
@@ -99,7 +99,7 @@ function elysia_cron_admin_page() {
         );
         $rows[] = array(
           '',
-          $conf['rule'] . (!empty($conf['weight']) ? ' <small>(' . t('Weight') . ': ' . $conf['weight'] . ')</small>' : ''),
+          check_plain($conf['rule']) . (!empty($conf['weight']) ? ' <small>(' . t('Weight') . ': ' . $conf['weight'] . ')</small>' : ''),
           elysia_cron_date($conf['last_run']),
           $conf['last_execution_time'] . 's',
           $conf['execution_count'],

Ticket #701 (Emails & Telephone calls) updated

paul — Tue, 11 Oct 2016 17:10:17 GMT

Add Hours to Ticket, Total Hours changed

No drupal security updates need to be applied this week.

https://www.drupal.org/psa-2016-003

https://transitionnetwork.org/admin/settings/webform
https://transitionnetwork.org/admin/settings/uploads
https://transitionnetwork.org/admin/user/permissions#module-upload

Ticket #926 (TLS cert for patterns.transitionresearchnetwork.org) closed

chris — Mon, 10 Oct 2016 12:28:32 GMT

fixed

Ticket #926 (TLS cert for patterns.transitionresearchnetwork.org) updated

chris — Mon, 10 Oct 2016 12:28:20 GMT

Add Hours to Ticket, Total Hours changed

Getting and installing a Let's Encrypt cert:

sudo -i
wget -O - https://get.acme.sh | sh
source ~/.bashrc
acme.sh --issue -d patterns.transitionresearchnetwork.org -d www.patterns.transitionresearchnetwork.org -d wagn.transitionnetwork.org -d wagn-phusion.penguin.webarch.net -w /web/patterns.transitionresearchnetwork.org/patterns/public
mkdir /etc/ssl/letsencrypt
chmod 700 /etc/ssl/letsencrypt
vi /etc/nginx/sites-available/patterns
acme.sh --installcert -d patterns.transitionresearchnetwork.org --certpath /etc/ssl/letsencrypt/patterns.crt.pem --keypath /etc/ssl/letsencrypt/patterns.key.pem --capath /etc/ssl/letsencrypt/patterns.ca.pem --fullchainpath /etc/ssl/letsencrypt/patterns.chain.pem --reloadcmd 'service nginx restart'

And checking:

https://www.ssllabs.com/ssltest/analyze.html?d=wagn.transitionnetwork.org&latest

That looks good, so closing.

Ticket #926 (TLS cert for patterns.transitionresearchnetwork.org) updated

chris — Mon, 10 Oct 2016 12:10:52 GMT

I haven't heard that this is is going to be migrated today so I'll get a new cert for it now.

Ticket #926 (TLS cert for patterns.transitionresearchnetwork.org) created

chris — Mon, 10 Oct 2016 07:09:48 GMT

The Gandi cert for https://patterns.transitionresearchnetwork.org/ is due to expire today, is the site going to have been mirated off PenguinServer by the end of today or should I get a new cert for the site?

Ticket #692 (Debian Updates) updated

chris — Fri, 07 Oct 2016 08:46:06 GMT

Add Hours to Ticket, Total Hours changed

Debian LTS c-ares security update on PenguinServer:

2016-10-07      chris
        *       libc-ares2/wheezy : updated

Ticket #701 (Emails & Telephone calls) updated

paul — Thu, 06 Oct 2016 14:08:44 GMT

Add Hours to Ticket, Total Hours changed

No drupal security updates need to be applied this week.

Ticket #925 (Piwik 2.16.3) updated

sam — Tue, 04 Oct 2016 13:50:05 GMT

Hi Chris, thanks.
All I meant is it would be great if you could not delete it from your
server until we give you confirmation next week.
Thanks
Sam
On 4 October 2016 at 14:41, Transition Technology Trac <
trac@tech.transitionnetwork.org> wrote:
> #925: Piwik 2.16.3
> ----------------------------------+-----------------------------------
>            Reporter:  chris       |                      Owner:  chris
>                Type:  defect      |                     Status:  new
>            Priority:  critical    |                  Milestone:
>           Component:  Unassigned  |                 Resolution:
>            Keywords:              |  Estimated Number of Hours:  0.0
> Add Hours to Ticket:  0.1         |                  Billable?:  1
>         Total Hours:  0.75        |
> ----------------------------------+-----------------------------------
> Changes (by chris):
>
>  * hours:  0.0 => 0.1
>  * totalhours:  0.75 => 0.85
>
>
> Comment:
>
>  Replying to [comment:4 sam]:
>  >
>  > Could you stop working on this ticket please.
>
>  OK, but in order to reply to you I have to work on it... but point taken,
>  I won't upgrade the site to the [https://piwik.org/changelog/
> piwik-2-16-4/
>  latest version].
>
>  > We're now using google analytics so it's now a legacy machine.
>
>  OK
>
>  > Would be great to retain access to it for a few days though so I can
>  make
>  > sure all the data we need is out of there/ set up on Google.
>
>  How do you not have access to it? Do you need to reset the password? If so
>  there is a link for that at the bottom of the page here:
>
>  * https://stats.transitionnetwork.org/
>
> --
> Ticket URL: <https://tech.transitionnetwork.org/trac/ticket/925#comment:5>
> Transition Technology <https://tech.transitionnetwork.org/trac>
> Support and issues tracking for the Transition Network Web Project.
>

Ticket #925 (Piwik 2.16.3) updated

chris — Tue, 04 Oct 2016 13:47:07 GMT

Also note that although you have removed the Piwik webbug from http://transitionnetwork.org/ this server is still collecting data from other sites, Reconomy, the Movie site and archives:

All_Websites_dashboard_Tuesday_October_4_2016_Web_Analytics_Reports.png attached to Ticket #925

chris — Tue, 04 Oct 2016 13:45:48 GMT

All Websites dashboard - Tuesday, October 4, 2016 - Web Analytics Reports -.png attached to Ticket #925

chris — Tue, 04 Oct 2016 13:42:53 GMT

Ticket #925 (Piwik 2.16.3) updated

chris — Tue, 04 Oct 2016 13:41:22 GMT

Add Hours to Ticket, Total Hours changed

Replying to sam:

Could you stop working on this ticket please.

OK, but in order to reply to you I have to work on it... but point taken, I won't upgrade the site to the latest version.

We're now using google analytics so it's now a legacy machine.

Would be great to retain access to it for a few days though so I can make
sure all the data we need is out of there/ set up on Google.

How do you not have access to it? Do you need to reset the password? If so there is a link for that at the bottom of the page here:

https://stats.transitionnetwork.org/

Ticket #924 (Sheffield Server Shutdown Timetable?) updated

sam — Tue, 04 Oct 2016 13:35:04 GMT

Hi Chris
This is now working, I've grabbed the backups.
Thanks.
Sam
On 4 October 2016 at 13:16, Transition Technology Trac <
trac@tech.transitionnetwork.org> wrote:
> #924: Sheffield Server Shutdown Timetable?
> -----------------------------------+-----------------------------------
>            Reporter:  chris        |                      Owner:  chris
>                Type:  maintenance  |                     Status:  new
>            Priority:  minor        |                  Milestone:
>           Component:  Live server  |                 Resolution:
>            Keywords:               |  Estimated Number of Hours:  0.0
> Add Hours to Ticket:  0.25         |                  Billable?:  1
>         Total Hours:  1.15         |
> -----------------------------------+-----------------------------------
> Changes (by chris):
>
>  * hours:  0.0 => 0.25
>  * totalhours:  1.15 => 1.4
>
>
> Comment:
>
>  Replying to [comment:12 sam]:
>  >
>  > This is still giving a 404 though:
>  https://penguin.transitionnetwork.org/info/stats.gz
>
>  Really sorry about that, the file is actually `stats.sql.gz`, so the URL
>  is:
>
>  * https://penguin.transitionnetwork.org/info/stats.sql.gz
>
>  However this generates a 403 and I think this is due to the size of the
>  file, and this is the case, in `/etc/nginx/nginx.conf` there was:
>
>  {{{
>          client_max_body_size 200M;
>  }}}
>
>  So that has been changed to:
>
>  {{{
>          client_max_body_size 2G;
>  }}}
>
>  And Nginx has been restarted.
>
>  Also the file needed to be chmod'ed:
>
>  {{{
>  chmod 644 /web/penguin.transitionnetwork.org/www/info/stats.sql.gz
>  }}}
>
>  Sam, can you try again?
>
>  * https://penguin.transitionnetwork.org/info/stats.sql.gz
>
> --
> Ticket URL: <https://tech.transitionnetwork.org/trac/ticket/924#comment:13
> >
> Transition Technology <https://tech.transitionnetwork.org/trac>
> Support and issues tracking for the Transition Network Web Project.
>

Ticket #925 (Piwik 2.16.3) updated

sam — Tue, 04 Oct 2016 13:35:03 GMT

Hi Chris
Could you stop working on this ticket please.
We're now using google analytics so it's now a legacy machine.
Would be great to retain access to it for a few days though so I can make
sure all the data we need is out of there/ set up on Google.
Thanks
Sam
On 4 October 2016 at 10:24, Transition Technology Trac <
trac@tech.transitionnetwork.org> wrote:
> #925: Piwik 2.16.3
> ----------------------------------+-----------------------------------
>            Reporter:  chris       |                      Owner:  chris
>                Type:  defect      |                     Status:  new
>            Priority:  critical    |                  Milestone:
>           Component:  Unassigned  |                 Resolution:
>            Keywords:              |  Estimated Number of Hours:  0.0
> Add Hours to Ticket:  0.25        |                  Billable?:  1
>         Total Hours:  0.5         |
> ----------------------------------+-----------------------------------
> Changes (by chris):
>
>  * hours:  0.0 => 0.25
>  * totalhours:  0.5 => 0.75
>
>
> Comment:
>
>  Request [https://forum.piwik.org/t/array-to-string-conversion-
>  piwik-2-16-3/21178/4 from the Piwik developers]:
>
>  > Can you look in PHP info output, what is your PDO and pdo_mysql
>  versions?
>
>  So following the link from the documentation at
>  PenguinServer#APCStatsandPHPinfo we have:
>
>  [[Image(penguin_phpinfo_pdo.png)]]
>
>  The above has been [https://forum.piwik.org/t/array-to-string-conversion-
>  piwik-2-16-3/21178/6 posted in the forum] as requested.
>
> --
> Ticket URL: <https://tech.transitionnetwork.org/trac/ticket/925#comment:2>
> Transition Technology <https://tech.transitionnetwork.org/trac>
> Support and issues tracking for the Transition Network Web Project.
>

Ticket #924 (Sheffield Server Shutdown Timetable?) updated

chris — Tue, 04 Oct 2016 12:16:11 GMT

Add Hours to Ticket, Total Hours changed

Replying to sam:

This is still giving a 404 though: https://penguin.transitionnetwork.org/info/stats.gz

Really sorry about that, the file is actually stats.sql.gz, so the URL is:

https://penguin.transitionnetwork.org/info/stats.sql.gz

However this generates a 403 and I think this is due to the size of the file, and this is the case, in /etc/nginx/nginx.conf there was:

        client_max_body_size 200M;

So that has been changed to:

        client_max_body_size 2G;

And Nginx has been restarted.

Also the file needed to be chmod'ed:

chmod 644 /web/penguin.transitionnetwork.org/www/info/stats.sql.gz

Sam, can you try again?

https://penguin.transitionnetwork.org/info/stats.sql.gz

Ticket #924 (Sheffield Server Shutdown Timetable?) updated

sam — Tue, 04 Oct 2016 12:00:50 GMT

Hi Chris
Thanks, I've saved the Trac one.
This is still giving a 404 though: https://penguin.
transitionnetwork.org/info/stats.gz
Thanks
Sam
On 4 October 2016 at 12:43, Transition Technology Trac <
trac@tech.transitionnetwork.org> wrote:
> #924: Sheffield Server Shutdown Timetable?
> -----------------------------------+-----------------------------------
>            Reporter:  chris        |                      Owner:  chris
>                Type:  maintenance  |                     Status:  new
>            Priority:  minor        |                  Milestone:
>           Component:  Live server  |                 Resolution:
>            Keywords:               |  Estimated Number of Hours:  0.0
> Add Hours to Ticket:  0.15         |                  Billable?:  1
>         Total Hours:  1.0          |
> -----------------------------------+-----------------------------------
> Changes (by chris):
>
>  * hours:  0.0 => 0.15
>  * totalhours:  1.0 => 1.15
>
>
> Comment:
>
>  Replying to [comment:8 sam]:
>  >
>  > Thanks for this. When I visit
>  https://penguin.transitionnetwork.org/info/
>  > trac.backup.tgz I see a page of symbols in my browser (see attached)
>
>  This means that the `tgz` is being served as `text/plain` so checking
>  `/etc/nginx/mine.types` there is no entry for `tgz` files so the following
>  lines were added and Nginx restarted:
>
>  {{{
>      application/x-gtar-compressed                   tgz;
>      application/gzip                                gz;
>  }}}
>
>  > And https://penguin.transitionnetwork.org/info/stats.gz is giving a 404
>  > (see attached)
>
>  Sorry about that, the following typo in the Ngnix config:
>
>  {{{
>          location = /info/stats.gz {
>                  alias
>  /web/penguin.transitionnetwork.org/www/info/stats.tgz;
>  }}}
>
>  Was the cause, this has now been corrected.
>
> --
> Ticket URL: <https://tech.transitionnetwork.org/trac/ticket/924#comment:9>
> Transition Technology <https://tech.transitionnetwork.org/trac>
> Support and issues tracking for the Transition Network Web Project.
>

Ticket #924 (Sheffield Server Shutdown Timetable?) updated

chris — Tue, 04 Oct 2016 11:43:30 GMT

Add Hours to Ticket, Total Hours changed

Replying to sam:

Thanks for this. When I visit https://penguin.transitionnetwork.org/info/
trac.backup.tgz I see a page of symbols in my browser (see attached)

This means that the tgz is being served as text/plain so checking /etc/nginx/mine.types there is no entry for tgz files so the following lines were added and Nginx restarted:

    application/x-gtar-compressed                   tgz;
    application/gzip                                gz;

And https://penguin.transitionnetwork.org/info/stats.gz is giving a 404
(see attached)

Sorry about that, the following typo in the Ngnix config:

        location = /info/stats.gz {
                alias   /web/penguin.transitionnetwork.org/www/info/stats.tgz;

Was the cause, this has now been corrected.

file.png attached to Ticket #924

sam — Tue, 04 Oct 2016 11:35:06 GMT

Added by email2trac

nofiles.png attached to Ticket #924

sam — Tue, 04 Oct 2016 11:35:06 GMT

Added by email2trac