[Freeswitch-users] Freeswitch 1.10.1 / MariaDB / ODBC / core-db-dsn
Thorsten Göllner
tg-maillistings at level5.de
Thu Oct 17 10:27:30 UTC 2019
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 at lists.freeswitch.org
> <mailto:freeswitch-users-request at lists.freeswitch.org>>:
>
> Send FreeSWITCH-users mailing list submissions to
> freeswitch-users at lists.freeswitch.org
> <mailto:freeswitch-users at 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 at lists.freeswitch.org
> <mailto:freeswitch-users-request at lists.freeswitch.org>
>
> You can reach the person managing the list at
> freeswitch-users-owner at lists.freeswitch.org
> <mailto:freeswitch-users-owner at 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 at level5.de
> <mailto:tg-maillistings at level5.de>>
> To: freeswitch-users at lists.freeswitch.org
> <mailto:freeswitch-users at 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 at gmail.com
> <mailto:david.villasmil.work at gmail.com>>
> To: FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org
> <mailto:freeswitch-users at 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 at gmail.com
> <mailto: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 <mailto: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 <mailto: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
> <mailto: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
>
>
>
>
> ---------- Forwarded message ----------
> From: Sean Devoy <sdevoy at bizfocused.com
> <mailto:sdevoy at bizfocused.com>>
> To: FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org
> <mailto:freeswitch-users at 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 at lists.freeswitch.org
> <mailto:freeswitch-users-bounces at lists.freeswitch.org>> *On Behalf
> Of *David Villasmil
> *Sent:* Wednesday, October 16, 2019 11:56 AM
> *To:* FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org
> <mailto:freeswitch-users at 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 at bizfocused.com
> <mailto:sdevoy at 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 at lists.freeswitch.org
> <mailto:freeswitch-users-bounces at lists.freeswitch.org>> *On
> Behalf Of *David Villasmil
> *Sent:* Tuesday, October 15, 2019 2:37 PM
> *To:* FreeSWITCH Users Help
> <freeswitch-users at lists.freeswitch.org
> <mailto:freeswitch-users at 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 at gmail.com
> <mailto:david.villasmil.work at gmail.com>
>
> phone: +34669448337
>
>
>
>
>
> On Tue, Oct 15, 2019 at 7:22 PM Sean Devoy
> <sdevoy at bizfocused.com <mailto:sdevoy at 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 at freeswitch.com <mailto: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
> <mailto: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
>
> _________________________________________________________________________
>
> 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 at freeswitch.com <mailto: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
> <mailto: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
>
> --
>
> Regards,
>
>
>
> David Villasmil
>
> email: david.villasmil.work at gmail.com
> <mailto:david.villasmil.work at 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 at freeswitch.com <mailto: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
> <mailto: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
>
>
> _________________________________________________________________________
>
> 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/20191017/e81b5e17/attachment-0001.html>
More information about the FreeSWITCH-users
mailing list