[ic] Newbie DB question

Ian Eure interchange-users@interchange.redhat.com
Mon May 20 13:18:00 2002


Hi. I'm trying to get Interchange integrated with an existing MySQL database. 
I've got it mostly working, I'm just really confused about these TAB 
databases. I can't seem to get Interchange working without having a TAB 
database, and it will only use N SQL records, where N = the number of records 
in the TAB DB.

It seems completely silly to use a SQL DB, yet be so dependent on a text 
database as well. Am I just misunderstanding, or is Interchange really 
dependent on this TAB DB?

Here's the relevent sections of my catalog.cfg:

-- snip --
Database        products        products.txt    SQL
Database        products        DSN     dbi:mysql:sso
Database        products        USER devel
Database        products        PASS testing
Database        products        COLUMN_DEF "id=int(11) not null default 0"
Database        products        COLUMN_DEF "description=varchar(255)"
Database        products        COLUMN_DEF "price=varchar(255)"
NoImport        products
DynamicData     products
ProductFiles    products
-- snip --

(I also tried turning on VariableDatabase, it had no effect)

Also, can someone point me at some documentation about setting up users for 
the admin interface? I see mention of UserDB in the foundation catalog, but 
not much mention of it in the documentation.

Thanks.