My setup is the same, but we had deadlocks with MySQL so we switched back to PostgreSQL:

 

Here is switch.xml it might help:

<param name="core-db-dsn" value="odbc://freeswitch:user:pass"/>

<param name="odbc-dsn" value="odbc://freeswitch:user:pass"/>

<param name="core-recovery-db-dsn" value="odbc://freeswitch:user:pass"/>

<param name="auto-create-schemas" value="true"/>

<param name="auto-clear-sql" value="true"/>

<param name="core-dbtype" value="MYSQL"/>

 

 

BR,

Zvonimir Bužanić

 

From: FreeSWITCH-users <freeswitch-users-bounces@lists.freeswitch.org> On Behalf Of David Villasmil
Sent: 16. listopada 2019. 23:57
To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org>
Subject: Re: [Freeswitch-users] Freeswitch 1.10.1 / MariaDB / ODBC / core-db-dsn / freeswitch does not start

 

can you paste freeswitch's log?

Regards,

 

David Villasmil

phone: +34669448337

 

 

On Wed, Oct 16, 2019 at 10:45 PM Thorsten Göllner <tg-maillistings@level5.de> wrote:

Hi,

I have a fresh install with:

OS: Debian 10
Freeswitch: 1.10.1-release-12-f9990221e6~64bit
MariaDB: 10.3 (Debian-Package)

I compiled MariaDB ODBC-Connector (3.1.4) via:

cd /usr/src
git clone https://github.com/MariaDB/mariadb-connector-odbc.git
cd mariadb-connector-odbc
cmake -DCMAKE_BUILD_TYPE=RelWithDebInfo -DCONC_WITH_UNIT_TESTS=Off
-DCONC_WITH_MSI=OFF -DCMAKE_INSTALL_PREFIX=/usr/local .
cmake --build . --config RelWithDebInfo
install libmaodbc.so /usr/lib/x86_64-linux-gnu/odbc/

My /etc/odbcinst.ini :
[MariaDB]
Description=MariaDB Connector/ODBC v.3.1.4 compiled from source
Driver=/usr/lib/x86_64-linux-gnu/odbc/libmaodbc.so
Setup=/usr/lib/x86_64-linux-gnu/odbc/libmaodbc.so
UsageCount = 1
FileUsage = 1
Threading = 0

My /etc/odbc.ini :
[freeswitch]
Driver    = MariaDB
SERVER    = 127.0.0.1
PORT      = 3306
DATABASE  = freeswitch
OPTION    = 67108864
Socket    = /run/mysqld/mysqld.sock
threading = 0
MaxLongVarcharSize = 65536

Works fine with:
isql -v freeswitch user password

My /etc/freeswitch/autoload_configs/switch.conf.xml :
[...]
<param name="core-db-dsn" value="odbc://freeswitch:user:password" />
[...]

When starting freeswitch I get the following feedback:

Oct 16 23:29:39 test systemd[1]: Starting freeswitch...
Oct 16 23:29:39 test freeswitch[1855]: 1856 Backgrounding.
Oct 16 23:30:24 test systemd[1]: freeswitch.service: Start operation
timed out. Terminating.
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for
background process pid:1856 to be ready.....
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for
background process pid:1856 to be ready.....
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for
background process pid:1856 to be ready.....
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for
background process pid:1856 to be ready.....
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for
background process pid:1856 to be ready.....
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for
background process pid:1856 to be ready.....
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for
background process pid:1856 to be ready.....
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for
background process pid:1856 to be ready.....
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for
background process pid:1856 to be ready.....
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for
background process pid:1856 to be ready.....
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for
background process pid:1856 to be ready.....
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for
background process pid:1856 to be ready.....
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for
background process pid:1856 to be ready.....
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for
background process pid:1856 to be ready.....
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for
background process pid:1856 to be ready.....
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for
background process pid:1856 to be ready.....
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for
background process pid:1856 to be ready.....
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for
background process pid:1856 to be ready.....
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for
background process pid:1856 to be ready.....
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for
background process pid:1856 to be ready.....
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for
background process pid:1856 to be ready.....
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for
background process pid:1856 to be ready.....
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Error starting
system! pid:1856
Oct 16 23:30:24 test systemd[1]: freeswitch.service: Control process
exited, code=exited, status=1/FAILURE
Oct 16 23:30:24 test systemd[1]: freeswitch.service: Failed with result
'timeout'.
Oct 16 23:30:24 test systemd[1]: Failed to start freeswitch.
Oct 16 23:30:25 test systemd[1]: freeswitch.service: Service
RestartSec=100ms expired, scheduling restart.
Oct 16 23:30:25 test systemd[1]: freeswitch.service: Scheduled restart
job, restart counter is at 2.


When going back to sqlite (<param name="core-db-dsn" value="$${dsn}" />)
everything works fine again.

What do I miss here?

Best regards, Thorsten


_________________________________________________________________________

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

This communication is for informational purposes only. All market prices, data and other information are not warranted as to completeness or accuracy and are subject to change without notice. Present message and any attached files may be or contain privileged information and is the property exclusive of ASSECO SEE CAPITAL GROUP. This transmission may contain information that is privileged, confidential, legally privileged, and/or exempt from disclosure under applicable law. The information contained in this message is solely intended for the physical or legal person to whom it is addressed and to the authorized persons for receiving it. In the case you are not the intended recipient or the authorized person to receive this message, we inform that disclosure, duplicate, distribution or taking up any actions on information contained in this message are strictly forbidden and are under civil and legal responsibility. In case you received it by error, you are requested to notify the sender and to destroy the original e-mail message from your system. Opinions, conclusions or any other information contained into this message, which are not related to ASSECO SEE CAPITAL GROUP activity must not be understood to be expressed or should be endorsed by ASSECO SEE CAPITAL GROUP. The interpretation expressed in the present message did not reflect ASSECO SEE CAPITAL GROUP opinion.