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+Fil... 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.comEnhance 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.communityProfessional FreeSWITCH Servicessales@freeswitch.comhttps://freeswitch.comOfficial FreeSWITCH Siteshttps://freeswitch.com/osshttps://freeswitch.org/confluencehttps://cluecon.c... mailing listFreeSWITCH-users@lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-usersUNSUBSCRIBE:htt...

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:

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+Fil... 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