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
The basic steps that will be performed
- Download and Extract 2.2.2 code
- Shutdown httpd and vcld services
- Create backup of vcl database
- Update mysql schema
- Grant CREATE TEMPORARY TABLES to mysql user
- Update Web code, create a backup, copy in new, make changes
- Restart httpd service
- Update Management node vcl code, create a backup, copy in new, make changes
- Restart vcld service
Detailed steps for upgrade from 2.2 to 2.2.2
follow instructions on the VCL download page to download and verify apache-VCL-2.2.2.tar.bz2 and put in in /root
extract VCL 2.2.2 code
tar xjf apache-VCL-2.2.2.tar.bz2
Shutdown the httpd service
service httpd stop or /etc/init.d/httpd stop service vcld stop or /etc/init.d/vcld stop
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.
mysqldump vcl > ~/vcl-pre2.2.2-upgrade.sql
This step updates the mysql schema.
cd /root/apache-VCL-2.2.2 mysql vcl < 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:
mysql GRANT CREATE TEMPORARY TABLES ON `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.
cd /var/www/html mv vcl ~/vcl_2.2_web
Copy the new code in place
cd /root/apache-VCL-2.2.2 cp -r web /var/www/html/vcl
Copy your 2.2 config files
cd ~/vcl_2.2_web/.ht-inc cp conf.php secrets.php pubkey.pem keys.pem /var/www/html/vcl/.ht-inc
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.
chown apache /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.
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.
Restart httpd service
service httpd start or /etc/init.d/httpd start
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.
cd <your vcl MN code root path> ie. cd /usr/local/ cp -r vcl ~/vcl_2.2_managementnode
Copy in the 2.2.2 code base to /usr/local, copying in should preserve any drivers or other files you’ve added.
/bin/cp -r /root/apache-VCL-2.2.2/managementnode/* /usr/local/vcl
Run install_perl_libs.pl to add any new perl library requirements:
Restart vcld service
service vcld start or /etc/init.d/vcld start
Make some test reservations and watch the vcld.log to verify everything is working correctly.
tail -f /var/log/vcld.log