[ic] mySQL problem
Martin Abell
abellmt@spsp.net
Sat, 06 Jan 2001 13:41:50 -0500
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