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

[David Villasmil]

can you paste freeswitch's log?
Regards,

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


On Wed, Oct 16, 2019 at 10:45 PM Thorsten Göllner <tg-maillistings at 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 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/20191016/cffe6f74/attachment.html>