Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

VoIP Mailing List Archives
Mailing list archives for the VoIP community
 SearchSearch 

[Freeswitch-users] Sofia and ODBC


 
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> freeSWITCH Users
View previous topic :: View next topic  
Author Message
Antony.Stone at freesw...
Guest





PostPosted: Wed Nov 03, 2021 7:46 am    Post subject: [Freeswitch-users] Sofia and ODBC Reply with quote

Hi.

https://freeswitch.org/confluence/display/FREESWITCH/FreeSWITCH+Databases tells
me that "Instead of using the default SQLite database as the internal
FreeSWITCH database, you can use any core database type. This works for:
mod_db
mod_voicemail
mod_sofia
mod_dingaling
mod_cidlookup
mod_lcr"

Each of those is a link, and if I click on the mod_sofia link I get to the page
https://freeswitch.org/confluence/display/FREESWITCH/mod_sofia which tells me
nothing about using ODBC.

If I scroll further down the first page I started from, the heading "Configuring
FreeSWITCH to use databases" has a sub-section "mod_sofia" with a link pointing
to https://freeswitch.org/confluence/display/FREESWITCH/Sofia+Configuration+Files
whose only mention of ODBC is:

odbc-dsn
If you have ODBC support and a working dsn you can use it instead of SQLite
<param name="odbc-dsn" value="dsn:user:pass"/>

So, where can find the information telling me _how_ I can put my sofia
configuration into ODBC, instead of XML files?

Basically I'm looking for the equivalent of Asterisk's "Realtime" configuration
option, where SIP connections can be held in a database table instead of a flat
file, meaning that (a) it's easier to maintain dynamically, and (b) new entries
get used without needing a reload.

I'm liking FreeSwitch (after using it for about a month), but still finding it
sometimes hard to discover the definitive documentation for what it can do (or
how to make it do it).


Thanks,


Antony.

--
This sentence contains exacly three erors.

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
Back to top
brian at freeswitch.com
Guest





PostPosted: Wed Nov 03, 2021 10:07 am    Post subject: [Freeswitch-users] Sofia and ODBC Reply with quote

See XML Curl, not anything related to ODBC.

/b




On Wed, Nov 3, 2021 at 7:43 AM Antony Stone <Antony.Stone@freeswitch.open.source.it (Antony.Stone@freeswitch.open.source.it)> wrote:

Quote:
Hi.

https://freeswitch.org/confluence/display/FREESWITCH/FreeSWITCH+Databases tells
me that "Instead of using the default SQLite database as the internal
FreeSWITCH database, you can use any core database type. This works for:
        mod_db
        mod_voicemail
        mod_sofia
        mod_dingaling
        mod_cidlookup
        mod_lcr"

Each of those is a link, and if I click on the mod_sofia link I get to the page
https://freeswitch.org/confluence/display/FREESWITCH/mod_sofia which tells me
nothing about using ODBC.

If I scroll further down the first page I started from, the heading "Configuring
FreeSWITCH to use databases" has a sub-section "mod_sofia" with a link pointing
to https://freeswitch.org/confluence/display/FREESWITCH/Sofia+Configuration+Files
whose only mention of ODBC is:

odbc-dsn
If you have ODBC support and a working dsn you can use it instead of SQLite
<param name="odbc-dsn" value="dsn:user:pass"/>

So, where can find the information telling me _how_ I can put my sofia
configuration into ODBC, instead of XML files?

Basically I'm looking for the equivalent of Asterisk's "Realtime" configuration
option, where SIP connections can be held in a database table instead of a flat
file, meaning that (a) it's easier to maintain dynamically, and (b) new entries
get used without needing a reload.

I'm liking FreeSwitch (after using it for about a month), but still finding it
sometimes hard to discover the definitive documentation for what it can do (or
how to make it do it).


Thanks,


Antony.

--
This sentence contains exacly three erors.

                                                   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 (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 (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



--



Brian West | Co-founder and Developer
Need Commercial support? email sales@freeswitch.com (sales@freeswitch.com)
FreeSWITCH Solutions | 17345 Civic Drive #2531 Brookfield, WI 53045
Email: brian@freeswitch.com (brian@freeswitch.com)
Mobile: 918-424-9378
Website: https://www.FreeSWITCH.com
[/url] [url=https://twitter.com/freeswitch]
Back to top
martin at pattersong.c...
Guest





PostPosted: Wed Nov 03, 2021 10:52 am    Post subject: [Freeswitch-users] Sofia and ODBC Reply with quote

I think you are confusing two different things here. The docs pages
you link to are about choosing the internal database that FreeSWITCH
uses for its internal state information. This is not the same as
serving configuration, which is by default provided in XML files.

You can dynamically serve the XML configuration with the module:
mod_xml_curl and also control call flow with mod_httapi.

Martin.

Martin Paterson, Pattersong Music
Reduced orchestrations of G&S

On Wed, 3 Nov 2021 at 11:15, Antony Stone
<Antony.Stone@freeswitch.open.source.it> wrote:
Quote:

Hi.

https://freeswitch.org/confluence/display/FREESWITCH/FreeSWITCH+Databases tells
me that "Instead of using the default SQLite database as the internal
FreeSWITCH database, you can use any core database type. This works for:
mod_db
mod_voicemail
mod_sofia
mod_dingaling
mod_cidlookup
mod_lcr"

Each of those is a link, and if I click on the mod_sofia link I get to the page
https://freeswitch.org/confluence/display/FREESWITCH/mod_sofia which tells me
nothing about using ODBC.

If I scroll further down the first page I started from, the heading "Configuring
FreeSWITCH to use databases" has a sub-section "mod_sofia" with a link pointing
to https://freeswitch.org/confluence/display/FREESWITCH/Sofia+Configuration+Files
whose only mention of ODBC is:

odbc-dsn
If you have ODBC support and a working dsn you can use it instead of SQLite
<param name="odbc-dsn" value="dsn:user:pass"/>

So, where can find the information telling me _how_ I can put my sofia
configuration into ODBC, instead of XML files?

Basically I'm looking for the equivalent of Asterisk's "Realtime" configuration
option, where SIP connections can be held in a database table instead of a flat
file, meaning that (a) it's easier to maintain dynamically, and (b) new entries
get used without needing a reload.

I'm liking FreeSwitch (after using it for about a month), but still finding it
sometimes hard to discover the definitive documentation for what it can do (or
how to make it do it).


Thanks,


Antony.

--
This sentence contains exacly three erors.

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

_________________________________________________________________________

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
Back to top
Antony.Stone at freesw...
Guest





PostPosted: Wed Nov 03, 2021 9:43 pm    Post subject: [Freeswitch-users] Sofia and ODBC Reply with quote

On Wednesday 03 November 2021 at 16:33:45, Martin Paterson wrote:

Quote:
I think you are confusing two different things here. The docs pages
you link to are about choosing the internal database that FreeSWITCH
uses for its internal state information. This is not the same as
serving configuration, which is by default provided in XML files.

You can dynamically serve the XML configuration with the module:
mod_xml_curl and also control call flow with mod_httapi.

Aha - that clarifies greatly - thank you.

I'm surprised that mod_xml_curl is not mentioned on the first page I found
about FreeSwitch and databases in general:

https://freeswitch.org/confluence/display/FREESWITCH/FreeSWITCH+Databases


Antony.

--
I bought a book on memory techniques, but I've forgotten where I put it.

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
Back to top
Jerry.Kendall at Bisho...
Guest





PostPosted: Wed Nov 03, 2021 10:33 pm    Post subject: [Freeswitch-users] Sofia and ODBC Reply with quote

Lookup "ODBC in the core"






Sent from my Galaxy





-------- Original message --------
From: Antony Stone <Antony.Stone@freeswitch.open.source.it>
Date: 2021-11-03 8:41 AM (GMT-05:00)
To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org>
Subject: [Freeswitch-users] Sofia and ODBC



Hi.

https://freeswitch.org/confluence/display/FREESWITCH/FreeSWITCH+Databases tells
me that "Instead of using the default SQLite database as the internal
FreeSWITCH database, you can use any core database type. This works for:
mod_db
mod_voicemail
mod_sofia
mod_dingaling
mod_cidlookup
mod_lcr"

Each of those is a link, and if I click on the mod_sofia link I get to the page
https://freeswitch.org/confluence/display/FREESWITCH/mod_sofia which tells me
nothing about using ODBC.

If I scroll further down the first page I started from, the heading "Configuring
FreeSWITCH to use databases" has a sub-section "mod_sofia" with a link pointing
to https://freeswitch.org/confluence/display/FREESWITCH/Sofia+Configuration+Files
whose only mention of ODBC is:

odbc-dsn
If you have ODBC support and a working dsn you can use it instead of SQLite
<param name="odbc-dsn" value="dsn:user:pass"/>

So, where can find the information telling me _how_ I can put my sofia
configuration into ODBC, instead of XML files?

Basically I'm looking for the equivalent of Asterisk's "Realtime" configuration
option, where SIP connections can be held in a database table instead of a flat
file, meaning that (a) it's easier to maintain dynamically, and (b) new entries
get used without needing a reload.

I'm liking FreeSwitch (after using it for about a month), but still finding it
sometimes hard to discover the definitive documentation for what it can do (or
how to make it do it).


Thanks,


Antony.

--
This sentence contains exacly three erors.

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
Back to top
gmaruzz at gmail.com
Guest





PostPosted: Thu Nov 04, 2021 4:57 am    Post subject: [Freeswitch-users] Sofia and ODBC Reply with quote

On Thu, Nov 4, 2021 at 3:11 AM Antony Stone <Antony.Stone@freeswitch.open.source.it (Antony.Stone@freeswitch.open.source.it)> wrote:

Quote:
On Wednesday 03 November 2021 at 16:33:45, Martin Paterson wrote:


I'm surprised that mod_xml_curl is not mentioned on the first page I found
about FreeSwitch and databases in general:



because has nothing to do with DBs, and all to do with xml and curl (http/s)?

Wink



--
Sincerely,

Giovanni Maruzzelli
OpenTelecom.IT
cell: +39 347 266 56 18
Back to top
Display posts from previous:   
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> freeSWITCH Users All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

VoiceMeUp - Corporate & Wholesale VoIP Services