[Freeswitch-users] ivr with mysql

[Karsten Horsmann]

Hi,

you can choose diffrent ways to get an sql connection in mod_lua.

http://wiki.freeswitch.org/wiki/Lua_freeswitch_dbh (needs odbc-connection)
http://wiki.freeswitch.org/wiki/Installing_LuaSQL (not recommended)

Or include in your lua-script lua-dbi (supports prepared statements)




2013/12/6 Joli Martinez <mrjoli021 at gmail.com>

> In the code below where is the connection string?
>
>
>
> On Dec 6, 2013, at 1:49 PM, Vik Killa <vipkilla at gmail.com> wrote:
>
> var=${caller_id_number}
>
>
> On Fri, Dec 6, 2013 at 1:19 PM, Joli Martinez <mrjoli021 at gmail.com> wrote:
>
>> That will work.
>>
>> Final question.  How can I get the incoming caller ID into a variable?
>>
>> Thanks,
>>
>> On Dec 6, 2013, at 11:59 AM, Aleksandr Chusov <chusov.alexsandr at gmail.com>
>> wrote:
>>
>> Or execute  lua script, something like
>>
>> session:answer();
>> session:execute("start_dtmf");
>> menu_id = session:playAndGetDigits();
>>
>> .....
>>
>> query = "SELECT * FROM  ivr_menu WHERE  menu_number = '" ..menu_id.. "'"
>> assert(dbh:query(query, function(qrow)
>> .......
>> .......
>>
>>
>> 2013/12/6 Vik Killa <vipkilla at gmail.com>
>>
>>> You can use XML_CURL to create the ivr.conf.xml that FS parses
>>>
>>>
>>> On Fri, Dec 6, 2013 at 10:31 AM, Joli Martinez <mrjoli021 at gmail.com>wrote:
>>>
>>>> Hello,
>>>>
>>>> I would like to know how to connect an IVR to msql db to make the IVR
>>>> more dynamic.
>>>>
>>>> thanks,
>>>>
>>>> _________________________________________________________________________
>>>> Professional FreeSWITCH Consulting Services:
>>>> consulting at freeswitch.org
>>>> http://www.freeswitchsolutions.com
>>>>
>>>> 
>>>> 
>>>>
>>>> Official FreeSWITCH Sites
>>>> http://www.freeswitch.org
>>>> http://wiki.freeswitch.org
>>>> http://www.cluecon.com
>>>>
>>>> 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
>>>>
>>>
>>>
>>> _________________________________________________________________________
>>> Professional FreeSWITCH Consulting Services:
>>> consulting at freeswitch.org
>>> http://www.freeswitchsolutions.com
>>>
>>> 
>>> 
>>>
>>> Official FreeSWITCH Sites
>>> http://www.freeswitch.org
>>> http://wiki.freeswitch.org
>>> http://www.cluecon.com
>>>
>>> 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
>>>
>>>
>> _________________________________________________________________________
>> Professional FreeSWITCH Consulting Services:
>> consulting at freeswitch.org
>> http://www.freeswitchsolutions.com
>>
>> 
>> 
>>
>> Official FreeSWITCH Sites
>> http://www.freeswitch.org
>> http://wiki.freeswitch.org
>> http://www.cluecon.com
>>
>> 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
>>
>>
>>
>> _________________________________________________________________________
>> Professional FreeSWITCH Consulting Services:
>> consulting at freeswitch.org
>> http://www.freeswitchsolutions.com
>>
>> 
>> 
>>
>> Official FreeSWITCH Sites
>> http://www.freeswitch.org
>> http://wiki.freeswitch.org
>> http://www.cluecon.com
>>
>> 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
>>
>>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> 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
>
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> 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
>
>


-- 
Mit freundlichen Grüßen
*Karsten Horsmann*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20131206/5197ecfa/attachment-0001.html