[Freeswitch-users] Developers / packagers here?

Fri Nov 5 01:47:16 UTC 2021

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 at gmail.com
phone: +34669448337

On Fri, Nov 5, 2021 at 1:34 AM <krice at 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 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> 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
> > 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
> > 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
>
> _________________________________________________________________________
>
> 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
> 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
> 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 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
> 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/20211105/3956aa35/attachment.html>