Transition Technology: Ticket #537: Parrot setup and documentation

type, component changed

chris — Tue, 30 Apr 2013 11:13:11 GMT

type changed from defect to maintenance
component changed from Unassigned to Parrot server

hours, totalhours changed

chris — Tue, 30 Apr 2013 13:41:36 GMT

hours changed from 0.0 to 2.5
totalhours changed from 0.0 to 2.5

The server has been installed and the following tasks have been completed:

An ssh account for jim has been added
Munin has been set up, https://penguin.transitionnetwork.org/munin/transitionnetwork.org/parrot.transitionnetwork.org/
A http://cacert.org/ certificate has been generated, details: wiki:ParrotServer#SSLCert
Created a default splash page and associated 404 etc pages, http://parrot.webarch.net/
Added an additional IP address for intransitionmovie.com, 81.95.52.39
Reverse DNS has been set up for both IP addresses
Movie site migrated, DNS updated needed: http://movie.parrot.webarch.net/
Earthinheritors site migrated, DNS updated needed: http://earthin.parrot.webarch.net/

I haven't migrated the Reconomy site as it's massive, 7.7G, due to some unneeded backups and also it looks like it might be compromised, there are a couple of very dodgy looking scripts installed -- more investigation needed.

Ed -- would it be OK to move the movie and earthinheritors sites later tonight?

TODO:

Backups!

ed — Tue, 30 Apr 2013 16:14:25 GMT

Approved to move EI and ITmovie sites tonight - please confirm there will be no change in access or service?
REconomy - do I need to get involved in some way - can I help?

hours, totalhours changed

chris — Tue, 30 Apr 2013 17:34:35 GMT

hours changed from 0.0 to 0.5
totalhours changed from 2.5 to 3.0

Current backup space usage:

7.0G    ./puffin
7.7G    ./penguin
334G    ./quince
39G     ./kiwi

Most of the quince backups are from /var/backups/mysql -- 144G -- this has daily database dumps going back to 2011-12-01, can I assume it's safe to delete most of these?

Backups have been set up for parrot.

I'll email the site admins about the server move and investigate REconomy some more.

hours, totalhours changed

chris — Tue, 30 Apr 2013 20:33:36 GMT

hours changed from 0.0 to 1.0
totalhours changed from 3.0 to 4.0

The http://www.earthinheritors.net/ site will be migrated when the DNS has fully updated, this is a straight forward site, no plugins and no recent content. I still have to configure the Piwik plugin.

The http://www.intransitionmovie.com/ site will also be migrated when the DNS has updated, this is a complicated ecommerce site with quite a few plugins and also quite a lot of traffic, I have raised a ticket for updates to this site, ticket:538.

I have sent a email to the admin of http://www.reconomy.org/ raising 3 concerns, the 7GB of backups, two dubious looking perl scripts and the fact that the site doesn't work with the command line tool http://wp-cli.org/.

hours, totalhours changed

chris — Wed, 01 May 2013 20:28:30 GMT

hours changed from 0.0 to 0.6
totalhours changed from 4.0 to 4.6

I have created the following wiki pages for documenting the sites:

And opened the following tickets:

ticket:540 HTTPS for WordPress sites
ticket:541 Documentation of the WordPress sites

The documentation of the wiki:ParrotServer might as well be tracked on this ticket.

hours, totalhours changed

chris — Thu, 02 May 2013 09:53:59 GMT

hours changed from 0.0 to 1.0
totalhours changed from 4.6 to 5.6

I have done some work on the documentation:

wiki:ParrotServer#SSLCerts notes on the SSL certs and link to the ticket about this issue
wiki:ParrotServer#AddingaNewWordPressSite notes on how to add a new site to the server
wiki:ParrotServer#Addingadomaintoasite notes on adding a domain to a site
wiki:ParrotServer#Changingthedefaultdomainofasite notes on changing the domain of a site
wiki:ParrotServer#SFTPAccess notes on SFTP access
wiki:ParrotServer#PhpmyadminAccess notes on phpmyadmin access
wiki:WordPress#wp notes on the wp command line interface for working on sites

I think that will do for the general documentation for now, more work is needed on the site specific documentation and also I'll do some on how to set up Piwik for WordPress.

milestone set

ed — Thu, 09 May 2013 09:40:46 GMT

milestone set to Maintenance

hours, totalhours changed

chris — Thu, 09 May 2013 12:49:57 GMT

hours changed from 0.0 to 0.25
totalhours changed from 5.6 to 5.85

A chat between Chris and Ed about the wiki:ParrotServer and the wiki:WordPress site migrations is due to take place on Tuesday 14th May. The context of the scheduled call is the two times the server went down last week, due to it running out of memory, see ticket:542

Items we might cover in the call:

Communications, how can we better communicate with the admins of the WordPress sites
RAM, started with 1GB now 2GB RAM, see ticket:542
Performance, can we decrease the load times though:
1. Reducing the number of requests, see wiki:ReconomyWordPress#Performance and wiki:InTransitionWordPress#Performance
2. Adding a Varnish reverse proxy
Parrot setup and documentation, see ticket:537
HTTPS for WordPress sites, see ticket:540
REconomy site migration and updates, see ticket:539
intransitionmovie.com checks and updates, see ticket:538

hours, totalhours changed

chris — Tue, 14 May 2013 10:54:07 GMT

hours changed from 0.0 to 0.75
totalhours changed from 5.85 to 6.6

Some notes I took during our chat:

Chris to email Ed with a list of admins for a Mailman list.
Agreed to reep the extra 1GB RAM.
Performance, to be considered next time the sites have some development work.

hours, totalhours changed

chris — Fri, 29 Nov 2013 13:36:26 GMT

hours changed from 0.0 to 0.4
totalhours changed from 6.6 to 7.0

Generating a list of admins for a Mailman list:

sudo -i
su-user ttt
cd sites/default/
wp user list | grep "administrator"
cd sites/default/
su-user earthin
PHP Fatal error:  Call to undefined function get_post_format_slugs() in /home/earthin/sites/default/wp-includes/theme.php on line 1264
su-user movie
cd sites/default/
wp user list | grep "administrator"
su-user recon
cd sites/default/
wp user list | grep "administrator"
su-user ts
cd sites/default/
wp user list | grep "administrator"

For earthin:

su-user earthin
grep PASSWORD sites/default/wp-config.php
mysql -uearthin -p earthin
mysql> SELECT ID,user_login,user_nicename,user_email FROM wp_users;

chris — Wed, 02 Apr 2014 10:25:04 GMT

Not closing this yet as there are these outstanding issues:

A email list for admins / people responsible for WordPress sites on wiki:ParrotServer
ticket:540 HTTPS for WordPress sites
ticket:541 Documentation of the WordPress sites