[Freeswitch-users] Developers / packagers here?

Fri Nov 5 00:51:07 UTC 2021

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 at lists.freeswitch.org> On Behalf Of Avi Marcus
Sent: Thursday, November 4, 2021 2:42 PM
To: FreeSWITCH Users Help <freeswitch-users at 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 at ccs.covici.com <mailto:covici at 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 at freeswitch.com <mailto:sales at 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 at lists.freeswitch.org <mailto:FreeSWITCH-users at 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 at ccs.covici.com <mailto:covici at 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 at freeswitch.com <mailto:sales at 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 at lists.freeswitch.org <mailto:FreeSWITCH-users at lists.freeswitch.org> 
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
https://freeswitch.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20211104/78da29e1/attachment-0001.html>