Parrot setup and documentation

[chris]

Things done setting up parrot.webarch.net -- a new virtual machine for running Wordpress sites, see wiki:ParrotServer

[chris]

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]

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

[chris]

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.

[chris]

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/.

[chris]

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

• ReconomyWordPress
• InTransitionWordPress
• EarthInheritorsWordPress

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.

[chris]

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.

[chris]

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:

1. Communications, how can we better communicate with the admins of the WordPress sites
2. RAM, started with 1GB now 2GB RAM, see ticket:542
3. 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
4. Parrot setup and documentation, see ticket:537
5. HTTPS for WordPress sites, see ticket:540
6. REconomy site migration and updates, see ticket:539
7. intransitionmovie.com checks and updates, see ticket:538

[chris]

Some notes I took during our chat:

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

[chris]

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]

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