Version 30 (modified by 15 years ago) ( diff ) | ,
---|
Release Management for the Haiti Portal
We have 3 running instances:
- Production: http://haiti.sahanafoundation.org
- UAT: http://haiti-test.sahanafoundation.org - lifeeth
- Development: http://haiti-dev.sahanafoundation.org - lifeeth
The Bug Tracker should have different views to distinguish between bugs being reported against each version
- ToDo customise the 'Report Bugs' footer URL to link directly to a new ticket against that version?
We have several Code branches:
- Haiti Portal: https://launchpad.net/sahana/haiti-quake-2010
- Haiti Offline: tbc
- Trunk: https://launchpad.net/sahana/sahanapy
- OR: https://code.launchpad.net/~michael-howden/sahana/haiti-quake-2010 to change to being trunk-derived?
- RMS: https://code.launchpad.net/~uwthw/sahana/rms
- VITA: https://code.launchpad.net/~nursix.org/sahana/vita
Release Process
Overall responsible Person: Fran (currently)
- Where generic, new code is merged 1st into Trunk by Fran
- Code is then merged into the Haiti branch by Fran
- RMS is currently Haiti-specific so is merged directly to Haiti branch
- Code is pulled from the Haiti branch to Dev by Fran
- Data is 1st synced from Prod:
/root/automysqlbackup.sh scp /backups/daily/haitiprod/haitiprod_2010-01-27_01h24m.Wednesday.sql.gz flavour@haiti-dev.sahanafoundation.org:. gunzip haitiprod_2010-01-27_01h24m.Wednesday.sql.gz sed 's/haitiprod/haitidev/g' haitiprod_2010-01-27_01h24m.Wednesday.sql > haitidev_import.sql vim /etc/crontab #0-59/1 * * * * www-data cd /home/haiti/web2py/ && python web2py.py -C -D 1 >> /tmp/cron.output 2>&1 ln -sf /etc/apache2/sites-available/dev-maintain /etc/apache2/sites-enabled/dev /etc/init.d/apache2 force-reload mysql drop DATABASE haitidev; create DATABASE haitidev; \q mysql < haitidev_import.sql vim /home/haiti/dev/models/00_db.py migrate=True ln -sf /etc/apache2/sites-available/dev /etc/apache2/sites-enabled/dev /etc/init.d/apache2 force-reload vim /etc/crontab 0-59/1 * * * * www-data cd /home/haiti/web2py/ && python web2py.py -C -D 1 >> /tmp/cron.output 2>&1 vim /home/haiti/dev/models/00_db.py migrate=False
- A 1st draft of a data migration plan is made
- Data is 1st synced from Prod:
- Code is pulled from the Haiti branch to UAT by lifeeth or chamindra
- Testers to be informed before this via the group: tbc
- Data is 1st synced from Prod
- A more detailed data migration plan is made
- Code is pulled from the Haiti branch to Prod by Fran (Volunteers welcomed to take over!)
- Sign-off for this to come from the group: tbc
- A careful data migration plan is made
- Backup
- Disable system crontab & put Website into Maintenance Mode
vim /etc/crontab #0-59/1 * * * * www-data cd /home/haiti/web2py/ && python web2py.py -C -D 1 >> /tmp/cron.output 2>&1 vim /home/haiti/prod/models/00_db.py migrate=True rm /etc/apache2/sites-enabled/prod-ssl /etc/init.d/apache2 force-reload /home/haiti/update-prod /home/haiti/shell-prod db.export_to_csv_file(open('db.csv','wb')) Ctrl+D
- Disable system crontab & put Website into Maintenance Mode
- DataMigration
cd /home/haiti/web2py ; python web2py.py -S prod -M -N
Ctrl+D
- Restore Website & Cron
ln -s /etc/apache2/sites-available/prod-ssl /etc/apache2/sites-enabled /etc/init.d/apache2 force-reload vim /home/haiti/prod/models/00_db.py migrate=False vim /etc/crontab 0-59/1 * * * * www-data cd /home/haiti/web2py/ && python web2py.py -C -D 1 >> /tmp/cron.output 2>&1
Technical Details
Production
- haiti.sahanapy.org VM: 212.23.5.4
- /home/haiti/web2py/applications/prod
- /etc/apache2/sites-enabled/prod
- Sqlite
- Web2Py r1544
- Sahana Haiti r547
- Customisations:
- models/00_db.py
- migrate = False
- models/00_settings.py
- auth.settings.registration_requires_verification = True
- auth.settings.registration_requires_approval = True
- models/01_modules.py
s3.menu_modules.append([T('Home'), False, URL(r=request, c='default', f='open_module', vars=dict(id=1))]) if auth.has_membership(1): s3.menu_modules.append([T('Admin'), False, URL(r=request, c='default', f='open_module', vars=dict(id=2))]) s3.menu_modules.append([T('Mapping'), False, URL(r=request, c='default', f='open_module', vars=dict(id=3))]) module_id = db(db.s3_module.name == 'or').select()[0].id s3.menu_modules.append([T('Organizations'), False, URL(r=request, c='default', f='open_module', vars=dict(id=module_id))]) s3.menu_modules.append([T('People'), False, URL(r=request, c='default', f='open_module', vars=dict(id=4))]) #dvi_group = db(db[auth.settings.table_group_name] == 'DVI').select()[0].id #if auth.has_membership(dvi_group): #module_id = db(db.s3_module.name == 'dvi').select()[0].id #s3.menu_modules.append([T('Victim Identification'), False, URL(r=request, c='default', f='open_module', vars=dict(id=module_id))]) module_id = db(db.s3_module.name == 'rms').select()[0].id s3.menu_modules.append([T('Requests'), False, URL(r=request, c='default', f='open_module', vars=dict(id=module_id))])
- cron/crontab
*/5 * * * * root *applications/prod/cron/rms_entry2record.py */5 * * * * root *applications/prod/cron/rms_tweet2request.py
- views/layout_default.html
<script type="text/javascript"> var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www."); document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E")); </script> <script type="text/javascript"> try { var pageTracker = _gat._getTracker("UA-12510226-2"); pageTracker._setDomainName(".sahanafoundation.org"); pageTracker._trackPageview(); } catch(err) {}</script>
- views/ext.html
<!-- For Sites Hosted on the Public Internet, using Cachefly CDN's version of ExtJS may provide better performance <script type="text/javascript" src="/{{=request.application}}/static/scripts/ext/ext-all.js"></script> --> <script type="text/javascript" src="http://extjs.cachefly.net/ext-3.0.3/ext-all.js"></script>
- views/sahana_scripts_min.html
<!-- For Sites Hosted on the Public Internet, using Google's version of jQuery will provide better performance <script src="/{{=request.application}}/static/scripts/web2py/jquery-1.3.2.min.js" type="text/javascript"></script> --> <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.3/jquery.min.js" type="text/javascript"></script>
- models/00_db.py
- http://haiti-test.sahanafoundation.org/test/gis/apikey/update/1
- ABQIAAAAgB-1pyZu7pKAZrMGv3nksRR1-chREdZE62d-MGawPNPOGidOJBQQCwHsElsSGbD5VMpNj7DBMNxjTg
UAT
- logistics.sahanapy.org VM: 212.23.5.5
- /home/haiti/web2py-test/applications/test
- /etc/apache2/sites-enabled/haiti-test
- MySQL hopefully
- Web2Py r1544
- Sahana Haiti r547
- Customisations:
- models/00_db.py
- migrate = False
- db = DAL('mysql://haititest:password@localhost/haititest', pool_size=10)
- models/00_settings.py
- S3_PUBLIC_URL = 'http://haiti-test.sahanafoundation.org'
- auth.settings.registration_requires_verification = True
- auth.settings.registration_requires_approval = True
- cron/crontab
*/5 * * * * root *applications/test/cron/rms_entry2record.py */5 * * * * root *applications/test/cron/rms_tweet2request.py
- views/ext.html
<!-- For Sites Hosted on the Public Internet, using Cachefly CDN's version of ExtJS may provide better performance <script type="text/javascript" src="/{{=request.application}}/static/scripts/ext/ext-all.js"></script> --> <script type="text/javascript" src="http://extjs.cachefly.net/ext-3.0.3/ext-all.js"></script>
- views/sahana_scripts_min.html
<!-- For Sites Hosted on the Public Internet, using Google's version of jQuery will provide better performance <script src="/{{=request.application}}/static/scripts/web2py/jquery-1.3.2.min.js" type="text/javascript"></script> --> <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.3/jquery.min.js" type="text/javascript"></script>
- http://haiti-test.sahanafoundation.org/test/gis/apikey/update/1
- ABQIAAAAgB-1pyZu7pKAZrMGv3nksRR1-chREdZE62d-MGawPNPOGidOJBQQCwHsElsSGbD5VMpNj7DBMNxjTg
- models/00_db.py
Dev
- logistics.sahanapy.org VM: 212.23.5.5
- /home/haiti/web2py/applications/dev
- /etc/apache2/sites-available/dev
- /etc/apache2/sites-available/dev-maintain
- /etc/apache2/sites-enabled/dev
- MySQL
- Web2Py r1544
- Sahana Haiti r547
cd /home/haiti/web2py/applications bzr branch lp:sahana/haiti-quake-2010 dev cd dev chown www-data -R cache chown www-data -R databases chown www-data -R errors chown www-data -R sessions chown www-data -R static/img/markers chown www-data -R static/scripts chown www-data -R static/styles chown www-data -R uploads
- Customisations:
- models/00_db.py
- migrate = False (after 1st run)
- db = DAL('mysql://haitidev:password@localhost/haitidev', pool_size=10)
- models/01_modules.py
s3.menu_modules.append([T('Home'), False, URL(r=request, c='default', f='open_module', vars=dict(id=1))]) if auth.has_membership(1): s3.menu_modules.append([T('Admin'), False, URL(r=request, c='default', f='open_module', vars=dict(id=2))]) s3.menu_modules.append([T('Mapping'), False, URL(r=request, c='default', f='open_module', vars=dict(id=3))]) module_id = db(db.s3_module.name == 'or').select()[0].id s3.menu_modules.append([T('Organizations'), False, URL(r=request, c='default', f='open_module', vars=dict(id=module_id))]) module_id = db(db.s3_module.name == 'hms').select()[0].id s3.menu_modules.append([T('Hospitals'), False, URL(r=request, c='default', f='open_module', vars=dict(id=module_id))]) s3.menu_modules.append([T('People'), False, URL(r=request, c='default', f='open_module', vars=dict(id=4))]) #dvi_group = db(db[auth.settings.table_group_name] == 'DVI').select()[0].id #if auth.has_membership(dvi_group): module_id = db(db.s3_module.name == 'dvi').select()[0].id s3.menu_modules.append([T('Victims'), False, URL(r=request, c='default', f='open_module', vars=dict(id=module_id))]) module_id = db(db.s3_module.name == 'rms').select()[0].id s3.menu_modules.append([T('Requests'), False, URL(r=request, c='default', f='open_module', vars=dict(id=module_id))]) module_id = db(db.s3_module.name == 'vol').select()[0].id s3.menu_modules.append([T('Volunteers'), False, URL(r=request, c='default', f='open_module', vars=dict(id=module_id))])
- models/00_settings.py
- S3_PUBLIC_URL = 'http://haiti-dev.sahanafoundation.org'
- auth.settings.registration_requires_verification = True
- auth.settings.registration_requires_approval = True
- cron/crontab
*/5 * * * * root *applications/dev/cron/rms_entry2record.py */5 * * * * root *applications/dev/cron/rms_tweet2request.py */5 * * * * root *applications/dev/cron/import_job_do_processing.py */5 * * * * root *applications/dev/cron/import_job_do_import.py
- views/ext.html
<!-- For Sites Hosted on the Public Internet, using Cachefly CDN's version of ExtJS may provide better performance <script type="text/javascript" src="/{{=request.application}}/static/scripts/ext/ext-all.js"></script> --> <script type="text/javascript" src="http://extjs.cachefly.net/ext-3.0.3/ext-all.js"></script>
- views/sahana_scripts_min.html
<!-- For Sites Hosted on the Public Internet, using Google's version of jQuery will provide better performance <script src="/{{=request.application}}/static/scripts/web2py/jquery-1.3.2.min.js" type="text/javascript"></script> --> <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.3/jquery.min.js" type="text/javascript"></script>
- models/00_db.py
- http://haiti-dev.sahanafoundation.org/dev/gis/apikey/update/1
- ABQIAAAAgB-1pyZu7pKAZrMGv3nksRR1-chREdZE62d-MGawPNPOGidOJBQQCwHsElsSGbD5VMpNj7DBMNxjTg
Note that UAT & Dev have different Web2Py instances so that:
- We can trial different Web2Py versions on Dev
- Crontab can be separately enabled/disabled
Note that all names/paths include the words 'dev'/'test'/'prod' to minimise chances of confusion as to which site is being altered
Note:
See TracWiki
for help on using the wiki.