[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [mv] Newbie problem starting MiniVend
****** 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
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.
Are you saying the the first "products" should be "minivend" instead ?
That "products.asc" should be just "products" and 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
"Christian J. Müller" wrote:
> ****** 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
-
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
