[Freeswitch-users] Best way to implement real-time ivr from mysql

[Tim St. Pierre]

Actually, no.

I was using the lua odbc library that I installed from a package.  I 
didn't know about Dbh()  That might solve some problems, as I don't 
really have any issues with Freeswitch using ODBC for core and things 
like voicemail.  It's only when I want to interact with it from a script 
that it's a problem.

xml_curl is working very nicely for routing, directory, and config, but 
this may be a better solution for things like IVR and other more 
complicated features.

Thanks!

-Tim

David Ponzone wrote:
> Tim,
>
> which ODBC is that ? the one integrated in FreeSWITCH that you can 
> call from LUA with freeswitch.Dbh() ?
> I would say that solving those issues would be a better way to achieve 
> this, for you and for everyone around.
>
> David Ponzone  Direction Technique
> email: david.ponzone at ipeva.fr <mailto:david.ponzone at ipeva.fr>
> tel:      01 74 03 18 97
> gsm:   06 66 98 76 34
>
> Service Client IPeva
> tel:      0811 46 26 26
> www.ipeva.fr <BLOCKED::http://www.ipeva.fr/>  -   www.ipeva-studio.com 
> <BLOCKED::http://www.ipeva-studio.com/>
>
> /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. /*/IPeva/*/ 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./
> /
> /
>
>
>
> Le 09/02/2011 à 17:56, Tim St. Pierre a écrit :
>
>> Hello list,
>>
>> I'm trying to implement a flexible, but easy to administer IVR system
>> for our multi-tenant PBX.
>>
>> My goal is to be able to build a flexible auto-attendent scheme for
>> incoming calls, based on data in a mysql database.
>>
>> The functionality I need is:
>>    -Different options based on time of day
>>    -Playback of 1-2 audio files while listening for digits (Thank you
>> for calling abc company)
>>    -Single digit options set some variables, then transfer to a defined
>> extension (press 1 for sales)
>>    -Multi-digit options are checked against a pattern, then a transfer
>> is executed (enter the extension now ...)
>>
>> Not very complicated, I know, but making it scale is tricky.
>>
>> I have tried LUA, but LuaSQL has issues.  Even using ODBC, I still get
>> memory leaks and random errors with file handles etc.
>>
>> For the most part, I haven't had any issues with xml_curl getting config
>> from another server that generates it with PHP.  I'm exploring this, but
>> it looks like I'll have to implement the following logic:
>>    -Call comes in, and a dialplan is returned that plays the greetings,
>> sets some variables, and does a play_and_get_digits, followed by a
>> transfer back to the dialplan, so we can figure out what to do based on
>> the digits.
>>    -The callback to the dialplan evaluates the dtmf presented, and
>> decides what action to take, returning that in another dialplan piece.
>>
>> I think this could work. but it means that a dialplan lookup has to be
>> done each time someone makes a selection.
>>
>> Is there a better way, or does that make the most sense?
>>
>> Thanks!
>>
>> -Tim
>>
>> _______________________________________________
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at lists.freeswitch.org 
>> <mailto:FreeSWITCH-users at lists.freeswitch.org>
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>> http://www.freeswitch.org
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>