Forums / Install & configuration / Single Database, Single Publish Domain, Multiple Client Domains

Single Database, Single Publish Domain, Multiple Client Domains

Author Message

Kevin Landers

Friday 05 December 2003 2:35:28 pm

Hey guys,

Forgive me if I have missed something in another post previous to this posting. Exams and lack of sleep aren't exactly helping me in understanding this product.

Here is what I would like to do:

I would like to implement a single Postgres database for all eZ-publish sites.

I would like to offer a http://publish.bezaleel.net domain that all my clients could login to with their username and password and gain access to only their content, templates, etc. I would want them to have complete access to THIER site, but not any access to anyother client's website information.

From this database, I would like each client to have their own full domain name. www.whatever.com
I would like for this domain not to have to have all the eZ-publish install files sitting around in the httproot directory. I would prefer to use this so that updating eZpublish would be simplistic and spontaeneous. I do not care whether a client did not wish to upgrade, they would all upgrade.

Another note is that we have our own server and do NOT use virtual hosting, instead we assign each domain an IP number. I am not sure whether this will affect eZ-publish in any way.

Well, I would simply ask for your guidance and direction in determining whether eZ-publish will accomplish the above or not.

And if not, are there any suggestions to software that will support the above requests?

All help is appreciated!

Kevin L.

Marco Zinn

Saturday 13 December 2003 11:33:07 am

Hi Kevin,
i didn't do this, but ez3 was designed to do a lot of this.
You can have multiple VHosts (or IPs, in your case) be handled by one single ezPublish installation (the files are there just once).
Then you will need to create at least two siteaccesses for each customer (one for "user", one for "admin").
I would suggest one unique MySQL DB per customer, which those two siteaccesses will use.
Then, you will probably need one "Design" per customer (or two, if you want to allow them to change the admin Design). "Design" will be assigned to the siteaccess, too and will take care of the Templates.
This should get you going more or less.

Notes:
- I don't know, if anyone tried this yet
- I'm not sure, if/how you can permit the customers to change Designs, which are not theirs, especially the "Standard" Design, which is the fallback for everyone
- Maybe it's even possible to use just one "big" MySQL, but i would not recommend this at all.

See the documentation about "siteaccesses" to give you some more background info and let's hope, that someone already did, what you want to do (you wish is not so extraordinary ;) )

PS: Sorry, I'm using MySQL. Read "Postgres" ;)

Marco
http://www.hyperroad-design.com

Kjell Andersen

Thursday 08 January 2004 5:21:44 am

Hi, Kevin
If I understood your problem right I just did more or less what you wanted to do.

I have two different domains using the same db (MySQL) but with different designs. I use Virtual hosting, but everything else seems quite similar.

What did I do:

Create a design directory for each site, just like the doc. tells you.

In the settings/siteaccess you create a "site" and "site_admin" directory for each site and you just specify the same db in each site.ini.append file.

In settings/override i modified the the "site.ini.append.php" file to

[SiteSettings]
DefaultAccess=site1
SiteList[]=site1
SiteList[]=site2

[SiteAccessSettings]
CheckValidity=false

MatchOrder=host
HostMatchType=map

HostMatchMapItems[]=www.site1.com;site1
HostMatchMapItems[]=admin.site1.net;site1_admin
HostMatchMapItems[]=www.site2.com;site2
HostMatchMapItems[]=admin.site2.org;site2_admin

The you just have to create forlders, sections and usergroups for each site and give limited access to each site administrator.

Kjell

eZ debug

Timing: Jan 19 2025 01:06:27
Script start
Timing: Jan 19 2025 01:06:27
Module start 'content'
Timing: Jan 19 2025 01:06:28
Module end 'content'
Timing: Jan 19 2025 01:06:28
Script end

Main resources:

Total runtime1.1195 sec
Peak memory usage4,096.0000 KB
Database Queries196

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0071 589.3281180.7891
Module start 'content' 0.00710.8915 770.1172588.1875
Module end 'content' 0.89860.2209 1,358.3047336.7188
Script end 1.1195  1,695.0234 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00510.4526210.0002
Check MTime0.00210.1848210.0001
Mysql Total
Database connection0.00070.065610.0007
Mysqli_queries1.032192.18961960.0053
Looping result0.00240.21211940.0000
Template Total1.083496.820.5417
Template load0.00290.258620.0014
Template processing1.080596.512220.5402
Template load and register function0.00030.023610.0003
states
state_id_array0.00130.111910.0013
state_identifier_array0.00150.133220.0007
Override
Cache load0.00260.2297520.0000
Sytem overhead
Fetch class attribute can translate value0.00130.116940.0003
Fetch class attribute name0.00130.118340.0003
XML
Image XML parsing0.00090.080440.0002
class_abstraction
Instantiating content class attribute0.00000.000740.0000
General
dbfile0.00380.3401270.0001
String conversion0.00000.000630.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
3content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
9content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
8content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 23
 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs