View Single Post
Old 09-08-2012, 04:15 PM   #1
ICDeadPpl
Junior Member
ICDeadPpl began at the beginning.
 
Posts: 3
Karma: 10
Join Date: Mar 2010
Location: Sweden
Device: BeBook One
Question Library on Cifs share, DB on local disk?

I have a NAS with a cifs share, where I'd like to store the library (96 GB).
On my local computer I have an 128 GB SSD, which is why I don't want to store the libtrary on my local machine.
I read that you can have the DB location overridden, so I tried that.
I tried to override the DB location with this (Ubuntu 12.04):
Code:
Exec=env CALIBRE_OVERRIDE_DATABASE_PATH=/home/jan/Calibre calibre
Yet, when I start Calibre it throws an error:

Code:
Traceback (most recent call last):
  File "/usr/lib/calibre/calibre/library/restore.py", line 131, in load_preferences
    progress_callback=self.progress_callback)
  File "/usr/lib/calibre/calibre/library/database2.py", line 198, in __init__
    self.connect()
  File "/usr/lib/calibre/calibre/library/database2.py", line 146, in connect
    self.conn = connect(self.dbpath, self.row_factory)
  File "/usr/lib/calibre/calibre/library/sqlite.py", line 366, in connect
    raise DatabaseException(*conn.proxy.unhandled_error)
DatabaseException: unable to open database file
	RemoteTraceback (most recent call last):
	  File "/usr/lib/calibre/calibre/library/sqlite.py", line 248, in run
	    self.connect()
	  File "/usr/lib/calibre/calibre/library/sqlite.py", line 225, in connect
	    detect_types=sqlite.PARSE_DECLTYPES|sqlite.PARSE_COLNAMES)
	OperationalError: unable to open database file
I also tried export CALIBRE_OVERRIDE_DATABASE_PATH=/home/jan/Calibre, but it just doesn't seem to "take" the env variable?

Or have I misunderstood the concept?
From the Calibre manual: CALIBRE_OVERRIDE_DATABASE_PATH - allows you to specify the full path to metadata.db. Using this variable you can have metadata.db be in a location other than the library folder. Useful if your library folder is on a networked drive that does not support file locking.

Wouldn't it be easier for everyone, if the setup wizard would let one (optionally) choose separate locations for the library and the database?
ICDeadPpl is offline   Reply With Quote