[ic] Interchange & PostgreSQL - More detail

[interchange-users@interchange.redhat.com (Andrew Lietzow)]

See below... 
On Tuesday 14 May 2002 02:47 pm, you wrote:
> I installed from the tarball, following the README.  Ran makecat - took
> a couple of times through to figure out what the options were :(  Now
> when I start interchange (bin/interchange -r) I get the output below.  I
> imagine it's something that should be obvious, but I don't see it.
>
> Any help appreciated..
> Mike
> --------------------------------
>
> Low traffic settings.
> Calling UI......UI is loaded...
> Interchange V4.8.5
> Configuring catalog foundation...Using PostgreSQL,
> DSN=dbi:Pg:dbname=foundation...table 'country' failed: DBD::Pg::db
> table_info failed: ERROR:  No such attribute or function 'objsubid' at
> /home/wcs1459/interchange/lib/Vend/Table/DBI.pm line 495.
>
> table 'gift_certs' failed: DBD::Pg::db table_info failed: ERROR:  No such
> attribute or function 'objsubid' at
> /home/wcs1459/interchange/lib/Vend/Table/DBI.pm line 495.
>
> table 'userdb' failed: DBD::Pg::db table_info failed: ERROR:  No such
> attribute or function 'objsubid' at
> /home/wcs1459/interchange/lib/Vend/Table/DBI.pm line 495.
>
> table 'options' failed: DBD::Pg::db table_info failed: ERROR:  No such
> attribute or function 'objsubid' at
> /home/wcs1459/interchange/lib/Vend/Table/DBI.pm line 495.
>
> table 'affiliate' failed: DBD::Pg::db table_info failed: ERROR:  No such
> attribute or function 'objsubid' at
> /home/wcs1459/interchange/lib/Vend/Table/DBI.pm line 495.
>
> table 'cat' failed: DBD::Pg::db table_info failed: ERROR:  No such
> attribute or function 'objsubid' at
> /home/wcs1459/interchange/lib/Vend/Table/DBI.pm line 495.
>
> table 'pricing' failed: DBD::Pg::db table_info failed: ERROR:  No such
> attribute or function 'objsubid' at
> /home/wcs1459/interchange/lib/Vend/Table/DBI.pm line 495.
>
> table 'state' failed: DBD::Pg::db table_info failed: ERROR:  No such
> attribute or function 'objsubid' at
> /home/wcs1459/interchange/lib/Vend/Table/DBI.pm line 495.
>
> table 'area' failed: DBD::Pg::db table_info failed: ERROR:  No such
> attribute or function 'objsubid' at
> /home/wcs1459/interchange/lib/Vend/Table/DBI.pm line 495.
>
> table 'merchandising' failed: DBD::Pg::db table_info failed: ERROR:  No
> such attribute or function 'objsubid' at
> /home/wcs1459/interchange/lib/Vend/Table/DBI.pm line 495.
>
> table 'orderline' failed: DBD::Pg::db table_info failed: ERROR:  No such
> attribute or function 'objsubid' at
> /home/wcs1459/interchange/lib/Vend/Table/DBI.pm line 495.
>
> table 'inventory' failed: DBD::Pg::db table_info failed: ERROR:  No such
> attribute or function 'objsubid' at
> /home/wcs1459/interchange/lib/Vend/Table/DBI.pm line 495.
>
> table 'order_returns' failed: DBD::Pg::db table_info failed: ERROR:  No
> such attribute or function 'objsubid' at
> /home/wcs1459/interchange/lib/Vend/Table/DBI.pm line 495.
>
> table 'transactions' failed: DBD::Pg::db table_info failed: ERROR:  No such
> attribute or function 'objsubid' at
> /home/wcs1459/interchange/lib/Vend/Table/DBI.pm line 495.
>
> table 'products' failed: DBD::Pg::db table_info failed: ERROR:  No such
> attribute or function 'objsubid' at
> /home/wcs1459/interchange/lib/Vend/Table/DBI.pm line 495.
>
> foundation config error: products not a database, cannot use as products
> file
>
>
> foundation: error in configuration. Skipping.
> foundation: config error. Skipping.
> Interchange server started in INET and UNIX mode(s) (process id 8548)
>
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users

I'm not certain about PostgreSQL but I can tell you about mySQL.  Usually, 
when I get a listing like this it means IC can't connect to the DB server.  
Why?  Because I've forgotten to start it or it's stop running for some 
reason. 

Check to make sure you can access Postgres from the command line.  

Or, with mysql I issue the command 
ps -elf | grep mysql 
to make sure the mysqld is running.   

HTH,

-- 
Andrew Lietzow               
The ACL Group, Inc.