Hello, You can either install both and configure them , or you can use this directly with mariadb <param name="core-db-dsn" value="mariadb://Server=localhost;Database=freeswitch;Uid=freeswitch;Pwd=pass;" /> On Mon, Apr 6, 2020 at 1:26 AM Sean Devoy <sdevoy@bizfocused.com> wrote:
Hi,
I am running fs 1.10 on Debian 10 64bit.
I have searched for help configuring FreeSwitch to use MySQL. I have configured db.conf.xml for Mysql:
<param name="core-db-dsn" value="odbc://DRIVER=mysql;SERVER=serveriphere;UID=userhere;PWD=passwordhere;DATABASE=freeswitch;OPTION=67108864" />
I have reloaded, restarted and rebooted. FreeSwitch continues to use sqlite.
Is there more to configure?
Do I need to install unixODBC and/or MySql driver?
Here is the error:
2020-04-05 20:57:48.159620 [ERR] switch_odbc.c:368 STATE: 01000 CODE 0 ERROR: [unixODBC][Driver Manager]Can't open lib 'mysql' : file not found
2020-04-05 20:57:48.159658 [CRIT] switch_core_sqldb.c:646 Failure to connect to ODBC DRIVER=mysql;SERVER=127.0.0.1;UID=xxxxxx;PWD=XXXXXXXXXX;DATABASE=freeswitch;OPTION=67108864!
2020-04-05 20:57:48.160130 [CONSOLE] switch_loadable_module.c:1804 Successfully Loaded [mod_db]
2020-04-05 20:57:48.160146 [NOTICE] switch_loadable_module.c:350 Adding Application 'db' _________________________________________________________________________
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