- Zope - Zope lists

Install Zope correctly
by Oliver Marx 26 Jul '02

26 Jul '02

Dear List I have just read this: http://www.zope.org/Members/beacon/install_instructions And I and a bit confused over this part: btw - the comments are mine. #Client is connection to www.foobar.net and we do the RewriteRule dance. ServerName foobar.net ServerAlias www.foobar.net # What the f..k ServerAlias outside <VirtualHost> !! ?? ServerAdmin admin DocumentRoot /var/zope-sites/FooBar/static CustomLog /var/zope-sites/FooBar/logs/access_log combined RewriteEngine on RewriteRule ^/images/ - [L] RewriteRule ^/(.*) http://127.0.0.1:8080/VirtualHostBase/http/foobar.net:80/MySites/FooBar/Virt ualHostRoot/$1 [P] # The intention with this part seems to be that if the client tries to connect to manage.foobar.net via http he is forced to use https. ServerName manage.foobar.net # ?? ServerName used as a condition? ServerAdmin admin RewriteEngine on RewriteCond %{SERVER_PORT} !443 RewriteRule ^/(.*) https://manage.foobar.net/$1 [P] # The client is connecting to manage.foobar.net via https and we do the usual RewriteRule dance. ServerAdmin admin DocumentRoot /var/zope-sites/FooBar/static CustomLog /var/zope-sites/FooBar/logs/access_log combined ServerName manage.foobar.net RewriteEngine on RewriteRule ^/images/ - [L] RewriteRule ^/(.*) http://127.0.0.1:8080/VirtualHostBase/https/manage.foobar.net:443/MySites/Fo oBar/VirtualHostRoot/$1 [P] SSLEngine on SSLCertificateFile /var/zope-sites/FooBar/conf/ssl/server.pub SSLCertificateKeyFile /var/zope-sites/FooBar/conf/ssl/server.key SSLCipherSuite ALL:!ADH:RC4+RSA:+HIGH:+MEDIUM:+LOW:+SSLv2:+EXP:+eNULL SetEnvIf User-Agent ".*MSIE.*" nokeepalive ssl-unclean-shutdown How on earth is this supposed to work? AFAIK One cannot use ServerName as a condition the way it seems to be used here. All comments welcome! \Oliver --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com) Version: 6.0.371 / Virus Database: 206 - Release Date: 13-06-2002

2 2

FW: [Zope] m$ word question
by Greg Conway 26 Jul '02

26 Jul '02

