Re: SQL not importing

[Dan Busarow <dan@dpcsys.com>]

******    message to minivend-users from Dan Busarow <dan@dpcsys.com>     ******

On Mon, 12 Apr 1999, Russ wrote:
> I am having a problem trying to get my databases to go 'SQL'.  I have mySQL
> on a different machine than minivend.  (Because the other machine is RedHat,
> and mySQL will install on redhat, minivend is on IRIX, and mySQL won't
> install on IRIX).  I'm still searching mySQL docs and minivend docs to see
> what I can find out....
> 
> My catalog.cfg for SQL is this:
> 
> Database  products         products.asc    dbi:mysql:newcb:othermachine:3333
> Database  products         DELIMITER       TAB
> Database  products         COLUMN_DEF      "code=char(20) primary key"
> Database  products         COLUMN_DEF      description=char(254)
> 
> I get this error and the catalog won't work.
> 
> newcb config error: Undefined subroutine &Vend::Table::DBI::create called at
> /ho
> me/minivend/mvend/lib/Vend/Table/Import.pm line 160, <IN> chunk 1.

You're trying to populate your SQL db with data from products.asc?
If so, you'll probably need to add USER and PASS declarations like

# Not needed unless your database requires a login
Database            products USER   you
Database            products PASS   XXXXXX

Unless you have your mysql set to allow drop/create by anonymous users.
The error message also suggests that you have not installed the mysql
client lib on the IRIX box.

Dan
-- 
 Dan Busarow                                                  949 443 4172
 Dana Point Communications, Inc.                            dan@dpcsys.com
 Dana Point, California  83 09 EF 59 E0 11 89 B4   8D 09 DB FD E1 DD 0C 82

-
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