Ubuntu Server

[Karlieth]

Hey, I have an Ubuntu server setup (headless) and am unable to set a library path every time i try it returns
xvfb-run calibredb add /mnt/sdc/toadd/* --library-path /mnt/sdc/Edutational/*
Traceback (most recent call last):
File "site.py", line 66, in main
File "site-packages/calibre/library/cli.py", line 1604, in main
File "site-packages/calibre/library/cli.py", line 437, in command_add
File "site-packages/calibre/library/cli.py", line 68, in get_db
File "site-packages/calibre/db/legacy.py", line 73, in __init__
File "site-packages/calibre/db/legacy.py", line 46, in create_backend
File "site-packages/calibre/db/backend.py", line 355, in __init__
File "site-packages/calibre/db/backend.py", line 1080, in fget
File "site-packages/calibre/db/backend.py", line 798, in conn
File "site-packages/calibre/db/backend.py", line 250, in __init__
CantOpenError: CantOpenError: unable to open database file

i have removed a metadata.db file that was created in my home directory, I realize this would be simpler if i installed a GUI but that kind of defeats the purpose of the server

[theducks]

is that a typo in the path to library or a non-english name?

[Karlieth]

Originally Posted by theducks

is that a typo in the path to library or a non-english name?

the edutational? i got bored to be completely honest and threw 2 words together

[PeterT]

I tried this and it created the database for me

mkdir MyBooks
calibredb restore_database --really-do-it --library-path /home/petert/MyBooks

I was then able to add books to it

calibredb add Downloads/* --library-path /home/petert/MyBooks/

At no time did I launch the GUI

[theducks]

Originally Posted by Karlieth

the edutational? i got bored to be completely honest and threw 2 words together

I make pesky typos all the time. A second set of eyes (and a slap on the noggin) gets things back on track.

don't use the CLI much,

Give Peter T's post a gander

[kovidgoyal]

That indicates sqlite is unable to open/create the db file. First stop using xvfb-run, it is not needed. Then stop using * in your command lines. Finally, make sure you are creating your library on a "native" filesystem, not a network filesystem, not ntfs, not fat32 not hfs etc. Linux is full of poorly implemented filesystem drivers.

[Karlieth]

Originally Posted by kovidgoyal

That indicates sqlite is unable to open/create the db file. First stop using xvfb-run, it is not needed. Then stop using * in your command lines. Finally, make sure you are creating your library on a "native" filesystem, not a network filesystem, not ntfs, not fat32 not hfs etc. Linux is full of poorly implemented filesystem drivers.

all drives connected to calibre are native internal drives i have allocated my smallest hdd (500gb) to books which is SDC the network drive i do have i made a special directory for so i could hook up the server with plex and all my media but currently it is not mounted and peterT thank you

[eschwartz]

Originally Posted by kovidgoyal

That indicates sqlite is unable to open/create the db file. First stop using xvfb-run, it is not needed. Then stop using * in your command lines. Finally, make sure you are creating your library on a "native" filesystem, not a network filesystem, not ntfs, not fat32 not hfs etc. Linux is full of poorly implemented filesystem drivers.

Never had a problem with fat32 drives
Obviously networked filesystems are asking for trouble, and using NTFS on linux is just silly...


@PeterT, when I try running `calibredb add /tmp/random-file.txt --with-library /tmp/test-library` it creates a library and adds the file.

@OP -- did you get it to work?

[theducks]

Half my boxes are dual boot, so I run NTFS and EXT3
Linux (the OS and user file system) is EXT3, with the windows partitions (NTFS) mounted. I mostly READ from those, but I have not had problems <Knock, Knock> If I do write.