PHP+Apache web server for calibre ...

[chaley]

Release 0.2.8 is available at http://charles.the-haleys.org/calibre/

This release fixes various bugs and adds the ability to disable downloading of formats on a per-user basis. For the latter, see the new configuration item 'enable_format_download'.

Please note: in all previous releases, per-user restrictions did not work when also using the server's internal login facility.

Change log:

Spoiler:

88 charles <> 2012-02-15 {REL 0.2.8}
Release 0.2.8

87 charles <> 2012-02-15
Update version number

86 charles <> 2012-02-15
Add the ability to not display format links. Fix a longstanding bug with internal login not respecting the restrictions.

85 charles <> 2012-02-15
Preserve spaces in the book name in the content-disposition header.

84 charles <> 2011-11-22
Remove extra </span>

83 charles <> 2011-11-21
Remove deprecated meta language tag. Instead put it on html element.

82 charles <> 2011-11-20
Changes submitted by edent:
- add size to link to format
- correctly escape ampersands in various places

[chaley]

Originally Posted by ilovejedd

Thanks! Would the following work?

$config['restrict_display_to'] = array('admin'=> '', 'user1' => '#user:=all or #user:=user1', 'user2' => '#user:=all or #user:=user2');

Yes. Note that if you are using the internal login feature as opposed to apache authentication, then you must be running 0.2.8.

Special request, would it be possible to add a configuration for preferred book name? For example, instead of Artemis_Fowl___Eoin_Colfer.epub, you can set it to Eoin Colfer - Artemis Fowl.epub ({author} - {title}). If that's too much hassle, even retaining the default calibre name of Artemis Fowl - Eoin Colfer.epub would be fine, too. Thanks!

I changed the server to preserve spaces in the existing name. This was a mild PITA because firefox won't accept spaces in the content-disposition header while IE will. Both accept escaped file names.

Note that the release 0.2.8 provides the 'no download' feature you asked for.

[ilovejedd]

Originally Posted by chaley

Yes. Note that if you are using the internal login feature as opposed to apache authentication, then you must be running 0.2.8.
I changed the server to preserve spaces in the existing name. This was a mild PITA because firefox won't accept spaces in the content-disposition header while IE will. Both accept escaped file names.

Note that the release 0.2.8 provides the 'no download' feature you asked for.

Thank you very, very, very much!

[ilovejedd]

Played around with the templates to strip most of the styling and put them in CSS. Here are the revised .tpl files (header, footer, index, category & books_section) along with some sample stylesheets. The file stylesheet.css must be in the same folder as index.php.

stylesheet.css:

001: uses the original styles (stylesheet.css is a copy of this file)
002: similar to original style but uses different font
003 & 004: changed header/footer background color, added button styling
005: similar to 004, added background color

Also working on a template for something more mobile-friendly.

Not really particularly artistic. Hopefully, someone with a more artistic bent will modify the CSS to something more pleasing to the eye.

[chaley]

Originally Posted by ilovejedd

Played around with the templates to strip most of the styling and put them in CSS. Here are the revised .tpl files (header, footer, index, category & books_section) along with some sample stylesheets. The file stylesheet.css must be in the same folder as index.php.

Thanks. The changes will be in the next release.

While playing with your changes I noticed that the background of the ratings image (images/five_stars.png) was set to white instead of transparent, messing up any change to the background. A fixed file is attached.

[vlad59]

Hi,

If anybody is interested I modified the template to make it xhtml and 90% valid w3c code.

I modified ilovejedd's template version and added some new styles.

I still have some work to do with the book_section.tpl to make it both valid and working.

As a side note, I'm using Nginx and I'm not able to download any epub. I can't test with apache so can anybody tell me if download works if the calibre directory is not inside the web site directory (in my case my web dir is /var/www/ebook and my calibre directory is /home/calibre/Calibre).

@chaley do you use any versionning system for this project ? a github / google code / bitbucket account could be a good idea, don't you think ?

[chaley]

Originally Posted by vlad59

As a side note, I'm using Nginx and I'm not able to download any epub. I can't test with apache so can anybody tell me if download works if the calibre directory is not inside the web site directory (in my case my web dir is /var/www/ebook and my calibre directory is /home/calibre/Calibre).

