David, thanks for the reply.<br><br>I've actually decided to do this within an openser dialplan lookup before the freeswitch media box gets hit.<br><br>However, it would be useful if there are any docs/examples around of how to listen for and modify events using a lua startup script.<br>
<br>Pete<br><br><div class="gmail_quote">On 2 September 2010 20:32, David Ponzone <span dir="ltr"><<a href="mailto:david.ponzone@ipeva.fr">david.ponzone@ipeva.fr</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div style="word-wrap: break-word;">Pete,<div><br></div><div>define "heavy" :)</div><div>How much time does it take to get the reply from your DB ?</div><div><br></div><div>Consider also that 100 concurrent calls, it's nothing.</div>
<div>If you consider an avg call duration of 1 min, it's around 1,6CPS.</div><div>Don't you think your DB can handle that (MS Access probably can't) ?</div><div><br></div><div>You could also extract the XML dialplan containing your regexps (as far as they can be written using the regexp lib provided with FS) from the DB at startup.</div>
<div><br></div><div><div class="im"><div> <span style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;"><div style="word-wrap: break-word;">
<span style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;"><div style="word-wrap: break-word;">
<div><font face="'Helvetica Neue'"><font color="#1c00ff">David Ponzone </font><font color="#000000" size="3"><span style="font-size: 12px;">Direction Technique</span></font></font></div><div><font face="'Helvetica Neue'"><font size="3"><span style="font-size: 13px;">email: <a href="mailto:david.ponzone@ipeva.fr" target="_blank">david.ponzone@ipeva.fr</a></span></font></font></div>
<div><font face="'Helvetica Neue'"><font size="3"><span style="font-size: 13px;">tel: 01 74 03 18 97</span></font></font></div><div><font face="'Helvetica Neue'"><font size="3"><span style="font-size: 13px;">gsm: 06 66 98 76 34</span></font></font></div>
<div><font face="'Helvetica Neue'"><br></font></div><div><font color="#1c00ff" face="'Helvetica Neue'">Service Client<span> </span></font><font face="'Helvetica Neue'"><font color="#ff0000">IP</font></font><font color="#1c00ff" face="'Helvetica Neue'">eva</font></div>
<div><font color="#1c00ff" face="'Helvetica Neue'"><span style="color: rgb(0, 0, 0); font-family: Helvetica;"><div><font face="'Helvetica Neue'"><font size="3"><span style="font-size: 13px;">tel: 0811 46 26 26</span></font></font></div>
<div><font face="'Helvetica Neue'" size="3"><span style="font-size: 13px;"><div style="margin: 0px; color: rgb(0, 34, 243);"><span style="text-decoration: underline;"><a>www.ipeva.fr</a></span><span style="color: rgb(101, 104, 149);"> - <span style="color: rgb(0, 34, 243); text-decoration: underline;"><a>www.ipeva-studio.com</a></span></span></div>
<div style="margin: 0px; color: rgb(0, 34, 243);"><span style="text-decoration: underline;"><br></span></div><div style="margin: 0px; color: rgb(0, 34, 243);"><span><div style="margin: 0px; text-align: justify; color: rgb(192, 192, 192);">
<i>Ce message et toutes les pièces jointes sont confidentiels et établis à l'intention exclusive de ses destinataires. Toute utilisation ou diffusion non autorisée est interdite. Tout message électronique est susceptible d'altération. </i><b><i>IPeva</i></b><i> décline toute responsabilité au titre de ce message s'il a été altéré, déformé ou falsifié. Si vous n'êtes pas destinataire de ce message, merci de le détruire immédiatement et d'avertir l'expéditeur.</i></div>
<div style="text-decoration: underline; text-align: justify;"><font color="#c0c0c0"><i><br></i></font></div></span></div></span></font></div></span></font></div></div></span><br></div></span><br> </div><br></div><div><div>
Le 01/09/2010 à 21:19, Pete Kelly a écrit :</div><br><blockquote type="cite"><div><div></div><div class="h5">Hi<div><br></div><div>I am new to freeswitch, so please excuse me if I have some terminology slightly wrong! I am writing an IVR application using mod_lua, to do simple auth then enter a menu tree etc.</div>
<div><br></div> <div>I need to "preprocess" the incoming SIP INVITE by running a series of regular expressions (which are stored in a mysql database) against the request URI (and/or From header), to add an extra header to the INVITE for internal use.</div>
<div><br></div><div>I only want to read in the regular expressions from the database at "startup" (or by a controlled reload), as the query to get them is quite heavy and the IVR will be handling upwards of 100 concurrent calls - so to query for the regex list on each INVITE is impractical.</div>
<div><br></div><div>Is this startup scenario possible? Two options that I think I might have are:</div><div><br></div><div>1) Have a lua startup script which reads the regex list in at startup, and listens for incoming call events. I would then apply the header within the lua script before the dialplan extension is looked up. Does anyone have any examples, or know of any documentation which shows something similar to this happening. I have searched the wiki high and low but can only find very basic documentation on event handling in lua, and startup scripts in lua.</div>
<div><br></div><div>2) Have the regular expressions stored somewhere within the dialplan (global variables?) and make it part of a dialplan extension to add this header.</div><div><br></div><div><br></div><div>Any advice or tips anybody could give me will be very helpful.</div>
<div><br></div><div>Thanks</div><div><br>Pete</div></div></div><div class="im"> _______________________________________________<br>FreeSWITCH-users mailing list<br><a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br></div></blockquote></div><br></div></div><br>_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div><br>