This year's upgrade process will be in 4 parts.

0. Verify backups ran successfully (completed 2:19am)
1. Copy Webvoyage from split server to DB server (completed 2:47am)
2. Upgrade DB server to Voyager 7.2.3 (completed 3:10am)
3. Re-split the webserver from the DB server to the split server (millib.wisconsin.edu) (completed 3:25am)
4. Split z3950 server (completed 3:40am)

bw - 3:42am - patch is complete. Just a couple of little error messages about removing the prevoy723 mobile skin backup files due to file permissions. I'm adding a step to fix perms before I run the upgrade script. It completed successfully just the same, and everything else went smoothly (knock on wood). I'm heading back to bed shortly - please page me if anything doesn't look right. (Clients will need to be upgraded, are available from the Exlibris Documents website, etc etc).

Verify backups ran successfully (just after 2am)
- On widener verify that all of Milwaukee's backup mount points are new from the previous night's backup (completed 2:19am)

Copy Webvoyage from split server to DB server (completed 2:47am)
- Comment out cron jobs (completed 2:20am)
- Take down production web server (completed 2:35am)
- Take down production DB server (all but Oracle DB) (completed 2:40am)
- cd /m1/voyager/milwaukeedb/tomcat/
- sudo rsync -a -v -x --progress bwilson@millib.wisconsin.edu:/m1/voyager/milwaukeedb/tomcat/vwebv .
- cd /m1/voyager/milwaukeedb
- sudo rsync -a -v -x --progress bwilson@millib.wisconsin.edu:/m1/voyager/milwaukeedb/webvoyage .
- cd /m1/voyager/rescatdb/tomcat
- sudo rsync -a -v -x --progress bwilson@millib.wisconsin.edu:/m1/voyager/rescatdb/tomcat/vwebv .
- cd /m1/voyager/rescatdb
- sudo rsync -a -v -x --progress bwilson@millib.wisconsin.edu:/m1/voyager/rescatdb/webvoyage .

Upgrade DB server to Voyager 7.2.3 (completed 3:10am with very minor errors)
- Copy voy723 script to /m1/incoming/patch (completed 2:50am)
- re-verify that voyager is down (completed 2:51am)
- sudo su - voyager
- cd /m1/incoming/patch
- chmod +x voy723
- ./voy723
- Walk through upgrade script (completed 3:05am)
-- There were some very minor errors here in the moving of the mobile skin back to it's previous state (file permissions weren't right, adding a step to fix those before upgrade script). I believe the errors simply indicated that it failed to remove the backup files, and have manually verified that the files look okay as best I can (diff comparison to the pre723 files). The mobile skin should be reviewed if it's in use.
- verify logs (completed 3:10am)

Re-split webserver from DB server to split server (millib.wisconsin.edu) (completed 3:25am)
- cd /m1/voyager
- sudo tar cvf webserver.tar milwaukeedb/etc milwaukeedb/webvoyage milwaukeedb/ini milwaukeedb/tomcat/vwebv rescatdb/etc rescatdb/webvoyage rescatdb/ini rescatdb/tomcat/vwebv lib/2007.2.3 bin/2007.2.3/*exe bin/2007.2.3/*cgi
- scp webserver.tar to millib.wisconsin.edu
- on millib - cd /m1/voyager
- for db in milwaukeedb rescatdb ; do ; sudo mv $db $db.v721 ; done
- sudo tar xvpf webserver.tar
- sudo vi *db/etc/webvoyage/voyager.ini
- sudo vi *db/tomcat/vwebv/context/vwebv/WEB-INF/web.xml
- on DB server start voyager and httpd, then on web server start voyager and httpd
- verify everything's working (completed 3:25am)
- uncomment cron jobs, and schedule them as needed (completed 3:30am)
-- rescheduled the 2:50am cron job for 3:50am - and the cronjabs between 3am and 4am, for 4am to 5am (e.g 3:11am will run at 4:11am)


Split z3950 server (completed 3:40am)
- Build with their tar command - leave out voyager and oracle libraries - scp them over afterwards
-- sudo su - voyager
-- cd /m1/voyager
-- tar cvf opacZserver.tar */etc/ascopac */ini */log */sbin/*ascopac */sbin/*z3950svr bin/2007.2.3/z3950svr bin/2007.2.3/ascopac lib/2007.2.3
- scp opacZ3server.tar to z3950.wisconsin.edu
- on z3950.wisconsin.edu
-- sudo mkdir /m1/voyager/lib/2007.2.3 ; sudo chown voyager:endeavor /m1/voyager/lib/2007.2.3
-- cd /m1/voyager/lib/2007.2.3
-- sudo rsync -a /m1/voyager/lib/2007.2.1/libnnz10.so .
-- sudo rsync -a /m1/voyager/lib/2007.2.1/libclntsh.so.10.1 .
-- sudo rsync -a /m1/voyager/lib/2007.2.1/libclntsh.so.9.0 .
-- modify /m1/voyager/*db/etc/ascopac/opac.ini from localhost to xxxdb
-- modify /m1/voyager/*db/ini/z3950svr.ini from localhost to xxxdb
-- modify /m1/voyager/*db/ini/voyager.ini as needed (localhost to xxxdb I believe)
- test with library of congress z3950 gateway
-- open browser to http://www.loc.gov/z3950/
-- go down to University of Wisconsin - Milwaukee, follow link
-- manually change the URL hostname from 'milvoydb.wisconsin.edu' to 'z3950.wisconsin.edu'
-- make sure it loads the query screen and attempt a few queries, click through to more information on a few records (I usually search for the word 'red' or 'green')