PHP+Apache web server for calibre ...

[chaley]

Originally Posted by Fooligan

First of all thanks for the great work you did on this. Especially the different user (.htpasswd) function made my life a lot easier.
There's only one thing; I seem to have some problems with the search function in the PHP version. If I conduct a search all is well, if I conduct a second search, without logging out and in again, it only searches within the first search results. Is there a way, like in the original (kovidgoyal) version, to search from scratch?

I don't see that behavior.

Test:
1) go to the demo library http://charles.the-haleys.org/calibre/demo/
2) search for khalid. You will find one book, The Book of Khalid
3) search for Rohmer. You will find 14 books, none of which is the Book of Khalid.

I can't explain why your system is behaving the way you describe.

[Fooligan]

I don't see that behavior.

Test:
1) go to the demo library http://charles.the-haleys.org/calibre/demo/
2) search for khalid. You will find one book, The Book of Khalid
3) search for Rohmer. You will find 14 books, none of which is the Book of Khalid.

I can't explain why your system is behaving the way you describe.

Noticed that your server doesn't have this problem.
Just browsed through my log files. Seems to be a smarty problem on my side: Undefined variable: _SESSION in /usr/share/php/smarty/Smarty.class.php that keeps popping up. Will look further from here. Thanks for the quick reply!

[Fooligan]

The problem was in smarty. I upgraded smarty to smarty-3.1.8 (which is still marked as unstable in Gentoo) and the problem is gone.

[ldolse]

.....

[micster]

When I click on my "Titles" link to display all of the books in my database, PHP runs out of memory. I'm presented with a blank page and if I view the source the only thing displayed is a solitary "1".

I viewed my Apache error logs and I have one that says PHP ran out of memory while trying to run this script. The first time this happened I had around 7,000 book entries. I checked the memory setting in my "php.ini" and it was set to 128 megs. I thought this should have been enough, but I doubled it to 256 megs which made the problem go away.

I have since added many more books to my calibre database and I now have over 20,000 titles. Needless to say, every time I select to view all of my titles the script will crash with an out-of-memory error.

Is there anyway around this? Clicking on the other links is slow, but eventually they will display their info. I had a different script that would organize the titles into categories from A-Z and it would run fine. I'm thinking that the root of the problem is this one link that has 20,000 entries and if I could somehow break it up into smaller chunks I think it will work again.

[chaley]

Originally Posted by micster

When I click on my "Titles" link to display all of the books in my database, PHP runs out of memory. I'm presented with a blank page and if I view the source the only thing displayed is a solitary "1".

I viewed my Apache error logs and I have one that says PHP ran out of memory while trying to run this script. The first time this happened I had around 7,000 book entries. I checked the memory setting in my "php.ini" and it was set to 128 megs. I thought this should have been enough, but I doubled it to 256 megs which made the problem go away.

I have since added many more books to my calibre database and I now have over 20,000 titles. Needless to say, every time I select to view all of my titles the script will crash with an out-of-memory error.

Is there anyway around this? Clicking on the other links is slow, but eventually they will display their info. I had a different script that would organize the titles into categories from A-Z and it would run fine. I'm thinking that the root of the problem is this one link that has 20,000 entries and if I could somehow break it up into smaller chunks I think it will work again.

The problem arises because the db reads all the books into memory to ease the sorting problem. The various column types need to use different rules for sorting, something that goes beyond what ORDER BY can do.

It wouldn't be hard to "fix" this to use paged accesses when sorting by (for example) title & author, because these have db columns underneath them. Series requires a compound ordering, and dates add even more complexity.

My problem is that I no longer use this server so am not motivated to take on changes of this complexity. I have switched to the calibre content server so I can use it with Calibre Companion (the android app).

If you wish to do the changes, then you would need to change db.php (to page and to sort), the various modules like title.php to pass the paging information to the db routine, and book_base.php to understand that it is being given page segments and not the entire books array.

Another possibility would be to read only the fields required to do the current sort, do the sort, then read the entire records for the desired book ids. This is probably easier than changing to use LIMIT expressions, but won't be nearly as memory efficient.

A third possibility, perhaps the simplest, is that if displaying titles then honor only the sorting options that ORDER BY can do without difficulty. These would be the non-NULL string fields (almost all custom columns can be NULL), and possibly series if you generate the appropriate compound order by for them.

