[Freeswitch-users] MySQL setup

[Jurijs Ivolga]

Hi,

If you go with unixODBC:

1) You need to install unixodbc (apt-get -y install unixodbc)
2) Install odbc connector for MariaDB, for me it worked only 2.0.* version
on Debian 10 (wget
https://downloads.mariadb.com/Connectors/odbc/connector-odbc-2.0.19/mariadb-connector-odbc-2.0.19-ga-debian-x86_64.tar.gz
&& tar -xvzf mariadb-co* && install lib/libmaodbc.so)
3) Configure odbc connector, something like this:
https://mariadb.com/kb/en/creating-a-data-source-with-mariadb-connectorodbc/
4) test if you can connect to MariaDB using isql command.

At this point there will left only Freeswitch to configure. I believe you
do not have installed unixodbc or odbc connector.

Jurijs


On Mon, Apr 6, 2020 at 1:56 PM David Villasmil <
david.villasmil.work at gmail.com> wrote:

> +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
> _________________________________________________________________________
>
> 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/db159757/attachment.html>