Koha 2.29, HTTP 500 internal server error with Amazon AWS

[Charles N Burns]

Hello all,

Please cc this email to my email address as I am not subscribed to the
list. I would subscribe, but I am setting up Koha for a friend's
community elementary school's library, but have no library of my own.
:)

Problem is:
When I enable AWS (Amazon Web Services) with "AmazonContent = 1", any
attempt to view a book from search is met with the familiar:

"Internal Server Error

The server encountered an internal error or misconfiguration and was
unable to complete your request."
(etc.)

An example of a URL that crashes Koha is this:
http://KOHA_SERVER/cgi-bin/koha/opac-detail.pl?bib=5338

(So the problem seems to be in opac-detail.pl)

----------

When I execute opac-detail.pl directly in the command line:

# export PERL5LIB=/usr/local/koha/intranet/modules
# /usr/local/koha/opac/cgi-bin/opac-detail.pl

I get:

could not retrieve
http://xml.amazon.com/onca/xml3?t=&dev-t=(My_amazon_qws_id)&type=heavy&f=xml&AsinSearch=
at /usr/local/koha/intranet/modules/C4/Amazon.pm line 64.
Could not find opac-detail.xml in /usr/local/koha/opac/cgi-bin/ at
/usr/local/koha/intranet/modules/C4/Amazon.pm line 66

----------

No log files mention anything special other than the access log, which
is pretty worthless:

# cat opac-access_log
(...)
10.0.0.196 - - [22/Jul/2008:22:22:25 -0600] "GET
/cgi-bin/koha/opac-detail.pl?bib=5338 HTTP/1.1" 500 663

----------

The setup:
Ubuntu Hardy 8.04 with most recent updates
Koha 2.2.9
Apache ID string: "Apache/2.2.8 (Ubuntu) PHP/5.2.4-2ubuntu5.2 with
Suhosin-Patch Server at 10.0.0.161 Port 80"
Perl v5.8.8

----------

So it looks like either Amazon isn't providing some XML file, or the
request generated by Koha is not correct.
Either way, I think it's extremely bad that the results of a request
to an external website (Amazon.com) had the effect of basically
"crashing" Koha. I think Koha really ought to handle this, though I
don't actually know if it's something Koha can prevent.


So the question is:
How do I get AWS to work with Koha?

Best regards,

Charles Burns

--
"Be who you are and say what you feel, because those who mind don't
matter and those who matter don't mind." --Dr. Seuss
_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha

[Magnus Enger]

Hi!

Looks like you need to provide Koha with two pieces of information in the
preferences: AmazonAssocTag and AWSAccessKeyID (Access Key ID - if you do not
provide this you will not be getiting the Amazon Reviews). See
http://aws.amazon.com/ for info on how to get these.

Regards,
Magnus Enger
collib.info

----- Original Message -----
From: "Charles N Burns" <charlesnburns@...>
To: koha@...
Sent: Tue, 22 Jul 2008 22:33:21 -0600
Subject: [Koha] Koha 2.29, HTTP 500 internal server error with Amazon AWS

> Hello all,
>
> Please cc this email to my email address as I am not subscribed to the
> list. I would subscribe, but I am setting up Koha for a friend's
> community elementary school's library, but have no library of my own.
> :)
>
> Problem is:
> When I enable AWS (Amazon Web Services) with "AmazonContent = 1", any
> attempt to view a book from search is met with the familiar:
>
> "Internal Server Error
>
> The server encountered an internal error or misconfiguration and was
> unable to complete your request."
> (etc.)
>
> An example of a URL that crashes Koha is this:
> http://KOHA_SERVER/cgi-bin/koha/opac-detail.pl?bib=5338
>
> (So the problem seems to be in opac-detail.pl)
>
> ----------
>
> When I execute opac-detail.pl directly in the command line:
>
> # export PERL5LIB=/usr/local/koha/intranet/modules
> # /usr/local/koha/opac/cgi-bin/opac-detail.pl
>
> I get:
>
> could not retrieve
>

http://xml.amazon.com/onca/xml3?t=&dev-t=(My_amazon_qws_id)&type=heavy&f=xml&

