Transition Technology: Ticket Query

#391: PSE tracking, moderation and security

chris — Thu, 02 Feb 2012 11:30:00 GMT

This ticket is track time spent on the Tracking, Moderation and Security discussion which has a wiki page here: https://wiki.transitionnetwork.org/Sharing_Engine/Tracking,_Moderation_and_Security

#392: PSE Server Upgrade

chris — Thu, 02 Feb 2012 12:53:41 GMT

This ticket has been created to discuss and implement and upgrade to the wiki:NewLiveServer

#396: Migrate MySQL Databases from MyISAM to InnoDB

chris — Thu, 23 Feb 2012 15:32:33 GMT

This should result in things being faster, however there are some potential new issues that it would create, see for example The perils of InnoDB with Debian and startup scripts.

There is also an issue with the one !InnoDB table on kiwi which will need investigation and fixing, the dev Mediawiki database backup fails each night, this is the error:

Warning: mysqldump: Got error: 1286: Unknown table engine 'InnoDB' when using LOCK TABLES
Warning: Failed to dump mysql databases transwiki

#397: Live server RAM and disk upgrade

chris — Thu, 23 Feb 2012 15:54:04 GMT

The live server is all set to have the additional 1GB of RAM added to it, it just needs a reboot at an appropriate time for this to become available. Once it's available configurations changes will be needed to Apache, Varnish etc to enable applications to make use of it.

In addition to upgrading the RAM we have made a new 15GB partition available to the virtual machine (it'll only appear after a reboot) with the intention of using this for the !MySQL databases. This partition is on a pair of mirrored SCSI disks, the rest of the virtual machine is on a pair of SATA disks.

A quick test of the new partition disk speeds:

 hdparm -tT /dev/FastDisk/quince-var-lib-mysql
/dev/FastDisk/quince-var-lib-mysql:
 Timing cached reads:   3626 MB in  2.00 seconds = 1815.54 MB/sec
 Timing buffered disk reads:  408 MB in  3.01 seconds = 135.60 MB/sec

Compared to the SATA disks:

hdparm -tT /dev/xvda2
/dev/xvda2:
 Timing cached reads:   1998 MB in  2.00 seconds = 999.00 MB/sec
 Timing buffered disk reads:  92 MB in  3.03 seconds =  30.34 MB/sec

The faster partition and the switch to !InodeDB, see ticket:396 should, hopefully, result in dramatic performance improvement for !MySQL.

#463: Ttech Skype Meeting 22nd November 2012

chris — Thu, 22 Nov 2012 15:20:06 GMT

Skype meeting at 8pm tonight, see ticket:456 for the last meeting.

#466: Puffin install and configuration

chris — Wed, 28 Nov 2012 13:42:56 GMT

This ticket is to track the install and configuration of the new wiki:PuffinServer which is to replace wiki:NewLiveServer and wiki:DevelopmentServer and is due to go live in early 2013.

#471: Ttech Skype Meeting 17th December 2012

chris — Mon, 17 Dec 2012 20:04:44 GMT

Skype meeting tonight, now, the last meeting was ticket:463

#478: Import TN.org site from Quince to Puffin

jim — Sat, 26 Jan 2013 19:47:02 GMT

This ticket is to log/document steps in the process of importing TN.org onto the new Puffin server.

Current imported site at: http://newlive.puffin.webarch.net/

Import Process

This needs Part A of Transfer live TN.org site to Puffin before continuing.

Run Quince to Puffin rsync script to get Drupal files.
Make 'Transition Network XXX' platform from the latest makefile per BOA Server page.
Create an empty site on platform called 'www.transitionnetwork.org' with aliases for dev.newlive.puffin.webarch.net, newlive.puffin.webarch.net, and dev.www.transitionnetwork.org (dev.newlive... ones will go after launch).

SSH to Puffin and replace the default files folder with symlink to the one imported:

totn
cd static/transition-network-d6-XXX/sites/transitionnetwork.org
rm -R files
ln -s ~/static/sites/transitionnetwork.org-PROD/files/

Use one-time login link sent to me but replacing transitionnetwork.org with dev.newlive.puffin.webarch.net in url.
Enable Backup and Migrate module, use to import DB backup from Quince TN.org present in the Backup & Migrate manual folder.
```
drush @www.transitionnetwork.org en backup_migrate
```
(white screen of death, expected)

Run following as 'tn' to remove unneeded modules, then clear registry and caches, then update database for module/core updates:

drush @www.transitionnetwork.org rr
drush @www.transitionnetwork.org updb
drush @www.transitionnetwork.org en reroute_email environment_indicator robotstxt

Check site is ok.
Double-migrate per http://omega8.cc/import-your-sites-to-aegir-in-8-easy-steps-109#hint-8 (migrate site to 'rename.transitionnetwork.org', then back to 'www.transitionnetwork.org')
add puffin_server_override_settings_set_environment('Production'); to the local.settings.php file to set environment to test mode (no emails).
Set logo and favicon admin/build/themes/settings/transition2 (replace 'default' with 'www.transitionnetwork.org')
Change 443 Session settings to force HTTPS for logged in users.
Run developer tests on site, email all to begin testing before decision on DNS switch.

#481: Puffin tweaks

jim — Sun, 27 Jan 2013 18:26:45 GMT

Further to #466 there are some things to tweak on Puffin. Thought I'd put the little ones in this ticket...

Bash autocompletes don't really work with tab for apt-get, service, some filename options etc... miss that a lot!
Users don't seem to be auto-logged out once in via ssh. I've had my pc standby and the connection drop, but the logins I had don't seem to have been killed. According to http://cgp.master.puffin.webarch.net/host.php?h=puffin.webarch.net there are 3 users when I have only 1 session active. Are these yours or from old screens?

#503: Widget owners cannot see project moderation tab

ed — Fri, 01 Mar 2013 15:41:08 GMT

Test user1 cannot see project moderation tab. Admin can. Must be a rights issue. Can't test!