[ic] 2 cart with one userdb

Kevin Walsh interchange-users@interchange.redhat.com
Wed Apr 3 10:10:01 2002


> I'm not explain well my problem.
> I want to have 2 differents catalogs using only one shared userdb table.
> Where can I tell to ic to use a different userdb table for the catalog?
> I use PgSQL.
> Very sorry for my english.
>
:-)

The Foundation demo has a file called dbconf/pgsql/userdb.pgsql.
Edit that file and change the __SQLDSN__ to point to your shared
userdb table, possibly in a shared database.  Also change the
__SQLUSER__ and __SQLPASS__ markers to set the username and
password you will be using.

If you don't want to hard-code the DSN/USER/PASS into that file
then change the markers to something like __USERDB_DSN__,
__USERDB_USER__ and __USERDB_PASS__, and then add three
lines to your catalog.cfg to define the variables:

    Variable USERDB_DSN  dbi:Pg:dbname=whatever
    Variable USERDB_USER kevin
    Variable USERDB_PASS abc123

You can define the variables in your products/variable.txt file
instead, if you wanted to.

Once you have done that, reconfig the affected sites (Apply changes
in the Admin UI) or restart Interchange.

-- 
   _/   _/  _/_/_/_/  _/    _/  _/_/_/  _/    _/
  _/_/_/   _/_/      _/    _/    _/    _/_/  _/   K e v i n   W a l s h
 _/ _/    _/          _/ _/     _/    _/  _/_/    kevin@cursor.biz
_/   _/  _/_/_/_/      _/    _/_/_/  _/    _/