[Freeswitch-users] Switch to MySQL db for config

[TTT]

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