From: sasha
Date: November 13 2000 4:20pm
Subject: Re: Question on detailed logging
List-Archive: http://lists.mysql.com/mysql/56184
Message-Id: <3A1014D1.EC5002C8@mysql.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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
       <___/