[mv] Newbie problem starting MiniVend

[Oldarnie <rbarnold@a-dream.com.au>]

******    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