[Freeswitch-users] Sofia and ODBC

[Martin Paterson]

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 at 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+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 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