COPS : Calibre OPDS PHP Server

[darkmiss]

I am using Firefox.

I go to the Index.php

I get the COPS startscreen

I can go to the next Level, e.g Authors

I get the alphabetical list

I can choose a letter, I can choose an author and I can choose a book.

I can see the books metadata but when I click on the "epub"-Button I reach a page with the Owncloud-Logo on top with the message "access forbidden".

Maybe I need to do something with htaccess?

[vlad59]

Originally Posted by darkmiss

...

I can see the books metadata but when I click on the "epub"-Button I reach a page with the Owncloud-Logo on top with the message "access forbidden".

Maybe I need to do something with htaccess?

There is something wrong with your Calibre database. Can you send me your metadata.db by mail (you'll find it in the bottom of the README file of COPS).

[darkmiss]

Thanks for the hint, Vlad. The whole Calibre program was corrupt, I have reinstalled it completely and I am uploading everything afresh to the server, program, ebooks and all. This is going to take a while.

BTW: I use Calibre portable and have the program in the cloud directory as well, is anybody else doing this?

[cr45h]

So I'm trying to use custom columns in COPS. I changed the value of "cops_calibre_custom_column" in "config_default.php" and restarted COPS, but it makes no difference. Is there anything else I have to do to use custom columns? Any help would be appreciated!

[micheljo]

Hi,
Before, thanks for The COPS software.
I am using it in 4.0 issue since 2 months, but today, I want to install 5.0 issue.

On my synology DS212J, I unzip cops-0.5.0.zip in Web/Calibre directory.
Then, I put my "Calibre Librairy " in this directory, an I rename "Calibre Librairy " as Data.
I Open config_local.php
I change datas as follow:

<?php
if (!isset($config))
$config = array();

/*
* The directory containing calibre's metadata.db file, with sub-directories
* containing all the formats.
* BEWARE : it has to end with a /
*/
$config['calibre_directory'] = './Data/';

/*
* Catalog's title
*/
$config['cops_title_default'] = "les bouquins de micheljo";

/*
* use URL rewriting for downloading of ebook in HTML catalog
* See README for more information
* 1 : enable
* 0 : disable
*/
$config['cops_use_url_rewriting'] = "0";
?>

Then I test my connection as the same way of Issue 4.0
But now the hereafter message appears

Warning: require_once(/tbszip.php): failed to open stream: No such file or directory in /volume1/web/calibre/resources/php-epub-meta/epub.php on line 9 Fatal error: require_once(): Failed opening required '/tbszip.php' (include_path='.:/usr/syno/php/lib/php') in /volume1/web/calibre/resources/php-epub-meta/epub.php on line 9

So I open /calibre/resources/php-epub-meta/epub.php

I can see this
<?php
/**
* PHP EPub Meta library
*
* @author Andreas Gohr <andi@splitbrain.org>
* @author Sébastien Lucas <sebastien@slucas.fr>
*/

require_once(realpath( dirname( __FILE__ ) ) . '/tbszip.php');

define ("METADATA_FILE", "META-INF/container.xml");

<?php
/**
* PHP EPub Meta library
*
* @author Andreas Gohr <andi@splitbrain.org>
* @author Sébastien Lucas <sebastien@slucas.fr>
*/

require_once(realpath( dirname( __FILE__ ) ) . '/tbszip.php');

define ("METADATA_FILE", "META-INF/container.xml");

Where is my error?
Thanks for your help

Micheljo

[maxjens]

In cops 0.5.0 i found that if i made the covers bigger then 70, say 140, the first line with books is not resized making the whole page a bit out of sync. I used the html size. Is it possible to correct this problem?

[vlad59]

@all

Sorry for being slow to answer, I've got lot's of things going on but next release is coming before the end of july .

@cr45h

For now only some type of custom columns are handled. You can see in Config_default.php :

Note that for now only the first, second and forth type of custom columns are supported

@micheljo

Indeed I made some big changes in the way external resources are stored. Did you start with an empty directory ?

Thanks for your answer.

@maxjens

Yes I already fixed that in github. It'll also allow better quality covers with Retina / Nexus 10 devices.

[Pope Viper]

Hello gents -

Going crazy here.

I'm running IIS 7.5 and PHP 5.4, and I'm having a bear of time. Finally got things recognized, but I'm getting this error:


Check if Calibre database file contains at least some of the needed tables
Not all Calibre tables were found. Are you you're using the correct database.


This is the same database as I'm using for my calibre set up.

Thanks for any insight.

[micheljo]

Originally Posted by vlad59

@micheljo

Indeed I made some big changes in the way external resources are stored. Did you start with an empty directory ?

Thanks for your answer.

Thanks for your response
Finally, COPS 5.0 works
During data synchronization with Calibre directory, the metadata.db was corrupted, Calibre/metadata.db also.
Now, I rebuild my Calibre library book by book, and each day I save it in my COPS directory.
It's a very long way, but I can control books metadata , and add missing.
Synchronization between computer and Nas is not a good idea for Calibre and Cops, now, i use SyncBack with only save configuration to copy data in Calibre library and paste it in Cops data library.
I have tested also CloudStation, but when I added a lot of books in Calibre, it's metadata.db file changed, and failures appeared.
In COPS, I want to add custom columns like "A_Lire_Michel" feed by the same custom columns in Calibre.
Is it easy?
Best regards
Micheljo
PS: as a lot of French people, my English is not perfect, sorry!

[vlad59]

Originally Posted by Pope Viper

Hello gents -

Going crazy here.

I'm running IIS 7.5 and PHP 5.4, and I'm having a bear of time. Finally got things recognized, but I'm getting this error:


Check if Calibre database file contains at least some of the needed tables
Not all Calibre tables were found. Are you you're using the correct database.


This is the same database as I'm using for my calibre set up.

Thanks for any insight.

Hi,

I think COPS try to access the wrong database. Have you correctly configured config_local.php with $config['calibre_directory'] ?

I'm guessing COPS has created an empty database somewhere and try to use it. This happen when your calibre directory is wrong.

[vlad59]

Originally Posted by micheljo

Thanks for your response
Finally, COPS 5.0 works
During data synchronization with Calibre directory, the metadata.db was corrupted, Calibre/metadata.db also.
Now, I rebuild my Calibre library book by book, and each day I save it in my COPS directory.
It's a very long way, but I can control books metadata , and add missing.
Synchronization between computer and Nas is not a good idea for Calibre and Cops, now, i use SyncBack with only save configuration to copy data in Calibre library and paste it in Cops data library.
I have tested also CloudStation, but when I added a lot of books in Calibre, it's metadata.db file changed, and failures appeared.

Corruption usually appear when you try to update the same database with two Calibre or Cloudstation try to update the metadata.db and Calibre is started.

My Calibre directory is not synchronized automatically, I start it manually when I update it.

Originally Posted by micheljo

In COPS, I want to add custom columns like "A_Lire_Michel" feed by the same custom columns in Calibre.
Is it easy?

So far only some type of custom columns are handled but it should work.

Originally Posted by micheljo

PS: as a lot of French people, my English is not perfect, sorry!

I'm french so I know .

[Pope Viper]

Originally Posted by vlad59

Hi,

I think COPS try to access the wrong database. Have you correctly configured config_local.php with $config['calibre_directory'] ?

I'm guessing COPS has created an empty database somewhere and try to use it. This happen when your calibre directory is wrong.

I'm pretty sure I have it pointed correctly, I've

My library is at D:\Websites\Name\Library\Calibre

Config attached.

Also, when I try to browse the page, I get the following error:
This XML file does not appear to have any style information associated it with it. The document tree is shown below.

It then indicates a server error.

[mariosipad]

    $config['calibre_directory'] = 'D:\Websites\Name\Library\calibre';

should be:

    $config['calibre_directory'] = 'D:\Websites\Name\Library\calibre\';

with a '\' at the end.

If tis does not work try

    $config['calibre_directory'] = "D:/Websites/Name/Library/calibre/";

[Pope Viper]

Son of a gun, that did it. Option 2 did the trick.

Stupid Windows.

Thank you so much, I'm loving this server. Much faster than the one I had.

[Pope Viper]

Vlad -

Now that I've finally got it running (Thanks again, mariosipad!!!!), on the "Show All Books", rather than displaying all the books by letter, is there a way to pull back ALL the books (without being broken out), and provide pagination for the results?


I also saw this:

Entry indicates there are no book formats available, but when you click on the book, there is a format.

Not sure if this is Calibre or COPS.