[Freeswitch-users] MySQL setup

Sean Devoy sdevoy at bizfocused.com
Sun Apr 5 22:19:08 UTC 2020


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'
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20200405/8a85310b/attachment.html>


More information about the FreeSWITCH-users mailing list