<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/4.4.4">
</HEAD>
<BODY>
The power loss must have caused database corruption. You can remove the presence db and restart FS, it will be re-created from scratch and registrations should start happening again!<BR>
<BR>
François.<BR>
<BR>
On Sun, 2013-09-01 at 11:47 -0500, Blake Priddy wrote:
<BLOCKQUOTE TYPE=CITE>
I had to manually start the internal profile. And now when a registration occurs i get this message.. School starts back tuesday please help haha
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BR>
<BR>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
2013-09-01 11:45:38.234642 [ERR] switch_core_sqldb.c:581 NATIVE SQL ERR [database is locked]
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
update sip_subscriptions set version=version+1 where ((expires > 0 and expires <= 1378053639)) and profile_name='internal' and hostname='voice'
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
2013-09-01 11:45:38.234642 [ERR] switch_core_sqldb.c:581 NATIVE SQL ERR [database disk image is malformed]
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
delete from sip_subscriptions where ((expires > 0 and expires <= 1378053639)) and profile_name='internal' and hostname='voice'
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BR>
<BR>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BR>
<BR>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BR>
<BR>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BR>
<BR>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
--
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<IMG SRC="http://dl.dropbox.com/u/6313391/BryantSchoolDist_Seal_final%20(1).png" WIDTH="96" HEIGHT="93" ALIGN="bottom" BORDER="0"> <IMG SRC="http://www.aerohive.com/sites/default/files/acwa.png" WIDTH="95" HEIGHT="96" ALIGN="bottom" BORDER="0">
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BR>
<BR>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<B>Blakelund Priddy</B>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<FONT COLOR="#000000">Network & Systems Engineer</FONT><BR>
Bryant Public School District<BR>
Bryant, Arkansas 72022<BR>
<A HREF="http://www.bryantschools.org/">http://www.bryantschools.org</A><BR>
<BR>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
p 501-653-5038<BR>
f 501-847-5656
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BR>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BR>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<PRE>
_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
<A HREF="mailto:consulting@freeswitch.org">consulting@freeswitch.org</A>
<A HREF="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</A>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
<A HREF="http://www.cudatel.com">http://www.cudatel.com</A>
Official FreeSWITCH Sites
<A HREF="http://www.freeswitch.org">http://www.freeswitch.org</A>
<A HREF="http://wiki.freeswitch.org">http://wiki.freeswitch.org</A>
<A HREF="http://www.cluecon.com">http://www.cluecon.com</A>
FreeSWITCH-users mailing list
<A HREF="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</A>
<A HREF="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</A>
UNSUBSCRIBE:<A HREF="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</A>
<A HREF="http://www.freeswitch.org">http://www.freeswitch.org</A>
</PRE>
</BLOCKQUOTE>
<BR>
</BODY>
</HTML>