<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">I am quite happy with FS odbc access, but I don't use it extensively.<div>The only issue I have with it is the syntax to access the data, which I find less intuitive than with luaSQL.</div><div><br><div>
<span class="Apple-style-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; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span class="Apple-style-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; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><font class="Apple-style-span" face="'Helvetica Neue'"><font class="Apple-style-span" color="#1C00FF">David Ponzone </font><font class="Apple-style-span" color="#000000" size="3"><span class="Apple-style-span" style="font-size: 12px; ">Direction Technique</span></font></font></div><div><font class="Apple-style-span" face="'Helvetica Neue'"><font class="Apple-style-span" size="3"><span class="Apple-style-span" style="font-size: 13px; ">email: <a href="mailto:david.ponzone@ipeva.fr">david.ponzone@ipeva.fr</a></span></font></font></div><div><font class="Apple-style-span" face="'Helvetica Neue'"><font class="Apple-style-span" size="3"><span class="Apple-style-span" style="font-size: 13px; ">tel: 01 74 03 18 97</span></font></font></div><div><font class="Apple-style-span" face="'Helvetica Neue'"><font class="Apple-style-span" size="3"><span class="Apple-style-span" style="font-size: 13px; ">gsm: 06 66 98 76 34</span></font></font></div><div><font class="Apple-style-span" face="'Helvetica Neue'"><br></font></div><div><font class="Apple-style-span" color="#1C00FF" face="'Helvetica Neue'">Service Client<span class="Apple-converted-space"> </span></font><font class="Apple-style-span" face="'Helvetica Neue'"><font class="Apple-style-span" color="#FF0000">IP</font></font><font class="Apple-style-span" color="#1C00FF" face="'Helvetica Neue'">eva</font></div><div><font class="Apple-style-span" color="#1C00FF" face="'Helvetica Neue'"><span class="Apple-style-span" style="color: rgb(0, 0, 0); font-family: Helvetica; "><div><font class="Apple-style-span" face="'Helvetica Neue'"><font class="Apple-style-span" size="3"><span class="Apple-style-span" style="font-size: 13px; ">tel: 0811 46 26 26</span></font></font></div><div><font class="Apple-style-span" face="'Helvetica Neue'" size="3"><span class="Apple-style-span" style="font-size: 13px; "><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 10px/normal Arial; color: rgb(0, 34, 243); "><span style="text-decoration: underline; "><a href="BLOCKED::http://www.ipeva.fr/">www.ipeva.fr</a></span><span style="color: rgb(101, 104, 149); "> - <span style="color: rgb(0, 34, 243); text-decoration: underline; "><a href="BLOCKED::http://www.ipeva-studio.com/">www.ipeva-studio.com</a></span></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 10px/normal Arial; color: rgb(0, 34, 243); "><span class="Apple-style-span" style="text-decoration: underline; "><br></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 10px/normal Arial; color: rgb(0, 34, 243); "><span class="Apple-style-span"><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; text-align: justify; font: normal normal normal 10px/normal Arial; 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 class="Apple-style-span" color="#C0C0C0"><i><br></i></font></div></span></div></span></font></div></span></font></div></div></span><br class="Apple-interchange-newline"></span><br class="Apple-interchange-newline">
</div>
<br><div><div>Le 10/02/2011 à 03:09, Tim St. Pierre a écrit :</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Actually, no.<br><br>I was using the lua odbc library that I installed from a package. I <br>didn't know about Dbh() That might solve some problems, as I don't <br>really have any issues with Freeswitch using ODBC for core and things <br>like voicemail. It's only when I want to interact with it from a script <br>that it's a problem.<br><br>xml_curl is working very nicely for routing, directory, and config, but <br>this may be a better solution for things like IVR and other more <br>complicated features.<br><br>Thanks!<br><br>-Tim<br><br>David Ponzone wrote:<br><blockquote type="cite">Tim,<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">which ODBC is that ? the one integrated in FreeSWITCH that you can <br></blockquote><blockquote type="cite">call from LUA with freeswitch.Dbh() ?<br></blockquote><blockquote type="cite">I would say that solving those issues would be a better way to achieve <br></blockquote><blockquote type="cite">this, for you and for everyone around.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">David Ponzone Direction Technique<br></blockquote><blockquote type="cite">email: <a href="mailto:david.ponzone@ipeva.fr">david.ponzone@ipeva.fr</a> <<a href="mailto:david.ponzone@ipeva.fr">mailto:david.ponzone@ipeva.fr</a>><br></blockquote><blockquote type="cite">tel: 01 74 03 18 97<br></blockquote><blockquote type="cite">gsm: 06 66 98 76 34<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Service Client IPeva<br></blockquote><blockquote type="cite">tel: 0811 46 26 26<br></blockquote><blockquote type="cite"><a href="http://www.ipeva.fr">www.ipeva.fr</a> <BLOCKED::<a href="http://www.ipeva.fr/">http://www.ipeva.fr/</a>> - <a href="http://www.ipeva-studio.com">www.ipeva-studio.com</a> <br></blockquote><blockquote type="cite"><BLOCKED::<a href="http://www.ipeva-studio.com/">http://www.ipeva-studio.com/</a>><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">/Ce message et toutes les pièces jointes sont confidentiels et établis <br></blockquote><blockquote type="cite">à l'intention exclusive de ses destinataires. Toute utilisation ou <br></blockquote><blockquote type="cite">diffusion non autorisée est interdite. Tout message électronique est <br></blockquote><blockquote type="cite">susceptible d'altération. /*/IPeva/*/ décline toute responsabilité au <br></blockquote><blockquote type="cite">titre de ce message s'il a été altéré, déformé ou falsifié. Si vous <br></blockquote><blockquote type="cite">n'êtes pas destinataire de ce message, merci de le détruire <br></blockquote><blockquote type="cite">immédiatement et d'avertir l'expéditeur./<br></blockquote><blockquote type="cite">/<br></blockquote><blockquote type="cite">/<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Le 09/02/2011 à 17:56, Tim St. Pierre a écrit :<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><blockquote type="cite">Hello list,<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">I'm trying to implement a flexible, but easy to administer IVR system<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">for our multi-tenant PBX.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">My goal is to be able to build a flexible auto-attendent scheme for<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">incoming calls, based on data in a mysql database.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">The functionality I need is:<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> -Different options based on time of day<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> -Playback of 1-2 audio files while listening for digits (Thank you<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">for calling abc company)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> -Single digit options set some variables, then transfer to a defined<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">extension (press 1 for sales)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> -Multi-digit options are checked against a pattern, then a transfer<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">is executed (enter the extension now ...)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Not very complicated, I know, but making it scale is tricky.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">I have tried LUA, but LuaSQL has issues. Even using ODBC, I still get<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">memory leaks and random errors with file handles etc.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">For the most part, I haven't had any issues with xml_curl getting config<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">from another server that generates it with PHP. I'm exploring this, but<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">it looks like I'll have to implement the following logic:<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> -Call comes in, and a dialplan is returned that plays the greetings,<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">sets some variables, and does a play_and_get_digits, followed by a<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">transfer back to the dialplan, so we can figure out what to do based on<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">the digits.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> -The callback to the dialplan evaluates the dtmf presented, and<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">decides what action to take, returning that in another dialplan piece.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">I think this could work. but it means that a dialplan lookup has to be<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">done each time someone makes a selection.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Is there a better way, or does that make the most sense?<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Thanks!<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">-Tim<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">_______________________________________________<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">FreeSWITCH-users mailing list<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a> <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">mailto:FreeSWITCH-users@lists.freeswitch.org</a>><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><a href="http://www.freeswitch.org">http://www.freeswitch.org</a><br></blockquote></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">------------------------------------------------------------------------<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">_______________________________________________<br></blockquote><blockquote type="cite">FreeSWITCH-users mailing list<br></blockquote><blockquote type="cite"><a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br></blockquote><blockquote type="cite"><a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br></blockquote><blockquote type="cite">UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users<br></blockquote><blockquote type="cite"><a href="http://www.freeswitch.org">http://www.freeswitch.org</a><br></blockquote><blockquote type="cite"><br></blockquote><br><br>_______________________________________________<br>FreeSWITCH-users mailing list<br><a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users<br>UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users<br>http://www.freeswitch.org<br></div></blockquote></div><br></div></body></html>