Re: [Zope] Zope 2.6.4 + Win32 server
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
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
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 )