Correct me if I'm wrong or don't know anything other than AMI Originate Event or a call file to kick start a call from asterisk ! So making a new or modifying asterisk call-file cron job/poller seems like a nice idea but why put on extra load on Asterisk. (See pbx_spool.c if still want to modify). <div>
The simple idea is create a MySQL trigger for your Table insertion, the data in the table at insertion time becomes parameters for a simple script that triggers an AMI event (or call file) whichever is easier for you.<br>
<br><div class="gmail_quote">On Tue, Sep 27, 2011 at 6:54 PM, Nick Khamis <span dir="ltr"><<a href="mailto:symack@gmail.com">symack@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Hello David,<br>
<br>
At first I assumed asterisk used call files out of the box for<br>
normal-initiated/instantiated calls however,<br>
this is incorrect. I think call files was the easy approach for client<br>
just to place a file with call details<br>
in some location. I am trying to do the same with a db record. My<br>
first question is, how does asterisk<br>
initiate calls, i.e. what part of the source code is responsible for<br>
that. Are there any threads involved etc.<br>
<br>
Cheers,<br>
<font color="#888888"><br>
Nick.<br>
</font><div><div></div><div class="h5"><br>
On Tue, Sep 27, 2011 at 9:35 AM, David Moring <<a href="mailto:DMoring@tmcentral.net">DMoring@tmcentral.net</a>> wrote:<br>
> Hi Nick,<br>
><br>
> Understand your reasoning - though as Matt points out sql db isn't in the<br>
> core so compiling it there would preclude seemless upgrades. Also, I<br>
> personally would be concerned putting the calls right into the call-file<br>
> thread might create an issue if you hung on a db query or insert. Finally<br>
> (and I'd love to hear the answer not knowing), but I believe<br>
> "normally-initiated/instantiated" calls are handled with direct calls via<br>
> either SIP requests and/or AMI - thus even using the proposed method, I<br>
> *think* the db/file-drop method is going to create some overhead that might<br>
> not scale well...<br>
><br>
> Best,<br>
><br>
> David<br>
><br>
> -----Original Message-----<br>
> From: Nick Khamis <<a href="mailto:symack@gmail.com">symack@gmail.com</a>><br>
> To: Asterisk Users Mailing List - Non-Commercial Discussion<br>
> <<a href="mailto:asterisk-users@lists.digium.com">asterisk-users@lists.digium.com</a>><br>
> Date: Mon, 26 Sep 2011 18:49:07 -0400<br>
> Subject: Re: [asterisk-users] Asterisk Realtime Time Dial App<br>
><br>
> Hello David,<br>
><br>
> Thank you so much for your response. I am sure it can be easily done<br>
> using AGI. The reason I am leaning more<br>
> towards storing the call information in a database record, is because<br>
> our existing client applications can be easily<br>
> modified to write to MySQL. The asterisk cron/thread that would<br>
> querying the DB should be no different than existing implementation<br>
> used process the call files?<br>
> For those of you that may be interested in what we are doing. We are<br>
> developing an application that will apply NLP<br>
> services on text generated using the speech to text module, and<br>
> generate the response that will then be forwarded to<br>
> the text to speech.<br>
><br>
> Cheers,<br>
><br>
> Nick<br>
> .<br>
><br>
><br>
><br>
</div></div><div><div></div><div class="h5">> --<br>
> _____________________________________________________________________<br>
> -- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
> New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
> <a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
><br>
> asterisk-users mailing list<br>
> To UNSUBSCRIBE or update options visit:<br>
> <a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>
><br>
<br>
--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>
</div></div></blockquote></div><br></div>