Re: [mv] Newbie problem starting MiniVend

["Christian J. Müller" <cmueller@polinet.ch>]

******    message to minivend-users from "Christian J. =?iso-8859-1?Q?M=FCller?=" <cmueller@polinet.ch>     ******

I am afraid, my message was not quite clear and possibly not quite
correct either.
As far as I understand SQL settings, products is your SQL table and
minivend is your SQL database.
I think that your DELIMITER should refer to the SQL table and not to the
database minivend. The same applies for the LongReadLen.

It is unusual (but legal) to have tuvwxyz as User ID and Sammy as
Password. 


Oldarnie wrote:
> 
> ******    message to minivend-users from Oldarnie <rbarnold@a-dream.com.au>     ******
> 
> Oldarnie wrote:
> 
> Thanks for the reply Christian,
> 
> No fully understanding the line in question, I will go over it here and perhaps you could correct my understanding
> please.
> 
> Database            products products.asc dbi:mysql:minivend:localhost:3306

This looks OK to me.

> 
> After the database declaration the first "products" indicates a directory and the second "products.asc" a table then
> "dbi" the interface to "mysql" the database program "minivend" is the database "localhost" the host we are connecting
> under and "3306" the socket we are using.

Right.

> 
> Are you saying the the first "products" should be "minivend" instead ?

minivend is the database.

> That "products.asc" should be just "products" and is the table ?

products is the table.


> 
> I am sorry, but I don't understand the structure here, perhaps you could explain please ?
> 
> As for the "username - password" well I know that is OK because I have used it to access MySQL independant of
> minivend, and I don't get any errors, however if I have upset the first line with the "products" etc., then MySQL
> would not know what the username/password related to
> 
> Thanks in advance for you help
> Oldarnie
> > >
> > > ******    message to minivend-users from Oldarnie <rbarnold@a-dream.com.au>     ******
> > >
> > > Oldarnie wrote:
> > >
> > > I have a problem starting MiniVend using MySQL which doesn't make sense,
> > > could someone please help and explain what I am doing wrong.
> > >
> > > This is the database part of my catalog.cfg (with names and id's changed
> > > only):

> > >
> > > Database            products products.asc
> > > dbi:mysql:minivend:localhost:3306
> > > # Not needed unless your database requires a login
> > > Database            minivend USER   tuvwxyz
> > > Database            minivend PASS   sammy
> > > # Set some other parameters
> > > Database            minivend DELIMITER    TAB

!! Database  products DELIMITER TAB

> > > Database            minivend LongReadLen  128

!! Database products LongReadLen 128

> > > # Change some data type definitions
> > > # Database            products COLUMN_DEF   code=VARCHAR(20)
> > > # Database            products COLUMN_DEF   price=VARCHAR(5)
> > > # Database            products COLUMN_DEF   description=TEXT
> > >
> > > And this is the error displayed when trying to start minivend:
> > >
> > > Sent TERM to server on PID 1133.
> > > MiniVend server stopped.
> > > MiniVend V3.14-4
> > > Configuring catalog simple...done.
> > > Configuring catalog winged...Database 'minivend' scalar parameter
> > > 'DELIMITER' redefined.
> > > In line 166 of the configuration file 'catalog.cfg':
> > > Database            minivend DELIMITER    TAB
> > >
> > > webways config error: products: Access denied for user:
> > > 'tuvwxyz@localhost' (Using password: NO)


See whether this persists if the other settings are correct.

I hope I have not created more confusion.  

I hope this helps now.
Chris
-
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