Hi all (especially Oliver if you are there!!) >> >> But if you know how to invoke the WORD-object from Python - >> >> which should be >> >> a piece of cake >> >> Then you only need the stream of data and voila. Can anybody please help me with the above? Maybe someone has some example code they could (please please please!) throw my way so I can get a starting point on this!! Maybe a piece of cake to some, but I am still struggling! Do I need to initalise COM to do this? (at the bottom of this mail) I am running Zope 2.5.0 - is COM already enabled in Zope by this release by default? Many thanks for any help! Regards, Greg Conway. PS the VB code I actually want to run is as follows! if anybody else can throw some light on this from my code, would be very very appreciated! Dim objWord As Word.Document Set objWord = GetObject(Template, "Word.Document") FullPath = FolderName & "\" & Filename ' Make Word visible. objWord.Application.Visible = True ' Set the mail merge data source objWord.MailMerge.OpenDataSource _ Name:="H:\ENACT\Datatables\nacustdb-010_be.MDB", _ LinkToSource:=True, _ Connection:="TABLE CustDetail", _ SQLStatement:="SELECT * FROM [CustDetail] WHERE CustNoD=" & ContractID ' Execute the mail merge. objWord.MailMerge.Execute ' Set the path and save the current document objWord.Application.ActiveDocument.SaveAs Filename:=FullPath >> -----Original Message----- >> From: Greg Conway [mailto:greg@gmlnt.com] >> Sent: 25 July 2002 07:15 >> To: oliver(a)tekk.dk >> Subject: RE: [Zope] m$ word question >> >> >> Hi Oliver, >> >> This sounds as if it is exactly what I need to do! >> >> However, whilst I have my VB code I have not a clue where to >> start with Zope! >> >> You don't possibly have a bit of example code you could throw my >> way, please, that I could maybe get a starting point from?! >> >> Many thanks! >> >> Regards, >> >> Greg. >> >> >> -----Original Message----- >> >> From: Oliver Marx [mailto:oliver@tekk.dk] >> >> Sent: 22 July 2002 09:35 >> >> To: Toby Dickenson; Greg Conway; Zope@Zope. Org >> >> Subject: RE: [Zope] m$ word question >> >> >> >> >> >> The VB-script is already based on COM. >> >> So doing COM communication twice is not good coding style in >> my opinion. >> >> >> >> But if you know how to invoke the WORD-object from Python - >> >> which should be >> >> a piece of cake >> >> Then you only need the stream of data and voila. >> >> >> >> \Oliver >> >> >> >> >>-----Original Message----- >> >> >>From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On >> Behalf Of Toby >> >> >>Dickenson >> >> >>Sent: 22. juli 2002 10:09 >> >> >>To: Greg Conway; Zope@Zope. Org >> >> >>Subject: Re: [Zope] m$ word question >> >> >> >> >> >> >> >> >>On Saturday 20 Jul 2002 1:02 am, Greg Conway wrote: >> >> >> >> >> >>> Anyway, what I want to do exactly is call Word with a stream >> >> of data, to >> >> >>> perform a Mail Merge. I'm converting some script that >> already runs in >> >> >>> Visual Basic, is it possible to get a Visual Basic script >> >> >>plug-in for Zope? >> >> >> >> >> >>Youve already got some code? thats a good start. Use VB to wrap >> >> >>it up in an >> >> >>in-process COM object, and use python's COM support in an >> >> >>external method to >> >> >>call it. >> >> >> >> >> >>The one major gotcha is getting COM initialized correctly. Unless >> >> >>you add some >> >> >>code, this will happen wrong by default. One of these should help: >> >> >> >> >> >>http://www.google.com/search?q=dickenson+coinitializeex >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >>_______________________________________________ >> >> >>Zope maillist - Zope(a)zope.org >> >> >>http://lists.zope.org/mailman/listinfo/zope >> >> >>** No cross posts or HTML encoding! ** >> >> >>(Related lists - >> >> >> http://lists.zope.org/mailman/listinfo/zope-announce >> >> >> http://lists.zope.org/mailman/listinfo/zope-dev ) >> >> >>--- >> >> >>Incoming mail is certified Virus Free. >> >> >>Checked by AVG anti-virus system (http://www.grisoft.com) >> >> >>Version: 6.0.371 / Virus Database: 206 - Release Date: 13-06-2002 >> >> >> >> >> --- >> >> Outgoing mail is certified Virus Free. >> >> Checked by AVG anti-virus system (http://www.grisoft.com) >> >> Version: 6.0.371 / Virus Database: 206 - Release Date: 13-06-2002 This electronic transmission and any files attached to it are strictly confidential and intended solely for the addressee. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. If you have received this transmission in error, please notify us by return and delete the same. Further enquiries/returns can be posted to postmaster(a)gmlnt.com Thank you.

2 1

Newbie to Zope
by zope 26 Jul '02

26 Jul '02

Hi I am a Newbie to zope. I am interested in working in zope and have been involved in work related with Pythonscripts and PostgreSql and Page Templates. I have become stuck at a point and I am not able to find what to do next. I am using a python Script to run a ZSQL method and then the values are to be sent to the Page Template to be displayed.The Script is: from Products.PythonScripts.standard import html_quote r = context.ond.db.zqll_clin # this is a zsql method in a different folder at root for x in r: print x['Id'],x['Name'],x['tt'] # these are the fields of the table return r The error message I get is Error Type: KeyError Error Value: 0 Am i not being able to get the record set from the database?Because if I give a print command in the loop it does not work.HEnce it may not be entering the loop.What is the method to access a Zsql Method which is another folder? If there is someone who could help me out here it would be very helpful.Since i am stuck with this problem for 2 days and I have tried other possibilities. Regards John Kunchandy --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com) Version: 6.0.380 / Virus Database: 213 - Release Date: 7/24/2002

