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
