<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.crayon-sy
{mso-style-name:crayon-sy;}
span.crayon-v
{mso-style-name:crayon-v;}
span.crayon-o
{mso-style-name:crayon-o;}
span.crayon-e
{mso-style-name:crayon-e;}
span.crayon-st
{mso-style-name:crayon-st;}
span.crayon-h
{mso-style-name:crayon-h;}
span.crayon-cn
{mso-style-name:crayon-cn;}
span.crayon-i
{mso-style-name:crayon-i;}
span.crayon-t
{mso-style-name:crayon-t;}
span.crayon-s
{mso-style-name:crayon-s;}
.MsoChpDefault
{mso-style-type:export-only;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="HR" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">My setup is the same, but we had deadlocks with MySQL so we switched back to PostgreSQL:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Here is switch.xml it might help:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><param name="core-db-dsn" value="odbc://freeswitch:user:pass"/><o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><param name="odbc-dsn" value="odbc://freeswitch:user:pass"/><o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><param name="core-recovery-db-dsn" value="odbc://freeswitch:user:pass"/><o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><param name="auto-create-schemas" value="true"/><o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><param name="auto-clear-sql" value="true"/><o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><param name="core-dbtype" value="MYSQL"/><o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">BR,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Zvonimir Bužanić<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> FreeSWITCH-users <freeswitch-users-bounces@lists.freeswitch.org>
<b>On Behalf Of </b>David Villasmil<br>
<b>Sent:</b> 16. listopada 2019. 23:57<br>
<b>To:</b> FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org><br>
<b>Subject:</b> Re: [Freeswitch-users] Freeswitch 1.10.1 / MariaDB / ODBC / core-db-dsn / freeswitch does not start<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">can you paste freeswitch's log?<br clear="all">
<o:p></o:p></p>
<div>
<div>
<div>
<div>
<p class="MsoNormal">Regards,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal">David Villasmil<o:p></o:p></p>
<div>
<p class="MsoNormal">email: <a href="mailto:david.villasmil.work@gmail.com" target="_blank">
david.villasmil.work@gmail.com</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">phone: +34669448337<o:p></o:p></p>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">On Wed, Oct 16, 2019 at 10:45 PM Thorsten Göllner <<a href="mailto:tg-maillistings@level5.de">tg-maillistings@level5.de</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<p class="MsoNormal">Hi,<br>
<br>
I have a fresh install with:<br>
<br>
OS: Debian 10<br>
Freeswitch: 1.10.1-release-12-f9990221e6~64bit<br>
MariaDB: 10.3 (Debian-Package)<br>
<br>
I compiled MariaDB ODBC-Connector (3.1.4) via:<br>
<br>
cd /usr/src<br>
git clone <a href="https://github.com/MariaDB/mariadb-connector-odbc.git" target="_blank">
https://github.com/MariaDB/mariadb-connector-odbc.git</a><br>
cd mariadb-connector-odbc<br>
cmake -DCMAKE_BUILD_TYPE=RelWithDebInfo -DCONC_WITH_UNIT_TESTS=Off<br>
-DCONC_WITH_MSI=OFF -DCMAKE_INSTALL_PREFIX=/usr/local .<br>
cmake --build . --config RelWithDebInfo<br>
install libmaodbc.so /usr/lib/x86_64-linux-gnu/odbc/<br>
<br>
My /etc/odbcinst.ini :<br>
[MariaDB]<br>
Description=MariaDB Connector/ODBC v.3.1.4 compiled from source<br>
Driver=/usr/lib/x86_64-linux-gnu/odbc/libmaodbc.so<br>
Setup=/usr/lib/x86_64-linux-gnu/odbc/libmaodbc.so<br>
UsageCount = 1<br>
FileUsage = 1<br>
Threading = 0<br>
<br>
My /etc/odbc.ini :<br>
[freeswitch]<br>
Driver = MariaDB<br>
SERVER = 127.0.0.1<br>
PORT = 3306<br>
DATABASE = freeswitch<br>
OPTION = 67108864<br>
Socket = /run/mysqld/mysqld.sock<br>
threading = 0<br>
MaxLongVarcharSize = 65536<br>
<br>
Works fine with:<br>
isql -v freeswitch user password<br>
<br>
My /etc/freeswitch/autoload_configs/switch.conf.xml :<br>
[...]<br>
<param name="core-db-dsn" value="odbc://freeswitch:user:password" /><br>
[...]<br>
<br>
When starting freeswitch I get the following feedback:<br>
<br>
Oct 16 23:29:39 test systemd[1]: Starting freeswitch...<br>
Oct 16 23:29:39 test freeswitch[1855]: 1856 Backgrounding.<br>
Oct 16 23:30:24 test systemd[1]: freeswitch.service: Start operation<br>
timed out. Terminating.<br>
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for<br>
background process pid:1856 to be ready.....<br>
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for<br>
background process pid:1856 to be ready.....<br>
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for<br>
background process pid:1856 to be ready.....<br>
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for<br>
background process pid:1856 to be ready.....<br>
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for<br>
background process pid:1856 to be ready.....<br>
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for<br>
background process pid:1856 to be ready.....<br>
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for<br>
background process pid:1856 to be ready.....<br>
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for<br>
background process pid:1856 to be ready.....<br>
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for<br>
background process pid:1856 to be ready.....<br>
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for<br>
background process pid:1856 to be ready.....<br>
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for<br>
background process pid:1856 to be ready.....<br>
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for<br>
background process pid:1856 to be ready.....<br>
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for<br>
background process pid:1856 to be ready.....<br>
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for<br>
background process pid:1856 to be ready.....<br>
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for<br>
background process pid:1856 to be ready.....<br>
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for<br>
background process pid:1856 to be ready.....<br>
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for<br>
background process pid:1856 to be ready.....<br>
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for<br>
background process pid:1856 to be ready.....<br>
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for<br>
background process pid:1856 to be ready.....<br>
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for<br>
background process pid:1856 to be ready.....<br>
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for<br>
background process pid:1856 to be ready.....<br>
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Waiting for<br>
background process pid:1856 to be ready.....<br>
Oct 16 23:30:24 test freeswitch[1855]: FreeSWITCH[1855] Error starting<br>
system! pid:1856<br>
Oct 16 23:30:24 test systemd[1]: freeswitch.service: Control process<br>
exited, code=exited, status=1/FAILURE<br>
Oct 16 23:30:24 test systemd[1]: freeswitch.service: Failed with result<br>
'timeout'.<br>
Oct 16 23:30:24 test systemd[1]: Failed to start freeswitch.<br>
Oct 16 23:30:25 test systemd[1]: freeswitch.service: Service<br>
RestartSec=100ms expired, scheduling restart.<br>
Oct 16 23:30:25 test systemd[1]: freeswitch.service: Scheduled restart<br>
job, restart counter is at 2.<br>
<br>
<br>
When going back to sqlite (<param name="core-db-dsn" value="$${dsn}" />)<br>
everything works fine again.<br>
<br>
What do I miss here?<br>
<br>
Best regards, Thorsten<br>
<br>
<br>
_________________________________________________________________________<br>
<br>
The FreeSWITCH project is sponsored by SignalWire <a href="https://signalwire.com" target="_blank">
https://signalwire.com</a><br>
Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services.<br>
Build your next product on our scalable cloud platform.<br>
<br>
Join our online community to chat in real time <a href="https://signalwire.community" target="_blank">
https://signalwire.community</a><br>
<br>
Professional FreeSWITCH Services<br>
<a href="mailto:sales@freeswitch.com" target="_blank">sales@freeswitch.com</a><br>
<a href="https://freeswitch.com" target="_blank">https://freeswitch.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="https://freeswitch.com/oss" target="_blank">https://freeswitch.com/oss</a><br>
<a href="https://freeswitch.org/confluence" target="_blank">https://freeswitch.org/confluence</a><br>
<a href="https://cluecon.com" target="_blank">https://cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="https://freeswitch.com" target="_blank">https://freeswitch.com</a><o:p></o:p></p>
</blockquote>
</div>
</div>
<font size="1" face="arial" color="gray">This communication is for informational purposes only. All market prices, data and other information are not warranted as to completeness or accuracy and are subject to change without notice. Present message and any
attached files may be or contain privileged information and is the property exclusive of ASSECO SEE CAPITAL GROUP. This transmission may contain information that is privileged, confidential, legally privileged, and/or exempt from disclosure under applicable
law. The information contained in this message is solely intended for the physical or legal person to whom it is addressed and to the authorized persons for receiving it. In the case you are not the intended recipient or the authorized person to receive this
message, we inform that disclosure, duplicate, distribution or taking up any actions on information contained in this message are strictly forbidden and are under civil and legal responsibility. In case you received it by error, you are requested to notify
the sender and to destroy the original e-mail message from your system. Opinions, conclusions or any other information contained into this message, which are not related to ASSECO SEE CAPITAL GROUP activity must not be understood to be expressed or should
be endorsed by ASSECO SEE CAPITAL GROUP. The interpretation expressed in the present message did not reflect ASSECO SEE CAPITAL GROUP opinion.
</font>
</body>
</html>