My library (calibre directory) is not in web space and downloads work fine.

When other people have had problems with downloading, it has been faulty URL rewriting. The download links have 'extended' information on them (info after the .php segment). If that extra info isn't passed along, the download will fail.

@chaley do you use any versionning system for this project ? a github / google code / bitbucket account could be a good idea, don't you think ?

I use bzr. I haven't made the repository public, mostly because I have some private files also under VC and haven't bothered to separate them out.

[vlad59]

Originally Posted by chaley

My library (calibre directory) is not in web space and downloads work fine.

When other people have had problems with downloading, it has been faulty URL rewriting. The download links have 'extended' information on them (info after the .php segment). If that extra info isn't passed along, the download will fail.

Thanks I'll try to check that. I already use the tweak on some previous page of this thread. I must have forgotten something.

Originally Posted by chaley

I use bzr. I haven't made the repository public, mostly because I have some private files also under VC and haven't bothered to separate them out.

I'll attach here my modifications later tonight then.

EDIT : I'm too tired tonight so I'll upload it next sunday ...

[CyberMike]

Hi

I have been reading some time with you very interested in the forum. When I now want to use my eBook available on the web on my books, I've been looking for a way. Here I found the Calibre PHP content server that meets all my needs.

I installed everything exactly as directed and adapted the paths. When you call the index.php I get the following error message from the server.

Fatal error: Uncaught exception 'Exception' with message 'Unable to open database: unable to open database file' in /www/htdocs/-------/calibre/db.php:160 Stack trace:
#0 /www/htdocs/-------/calibre/db.php(160): SQLite3->__construct('/metadata.db', 1)
#1 /www/htdocs/-----/calibre/db.php(195): MySQLite->open('/metadata.db')
#2 /www/htdocs/-----/calibre/index.php(53): CalDatabase->__construct(NULL)
#3 {main} thrown in /www/htdocs/------/calibre/db.php on line 160

I hope you can help in solving my problem.

The PHP server-info is located here and the page is here.

Thanks in advance

MIKE

[Zatakawa]

EDIT: Solved. I had to move library_dir out of /home and adjust smarty_dir permissions by executing chown -R www-data:www-data /tmp/smarty_test

Thanks for creating and sharing your server!

I've set up your content server, but when i open index.php, all i get is an Error 500 in Chrome or a blank page in Firefox/Opera. Apache's error.log gives the exact same message which user Eibi got a month ago. How can i troubleshoot this further?

OS: Ubuntu 11.10
Webserver: Apache 2.2.20, PHP 5.3.6-13ubuntu3.6
SQLite3 module enabled, gd support enabled
Smarty 2.6.26.
Smarty seems to work, at least this does not throw an error:

require_once('Smarty.class.php');
$smarty = new Smarty();

config_local.php:

...
        $config['library_dir'] = '/home/peter/bib';
	$config['web_dir'] = '.';
	$config['smarty_web_dir'] = $config['web_dir'] . '/smarty';
	$config['smarty_dir'] = '/tmp/smarty_test';
	$config['smarty'] = '/usr/share/php/smarty';
...

If you need any more information, please let me know!

[vlad59]

As promised, here is my XHTML 100% w3c valid version.

I had to modify some PHP code to make it work. If you find some problem with it I'll try to solve as quickly as possible.

calibre-php-server-xhtml.zip

[CyberMike]

Can anybody help me with my Problem ?

Post 204

thx
Mike

[chaley]

Originally Posted by CyberMike

Can anybody help me with my Problem ?

Post 204

thx
Mike

The server is saying that it cannot find or cannot open the database metadata.db in your calibre library. Either the path in $config['library_dir'] is wrong or the web server does not have permissions to read the files in that directory.

[chaley]

Originally Posted by vlad59

As promised, here is my XHTML 100% w3c valid version.

I had to modify some PHP code to make it work. If you find some problem with it I'll try to solve as quickly as possible.

Thanks for this. I haven't done anything yet because of other commitments, but I will in the next few days.

[vlad59]

Originally Posted by chaley

Thanks for this. I haven't done anything yet because of other commitments, but I will in the next few days.

No pressure ! Take your time.