Re: DBI Perl error.

["Jonathon Spaeth" <jspaeth@mwis.net>]

******    message to minivend-users from "Jonathon Spaeth" <jspaeth@mwis.net>     ******

Mark:

I ran across this error, too, when I was configuring my server.  I found
that Postgres works a little differently than the way minivend is
documented.  Try something like this in your Database line:

Database    products    products.asc    dbi:Pg:connectioin string

where connection string is in the format of a normal postgres connection
string.  For example:

dbname=nameofdatabase user=username password=password host=hostname
port=portnum

This ends up looking like:

Database products products.asc dbi:Pg:host=hostname port=portnum
dbname=database user=username password=password.

Note, all of the fields in the connection string (user, password, hostname,
port, dbname) are optional.  You may use as few or as many as you need.

Jonathon Spaeth



-----Original Message-----
From: Mark Stosberg <mark@summersault.com>
To: Minivend Users <minivend-users@minivend.com>
Date: Monday, December 21, 1998 4:39 PM
Subject: DBI Perl error.


>******    message to minivend-users from Mark Stosberg
<mark@summersault.com>     ******
>
>
>Hello!
>
> I'd like to inquire if anyone has gotten a DBI error like the
>following, or knows what it might be a sympton of.
>
>The error occurs when I restart the server, and looks like this:
>
>- simple config error: Can't locate object method "create_
>table" via package "Vend::Table::DBI" at
>/usr/home/minivend/lib/Vend/Data.pm line 422, <IN> chunk 1.
>
>The file referenced DOES exist and has not been modified. My relevent
>configs from catalog.cfg looks like the following:
>
>#Database            products    products.asc   TAB
>Database            pricing     pricing.asc    TAB
>Database            inventory   inventory.asc  TAB
>Database            userdb      userdb.asc     TAB
>Database            country     country.asc    TAB
>Database            locale      locale.asc     TAB
>Database            Ground      Ground.csv     CSV
>Database            2ndDayAir   2ndDayAir.csv  CSV
>Database            NextDayAir  NextDayAir.csv CSV
>
>Database products products.asc dbi:Pg:minivend:liver.infocom.com:5432
>
>------
>I've verified that DBI is working fine with Postgres on my system, and
>that the hostname
>and port are correct.
>
>I'm using the following software:
>Minivend 3.12
>FreeBSD 2.2.2
>Perl 5.004_04
>DBI-0.93
>
>
>Thanks for any help!
>
>
>   -mark
>http://flip.summersault.com/
>-
>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
>

-
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