Install Zenoss as you normally would with the MySQL database on the local server. Then you will need to use the standard mysqldump tool to dump the database for loading into your remote MySQL server. It would go something like this:

mysqldump -uroot --routines events > events.sql

Then you can take the resulting events.sql file and load it into your remote MySQL server as follows.

mysql -uroot -p # -p only if password is required.
mysql> CREATE DATABASE events;
mysql> \. events.sql
mysql> GRANT ALL ON events.* TO zenoss@IPADDRESS IDENTIFIED BY 'zenoss';

Be sure to replace that “IPADDRESS” with the IP address of your Zenoss server to allow it to remotely access the events database. You will then need to go into the Event Manager section of the Zenoss web interface and change the database hostname to the IP address or hostname of your remote database server.

technology/zenoss/howtos/remote_mysql_database.txt · Last modified: 06.22.2009 14:51 by nyeates1
Recent changes RSS feed Creative Commons License Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki