[Freeswitch-users] Developers / packagers here?

Avi Marcus avi at avimarcus.net
Thu Nov 4 19:41:43 UTC 2021


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20211104/9fbf8c15/attachment-0001.html>


More information about the FreeSWITCH-users mailing list