This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
network:mysql_syslog [2014/03/11 12:34] tschulz [Enable Mysql in syslog-ng] |
network:mysql_syslog [2014/03/11 13:18] (current) tschulz [Enable Mysql in syslog-ng] |
||
---|---|---|---|
Line 33: | Line 33: | ||
KEY `facility` (`facility`) | KEY `facility` (`facility`) | ||
) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
+ | </file> | ||
+ | |||
+ | ===== Grant Permissions to database ===== | ||
+ | <file sql> | ||
+ | CREATE USER 'syslog'@'localhost' IDENTIFIED BY '***'; | ||
+ | GRANT USAGE ON * . * TO 'syslog'@'localhost' IDENTIFIED BY '***' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; | ||
+ | GRANT ALL PRIVILEGES ON `syslog` . * TO 'syslog'@'localhost'; | ||
</file> | </file> | ||
===== Enable Mysql in syslog-ng ===== | ===== Enable Mysql in syslog-ng ===== | ||
- | you will need to grant permissions to the user syslog to the database syslog from localhost | ||
<file sql /etc/syslog-ng/conf.d/10mysqlsyslog.conf> | <file sql /etc/syslog-ng/conf.d/10mysqlsyslog.conf> | ||
filter f_no_debug { not level(debug); }; | filter f_no_debug { not level(debug); }; |