VoIP Mailing List Archives

[Antony.Stone at freesw...]

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.

(PS: This message sent at 15:21 UTC 2021-10-29, just wondering when it will
appear on the list.)

--
90% of networking problems are routing problems.
9 of the remaining 10% are routing problems in the other direction.
The remaining 1% might be something else, but check the routing anyway.

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

[mike at freeswitch.org]

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.

[Antony.Stone at freesw...]

On Wednesday 03 November 2021 at 22:00:14, Mike Jerris wrote:

[covici at ccs.covici.com]

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:

[avi at avimarcus.net]

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 (covici@ccs.covici.com)> wrote:

[david.villasmil.work a...]

https://freeswitch.org/confluence/display/FREESWITCH/mod_odbc_queryRegards,


David Villasmilemail: david.villasmil.work@gmail.com (david.villasmil.work@gmail.com)
phone: +34669448337







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

[krice at freeswitch.org]

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 (covici@ccs.covici.com)> wrote:

[krice at freeswitch.org]

This is specifically what the curl extensions are for. you bind the dialplan there and ask the DB for exactly what to do with the call.

-----Original Message-----
From: FreeSWITCH-users <freeswitch-users-bounces@lists.freeswitch.org> On Behalf Of Antony Stone
Sent: Thursday, November 4, 2021 4:47 AM
To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org>
Subject: Re: [Freeswitch-users] Developers / packagers here?

On Wednesday 03 November 2021 at 22:00:14, Mike Jerris wrote:

[david.villasmil.work a...]

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 Villasmilemail: david.villasmil.work@gmail.com (david.villasmil.work@gmail.com)
phone: +34669448337







On Fri, Nov 5, 2021 at 1:34 AM <krice@freeswitch.org (krice@freeswitch.org)> wrote:

[Antony.Stone at freesw...]

On Thursday 04 November 2021 at 20:24:03, John Covici wrote:

[covici at ccs.covici.com]

I mean instead of using the dialplan, you could use c sharp or even
lua for a portion of your workflow. Freeswitch does support doing
this kind of thing and then you get more realtime control instead of a
static dialplan. I have used mod_managed to write something to do
what asterisk's controlplayback does because I could not find anything
in fs to do what I wanted to do.

On Thu, 04 Nov 2021 16:00:41 -0400,
Antony Stone wrote:

[david.villasmil.work a...]

In FS there’s the embedded lua. You can do almost anything with it.

On Fri, 5 Nov 2021 at 08:18, John Covici <covici@ccs.covici.com (covici@ccs.covici.com)> wrote: