This is not a finished solution, but just a first step! Calibre supports to create virtual libraries that contain only a subset of all books. I am interested and willing to add this feature to cops (see feature request #204). Since I am new to this project, I would like to get some feedback and see if someone else is already working on it. With this pull request, I want to start a dialog about how to add this feature.

My current thoughts that I put here for discussion:

• For the user, virtual libraries look like databases
• Internally, the $database parameter has to be modified to hold two values (database and virtual library). If just one parameter is used, the database id doesn't directly relate to one database file.
• To apply the filter of a virtual library, the filter has to be translated into SQL-Terms. To use this, the existing sql statements might have to be modified.

And if that works: allow to add virtual libraries into the database name. E.g. like this:

$config['calibre_directory'] = '/volume1/books/@Programming'

In combination with user-specific config-files, this would restrict certain users to certain libraries (e.g. kids to child books)

The current code only reads the virtual library names and shows them as independent databases. No filtering or adjusted counting is done, yet.

I'm getting this error on apache logs [Thu Jun 28 2018] [:error] [pid 3342] [client] PHP Warning: require_once(/var/www/html/sex.com/public_html/vendor/autoload.php): failed to open stream: No such file or directory in /var/www/html/sex.com/public_html/config.php on line 9

Hi. I'm trying to open some of the .epub files which are in my calibre library. When pressing the "eye" icon beside the .epub file instead of opening the book ready to read in the new tab (like it usually works) it opens new tab with next error:

Warning: fopen(/volume1/books/Alistier Krouli/Lunnoie ditia (979)/Lunnoie ditia - Alistier Krouli.epub): failed to open stream: Permission denied in /volume1/web/cops/resources/php-epub-meta/tbszip.php on line 53 Fatal error: Uncaught exception 'Exception' with message 'Failed to read epub file' in /volume1/web/cops/resources/php-epub-meta/epub.php:37 Stack trace: #0 /volume1/web/cops/epubreader.php(23): EPub->__construct('/volume1/books/...') #1 {main} thrown in /volume1/web/cops/resources/php-epub-meta/epub.php on line 37

This happens with some of my .epub files while other work as expected. Also it doesn't show the cover of these books (Although they persist in the file and show up in Calibre).

What is the reason of such a strange behavior?

hi just wondering it there chance you can integrate twitter bootstrap in to the script this would allow users to easily customise the theme also it has good support for mobile. http://twitter.github.io/bootstrap/

The current (december 22nd) github version of COPS is broken.

On a Debian Jessie server with Apache 2.4 and PHP 5.6 (latest versions from the repositories) COPS does not start / react:

• browser screen remains white
• Apache PHP error log: PHP Fatal error: require_once(): Failed opening required '/var/www/html/cops-dec/vendor/autoload.php' (include_path='.:/usr/share/php:/usr/share/pear') in /var/www/html/cops-dec/config.php on line 9 --> directory ./vendor does not exist
• removing the offending line in config.php leads to other errors, so that seems not to be a quick solution.

An older version of COPS (git cloned november 9th) works without any error message.

This is a working snapshot of a complete overhaul of the COPS codebase with your merges from today included.

Most packages are now external libs and pulled in by Composer (and its Autoloader). Scrutinizer checks code formatting (Symfony style). No more multiple classes in one PHP file. And some code fixes/cleanups (more to come).

No functional changes were made to the code.

Builds fine in my Travis and Scrutinizer.

After merging, you have to fix the links in the README to point to your badges again.

When installing the package on a Synology NAS with the Calibre db in a custom folder the installer correctly detects and updates the path in config_local.php, but ignores the default value for opne_basedir in /etc/php/conf.d/com.synocommunity.packages.cops.ini

The values in override the values in com.synocommunity.packages.cops.ini override the settings in "Control Panel -> Web Services -> Web Applications Customise PHP open_base_dir", so the procedure described in https://github.com/seblucas/cops/wiki/Howto---Synology doesn't fix the problem.

My suggestion id either to automatically set the open_base_dir in com.synocommunity.packages.cops.ini, or to update the How To and the message in checkconfig.php

Thanks a lot for this project!

I use COPS + Apache with my kobo e-reader without any problems.

I thought I'd try COPS on NGINX to see if it's any faster on my hardware. It works like a charm except with $config['cops_use_url_rewriting'] = '1'; And I added: location /download/ { rewrite ^/download/(\d+)/(\d+)/..(.)$ /fetch.php?data=$1&db=$2&type=$3 last; rewrite ^/download/(\d+)/..(.)$ /fetch.php?data=$1&type=$2 last; break; } to a working NGINX config file (and rebooting etc.) but I still get the 404 error.

What am I doing wrong? What do I have to add to COPS config files and or NGINX config files to make url_rewriting work?

Edit: NGINX version 1.6.2 PHP 5.6.30 OS Debian Jessie 8.8 on VirtualBox / WIndows 7 - 32 bits

Hello,

On my Unbuntu 16.04, I installed calibre, nginx, PHP and COPS to use calibre with COPS.

If I call http://mydomain.eu:55555, i would like to get my calibre-infos.

But I get errors:

• Check if PHP version is correct => OK (7.1.12-3+ubuntu16.04.1+deb.sury.org+1)
• Check if GD is properly installed and loaded => Please install the php5-gd extension and make sure it's enabled
• Check if Sqlite is properly installed and loaded => Please install the php5-sqlite extension and make sure it's enabled
• Check if intl is properly installed and loaded => Please install the php5-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 Calibre database file exists and is readable => File /home/ubuntu/disk1/Calbib1/metadata.db not found, Please check

I have tried to install several versions of PHP. Maybe there is a mess.

At the moment, i would prefer to get the whole thing running with PHP version 7.1.

1. How can I fix the errors?

• maybe installing the missing extensions
• i tried several methods. non was working.
• but maybe, the error is not the missing php5-gd but something different?

2. why is the system ist asking for php5, when the PHP-Version is 7.1.12? is this normal? is this "correct"?

with best regards, Irv

my system

• Ubuntu 16.04
• nginx 1.10.3
• COPS 1.1.1
• PHP 7.1, 7.0, 5.6
• calibre 3.14

my files (~/disk1/Calbib1)

ubuntu@ip-172-31-19-142:~/disk1/Calbib1$ ls -ld meta* -rwxrwxr-- 1 ubuntu ubuntu 64000000 Jan 1 18:43 metadata.db -rwxrwxr-- 1 ubuntu ubuntu 12948 Dec 31 09:18 metadata_db_prefs_backup.json

ubuntu@ip-172-31-19-142:~/disk1/Calbib1$ ls -ld Westall*// -rwxrwx--- 1 ubuntu ubuntu 557019 Dec 27 13:43 Westall, Robert/Funf Faden tief (5754)/cover.jpg -rwxrwx--- 1 ubuntu ubuntu 801446 Dec 27 13:43 Westall, Robert/Funf Faden tief (5754)/Funf Faden tief - Westall, Robert.epub -rwxrwx--- 1 ubuntu ubuntu 5414 Dec 27 13:43 Westall, Robert/Funf Faden tief (5754)/metadata.opf

ubuntu@ip-172-31-19-142:/etc/nginx/sites-available$ ls -ld * -rw-r--r-- 1 root root 587 Jan 4 06:01 cops -rw-r--r-- 1 root root 2080 Jan 4 05:47 default

ubuntu@ip-172-31-19-142:/etc/nginx/sites-enabled$ ls -ld * lrwxrwxrwx 1 root root 31 Jan 4 05:58 cops -> /etc/nginx/sites-available/cops

my nginx-file with name cops in /etc/nginx/sites-available

server {
        listen 55555;
        server_name <myip>:55555;
        root /var/www/cops;
        index index.php;

        fastcgi_pass_header Authorization;

        location / {
                try_files $uri $uri/ =404;
        }

        location ~ \.php$ {
            fastcgi_pass unix:/run/php/php7.1-fpm.sock;
            include snippets/fastcgi-php.conf;
            fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
        }

        location ~ /\.ht {
                deny all;
        }

        location /Calbib1 {
              root /home/ubuntu/disk1;
               internal;
        }
}

my config_local.php in /var/www/cops

<?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'] = '/home/ubuntu/disk1/Calbib1/';



   /*
     * The URL to the calibre internal directory you specified in your nginx site
     * config file.
     */
    $config['calibre_internal_directory'] = '/Calbib1/';



    /*
     * Catalog's title
     */
    $config['cops_title_default'] = "COPS";

    /*
     * 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";


     /*
     * Wich header to use when downloading books outside the web directory
     * Possible values are :
     *   X-Accel-Redirect   : For Nginx
     *   X-Sendfile         : For Lightttpd or Apache (with mod_xsendfile)
     *   No value (default) : Let PHP handle the download
     */
    $config['cops_x_accel_redirect'] = "X-Accel-Redirect";


    /*
     * URL to access the COPS page
     */
    $config['cops_full_url'] = '<mydomain>.eu:55555';

    /*
     * Default timezone
     * Check following link for other timezones :
     * http://www.php.net/manual/en/timezones.php
     */
    $config['default_timezone'] = "America/Denver";


    $config['cops_basic_authentication'] = array('username' => 'xxx', 'password' => 'xxx');
ubuntu@ip-172-31-19-142:~$

status nginx.service

ubuntu@ip-172-31-19-142:/etc/systemd/system/nginx.service.d$ sudo systemctl status nginx.service
? nginx.service - A high performance web server and a reverse proxy server
   Loaded: loaded (/lib/systemd/system/nginx.service; enabled; vendor preset: enabled)
  Drop-In: /etc/systemd/system/nginx.service.d
           +-override.conf
   Active: active (running) since Thu 2018-01-04 07:30:42 CET; 3min 34s ago
  Process: 1324 ExecStartPost=/bin/sleep 0.1 (code=exited, status=0/SUCCESS)
  Process: 1318 ExecStart=/usr/sbin/nginx -g daemon on; master_process on; (code=exited, status=0/SUCCESS)
  Process: 1296 ExecStartPre=/usr/sbin/nginx -t -q -g daemon on; master_process on; (code=exited, status=0/SUCCESS)
 Main PID: 1323 (nginx)
    Tasks: 2
   Memory: 7.3M
      CPU: 22ms
   CGroup: /system.slice/nginx.service
           +-1323 nginx: master process /usr/sbin/nginx -g daemon on; master_process on
           +-1326 nginx: worker process

Jan 04 07:30:41 ip-172-31-19-142 systemd[1]: Starting A high performance web server and a reverse proxy server...
Jan 04 07:30:42 ip-172-31-19-142 systemd[1]: Started A high performance web server and a reverse proxy server.
ubuntu@ip-172-31-19-142:/etc/systemd/system/nginx.service.d$

status PHP

ubuntu@ip-172-31-19-142:/etc/systemd/system/nginx.service.d$ sudo systemctl status php7.1-fpm.service
? php7.1-fpm.service - The PHP 7.1 FastCGI Process Manager
   Loaded: loaded (/lib/systemd/system/php7.1-fpm.service; enabled; vendor preset: enabled)
   Active: active (running) since Thu 2018-01-04 07:30:42 CET; 3min 11s ago
     Docs: man:php-fpm7.1(8)
 Main PID: 1298 (php-fpm7.1)
   Status: "Processes active: 0, idle: 2, Requests: 0, slow: 0, Traffic: 0req/sec"
    Tasks: 3
   Memory: 37.9M
      CPU: 45ms
   CGroup: /system.slice/php7.1-fpm.service
           +-1298 php-fpm: master process (/etc/php/7.1/fpm/php-fpm.conf)
           +-1330 php-fpm: pool www
           +-1331 php-fpm: pool www

Jan 04 07:30:41 ip-172-31-19-142 systemd[1]: Starting The PHP 7.1 FastCGI Process Manager...
Jan 04 07:30:42 ip-172-31-19-142 systemd[1]: Started The PHP 7.1 FastCGI Process Manager.
ubuntu@ip-172-31-19-142:/etc/systemd/system/nginx.service.d$

netstat

ubuntu@ip-172-31-19-142:~$ sudo netstat -ntlp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 0.0.0.0:8080            0.0.0.0:*               LISTEN      1291/calibre-server
tcp        0      0 127.0.0.1:3350          0.0.0.0:*               LISTEN      1460/xrdp-sesman
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      1337/sshd
tcp        0      0 0.0.0.0:3389            0.0.0.0:*               LISTEN      1452/xrdp
tcp        0      0 0.0.0.0:55555           0.0.0.0:*               LISTEN      1323/nginx -g daemo
tcp6       0      0 :::80                   :::*                    LISTEN      1488/apache2
tcp6       0      0 :::22                   :::*                    LISTEN      1337/sshd
ubuntu@ip-172-31-19-142:~$

/var/log/nginx/error.log

  thrown in /var/www/cops/base.php on line 1257" while reading response header from upstream, client: 5.159.0.139, server: myip:55555, request: "GET / HTTP/1.1", upstream: "fastcgi://unix:/run/php/php5.6-fpm.sock:", host: "mydomain.eu:55555"
2018/01/04 12:12:42 [error] 7097#7097: *1 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Exception: Database <> not found. in /var/www/cops/base.php:1257
Stack trace:
#0 /var/www/cops/base.php(1272): Base::error(NULL)
#1 /var/www/cops/base.php(1285): Base::getDb()
#2 /var/www/cops/index.php(37): Base::checkDatabaseAvailability()
#3 {main}
  thrown in /var/www/cops/base.php on line 1257" while reading response header from upstream, client: 5.159.0.139, server: myip:55555, request: "GET / HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.1-fpm.sock:", host: "mydomain.eu:55555"
2018/01/04 12:12:42 [error] 7097#7097: *1 FastCGI sent in stderr: "PHP message: PHP Notice:  Undefined index: cops_server_side_render in /var/www/cops/base.php on line 18" while reading response header from upstream, client: 5.159.0.139, server: myip:55555, request: "GET /checkconfig.php?err=1 HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.1-fpm.sock:", host: "mydomain.eu:55555"
2018/01/04 12:12:43 [error] 7097#7097: *3 FastCGI sent in stderr: "PHP message: PHP Notice:  Undefined index: cops_server_side_render in /var/www/cops/base.php on line 18" while reading response header from upstream, client: 5.159.0.139, server: myip:55555, request: "GET /checkconfig.php?err=1 HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.1-fpm.sock:", host: "mydomain.eu:55555"
2018/01/04 12:23:15 [error] 7420#7420: *1 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Exception: Database <> not found. in /var/www/cops/lib/Base.php:109
Stack trace:
#0 /var/www/cops/lib/Base.php(124): Base::error(NULL)
#1 /var/www/cops/lib/Base.php(137): Base::getDb()
#2 /var/www/cops/index.php(28): Base::checkDatabaseAvailability()
#3 {main}
  thrown in /var/www/cops/lib/Base.php on line 109" while reading response header from upstream, client: 5.159.0.139, server: myip:55555, request: "GET / HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.1-fpm.sock:", host: "mydomain.eu:55555"
2018/01/04 12:38:11 [error] 7420#7420: *12 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Exception: Database <> not found. in /var/www/cops/lib/Base.php:109
Stack trace:
#0 /var/www/cops/lib/Base.php(124): Base::error(NULL)
#1 /var/www/cops/lib/Base.php(137): Base::getDb()
#2 /var/www/cops/index.php(28): Base::checkDatabaseAvailability()
#3 {main}
  thrown in /var/www/cops/lib/Base.php on line 109" while reading response header from upstream, client: 5.159.0.139, server: myip:55555, request: "GET / HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.1-fpm.sock:", host: "mydomain.eu:55555"
ubuntu@ip-172-31-19-142:~$

Screenshot of Error messages:

Installed cops and it worked fine. Only one thing: there are no covers, at least no thumbnails. Clicking on the broken-link for the thumbnails shows the correct cover. How come?

Since upgrading to 1.0.2 (from 1.0.0), I don't seem to be able to do user authentication using cops_basic_authentication

What appears to be happening it seems to be reading the config_local.user.php file once, but then a second time not doing so, because it doesn't carry the PHP_AUTH_USER when it loads config a second time, and pulls in the blank cops_basic_authentication config array. I tested this by putting a default array in with bogus username and password, and then just above the check for username and password, dumping the contents of cops_basic_authentication. It shows in succession, the contents of the array in my custom user config file, and then the contents of the default one.

Any idea what might have changed since 1.0.0? I don't see anything unusual in config.php

Thanks,

Hello and a Happy Christmas !

I am using COPS in combination with FBReader. $config['cops_use_url_rewriting'] = "1" is set and when I download a book on my PC or Chrome on my Android mobile, it is downloaded with the correct filename. When I download the same book in FBReader it is downloaded as "fetch.php?....".

What am I doing wrong ?

YOS, Kuzorra

Basically I was facing the same issue as in #389 and there was always the option of playing with the PHP options but I wonder if the buffering shouldn't be disabled altogether in this kind of process.

So here the idea was to simply flush the output buffer and stop using it and then read the file contents.

Two notes:

1. In terms of performance I'm not a guru enough to be able to assess whether buffering adds a lot of value here. But there may be cases where it has so this could be the wrong path
2. When opening the file in read mode a "read lock" was put on the file before reading the file size. By reading the file contents brutally without opening the file handle there is a risk for having inconsistent data (if file is changed basically between the reading of the file size and the reading of its contents). But that seemed farfetched to me.

But I also may be missing something here :)

On big eBooks like comic books you can hit the PHP memory limit. With this changes there is no need to raise the memory limit in php.ini. Also readfile is recommended in the php documentation instead of fpassthru for most cases so I changed it. Also if you download binary data make sure that there is no output after that therefore an explicit exit() at the end.

Hello, I'm just starting to play around with my Synology, I managed to install docker and portainer, I have calibre-web running, but after installing cops I receive the error nginx: [emerg] bind() to 0.0.0.0:80 failed (98: Address in use) I can't set ports with -p because I have to use docker in "host" mode, due to arm64 version limits, if I understood correctly. So, can someone help me to set the right ports for cops? I tried to change ports in container settings but whitout success 🙄 Thank you! 🤗 Valeria

Hi, I installed COPS as a subdirectory of the folder web, and it starts alright, displaying all my books. Path of calibre-library is /volume1/books/calibre. Yet something must be wrong still as I cannot download a single book I have. But if I choose to read the book online in the browser it works alright - so where is my mistake?

You can try out here for yourselves: mwcem.synology.me/cops

Don't know what I'm doing wrong.

I truly like this project, and as somewhat of an old programmer, am working to customize this to fit my needs.

But I need to know what all the variables, and properties are.

Here are some of the things I have added to my version:

1. Added Authors, Series, Publishers and Tags with glyphicons to the top navigation.
2. Added Home Glyphicon to the right of search box.
3. Changed Home Link into breadcrumbs
4. Tags, Series and Publisher Home Page now shows a tag cloud

Things I would like to do:

1. Being able to add and switch more themes
2. Change the look and feel and what data to show on certain pages.
3. Have the book div have links to tags and author
4. have a built-in customizable ebook reader, that displays the book and allows me to go page by page.

But to do that, I need to have a list of variables, properties, etc.

Othewise I am just guessing based on code I read in the files.

Thanks.