COPS : Calibre OPDS PHP Server

[mariosipad]

to speed up cops:
1 - faster computer with faster HDD for libraries
2 - newer version of PHP (7.3 should be faster than 5.5)
3 - split your big library in smaller libraries (works for me)
4 - cache the thumbnails on the server side: use setting

    /*
     * Directory to keep resized thumbnails: allow to resize thumbnails only on first access, then use this cache.
     * $config['cops_thumbnail_handling'] must be ""
     * "" : don't cache thumbnail
     * "/tmp/cache/" (example) : will generate thumbnails in /tmp/cache/
     * BEWARE : it has to end with a /
     */
    $config['cops_thumbnail_cache_directory'] = "/path/to/cache/";

On what hardware, OS (Windows/linux) and software (webserver/php) are you running COPS?

[AquaWide]

Merci pour la réponse,
1 - Site sur SSD raid1, librairie sur HDD Raid6
2 - PHP 5.6.35, je vais upgrade ce week-end
3 - Noté, si les autres options non pas d'effet je splitterais la base
4 - activé, un léger mieux

Dell T440 (xeon 4110 single / Perc H730P) - Fibre 2gb / windows 2016 /

Merci pour les infos, je vais tester ces solutions.
______________________________________________
Google Trad :

Thank you for the answer,
1 - Site on SSD raid1, library on HDD Raid6
2 - PHP 5.6.35, I will upgrade this weekend
3 - Noted, if the other options have no effect I would split the base
4 - activated, a little better

Dell T440 (xeon 4110 single / Perc H730P) - Fiber 2 GB / Windows 2016 /

Thanks for the info, I'll test these solutions.

[mariosipad]

Exactly what pages take a long time to display?
Is the database slow or are pages with images slow?

What web server do you use (apache, nginx, other)?

[AquaWide]

Salut
Page d'accueil -> 51 secondes (la moitié après authentification)
Page ajouts récents -> 27 secondes

J'ai fait ces mises à jours :
Cops : 1.1.3
Apache 2.4.33
PHP 7.2.4
WampServer 3.2.3
Calibre 4.23.0

Merci
______________________________________
Translate :

Hello
Home page -> 51 seconds (half after authentication)
Recent additions page -> 27 seconds

I made these updates:
Cops: 1.1.3
Apache 2.4.33
PHP 7.2.4
WampServer 3.2.3
Caliber 4.23.0

Thank you

[mariosipad]

Salut

Your speeds resemble the speed of my old and slow Synology DS-110J.
Bud even then the COPS home page is show fater (if the HDD is spun up, if not then 30 sec+ is to be expected.

I tested with a COPS database containing about 20.000 titles.
I accessed COPS over LAN (gigabit) with Firefox in Private mode.

On slow hardware the "recent additions" page takes forever to show all the thumbnail images. If cached it takes way less time.

On faster hardware (Intel Pentium G2120 + SSD for the OS) running Debian 9 (Linux) and Apache 2.4 and PHP 7 the home page is shown almost immediately (1-2 secs). The "recent additions" page takes a few seconds to display and some more time before all images are loaded (titles to display is set to 1000).

On a WAMP like installation (UWAMP) on Windows 7 (32 bits) on a 10 year old AMD dual core COPS is significantly slower than with Debian.

I think for you the WAMP-server is the limiting factor.
Try to speed up WAMP server (maybe remove the cgi_module) or search on the internet for a solution that works for you.

Or is your LAN slow?
Also check if your server CPU is at 100% (on all cores) while it is busy displaying the "recent additions" page.

Hope this helps.

[AquaWide]

Bonjour,

Effectivement le problème vient surement de Wamp, je vais chercher de ce coté. ou le remplacer.

Le cache peut etre une piste, une fois la page chargé, elle met moins de 2 secondes pour s'ouvrir à nouveau à partir d'un autre navigateur, peut etre une expiration du cache trop rapide.

Le cpu est très peu utilisé pendant le chargement, Lan gigabit, et Wan 2 gigabits. (2x 120mo/s réèl)

Merci pour la réponse, je regarde tout ça et je ferais un retour si je trouve la cause

_____________________________
Translate

Hello,

Indeed the problem probably comes from Wamp, I will look on this side. or replace it.

The cache can be a track, once the page is loaded it takes less than 2 seconds to reopen from another browser, maybe the cache expires too fast.

The cpu is used very little while charging, Lan gigabit, and Wan 2 gigabit. (2x 120mo / s real)

Thanks for the reply, I am looking at all of this and would make a comeback if I find the cause

[mariosipad]

Today I installed Calibre 5 (latest and greatest), made new library to test and COPS still works

I'm happy

[dlw]

I need some help with this wonderful software. I have a brand new installation of Rasbian Buster, php 7.3, nginx, and COPS1.2.0 on an rPi zero W. After a few false starts (my first time with nginx, php, and COPS), everything works -- except that I cannot for the life of me display custom columns.

I have three Calibre libraries (Fiction, NonFiction, and Graphics) to split the load across cloud servers. I have no problem defining and using all three of them with COPS, but to keep things simple, I'm only trying custom columns on one -- until it works. I have two "custom" columns in Calibre in all the libraries: DD and DDC. The first I use constantly in the Fiction library to track categories such as "FIC", "MYS", "SF" and so forth. The DDC column comes into its own in the NonFiction library, where it contains an approximation of the Dewey Decimal number assigned to the ebook. These are not composite columns (though I do use them to create the file name for use in Calibre's "save to disk" routine).
No matter what I try, I can't seem to get the columns to show up in COPS. The code I'm using is:

