Setup on new server tasks¶

1. Install Apache, Postgres, Varnish, etc
2. Install Ruby EE and Phusion Passenger
3. Install (via gem) rake, rails version 2.3.5, pg, rmagick, ruby-openid
4. Clone current soundsoftware code
5. Set up postgresql user and initialise database
6. Redmine initialisation
7. Redmine permissions and ownership
8. Basic Apache config for site on :81
9. Varnish config for :80->:81
10. PHP5 via fcgi
11. Basic Drupal install
12. Set up hgwebdir, reposman-soundsoftware, soundsoftware Apache auth
13. Pull across remaining bits of redmine server that are not in hg (fonts, files, etc)
14. Pull across Drupal theme etc
15. Ensure machine can be routed to!
16. Configure SSL server
17. Pull across hg repos
18. Initial database load
19. Set up test instances

in the future: put old host in admin mode, re-point dns, final hg / database / redmine files update

MySQL to Postgres migration notes¶

Just to make things more fun, we're migrating the existing databases from MySQL to pgsql.

For Redmine, we don't attempt to dump and reload the schema -- more sensible to use Redmine to set up the schema (in case it has any database-specific set up) and then massage the data as we load it. That way we only see problems once.

mysql2pgsql does a reasonable job of converting the data (only -- no schema) as far as it goes. Some problems remain:

grep ERROR log/dbload.log |sort|uniq
ERROR:  column "admin" is of type boolean but expression is of type integer
ERROR:  column "assignable" is of type boolean but expression is of type integer
ERROR:  column "hide_mail" is of type boolean but expression is of type integer
ERROR:  column "is_closed" is of type boolean but expression is of type integer
ERROR:  column "is_default" is of type boolean but expression is of type integer
ERROR:  column "is_in_chlog" is of type boolean but expression is of type integer
ERROR:  column "is_public" is of type boolean but expression is of type integer
ERROR:  column "mail_notification" is of type boolean but expression is of type integer
ERROR:  column "onthefly_register" is of type boolean but expression is of type integer
ERROR:  column "protected" is of type boolean but expression is of type integer
ERROR:  duplicate key value violates unique constraint "unique_schema_migrations" 
ERROR:  INSERT has more expressions than target columns
ERROR:  invalid input syntax for type bytea