This is a discussion on loging to syslog within the MySQL forums, part of the Database Server Software category; --> how do i log errors (and queries and 'slow queries') to syslog? i don't want to maintain a bunch ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| how do i log errors (and queries and 'slow queries') to syslog? i don't want to maintain a bunch of individual log files ... i want to log everything to syslog in my.cnf, i've tried: [mysqld_safe] syslog and [mysqld_safe] log=/var/log/syslog log-error=/var/log/syslog log-slow-queries=/var/log/syslog without much success --sk stuart kendrick fhcrc |
| ||||
| == Quote from sbk (skendric@fhcrc.org)'s article > how do i log errors (and queries and 'slow queries') to syslog? > i don't want to maintain a bunch of individual log files ... i want to > log everything to syslog > in my.cnf, i've tried: > [mysqld_safe] > syslog > and > [mysqld_safe] > log=/var/log/syslog > log-error=/var/log/syslog > log-slow-queries=/var/log/syslog > without much success > --sk > stuart kendrick > fhcrc this could really mess up your syslog; however, if you're hell bent on doing it, you ought to make sure that the mysql server has the right to write to your syslog. this is usually reserved only for root. but again, this can really be messy. alternatively, you could place mysql logs under /var/log/mysql or something similar. -- POST BY: lark with PHP News Reader |