[ic] ic + postgres newbie problems

[interchange-users@icdevgroup.org (Richard Barrington)]

Hi List.

I'm having problems getting the foundation store running under Debain
3.0, Interchange 4.8.4, and PostgreSQL 7.2.1. It all "just works" using
DBM, however with Postgresql, what I found was lots of errors like:

- - - [11/October/2002:01:32:10 +3700] - - table 'products' failed:
DBD::Pg::st execute failed: ERROR:  Relation "products" does not exist
at /usr/lib/interchange/Vend/Table/DBI.pm line 1370.

This appears to go away when changing, say, products.pgsql from
"Database products products.txt __SQLDSN__" to "Database products SQL"
and adding a DSN line below, but doing so introduces an error of:

192.168.0.1 RpeuGLA5:192.168.0.1 - [11/October/2002:00:53:32 +3700]
foundation /cgi-bin/ic/foundation/ search error: your search file a
valid database reference, was 'SQL'.

It's accompained by an Apache 1.3.26 server error:

192.168.0.1 - - [11/Oct/2002:00:33:47 +1300] "GET
/cgi-bin/ic/foundation/index.html HTTP/1.0" 500 599 "-" "Mozilla/5.0
(X11; U; Linux i686; en-US; rv:1.0.0) Gecko/20020606"

[Fri Oct 11 00:53:32 2002] [error] [client 192.168.0.1] Premature end of
script headers: /usr/lib/cgi-bin/ic/foundation

Obviously something is misconfigured, but as a newbie, I'm having
troubles finding it...

Any pointers?

Richard.