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 not that much of a SQL guru (only just started to use it myself),
but I think you have two problems:
1: you have defined products as your SQL database, but you tell MV that
the User and Pass is for the database minivend. Do you use a "minivend"
Database at all?
2: Check your User and Pass. I think they are mixed up.

If you do not have a minivend db, then simply replace the two lines
containing minivend by products, replace your User by Pass and
vice-versa and you should be OK. If you do have a minivend db, then you
need to change a few more things...

Chris

Oldarnie wrote:
> 
> ******    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
> ##
> ## Default: products products.asc 1
> #
> # Definition of an arbitrary database, in the form
> # "Database database file type", where "file" is the name of an
> # ASCII file in the same format as the products database.  The
> # file is relative to VendRoot, and is put in DataDir if no
> # path is provided.  Records can be accessed with the
> # [data database field key] tag.
> #
> 
> # Here are some sample product database definitions for various SQL
> # database types. These might even work for you if the SQL package
> # in question has an existing data source with that name -- these
> # may be the defaults in the distributed packages.
> #
> # For mSQL to work you would do:  msqladmin create minivend
> #
> # For mysql to work you would do: mysqladmin create minivend
> #
> 
> 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            minivend 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)
> 
> winged: error in configuration. Skipping.
> winged: config error. Skipping.
> MiniVend server started in INET and UNIX mode(s) (process id 1154)
> 
> It appears that minivend is not passing the "password" through to mysql,
> because mysql is reporting "Using password: NO"
> Also there seems to be a problem defining TAB as a delimiter.
> 
> I have tried commenting out the line in the cfg file regarding the
> delimiter "tab" and I still get the other "Access denied for user"
> error.
> 
> I have double checked the permissions and I can start MySQL outside of
> minivend using the user "tuvwxyz" on "localhost" with the password
> "sammy" and I can do what ever I want with mysql.
> 
> I have granted all privileges to user "tuvwxyz" under MySQL, so this
> user is as good as a superuser.
> 
> I have added MiniVend to the group "tuvwxyz" as well as the group
> "mysql" and set the permissions on the database to allow reads and
> writes for the group.
> 
> I don't know what else to try so perhaps someone could give me some tips
> please
> 
> Thanks in advance
> Oldarnie
> 
> -
> 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