[ic] Custom Database defaulting to gdbm (Sql-Ledger)
batschelet at exactasphere.com
Sat Nov 1 20:31:36 EST 2003
----- Original Message -----
From: "Sam Batschelet"
> > Hi List,
> > I have a small database that I am trying to integrate with a 3rd party
> > accounting system (Sql-Ledger). The scripts seems to be working fine as
> > database is populated but here is my problem its in the wrong format the
> > database is defaulting to .gdbm.
> > So my question is how do I get this database to connect to the pgsql.
> > now it is defaulting to the default database gdbm so I must be missing a
> > flag somewhere to have the database written to sql instead of dbm,
> > having the customer.pgsql file setup alleviate that? Any help on this
> > be great.
> Ok I have isolated the problem I think......when I restart intrechange now
> get an error DBI.pm error. This is after I have removed the customer
> database and I'm trying to get interchange to rebuild it.
> I adjusted my customer.pgsql and combined the sql-ledger database and the
> interchange database so they are the same, and they both use the same user
> and pass. Now there must be something in here that interchange doesn't
> but I can't put a finger on it.
Well slow but sure here I have Interchange aleast reading the headers in the
customer.txt file as well as the customer.pgsql. But now it won't actually
create the database it just goes through the motions and errors out. I know
I'm close but if anyone has any pointers it would be great. The change that
seemed to make things move atleast more than it has was move the EOR to the
end of the catalog.cfg as seen below. More info to come I'm sure....
Database customer customer.txt dbi:Pg:dbname=exactasphere
Configuring catalog ledger...Using PostgreSQL,
DSN=dbi:Pg:dbname=exactasphere...table customer created: create table
id VARCHAR(35) DEFAULT 'nextval('id'::text)' NOT NULL,
creditlimit TEXT DEFAULT '0',
terms SMALLINT DEFAULT '0',
table customer index failed: ERROR: Relation "customer" does not exist
table 'customer' failed: list_fields execute on customer: ERROR: Relation
"customer" does not exist at /usr/local/interchange/lib/Vend/Table/DBI.pm
More information about the interchange-users