1 - Presenting The Eventlog Plugin

This plugin allows you to view the alerts contained in the database software EventCentral http://xavier.dusart.free.fr

2 - Installation

Very simple:

- Get the tar.gz archive of the plugin - Unzip it in the plugins directory of your installation glpi

3 - Queries to launch on the database EventCentral

ALTER TABLE `events` ADD `ID` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST ;

CREATE TABLE `glpi_dropdown_plugin_eventlog_type` (
        `ID` int(11) NOT NULL auto_increment,
        `name` varchar(255) NOT NULL default '',
        `comments` text,
        PRIMARY KEY  (`ID`),
        KEY `name` (`name`)
            ) TYPE=MyISAM;

INSERT INTO `glpi_dropdown_plugin_eventlog_type` ( `ID` , `name` , `comments` )
VALUES ('1' , 'Error', NULL);

INSERT INTO `glpi_dropdown_plugin_eventlog_type` ( `ID` , `name` , `comments` )
VALUES ('2' , 'Warning', NULL);

INSERT INTO `glpi_dropdown_plugin_eventlog_type` ( `ID` , `name` , `comments` )
VALUES ('3' , 'Ack', NULL);

INSERT INTO `glpi_dropdown_plugin_eventlog_type` ( `ID` , `name` , `comments` )
VALUES ('4' , 'Information', NULL);

INSERT INTO `glpi_dropdown_plugin_eventlog_type` ( `ID` , `name` , `comments` )
VALUES ('8' , 'Audit', NULL);

INSERT INTO `glpi_dropdown_plugin_eventlog_type` ( `ID` , `name` , `comments` )
VALUES ('16' , 'Empty', NULL);

INSERT INTO `glpi_dropdown_plugin_eventlog_type` ( `ID` , `name` , `comments` )
VALUES ('1024' , 'Undefined', NULL);

4 - To do on web site of eventcentral

fichier eventlog.pl

$query = "SELECT SQL_CALC_FOUND_ROWS `events`.*, `acks`.`computer` IS NOT NULL as acked, `acks`.`comment` FROM `events`";

replaced by

$query = "SELECT SQL_CALC_FOUND_ROWS `events`.computer, `events`.`domain`, `events`.`log`, `events`.`source`, `events`.`eventID`, `events`.`type`, `events`.`date`, `events`.`time`, `events`.`user`, `events`.`strings`, `acks`.`computer` IS NOT NULL as acked, `acks`.`comment` FROM `events`";