I switched to mod_mariadb and now the server starts without any issue. Thanks a lot! Am 17.10.2019 um 01:40 schrieb Andrey Wolk:
Why ODBC? Use mod_mariadb instead. Install the mod via apt and configure according these tips: https://freeswitch.org/jira/browse/FS-11727
чт, 17 окт. 2019 г., 2:04 <freeswitch-users-request@lists.freeswitch.org <mailto:freeswitch-users-request@lists.freeswitch.org>>:
Send FreeSWITCH-users mailing list submissions to freeswitch-users@lists.freeswitch.org <mailto:freeswitch-users@lists.freeswitch.org>
To subscribe or unsubscribe via the World Wide Web, visit http://lists.freeswitch.org/mailman/listinfo/freeswitch-users or, via email, send a message with subject or body 'help' to freeswitch-users-request@lists.freeswitch.org <mailto:freeswitch-users-request@lists.freeswitch.org>
You can reach the person managing the list at freeswitch-users-owner@lists.freeswitch.org <mailto:freeswitch-users-owner@lists.freeswitch.org>
When replying, please edit your Subject line so it is more specific than "Re: Contents of FreeSWITCH-users digest..." Today's Topics:
1. Freeswitch 1.10.1 / MariaDB / ODBC / core-db-dsn / freeswitch does not start (Thorsten Göllner) 2. Re: Freeswitch 1.10.1 / MariaDB / ODBC / core-db-dsn / freeswitch does not start (David Villasmil) 3. Re: Logfile problems (Sean Devoy)
---------- Forwarded message ---------- From: "Thorsten Göllner" <tg-maillistings@level5.de <mailto:tg-maillistings@level5.de>> To: freeswitch-users@lists.freeswitch.org <mailto:freeswitch-users@lists.freeswitch.org> Cc: Bcc: Date: Wed, 16 Oct 2019 23:33:37 +0200 Subject: [Freeswitch-users] 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
---------- Forwarded message ---------- From: David Villasmil <david.villasmil.work@gmail.com <mailto:david.villasmil.work@gmail.com>> To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org <mailto:freeswitch-users@lists.freeswitch.org>> Cc: Bcc: Date: Wed, 16 Oct 2019 22:57:27 +0100 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
---------- Forwarded message ---------- From: Sean Devoy <sdevoy@bizfocused.com <mailto:sdevoy@bizfocused.com>> To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org <mailto:freeswitch-users@lists.freeswitch.org>> Cc: Bcc: Date: Wed, 16 Oct 2019 22:03:46 +0000 Subject: Re: [Freeswitch-users] Logfile problems
Thanks for your help. I was looking in /var/log/freeswitch for freeswitch.log. They are in /var/log called freeswitch.log*
*From:* FreeSWITCH-users <freeswitch-users-bounces@lists.freeswitch.org <mailto:freeswitch-users-bounces@lists.freeswitch.org>> *On Behalf Of *David Villasmil *Sent:* Wednesday, October 16, 2019 11:56 AM *To:* FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org <mailto:freeswitch-users@lists.freeswitch.org>> *Subject:* Re: [Freeswitch-users] Logfile problems
Whenever I get issues like that, I start freeswitch from the command line, and check for errors.
Try that
On Wed, 16 Oct 2019 at 16:47, Sean Devoy <sdevoy@bizfocused.com <mailto:sdevoy@bizfocused.com>> wrote:
I checked the permissions and they are good. Restarted again. Still no log files.
Any ideas?
Sean
*From:* FreeSWITCH-users <freeswitch-users-bounces@lists.freeswitch.org <mailto:freeswitch-users-bounces@lists.freeswitch.org>> *On Behalf Of *David Villasmil *Sent:* Tuesday, October 15, 2019 2:37 PM *To:* FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org <mailto:freeswitch-users@lists.freeswitch.org>> *Subject:* Re: [Freeswitch-users] Logfile problems
permissions? usually fs logs go into /var/log/freeswitch/
Regards,
David Villasmil
email: david.villasmil.work@gmail.com <mailto:david.villasmil.work@gmail.com>
phone: +34669448337
On Tue, Oct 15, 2019 at 7:22 PM Sean Devoy <sdevoy@bizfocused.com <mailto:sdevoy@bizfocused.com>> wrote:
Hi,
I installed v 10 from distro on Debian 10.
My initial logfile is 100MB.
I checked the logfile.conf.xml in autoload_config.
It has this:
<configurationname="logfile.conf"description="File Logging">
<settings>
<!--true to auto rotate on HUP, false to open/close -->
<paramname="rotate-on-hup"value="true"/>
</settings>
<profiles>
<profilename="default">
<settings>
<!--File to log to -->
<paramname="logfile"value="/var/log/freeswitch.log"/>
<!--At this length in bytes rotate the log file (0 for never) -->
<paramname="rollover"value="10000000"/>
<!--Maximum number of log files to keep before wrapping -->
<!--If this parameter is enabled, the log filenames will not include a date stamp -->
<paramname="maximum-rotate"value="14"/>
<!--Prefix all log lines by the session's uuid -->
<paramname="uuid"value="true"/>
</settings>
<mappings>
<!--
name can be a file name, function name or 'all'
value is one or more of debug,info,notice,warning,err,crit,alert,all
Please see comments in console.conf.xml for more information
-->
<mapname="all"value="console,debug,info,notice,warning,err,crit,alert"/>
</mappings>
</profile>
</profiles>
</configuration>
I restarted FS and now I have no logfile (that I can find).
Ideas?
Sean
_________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire https://signalwire.com <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 <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
_________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire https://signalwire.com <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 <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
--
Regards,
David Villasmil
email: david.villasmil.work@gmail.com <mailto:david.villasmil.work@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@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
_________________________________________________________________________
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