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.
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@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