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>:
Send FreeSWITCH-users mailing list submissions to 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
You can reach the person managing the list at 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> To: 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> To: FreeSWITCH Users Help <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 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
---------- Forwarded message ---------- From: Sean Devoy <sdevoy@bizfocused.com> To: FreeSWITCH Users Help <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> *On Behalf Of *David Villasmil *Sent:* Wednesday, October 16, 2019 11:56 AM *To:* FreeSWITCH Users Help <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> 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> *On Behalf Of *David Villasmil *Sent:* Tuesday, October 15, 2019 2:37 PM *To:* FreeSWITCH Users Help <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
phone: +34669448337
On Tue, Oct 15, 2019 at 7:22 PM Sean Devoy <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:
<configuration name="logfile.conf" description="File Logging">
<settings>
<!-- true to auto rotate on HUP, false to open/close -->
<param name="rotate-on-hup" value="true"/>
</settings>
<profiles>
<profile name="default">
<settings>
<!-- File to log to -->
<param name="logfile" value="/var/log/freeswitch.log"/>
<!-- At this length in bytes rotate the log file (0 for never) -->
<param name="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 -->
<param name="maximum-rotate" value="14"/>
<!-- Prefix all log lines by the session's uuid -->
<param name="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
-->
<map name="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 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
_________________________________________________________________________
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
--
Regards,
David Villasmil
email: 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 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