Re: Converting Demo to SQL

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

On Wed, 01 Sep 1999, you wrote:
> ******    message to minivend-users from Kyle Hayes <kyle540@quicknet.net>     ******
> 
> 
> Karl,
> 
> Look up the ProductFiles directive.  You have changed the name of the
> product file.  There are some patches available on the mailing list
> archive that track down all the places that hardcode the product file with
> the name "products".
> 
> It would probably be easier to change the name of the table in PostgreSQL
> than in MV unless you are really a wiz with patches :-)
 I did a drop table and edited the create file changing 'products_tbl'
to 'products' before recreating using the \i psql command.  I also edited the
catalog config file and changed all 'products_tbl' to 'products'.  However my
results are still the same on a restart.  I must have something else also
misconfigured.  Thanks very much for your help  
Karl
 
> Best,
> Kyle (KH)
> 
> 
> On Tue, 31 Aug 1999, Swisher, Karl wrote:
> 
> > ******    message to minivend-users from 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
> > -
> > To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> > email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
> > Archive of past messages: http://www.minivend.com/minivend/minivend-list
> > 
> 
> -
> To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list