Re: [mv] Minivend3.14/MySQL Problem

[Dan Busarow <dan@dpcsys.com>]

******    message to minivend-users from Dan Busarow <dan@dpcsys.com>     ******

On Mon, 24 Apr 2000, OTR Comm wrote:
> Okay, I give up!  What do I have to do to get MV3.14 working with MySQL?
> 
> First I created a test database in MySQL called minivend314.  For
> testing, I do not require a username or password.
> 
> Then I commented out the references to products.asc in my catalog.cfg,
> i.e.;
> 
> #Database            products     products.asc      TAB
> #Database            products     INDEX             category
> 
> Then I uncommented the MySQL reference, i.e.;
> 
> Database            products products.asc dbi:mysql:minivend314
> 
> and changed one of the references like so,
> 
> Database            products COLUMN_DEF   code=char(20), code=NOT NULL
> 
> Now when I restart minivend I get:
> 
> ...
> ...
> ...
> Configuring catalog store...store config error: Table
> 'minivend.products' doesn't exist
> 
> 
> store: error in configuration. Skipping.
> store: config error. Skipping.
> ...
> 
> Notice that Minivend is referring to 'minivend.products', when I told it
> to use minivend314.  So I dropped minivend314 from MySQL and created
> minivend (mysqladmin create minivend) and I get the same error.
> 
> Does anyone know what is going on here?

Couple of possibilities.  You need to have DBI and DBD::mysql installed.
Also you need an entry in your mysql grant tables for the USER specified
in catalog.cfg that gives him create privs.

> I get the same error if I try to build the pricing table!
> 
> Also, where in the MV code are the tables created and I can look to see
> how the tables are created initially?

Should be in lib/Vend/Table/DBI.pm

You could also create the tables yourself and then use a read only
anonymous entry in the mysql.user grant table for minivend.

Dan
-- 
 Dan Busarow                                                  949 443 4172
 Dana Point Communications, Inc.                            dan@dpcsys.com
 Dana Point, California  83 09 EF 59 E0 11 89 B4   8D 09 DB FD E1 DD 0C 82

-
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