...
- (08:00 Joncarlo) Prevent any client access to SmartSite via iptables and redirect clients to a maintenance/outage page
- We need to allow access from dedicated IPs for possible pre-upgrade work, such as exporting Melete modules, etc.
- Adjust iptables on head node (stubing) to allow JMX access to port 9000 for specified IPs
- PORT 8443:
- 169.237.11.246 (thomas)
- 69.12.224.247 (thomas)
- 169.237.97.91 (zoidberg: vpn, terminal server)
- 169.237.97.133 (kirk)
- 169.237.11.220 (james)
- 169.237.11.23 (sandra)
- 169.237.11.6 (jon)
- 169.237.11.242 (mike)
- 169.237.11.30 (lisa)
- PORT 9000:
- IPs : 169.237.11.246
- PORT 8443:
- (08:10 Prabhu) Backing up (CLONE) production database so that it can be fully restored.
- (09:00 Prabhu) Run database upgrade scripts in the following order
- (09:15 Thomas) Backup all configuration files in production staging area
- /afs/.ucdavis.edu/app/sakai/staging/config/*
Code Block mkdir /afs/.ucdavis.edu/app/sakai/staging/config/config-2-4-0.bak cp /afs/.ucdavis.edu/app/sakai/staging/config/* /afs/.ucdavis.edu/app/sakai/staging/config/config-2-4-0.bak/
- /afs/.ucdavis.edu/app/sakai/staging/config/*
- (09:20 Thomas) Start process of preparing Sakai v2.4.1 source on the head node (stubing).
- Getting the source code:
Code Block cd ~/src svn co https://mware.ucdavis.edu/svn/ucd-sakai/sakai/tags/sakai_2-4-x-prod-003
- Cleaning, building, deploying source on head node
- Getting the source code:
- (09:35 Thomas) Making sure all the configuration files are in place for v2.4.1 such as sakai.properties etc.
- Configure JAVA_OPTS to allow JMX access via JConsole
- Synchronize all configuration files on the head node (stubing) with the AFS configuration staging area
- /afs/.ucdavis.edu/app/sakai/staging/config
- Edit sakai.properties on stubing
Code Block auto.ddl=true
- Start-up head node (stubing) and check catalina.out for any errors
- Check catalina.out for DB errors. There is one known issue where hibernate auto.ddl creates the following warning:
No Format WARN: Unsuccessful schema statement: alter table GB_LETTERGRADE_MAPPING add LG_MAPPING_ID number(19,0) (2007-08-07 16:07:57,962 main_org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean) java.sql.SQLException: ORA-01430: column being added already exists in table ...
- Once the head node started up without any errors, shut it down again
- Check catalina.out for DB errors. There is one known issue where hibernate auto.ddl creates the following warning:
- Edit sakai.properties on stubing
Code Block auto.ddl=false
- Start-up head node (stubing) again
- Make sure that there are no errors in catalina.out
- Access head node and perform any appropriate testing
- If there are no errors/problems, perform installation on second node (walton)
- Start-up walton and perform any appropriate testing
- (10:00 Kirk, Sandra, Lisa, ...) Release SmartSite for initial testing to determine "successful upgrade"
- (12:00 Joncarlo) Adjust iptables on all nodes (stubing, walton) to allow public access
- (11:45 Thomas) Send mail to Joncarlo if we are ready to switch iptables
- (12:01) System ready for public access
...