One installation, multiple databases ?

Thursday 24 April 2003 4:47:10 am

Hi,

Is it possible to run several subdomains with one installation but with separate databases ?

I've found http://ez.no/developer/ez_publish_3/documentation/ez_publish_3/howtos/several_sites_with_one_installation but it doesn't mention different databases.

Thursday 24 April 2003 4:49:48 am

To run multiple databases on the same installation you need to configure the site access. The site access is used to separate the different sites. When for each site access you can override all settings, including database configuration.

So all you need to do is to create the proper site access configuration ( info in the manual ) and tune the database settings for that site access. These settings will be placed in e.g.
settings/siteaccess/mynewsite/site.ini.append

--bård

Documentation: http://ez.no/doc

Monday 28 April 2003 1:46:24 pm

> When I try to login to the admin site it gives me an error
> "Kernel. No database connection could be made, the
> system might not behave properly.".

i had that error when i used a fully qualified domain name as <accessname> value for the HostMatchMapItems[] directive. e.g.:

file: Exponential-3.0-1/settings/override/site.ini.append.php

[SiteAccessSettings]
HostMatchMapItems[]=ez3test.vangorkum.com;ez3test.vangorkum.com
HostMatchMapItems[]=admin.ez3test.vangorkum.com;admin.ez3test.vangorkum.com

file: Exponential-3.0-1/settings/siteaccess/ez3test.vangorkum.com/site.ini.append

[DatabaseSettings]
User=ez3test
Password=********
Database=ez3test

that doesn't work and displays above error. it works when i use a shorter name for <accessname> (and rename the subdirectory in siteaccess/)

[SiteAccessSettings]
HostMatchMapItems[]=ez3test.vangorkum.com;ez3test
HostMatchMapItems[]=admin.ez3test.vangorkum.com;admin.ez3test

hth,

jeroen.

Tuesday 29 April 2003 5:49:39 am

correction: after more testing it seems that the connection to the database always fails if it is done from a site.ini.append in a directory that contains a dot in its name.

so, `admin.ez3test.vangorkum.com' in my previous example doesn't work after all; it shows your error. it works if i replace the dot in <accessname> and the subdirectoryname with an underscore:

file: Exponential-3.0-1/settings/override/site.ini.append.php

[SiteAccessSettings]
MatchOrder=host
HostMatchType=map
HostMatchMapItems[]=ez3test.vangorkum.com;ez3test
HostMatchMapItems[]=admin.ez3test.vangorkum.com;admin_ez3test
...

file: Exponential-3.0-1/settings/siteaccess/ez3test/site.ini.append

[DatabaseSettings]
User=ez3test
Password=********
Database=ez3test
...

file: Exponential-3.0-1/settings/siteaccess/admin_ez3test/site.ini.append

[DatabaseSettings]
User=ez3test
Password=********
Database=ez3test
...

configuration details:
* debian GNU/Linux 3 woody
* apache 1.3.26
* php 4.1.2
* mysql 3.23.49
* Exponential 3.0-1

jeroen.

Sunday 15 June 2003 6:38:24 am

Thanks Jeroen

Your setup works on windows too.

axel

http://AlexandreCunha.com