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?