Page 1 of 1

[trunk] History DB

Posted: February 24th, 2009, 10:35 am
by markus101
Running SABnzbd on Slackware 12.1, booting from a USB drive. SAB is on the flash drive and all was fine when I was running 0.4.6, but since the Trunk version uses SQLite3 as a DB for history it now uses my flash drive to store the History file in an admin folder under the root of the SAB directory. Is it possible to have this file moved? I have my log files writing to a data dik, but for organizations sake I would prefer to leave the SAB "install" in its current place and juts move the DB file.

I didn't see an option in the config, but maybe I'm missing something.

-Markus

Re: [trunk] History DB

Posted: February 24th, 2009, 11:00 am
by switch
I fail to see why it was fine before, and why it isnt fine now.
Before your history was stored relational to your sabnzbd.ini in the cache folder:

Code: Select all

~/.sabnzbd/sabnzbd.ini
~/.sabnzbd/cache/queue7.sab
Now it is stored in an admin folder relational to your sabnzbd.ini

Code: Select all

~/.sabnzbd/sabnzbd.ini
~/.sabnzbd/admin/history1.db
Where are you wanting to move it to? The program folder? All settings should be stored in the users home folder and never written to the program folder.

Re: [trunk] History DB

Posted: February 24th, 2009, 11:44 am
by markus101
Not the case for me? Previously my queue7.sab file was stored in the cache dir, which could be controlled via the web interface/config file and wasn't place relevant to the sabnzbd.ini file (unless the settings were left at default).

I've got it sorted now. The option to control the admin directory is able to be set in the sabnzbd.ini file, which I overlooked, but there is no option via the web interface. By default the file is is relative to the sabnzbd.ini file which would create the admin folder and then create the history1.db database file.

Changing the following line allows you to control it (which makes sense).

Code: Select all

admin_dir = admin
to (in my case):

Code: Select all

admin_dir = /mnt/staging/SABnzbd/admin
Might be worthwhile to add it to the Folder Configuration, although unless you're doing something special the default location should be fine. Thanks for the info though, it led me to the right solution.

-Markus

Re: [trunk] History DB

Posted: February 24th, 2009, 2:35 pm
by shypike
We're looking at concentrating the admin folders in one master-folder,
containing sub-folders admin, logs, cache, nzbbackup.

The other folders will obviously be separately settable.