RE: Setting up Mysql Part I

[Darren Littlejohn <darrenl@cats.ucsc.edu>]

******    message to minivend-users from Darren Littlejohn <darrenl@cats.ucsc.edu>     ******

Dan,

I commented out the default products.asc file and uncommented the mysql dbi
line, created
a database called minivend in mysql, and restarted minivend. To my
surprise, minivend AUTOMATICALLY created the products database in Mysql!
That's all super groovy and everything, but I don't have the slightest clue
as to how it happened. Here's the point where I'm at now: I've been working
on this for 2 weeks, and am still at a loss for
how to make my own database work with minivend. The docs are very
confusing. But at least now I know that all the components are working
together, ie Perl, DBI, Apache, Mysql, and Minivend. That was hard enough!
Now my goal is to be able to add fields to the existing products database
that was autocreated off the demo template, and to figure out how that
connects to the actual HTML page, and what I put in the HTML\MV page to
make it access the new Mysql fields. 


Am I making this too hard? Normally I can kick butt on new things, but this
one's been very difficult. Do you have any tips?

-d-



>> Then do I assume I'd need a whole set of these for each table in the
>> database?
>> 
>>  for example:
>> 
>>   Database   publishers.csv  dbi:mysql:minivend:localhost:3333
>>   Database   publishers  USER          mike
>>   Database   publishers  PASS          NeVairBE
>>   Database   publishers  DELIMITER     CSV"
>
>Just one instance of USER and PASS and don't use DELIMITER at all
>(unless you are really using publishers.csv)  You may not even
>need USER and PASS, depends on how you've setup mysql access controls.
>The default entries for mysql allow selects from a null user on localhost.
>
>Dan
>-- 
> Dan Busarow                                                  949 443 4172
> Dana Point Communications, Inc.                            dan@dpcsys.com
> Dana Point, California  83 09 EF 59 E0 11 89 B4   8D 09 DB FD E1 DD 0C 82
>
>

-
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