[ic] mySQL problem

[Martin Abell <abellmt@spsp.net>]

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


_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users