This page describes how to update a legacy (pre-cfg mgmt, sysuser based configuration) PHP built to use the latest PHP build, installed by RadminD and including JPEG library support.

1. Shut down Apache on the server being upgraded.

   /etc/init.d/web stop

2. Backup the MySQL databases

   mysqldump -p --all-databases --flush-privileges --single-transaction > ~/database-backups-`hostname`.sql mysqldump -p -B pubsdev --flush-privileges --single-transaction > ~/database-backups-pubsdev-`hostname`.sql

3. Check version of MySQL, and shutdown MySQL on the server if it is not the OS provided version (5.0.45 x86_64 on the 64 bit RHEL5.1 servers)

   mysql --version /etc/init.d/mysqld stop

   1. Remove MySQL if it is not the correct version. Do not delete the data directories.
      • If possible, use RPM to remove the version of MySQL that is there.

        ### This code chunk in untested. Use only after careful review. rpm -e /home/db/tmp/MySQL-server-community-5.0.45-0.rhel5.i386.rpm /etc/init.d/mysql stop rpm -e MySQL-client-community rpm -e MySQL-shared-community rpm -e MySQL-clusterstorage-community rpm -e MySQL-clustertools-community rpm -e MySQL-clusterextra-community rpm -e MySQL-clustermanagement-community

      • If it is a hand-installed version, such as the custom build on 5.0.67, must delete the files by hand (and force yum to write over remaining files that we have missed). Backup the my.cnf config file.

        cp /etc/my.cnf /home/db rm -rf /usr/bin/mysql /usr/lib/mysql /usr/include/mysql /usr/share/mysql /usr/man/man1/mysql.1 /usr/share/man/man1/mysql.1.gz /usr/libexec/mysqld /usr/man/man8/mysqld.8 /usr/share/man/man1/mysqld.1.gz

4. Install correct version of MySQL, if necessary, and reconfigure it.

   yum -y install mysql-server /etc/init.d/mysql stop rm /var/lock/subsys/mysqld cp /home/db/my.cnf /etc/my.cnf scp dracus@athena.dialup.mit.edu:/afs/athena.mit.edu/project/amit-dsl/Public/MySQL/mysqld /etc/init.d/mysqld

   1. Check that the init script sets the user to be db, and that the my.cnf file contains the proper location for the pid file.
      • Grep for user.

        grep user /etc/init.d/mysqld

      • Should return the following line.

        get_mysql_option /etc/my.cnf user "db"

      • If it does not, download the correct init script from the AMIT DSL.

        scp dracus@athena.dialup.mit.edu:/afs/athena.mit.edu/project/amit-dsl/Public/MySQL/mysqld /etc/init.d/mysqld

   2. Grep for pid file.

      grep pid /etc/my.cnf

      • Should return the following line.

        pid-file=/home/db/mysql.pid

      • If it does not, update the /etc/my.cnf file to contain that config line.
5. Log into Nebula/Lockbox (the RadminD server), and link the host command filename to the legacy PHP command file.

   cd /var/radmind/command/isda ln -s legacy-php-rhel5.1-x86_64.K [hostname].K

6. Move the PHP directory to a backup location.

   cd /home/www mv php-5.2.6 php-5.2.6-backup rm php

   • Replace '[hostname]' with the base hostname of the server being upgraded.
7. Go to the RadminD client directory and delete the previous command and transcript files.

   cd /var/radmind/client/ rm -rf *

8. Use ra.sh, and update the version of PHP on the system.

   ra.sh -c update /

   • Edit the appliable transcript and make certain nothing that has not been backed up is going to be overwritten.
9. Start Apache

   /etc/init.d/web start

10. If it starts, log in as www user, and test socket connection to mysql.
11. Copy the php.ini, phpinfo.php and settings.php files, and edit them to reflect local settings.
12. Bounce MySQL, start Apache, give Drupal ~10 min to init, and test the machine.