List:General Discussion« Previous MessageNext Message »
From:sasha Date:November 13 2000 4:20pm
Subject:Re: Question on detailed logging
View as plain text  
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
       <___/
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