#C.2. Procedure
The following steps show how an existing Zenoss installation can be configured to use a specific MySQL server.
Initialize the new database.
As a super-privileged user on the MySQL server, create the Zenoss events database schema. The
zenevents.sql
andzenprocs.sql
files are located in$ZENHOME/Products/ZenEvents/db
on y our Zenoss server. Replace 10.1.2.30 with the IP address of your Zenoss server, and replace the password with your password.From the MySQL client, run these commands:
CREATE DATABASE events; \. zenevents.sql \. zenprocs.sql GRANT ALL PRIVILEGES ON events.* to zenoss@10.1.2.30 identified by 'password'; FLUSH PRIVILEGES;
Configure Zenoss to use the new database.
In the Zenoss Web interface, navigate to Event Manager. (You must be assigned the Manager role to do this.)
In the Connection Information section, adjust field values as needed. Replace 10.1.2.40 with the IP address of your MySQL server.
User Name = zenoss
Password = password
Database = events
Hostname = 10.1.2.40
Port = 3306
Click Save.
Restart Zenoss.
Note
The Zenoss installation
--help
option lists command-line options for setting up a remote MySQL server.