List:General Discussion« Previous MessageNext Message »
From:Sonam Chauhan Date:November 13 2000 10:48pm
Subject:Re: Question on detailed logging
View as plain text  
Hi Sasha: 

I was looking for passing some additional information from the client 
to mySQL and this information making it's way to the logs. 

Specifically, I would like to pass a *website* username from Apache/mod_perl DBI, 
(as opposed to passing a *mysql* username) and this information being added to a
log file. 
Thanks for your information on the binary log.

Kind Regards,
Sonam

sasha@stripped wrote:
> 
> Sonam Chauhan wrote:
> >
> > Is it possible to add additional query-specific information to the MySQL update
> log ?
> >
> > e.g.:
> > ----------LOG EXCERPT------------------------
> > # User: jj-332 Time: 2000-10-20-22:32
> > insert into users set user="ass", ccode = "ass";
> >
> > # User: jj-323 Time: 2000-10-20-22:32
> > insert into users set user="ass", ccode = "ewtkwj";
> >
> > # User: jj-344 Time: 2000-10-20-22:32
> > insert into users set user="ass", ccode = "ewtkwj";
> > ----------/LOG EXCERPT------------------------
> >
> > This essentially would work as an audit trail.
> >
> > It would need to pick up additional parameters from the client
> > (eg: authenticated webserver user)
> > The mySQL server would then add these params to the update log
> >
> > Could you cc: me on all replies? I'm not subscribed to all 3 lists.
> >
> > Regards,
> > Sonam Chauhan
> >
> > Electronic Commerce
> > Corporate Express Australia Ltd.
> > Phone: +61-2-9335-0725 Fax: +61-2-9335-0753
> 
> This information is available in the binary log in the latest 3.23 version. You
> will need to run mysqlbinlog to see it.
> 
> --
> MySQL Development Team
>    __  ___     ___ ____  __
>   /  |/  /_ __/ __/ __ \/ /   Sasha Pachev <sasha@stripped>
>  / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
> /_/  /_/\_, /___/\___\_\___/  Provo, Utah, USA
>        <___/

-- 
Sonam Chauhan
Electronic Commerce
Corporate Express Australia Ltd.
Phone: +61-2-9335-0725 Fax: +61-2-9335-0753
Thread
Problems while pre-compilation configureingRobert Wirth24 Mar
  • Problems while pre-compilation configureingMichael Widenius24 Mar
  • Re: Question on detailed loggingsasha13 Nov
  • Re: Question on detailed loggingSonam Chauhan14 Nov
  • Re: Question on detailed loggingsasha14 Nov
  • Re: Question on detailed loggingSonam Chauhan14 Nov
  • Re: Question on detailed loggingSonam Chauhan16 Nov