Forums / Install & configuration / Clustering 4.3 on Windows 2000 Server. Is it possible ?

Clustering 4.3 on Windows 2000 Server. Is it possible ?

Author Message

Adam Butler

Tuesday 03 August 2010 6:55:27 am

Hi

We have made several attempts to get Ez publish 4.3 running using clustering on

PHP 5.2.5 (cli) (built: Nov 8 2007 23:18:51)
Windows 2000 Server [Version 5.2.3790]
Apache/2.2.8 (Win32)
MySql 5.0.51

All our attempts have failed in one way or another , has anyone actually got 4.3 working with clustering or are we wasting our time ?

If you have and can let us have any advice which will get us up and running
or can point in the direction of some documentation that would be much appreciated.

Thanks in advance

Bertrand Dunogier

Tuesday 03 August 2010 12:00:36 pm

I see no reason why it wouldn't work, as simple as that. Not optimal, but this would work, I think. How many servers do you have in mind ?

Depending on the expected traffic, you might wanna look carefully into the performances of your setup, and tune it accordingly... the knowledge about software optimization for windows might not be very very heavy in the community though, but it's worth a try :)

Bertrand Dunogier
eZ Systems Engineering, Lyon
http://twitter.com/bdunogier
http://gplus.to/BertrandDunogier

André R.

Tuesday 03 August 2010 1:00:06 pm

> are we wasting our time ?

IMHO yes. eZ Publish as well as php and Apache performs best on linux, so you would need less invested time getting it to run smoothly there. MS has been serious about getting PHP to work good on Windows the last few years though, so PHP 5.3+, WinCache, IIS 7+ and FastCGI should perform pretty decent(but yes, you'll optimally need Windows 2008). MySQL is another story though, MS does not spend lots of effort on it unlike PHP, so best SQL server on Windows would be SQL Server, but we don't have anything officially supported for that.

Having said that, I also have to back up what bd says, "it should work", but we have not tested it or documented how to set it up, hence why you won't find it among certified / approved platforms: http://ez.no/ezpublish/requirements

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

Adam Butler

Wednesday 04 August 2010 12:52:38 am

The problem we have had is that when following the instructions in the technical manual we get to the step for setting up the clustering and try running clusterize.php this comes back with an error

This then causes an error which breaks the whole site

D:\inet\http\oagaviation.com\ezpublish>php bin\php\clusterize.php -s eng
This script will now copy your files and/or images to database.
You have 10 seconds to break the script (press Ctrl-C).
This 1mClustering settings specified incorrectly or the chosen file handler is ezfs.

With error "Class 'ezdb' as defined in setting file.ini [ClusteringSettings] FileHandler could not be autoloaded. Did you remember to run bin/php/ezpgenerateautoloads.php after you added extension(s)?" in var/log/error.log

We have the ezdb class referenced in the autoload\ezp_kernel.php file so the system should be able to find it

When you try to access any page within the default site from a web browser we get a "Unexpected error, the message was : Access to non-public constructor of class eZDB in D:\inet\http\oagaviation.com\ezpublish\lib\ezutils\classes" in the var/log/error.log

We have had clustering work in version 4.2 on windows using ezdb as the filehandler and mysql as the db.

Bertrand Dunogier

Wednesday 04 August 2010 2:50:49 am

I'm having a few doubts here... could you paste your file.ini override right here please ?

Thanks.

Bertrand Dunogier
eZ Systems Engineering, Lyon
http://twitter.com/bdunogier
http://gplus.to/BertrandDunogier

Adam Butler

Wednesday 04 August 2010 3:17:11 am

hi Bertrand

ezpublish\settings\override\file.ini.append.php

is as below with obvious changes for sensitive data

<?php /* #?ini charset="utf-8"?
[ClusteringSettings]
FileHandler=ezdb
DBBackend=mysql
DBHost=host.address
DBPort=3306
DBSocket=
DBName=database_name
DBUser=user_name
DBPassword=password
DBChunkSize=65535
*/ ?>

I have checked the cluster db is the same db as used for the instance of ez publish and so is accessible using host config / credentials

Adam Butler

Wednesday 04 August 2010 3:44:18 am

We have had an experiment using the

FileHandler=eZDBFileHandler
DBBackend=eZDBFileHandlerMysqlBackend

settings

This has allowed us to import the content into the db , however the default eng site looks ok , but the admin site is not finding either it's javascript or css files.

The files are linked in the admin home / post login page as

http://xxx.xxx.xxx.xxx.xxx/var/ezflow_site/cache/public/stylesheets/3e08b22e788f030c151caf0bcba0277f_all.css
and

http://xxx.xxx.xxx.xxx.xxx/var/ezflow_site/cache/public/javascript/073908696c0ced15f702f77c93154ca9.js

I have also noticed that when running the clusterize script it's only indexing to var/ezflow_site/storage/ regardless of which -s option we give it

This where we we're a couple of days ago.

Update - I have just cleared the cache and now the defult eng site is missing both css and js files - have re-run the clusterize script but this has had not effect.

Bertrand Dunogier

Wednesday 04 August 2010 5:34:00 am

The configuration you have experimented with is the correct one. We now use class autoloading, and therefore require class names to be used instead of handler names.

Your problem is a different one; ezjscore requires specific cluster rewrite rules in order to serve packed CSS & JS files. See this issue for a solution: http://issues.ez.no/16456.

P.S. You would have experienced the exact same issue on linux. You can also find some details about that on the official online doc: http://ez.no/doc/ez_publish/technical_manual/4_x/features/clustering/setting_it_up_for_an_ezdfsfilehandler#eztoc109664_7.

Bertrand Dunogier
eZ Systems Engineering, Lyon
http://twitter.com/bdunogier
http://gplus.to/BertrandDunogier

Adam Butler

Wednesday 04 August 2010 5:56:24 am

Merci Bertrand ,

That seems to have fixed the issue. We'll try running it in development and see how things go.

Thanks Again

Adam

Bertrand Dunogier

Wednesday 04 August 2010 7:11:26 am

Could you set the thread's status to resolved then ? :-)

Bertrand Dunogier
eZ Systems Engineering, Lyon
http://twitter.com/bdunogier
http://gplus.to/BertrandDunogier