4 3

Problem with SessionData
by Андрей Пучин 26 Jul '02

26 Jul '02

Good day! There was a problem with loss SessionData at the manipulation with them from function which it is started in new thread and to which as parameter is transferred self.REQUEST. In function is called self.REQUEST.SESSION.get(). In some cases there is "loss" SessionData or to a browser is given new ID. ZOPE 2.5.1 is running under WinXP on the dual-processor machine. Python 2.1.3. Any assumptions? P.S. This problem arises only by 2-processor machines. -- Best regards, Andrew mailto:nash@garant.ru

2 3

Re: FW: [Zope] m$ word question
by John Whalley 26 Jul '02

26 Jul '02

Hi, The MSWordDocument product uses COM on Windows platforms to get Word to create an HTML preview of uploaded files. Maybe this will help? The installation instructions also tell you how to add the COM extensions to Python, IIRC. HTH John Whalley "Greg Conway" <greg(a)gmlnt.com> 26/07/02 01:13:52 >>> -- * John Whalley, Crewe Site Library, Manchester Metropolitan University * email: J.H.Whalley(a)mmu.ac.uk * Phone: (+44) 161 247 5220 (UK) * Usual disclaimer applies........... >>> >> But if you know how to invoke the WORD-object from Python - >>> >> which should be >>> >> a piece of cake >>> >> Then you only need the stream of data and voila. > >Can anybody please help me with the above? Maybe someone has some example >code they could (please please please!) throw my way so I can get a starting >point on this!! > >Maybe a piece of cake to some, but I am still struggling! > >Do I need to initalise COM to do this? (at the bottom of this mail) > >I am running Zope 2.5.0 - is COM already enabled in Zope by this release by >default?

1 0

Re: [Zope] Verions & TinyTablePlus bug?
by John Whalley 26 Jul '02

26 Jul '02

Hi, "Eric van Riet Paap" <eric(a)quadgames.com> 25/07/02 22:57:10 >>> >While working with a TinyTablePlus object the table get locked because Zope >seems to think someone modified it while working in Version (called >workInProgress). However I am the only one working on this machine and I am >definataly not working in a Version (I actually deleted workInProgress >object some time ago). I use Zope 2.5.1 . Anyone encountered a similar >problem sometime? NB I'm working from memory here, so minutiae may be incorrect. I had a similar problem a while back where Zope wouldn't let me modify some objects as it said they had been altered in a version which I'd deleted. This was some months ago and (I think) I was using a flavour of Zope 2.3 at the time. IIRC, the eventual solution was to export the parent folder, rename the problem one and import the exported .zexp. This removed the locks and all was well, at which point I deleted the problem folder. And stopped using versions, which seem like a great idea, but it's easy to confuse them: IIRC moving objects within a version was a recipe for trouble. TTFN John Whalley -- * John Whalley, Crewe Site Library, Manchester Metropolitan University * email: J.H.Whalley(a)mmu.ac.uk * Phone: (+44) 161 247 5220 (UK) * Usual disclaimer applies...........

1 0

Unexpected 302 in HTTP Header
by Roché Compaan 26 Jul '02

26 Jul '02

Hi, I have a form that submits to a python script. The python script "returns" a DTML method but Zope never displays that DTML method - it redirects to another page and I definitely didn't tell it too. I tried to debug this with tcpwatch and a "302" showed up in the HTTP Header with the rendered content of the DTML method without any exceptions showing up. I am confident that there is no "redirect" in my code. Is there a place in ZPublisher's HTTPResponse.py where I can add some logging code as a way to track this down? I'm using Zope 2.4.4. -- Roché Compaan Upfront Systems http://www.upfrontsystems.co.za

2 6

Accessing Tracker Catalog
by Sebastian Sippl 26 Jul '02

26 Jul '02

Hi, I've installed a TrackerProdukt. I need to acess the Trackers catalog via dtml, to read out some values. Does anyone know how to manage this ? Sebastian

1 0

