[Freeswitch-users] Freeswitch 1.10.1 / MariaDB / ODBC / core-db-dsn / freeswitch does not start

[Thorsten Göllner]

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