[KLUG Members] triggering a program

[Adam Tauno Williams]

> > > I can probably use Curl for Box 2 to talk to Box 3, but what would  
> > > start
> > > it?
> > What DB are you running? I would look at the stored procedure options  
> > for your db and see if you can fire off a script post insert or  
> > something as a trigger.
> The DB is MySQL 4.11.14.  I don't see stored procedures, functions, and
> triggers available until 5.x
> So, if I can't use a db trigger, are there other ideas?

It gets much uglier.  I don't know enough about MySQL but can you
identify the file that contains the table in question?  You can probably
watch it for modification via fam and then poll it for changes.
http://oss.sgi.com/projects/fam/faq.html#why_use_fam

Those are the only two mechanisms I can think of:  DB triggers or FAM.

Or, if MySQL 4.x supports auditing you might be able to poll the
journal.  But I doubt it does if it doesn't do triggers.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://www.kalamazoolinux.org/pipermail/members/attachments/20060216/b796e4bb/attachment.bin