Uppercase table names

["Dave 'Duke of URL' Weiner" <davew@webmast.com>]

Greeting Minivenders!  I'm working on a new minivend project, so once again,
I've subscribed to the list!

Just downloaded and installed MV 3.14 on a Mandrake Linux 6.0 box (Think Red
Hat 6.0 with pentium optimizations, and some improvements to the install
program)

Technical information of the setup before I ask the question:

#uname -a
Linux rocky 2.2.9-19mdk #1 Wed May 19 19:53:00 GMT 1999 i586 unknown

# perl -v

This is perl, version 5.005_03 built for i386-linux

# mysqld -v
mysqld  Ver 3.22.22 for pc-linux-gnu on i686

from catalog.cfg:

ProductFiles JEWELRY BOOKS SOFTWARE APPAREL

Database        JEWELRY jewelry.asc dbi:mysql:mmall:localhost:3306
Database        BOOKS books.asc dbi:mysql:mmall:localhost:3306
Database        SOFTWARE software.asc dbi:mysql:mmall:localhost:3306
Database        APPAREL apparel.asc dbi:mysql:mmall:localhost:3306

Database        JEWELRY USER    xxxx
Database        BOOKS USER      xxxx
Database        SOFTWARE USER   xxxx
Database        APPAREL USER    xxxx

Database        JEWELRY PASS    xxxxxxxx
Database        BOOKS PASS      xxxxxxxx
Database        SOFTWARE PASS   xxxxxxxx
Database        APPAREL PASS    xxxxxxxx

NoImport   JEWELERY BOOKS SOFTWARE APPAREL

You will notice that my table names are in uppercase.  I know the tables are
there:

# mysql -p mmall
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 22 to server version: 3.22.22

Type 'help' for help.

mysql> select * from JEWELRY;
+----------+-------------------+-------+--------+-------------------+-------
----+------+----------------+-------+----------+------+
| code     | description       | price | weight | dial              | band
| size | cord           | metal | fineness | info |
+----------+-------------------+-------+--------+-------------------+-------
----+------+----------------+-------+----------+------+
| WE0001-1 | Hematite Necklace | 24.95 |   1.00 | NULL              | NULL
| NULL | NULL           | NULL  | NULL     | NULL |
| WE0001-2 | Tiger Eye Pendant | 14.95 |   1.00 | NULL              | NULL
| NULL | red,black,blue | NULL  | NULL     | NULL |
| WE0001-3 | Yin/Yang Watch    | 39.95 |   1.00 | brown,black,khaki |
white,tan | NULL | NULL           | NULL  | NULL     | NULL |
+----------+-------------------+-------+--------+-------------------+-------
----+------+----------------+-------+----------+------+
3 rows in set (0.00 sec)

mysql> select * from jewelry;
ERROR 1146: Table 'mmall.jewelry' doesn't exist
mysql>

in the mysql program, it works as expected.....the table name is case
sensitive.  But, when I restart MV, I get:

MiniVend V3.14
Configuring catalog mmall2k...mmall2k config error: Table 'mmall.jewelry'
doesn't exist


mmall2k: error in configuration. Skipping.
mmall2k: config error. Skipping.

I don't see anything in the DBI docs that indicate that table names are
squashed to all lower case, but that seems to be what's happening.  Does MV
do this, and if so, how can it be turned off?  I can rename the tables if I
have to, but I'd rather not.

Thanks in advance!

Dave Weiner
WebMasters, Inc. - www.webmast.com