Re: [Zope] Zope 2.6.4 + Win32 server

2007-02-21 Thread Philip Kilner

Hi David,

David VanKirk wrote:

I'm trying to migrate from a Linux server with Oracle to a win32
server with MS SQL Server.  I need to run it behind a webserver so
that I can connect through SSL.

I've tried IIS, Apache + PCGI, and Apache + FastCGI.

Has anyone been able to successfully run a Zope + win32 Web Server
successfully, that can help.



I run Zope behind Apache on Windows for several projects, some with MS 
SQL server. I'm very happy using Zope behind Apache on Windows, and have 
always been happy with the standard setup - never had to use PCGI or 
FastCGI. I also use Zope  Plone (in the form of Enfold Server) behind 
IIS in one case, but frankly the IIS aspect is not one I am 100% happy with.


What problems are you having?

Do you actually need PCGI/FastCGI?


--

Regards,

PhilK

'let's hear it for the vague blur'
___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
http://mail.zope.org/mailman/listinfo/zope-announce

http://mail.zope.org/mailman/listinfo/zope-dev )


Re: [Zope] Zope 2.6.4 + Win32 server

2007-02-21 Thread Philip Kilner

Hi David,

Please stay on the list - have added back in as CC.

David VanKirk wrote:

I was under the impression that you needed PCGI or FastCGI to get Zope
and Apache to communicate.

If you have another method, I'm open to try it.



No, not at all - in fact FastCGI at least is deprecated in current versions.


Just be informed that I'm using an older version of Zope (2.6.4) so if
there have been advancements that have been made since then with
communicating with Apache, I'm not able to use those.



Well, if you need Apache or IIS for SSL support, and you do not need to 
have SSL for the link between Apache and Zope, then there is nothing 
exotic at all involved. There are 3rd party solutions to use IIS (which 
cannot proxy on its own), but Apache is all you need.


The Zope book has the gist here: -

http://www.plope.com/Books/2_7Edition/VirtualHosting.stx

That's the latest version, but the version on the Zope site is for 2.6, 
and as you can see little has changed: -



http://www.zope.org/Documentation/Books/ZopeBook/2_6Edition/VirtualHosting.stx

The gist is: -

- Zope serves over HTTP.
- Apache can /proxy/ HTTP.
- The Zope Virtual Host Monster can rewrite the URLs generated by Zope 
to those required to pass the traffic through Apache.


You don't need to do anything on the Zope side other than ensure that 
the VHM is present - all the work is done by a rewrite rule in the 
Apache virtual hosts setup. The rewrite rules can be fiddly, and a great 
resource is the Rewrite Rule Witch: -


http://betabug.ch/zope/witch

I've mainly done this with Apache 2.0.x, but I have used the same basic 
setup under 1.3.x - I can't recall if there were any great differences, 
but I still have one running server with 1.3.x on it, so I should be 
able to help either way.


Can I suggest that you read up and have a play, and come back with any 
specific questions?


I found the rewrite rules very fiddly at first, but soon got used to 
them - you might need some patience to get to grips with that part, but 
that's the only bit that caused me any pain.


You don't say how you will be connecting Zope to MS SQL Server, but I 
can recommend the eGenix ODBC DA - it's not free, but it's not expensive 
either, and if you value your time at all it's cheaper and safer than 
doing it any other way...


HTH!


--

Regards,

PhilK

'let's hear it for the vague blur'
___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
http://mail.zope.org/mailman/listinfo/zope-announce

http://mail.zope.org/mailman/listinfo/zope-dev )


Re: [Zope] Zope 2.6.4 + Win32 server

2007-02-21 Thread Philip Kilner

Hi David,

Once again, please stay on the list - you need to hit reply to all.

David VanKirk wrote:

I appreciate your help and links, but I'm still not getting anything.



I did say it was fiddly!

I've go to get some urgent stuff out of the way, but I'll have some 
time	 later and will do a fully worked example.


In the meantime...


I enabled the proxy_module to use with the P option on the rewrite rule.

I've also added the following line to my VirtualHost section:

RewriteRule ^($|/.*)
http://127.0.0.1:8080/VirtualHostBase/https/%{SERVER_NAME}:443/VirtualHostRoot$1 


[L,P]

but when I go to http://127.0.0.1/manage I get a Forbidden error.



You can turn on some logging in Apache for rewrites.


I did setup the Virtual Host Monster in Zope, so if I were to
construct the URL like the ReWrite rule does manually, it starts to
load the page, but the frames all have 404 errors because it's
querying Apache on port 443 for the resources after Zope returns the
VHMed URL.



Is this an application that loads in a frame-set?


Maybe you could send me a copy of you httpd.conf/ssl.conf files so I
can see if there's something I'm missing?



I'll send an annotated version.


--

Regards,

PhilK

'let's hear it for the vague blur'
___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
http://mail.zope.org/mailman/listinfo/zope-announce

http://mail.zope.org/mailman/listinfo/zope-dev )