[asterisk-users] Trigger Asterisk after data inserted in mysql

David Cook dbc_asterisk at advan.ca
Wed Sep 19 13:04:33 CDT 2012

It looks like the answer is yes.


 From the page, here is code to execute a UDF library and call a shell. 
Clearly there would be a heavy penalty to launching a shell so you would 
want to carefully evaluate the frequency this is executed on your system.
|CREATE| |TRIGGER| |Test_Trigger |
|AFTER| |INSERT| |ON| |MyTable |
|||DECLARE| |cmd ||CHAR||(255);|
|||DECLARE| |result ||int||(10);|
|||SET| |cmd=CONCAT(||'sudo /home/sarbac/hello_world '||,||'Sarbajit'||);|
|||SET| |result = sys_exec(cmd);|


> Message: 1
> Date: Tue, 18 Sep 2012 15:41:46 -0400
> From: Ahmed Munir <ahmedmunir007 at gmail.com>
> Subject: [asterisk-users] Trigger Asterisk after data inserted in
> 	mysql
> To: asterisk-users at lists.digium.com
> Message-ID:
> 	<CAGMN=JdbE5FdDSQXxZ9OrWXu3Pvgc-hj-EnPxUrG=RJHGSD-eg at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
> Hi all,
> I would like to know, is there a way to trigger Asterisk after data
> inserted into mysql DB? Like here what I'm trying to do, when the new data
> inserted into MySQL DB, it sends the request to Asterisk along with the new
> data (that is inserted in DB) for making outbound call i.e. Realtime.
> Currently I've set a cron job that execute my script every 30 seconds and
> checks for a new data in DB. If new data is inserted in 30 seconds that
> script will run and sends the data to Asterisk for making calls. (This is
> the case which I'm thinking to avoid)
> Please advise.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20120919/f7589552/attachment.htm>

More information about the asterisk-users mailing list