Developers / packagers here?
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.
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.
On Oct 29, 2021, at 10:21 AM, Antony Stone <Antony.Stone@freeswitch.open.source.it> 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.
(PS: This message sent at 15:21 UTC 2021-10-29, just wondering when it will appear on the list.)
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.
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@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
-- Your life is like a penny. You're going to lose it. The question is: How do you spend it? John Covici wb2una covici@ccs.covici.com
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> 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@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
-- Your life is like a penny. You're going to lose it. The question is: How do you spend it?
John Covici wb2una covici@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@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
https://freeswitch.org/confluence/display/FREESWITCH/mod_odbc_query Regards, David Villasmil email: david.villasmil.work@gmail.com phone: +34669448337 On Thu, Nov 4, 2021 at 8:15 PM Avi Marcus <avi@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@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
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
-- Your life is like a penny. You're going to lose it. The question is: How do you spend it?
John Covici wb2una covici@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@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
_________________________________________________________________________
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
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 <mailto:covici@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@freeswitch.com <mailto: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 <mailto: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
-- Your life is like a penny. You're going to lose it. The question is: How do you spend it? John Covici wb2una covici@ccs.covici.com <mailto:covici@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@freeswitch.com <mailto: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 <mailto: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
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@gmail.com phone: +34669448337 On Fri, Nov 5, 2021 at 1:34 AM <krice@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@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> 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@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
-- Your life is like a penny. You're going to lose it. The question is: How do you spend it?
John Covici wb2una covici@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@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
_________________________________________________________________________
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
On Thursday 04 November 2021 at 20:24:03, John Covici 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.
Thanks. When you say "use a real programming language", do you mean "instead of FreeSwitch / Asterisk" or do you mean instead of XML / curl? Just wondering whether you regard FreeSwitch / Asterisk as a sensible starting point here, and if so, what you would recommend using alongside them as a "real language". Antony. -- A user interface is like a joke. If you have to explain it, it means it doesn't work. Please reply to the list; please *don't* CC me.
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:
On Thursday 04 November 2021 at 20:24:03, John Covici 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.
Thanks.
When you say "use a real programming language", do you mean "instead of FreeSwitch / Asterisk" or do you mean instead of XML / curl?
Just wondering whether you regard FreeSwitch / Asterisk as a sensible starting point here, and if so, what you would recommend using alongside them as a "real language".
Antony.
-- A user interface is like a joke. If you have to explain it, it means it doesn't work.
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
-- Your life is like a penny. You're going to lose it. The question is: How do you spend it? John Covici wb2una covici@ccs.covici.com
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> wrote:
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:
On Thursday 04 November 2021 at 20:24:03, John Covici 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.
Thanks.
When you say "use a real programming language", do you mean "instead of FreeSwitch / Asterisk" or do you mean instead of XML / curl?
Just wondering whether you regard FreeSwitch / Asterisk as a sensible
starting
point here, and if so, what you would recommend using alongside them as a "real language".
Antony.
-- A user interface is like a joke. If you have to explain it, it means it doesn't work.
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
-- Your life is like a penny. You're going to lose it. The question is: How do you spend it?
John Covici wb2una covici@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@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
-- Regards, David Villasmil email: david.villasmil.work@gmail.com phone: +34669448337
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:
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@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
participants (6)
-
Antony Stone
-
Avi Marcus
-
David Villasmil
-
John Covici
-
krice＠freeswitch.org
-
Mike Jerris