List:Internals« Previous MessageNext Message »
From:Sonam Chauhan Date:November 13 2000 4:27am
Subject:Question on detailed logging
View as plain text  
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
Thread
Question on detailed loggingSonam Chauhan13 Nov