DB select to graylog
Q1. Hello I have one problem about mysql to graylog server
i want my db (version:mariadb 5.5 OS centos 7 ) "SELECT eventlog" to my graylog server
but my nxlog log have error the message is: ERROR im_dbi failed to execute SQL statement. 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE id > -1 LIMIT 10' at line 1
my nxlog.conf
<Extension _syslog> Module xm_syslog </Extension>
<Input in> Module im_dbi Driver mysql Option host 127.0.0.1 Option username root Option password librenms Option dbname librenms SQL SELECT eventlog </Input>
<Output out> Module om_udp Host 192.168.1.20 Port 10514 Exec to_syslog_snare(); </Output>
<Route 1> Path in => out </Route>
so how can i do or where are reference about nxlog for mysql(mariadb) ?
Q2. can i install nxlog-ce to CentOS8?
Hello.
Regarding first point - shouldn't you use FROM clause in your SQL query? And is there any column with id name?
Second one - it should work but not guaranteed as it's CE.
Regards, Arch
