MYSQL5: MySQL 5.0 Database Appliance - Test Plan

The test plan for the MySQL 5.0 appliance is the same as the test plan for MYSQL except for the following difference:

Preparation

The test application should use MySQL5 appliance instead of MYSQL appliance.

Tests Details

Properties Tests

"use_old_passwords" property

1. Leave use_old_passwords=1, create web.db -> db.in connection, switch off the standby attribute of the web appliance and restart the test application.
   
   Login on the db appliance and execute:
   mysql -e "grant all privileges on * . * to 'test1'@'%' identified by 'test1' with grant option;"
   mysql -e "grant all privileges on * . * to 'test2'@'%' with grant option;"
   mysql -e "flush privileges;"
   
   Login on the web appliance and execute:
   mysql -h db -u test1 -p - it should succeed
   mysql -h db -u test2 - it should succeed
   
   
2. Set use_old_passwords=0 and restart the test application.
   
   Login on the db appliance and execute:
   mysql -e "grant all privileges on * . * to 'test3'@'%' identified by 'test3' with grant option;"
   mysql -e "grant all privileges on * . * to 'test4'@'%' with grant option;"
   mysql -e "flush privileges;"
   
   Login on the web appliance and execute:
   mysql -h db -u test3 -p - it should fail
   mysql -h db -u test4 - it should succeed
   

Compatibility Tests

Test real applications - in copies of SugarCRM, Lamp and Lampx4 applications replace MYSQL with MYSQL5 appliances, configure, start and test the application:

SugarCRM application

1. Verify the main sugar page is displayed by pointing your browser at the configured IP address.
2. Verify you can login to sugar using the admin user with password "3tSugar".
3. After login, verify you can modify customers, display customer info, etc.
4. Access the configured admin ip and login using the admin user.
5. Verify you can access all logs.

Lamp and Lampx4 applications

Install phpBB and verify it's working:

1. Download phpBB from http://downloads.sourceforge.net/phpbb/phpBB-2.0.22.tar.gz
2. Extract the contents in the apache web root directory (/mnt/content)
3. chmod 0666 /mnt/content/phpBB2/config.php
4. Create a database for phpBB (this will be required during configuration from the browser) + an admin user:
   1. Start the mysql client ("mysql -h db") and run the following commands:
      "create database php;"
      "grant all privileges on php.* to 'usr'@'%' identified by 'pass';"
      "flush privileges"
      
   2. Exit the mysql client.
5. Open a browser pointing at http://app_ip/phpBB2/ and follow the instructions (below are the fields to fill in during the install)
   • database type=4.x/5.x
   • database server hostname=db
   • database name=php
   • database username=usr
   • database password=pass
   • admin username=admin
   • admin password=(password)
6. At the end of the installation it will ask you to remove the install and contrib folders (you can delete or rename them)
7. Log in with the admin user and verify the application works (add a user, post messages, etc)

-- NetClime - 02 Oct 2007