+1 The best choice--On Mon, 6 Apr 2020 at 11:07, Vlad Toma <vldtoma@gmail.com> wrote: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
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_________________________________________________________________________
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