Internal Server Error

[Constantine Tsardounis]

Hello to all!...

I have successfully installed  koha-2.2.9.

I can add Members/Organizations and search for them flawlessly,
BUT, trying to add a bibliographic records leads me to this error:

Internal Server Error
The server encountered an internal error or misconfiguration and was
unable to complete your request.
Please contact the server administrator, w@... and inform them of the
time the error occurred, and anything you might have done that may
have caused the error.
More information about this error may be available in the server error log.
Apache/2.2.9 (Debian) PHP/5.2.6-1 with Suhosin-Patch Server at
localhost Port 8889

MySQL server IS running:
# ps aux |grep mysql
root     10115  0.0  0.0   1820   516 pts/4    S    00:54   0:00
/bin/sh /usr/bin/mysqld_safe
mysql    10163  0.0  1.4 128736 18144 pts/4    Sl   00:54   0:07
/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking
--port=3306 --socket=/var/run/mysqld/mysqld.sock
root     10165  0.0  0.0   4704   616 pts/4    S    00:54   0:00
logger -p daemon.err -t mysqld_safe -i -t mysqld

and also I get
# a2enmod auth_mysql
Module auth_mysql already enabled
# /etc/init.d/apache2 restart

What should I do?


Thank you in advance,

Constantine Tsardounis
http://costis.name
_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha

[MJ Ray-2]

constantine <costas.magnuse@...> wrote:

> I can add Members/Organizations and search for them flawlessly,
> BUT, trying to add a bibliographic records leads me to this error:
>
> Internal Server Error [...]
> MySQL server IS running: [...]
> # a2enmod auth_mysql
> Module auth_mysql already enabled
> # /etc/init.d/apache2 restart
>
> What should I do?

Hi.  Thanks for the question, but I'll be surprised if anyone can help
from that.  In particular, you probably need to tell us:-

* Any error message (preferred) or problem description - if it's not
on the screen, check any relevant log files you can find.

* Web address of error (if any).

* How to obtain the error, step-by-step if possible.

* If that process has worked for you before, the date when it worked.

(This is copy-pasta which you can avoid in future by reading the
list archives before posting.)