RE: Speeding up Zope startup (was: [Zope] Re: Zope digest, Vol 1 #2225 - 6 msgs)
by EvH 26 Jul '02

26 Jul '02

At 12:44 24/07/2002 -0500, Steve Drees <drees(a)rangebroadband.com> wrote: >are you online when starting up zope? Online? You mean, connected to the Net? Sometimes. Besides the instense disk-drive activity that I can hear when hitting start.bat, does Zope try to connect to a remote server on the Net without telling anyone? My firewall doesn't include rules to allow Zope to connect to the Net, so I don't think that's what it is. I didn't do anything special besides running the Windows install program, so I guess it's normal behavior, but I wish it started faster. Thx EvH.

1 0

ProxyPass displaying HTML source
by Jordi YC 26 Jul '02

26 Jul '02

Hi, I am trying to use Apache as the front-end using SSL. It seems that SSL is not an issue, but I am getting HTML source code instead. As a test, I tried to use proxypass to zope.org and it worked. I can lynx 127.0.0.1:8080 and the page will be displayed correctly on the server where apache and zope are hosted. Any hint appreciated, TIA Browser screen http://somedomain.com/myzope/ Date: Thu, 25 Jul 2002 11:29:29 GMT Connection: close Content-Type: text/html Etag: Content-Length: 2958 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "http://www.w3.org/TR/REC-html40/loose.dtd"> <html> <head> <base href="http://127.0.0.1:8080/" /> <title>Zope QuickStart</title> <link rel="stylesheet" type="text/css" href="/manage_page_style.css"> </head> <body bgcolor="#ffffff" link="#000099" alink="#000099" vlink="#000099"> httpd.conf ### Section 1: Global Environment ServerType standalone # Do NOT add a slash at the end of the directory path. ServerRoot "/var/www" PidFile logs/httpd.pid ScoreBoardFile logs/apache_runtime_status #ResourceConfig conf/srm.conf #AccessConfig conf/access.conf Timeout 300 KeepAlive On MaxKeepAliveRequests 100 KeepAliveTimeout 15 MinSpareServers 5 MaxSpareServers 10 StartServers 5 MaxClients 20 MaxRequestsPerChild 30 LoadModule proxy_module /usr/lib/apache/modules/libproxy.so #LoadModule rewrite_module /usr/lib/apache/modules/mod_rewrite.so ### Section 2: 'Main' server configuration Port 80 <IfDefine SSL> Listen 80 Listen 443 </IfDefine> User www Group www ServerAdmin root(a)somedomain.com ServerName somedomain.com DocumentRoot "/var/www/htdocs" <Directory /> Options FollowSymLinks AllowOverride None </Directory> <Directory "/var/www/htdocs"> Options Indexes FollowSymLinks AllowOverride None Order allow,deny Allow from all </Directory> UserDir disabled DirectoryIndex index.html AccessFileName .htaccess <Files .htaccess> Order allow,deny Deny from all </Files> UseCanonicalName On TypesConfig conf/mime.types DefaultType text/plain <IfModule mod_mime_magic.c> MIMEMagicFile conf/magic </IfModule> HostnameLookups Off ErrorLog logs/error_log LogLevel warn LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combined LogFormat "%h %l %u %t \"%r\" %>s %b" common LogFormat "%{Referer}i -> %U" referer LogFormat "%{User-agent}i" agent CustomLog logs/access_log common ServerSignature Off Alias /icons/ "/var/www/icons/" <Directory "/var/www/icons"> Options Indexes MultiViews AllowOverride None Order allow,deny Allow from all </Directory> ScriptAlias /cgi-bin/ "/var/www/cgi-bin/" <Directory "/var/www/cgi-bin"> AllowOverride None Options None Order allow,deny Allow from all </Directory> IndexOptions FancyIndexing AddIconByEncoding (CMP,/icons/compressed.gif) x-compress x-gzip AddIconByType (TXT,/icons/text.gif) text/* AddIconByType (IMG,/icons/image2.gif) image/* AddIconByType (SND,/icons/sound2.gif) audio/* AddIconByType (VID,/icons/movie.gif) video/* AddIcon /icons/binary.gif .bin .exe AddIcon /icons/binhex.gif .hqx AddIcon /icons/tar.gif .tar AddIcon /icons/world2.gif .wrl .wrl.gz .vrml .vrm .iv AddIcon /icons/compressed.gif .Z .z .tgz .gz .zip AddIcon /icons/a.gif .ps .ai .eps AddIcon /icons/layout.gif .html .shtml .htm .pdf AddIcon /icons/text.gif .txt AddIcon /icons/c.gif .c AddIcon /icons/p.gif .pl .py AddIcon /icons/f.gif .for AddIcon /icons/dvi.gif .dvi AddIcon /icons/uuencoded.gif .uu AddIcon /icons/script.gif .conf .sh .shar .csh .ksh .tcl AddIcon /icons/tex.gif .tex AddIcon /icons/bomb.gif core AddIcon /icons/back.gif .. AddIcon /icons/hand.right.gif README AddIcon /icons/folder.gif ^^DIRECTORY^^ AddIcon /icons/blank.gif ^^BLANKICON^^ DefaultIcon /icons/unknown.gif ReadmeName README HeaderName HEADER IndexIgnore .??* *~ *# HEADER* README* RCS CVS *,v *,t AddEncoding x-compress Z AddEncoding x-gzip gz AddLanguage en .en AddLanguage es .es AddLanguage ca .ca LanguagePriority en es ca BrowserMatch "Mozilla/2" nokeepalive BrowserMatch "MSIE 4\.0b2;" nokeepalive downgrade-1.0 force-response-1.0 BrowserMatch "RealPlayer 4\.0" force-response-1.0 BrowserMatch "Java/1\.0" force-response-1.0 BrowserMatch "JDK/1\.0" force-response-1.0 # Allow server status reports, with the URL of http://servername/server-status # Change the ".your_domain.com" to match your domain to enable. # <Location /server-status> SetHandler server-status Order deny,allow Deny from all Allow from somedomain.com </Location> # # Allow remote server configuration reports, with the URL of # http://servername/server-info (requires that mod_info.c be loaded). # Change the ".your_domain.com" to match your domain to enable. # #<Location /server-info> # SetHandler server-info # Order deny,allow # Deny from all # Allow from .your_domain.com #</Location> ## ## SSL Global Context ## ## All SSL configuration in this context applies both to ## the main server and all SSL-enabled virtual hosts. ## # # Some MIME-types for downloading Certificates and CRLs # <IfDefine SSL> AddType application/x-x509-ca-cert .crt AddType application/x-pkcs7-crl .crl </IfDefine> <IfModule mod_ssl.c> SSLPassPhraseDialog builtin SSLSessionCache dbm:logs/ssl_scache SSLSessionCacheTimeout 300 SSLMutex file:logs/ssl_mutex SSLRandomSeed startup builtin SSLRandomSeed connect builtin SSLRandomSeed startup file:/dev/arandom 512 SSLLog logs/ssl_engine_log SSLLogLevel info </IfModule> <IfDefine SSL> ## ## SSL Virtual Host Context ## <VirtualHost _default_:443> # General setup for the virtual host #DocumentRoot /var/www/htdocs/manual ServerName somedomain.com ServerAdmin root(a)somedomain.com ErrorLog logs/error_log TransferLog logs/access_log setEnv SERVER_URL http://somedomain.com ProxyPass /myzope/ http://127.0.0.1:8080/ ProxyPassReverse /myzope/ http://127.0.0.1:8080/ ProxyPass /lycos/ http://www.lycos.com/ ProxyPassReverse /lycos/ http://www.lycos.com/ #ProxyPass / http://127.0.0.1:8080/ #ProxyPassReverse / http://127.0.0.1:8080/ SSLEngine on SSLCertificateFile /etc/ssl/server.crt SSLCertificateKeyFile /etc/ssl/private/server.key CustomLog logs/ssl_request_log \ "%t %h %{SSL_PROTOCOL}x %{SSL_CIPHER}x \"%r\" %b" </VirtualHost> </IfDefine>

3 2