[Freeswitch-users] Freeswitch and mysql

[Avi Marcus]

Integrate freeswitch with mysql is vague. That itself could mean something
like having freeswitch store it's database in mysql, but that doesn't seem
to be what you want.
You are asking how to use a database (any, not just mysql) to configure the
dialplan - users, extensions, conferences, whatever.
1) You can use lua to process the calls and have it query your database
2) If you just need simple sql queries, check the mod_odbc_query from the
git contrib. If you already understand the dialplan basics, then this can
easily let you query the database as part of that.
3) However, if you need more complicated things, then mod_xml_curl is your
friend - it lets you grab dynamicly generated XML files for each call.
I myself use php to query a mysql database for how much to charge for the
call, a custom LCR implementation, etc.
I posted the basic classes to github a while ago:
https://github.com/avimar/FreeSWITCH-mod_xml-with-PHP
 <https://github.com/avimar/FreeSWITCH-mod_xml-with-PHP>Also, intralanman
wrote a very modular, all inclusive xml_curl implementation in php - which
if you understand it (I didn't know it existed) should be really helpful.
You can find that in the git contrib also in: intralanman/PHP/fs_curl

-Avi Marcus

On Wed, Jan 19, 2011 at 10:57 PM, Antonio <potxoka at gmail.com> wrote:

>  El 28/09/10 0:36, Antonio escribió:
>
> Hello,
>
> I asked and more I searched, I found nothing, how to integrate FreeSwitch
> with mysql. Some time ago I found Asterisk-realtime and wanted to know if
> there is something similar in FreeSwitch. Is to avoid double
> configurations, for example if there is a conference room that can be
> accessed from multiple servers, etc. I'm new in FreeSwitch and I have much
> knowledge ;-)
>
> Does anyone have any url or book on how to do? Lua?. Thanks.
>
> Greetings
>
> Hello,
>
> Thanks, is that having to generate hundreds of xml files with the
> extensions can be very stressful, so we had planned to use php + mysql to
> configure extensions. Buy the book FreeSwitch and I have yet to start
> reading and see if I can find a solution to this problem, also tend to
> read the wiki, but being new to FreeSwitch not quite understand certain concepts
> :-(. Thanks for the aid; -).
>
> Greetings
>
> _______________________________________________
> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20110119/2ba22ebe/attachment-0001.html