Archived community.zenoss.org | full text search
Skip navigation
Currently Being Moderated

C.2. Procedure

VERSION 1 
Created on: Oct 26, 2009 4:19 PM by Zenoss API - Last Modified:  Oct 26, 2009 4:19 PM by Zenoss API

#C.2. Procedure

The following steps show how an existing Zenoss installation can be configured to use a specific MySQL server.

  1. Initialize the new database.

    As a super-privileged user on the MySQL server, create the Zenoss events database schema. The zenevents.sql and zenprocs.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;
  2. Configure Zenoss to use the new database.

    1. In the Zenoss Web interface, navigate to Event Manager. (You must be assigned the Manager role to do this.)

    2. 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

    3. Click Save.

    4. Restart Zenoss.

    Note

    The Zenoss installation --help option lists command-line options for setting up a remote MySQL server.

Comments (0)