[Freeswitch-users] Switch to MySQL db for config

[Rahman Duran]

Hi,

Adding " <param name="core-db-dsn" value="pgsql://hostaddr=127.0.0.1
dbname=freeswitch user=freeswitch password='blablabla' options='-c
client_min_messages=NOTICE'" />" to "switch.conf.xml" did the trick for us.
You can add a similar line for mariadb/mysql.

Rahman


TTT <lists at telium.io>, 8 Ara 2021 Çar, 07:12 tarihinde şunu yazdı:

> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20211208/3428eccf/attachment.html>