> AsinSearch=
> at /usr/local/koha/intranet/modules/C4/Amazon.pm line 64.
> Could not find opac-detail.xml in /usr/local/koha/opac/cgi-bin/ at
> /usr/local/koha/intranet/modules/C4/Amazon.pm line 66
>
> ----------
>
> No log files mention anything special other than the access log, which
> is pretty worthless:
>
> # cat opac-access_log
> (...)
> 10.0.0.196 - - [22/Jul/2008:22:22:25 -0600] "GET
> /cgi-bin/koha/opac-detail.pl?bib=5338 HTTP/1.1" 500 663
>
> ----------
>
> The setup:
> Ubuntu Hardy 8.04 with most recent updates
> Koha 2.2.9
> Apache ID string: "Apache/2.2.8 (Ubuntu) PHP/5.2.4-2ubuntu5.2 with
> Suhosin-Patch Server at 10.0.0.161 Port 80"
> Perl v5.8.8
>
> ----------
>
> So it looks like either Amazon isn't providing some XML file, or the
> request generated by Koha is not correct.
> Either way, I think it's extremely bad that the results of a request
> to an external website (Amazon.com) had the effect of basically
> "crashing" Koha. I think Koha really ought to handle this, though I
> don't actually know if it's something Koha can prevent.
>
>
> So the question is:
> How do I get AWS to work with Koha?
>
> Best regards,
>
> Charles Burns
>
> --
> "Be who you are and say what you feel, because those who mind don't
> matter and those who matter don't mind." --Dr. Seuss
> _______________________________________________
> Koha mailing list
> Koha@...
> http://lists.katipo.co.nz/mailman/listinfo/koha

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

[Charles N Burns]

Thank you. Now all I need help with is figuring out how on earth I completely missed the "AmazonAssocTag" field when it's right there under the OPAC tab.

On Wed, Jul 23, 2008 at 4:07 PM, Magnus Enger <magnus@...> wrote:

Hi!

Looks like you need to provide Koha with two pieces of information in the
preferences: AmazonAssocTag and AWSAccessKeyID (Access Key ID - if you do not
provide this you will not be getiting the Amazon Reviews). See
http://aws.amazon.com/ for info on how to get these.

Regards,
Magnus Enger
collib.info

----- Original Message -----
From: "Charles N Burns" <charlesnburns@...>
To: koha@...
Sent: Tue, 22 Jul 2008 22:33:21 -0600
Subject: [Koha] Koha 2.29, HTTP 500 internal server error with Amazon AWS

> Hello all,
>
> Please cc this email to my email address as I am not subscribed to the
> list. I would subscribe, but I am setting up Koha for a friend's
> community elementary school's library, but have no library of my own.
> :)
>
> Problem is:
> When I enable AWS (Amazon Web Services) with "AmazonContent = 1", any
> attempt to view a book from search is met with the familiar:
>
> "Internal Server Error
>
> The server encountered an internal error or misconfiguration and was
> unable to complete your request."
> (etc.)
>
> An example of a URL that crashes Koha is this:
> http://KOHA_SERVER/cgi-bin/koha/opac-detail.pl?bib=5338
>
> (So the problem seems to be in opac-detail.pl)
>
> ----------
>
> When I execute opac-detail.pl directly in the command line:
>
> # export PERL5LIB=/usr/local/koha/intranet/modules
> # /usr/local/koha/opac/cgi-bin/opac-detail.pl
>
> I get:
>
> could not retrieve
>
http://xml.amazon.com/onca/xml3?t=&dev-t=(My_amazon_qws_id)&type=heavy&f=xml&

> AsinSearch=
> at /usr/local/koha/intranet/modules/C4/Amazon.pm line 64.
> Could not find opac-detail.xml in /usr/local/koha/opac/cgi-bin/ at
> /usr/local/koha/intranet/modules/C4/Amazon.pm line 66
>
> ----------
>
> No log files mention anything special other than the access log, which
> is pretty worthless:
>
> # cat opac-access_log
> (...)
> 10.0.0.196 - - [22/Jul/2008:22:22:25 -0600] "GET
> /cgi-bin/koha/opac-detail.pl?bib=5338 HTTP/1.1" 500 663
>
> ----------
>
> The setup:
> Ubuntu Hardy 8.04 with most recent updates
> Koha 2.2.9
> Apache ID string: "Apache/2.2.8 (Ubuntu) PHP/5.2.4-2ubuntu5.2 with
> Suhosin-Patch Server at 10.0.0.161 Port 80"
> Perl v5.8.8
>
> ----------
>
> So it looks like either Amazon isn't providing some XML file, or the
> request generated by Koha is not correct.
> Either way, I think it's extremely bad that the results of a request
> to an external website (Amazon.com) had the effect of basically
> "crashing" Koha. I think Koha really ought to handle this, though I
> don't actually know if it's something Koha can prevent.
>
>
> So the question is:
> How do I get AWS to work with Koha?
>
> Best regards,
>
> Charles Burns
>
> --
> "Be who you are and say what you feel, because those who mind don't
> matter and those who matter don't mind." --Dr. Seuss

