Sends log to traditional RDMBS databases with the use of JDBC.
Use eclise to build + export as JAR.
Use mvn package to create package.
Download graylog2-output-jdbc.jar from releases and put inside /graylog-1.x/plugins folder
Restart Graylog2
Create new output globally or inside stream.
Make sure your RDBMS commit speed is suffcient to handle output message rate.
Graylog does not ship with JDBC drivers. You must add your driver manually AND update graylog2-output-jdbc.jar accordingly.
Add following line to graylog2-output-jdbc.jar/META-INF/MANIFEST.MF
Class-Path: <driver>.jar
Driver to initialize. Needed so URL can be handled properly.
Default value: NONE
Required. Fully qualified JDBC url to connect to.
Default value: NONE
Optional. Username to connect as. If not specified, no password will be passed to driver.
Default value: NONE
Optional. Password for user.
Default value: NONE
Optional. Comma separated list of additional fields for Message insert query
Default value: NONE
Required. Query to execute to add log entry. Must contain required 4 columns and optional (see Additional fields). Must produce generated key (ID).
Default value: insert into log (message_date, message_id, source, message) values (?, ?, ?, ?)
Optional. If specified all attributes will be added using this query.
Default value: insert into log_attribute (log_id, name, value) values (?, ?, ?)
By default output uses table 'log' for main message entry and 'log_attribute' for attributes.
Sample table creation script:
create table log (
id numeric(10,0),
message_date datetime,
message_id varchar(32),
source varchar(32),
message varchar(255) null
)
create table log_attribute (
id numeric(10,0) identity,
log_id numeric(10,0),
name varchar(255),
value varchar(4096) null
)
Make sure table log, column ID is generates IDs automatically. For example add 'identity' (MS SQL/Sybase ASE) or AUTO_INCREMENT (MySQL) into column definition.
huksley
free!
Thanks! It is a good plugin which I am implementing it; however, I have some issue to set it up. Below are my questions:
1. What should I fill in in "Driver to use"?
2. Is the JDBC URL correct? jdbc:sqlserver://;servername=server123:1433;databaseName=Graylog;
3. Is the authentication supporting "Windows Authentication"? Or only support SQL authentication?
4. Is my graylog2-output-jdbc.jar/META-INF/MANIFEST.MF configuring right?
Manifest-Version: 1.0
Archiver-Version: Plexus Archiver
Created-By: Apache Maven
Built-By: ruslan
Build-Jdk: 1.6.0_65
Class-Path: /home/ubuntu/mssqlserverjdbc/Driver/sqljdbc_4.2/enu/sqljdbc42.jar
5. Where is the log/ error log of using the plugin? What is the log file name?
Thanks a lot for your help