Mailing List Archive

IC displays first page, but no others
Hi!

I've installed the IC 4.6.1 rpm under RedHat 6.2. I'm using Apache 1.3.14
with suexec enabled inside a virtual host.

Clicking on 'Enter as a customer' brings up the main page, but with errors
in the log (see below), and with no new items or specials listed. Any
other links from this main page brings up a page saying "We're sorry, the
Interchange server is unavailable..."


I did a bit of digging, and discovered that accessing the main page
produces two entries in the log file, error.log:

192.168.0.23 XNEfxNf2:192.168.0.23 - [04/January/2001:14:07:22 +0800]
construct /cgi-bin/construct/index.html Could not open error file
error.log: Permission denied
> to report this error: 192.168.0.23 XNEfxNf2:192.168.0.23 -
[04/January/2001:14:07:22 +0800] construct /cgi-bin/construct/index.html
Bad SQL, query was:
> > SELECT sku,timed_promotion,start_date,finish_date
> > FROM merchandising
> > WHERE featured = 'specials'
> >
192.168.0.23 XNEfxNf2:192.168.0.23 - [04/January/2001:14:07:22 +0800]
construct /cgi-bin/construct/index.html Could not open error file
error.log: Permission denied
> to report this error: 192.168.0.23 XNEfxNf2:192.168.0.23 -
[04/January/2001:14:07:22 +0800] construct /cgi-bin/construct/index.html
Bad SQL, query was:
> > SELECT sku,timed_promotion,start_date,finish_date
> > FROM merchandising
> > WHERE featured = 'new'
> >

Note that it seems to be complaining that it can't open error.log. Also
note that this complaint is logged in error.log. Go figure.


Information about my installation:

* OS - RedHat 6.2
* Webserver - Apache 1.3.14 from source with suexec enabled
(also, using a virtual host for this site)
* Interchange - 4.6.1 (rpm version)


Things I did to get it working up to this level of functionality:

* Created a user interchw to use instead of interch for the cgi (suexec
doesn't like executing anything with a uid/gid less than 500 due to
my security-conscious configuration).

* The rpm installs vlink, but according to the documentation this
doesn't work so well with suexec, so I replaced it with tlink.

* Initially, the interchange server was run as interch, and the cgi was
run as interchw. In order to reduce the number of configuration
oddities, the interchange server and the cgi now both run as interchw.
This has not affected the (mis)behaviour of the system.

* The rpm installs the web files under /home/httpd/html and
/home/httpd/cgi-bin. I had to move them to the correct virtual
host directories, which are /home/httpd/interchange/html and
/home/httpd/interchange/cgi-bin.


Summary:

* Some part(s) of the system appears to have problems accessing the error
log.

* The system appears to be having difficulty accessing the database.

Does anyone know how I might solve these issues?


2
Regards, /|/|
/ | (MSquared)
--
___________________________________________
M Squared <msquared@digitalwizards.com.au>
Code monkey (programmer)
Digital Wizards
http://www.digitalwizards.com.au
IC displays first page, but no others [ In reply to ]
sounds like to me your file permissions are not set right. there is a
section in the docs that cover this in making sure you either have interch
as part of your group or you as part of interch group depending on setup. I
have Linux Mandrake and did the tar install. instead of the rpm. It was much
easier for me to control what I wanted Interchange to do on the install and
setup. And than again I may be wrong.

Dan

-----Original Message-----
From: interchange-users-admin@lists.akopia.com
[mailto:interchange-users-admin@lists.akopia.com]On Behalf Of msquared
Sent: Thursday, January 04, 2001 1:46 AM
To: interchange-users@lists.akopia.com
Subject: [ic] IC displays first page, but no others


Hi!

I've installed the IC 4.6.1 rpm under RedHat 6.2. I'm using Apache 1.3.14
with suexec enabled inside a virtual host.

Clicking on 'Enter as a customer' brings up the main page, but with errors
in the log (see below), and with no new items or specials listed. Any
other links from this main page brings up a page saying "We're sorry, the
Interchange server is unavailable..."


I did a bit of digging, and discovered that accessing the main page
produces two entries in the log file, error.log:

192.168.0.23 XNEfxNf2:192.168.0.23 - [04/January/2001:14:07:22 +0800]
construct /cgi-bin/construct/index.html Could not open error file
error.log: Permission denied
> to report this error: 192.168.0.23 XNEfxNf2:192.168.0.23 -
[04/January/2001:14:07:22 +0800] construct /cgi-bin/construct/index.html
Bad SQL, query was:
> > SELECT sku,timed_promotion,start_date,finish_date
> > FROM merchandising
> > WHERE featured = 'specials'
> >
192.168.0.23 XNEfxNf2:192.168.0.23 - [04/January/2001:14:07:22 +0800]
construct /cgi-bin/construct/index.html Could not open error file
error.log: Permission denied
> to report this error: 192.168.0.23 XNEfxNf2:192.168.0.23 -
[04/January/2001:14:07:22 +0800] construct /cgi-bin/construct/index.html
Bad SQL, query was:
> > SELECT sku,timed_promotion,start_date,finish_date
> > FROM merchandising
> > WHERE featured = 'new'
> >

Note that it seems to be complaining that it can't open error.log. Also
note that this complaint is logged in error.log. Go figure.


Information about my installation:

* OS - RedHat 6.2
* Webserver - Apache 1.3.14 from source with suexec enabled
(also, using a virtual host for this site)
* Interchange - 4.6.1 (rpm version)


Things I did to get it working up to this level of functionality:

* Created a user interchw to use instead of interch for the cgi (suexec
doesn't like executing anything with a uid/gid less than 500 due to
my security-conscious configuration).

* The rpm installs vlink, but according to the documentation this
doesn't work so well with suexec, so I replaced it with tlink.

* Initially, the interchange server was run as interch, and the cgi was
run as interchw. In order to reduce the number of configuration
oddities, the interchange server and the cgi now both run as interchw.
This has not affected the (mis)behaviour of the system.

* The rpm installs the web files under /home/httpd/html and
/home/httpd/cgi-bin. I had to move them to the correct virtual
host directories, which are /home/httpd/interchange/html and
/home/httpd/interchange/cgi-bin.


Summary:

* Some part(s) of the system appears to have problems accessing the error
log.

* The system appears to be having difficulty accessing the database.

Does anyone know how I might solve these issues?


2
Regards, /|/|
/ | (MSquared)
--
___________________________________________
M Squared <msquared@digitalwizards.com.au>
Code monkey (programmer)
Digital Wizards
http://www.digitalwizards.com.au

_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users
IC displays first page, but no others [ In reply to ]
On Thu, Jan 04, 2001 at 08:44:55AM -0500, Dan Garwood wrote:

> sounds like to me your file permissions are not set right.

Yeah, that's what I thought, too. I had actually messed about with the
permissions quite a bit to get them working that far, due to Apache/suexec
being (understandably) rather anal retentive about its permissions.

> there is a
> section in the docs that cover this in making sure you either have interch
> as part of your group or you as part of interch group depending on setup. I
> have Linux Mandrake and did the tar install. instead of the rpm. It was much
> easier for me to control what I wanted Interchange to do on the install and
> setup. And than again I may be wrong.

Nah, you were right. :) I ended up doing a tarball installation and it
worked fine. Interchange even correctly interpreted the VirtualHost
containers in my httpd.conf file, making setting up a catalog virtually
effortless.

Nice one, guys! :-)

2
Regards, /|/|
/ | (MSquared)
--
___________________________________________
M Squared <msquared@digitalwizards.com.au>
Product development
Digital Wizards
http://www.digitalwizards.com.au