[micster]

Thanks chaley!

That fills in some of the pieces for me and gives me something to go on. I totally understand the motivation thing also.

[Kevnancy]

Dear all,

I want to use calibre php server on my IIS8 + php 5.4.9 but it doesn't work... http error 500

What kind of DB calibre uses? sqlite3?

Do I need to modify the .php files of calibre server?

Best regards

[chaley]

Originally Posted by Kevnancy

Dear all,

I want to use calibre php server on my IIS8 + php 5.4.9 but it doesn't work... http error 500

What kind of DB calibre uses? sqlite3?

Do I need to modify the .php files of calibre server?

Best regards

Calibre's db is sqlite3. With php 5.4.9 you should use the sqlite3 plugin, although I confess that I have never tried that php version.

You must modify the configuration .php file(s) as described in the INSTALL file. You shouldn't need to modify anything else, but given that I have never run the server on IIS or used php 5.4, I might be wrong. In particular, the version of smarty might force some modification of the templates.

Final note: I no longer use this server and have no strong interest in maintaining it. If you want to use a server that is under active development, see http://www.mobileread.com/forums/sho...d.php?t=170903. I don't know the state of its development or if that server will meet your needs.

[claduver]

Hello All,

First thanks to Charles for this great work !!
I've spent the last three evenings installing and configuring it on my windows XP box acting as server. It works fine, and answers all my needs.
I've put Apache 2.2.22 + PHP 5.2.17 + smarty 2.6.27 (the 3.x versions produced errors as said in another post)

Just two little add-ons I made :
1 - on windows, as you pointed out, Apache MD5 encoder doesn't work the same as PHP's so no password is recognized correctly if encrypted. I had to go for plain text.
So I added in config_local_php an entry :
$config['password_crypted'] = [true|false];
and modified index.php as below :

Moderator Notice
Changed the FONT tags around the source code to CODE tags so that indentation is not lost

if ($config['use_internal_login']) {
		$_REQUEST['msg'] = '';
		if (!isset($_SESSION['has_logged_in'])) {
			if (isset($_REQUEST['name']) && isset($_REQUEST['password'])) {
				$lines = file($config['password_file'], FILE_IGNORE_NEW_LINES);
				$upw = $_REQUEST['password'];
						
				foreach ($lines as $line) {
					list($name, $fpw) = explode(':', $line, 2);					
					if ($name == $_REQUEST['name']) {
						$cpwd = '';
						// test if password needs to be encrypted before compare with file password
						if ($config['password_crypted']) {
							$cpwd= crypt($upw, $fpw);							
						}
						else {
							$cpwd=$upw;
						}
						if ($cpwd == $fpw) {						
							$_SESSION['has_logged_in'] = $_REQUEST['name'];
							dprint("$name has logged in");
							break;
						}
					}
				}
				if (!isset($_SESSION['has_logged_in'])) {
					$_REQUEST['m'] = 'login';
					$_REQUEST['msg'] = 'invalid user name or password';
				}
			}
		}
		if (!isset($_SESSION['has_logged_in'])) {
			$_REQUEST['m'] = 'login';
		} else {
			$_SERVER['REMOTE_USER'] = $_SESSION['has_logged_in'];
		}
	}

Besides, I corrected a bug in the loop because the password was re-encrypted upon each turn.

Authentication works fine now.


2 - I have declared three users with differents rights and I felt the need to disconnect properly, so I added a "disconnect" functionality in the header and a disconnect.php file.
I also modify the styles to display the message in login page more beautifully (I used the stylesheets published by another user).
here goes in attached files.

Hope this will please you, and thanks again for your great work.

Claire.

[chaley]

@claire: thanks for the nice words. I am glad you got it working.

I took the liberty of changing your post slightly so that the indentation of the code is not lost. I did that by changing FONT to CODE around the source code.

[claduver]

Originally Posted by chaley

@claire: thanks for the nice words. I am glad you got it working.

I took the liberty of changing your post slightly so that the indentation of the code is not lost. I did that by changing FONT to CODE around the source code.

You did well, I wanted to make it appear like code but didn't know how to do that