10-06-2013, 09:33 PM | #646 |
Junior Member
Posts: 5
Karma: 10
Join Date: Feb 2008
Device: Kindle
|
QNap install steps? PDOException
Trying to get COPS working on my QNap 419 w/firmware 4.02. I'm pretty sure I followed all the correct steps, but am being bugged by the DB access error.
My install is in Code:
/share/QWeb/cops My Calibre library is in Code:
/share/Public/eBooks/Calibre\ Library/ Code:
/share/MD0_DATA/Public/eBooks/Calibre\ Library/ When I hit http://192.168.1.105:8082/cops/feed.php, I get the common error: Code:
Check if Calibre database file exists and is readable File ../../../MD0_DATA/Public/eBooks/Calibre\ Library/metadata.db not found, Please check Value of $config['calibre_directory'] in config_local.php Value of open_basedir in your php.ini The access rights of the Calibre Database Synology users please read this Check if Calibre database file can be opened with PHP If the file is readable, check your php configuration. Exception detail : exception 'PDOException' with message 'safe_mode/open_basedir prohibits opening ../../../MD0_DATA/Public/eBooks/Calibre\ Library/metadata.db' in /share/MD0_DATA/Qweb/cops/checkconfig.php:136 Stack trace: #0 /share/MD0_DATA/Qweb/cops/checkconfig.php(136): PDO->__construct('sqlite:../../.....') #1 {main} Check if Calibre database file contains at least some of the needed tables If the file is readable, check your php configuration. Exception detail : exception 'PDOException' with message 'safe_mode/open_basedir prohibits opening ../../../MD0_DATA/Public/eBooks/Calibre\ Library/metadata.db' in /share/MD0_DATA/Qweb/cops/checkconfig.php:149 Stack trace: #0 /share/MD0_DATA/Qweb/cops/checkconfig.php(149): PDO->__construct('sqlite:../../.....') #1 {main} Code:
<?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'] = '../../../MD0_DATA/Public/eBooks/Calibre\ Library/'; /* * Catalog's title */ $config['cops_title_default'] = "Calibre Library"; /* * 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"; Code:
open_basedir="/share/Qweb:/share/MD0_DATA/Public/eBooks/Calibre\ Library/" Any ideas what I'm missing? |
10-07-2013, 04:24 AM | #647 |
Guru
Posts: 716
Karma: 10738
Join Date: Nov 2012
Device: iPad & iPhone with Marvin 2 + 3 & Kobo Glo HD
|
In config_local.php try using:
Code:
$config['calibre_directory'] = '/share/Public/eBooks/Calibre Library/'; Use an absolute path not a relative path (though it should work in Linux). |
Advert | |
|
10-07-2013, 11:08 PM | #648 |
Junior Member
Posts: 5
Karma: 10
Join Date: Feb 2008
Device: Kindle
|
I tried that - Both with the aliased and non-aliased paths - same failure.
|
10-08-2013, 11:07 AM | #649 |
Guru
Posts: 716
Karma: 10738
Join Date: Nov 2012
Device: iPad & iPhone with Marvin 2 + 3 & Kobo Glo HD
|
I have tested a little.
I can reproduce (I think) your problem if I write "Calibre\ Library" in config_local.php and then check with checkconfig.php. I have no problem when I use "Calibre Library" in config_local.php (and possibly php.ini). Please try without the "\". |
10-08-2013, 11:12 AM | #650 |
Addict
Posts: 369
Karma: 37869
Join Date: Sep 2011
Device: Kobo eReader Touch, Kobo Aura HD
|
|
Advert | |
|
10-09-2013, 01:57 AM | #651 |
Junior Member
Posts: 5
Karma: 10
Join Date: Feb 2008
Device: Kindle
|
Thanks all! That was it - The path spec doesn't like spaces (escaped or not). I changed the folder to Calibre_Library and reverted the php.ini file to get rid of the open_basedir I'd added and now things work fine.
|
10-10-2013, 09:37 AM | #652 | |
Addict
Posts: 369
Karma: 37869
Join Date: Sep 2011
Device: Kobo eReader Touch, Kobo Aura HD
|
Quote:
To satisfy my curious mind, the space was the problem ? or only the backslash ? |
|
10-12-2013, 12:20 PM | #653 |
Junior Member
Posts: 5
Karma: 10
Join Date: Feb 2008
Device: Kindle
|
Sorry for the slow response. It was the backslash that was the issue. It appears you don't need to escape spaces in the path at all, it works fine with them as-is.
|
10-14-2013, 06:03 AM | #654 |
Addict
Posts: 369
Karma: 37869
Join Date: Sep 2011
Device: Kobo eReader Touch, Kobo Aura HD
|
|
10-14-2013, 06:58 PM | #655 |
Junior Member
Posts: 1
Karma: 10
Join Date: Oct 2013
Device: iPad
|
Hello, today I tried upgrading my synology install both by copying the new files from the zip over the old ones and by creating a new directory in the web share, but both resulted in nonfunctional version of cops, so in the end uninstalled and reinstalled it from the package manager. Is there any chance to get the package on Synocommunity updated to 0.6.2?
Cheers and thanks for the useful program |
10-17-2013, 02:55 AM | #656 | |
Addict
Posts: 369
Karma: 37869
Join Date: Sep 2011
Device: Kobo eReader Touch, Kobo Aura HD
|
Quote:
https://github.com/SynoCommunity/spksrc/pull/690 Last edited by vlad59; 10-17-2013 at 03:02 AM. |
|
10-18-2013, 03:36 AM | #657 |
Addict
Posts: 369
Karma: 37869
Join Date: Sep 2011
Device: Kobo eReader Touch, Kobo Aura HD
|
Translators still wanted
Hi all,
I'd like to renew my call for translators (see https://www.mobileread.com/forums/sho...&postcount=625 for the details). For information here is the current status of all COPS's translations : Code:
language file: ../lang/Localization_en.json / en 68 / 68 (100 %) language file: ../lang/Localization_ca.json / ca 34 / 68 (50 %) language file: ../lang/Localization_de.json / de 59 / 68 (86.7647058823529 %) language file: ../lang/Localization_es.json / es 34 / 68 (50 %) language file: ../lang/Localization_fr.json / fr 65 / 68 (95.5882352941177 %) language file: ../lang/Localization_it.json / it 63 / 68 (92.6470588235294 %) language file: ../lang/Localization_nb.json / nb 55 / 68 (80.8823529411765 %) language file: ../lang/Localization_nl.json / nl 68 / 68 (100 %) language file: ../lang/Localization_pt.json / pt 68 / 68 (100 %) language file: ../lang/Localization_ru.json / ru 35 / 68 (51.4705882352941 %) language file: ../lang/Localization_zh.json / zh 68 / 68 (100 %) If you can help, please speak up. If nobody does, I'll remove completely those translations in the next release. Thanks in advance. Last edited by vlad59; 10-18-2013 at 08:26 AM. |
10-20-2013, 11:22 AM | #658 | |
Addict
Posts: 369
Karma: 37869
Join Date: Sep 2011
Device: Kobo eReader Touch, Kobo Aura HD
|
Quote:
|
|
10-22-2013, 10:47 AM | #659 |
Junior Member
Posts: 1
Karma: 10
Join Date: Oct 2013
Device: kobo
|
Hi there,
i have been using COPS for some time now and really like it. But i (and my GF) were always watching the changelogs for a more complex 'recent additions' feature. Currently the 'recent additions' displays 'n most recent books'. But we would really like to see something like a submenu (like author) with the 'Date' (date added to library eg: 2013.01.22). So something like: -Recent Additions --2013.10.22 (n books) ---books --2013.10.21 (n books) ---books I have been looking over the code, to perhaps, modify 1 layout (i.e. language) to display something like the date. But the code is a little to complex for my basis php understanding. And i have been trying some thing with the custom column, but i never did get that working. Is it possible to add / create something like this? |
10-23-2013, 02:12 PM | #660 |
Junior Member
Posts: 2
Karma: 10
Join Date: Oct 2013
Device: nexus10
|
Rating Icon
I recently discovered COPS and got it up & running. It is great!
Thanks for making this excellent piece of software. The only issue I have and could not find an easy explanation or solution is that if I use a browser to access the COPS catalog, the rating stars render incorrectly. I have used a variety of browsers and operating systems, some work, some doesn't. For example Firefox v24 on Windows XP does not, Firefox on Vista works, Chrome on Vista or Windows 7 doesn't, Internet Explorer 8 in Windows 7 and IE9 on Vista works too. Chrome and Firefox on both Nexus 7 and Nexus 10 is OK too. Any thoughts on this? |
Tags |
calibre opds, dns, kobo aura, synology |
Thread Tools | Search this Thread |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calibre OPDS server with windows apps? | nickdma | Related Tools | 10 | 03-03-2024 02:53 PM |
[Old Thread] Android FBreader and Calibre OPDS server question | kalex | Calibre | 5 | 12-24-2015 10:16 PM |
PHP+Apache web server for calibre ... | chaley | Related Tools | 254 | 04-28-2014 08:18 PM |
External OPDS catalogue in Calibre | bolton | Calibre | 1 | 09-05-2012 06:14 AM |
Calibre Command Line usage with PHP | artoros | Related Tools | 13 | 07-01-2010 09:57 AM |