[mv] SQL Database Name - Something Other Than test_minivend

["Cameron B. Prince" <cbp@internetexpertsllc.com>]

******    message to minivend-users from "Cameron B. Prince" <cbp@InternetExpertsLLC.com>     ******

Hello,

I am experimenting with migrating MiniVend to a MySQL database.

I have successfully created a new catalog with MySQL support using the
default test_minivend database.

When I try to create a second catalog using a different database name, I am
running into problems.

At first it seems fine:

- - - [21/April/2000:02:28:52 -0500] - - START server (6965) (INET and UNIX)
- - - [21/April/2000:02:28:53 -0500] - - Accepting connections from
localhost|127\.0\.0\.1
- - - [21/April/2000:02:28:53 -0500] - - START server (6989) (INET and UNIX)
- - - [21/April/2000:02:30:54 -0500] - - STOP server (6989) on signal TERM
- - - [21/April/2000:02:31:04 -0500] - - Low traffic settings.
- - - [21/April/2000:02:31:04 -0500] - - Calling MiniMate....
- - - [21/April/2000:02:31:06 -0500] - - Minimate is loaded.
- - - [21/April/2000:02:31:07 -0500] - - MiniVend V4.04
- - - [21/April/2000:02:31:07 -0500] - -
> Using MySQL for databases, DSN=dbi:mysql:test_minivend.
>
- - - [21/April/2000:02:31:08 -0500] - -
> Using MySQL for databases, DSN=dbi:mysql:iellctest.
>
- - - [21/April/2000:02:31:11 -0500] - - START server (7049) (INET and UNIX)
- - - [21/April/2000:02:31:12 -0500] - - Accepting connections from
localhost|127\.0\.0\.1
- - - [21/April/2000:02:31:12 -0500] - - START server (7083) (INET and UNIX)


Then when I try to access the iellc-test catalog I get this:

compaq.internetexperts.com hri2eM4V:internetexperts.com -
[21/April/2000:02:32:13 -0500] iellc-test /cgi/iellc-test
Runtime error: Can't call method "record_exists" on an undefined
value at /usr/local/minivend/lib/Vend/Data.pm line 108.


On this last attempt I created the new catalog using makecat without
answering yes to SQL and then went into the catalog.cfg and configured SQL
there after it was built and working in non-SQL mode.

I restarted Minivend hoping it would create the new database like makecat
did for test_minivend, but it give the error:

- - - [21/April/2000:02:27:01 -0500] - - Low traffic settings.
- - - [21/April/2000:02:27:01 -0500] - - Calling MiniMate....
- - - [21/April/2000:02:27:04 -0500] - - Minimate is loaded.
- - - [21/April/2000:02:27:04 -0500] - - MiniVend V4.04
- - - [21/April/2000:02:27:04 -0500] - -
> Using MySQL for databases, DSN=dbi:mysql:test_minivend.
>
- - - [21/April/2000:02:27:05 -0500] - -
> Using MySQL for databases, DSN=dbi:mysql:iellctest.
>
- - - [21/April/2000:02:27:06 -0500] - - iellc-test config error: DBI
connect failed: Access denied for user: '@localhost' to
database 'iellctest'

- - - [21/April/2000:02:27:06 -0500] - - iellc-test: config error. Skipping.
- - - [21/April/2000:02:27:06 -0500] - - START server (6898) (INET and UNIX)
- - - [21/April/2000:02:27:07 -0500] - - Accepting connections from
localhost|127\.0\.0\.1



So I stopped Minivend and created the database myself:

mysql> CREATE DATABASE iellctest;
Query OK, 1 row affected (0.00 sec)

mysql> show databases;
+---------------+
| Database      |
+---------------+
| iellctest     |
| mysql         |
| test_minivend |
+---------------+
3 rows in set (0.00 sec)


I restarted MiniVend and it populated the database:

mysql> use iellctest
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables
    -> ;
+---------------------+
| Tables in iellctest |
+---------------------+
| area                |
| cat                 |
| country             |
| inventory           |
| orderline           |
| pricing             |
| products            |
| shipping            |
| transactions        |
| userdb              |
+---------------------+
10 rows in set (0.01 sec)


But when I access it:

compaq.internetexperts.com hri2eM4V:internetexperts.com -
[21/April/2000:02:32:13 -0500] iellc-test /cgi/iellc-test
Runtime error: Can't call method "record_exists" on an undefined
value at /usr/local/minivend/lib/Vend/Data.pm line 108.



I have tried many things including coping the database file from
test_minivend to another name and changing the definition in catalog.cfg. I
even hacked the config/precopy file that stores the default database name
makecat uses to create the database and it didn't work either. I grepped all
the minivend directories and searched for places to change test_minivend to
iellctest and it appears that other than those precopy files, the database
name is only defined in catalog.cfg.




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.


Thanks,

Cameron B. Prince



-
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