- Zope - Zope lists

RE: [Zope] Python in LINUX to MS SQL.
by Tim Edwards 07 Apr '04

07 Apr '04

We've tried using the combination of FreeTDS drivers, UnixODBC and egenix's mxODBC Zope DA that is mentioned in a previous post. It does work, however we have had problems with concurrency causing deadlocks and freezing the Zope process. This does not happen when running Zope on Windows 2000 and connecting to MSSQL. Give FreeTDS/UnixODBC/mxODBC a try and see how you go first - later on you can always swap in the ODBC-ODBC bridge or whatever instead of FreeTDS/UnixODBC. Let us know how it works. -----Original Message----- From: Jaroslav Lukesh [mailto:lukesh@seznam.cz] Sent: Wednesday, 7 April 2004 10:29 PM To: jerry(a)westrick.com; zope(a)zope.org Subject: Re: [Zope] Python in LINUX to MS SQL. Jerome R. Westrick wrote: > > On Wed, 2004-04-07 at 00:55, Dennis Allison wrote: > >>Why not just connect to the MySQL Server directly? Check the MySQL manual >>on-line. MS-SQL, not My-SQL >>From Linux? Did you browse all possible zope products at both www.zope.org and old.zope.org? > >>On Tue, 6 Apr 2004, Jason C. Leach wrote: >> >> >>>hi, >>> >>>So I'm looking for a cost effective way to connect Zope on Linux to MS >>>SQL Server 2K on Windows. I know about the ODBC-ODBC bridge, but that >>>is a bit expensive for what I need. Any other ideas? I really just >>>need the basics from SQL (Select, Update, Join). Look at: http://www.google.com/search?q=zope%20mssql%20OR%20%22ms%20sql%22&ie=UTF-8&o e=UTF-8&num=100 -- Jaroslav Lukeš -- Tento e-mail nemůže obsahovat VIRY jelikož nepocházi z virózního systému M$ Windows! _______________________________________________ Zope maillist - Zope(a)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 )

1 0

Re: [Zope] Generate a .XLS file.
by J C Lawrence 07 Apr '04

07 Apr '04

On Wed, 7 Apr 2004 16:33:30 -0300 Fernando Lujan <fernando.lujan(a)nube.com.br> wrote: > Hi everyone, is there a way to generate a .xls file from Zope? CSV files with proper MIME typing are loaded transparently by Excel. -- J C Lawrence ---------(*) Satan, oscillate my metallic sonatas. claw(a)kanga.nu He lived as a devil, eh? http://www.kanga.nu/~claw/ Evil is a name of a foeman, as I live.

1 0

Re: [Zope] Apache 2 and Zope Integration
by Ames Andreas (MPA/DF) 07 Apr '04

07 Apr '04

JohanNyberg(a)tsl.uu.se writes: > I have also tried to solve this problem without success. I simply > want Zope to serve the contents of http://myhost.mydomain/zope, > while Apache2 serves all other files via http://myhost.mydomain/. Please excuse, if this is completely braindead, but I think the 'base' command line option to 2.6's Z2.py could be useful in this situation. Zope 2.7 will have something equivalent in the config file. <plug> This will probably make it harder to navigate through your Zope directly, i.e. without Apache in front of it. As a mitigation you could possibly have a look at http://www.zope.org/Members/andreasames/AJPServer The sample config for Apache+Zope, which is included, should do what you want, if I understand you right. </plug> cheers, aa

1 0

RE: Re: Your music (KMM12461488V57349L0KM)
by Best Buy Customer Care 07 Apr '04

07 Apr '04

Thank you for using Online Customer Care. For security purposes, replies to this address cannot be serviced. If you have common questions regarding your account, login to our secure web site at http://www.hrsaccount.com. Original Message Follows: ------------------------ Please read the attached file. [ Attachment 1.2 Type: text/plain]

1 0

Beta-Testers Wanted: ZServerSSL Windows Installers
by Ng Pheng Siong 07 Apr '04

07 Apr '04

