Library on Cifs share, DB on local disk?

[ICDeadPpl]

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):

Exec=env CALIBRE_OVERRIDE_DATABASE_PATH=/home/jan/Calibre calibre

Yet, when I start Calibre it throws an error:

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?

[kovidgoyal]

Your env var has to have the full path to the metadata.db file not its containing folder.

[ICDeadPpl]

Well, of course it's something too simple!
Thanks for the speedy reply!

[Adoby]

I have a similar setup, only I mount my NAS using nfs. Ubuntu 12.04. And like you I have my metadata.db on a SSD.

But I symlink instead. That way I can have more than one Calibre library.

https://www.mobileread.com/forums/sho...d.php?t=189714