Upgrade From 2.2 to 2.2.2

This page provides information on how to upgrade from VCL 2.2 to VCL 2.2.2. Please note
it only applies for the upgrade from 2.2 to 2.2.2, this may or may not work for other
versions.
The basic steps that will be performed

We will create a backup of the vcl database. This will provide a restore point
if necessary. There are no updates to the database in this upgrade, but it is still a
good idea to have a backup.

mysqldumpvcl>~/vcl-pre2.2.2-upgrade.sql

This step updates the mysql schema.

cd/root/apache-VCL-2.2.2
mysqlvcl<mysql/update-vcl.sql

Grant CREATE TEMPORARY TABLES to mysql user

The web code now requires access to create temporary tables in mysql. You need to
grant the user your web code uses to access mysql the "CREATE TEMPORARY TABLES"
permission. Look at the secrets.php file in your web code for the user and hostname.
For example, if your web code is installed at /var/www/html/vcl, your secrets.php
file would be /var/www/html/vcl/.ht-inc/secrets.php. Look for $vclhost and
$vclusername. The secrets.php file might have something like:

$vclhost='localhost';
$vcluser='vcluser';

Then, you need to issue the grant command to mysql. Using the values from above
as examples, connect to mysql and then issue the grant command:

mysqlGRANTCREATETEMPORARYTABLESON `vcl`.*TO'vcluser'@'localhost';exit

Update the web code. This step will move the 2.2 web directory out
of the way, so we can copy in the new web code base. After copying in the new
code, we will migrate your configuration changes. These instructions assume that
you installed the vcl web code at /var/www/html/vcl. If you installed it
elsewhere, replace /var/www/html/vcl with your vcl web root.

Make the maintenance directory writable by the web server user. Normally
this is the apache user, if using a different user change below cmd accordingly.

chownapache/var/www/html/vcl/.ht-inc/maintenance

Make changes to conf.php:

A new user group permission that controls who can manage block allocations
globally or for a specific affiliation has been added. It can be granted to any
user group under Privileges->Additional User Permissions->Manage Block Allocations.
Users with this permission are notified of new block allocation requests.
Remove the following from conf.php.

$blockNotifyUsers

A new user group permission that controls who can look up users globally
or for a specific affiliation has been added. It can be granted to any user group
under Privileges->Additional User Permissions->User Lookup. Users with this
permission can look up information about other users.
Remove the following from conf.php.

$userlookupUsers

Restart httpd service

servicehttpdstartor/etc/init.d/httpdstart

Update management node code This step will make a backup copy of the 2.2 vcl code
base and then copy the new code over the existing code to preserve any drivers or other
files you've added.