Hi, I'm building ZServerSSL Windows installers for stock Zope 2.7.0 and Plone 2.0. I will be selling these. The installers are at an advanced stage. See my blog at http://sandbox.rulemaker.net/ngps/ I'm looking for a few more beta testers. Please contact me if you're interested. Beta testers who provide feedback get complimentary copies of the gold versions. Thanks. Cheers. -- Ng Pheng Siong <ngps(a)netmemetic.com> http://firewall.rulemaker.net -+- Firewall Change Management & Version Control http://sandbox.rulemaker.net/ngps -+- Open Source Python Crypto & SSL

1 0

ZODB vs LocalFS
by Ryan Boder 07 Apr '04

07 Apr '04

Hi, I'm working on a Zope application that will store a bunch of openoffice documents that users change on a regular basis. I am not completely sure about using the ZODB for this for a few reasons, and I can't find complete documentation on the ZODB. These openoffice filess will be changed often and may be large. I think that ZODB keeps all old copies of a file each time it changes. Changing large openoffice documents all the time would make the ZODB huge, right? Can I make ZODB only store the most recent version of these files, instead of keeping a history of all the versions? I have also looked into using LocalFS and storing them on my file system. Is that the best way to go? OpenOffice has history and versioning built in so I won't be getting any benefit from keeping a history of old versions, just wasting disk space. Can I set ZODB to only keep the last 3 versions of a file and erase older versions all together? Is there any good ZODB documentation you can point me to? I've picked up things here and there from the Zope Book but I'm still don't know much about ZODB. Also, as for LocalFS I could hardly find anything. From the Zope site I couldn't even tell which version of LocalFS to use with Zope-2.7.0, let alone how to use it. Thanks, -- Ryan Boder http://www.bitwiser.org/icanoop

6 7

RE: [Zope] Apache 2 and Zope Integration
by Jim Kutter 07 Apr '04

07 Apr '04

