[Freeswitch-users] Switch to MySQL db for config

[Martin Paterson]

This page talks about it:
https://freeswitch.org/confluence/display/FREESWITCH/ODBC+DSN.
Basically there's a parameter switch-core-dsn in switch.conf.xml. In
the vanilla config there's a bunch of comments in that file explaining
the options.

No need to worry about creating the schema - FreeSWITCH does that for you.

Martin.

Martin Paterson, Pattersong Music
Reduced orchestrations of G&S

On Tue, 7 Dec 2021 at 22:25, TTT <lists at telium.io> wrote:
>
> I was actually referring to FreeSWITCH core.  I'm reading a book on FreeSwitch  (https://www.amazon.ca/FreeSWITCH-1-8-Anthony-Minessale-II-ebook/dp/B071ZZBH8G/ref=sr_1_3?keywords=freeswitch&qid=1638915802&s=books&sr=1-3) and it mentions that FreeSWITCH keeps its operating information in a database at runtime.  I think it's PostgreSQL
>
> I was wondering if/how I could switch that to MySQL.  I thought there might be a DSN setting in the XML registry that affects this.  This books says you can setup ODBC providers but it's not clear how, or if this applies to "core".
>
> -----Original Message-----
> From: FreeSWITCH-users [mailto:freeswitch-users-bounces at lists.freeswitch.org] On Behalf Of Antony Stone
> Sent: Monday, December 6, 2021 11:02 AM
> To: FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org>
> Subject: Re: [Freeswitch-users] Switch to MySQL db for config
>
> On Monday 06 December 2021 at 16:00:30, TTT wrote:
>
> > I would like to use MySQL to hold my FreeSWITCH config.
>
> What do you mean by "config"?
>
> All of it, or just certain aspects (such as user directory, SIP registrations, dialplan...)?
>
> > I found instructions on how to setup the DSN,
>
> Point us at the URL so that we know what you're doing?
>
> > but how to I create the db/table structure?  Is there a script to do this?
>
> What are you using as the "glue" between MySQL and FreeSwitch?  Common options would be xml-curl or lua.  In both cases you create your DB tables however you like, and you then write a lua script or create something that curl can interrogate, to return the XML which you would otherwise have placed into a flat file for FreeSwitch to parse.
>
>
> Regards,
>
>
> Antony.
>
> --
> .evah I serutangis sseltniop tsom eht fo eno eb tsum sihT
>
>                                                    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
>
>
> _________________________________________________________________________
>
> 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