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@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@xwin32.com> wrote:
I'll try again:
root@pbx:/var/lib/freeswitch/db# service freeswitch stop
root@pbx:/var/lib/freeswitch/db# rm call_limit.db core.db directory.db fifo.db share_presence.db sofia_reg_*.db
root@pbx:/var/lib/freeswitch/db# ls -l
total 48
-rw-r--r-- 1 freeswitch freeswitch 49152 May 12 16:03 voicemail_default.db
root@pbx:/var/lib/freeswitch/db# service freeswitch start
root@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@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@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@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@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@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org