[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: Converting Demo to SQL
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 :-)
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
>
