Unix Technical Forum

loging to syslog

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 ...


Go Back   Unix Technical Forum > Database Server Software > MySQL

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-28-2008, 10:04 AM
sbk
 
Posts: n/a
Default loging to syslog

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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-28-2008, 10:04 AM
lark
 
Posts: n/a
Default Re: loging to syslog

== 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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 05:58 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com