Re: [asterisk-users] Trigger Asterisk after data inserted in MySQL
Thanks Bryant and David for sharing.
From: Bryant Zimmerman brya...@zktech.com
Subject: Re: [asterisk-users] Trigger Asterisk after data inserted in
mysql
To: Asterisk Users Mailing List - Non-Commercial Discussion
asterisk-users@lists.digium.com
Message-ID: 4d5734ed$7d50d85e$77bd1cd6$@zktech.com
Content-Type: text/plain; charset=us-ascii
David
The way we do this is to have a trigger insert into a batch table. This
table can be polled from a secondary process. That process/service is
responsible for monitoring, working and cleanup. This allows for you to
poll a highly optimized table without taking the db performance hit from
larger tables that will grow over time. We process millions of cdr and
process records a day this way. It also allows you balanced process loads
across multiple servers. This can be extremely important on systems that
are more heavily loaded. It also allows you to remove process load and
latencies from the database servers.
Thanks
Bryant Zimmerman (ZK Tech Inc.)
616-855-1030 Ext. 2003
From: David Cook dbc_aster...@advan.ca
Sent: Wednesday, September 19, 2012 2:04 PM
To: asterisk-users@lists.digium.com
Subject: Re: [asterisk-users] Trigger Asterisk after data inserted in
mysql
It looks like the answer is yes.
http://crazytechthoughts.blogspot.ca/2011/12/call-external-program-from-mysq
l.html
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.
DELIMITER @@ CREATE TRIGGER Test_Trigger AFTER INSERT ON MyTable FOR
EACH ROW BEGIN DECLARE cmd CHAR(255); DECLARE result int(10); SET
cmd=CONCAT('sudo /home/sarbac/hello_world ','Sarbajit'); SET result =
sys_exec(cmd); END; @@ DELIMITER ;
-dbc
Message: 1 Date: Tue, 18 Sep 2012 15:41:46 -0400 From: Ahmed Munir
ahmedmunir...@gmail.com Subject: [asterisk-users] Trigger Asterisk after
data inserted inmysql To: asterisk-users@lists.digium.comMessage-ID:
CAGMN=JdbE5FdDSQXxZ9OrWXu3Pvgc-hj-EnPxUrG=
rjhgsd...@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/b8c396a7/attachment.htm
--
--
Regards,
Ahmed Munir Chohan
--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Trigger Asterisk after data inserted in mysql
It looks like the answer is yes. http://crazytechthoughts.blogspot.ca/2011/12/call-external-program-from-mysql.html 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. | DELIMITER @@| |CREATE| |TRIGGER| |Test_Trigger | |AFTER| |INSERT| |ON| |MyTable | |FOR| |EACH ROW | |BEGIN| |||DECLARE| |cmd ||CHAR||(255);| |||DECLARE| |result ||int||(10);| |||SET| |cmd=CONCAT(||'sudo /home/sarbac/hello_world '||,||'Sarbajit'||);| |||SET| |result = sys_exec(cmd);| |END||;| |@@| |DELIMITER ; | -dbc Message: 1 Date: Tue, 18 Sep 2012 15:41:46 -0400 From: Ahmed Munir ahmedmunir...@gmail.com Subject: [asterisk-users] Trigger Asterisk after data inserted in mysql To: asterisk-users@lists.digium.com Message-ID: CAGMN=JdbE5FdDSQXxZ9OrWXu3Pvgc-hj-EnPxUrG=rjhgsd...@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. -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Trigger Asterisk after data inserted in mysql
David
The way we do this is to have a trigger insert into a batch table. This
table can be polled from a secondary process. That process/service is
responsible for monitoring, working and cleanup. This allows for you to
poll a highly optimized table without taking the db performance hit from
larger tables that will grow over time. We process millions of cdr and
process records a day this way. It also allows you balanced process loads
across multiple servers. This can be extremely important on systems that
are more heavily loaded. It also allows you to remove process load and
latencies from the database servers.
Thanks
Bryant Zimmerman (ZK Tech Inc.)
616-855-1030 Ext. 2003
From: David Cook dbc_aster...@advan.ca
Sent: Wednesday, September 19, 2012 2:04 PM
To: asterisk-users@lists.digium.com
Subject: Re: [asterisk-users] Trigger Asterisk after data inserted in
mysql
It looks like the answer is yes.
http://crazytechthoughts.blogspot.ca/2011/12/call-external-program-from-mysq
l.html
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.
DELIMITER @@ CREATE TRIGGER Test_Trigger AFTER INSERT ON MyTable FOR
EACH ROW BEGIN DECLARE cmd CHAR(255); DECLARE result int(10); SET
cmd=CONCAT('sudo /home/sarbac/hello_world ','Sarbajit'); SET result =
sys_exec(cmd); END; @@ DELIMITER ;
-dbc
Message: 1 Date: Tue, 18 Sep 2012 15:41:46 -0400 From: Ahmed Munir
ahmedmunir...@gmail.com Subject: [asterisk-users] Trigger Asterisk after
data inserted inmysql To: asterisk-users@lists.digium.com Message-ID:
CAGMN=JdbE5FdDSQXxZ9OrWXu3Pvgc-hj-EnPxUrG=rjhgsd...@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.
--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Trigger Asterisk after data inserted in mysql
On Wed, 19 Sep 2012 14:04:33 -0400 David Cook dbc_aster...@advan.ca wrote: It looks like the answer is yes. I thought the answer was 42. If you're going to top-post (which is against the rules on this list), the least you can do is phrase your answers in a way that illustrates the question. Thanks! -- C. Chad Wallace, B.Sc. The Lodging Company http://www.lodgingcompany.com/ OpenPGP Public Key ID: 0x262208A0 -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Trigger Asterisk after data inserted in mysql
Hello David,If you're going to top-post (which is against the rules on this list),I apologize if mistaken, but out of curiosity, can you please refer me to where in the rules it says that we can not top-post in this list?ThanksChristian SavinovichVoIP Telephony Consultant646-982-3572 Original Message Subject: Re: [asterisk-users] Trigger Asterisk after data inserted in mysql From: Chad Wallace cwall...@lodgingcompany.com Date: Wed, September 19, 2012 4:30 pm To: asterisk-users@lists.digium.com On Wed, 19 Sep 2012 14:04:33 -0400 David Cook dbc_aster...@advan.ca wrote: It looks like the answer is yes. I thought the answer was 42. If you're going to top-post (which is against the rules on this list), the least you can do is phrase your answers in a way that illustrates the question. Thanks! -- C. Chad Wallace, B.Sc. The Lodging Company http://www.lodgingcompany.com/ OpenPGP Public Key ID: 0x262208A0 -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Trigger Asterisk after data inserted in mysql
On Wed, 19 Sep 2012 13:44:47 -0700 C. Savinovich c.savinov...@itntelecom.com wrote: Hello David, If you're going to top-post (which is against the rules on this list), I apologize if mistaken, but out of curiosity, can you please refer me to where in the rules it says that we can not top-post in this list? It's understandable that many are unaware of the rules, since it took some hunting for me to find them again. They aren't mentioned at all on any of the mailman pages at lists.digium.com. The rules can be found here: http://www.asterisk.org/community/rules Anyway, there are many who like to top-post, and I'm not interested in a holy war. I just wanted to point out that if you want to top-post, it may be worthwhile to consider ways to minimize the impact--like phrasing the answer so that the question is immediately apparent, and you don't force your readers to scroll down, possibly dodging signatures, disclaimers, pasted logs, and dragons, just to get to the question being answered. Original Message Subject: Re: [asterisk-users] Trigger Asterisk after data inserted in mysql From: Chad Wallace cwall...@lodgingcompany.com Date: Wed, September 19, 2012 4:30 pm To: asterisk-users@lists.digium.com On Wed, 19 Sep 2012 14:04:33 -0400 David Cook dbc_aster...@advan.ca wrote: It looks like the answer is yes. I thought the answer was 42. If you're going to top-post (which is against the rules on this list), the least you can do is phrase your answers in a way that illustrates the question. Thanks! -- C. Chad Wallace, B.Sc. The Lodging Company http://www.lodgingcompany.com/ OpenPGP Public Key ID: 0x262208A0 -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- C. Chad Wallace, B.Sc. The Lodging Company http://www.lodgingcompany.com/ OpenPGP Public Key ID: 0x262208A0 -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Trigger Asterisk after data inserted in mysql
If you're going to top-post (which is against the rules on this list), I agree with you. Just really wanted to locate where it was defined.Christian SavinovichVoIP Telephony Consultant646-982-3572 Original Message Subject: Re: [asterisk-users] Trigger Asterisk after data inserted in mysql From: Chad Wallace cwall...@lodgingcompany.com Date: Wed, September 19, 2012 5:14 pm To: asterisk-users@lists.digium.com On Wed, 19 Sep 2012 13:44:47 -0700 "C. Savinovich" c.savinov...@itntelecom.com wrote: Hello David, If you're going to top-post (which is against the rules on this list), I apologize if mistaken, but out of curiosity, can you please refer me to where in the rules it says that we can not top-post in this list? It's understandable that many are unaware of the rules, since it took some hunting for me to find them again. They aren't mentioned at all on any of the mailman pages at lists.digium.com. The rules can be found here: http://www.asterisk.org/community/rules Anyway, there are many who like to top-post, and I'm not interested in a holy war. I just wanted to point out that if you want to top-post, it may be worthwhile to consider ways to minimize the impact--like phrasing the answer so that the question is immediately apparent, and you don't force your readers to scroll down, possibly dodging signatures, disclaimers, pasted logs, and dragons, just to get to the question being answered. Original Message Subject: Re: [asterisk-users] Trigger Asterisk after data inserted in mysql From: Chad Wallace cwall...@lodgingcompany.com Date: Wed, September 19, 2012 4:30 pm To: asterisk-users@lists.digium.com On Wed, 19 Sep 2012 14:04:33 -0400 David Cook dbc_aster...@advan.ca wrote: It looks like the answer is yes. I thought the answer was 42. If you're going to top-post (which is against the rules on this list), the least you can do is phrase your answers in a way that illustrates the question. Thanks! -- C. Chad Wallace, B.Sc. The Lodging Company http://www.lodgingcompany.com/ OpenPGP Public Key ID: 0x262208A0 -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- C. Chad Wallace, B.Sc. The Lodging Company http://www.lodgingcompany.com/ OpenPGP Public Key ID: 0x262208A0 -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] Trigger Asterisk after data inserted in mysql
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. -- Regards, Ahmed Munir Chohan -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Trigger Asterisk after data inserted in mysql
On 9/18/2012 3:41 PM, Ahmed Munir wrote: 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. You could create a trigger in mysql that calls a shell script that pokes Asterisk properly. Look here for a start: http://forums.mysql.com/read.php?99,170973,236208#msg-236208 -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
