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?
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/
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--
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