COPS : Calibre OPDS PHP Server

[Crashogre]

Does anyone know what controls the sort of the opds page displayed by feed.php? I can see where to put exclusions but I would l8ke to change the order to closer to the frequency of use, i.e. latest additions, Author, Series, Tags, etc.

[Trevor68]

Hi, I have setup a Truenas Scale Server at home and would like to use it as my calibre storage, rather than the existing external usb drive plugged into my NUC.

Currently working config is thus. config['calibre_directory'] = 'F:/Calibre Library/';

I have created a SMB share, copied all the files over, and mapped it as Z on the NUC, which can happily access and read the files, but COPS fails to find the db. Perhaps this is a permissions problem? should I not have used a SMB share?

the true path is \\TRUENAS\Calibre for the SMB share, but nothing I put in COPS seems to work.

[mariosipad]

@Trevor68

Tried a samba share on Linux to Linux (Debian to Debian) and it worked.

Then tried a samba share from Windows 7 to Linux (Debian) and it worked.
What I did on Windows 7:

net use Z: \\<IP)\share_name /PERSISTENT:YES
Entered username and password

Check that I can access Z:/Calibre_Library

In (COPS) config_local.php
config['calibre_directory'] = 'Z:/Calibre Library/';

And it worked.

[Trevor68]

I did a bit of reading and apparently sharing windows network shares with apache can be problematic, so I have reverted to the simpler solution, a 64Gig USB stick in the NUC. :-)

[Grishka]

Hey !

I'm using a different solution with a Synology NAS :
- The Calibre library is in my computer
- I use Synology Drive to sync the library's folder to the NAS (one-way synchronization PC > NAS).
- Calibre use the NAS folder.

So there is 2 copy of the library, the second one is always in sync with the latest change on the main one. It works and avoids all the hassle of network sharing. Maybe it can be done with a RSYNC sync ?

Anyway, I also share a tutorial (in french) to install COPS manually on a Synology NAS.

[PepaBrno]

https://www.mobileread.com/forums/sh...63#post4195963

[mariosipad]

On what Operating System (linux, debian, centos, NAS, Windows, etc.) are you running COPS?
Your problem is probably not a COPS problem, but a problem with the (outated) version of sqlite3 in your OS.

[PepaBrno]

Run in www hosting www.endora.cz

[mariosipad]

In your hosting admin setup can you choose the PHP version to use?

If you can, choose at least php 5.6 and preferably php 7.3 or 7.4, but NOT php 8(.0 or .1).

[PepaBrno]

I am PHP vesrsion 7.4

[mariosipad]

Put the following code in the webroot og the www server and name it info.php:

<?php
                                                                                                                                                                                                
// Show all information, defaults to INFO_ALL                                                                                                                                                      
phpinfo();                                                                                                                                                                                         
                                                                                                                                                                                                   
// Show just the module information.                                                                                                                                                               
// phpinfo(8) yields identical results.                                                                                                                                                            
// phpinfo(INFO_MODULES);                                                                                                                                                                          
                                                                                                                                                                                                   
?>

and check for the version of sqlite3.
http://<IP_or_url>/info.php

[PepaBrno]

I'll test, I'll try, I'll thank you and I'll let you know later

[PepaBrno]

Not function ....... http://www.kniha.tode.cz/

[PepaBrno]

I have the code there now, I'll leave it there with the original Calibre metadata.db file ,,,, I'll put a modified matadata.db file there on Saturday night. It will display without any problems without those two lines, thank you

[mariosipad]

@PepaBrno

Thank you.
I have identified your problem. Now please delete info.php from your server!

The version of sqlite3 that your hosting provider uses is to old to use with calibre 5.

Therefore if you remove the 2 tables from the database it works again (Calibre version 4 database format).

To have it work automatically use this fork of COPS:
https://github.com/jvanderzande/cops/commits/master
This might work, but your best bet is to do what you are already doing, stripping tables from the calibre database.
[I have been able to make it work on my hosting provider (where it already works), however even there the sqlite3 version is "wrong", and it took some fiddling with databases and code. It's just not worth it for me.]

PS:
as an added safety feature I would advise you to use password protection. Either through:
- your hosting provider, or
- editing .htaccess in the cops directory, or
- using the config_local.php of COPS