User Tools
network:mysql_syslog
Differences
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 13:18] tschulz [Create database] |
network:mysql_syslog [2014/03/11 13:18] (current) tschulz [Enable Mysql in syslog-ng] |
||
|---|---|---|---|
| Line 36: | Line 36: | ||
| ===== Grant Permissions to database ===== | ===== Grant Permissions to database ===== | ||
| - | <file> | + | <file sql> |
| CREATE USER 'syslog'@'localhost' IDENTIFIED BY '***'; | 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 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'; | GRANT ALL PRIVILEGES ON `syslog` . * TO 'syslog'@'localhost'; | ||
| </file> | </file> | ||
| Line 46: | Line 44: | ||
| ===== 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); }; | ||
network/mysql_syslog.1394561893.txt.gz · Last modified: 2014/03/11 13:18 by tschulz
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
