MySQL Database Output Module [mysql_out]

Description

Updates a MySQL database table with log events. The database maintains realtime status information of the network (similar to LooperDB, Netcool/OMNIbus etc.). The basic schema is available in conf/mysql/create_db.sql and described below. The mechanism used to insert / update / correlate / prevent duplicate events in the database is similar to what is used by LooperDB and Netcool.

Database Schema

This schema can be extended, but the fields below cannot be removed without tweaking the module.

create table events_state
(
        Identifier      varchar(255) not null primary key,
        Serial          int not null auto_increment,
        Node            varchar(64),
        NodeAlias       varchar(64),
        Manager         varchar(64),
        Agent           varchar(64),
        AlertGroup      varchar(64),
        AlertKey        varchar(64),
        Severity        int,
        Summary         varchar(255),
        StateChange     timestamp,
        FirstOccurrence timestamp,
        LastOccurrence  timestamp,
        InternalLast    timestamp,
        Poll            int,
        Type            int,
        Tally           int,
        Class           int,
        Grade           int,
        OtherInfo       text,
        Location        varchar(255),
        URL             varchar(255),
        OwnerUID        int,
        OwnerGID        int,            -- Groups Option
        Acknowledged    int,
        Flash           int,            -- Flash Option
        ServerName      varchar(64),
        ServerSerial    int,
        index main (Serial)
);

Configuration Tokens

host: Hostname or IP address of MySQL host.
port: MySQL listen port address (3306).
database: Database name (netmanager).
statetable: Table name (events_state).
username: User Name (nmuser).
password: Password (nmuser).
debugmode: Debug Level
debugmessages: Path to file to log debug messages

Output Tokens

Include all fields required for insertion / update in the hash. See schema for more details.

__update__: Comma separated list of fields for which updates are forced.

Return to Module Reference