Converting Demo to SQL

[kswisher@iolinc.net (Swisher, Karl)]

Hello:
     I am trying to convert the products table in the demo base included with
MiniVend into PostgreSQL.  I have read as many faqs & mans as I have found. 
This mail list archive has been most helpful and the main reason I've got
this far.  I'm stalled at this point.  I have catalog configuration problems I
think.  I went through the same errors as someone on this list  until I got the
new DBI and DBD. 

     A restart results in the return of the shell prompt without any shell
error or otherwise report to the shell.  The Minivend server does not start.  I
get this:

MiniVend 3.14
Configuring catalog sample...bash$

  If the sample catalog is commented out the simple catalog configures and
the server starts with no problem.  I have checked the
/var/lib/minivend/error.log.  It says:

- - - [31/August/1999:10:37:26 -400] - - MiniVend 3.14
- - - [31/August/1999:10:37:26 -400] - - Config '_mv_admin' at server startup
- - - [31/August/1999:10:37:26 -400] - - Config 'sample' at server startup

The catalog.cfg code I've changed is below.  After studying some of the posts to
this mailing list archive, I felt this code conformed to theirs.   User  jtbm
is set up in postgres as a user without the need of a password.  I will want to
customize all configs after I get this to work  Table products_tbl already
exists in the database sample in PostgreSQL. This table is populated with the
actual asc demo database.  I have verified this using psql.

Database	products_tbl	products.asc	SQL
Database	products_tbl	DSN		DBI:Pg:dbname=sample:host=localhost:port=5432:user=jtbm
Database	products_tbl	USER		jtbm
Database	products_tbl	COLUMN_DEF	code=char(9)
Database	products_tbl	COLUMN_DEF	description=char(128) 	
Database	products_tbl	COLUMN_DEF	title=char(128) 	
Database	products_tbl	COLUMN_DEF	artist=char(128) 	
Database	products_tbl	COLUMN_DEF	comment=char(128) 	
Database	products_tbl	COLUMN_DEF	display=char(128) 	
Database	products_tbl	COLUMN_DEF	image=char(128) 	
Database	products_tbl	COLUMN_DEF	price=float8
Database	products_tbl	COLUMN_DEF	category=char(128)
Database	products_tbl	COLUMN_DEF	nontaxable=char(3)
Database	products_tbl	COLUMN_DEF	weight=int2
Database	products_tbl	COLUMN_DEF	size=char(128)
Database	products_tbl	COLUMN_DEF	color=char(128)
Database	products_tbl	COLUMN_DEF	related=char(8)

This line made no difference 
# Database	products_tbl	NAME		code description title  artists comment display image price category nontabable weight size color related
Database        	products_tbl	NUMERIC	price 
Database        	products_tbl 	NUMERIC	weight
Database	products_tbl	LongReadLen	128

All the above replaces this line doesn't it ?
#Database            products     products.asc      TAB

Database	products_tbl	INDEX		category

Didn't  believe I change any of this code here.
Database            pricing      pricing.asc       TAB
Database            transactions transactions.txt  TAB
Database            userdb       userdb.asc        TAB
Database            country      country.asc       TAB
Database            locale       locale.asc        TAB
Database            Ground       Ground.csv        CSV
Database            2ndDayAir    2ndDayAir.csv     CSV
Database            NextDayAir   NextDayAir.csv    CSV


What I have  and installed:  (DBD & DBI passed all tests before installation)
MiniVend 3.14
Perl 5.00404
DBD 0.92
DBI 1.13
PostgreSQL 6.5.1
Apache  1.3
Red Hat 5.2
K6-II 350mhz
128MB Ram
Could anyone tell me what I'm doing wrong or point me in the right direction ?

Thanks
Karl
kswisher@iolinc.net