[Freeswitch-users] MySQL setup

[David Villasmil]

+1 The best choice

On Mon, 6 Apr 2020 at 11:07, Vlad Toma <vldtoma at 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 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
>
> _________________________________________________________________________
>
> 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

-- 
Regards,

David Villasmil
email: david.villasmil.work at gmail.com
phone: +34669448337
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20200406/e96015be/attachment.html>