Mailing List Archive

I've attempted to change a catalog over to mySQL and upon restarting the
catalog get the following error:

Configuring catalog myName...Using MySQL, DSN=DBI:mysql:myName:localhost.
myName config error: connect failed (create) -- Can't connect( myName pwd ),
no database driver specified and DBI_DSN env var not se
t at //usr/lib/interchange/lib/Vend/Table/DBI.pm line 119

There is a database myName. I have been able to create a table in it, and
then read it with a perl script (using DBI/DBD).

I wasn't sure how to set up catalog.cfg, but here is the database part of
it:

Variable MYSQL 1
Database products products.txt SQL
Database products DSN DBI:mysql:myName:localhost
#ifndef SQLDSN
Variable SQLDSN DBI:mysql:myName:localost
#endif
#####
##### MySQL
#####
#ifdef MYSQL
Message Using MySQL, DSN=__SQLDSN__.
# Tell the default DBM we are using something else...
Variable SOME_DATABASE 1
# Uncomment if needed
Variable SQLUSER myName
Variable SQLPASS pwd

The file dbconf/mysql/products.mysql was left as it was (for Construct
demo), except to add weight as a numeric field.

Admin interface says:
Database Interfaces GDBM available (v1.00)
Berkeley DB_File available (v1.65)
DBI enabled (v1.14), available drivers:
ADO
ExampleP
Multiplex
Proxy
mysql

What do I have wrong that Interchange thinks no database driver has been
specified.?

Martin Abell
SpeedSpan