This is true. You _can_ do it all via sql queries in the dialplan it self, but you're going to need a lot of regexp'ing, not to mention variable manipulation, etc. it could really get convoluted. It really is simpler just to do xml_curl. A simple php would suffice. Regards, David Villasmil email: david.villasmil.work@gmail.com phone: +34669448337 On Fri, Nov 5, 2021 at 1:34 AM <krice@freeswitch.org> wrote:
Mod_xml_curl isn’t a bit heavy for this. This is exactly what it was designed to do. It also makes it where you are returning a much smaller dialplan. The curl request then eliminates a potential pile of regex hits that are quite expensive to parse thru.
*From:* FreeSWITCH-users <freeswitch-users-bounces@lists.freeswitch.org> *On Behalf Of *Avi Marcus *Sent:* Thursday, November 4, 2021 2:42 PM *To:* FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> *Subject:* Re: [Freeswitch-users] Developers / packagers here?
mod_xml_curl seems a bit heavy for this.
You can write a short js or lua script to do the odbc query and assign it to a channel variable.
I'm not sure about accessing a _foreign_ odbc source though, or if it only accesses the freeswitch core db.
The info isn't loading for me... https://freeswitch.org/confluence/display/FREESWITCH/Lua+FreeSWITCH+Dbh
-Avi Marcus BestFone
On Thu, Nov 4, 2021 at 9:24 PM John Covici <covici@ccs.covici.com> wrote:
I think you should be able to dl all this with mod_xml_curl. This module will give you the xml you need after searching whatever database you need -- and it can be on a per-call basis. One thing though, you might be better using a real programming language for these use cases. Freeswitch is more of a toolkit whereas asterisk is more of a pbx specific arrangement.
On Thu, 04 Nov 2021 05:47:06 -0400, Antony Stone wrote:
On Wednesday 03 November 2021 at 22:00:14, Mike Jerris wrote:
It’s a module abandoned 7-8 years ago in the contrib repo that we have never maintained and has never been part of the FS packaging. We generally don’t package unmaintained code but you are welcome to use
it if
you choose and it still works. The db layers have gone through some evolution since then, what exactly are you trying to accomplish, it may already be available elsewhere.
I have a few use cases:
1. Inbound calls come in to a DDI range I have, and need to be forwarded on to users' mobile phones. This list of DDI --> mobile number mappings is fairly large, and maintained externally to the telephony platform, therefore I want to do a dynamic lookup of the DDI to find out which mobile number to forward a call on to.
2. Users dialling out have different destinations they're allowed to call, and again the details about who is allowed to call where are maintained by people nothing to do with operating the telephony platform, so I want to do a database lookup of each user as they place a call to see whether the destination they're dialling is in their allowed list.
3. Outbound providers charge us for placing calls to different destinations, and the prices change (typically monthly, but sometimes more often), and I need to do accurate live per-call accounting to keep track of users' and groups' spend levels.
I've done all the above in Asterisk using its ODBC connectivity, so I'm looking for the best way to execute arbitrary SQL statements in a FreeSwitch dialplan.
On Oct 29, 2021, at 10:21 AM, Antony Stone wrote:
Hi.
Can anyone tell me why https://freeswitch.org/confluence/display/FREESWITCH/mod_odbc_query is not built as part of the standard Debian packages available from https://files.freeswitch.org/repo/deb/ ?
Thanks,
Antony.
-- "640 kilobytes (of RAM) should be enough for anybody."
- Bill Gates
Please reply to the list; please *don't* CC me.
_________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire https://signalwire.com Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services. Build your next product on our scalable cloud platform.
Join our online community to chat in real time https://signalwire.community
Professional FreeSWITCH Services sales@freeswitch.com https://freeswitch.com
Official FreeSWITCH Sites https://freeswitch.com/oss https://freeswitch.org/confluence https://cluecon.com
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 https://freeswitch.com
-- Your life is like a penny. You're going to lose it. The question is: How do you spend it?
John Covici wb2una covici@ccs.covici.com
_________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire https://signalwire.com Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services. Build your next product on our scalable cloud platform.
Join our online community to chat in real time https://signalwire.community
Professional FreeSWITCH Services sales@freeswitch.com https://freeswitch.com
Official FreeSWITCH Sites https://freeswitch.com/oss https://freeswitch.org/confluence https://cluecon.com
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 https://freeswitch.com
_________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire https://signalwire.com Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services. Build your next product on our scalable cloud platform.
Join our online community to chat in real time https://signalwire.community
Professional FreeSWITCH Services sales@freeswitch.com https://freeswitch.com
Official FreeSWITCH Sites https://freeswitch.com/oss https://freeswitch.org/confluence https://cluecon.com
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 https://freeswitch.com