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
Antonio, there are 2 main solutions: -use mod_xml_curl, which allows to get the whole dialplan from HTTP (so from SQL, using the language of your choice) -have a "call routing engine" written in the language of your choice (LUA, JS, Python, Perl, C, C#, Ruby) running standalone besides FS. It will be connected to FS through sockets, and then you can include any level of "smartness" in that engine David Ponzone Direction Technique email: david.ponzone@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 - 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 28/09/2010 à 00:36, Antonio a écrit :
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 _______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Hi, There is also the possibility to use the xml-handler (e.g. lua),write a c/c++ module which does fetch the dialplan/directory. Also it ispossible to call lua as a application and then do some sort of mysql queries. Another possible way is, that you specify to use LUA for thecontext of a sip profile. Then, if the context would be used, it will just callthe lua script BR, Bernhard Von:freeswitch-users-bounces@lists.freeswitch.org[mailto:freeswitch-users-bounces@lists.freeswitch.org] Im Auftrag von DavidPonzone Gesendet: Dienstag, 28. September 2010 08:57 An: FreeSWITCH Users Help Betreff: Re: [Freeswitch-users] Freeswitch and mysql Antonio, there are 2 main solutions: -use mod_xml_curl, which allows to get the whole dialplanfrom HTTP (so from SQL, using the language of your choice) -have a "call routing engine" written in thelanguage of your choice (LUA, JS, Python, Perl, C, C#, Ruby) running standalonebesides FS. It will be connected to FS through sockets, and then you caninclude any level of "smartness" in that engine David Ponzone DirectionTechnique email: david.ponzone@ipeva.fr tel: 0174 03 18 97 gsm: 06 66 98 76 34 Service Client IPeva tel: 0811 46 26 26 www.ipeva.fr - www.ipeva-studio.com Ce message et toutes les piècesjointes sont confidentiels et établis à l'intention exclusive de sesdestinataires. Toute utilisation ou diffusion non autorisée est interdite. Toutmessage électronique est susceptible d'altération. IPeva déclinetoute responsabilité au titre de ce message s'il a été altéré, déformé oufalsifié. Si vous n'êtes pas destinataire de ce message, merci de le détruireimmédiatement et d'avertir l'expéditeur. Le 28/09/2010 à 00:36, Antonio a écrit : Hello, I asked and more I searched, I found nothing, how tointegrate FreeSwitch with mysql. Some time ago I found Asterisk-realtime andwanted to know if there is something similar in FreeSwitch. Is to avoid doubleconfigurations, for example if there is a conference room that can be accessedfrom multiple servers, etc. I'm new inFreeSwitch and I have much knowledge ;-) Does anyone have any url orbook on how to do? Lua?. Thanks. Greetings _______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Hi Antonio, This might be what you want. http://wiki.freeswitch.org/wiki/Mod_xml_curl On Mon, Sep 27, 2010 at 6:36 PM, Antonio <potxoka@gmail.com> wrote:
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 _______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Hello Antonio, Or you can use MySQL directly (through ODBC) from within FreeSWITCH by using Lua: http://wiki.freeswitch.org/wiki/Lua#freeswitch.Dbh and: http://wiki.freeswitch.org/wiki/Lua_freeswitch_dbh Kind regards, Leon On Sep 28, 2010, at 8:59 AM, Diego Viola wrote:
Hi Antonio,
This might be what you want.
http://wiki.freeswitch.org/wiki/Mod_xml_curl
On Mon, Sep 27, 2010 at 6:36 PM, Antonio <potxoka@gmail.com> wrote:
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 _______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
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 configureextensions. 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
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@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
El 19/01/11 22:16, Avi Marcus escribió:
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 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
Hi Thanks for everyone's responses, are really helping me to really know to look for and how to document ;-). I had thought one thing and I have a question: Could use python for this cause?. I'll look at me while the modules that have told me;-). Thank you very much. Regards <action application="python" data="extension_user"/> --------- extension_user.xml --------- <include> <user id="1000" mailbox="1000"> <params> <param name="password" value="1234"/> <param name="vm-password" value="1000"/> </params> <variables> <variable name="toll_allow" value="domestic,international,local"/> <variable name="accountcode" value="1000"/> <variable name="user_context" value="default"/> <variable name="effective_caller_id_name" value="NAME"/> <variable name="effective_caller_id_number" value="1000"/> <variable name="outbound_caller_id_name" value="$${outbound_caller_name}"/> <variable name="outbound_caller_id_number" value="$${outbound_caller_id}"/> <variable name="callgroup" value="techsupport"/> </variables> </user> </include> --------- extension_user.xml ---------
This is interesting....Nice to know that we were doing something right...mod_xml_curl.... I did not get a chance to look at the php example...I will have a look when I have a free moment... - Duane From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Antonio Sent: Sunday, February 06, 2011 11:07 AM To: freeswitch-users@lists.freeswitch.org Subject: Re: [Freeswitch-users] Freeswitch and mysql El 19/01/11 22:16, Avi Marcus escribió: 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 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 Hi Thanks for everyone's responses, are really helping me to really know to look for and how to document ;-). I had thought one thing and I have a question: Could use python for this cause?. I'll look at me while the modules that have told me;-). Thank you very much. Regards <action application="python" data="extension_user"/> --------- extension_user.xml --------- <include> <user id="1000" mailbox="1000"> <params> <param name="password" value="1234"/> <param name="vm-password" value="1000"/> </params> <variables> <variable name="toll_allow" value="domestic,international,local"/> <variable name="accountcode" value="1000"/> <variable name="user_context" value="default"/> <variable name="effective_caller_id_name" value="NAME"/> <variable name="effective_caller_id_number" value="1000"/> <variable name="outbound_caller_id_name" value="$${outbound_caller_name}"/> <variable name="outbound_caller_id_number" value="$${outbound_caller_id}"/> <variable name="callgroup" value="techsupport"/> </variables> </user> </include> --------- extension_user.xml ---------
El 19/01/11 22:16, Avi Marcus escribió:
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 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 <mailto: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 configureextensions. 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
Hello the need I have is that of access to voicemail, because the registrar,location and others, is on another computer. FreeSwitch only what I have to use gateway, conferences (I'm looking at the issue with the wiki FreeSwitch, Javascript or Python) and voicemail. I can access the voicemail without having to configure extensions?. Looking at the module XML_CURL I understood something you can configure the voicemail so it, is not yet clarified me very well even with FreeSwitch: '(. Thanks. Greetings
Hello Looking Mod_Voicemail (http://wiki.freeswitch.org/wiki/Mod_voicemail), I see that could be configured with python, javascript or similar:-D. Every day I like best FreeSwitch. Thanks REgards
participants (7)
-
Antonio
-
Avi Marcus
-
Bernhard Suttner
-
David Ponzone
-
Diego Viola
-
Duane Gilbert
-
Leon de Rooij