$config['calibre_directory'] = "/home/pi/ebooks/Fiction/"; /* one library for testing */
$config['cops_calibre_custom_column'] = array("DD", "DDC"); /* has no effect */
$config['cops_calibre_custom_column_list'] = array("DD", "DDC"); /* has no effect */
$config['cops_ignored_categories'] = array("publisher","language"); /* works */

Can you think of anything I could try? Or where in COPS code I could see where it's processing -- to see what it actually looks for and finds? (php's not that hard to hack into, is it?)

I did search the forum for people having the same sort of problem. The solutions I found don't seem to apply to me.

Thanks for thinking about this.

[mariosipad]

Did you check this: https://github.com/seblucas/cops/pull/269 ?

The main thing is that custom column are not supported!
(and if I remember well, those were the only ones I would like to implement, so I never really tried to work with custom columns.)

If this does not work, I will try (maybe tomorrow) if I can make custom columns work once again.

Edit:

maybe: $config['cops_calibre_custom_column'] = array("DD", "DDC");
(note the space between "DD", and "DOC" )

[dlw]

Wow, that was a fast response. No I haven't. I will in the morning (my time, of course), so it may take me a bit to work through the thorough comments you've put out. A brief scan makes me thing you've covered everything I need -- I just need to learn how to use it. Thank you, and I'll be back.

[dlw]

ps .. the space was / is there.

[mariosipad]

Ok, I made it work for me.

In calibre 5.01 I added e few custom columns to a new testdatabase.

When I tried to use a custom column "Lookup name" with "UPPER CASE" letters it would not work. Only "lower case" letters, "digits" and "underscores" are permitted.

Maybe if you change (in calibre) upper case to lower case it will work with COPS?

[dlw]

Well (blush), it turned out to be pilot error. I was using the "Column header" rather than the "Lookup name". Once I got that right and removed the space after the comma(s), then everything just . . . works.

Thank you for providing the great documentation that got me to thinking instead of just reacting. And thanks for your remote troubleshooting.

Incidentally, to add to your list of ebook readers, tiReader is the first iOS (iPadOS I should say) app I've found that can handle epubs, PDFs, and cbr/cbzs as well as let me define an OPDS catalog. Unfortunately, it only displays a limited selection of the fields available to it and I see no way to change that

Thanks once again for turning this into a simple problem with a simple fix.

[mariosipad]

With Marvin3 (try for free) I can see the custom columns in the OPDS feed.

TiReader seems nice, I might try it out.

Once upon a time there were a lot of (epub)reader apps for iOS/iPadOS in development.
But lately I see less and less development of new(er) apps.

[dKodiak]

My cops is not working when it had been working last week with changes only in Calibre Library

You've been redirected because COPS is not configured properly
Database error
Check if PHP version is correct
OK (5.3.29)
Check if GD is properly installed and loaded
OK
Check if Sqlite is properly installed and loaded
OK
Check if libxml is properly installed and loaded
OK
Check if Json is properly installed and loaded
OK
Check if mbstring is properly installed and loaded
OK
Check if intl is properly installed and loaded
Please install the php5-intl / php7.0-intl extension and make sure it's enabled
Check if Normalizer class is properly installed and loaded
Please make sure intl is enabled in your php.ini
Check if the rendering will be done on client side or server side
Client side rendering
Check if Calibre database path is not an URL
OK
Check if Calibre database file exists and is readable
OK
Check if Calibre database file can be opened with PHP
OK
Check if Calibre database file contains at least some of the needed tables

is what I get