Try adding a re-write rule for /manage as well. RewriteRule ^/manage(.*) \ http://localhost:9080/VirtualHostBase/http/%{SERVER_NAME}:80/VirtualHost Root/manage$1 [L,P] But you will also need the following to get the images (object icons, etc...) RewriteRule ^/_p(.*) \ http://localhost:9080/VirtualHostBase/http/%{SERVER_NAME}:80/VirtualHost Root/_p$1 [L,P] Put these before your catch-all rule. In all truth, I never put the _vh_ stuff in the re-write paths, partly because I myself never quite understood their use. The above lines should work for you. -jim -----Original Message----- From: JohanNyberg(a)tsl.uu.se [mailto:JohanNyberg@tsl.uu.se] Sent: Wednesday, April 07, 2004 10:16 AM Cc: zope(a)zope.org Subject: [Zope] Apache 2 and Zope Integration Hi, I have also tried to solve this problem without success. I simply want Zope to serve the contents of http://myhost.mydomain/zope, while Apache2 serves all other files via http://myhost.mydomain/. I can reach the Zope Quick Start page, which in my case is at http://myhost.mydomain/zope, but when I click on the Zope Management Interface link on this page I get the error The requested URL /manage was not found on this server. I also get an error in the apache error log: [Wed Apr 07 15:33:17 2004] [error] [client <removed>] File does not exist: /var/www/html/manage_page_style.css, referer: http://myhost.mydomain/zope/ which is probably why the style of the zope pages does not look so nice. If I manually go to http://myhost.mydomain/zope/manage, I can login to zope, but the whole idea with the rewrite rule was that zope should add /zope/ to the URL of all referenced files, but it does not. The same problem occurs when I try to logout of zope: The requested URL /manage_zmi_logout was not found on this server. Zope did not add /zope/ to the URL of the logout link. I can logout manually if I direct the browser to http://myhost.mydomain/zope/manage_zmi_logout. I am using Linux Mandrake 9.2/cooker, zope-2.7.0, apache-2.0.49. I have created a VHM in Zope and these are my rewrite rules for apache2: NameVirtualHost * <VirtualHost *> ServerName myhost.mydomain <IfModule mod_rewrite.c> RewriteEngine On RewriteLog "/var/log/apache2/rewrite_log" RewriteLogLevel 2 RewriteRule ^/zope$ \ http://localhost:9080/VirtualHostBase/http/%{SERVER_NAME}:80/VirtualHost Root/_vh_zope [L,P] RewriteRule ^/zope(.*) \ http://localhost:9080/VirtualHostBase/http/%{SERVER_NAME}:80/VirtualHost Root/_vh_zope/$1 [L,P] RewriteRule ^/(.*) - [L] </IfModule> <IfModule mod_proxy.c> ProxyVia On # prevent the webserver from beeing used as proxy <LocationMatch "^[^/]"> Deny from all </LocationMatch> </IfModule> </VirtualHost> Any help is appreciated! Johan -------------------------------- Jim Kutter jim at ebizq.net Fri Apr 2 16:08:14 EST 2004 I got hit with the same snag when I first dove into this as well. Don't use the Proxy stuff directly, use it via mod_rewrite. I forget where I finally found that info. This is from my configs: RewriteEngine on # local requests for images redirect to real web server RewriteRule ^/web_resources(.*) http://<removed>/web_resources$1 [L,R] RewriteRule ^/web_images/style.css http://homer:8080/newsite/style.css [L,P] RewriteRule ^/web_images(.*) http://<removed>/web_images$1 [L,R] RewriteRule ^/z_images(.*) http://<removed>/z_images$1 [L,R] # insider (zope content) RewriteRule ^/insider(.*) http://<removed>/VirtualHostBase/http/<removed>:80/sections/VirtualHostR oot/insider$1 [L,P] Good luck! -jim -----Original Message----- From: Ade Fewings [mailto:ade at informatics.bangor.ac.uk] Sent: Friday, April 02, 2004 3:56 PM To: zope at zope.org Subject: [Zope] Apache 2 and Zope Integration Hi all, I'm trying to persuade our powers-that-be that a switch-over to using Zope for our website would be "a good idea". For this, the best way for me to achieve things is using Zope and the existing Apache stuff together. I've been following the guide at http://zope.org/Members/anser/apache_zserver for using Apache's Inverse Proxy ability to reach our Zope installation. However, I am having the problem that i have to log in twice to the management interface and then when i come to log out of it, i get the following error from Apache: The requested URL /manage_zmi_logout was not found on this server. I have the following in httpd.conf [changed the names to protect the server]: ProxyPass /Zope http://a.b.com:81/ ProxyPassReverse /Zope http://a.b.com:81/ ProxyPass /misc_ http://a.b.com:81/misc_ ProxyPass /p_ http://a.b.com:81/p_ I have also added the SiteRoot object in the management root. Does anybody have any idea what i might have done wrong? Is it because we are using Apache 2 [2.0.48]? Many thanks Ade _______________________________________________ Zope maillist - Zope at 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 ) _______________________________________________ Zope maillist - Zope(a)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 )

2 1

Apache 2 and Zope Integration
by JohanNyberg＠tsl.uu.se 07 Apr '04

07 Apr '04

