RE: [mv] MySQL setup tutorial??

["Keith Pettit" <keithp@censoft.com>]

******    message to minivend-users from "Keith Pettit" <keithp@censoft.com>     ******

OK I guess I'm being an idiot, but this is very confusing.

I would like to create the catalog using the makecat command but I have a
password on my database.  How can I define what that password is??

I tried changing changing the catalog.cfg of an exisiting cart, but can't
seem to get it to work.

Another question: I installed using the .rpm's and I also installed
MiniMate.  What is the default username/password, or how can I define it?

Thanks again

Keith


->-----Original Message-----
->From: owner-minivend-users@minivend.com
->[mailto:owner-minivend-users@minivend.com]On Behalf Of Cameron B. Prince
->Sent: Monday, June 05, 2000 5:56 PM
->To: minivend-users@minivend.com
->Subject: RE: [mv] MySQL setup tutorial??
->
->
->******    message to minivend-users from "Cameron B. Prince"
-><cbp@InternetExpertsLLC.com>     ******
->
->Hi Keith,
->
->The answer to your question is, it depends...
->
->If you are running MV v4.04 and have MySQL and Perl DBI working with no
->password on the database, Minivend's makecat program will create a simple
->demo running with the majority of the databases configured and running in
->MySQL.
->
->All you must do is answer 1 to Use MySQL while making the catalog.
->
->To add MySQL to an existing catalog, configure the following in
->catalog.cfg:
->
->Variable            SOMESQL      1
->Variable            MYSQL        1
->Variable  SQLDSN   dbi:mysql:database_name
->Variable  SQLUSER  user
->Variable  SQLPASS  password
->
->In my experiences, a username and password MUST be defined if configuring
->MySQL this way. Also watch your permissions on the database user.
->
->The definitions for the tables are found in catroot/mysql
->
->When you restart the minivend daemon, the default text files from
->catroot/products will be imported into MySQL using the definitions. A new
->file will be created in catroot/products for each database called
->database_name.sql
->
->To cause Minivend to re-import the text files, simply remove the
->corresponding .sql and restart the daemon.
->
->Be aware that changes to the databases aren't applied to the text files
->until the databases are exported.
->
->
->Good luck and let us know how it goes...
->
->
->Cameron
->
->
->
->
->-----Original Message-----
->From: owner-minivend-users@minivend.com
->[mailto:owner-minivend-users@minivend.com]On Behalf Of Keith Pettit
->Sent: Monday, June 05, 2000 3:34 PM
->To: minivend-users@minivend.com
->Subject: RE: [mv] MySQL setup tutorial??
->
->
->******    message to minivend-users from "Keith Pettit"
-><keithp@censoft.com>
->******
->
->What about the username:password?  WIll the shopping cart create the
->nessecart tables and fields?  If not is there a file I can use to create
->them or a list of what I need?
->
->Thanks,
->
->Keith
->
->
->->-----Original Message-----
->->From: owner-minivend-users@minivend.com
->->[mailto:owner-minivend-users@minivend.com]On Behalf Of Tewfic Kidess
->->Sent: Monday, June 05, 2000 1:26 PM
->->To: minivend-users@minivend.com
->->Subject: Re: [mv] MySQL setup tutorial??
->->
->->
->->******    message to minivend-users from Tewfic Kidess
->-><tewfic@electradigital.com>     ******
->->
->->all you really need to do is specify the name of the DB in the
->catalog.cfg
->->
->->
->->Database        pricing pricing.asc     dbi:mysql:dbname
->->Database        userdb  userdb.asc      dbi:mysql:dbname
->->
->->
->->
->->
->->-
->->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
->

-
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