> _______________________________________________
> Koha mailing list
> Koha@...
> http://lists.katipo.co.nz/mailman/listinfo/koha

--
"Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind." --Dr. Seuss

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

[Joe Atzberger]

Yes, the Amazon API changed this spring.  A patch for 2.29 was discussed on the list and released:
   http://lists.katipo.co.nz/public/koha/2008-April/013479.html

Other users report success after applying that.

--Joe Atzberger
LibLime

On Wed, Jul 23, 2008 at 6:07 PM, Magnus Enger <magnus@...> wrote:

Hi!

Looks like you need to provide Koha with two pieces of information in the
preferences: AmazonAssocTag and AWSAccessKeyID (Access Key ID - if you do not
provide this you will not be getiting the Amazon Reviews). See
http://aws.amazon.com/ for info on how to get these.

Regards,
Magnus Enger
collib.info

----- Original Message -----
From: "Charles N Burns" <charlesnburns@...>
To: koha@...
Sent: Tue, 22 Jul 2008 22:33:21 -0600
Subject: [Koha] Koha 2.29, HTTP 500 internal server error with Amazon AWS

> Hello all,
>
> Please cc this email to my email address as I am not subscribed to the
> list. I would subscribe, but I am setting up Koha for a friend's
> community elementary school's library, but have no library of my own.
> :)
>
> Problem is:
> When I enable AWS (Amazon Web Services) with "AmazonContent = 1", any
> attempt to view a book from search is met with the familiar:
>
> "Internal Server Error
>
> The server encountered an internal error or misconfiguration and was
> unable to complete your request."
> (etc.)
>
> An example of a URL that crashes Koha is this:
> http://KOHA_SERVER/cgi-bin/koha/opac-detail.pl?bib=5338
>
> (So the problem seems to be in opac-detail.pl)
>
> ----------
>
> When I execute opac-detail.pl directly in the command line:
>
> # export PERL5LIB=/usr/local/koha/intranet/modules
> # /usr/local/koha/opac/cgi-bin/opac-detail.pl
>
> I get:
>
> could not retrieve
>
http://xml.amazon.com/onca/xml3?t=&dev-t=(My_amazon_qws_id)&type=heavy&f=xml&

> AsinSearch=
> at /usr/local/koha/intranet/modules/C4/Amazon.pm line 64.
> Could not find opac-detail.xml in /usr/local/koha/opac/cgi-bin/ at
> /usr/local/koha/intranet/modules/C4/Amazon.pm line 66
>
> ----------
>
> No log files mention anything special other than the access log, which
> is pretty worthless:
>
> # cat opac-access_log
> (...)
> 10.0.0.196 - - [22/Jul/2008:22:22:25 -0600] "GET
> /cgi-bin/koha/opac-detail.pl?bib=5338 HTTP/1.1" 500 663
>
> ----------
>
> The setup:
> Ubuntu Hardy 8.04 with most recent updates
> Koha 2.2.9
> Apache ID string: "Apache/2.2.8 (Ubuntu) PHP/5.2.4-2ubuntu5.2 with
> Suhosin-Patch Server at 10.0.0.161 Port 80"
> Perl v5.8.8
>
> ----------
>
> So it looks like either Amazon isn't providing some XML file, or the
> request generated by Koha is not correct.
> Either way, I think it's extremely bad that the results of a request
> to an external website (Amazon.com) had the effect of basically
> "crashing" Koha. I think Koha really ought to handle this, though I
> don't actually know if it's something Koha can prevent.
>
>
> So the question is:
> How do I get AWS to work with Koha?
>
> Best regards,
>
> Charles Burns
>
> --
> "Be who you are and say what you feel, because those who mind don't
> matter and those who matter don't mind." --Dr. Seuss
> _______________________________________________
> Koha mailing list
> Koha@...
> http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha

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

[Jesse Weaver-2]

On Wed, Jul 23, 2008 at 4:07 PM, Magnus Enger <magnus@...> wrote:

Hi!

Looks like you need to provide Koha with two pieces of information in the
preferences: AmazonAssocTag and AWSAccessKeyID (Access Key ID - if you do not
provide this you will not be getiting the Amazon Reviews). See
http://aws.amazon.com/ for info on how to get these.

Regards,
Magnus Enger
collib.info

The problem might be more subtle than that. Charles, are you running 2.2.9 (looks like it) ? If so, I made patches a while back for the C4/Amazon.pm module and the opac-detail.pl script, at http://lists.katipo.co.nz/public/koha/2008-April/013479.html .

Best of luck,
Jesse

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