Re: Monitor mysql data directory

Hi,
I tried to use incron for monitoring MySQL database changes and
encountered these facts:
1. If I use a system table (/etc/incron.d/...) or an user table
(natively under "root" or "mysql") it works as expected. I tested it
both for MyISAM and InnoDB.
2 If I use incrontab -u it causes segfault. But this is a reported bug
with an existing patch (#0000187). The only problem is that I haven't
released the appropriate bugfix version yet.

You can try the following solution:
1. Create a system table for the event.
2. Write a script which drops root privileges first (in other words,
switches to a regular user such as "mysql") and then does what you want.

Please report whether it succeeds. Thanks.

Lukas

> Hi everyone,
>
> I'm trying to set up a system where a php script is fired whenever a
> mysql table is updated and I'm wondering if anyone has had any luck
> doing anything similar. (In case you're wondering why: a client needs
> an api call made to ebay whenever an inventory table is updated. He is
> trying to do multi-channel sales and doesn't want to adjust stock
> manually in each channel).
> I considered using a MySQL UDF but decided against it since the only
> one that could call an external script is sys_exec, and even the
> author of that recommends against using it because it's a security
> hazard.
> Leaving aside the issue that incrontab is also a security hazard...
>
> I want to know if anyone's had any luck setting up incron jobs that
> monitor the mysql data directory. I set up an incrontab for mysql and
> inserted
>
> /path/to/datadirectory/dbname/tablename.MYD IN_MODIFY /path/to/php
> /path/to/script.php
>
> "Script.php" is a hello world type script that sends me an email, and
> I checked that it works "on its own".
>
>
> After reading that a backslash needed to be added to escape the space
> in the command I changed it to:
>
>
> /path/to/datadirectory/dbname/tablename.MYD IN_MODIFY /path/to/php\
> /path/to/script.php
>
> I switched to root, and then I reloaded as the mysql user using
> incrontab -u mysql -d. I updated the table, still no dice. I checked
> that the ".MYD" file had in fact been modified. No luck.
>
> I'm stumped.
>
> Has anyone here played around with this sort of thing and had any
> success?
>
> Thanks in advance,
>
> Gabe
> Salisbury MD
>
>
>
>
>
>
>
>
>
>
Received on Tue Jun 05 2012 - 22:14:21 CEST