[Freeswitch-users] SO we lost power at the office and battery backups went out...

[Blake Priddy]

Ok I removed the files starting with sofia_ and Rebooted. Now when I place
a call out it shows not found on my phone. And in cli it shows unallocated
number.


On Sun, Sep 1, 2013 at 3:33 PM, Anthony Minessale <
anthony.minessale at gmail.com> wrote:

> 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 at 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 at bryantschools.org>wrote:
>>
>>> How does one do this magic? Lol
>>> On Sep 1, 2013 12:09 PM, "François" <fdelawarde at 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 at freeswitch.orghttp://www.freeswitchsolutions.com
>>>>
>>>> FreeSWITCH-powered IP PBX: The CudaTel Communication Server
>>>>
>>>> Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://wiki.freeswitch.orghttp://www.cluecon.com
>>>>
>>>> FreeSWITCH-users mailing listFreeSWITCH-users at lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.freeswitch.org
>>>>
>>>>
>>>>
>>>>
>>>> _________________________________________________________________________
>>>> Professional FreeSWITCH Consulting Services:
>>>> consulting at freeswitch.org
>>>> http://www.freeswitchsolutions.com
>>>>
>>>> 
>>>> 
>>>>
>>>> Official FreeSWITCH Sites
>>>> http://www.freeswitch.org
>>>> http://wiki.freeswitch.org
>>>> http://www.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
>>>> http://www.freeswitch.org
>>>>
>>>>
>>> _________________________________________________________________________
>>> Professional FreeSWITCH Consulting Services:
>>> consulting at freeswitch.org
>>> http://www.freeswitchsolutions.com
>>>
>>> 
>>> 
>>>
>>> Official FreeSWITCH Sites
>>> http://www.freeswitch.org
>>> http://wiki.freeswitch.org
>>> http://www.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
>>> http://www.freeswitch.org
>>>
>>>
>>
>> _________________________________________________________________________
>> Professional FreeSWITCH Consulting Services:
>> consulting at freeswitch.org
>> http://www.freeswitchsolutions.com
>>
>> 
>> 
>>
>> Official FreeSWITCH Sites
>> http://www.freeswitch.org
>> http://wiki.freeswitch.org
>> http://www.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
>> 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 at hotmail.com
> GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com
> IRC: irc.freenode.net #freeswitch
>
> FreeSWITCH Developer Conference
> sip:888 at conference.freeswitch.org
> googletalk:conf+888 at conference.freeswitch.org
> pstn:+19193869900
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.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
> http://www.freeswitch.org
>
>


-- 

*
*
*Blakelund Priddy*
Network & Systems Engineer
Bryant Public School District
Bryant, Arkansas 72022
http://www.bryantschools.org
p 501-653-5038
f 501-847-5656
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130903/f0c24c62/attachment-0001.html