Hi Steven, you can have MySQL log errors into syslog via the --syslog options for mysqld, see https://dev.mysql.com/doc/refman/5.7/en/mysqld-safe.html#option_mysqld_safe_syslog and http://mysqlserverteam.com/logging-with-mysql-error-logging-to-syslog-eventlog/ .
If you want to additionally send the slow query logs of MySQL, you'll need to tail the file MySQL writes the slow query log into (see https://dev.mysql.com/doc/refman/5.7/en/slow-query-log.html) and send it to Graylog via GELF. You can use nxlog, logstash, or our very own and shiny Graylog Agent (to be released together with Graylog 1.1.0) for this. For configuring your syslog daemon to send log messages to Graylog, please refer to our documentation at http://docs.graylog.org/en/1.0/pages/sending_data.html#syslog. Cheers, Jochen On Wednesday, 6 May 2015 13:59:40 UTC+2, Steven Broschat wrote: > > This request for help is specific to sending log data to graylog using > syslog-ng then analyzing the mysql servers logs from within graylog. > Primary Question is, How can I achieve this? FYI, I do have a running > stack just not logging any mysql data such as user data, queries data yet. > > Please offer constructive and helpful suggestions, Thank You, > P.S. I have been researching this for a few days and have not found any > conclusive instructions.. > -- You received this message because you are subscribed to the Google Groups "graylog2" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
