Freeswitch 1.10.1 / MariaDB / ODBC / core-db-dsn / freeswitch does not start
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
can you paste freeswitch's log? Regards, David Villasmil email: david.villasmil.work@gmail.com 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
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 email: david.villasmil.work@gmail.com<mailto:david.villasmil.work@gmail.com> phone: +34669448337 On Wed, Oct 16, 2019 at 10:45 PM Thorsten Göllner <tg-maillistings@level5.de<mailto: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<mailto: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<mailto: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.
participants (3)
-
David Villasmil
-
Thorsten Göllner
-
Zvonimir Bužanić