[Freeswitch-users] Developers / packagers here?

Thu Nov 4 23:13:28 UTC 2021

https://freeswitch.org/confluence/display/FREESWITCH/mod_odbc_query

Regards,

David Villasmil
email: david.villasmil.work at gmail.com
phone: +34669448337

On Thu, Nov 4, 2021 at 8:15 PM Avi Marcus <avi at avimarcus.net> wrote:

> 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/20211104/69a67b52/attachment.html>