[Freeswitch-users] database disk image is malformed

[Steven Ayre]

Have you told it to use pgsql for everything? There are several places to
put the DSN, core-dsn in switch.conf.xml and odbc-dsn in sofia.conf.xml for
example. I believe it'll only create the sqlite files if it is going to be
using them.

On 20 May 2016 at 06:17, Nick 'tarantul' Novikov <tarantul at gmail.com> wrote:

> Sometime I reckon with this bug. FS restart fails and I need to remove all
> file in db directory. Is it possible to disable usage sqlite db files
> because I have configured pgsql storage?
>
> On Fri, May 13, 2016 at 7:49 PM, Steven Schoch <
> schoch+freeswitch.org at xwin32.com> wrote:
>
>> I'll try again:
>> root at pbx:/var/lib/freeswitch/db# service freeswitch stop
>> root at pbx:/var/lib/freeswitch/db# rm call_limit.db core.db directory.db
>> fifo.db share_presence.db sofia_reg_*.db
>> root at pbx:/var/lib/freeswitch/db# ls -l
>> total 48
>> -rw-r--r-- 1 freeswitch freeswitch 49152 May 12 16:03 voicemail_default.db
>> root at pbx:/var/lib/freeswitch/db# service freeswitch start
>> root at pbx:/var/lib/freeswitch/db# ls -l
>> total 564
>> -rw-r----- 1 freeswitch freeswitch  14336 May 13 09:39 call_limit.db
>> -rw-r----- 1 freeswitch freeswitch 204800 May 13 09:39 core.db
>> -rw-r----- 1 freeswitch freeswitch   2048 May 13 09:39 directory.db
>> -rw-r----- 1 freeswitch freeswitch   5120 May 13 09:39 fifo.db
>> -rw-r----- 1 freeswitch freeswitch  95232 May 13 09:39 share_presence.db
>> -rw-r----- 1 freeswitch freeswitch  95232 May 13 09:39
>> sofia_reg_external.db
>> -rw-r----- 1 freeswitch freeswitch  95232 May 13 09:39 sofia_reg_lan.db
>> -rw-r--r-- 1 freeswitch freeswitch  49152 May 12 16:03
>> voicemail_default.db
>>
>> Hey! It worked! the DB error isn't there anymore!
>>
>> Now I can work on the next problem, which is that incoming calls are
>> immediately rejected. That's just me digging through the logs, reading the
>> documentation, and seeing what I messed up when I moved them to the new
>> system.
>>
>> --
>> Steve
>>
>> On Fri, May 13, 2016 at 9:29 AM, Ken Rice <krice at freeswitch.org> wrote:
>>
>>> Make sure the filesystem perms are correct for the user that freeswitch
>>> is running as.
>>>
>>>
>>>
>>> It is safe to stop FreeSWITCH, remove the files, and allow FreeSWITCH to
>>> recreate them with the correct permissions. The only file that needs to
>>> hang around across reboots is the voicemail one which contains the metadata
>>> for any voicemails that are still on the system. If you are not using
>>> mod_voicemail on a particular FreeSWITCH install, it is also safe to delete.
>>>
>>>
>>>
>> _________________________________________________________________________
>> Professional FreeSWITCH Consulting Services:
>> consulting at freeswitch.org
>> http://www.freeswitchsolutions.com
>>
>> Official FreeSWITCH Sites
>> http://www.freeswitch.org
>> http://confluence.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
>>
>
>
>
> --
> tarantul
> Dios es Amor
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://confluence.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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20160520/5303bd51/attachment-0001.html