[Freeswitch-users] MySQL setup

[David Villasmil]

does i_sql work? Have you installed libmysql client?

Regards,

David Villasmil
email: david.villasmil.work at gmail.com
phone: +34669448337


On Sun, Apr 5, 2020 at 11:24 PM Sean Devoy <sdevoy at 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 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/20200406/dc6f7754/attachment.html>