Regards,
--
MJ Ray (slef)
Webmaster for hire, statistician and online shop builder for a small
worker cooperative http://www.ttllp.co.uk/ http://mjr.towers.org.uk/
(Notice http://mjr.towers.org.uk/email.html) tel:[phone]
_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha

[Constantine Tsardounis]

On Wed, Jul 2, 2008 at 12:08 PM, MJ Ray <mjr@...> wrote:

> constantine <costas.magnuse@...> wrote:
>> I can add Members/Organizations and search for them flawlessly,
>> BUT, trying to add a bibliographic records leads me to this error:
>>
>> Internal Server Error [...]
>> MySQL server IS running: [...]
>> # a2enmod auth_mysql
>> Module auth_mysql already enabled
>> # /etc/init.d/apache2 restart
>>
>> What should I do?
>
> Hi.  Thanks for the question, but I'll be surprised if anyone can help
> from that.  In particular, you probably need to tell us:-

And I thought I was making informative posts :D...

> * Web address of error (if any).
> * How to obtain the error, step-by-step if possible.
I am adding the data manually using the address:
http://sangre:8889/cgi-bin/koha/acqui.simple/addbiblio.pl

When I retrieve the data from a Z39.50 server (this feature really
rocks!) the address with the completed data is:
http://sangre:8889/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbiblionumber=0&z3950=1&breedingid=1

Then I click "Add Bibliographic Record and go to Tems", which leads me
to the "Internal Server Error" page which is also:
http://sangre:8889/cgi-bin/koha/acqui.simple/addbiblio.pl

> * Any error message (preferred) or problem description - if it's not
> on the screen, check any relevant log files you can find.
I have added "Loglevel debug" in apache2.conf and koha-httpd.conf alike.
The apache2/error.log returns nothing.

However I get:

###############
root@sangre:/usr/local/koha/log# tail koha-access_log
###############
127.0.0.1 - - [02/Jul/2008:21:54:07 +0300] "POST
/cgi-bin/koha/acqui.simple/addbiblio.pl HTTP/1.1" 500 428
127.0.0.1 - - [02/Jul/2008:21:55:49 +0300] "GET
/cgi-bin/koha/loadmodules.pl?module=addbiblio&type=intranet HTTP/1.1"
302 -
127.0.0.1 - - [02/Jul/2008:21:55:49 +0300] "GET
/cgi-bin/koha/acqui.simple/addbooks.pl HTTP/1.1" 200 3782
127.0.0.1 - - [02/Jul/2008:21:56:15 +0300] "POST
/cgi-bin/koha/acqui.simple/addbiblio.pl HTTP/1.1" 200 36007
127.0.0.1 - - [02/Jul/2008:21:56:38 +0300] "GET
/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
HTTP/1.1" 200 759
127.0.0.1 - - [02/Jul/2008:21:56:39 +0300] "GET
/intranet-tmpl/default/en/includes/intranet.css HTTP/1.1" 404 296
127.0.0.1 - - [02/Jul/2008:21:56:41 +0300] "POST
/cgi-bin/koha/z3950/search.pl HTTP/1.1" 200 706
127.0.0.1 - - [02/Jul/2008:21:56:42 +0300] "GET
/intranet-tmpl/default/en/includes/intranet.css HTTP/1.1" 404 296
127.0.0.1 - - [02/Jul/2008:21:56:45 +0300] "GET
/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbiblionumber=0&z3950=1&breedingid=1
HTTP/1.1" 200 40843
127.0.0.1 - - [02/Jul/2008:21:57:04 +0300] "POST
/cgi-bin/koha/acqui.simple/addbiblio.pl HTTP/1.1" 500 428

###############
root@sangre:/usr/local/koha/log# cat koha-error_log
###############
[Wed Jul 02 21:55:50 2008] [debug] mod_deflate.c(619): [client
127.0.0.1] Zlib: Compressed 16118 to 3764 : URL
/cgi-bin/koha/acqui.simple/addbooks.pl, referer:
http://sangre:8889/cgi-bin/koha/acqui.simple/addbooks.pl
[Wed Jul 02 21:56:17 2008] [debug] mod_deflate.c(619): [client
127.0.0.1] Zlib: Compressed 767546 to 35989 : URL
/cgi-bin/koha/acqui.simple/addbiblio.pl, referer:
http://sangre:8889/cgi-bin/koha/acqui.simple/addbooks.pl
[Wed Jul 02 21:56:39 2008] [debug] mod_deflate.c(619): [client
127.0.0.1] Zlib: Compressed 1549 to 741 : URL
/cgi-bin/koha/z3950/search.pl, referer:
http://sangre:8889/cgi-bin/koha/acqui.simple/addbiblio.pl
[Wed Jul 02 21:56:39 2008] [error] [client 127.0.0.1] File does not
exist: /usr/local/koha/intranet/htdocs/intranet-tmpl/default/en/includes/intranet.css,
referer: http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:39 2008] [debug] mod_deflate.c(619): [client
127.0.0.1] Zlib: Compressed 376 to 278 : URL
/intranet-tmpl/default/en/includes/intranet.css, referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:41 2008] [error] [client 127.0.0.1] something went
wrong: No error at /usr/local/koha/intranet/cgi-bin/z3950/search.pl
line 135., referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:41 2008] [error] [client 127.0.0.1] doing the search
at /usr/local/koha/intranet/cgi-bin/z3950/search.pl line 145.,
referer: http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:42 2008] [error] [client 127.0.0.1] connection 0:
event 1 (connect), referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:42 2008] [error] [client 127.0.0.1] connection 0:
event 6 (send apdu), referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:42 2008] [error] [client 127.0.0.1] connection 0:
event 2 (send data), referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:42 2008] [error] [client 127.0.0.1] connection 0:
event 3 (receive data), referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:42 2008] [error] [client 127.0.0.1] connection 0:
event 7 (receive apdu), referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:42 2008] [error] [client 127.0.0.1] connection 0:
event 6 (send apdu), referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:42 2008] [error] [client 127.0.0.1] connection 0:
event 2 (send data), referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:42 2008] [error] [client 127.0.0.1] connection 0:
event 3 (receive data), referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:42 2008] [error] [client 127.0.0.1] connection 0:
event 7 (receive apdu), referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:42 2008] [error] [client 127.0.0.1] connection 0:
event 9 (receive search), referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:42 2008] [error] [client 127.0.0.1] connection 0:
event 10 (end), referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:42 2008] [error] [client 127.0.0.1] z3950.loc.gov at
/usr/local/koha/intranet/cgi-bin/z3950/search.pl line 161., referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:42 2008] [debug] mod_deflate.c(619): [client
127.0.0.1] Zlib: Compressed 1358 to 688 : URL
/cgi-bin/koha/z3950/search.pl, referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:42 2008] [error] [client 127.0.0.1] File does not
exist: /usr/local/koha/intranet/htdocs/intranet-tmpl/default/en/includes/intranet.css,
referer: http://sangre:8889/cgi-bin/koha/z3950/search.pl
[Wed Jul 02 21:56:42 2008] [debug] mod_deflate.c(619): [client
127.0.0.1] Zlib: Compressed 376 to 278 : URL
/intranet-tmpl/default/en/includes/intranet.css, referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl
[Wed Jul 02 21:56:48 2008] [debug] mod_deflate.c(619): [client
127.0.0.1] Zlib: Compressed 896041 to 40825 : URL
/cgi-bin/koha/acqui.simple/addbiblio.pl, referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl
[Wed Jul 02 21:57:06 2008] [error] [client 127.0.0.1] Q2 : select
distinct m1.bibid from biblio,biblioitems,marc_biblio,marc_word as
m1,marc_word as m2,marc_word as m3,marc_word as m4,marc_word as
m5,marc_word as m6,marc_word as m7,marc_word as m8,marc_word as m9
where biblio.biblionumber=marc_biblio.biblionumber and
biblio.biblionumber=biblioitems.biblionumber and
m1.bibid=marc_biblio.bibid and (m1.bibid=m2.bibid and
m1.bibid=m3.bibid and m1.bibid=m4.bibid and m1.bibid=m5.bibid and
m1.bibid=m6.bibid and m1.bibid=m7.bibid and m1.bibid=m8.bibid and
m1.bibid=m9.bibid) and ((m1.word  like 'Advances' and m1.tagsubfield
in ('245a'))and (m2.word like 'in' and m2.tagsubfield in('245a'))and
(m3.word like 'economics' and m3.tagsubfield in('245a'))and (m4.word
like 'and' and m4.tagsubfield in('245a'))and (m5.word like
'econometrics' and m5.tagsubfield in('245a'))and (m6.word like
'theory' and m6.tagsubfield in('245b'))and (m7.word like 'and' and
m7.tagsubfield in('245b'))and (m8.word like 'applications' and
m8.tagsubfield in('245b'))and (m9.word like 'seventh' and
m9.tagsubfield in('245b'))) order by biblio.title ASC term is
Advances in economics and econometrics   theory and applications
seventh world congress   24 cm. Cambridge University Press, no. 26-28
at /usr/local/koha/intranet/modules/C4/SearchMarc.pm line 274.,
referer: http://sangre:8889/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbiblionumber=0&z3950=1&breedingid=1
[Wed Jul 02 21:57:06 2008] [error] [client 127.0.0.1] Arguments must
be MARC::Field object at /usr/local/koha/intranet/modules/C4/Biblio.pm
line 1440, referer:
http://sangre:8889/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbiblionumber=0&z3950=1&breedingid=1
[Wed Jul 02 21:57:06 2008] [error] [client 127.0.0.1] Premature end of
script headers: addbiblio.pl, referer:
http://sangre:8889/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbiblionumber=0&z3950=1&breedingid=1
[Wed Jul 02 21:57:06 2008] [debug] mod_deflate.c(619): [client
127.0.0.1] Zlib: Compressed 657 to 410 : URL
/cgi-bin/koha/acqui.simple/addbiblio.pl, referer:
http://sangre:8889/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbiblionumber=0&z3950=1&breedingid=1


> * If that process has worked for you before, the date when it worked.

It has never worked for me and I 've mad a clean install of koha 2.2.9
at least 5 times.
(Unfortunately, using koha 3 leads me to other errors)


My Best Wishes,

Constantine Tsardounis
http://www.costis.name
_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha