Create a test VM and run PIM planner on a database dump

This page explains how to configure a VM to test the provider ID migration (PIM) on a dump of your production database. 

Author: Former user (Deleted)

1. Obtain a test VM with CentOS 7.

2. Install Abiquo release package, disable updates, install the required packages

   yum install http://user:passwd@mirror.abiquo.com/el7/5.3/os/x86_64/abiquo-release-ee-5.3.0-9243.el7.noarch.rpm
   yum-config-manager --disable abiquo-updates
   yum install abiquo-model abiquo-pim-tools abiquo-core mariadb-server liquibase

3. Make a config folder and from your API server, copy the abiquo.properties file

   mkdir -p /opt/abiquo/config
   scp root@my.api.server:/opt/abiquo/config/abiquo.properties /opt/abiquo/config

4. Enable and start MariaDB

   systemctl enable mariadb
   systemctl start mariadb

5. Log in to your database server and create a database dump of the main database and the accounting database

   mysqldump --databases kinton kinton_accounting --routines --triggers | gzip -9 > kinton_kinton_accounting_dump_$(date +%Y%m%d_%H%M%S).sql.gz
   scp kinton_kinton_accounting_dump_20210831_205241.sql.gz root@my.test.server:~/

6. Log in to your test server and uncompress the database dump

   tar -xzf kinton_kinton_accounting_dump_20210831_205241.sql.gz

7. On the test server, load the database dump

   mysql -e "CREATE DATABASE kinton"
   mysql kinton < kinton_kinton_accounting_dump_20210831_205241.sql
   mysql -e "GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY '' WITH GRANT OPTION;"

8. Update the database to version 5.3

   abiquo-db update

9. Run the PIM planner

   java -jar /opt/abiquo/pim-tools/pimplanner.jar --jdbc-url="jdbc:mysql://127.0.0.1:3306/kinton?autoReconnect=true&user=root&password=" > output_pimplanner.log

10. Check the output_pimplanner.log file. If there are any warnings or errors, please check the VMs before you continue.