[Freeswitch-users] Freeswitch 1.10.1 / MariaDB / ODBC / core-db-dsn
Andrey Wolk
andywolk at gmail.com
Wed Oct 16 23:40:50 UTC 2019
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>:
> Send FreeSWITCH-users mailing list submissions to
> 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
>
> You can reach the person managing the list at
> 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>
> To: 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>
> To: FreeSWITCH Users Help <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
> phone: +34669448337
>
>
> On Wed, Oct 16, 2019 at 10:45 PM Thorsten Göllner <
> 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
>> 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
>
>
>
>
> ---------- Forwarded message ----------
> From: Sean Devoy <sdevoy at bizfocused.com>
> To: FreeSWITCH Users Help <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> *On
> Behalf Of *David Villasmil
> *Sent:* Wednesday, October 16, 2019 11:56 AM
> *To:* FreeSWITCH Users Help <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> 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> *On
> Behalf Of *David Villasmil
> *Sent:* Tuesday, October 15, 2019 2:37 PM
> *To:* FreeSWITCH Users Help <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
>
> phone: +34669448337
>
>
>
>
>
> On Tue, Oct 15, 2019 at 7:22 PM Sean Devoy <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:
>
> <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 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
>
> _________________________________________________________________________
>
> 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
>
> --
>
> Regards,
>
>
>
> David Villasmil
>
> email: 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
> 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/356e7e43/attachment-0001.html>
More information about the FreeSWITCH-users
mailing list