Just delete the sofia_ ones and there won't be any permanent loss. On Sun, Sep 1, 2013 at 12:38 PM, Steven Ayre <steveayre@gmail.com> wrote:
If you're using SQLite (the default) it isn't great at handling crashes or power failures... you can easily get a corrupted DB file.
You have to manually remove the .db files then restart FS. It recreates the DB for you, but you still have to remove it yourself.
If you instead use an ODBC database (postgresql/mysql/etc) then generally they can recover from power failures much better. If configured correctly anyway.
-Steve
On 1 September 2013 18:10, Blake Priddy <bpriddy@bryantschools.org> wrote:
How does one do this magic? Lol On Sep 1, 2013 12:09 PM, "François" <fdelawarde@wirelessmundi.com> wrote:
** 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!
François.
On Sun, 2013-09-01 at 11:47 -0500, Blake Priddy wrote:
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
2013-09-01 11:45:38.234642 [ERR] switch_core_sqldb.c:581 NATIVE SQL ERR [database is locked]
update sip_subscriptions set version=version+1 where ((expires > 0 and expires <= 1378053639)) and profile_name='internal' and hostname='voice'
2013-09-01 11:45:38.234642 [ERR] switch_core_sqldb.c:581 NATIVE SQL ERR [database disk image is malformed]
delete from sip_subscriptions where ((expires > 0 and expires <= 1378053639)) and profile_name='internal' and hostname='voice'
--
*Blakelund Priddy*
Network & Systems Engineer Bryant Public School District Bryant, Arkansas 72022 http://www.bryantschools.org
p 501-653-5038 f 501-847-5656
_________________________________________________________________________ Professional FreeSWITCH Consulting Services:consulting@freeswitch.orghttp://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Serverhttp://www.cudatel.com
Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://wiki.freeswitch.orghttp://www.cluecon.com
FreeSWITCH-users mailing listFreeSWITCH-users@lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.frees...
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
-- Anthony Minessale II FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire AIM: anthm MSN:anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900