RE: [mv] SQL Database Name - Something Other Than test_minivend (SOLVED)

[Cameron Prince <PRINCECB@novachem.com>]

******    message to minivend-users from Cameron Prince <PRINCECB@novachem.com>     ******

Greetings all,

After banging my head for several hours now, I decided that integrating
MiniVend with MySQL couldn't be this hard. I deleted the test catalog and
started over.

1) Made new catalog using makecat with MySQL support = 1
2) Restarted MiniVend and loaded simple demo in browser
3) Logged into MySQL and verified test_minivend database
4) Changed a few values in the database manually and verified in browser
5) Stopped MiniVend and MySQL
6) Renamed database /var/lib/mysql/test_minivend to
/var/lib/mysql/iellc_test
7) Edited Variable  SQLDSN   in catalog.cfg
8) Started MySQL and then MiniVend
9) Loaded simple demo home page in browser and got ERROR 500 - Internal
Server Error

Also got this in error.log:

Runtime error: Can't call method "record_exists" on an undefined value at
/usr/local/minivend/lib/Vend/Data.pm line 108.

After almost breaking my keyboard, I decided to try again...

I followed exactly the same steps but this time I set a password on the
database using mysqladmin before I changed the name of the database and IT
WORKS!

So for those of you out there that want to take on MySQL, BE SURE TO SET A
PASSWORD BEFORE GIVING THE DATABASE A NEW NAME.

Maybe I was naive for not setting a password initially, but I am only
testing and it wasn't blatantly obvious. And what I don't understand is how
the test_minivend database worked without a password.



Cameron



 -----Original Message-----
From: 	owner-minivend-users@minivend.com
[mailto:owner-minivend-users@minivend.com]  On Behalf Of Dan Busarow
Sent:	Friday, April 21, 2000 11:41 AM
To:	minivend-users@minivend.com
Subject:	Re: [mv] SQL Database Name - Something Other Than
test_minivend

******    message to minivend-users from Dan Busarow <dan@dpcsys.com>
******

On Fri, 21 Apr 2000, Cameron B. Prince wrote:
> It's as if Minivend only wants to talk with SQL if the database is named
> test_minivend.
> 
> Can someone point me in the right direction here?
> 
> I must have two catalogs, one for live and the other for development.

I haven't seen the error message you're getting, so I can't tell you
for sure what the problem is.  But I'd go through catalog.cfg line
by line comparing the one that works and the one that doesn't.

Minivend happily talks to multiple databases, and you can run
multiple catalogs from a single database as well (in case you
just can't figure your problem out).

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