Upgrade 0.7 to 0.8

improved

• Addon now makes use of Initialization Vector (IV) for better security (See http://stackoverflow.com/questions/11821195/use-of-initialization-vector-in-openssl-encrypt for details) - Thanks Aaron Dummer and "sudopeople" on stackoverflow.com
• maxlength added to form items "Username" and "Password"

Backup Database

mysqldump -uroot -p racktables_db > racktables_db-20130607.sql

Remove Old File

cd /usr/local/share/RackTables/plugins/
mv passwords.php passwords.php.back

Alter Table

ALTER TABLE `ObjectPWs`
  ADD CONSTRAINT `ObjectPWs-FK-object_id` FOREIGN KEY (`object_id`) REFERENCES `Object` (`id`) ON DELETE CASCADE,
  CHANGE  `password_hash`  `password_hash` CHAR(255) DEFAULT NULL
;

Install PHP-MCrypt Module

yum install php-mcrypt -y

Copy Upgrade Password DB file

cp <Directory>/upgrade_pwdb.php /usr/local/share/RackTables/plugins

upgrade_pwdb.php 파일을 편집하여 $old_key와 $new_key 항목에 백업해 놓은 password.php.back 의 $key 값을 반드시 넣는다.

Upgrade Password Database

Copy new version of password.php

cp <Directory>/upgrade_pwdb.php /usr/local/share/RackTables/plugins

password.php 파일을 편집하여 $key 값을 반드시 넣는다.

Check Password

기존 Object에 들어가 암호가 잘 나오는지 확인한다.