[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] 2 cart with one userdb
> 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
_/ _/ _/_/_/_/ _/ _/_/_/ _/ _/