Page Comparison

...

1. Obtain a test VM with CentOS 7.

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

   Code Block
   yum install http://mirror.bcnuser:passwd@mirror.abiquo.com/el7/5.3/os/x86_64/abiquo-release-ee-internal-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

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

   
   

4. Enable and start MariaDB

   Code Block
   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

   Code Block
   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

   Code Block
   tar -xzf kinton_kinton_accounting_dump_20210831_205241.sql.gz

   
   

7. On the test server, load the database dump

   Code Block
   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

   Code Block
   abiquo-db update

   
   

9. Run the PIM planner

   Code Block
   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.

...