Re: [Openinteract-help] additional OI websites on a single server - DB question

[Chris W. <ch...@cw...>]

On Fri, 2002-11-08 at 11:04, Chris McDaniel wrote:
> I was wondering if it is possible to have a second OI website use the same
> database as the first. Is this possible?

Yes, although there is one catch with security. If you have the security
information (table: sys_security) for 2+ separate websites in separate
databases you will have problems unless you create some sort of
synchronization mechanism. (I think this is doable, but a pain, if
you're interested.)

But if you have security centralized in the one database you shouldn't
have any problems.

You can also use multiple databases in a single server. To do this you
need to define multiple datasources and then in the object configuration
specify the datasource you want to use. It's easiest to do this in the
global override configuration:

$WEBSITE_DIR/conf/override_spops.ini:

[user.datasource]
action = add
value  = UserDatasource

$WEBSITE_DIR/conf/server.ini:

[db_info UserDatasource]
db_owner      =
username      = user
password      = password
dsn           = dbname=userdb
db_name       =
driver_name   = Pg
sql_install   =
long_read_len = 65536
long_trunc_ok = 0

Hope this helps,

Chris

-- 
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.