Connecting CloudBolt to an external MySQL instance

While CloudBolt is typically installed as a single appliance, the individual pieces of CloudBolt can be split onto different systems.  The easiest way to do this is to install 2 separate virtual appliances, then use the following steps to point the Apache front-end from one system to the MySQL database from the second system.

Configuring the db server:
1) Get to the mysql shell (usually mysql -u root --password=Vi-gn3tt3 cloudbolt from the commandline)

2) Type:

GRANT ALL PRIVILEGES ON cloudbolt.* TO ‘root’@'cloudbolt_ip' IDENTIFIED BY 'Vi-gn3tt3';
(Replacing ‘cloudbolt_ip’ with the ip address of the server you want to be able to access this database from)

3) Close and exit from the shell

4) Edit /etc/my.cnf and make sure the bind-address is set to the ip of the database server

5) Restart mysqld with service mysqld restart

6) Open the iptables to give access to the mysql port:
/sbin/iptables -A INPUT -i eth0 -p tcp --destination-port 3306 -j ACCEPT
Change ‘eth0’ to the appropriate value (use ifconfig to see which eth is being used)

7) Save changes to iptables with service iptables save

 

Configuring the CloudBolt front-end:

1) Set up the CloudBolt server you want to be able to access the remote database

2) From /opt/cloudbolt/customer_settings.py in the DATABASES section, add values for ‘HOST’ and ‘PORT’ where host is the ip of the database server and port is 3306

3) Restart apache with service httpd restart

Have more questions? Submit a request

1 Comments

  • 0
    Avatar
    Nils Vogels

    Additionally, it is worth to notice that the cloudbolt upgrader needs to be tweaked before it runs, since it assumes a local database engine.

    It took a while before i figured out why my upgrade didn't run smoothly :)

Please sign in to leave a comment.