<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi,<br>
<br>
Do you have wss endpoints?<br>
<br>
<br>
<div class="moz-cite-prefix">On 01/03/2018 04:32 PM, Geoff Mina
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:6507AF29-DCCF-4651-8392-B97C7BE4186C@connectfirst.com">
<meta http-equiv="content-type" content="text/html; charset=utf-8">
It only happened the once. Didn’t look into root cause - just
eliminated the problem.
<div><br>
</div>
<div>This is running on an SSD backed Amazon EC2 instance. The
hypervisor, vm, and FS all have been up and running for months
without issue. No restarts or power cycles. </div>
<div><br>
</div>
<div>I tried to use sqlite3 to inspect the file, but it wouldn’t
open the DB. <br>
<br>
<div>
<div>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt;"><br>
</p>
</div>
</div>
<div><br>
On Jan 3, 2018, at 7:33 AM, Ken Rice <<a
href="mailto:krice@freeswitch.org" moz-do-not-send="true">krice@freeswitch.org</a>>
wrote:<br>
<br>
</div>
<blockquote type="cite">
<div>
<meta http-equiv="Content-Type" content="text/html;
charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]-->
<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:0in;
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:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
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]-->
<div class="WordSection1">
<p class="MsoNormal">Did you figure out the root of the
corruption issue? Sqlite has proven stable in FS over
trillions of calls in both small and large installs so I
wonder whats actually causing the issue you are seeing.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b>From:</b> FreeSWITCH-users [<a
href="mailto:freeswitch-users-bounces@lists.freeswitch.org"
moz-do-not-send="true">mailto:freeswitch-users-bounces@lists.freeswitch.org</a>]
<b>On Behalf Of </b>Geoff Mina<br>
<b>Sent:</b> Tuesday, January 2, 2018 9:21 PM<br>
<b>To:</b> <a
href="mailto:freeswitch-users@lists.freeswitch.org"
moz-do-not-send="true">freeswitch-users@lists.freeswitch.org</a><br>
<b>Subject:</b> Re: [Freeswitch-users] sqlite DB -
help?!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"> I finally figured it out. I
didn't realize that I needed a specific odbc-dsn
parameter in both the internal and external
sip_profiles. Adding the following to both of my
profiles seems to have resolved the issues.<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"> <param name="odbc-dsn"
value="freeswitch:freeswitch:freeswitch"/><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I wish the documentation on the
various ODBC settings was a little more clear.
Anyway... all good now, we are no longer relying on
corruption prone SQLite for our registrations.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Thanks,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Geoff<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><br clear="all">
<o:p></o:p></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p><b><span style="font-size:9.5pt">GEOFF
MINA<u><br>
</u></span></b><span
style="font-size:9.5pt">Chief
Executive Officer<br>
Connect First / Contact Center
Solutions, Built Better.<o:p></o:p></span></p>
<p><span style="font-size:9.5pt">3101 Iris
Ave #200, Boulder, CO 80301<br>
<a href="tel:%28720%29%20335-5924"
target="_blank"
moz-do-not-send="true"><span
style="color:#1155CC">720.335.5924</span></a><br>
<a
href="mailto:gmina@connectfirst.com"
target="_blank"
moz-do-not-send="true"><span
style="color:#1155CC">gmina@connectfirst.com</span></a> / <a
href="http://connectfirst.com/"
target="_blank"
moz-do-not-send="true"><span
style="color:#1155CC">www.connectfirst.com</span></a><o:p></o:p></span></p>
<p><span style="font-size:9.5pt"> <image001.png><o:p></o:p></span></p>
<p><span style="font-size:9.5pt"> This
email and any files transmitted with
it are confidential and intended
solely for the use of the individual
or entity to whom they are addressed.
If you have received this email in
error please notify the system
manager.<o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On Tue, Jan 2, 2018 at 5:26 PM,
Geoff Mina <<a
href="mailto:gmina@connectfirst.com"
target="_blank" moz-do-not-send="true">gmina@connectfirst.com</a>>
wrote:<o:p></o:p></p>
<blockquote style="border:none;border-left:solid
#CCCCCC 1.0pt;padding:0in 0in 0in
6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<p class="MsoNormal">Greetings,<o:p></o:p></p>
<div>
<p class="MsoNormal">I have a freeswitch
installation that is configured to use MySQL
(via ODBC) in switch.xml. Today we had one of
our freeswitch hosts go out of service with
this error:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<p class="MsoNormal"><b>2018-01-03
00:14:51.340034 [ERR]
switch_core_sqldb.c:587 NATIVE SQL ERR
[database disk image is malformed]</b><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><b>delete from
sip_registrations where
sip_user='rcampos1' and
sip_host='10.201.0.94'</b><o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Through some searching, we
determined that is the result of the sqlite db
becoming corrupt. There were no power events,
but it simply stopped working. Now... I don't
even want to use sqllite. We have MySQL
configured and is working properly. Here is
our config from switch.xml<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<p class="MsoNormal"> <param
name="core-db-dsn"
value="freeswitch:freeswitch:freeswitch"
/><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <param
name="auto-create-schemas" value="true"/><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <param
name="auto-clear-sql" value="true"/><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <param
name="core-dbtype" value="MYSQL"/><o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">The registrations and calls
ARE showing up in MySQL, so the ODBC
connection is working. Why would Freeswitch
continue to use SQLite even though we have
configured the core to use MySQL? Even after
clearing out the /freeswtich/db directory,
upon restart, the following files show up
again. It's as if Freeswitch is writing to
both SQLite and MySQL.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<p class="MsoNormal">-rw-r--r-- 1 14K Jan 3
00:16 call_limit.db<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">-rw-r--r-- 1 5.0K Jan 3
00:16 fifo.db<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">-rw-r--r-- 1 93K Jan 3
00:16 sofia_reg_external.db<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">-rw-r--r-- 1 99K Jan 3
00:26 sofia_reg_internal.db<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Any help would be greatly
appreciated.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Thanks,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Geoff<o:p></o:p></p>
</div>
</div>
</blockquote>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
</blockquote>
<blockquote type="cite">
<div><span>_________________________________________________________________________</span><br>
<span>Professional FreeSWITCH Consulting Services:</span><br>
<span><a href="mailto:consulting@freeswitch.org"
moz-do-not-send="true">consulting@freeswitch.org</a></span><br>
<span><a href="http://www.freeswitchsolutions.com"
moz-do-not-send="true">http://www.freeswitchsolutions.com</a></span><br>
<span></span><br>
<span>Official FreeSWITCH Sites</span><br>
<span><a href="http://www.freeswitch.org"
moz-do-not-send="true">http://www.freeswitch.org</a></span><br>
<span><a href="http://confluence.freeswitch.org"
moz-do-not-send="true">http://confluence.freeswitch.org</a></span><br>
<span><a href="http://www.cluecon.com"
moz-do-not-send="true">http://www.cluecon.com</a></span><br>
<span></span><br>
<span>FreeSWITCH-users mailing list</span><br>
<span><a href="mailto:FreeSWITCH-users@lists.freeswitch.org"
moz-do-not-send="true">FreeSWITCH-users@lists.freeswitch.org</a></span><br>
<span><a
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
moz-do-not-send="true">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a></span><br>
<span>UNSUBSCRIBE:<a
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
moz-do-not-send="true">http://lists.freeswitch.org/mailman/options/freeswitch-users</a></span><br>
<span><a href="http://www.freeswitch.org"
moz-do-not-send="true">http://www.freeswitch.org</a></span></div>
</blockquote>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
<a class="moz-txt-link-abbreviated" href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a>
Official FreeSWITCH Sites
<a class="moz-txt-link-freetext" href="http://www.freeswitch.org">http://www.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://confluence.freeswitch.org">http://confluence.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://www.cluecon.com">http://www.cluecon.com</a>
FreeSWITCH-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
UNSUBSCRIBE:<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a class="moz-txt-link-freetext" href="http://www.freeswitch.org">http://www.freeswitch.org</a></pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Saludos / Regards / Cumprimentos
António Silva</pre>
</body>
</html>