[ic] IC displays first page, but no others

[msquared]

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