Set user limitations for Calibre Server

TestCase · 07-14-2019, 02:01 PM

Hi,

I'm trying to disable write/delete access for a user but I am failing. The following sequence is partly in Dutch but I assume that's no obstacle. 'BoekServer' is the username.

BoekServer has read-write access
1) Show password for BoekServer
2) Wijzig paswoord voor: BoekServer
3) Change read/write permission for BoekServer
4) Change the libraries BoekServer is allowed to access
5) Annuleren

Wat wil je doen? [1-5]: 3

Prevent BoekServer from making changes (i.e. remove write access)? [y/n]: y

BoekServer has read-write access
1) Show password for BoekServer
2) Wijzig paswoord voor: BoekServer
3) Change read/write permission for BoekServer
4) Change the libraries BoekServer is allowed to access
5) Annuleren

As can be seen the user still has read-write access.

Thanks & regards,
Kees.

kovidgoyal · 07-15-2019, 12:23 AM

strange, what version of calibre/operating system is this?

TestCase · 07-15-2019, 03:50 AM

It's 3.44 (x64) on Windows Server 2008.

Thanks.

TestCase · 07-15-2019, 04:18 AM

Just tried 3.45.2 but same issue.

kovidgoyal · 07-15-2019, 04:21 AM

Can you run the calibre GUI, you can do it from there and just copy over the users.db file to the actual server.

TestCase · 07-15-2019, 04:32 PM

Created a userdb.sqlite using the GUI (3.45.2) with the correct user. Cleared the write flag!
Copied it to C:\srv\Calibre and renamed to users.sqlite as it seems to have a different name in there?
Checked it using the CLI but it showed incorrect. (Didn't modify anything)
Started Calibe Server and checked the user which still has write access.

Alas

kovidgoyal · 07-15-2019, 09:59 PM

Are you sure you are using the right db from the command line? Use the --userdb command line argument to tell the server which db to use.

TestCase · 07-16-2019, 04:59 PM

Indeed, it seemed I was using the wrong database in the last step. I copied the userdb (userdb.sqlite) from the Program Files\Calibre2 directory which seems to be an old database which is not modified by the current GUI?

When using the GUI everything is ok now for the time being.
The remaining issue now is I cannot use the CLI to start Calibre Server as I cannot locate the correct userdb which is being updated/used by the GUI. Where do you 'hide' this userdb?

(This is beside the fact that the CLI is still failing when modifyjng the userdb)

kovidgoyal · 07-16-2019, 09:01 PM

The file in the program directory is never modified. Programs should never modify their own files. Customized versions are stored int he calibre config directory, which you can find vi Preferences->Miscellaneous I dont recally if it i in a sub-directory, do asearch to find it.

07-14-2019, 02:01 PM	#1
TestCase Junior Member Posts: 6 Karma: 10 Join Date: Jul 2019 Device: Kobo	Set user limitations for Calibre Server Hi, I'm trying to disable write/delete access for a user but I am failing. The following sequence is partly in Dutch but I assume that's no obstacle. 'BoekServer' is the username. BoekServer has read-write access 1) Show password for BoekServer 2) Wijzig paswoord voor: BoekServer 3) Change read/write permission for BoekServer 4) Change the libraries BoekServer is allowed to access 5) Annuleren Wat wil je doen? [1-5]: 3 Prevent BoekServer from making changes (i.e. remove write access)? [y/n]: y BoekServer has read-write access 1) Show password for BoekServer 2) Wijzig paswoord voor: BoekServer 3) Change read/write permission for BoekServer 4) Change the libraries BoekServer is allowed to access 5) Annuleren As can be seen the user still has read-write access. Thanks & regards, Kees.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calibre Server initialize user(s)	stokstral	Server	4	08-28-2018 04:28 PM
Trying to set up a calibre server online	Teeg	Calibre	1	05-03-2018 10:17 PM
Is there a way to set Calibre Content Server to save with series info?	LadyKate	Related Tools	7	05-22-2015 03:20 AM
calibre-server set up	Aries84	Related Tools	1	04-30-2014 02:01 AM
Linux calibre-server: How to set username/password?	qupfer	Calibre	0	12-08-2011 04:54 PM

07-15-2019, 12:23 AM	#2
kovidgoyal creator of calibre Posts: 43,843 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	strange, what version of calibre/operating system is this?

07-15-2019, 03:50 AM	#3
TestCase Junior Member Posts: 6 Karma: 10 Join Date: Jul 2019 Device: Kobo	It's 3.44 (x64) on Windows Server 2008. Thanks.

07-15-2019, 04:18 AM	#4
TestCase Junior Member Posts: 6 Karma: 10 Join Date: Jul 2019 Device: Kobo	Just tried 3.45.2 but same issue.

07-15-2019, 04:21 AM	#5
kovidgoyal creator of calibre Posts: 43,843 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Can you run the calibre GUI, you can do it from there and just copy over the users.db file to the actual server.

07-15-2019, 04:32 PM	#6
TestCase Junior Member Posts: 6 Karma: 10 Join Date: Jul 2019 Device: Kobo	Created a userdb.sqlite using the GUI (3.45.2) with the correct user. Cleared the write flag! Copied it to C:\srv\Calibre and renamed to users.sqlite as it seems to have a different name in there? Checked it using the CLI but it showed incorrect. (Didn't modify anything) Started Calibe Server and checked the user which still has write access. Alas

07-15-2019, 09:59 PM	#7
kovidgoyal creator of calibre Posts: 43,843 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Are you sure you are using the right db from the command line? Use the --userdb command line argument to tell the server which db to use.

07-16-2019, 04:59 PM	#8
TestCase Junior Member Posts: 6 Karma: 10 Join Date: Jul 2019 Device: Kobo	Indeed, it seemed I was using the wrong database in the last step. I copied the userdb (userdb.sqlite) from the Program Files\Calibre2 directory which seems to be an old database which is not modified by the current GUI? When using the GUI everything is ok now for the time being. The remaining issue now is I cannot use the CLI to start Calibre Server as I cannot locate the correct userdb which is being updated/used by the GUI. Where do you 'hide' this userdb? (This is beside the fact that the CLI is still failing when modifyjng the userdb)

07-16-2019, 09:01 PM	#9
kovidgoyal creator of calibre Posts: 43,843 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	The file in the program directory is never modified. Programs should never modify their own files. Customized versions are stored int he calibre config directory, which you can find vi Preferences->Miscellaneous I dont recally if it i in a sub-directory, do asearch to find it.

Advert

Advert