We will be releasing opencore 0.9.7.3 to openplans.org next week. This update introduces two main new features: automatic creation of a discussion mailling list for future projects created with the Listen featurelet, and the blog featurelet, which requires building wordpress via topp.build.wordpress. On a system with no mysql root password, topp.build.wordpress sets up the wordpress user and database, but since theman's mysql root user is password-protected, I have taken care of this already. What follows is a prediction of what I will run next week when we roll out the new release:

$ ssh theman
$ sudo su openplans
$ cd /usr/local/topp/build
$ source bin/activate
$ cd config/wordpress
verify the build's ini files are present and correct (if not run build-wordpress --write-config and edit them)
$ build-wordpress --keep-config

verify build-wordpress hit http://localhost:8090/index.php (which sets up wordpress's database):
$ /usr/local/mysql/bin/mysql -u wordpress -p
mysql> use wordpress;
mysql> show tables;
if nothing is there, hit it manually:
$ wget http://localhost:8090/index.php > /dev/null

verify httpd is serving wordpress
replace wordpress-mu directory with svn checkout, preserving wp-config.php

$ svn up /usr/local/topp/opencore/src/opencore
as root:
# /etc/init.d/openplans-zope restart

hit https://wwwroot.openplans.org/openplans/sync-wordpress-users
verify "XYZ users added"