get info from DB into channel variable in xml dialplan
We are looking for a way to set a few variables in the XML dialplan with information stored in a MySQL DB, the simplest seems to be to use mod_odbc_query which will set channel variables (see http://wiki.freeswitch.org/wiki/Mod_odbc_query#APP), problem is that we prefer not to access the DB directly from xml. The other option is to use mod_curl which gets the result into a channel variable named 'curl_response_data', problem is that we have multiple values that we need in separate channel variables, and I can't find any documentation on how to do that, is there any way to do this using json etc?
lua is a lightweight option that can do sql or curl. -Avi On Mon, Jun 18, 2012 at 11:50 PM, Abaci <abaci64@gmail.com> wrote:
We are looking for a way to set a few variables in the XML dialplan with information stored in a MySQL DB, the simplest seems to be to use mod_odbc_query which will set channel variables (see http://wiki.freeswitch.org/wiki/Mod_odbc_query#APP), problem is that we prefer not to access the DB directly from xml. The other option is to use mod_curl which gets the result into a channel variable named 'curl_response_data', problem is that we have multiple values that we need in separate channel variables, and I can't find any documentation on how to do that, is there any way to do this using json etc?
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
Join Us At ClueCon - Aug 7-9, 2012
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
I was wondering if there is a way to do it using curl without lua On 6/18/2012 5:00 PM, Avi Marcus wrote:
lua is a lightweight option that can do sql or curl.
-Avi
On Mon, Jun 18, 2012 at 11:50 PM, Abaci <abaci64@gmail.com <mailto:abaci64@gmail.com>> wrote:
We are looking for a way to set a few variables in the XML dialplan with information stored in a MySQL DB, the simplest seems to be to use mod_odbc_query which will set channel variables (see http://wiki.freeswitch.org/wiki/Mod_odbc_query#APP), problem is that we prefer not to access the DB directly from xml. The other option is to use mod_curl which gets the result into a channel variable named 'curl_response_data', problem is that we have multiple values that we need in separate channel variables, and I can't find any documentation on how to do that, is there any way to do this using json etc?
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <mailto:consulting@freeswitch.org> http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
Join Us At ClueCon - Aug 7-9, 2012
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org <mailto: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
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
Join Us At ClueCon - Aug 7-9, 2012
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
My guess is that if you want/need to skip Lua then you'll need to do some regex magic to parse out the response data. However, I'm wondering what the aversion to Lua is. It's ridiculously light and it's pretty easy to use. What's the downside? -MC On Mon, Jun 18, 2012 at 1:50 PM, Abaci <abaci64@gmail.com> wrote:
We are looking for a way to set a few variables in the XML dialplan with information stored in a MySQL DB, the simplest seems to be to use mod_odbc_query which will set channel variables (see http://wiki.freeswitch.org/wiki/Mod_odbc_query#APP), problem is that we prefer not to access the DB directly from xml. The other option is to use mod_curl which gets the result into a channel variable named 'curl_response_data', problem is that we have multiple values that we need in separate channel variables, and I can't find any documentation on how to do that, is there any way to do this using json etc?
to avoid the overhead of XML+curl+lua+JSON4Lua and use just XML+curl. I know Lua is light but it adds up especially if you do more than one per call. On 6/18/2012 5:15 PM, Michael Collins wrote:
My guess is that if you want/need to skip Lua then you'll need to do some regex magic to parse out the response data. However, I'm wondering what the aversion to Lua is. It's ridiculously light and it's pretty easy to use. What's the downside? -MC
On Mon, Jun 18, 2012 at 1:50 PM, Abaci <abaci64@gmail.com <mailto:abaci64@gmail.com>> wrote:
We are looking for a way to set a few variables in the XML dialplan with information stored in a MySQL DB, the simplest seems to be to use mod_odbc_query which will set channel variables (see http://wiki.freeswitch.org/wiki/Mod_odbc_query#APP), problem is that we prefer not to access the DB directly from xml. The other option is to use mod_curl which gets the result into a channel variable named 'curl_response_data', problem is that we have multiple values that we need in separate channel variables, and I can't find any documentation on how to do that, is there any way to do this using json etc?
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
Join Us At ClueCon - Aug 7-9, 2012
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
If it's really a concern then I would just use a regex API and parse out the stuff you need from the response data. -MC On Mon, Jun 18, 2012 at 2:26 PM, Abaci <abaci64@gmail.com> wrote:
to avoid the overhead of XML+curl+lua+JSON4Lua and use just XML+curl. I know Lua is light but it adds up especially if you do more than one per call.
On 6/18/2012 5:15 PM, Michael Collins wrote:
My guess is that if you want/need to skip Lua then you'll need to do some regex magic to parse out the response data. However, I'm wondering what the aversion to Lua is. It's ridiculously light and it's pretty easy to use. What's the downside? -MC
On Mon, Jun 18, 2012 at 1:50 PM, Abaci <abaci64@gmail.com> wrote:
We are looking for a way to set a few variables in the XML dialplan with information stored in a MySQL DB, the simplest seems to be to use mod_odbc_query which will set channel variables (see http://wiki.freeswitch.org/wiki/Mod_odbc_query#APP), problem is that we prefer not to access the DB directly from xml. The other option is to use mod_curl which gets the result into a channel variable named 'curl_response_data', problem is that we have multiple values that we need in separate channel variables, and I can't find any documentation on how to do that, is there any way to do this using json etc?
participants (3)
-
Abaci
-
Avi Marcus
-
Michael Collins