Daemon to monitor mysql database.

Problems with the Linux version of XAMPP, questions, comments, and anything related.

Daemon to monitor mysql database.

Postby SteveDeFacto » 26. December 2013 12:55

I need to program a daemon which monitors the status of the xampp mysql database. When the database is modified it needs to determine which php script was executed, by what ip it was executed, and with what variables. How can I do this? (Any xampp log files I can monitor to get this information or even parts of this information would be great!)
Posts: 1
Joined: 26. December 2013 12:39
XAMPP Version: 5.6.3
Operating System: Linux

Re: Daemon to monitor mysql database.

Postby Nobbie » 26. December 2013 15:48

I dont think that there is such a tool, because (for example) PHP Scripts are triggered by Apache (and NOT by a client, the client sends a request to Apache and Apache then starts PHP). As well PHP does not change MySQL database, this is done by mysqld (mysql daemon), which is triggered by an PHP Script.

The only thing you can do is to analyze all logfiles you have (Apache, MySQL) and try to find out, which request may cause which change - but this will be hard job without guaranteed success.
Posts: 7486
Joined: 09. March 2008 13:04

Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 5 guests