Hi, I have also tried to solve this problem without success. I simply want Zope to serve the contents of http://myhost.mydomain/zope, while Apache2 serves all other files via http://myhost.mydomain/. I can reach the Zope Quick Start page, which in my case is at http://myhost.mydomain/zope, but when I click on the Zope Management Interface link on this page I get the error The requested URL /manage was not found on this server. I also get an error in the apache error log: [Wed Apr 07 15:33:17 2004] [error] [client <removed>] File does not exist: /var/www/html/manage_page_style.css, referer: http://myhost.mydomain/zope/ which is probably why the style of the zope pages does not look so nice. If I manually go to http://myhost.mydomain/zope/manage, I can login to zope, but the whole idea with the rewrite rule was that zope should add /zope/ to the URL of all referenced files, but it does not. The same problem occurs when I try to logout of zope: The requested URL /manage_zmi_logout was not found on this server. Zope did not add /zope/ to the URL of the logout link. I can logout manually if I direct the browser to http://myhost.mydomain/zope/manage_zmi_logout. I am using Linux Mandrake 9.2/cooker, zope-2.7.0, apache-2.0.49. I have created a VHM in Zope and these are my rewrite rules for apache2: NameVirtualHost * <VirtualHost *> ServerName myhost.mydomain <IfModule mod_rewrite.c> RewriteEngine On RewriteLog "/var/log/apache2/rewrite_log" RewriteLogLevel 2 RewriteRule ^/zope$ \ http://localhost:9080/VirtualHostBase/http/%{SERVER_NAME}:80/VirtualHostRoo… [L,P] RewriteRule ^/zope(.*) \ http://localhost:9080/VirtualHostBase/http/%{SERVER_NAME}:80/VirtualHostRoo… [L,P] RewriteRule ^/(.*) - [L] </IfModule> <IfModule mod_proxy.c> ProxyVia On # prevent the webserver from beeing used as proxy <LocationMatch "^[^/]"> Deny from all </LocationMatch> </IfModule> </VirtualHost> Any help is appreciated! Johan -------------------------------- Jim Kutter jim at ebizq.net Fri Apr 2 16:08:14 EST 2004 I got hit with the same snag when I first dove into this as well. Don't use the Proxy stuff directly, use it via mod_rewrite. I forget where I finally found that info. This is from my configs: RewriteEngine on # local requests for images redirect to real web server RewriteRule ^/web_resources(.*) http://<removed>/web_resources$1 [L,R] RewriteRule ^/web_images/style.css http://homer:8080/newsite/style.css [L,P] RewriteRule ^/web_images(.*) http://<removed>/web_images$1 [L,R] RewriteRule ^/z_images(.*) http://<removed>/z_images$1 [L,R] # insider (zope content) RewriteRule ^/insider(.*) http://<removed>/VirtualHostBase/http/<removed>:80/sections/VirtualHostR oot/insider$1 [L,P] Good luck! -jim -----Original Message----- From: Ade Fewings [mailto:ade at informatics.bangor.ac.uk] Sent: Friday, April 02, 2004 3:56 PM To: zope at zope.org Subject: [Zope] Apache 2 and Zope Integration Hi all, I'm trying to persuade our powers-that-be that a switch-over to using Zope for our website would be "a good idea". For this, the best way for me to achieve things is using Zope and the existing Apache stuff together. I've been following the guide at http://zope.org/Members/anser/apache_zserver for using Apache's Inverse Proxy ability to reach our Zope installation. However, I am having the problem that i have to log in twice to the management interface and then when i come to log out of it, i get the following error from Apache: The requested URL /manage_zmi_logout was not found on this server. I have the following in httpd.conf [changed the names to protect the server]: ProxyPass /Zope http://a.b.com:81/ ProxyPassReverse /Zope http://a.b.com:81/ ProxyPass /misc_ http://a.b.com:81/misc_ ProxyPass /p_ http://a.b.com:81/p_ I have also added the SiteRoot object in the management root. Does anybody have any idea what i might have done wrong? Is it because we are using Apache 2 [2.0.48]? Many thanks Ade _______________________________________________ Zope maillist - Zope at 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 )

2 1

Session
by Declan Shanaghy 07 Apr '04

07 Apr '04

I have a Zope instance in CVS, when i run it on my stage server it doesnt seem to hold session items at all however it works perfectly on my development machine. Anyone have any clue why this would happen? Dek __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com

1 0

Lamer: message on linux
by fowlertrainer＠anonym.hu 07 Apr '04

07 Apr '04

Hello ! I use zope in windows, but I need to install it in linux. It is working, but say that: 2004-04-07T12:48:22 INFO(0) z2 Your umask of 022 may be too permissive; for the security of your Zope data, it is recommended you use 077 Why ? Thanx for any answers (except rtfm). -- Üdv/Kind of Regards: fowlertrainer(a)anonym.hu mailto:fowlertrainer@anonym.hu

2 1