List:Internals« Previous MessageNext Message »
From:Mariella Petrini Date:March 26 2008 4:38pm
Subject:Re: mysql 5.1.23 and syslog for query log: more questions, plz
View as plain text  
Hi,

I have tried MySQL and syslog-ng with both directives
file and named pie and it works properly.
I have tried also using MySQL with named pipe and
syslog-ng over the network and works fine as well.

Thanks !!!

Mariella


--- Sergei Golubchik <serg@stripped> wrote:

> Hi!
> 
> On Mar 18, Mariella Petrini wrote:
> > 
> > I would like to ask more questions, please,
> related to
> > mysqld and syslog logging for general log and
> slow-log
> > and using syslog-ng.
> > 
> > Would it make sense, which could be the best way
> and
> > which could be the cons of trying to make mysqld
> code
> > working with syslog-ng ?
> > Or is there an easier way of doing that ?
> 
> The simplest way is, indeed, speficic to syslog-ng.
> But looks like it's
> what you want anyway :)
> 
> syslog-ng can use a file or a unix pipe as a source.
> Try
> 
> source testfile { file("/tmp/logfile" follow_freq(1)
> flags(no-parse)); };
> 
> or
> 
> source testpipe { pipe("/tmp/logpipe"
> flags(no-parse)); };
> 
> in your syslog-ng.conf, then use them in log {}
> directive, and configure
> MySQL to log to a specified file or a pipe.
>  
> Regards / Mit vielen Grüssen,
> Sergei
> 
> -- 
>    __  ___     ___ ____  __
>   /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik
> <serg@stripped>
>  / /|_/ / // /\ \/ /_/ / /__  Principal Software
> Developer/Server Architect
> /_/  /_/\_, /___/\___\_\___/  MySQL GmbH, Dachauer
> Str. 37, D-80335 München
>        <___/                  Geschäftsführer: Kaj
> Arnö - HRB München 162140
> 
> -- 
> MySQL Internals Mailing List
> For list archives: http://lists.mysql.com/internals
> To unsubscribe:   
>
http://lists.mysql.com/internals?unsub=1
> 
> 



      ____________________________________________________________________________________
Looking for last minute shopping deals?  
Find them fast with Yahoo! Search. 
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
Thread
Re: mysql 5.1.23 and syslog for query log: more questions, plzMariella Petrini18 Mar
  • Re: mysql 5.1.23 and syslog for query log: more questions, plzSergei Golubchik24 Mar
    • Re: mysql 5.1.23 and syslog for query log: more questions, plzMariella Petrini26 Mar
Re: mysql 5.1.23 and syslog for query log: more questions, plzMariella Petrini25 Mar
  • Re: mysql 5.1.23 and syslog for query log: more questions, plzChad MILLER25 Mar