- Zope - Zope lists

Virtual Host Moster w/ Apache.
by Jason C. Leach 15 Feb '02

15 Feb '02

hi, I have some virtual hosts behind an Apache proxy, I use Apache so I can have unique log files for each site. But some times I get urls that look like: /domain/domain/domain/file In the root folder of Zope I have a 'domain' folder for each domain we hosts. It's probably some combination of a SiteRoot or Apache's rewrieing. Below is one of my apache VirtualSites. Zope is behind a firewall thus the 9673 port. <VirtualHost 192.168.100.100> ServerAdmin webmaster(a)jsthrower.com ServerName riverspirit.ca ServerAlias www.riverspirit.ca #DocumentRoot /var/www/riverspirit.ca/riverspirit ErrorLog /var/log/apache/riverspirit.ca-error.log TransferLog /var/log/apache/riverspirit.ca-access.log <IfModule mod_rewrite.c> RewriteEngine On RewriteLog "/var/log/apache/rewrite_log" RewriteLogLevel 0 RewriteRule ^/local/ - [L] RewriteRule ^/(.*) http://www.riverspirit.ca:9673/riverspirit.ca/$1 [P] </IfModule> </VirtualHost> -- ...................... ..... Jason C. Leach .. PGP/GPG Public key at http://www.keyserver.net/ Key ID: 1CF6DA85

2 1

RE: [Zope] Houston, we have forked - ZMySQLDA keeps braking
by Micah Martin 14 Feb '02

14 Feb '02

Thanks Dieter, That information is very helpful and it sounds like you hit it on the nail. I had downloaded the ZMySQLDA product off the zope.org site, I didn't realize this was an ancient version (1-1-3). It did in fact print a deprication error message to stdout on startup so without a terminal... Redirecting output with the nohup cmd seemed to allow the MySQLDA product to restart successfully. I've since installed the newest version of MySQLDA off sourceforge. I have faith that this will work better. Thanks all, Micah -----Original Message----- From: Dieter Maurer [mailto:dieter@handshake.de] Sent: Thursday, February 14, 2002 3:18 PM To: Micah Martin Cc: 'zope(a)zope.org' Subject: Re: [Zope] Houston, we have forked - ZMySQLDA keeps braking Micah Martin writes: > I realize that this has been discussed here before but I was not able to > find the information needed. I've tried the ZOPE_SECURITY_POLICY=PYTHON > trick to no avail. > > The sympton is that zope restarts for some reason and when it restarts, it > cannot import the ZMySQLDA product.... Any Ideas? > > log = > > 2002-02-13T18:41:56 ERROR(200) zdaemon zdaemon: Wed Feb 13 12:41:56 2002: > Aiieee! 31297 exited with error code: 4 That's a SIGILL (Illegal Instruction Signal). Usually a very serious problem (memory corruption or array bounds violation led to a buggy return address, or something similar)... > .... > 2002-02-13T18:41:59 ERROR(200) Zope Could not import Products.ZMySQLDA > Traceback (innermost last): > File /usr/local/zope/lib/python/OFS/Application.py, line 531, in > import_product > File /usr/local/zope/lib/python/Products/ZMySQLDA/__init__.py, line 106, > in ? > (Object: os) > File /usr/local/zope/lib/python/Products/ZMySQLDA/DA.py, line 108, in ? > File /usr/local/zope/lib/python/Products/ZMySQLDA/db.py, line 106, in ? > File /usr/local/zope/lib/python2.1/warnings.py, line 39, in warn > File /usr/local/zope/lib/python2.1/warnings.py, line 92, in warn_explicit > File /usr/local/zope/lib/python2.1/warnings.py, line 98, in showwarning > IOError: [Errno 5] Input/output error Python want to issue a warning, probably a deprecation warning (in my view a stupid invention...), and it cannot because the file descriptor is in an unheathy state. This may happen, when a process is started in a terminal session and the session is later terminated (but the process is still running). An explicit redirect of stdout and stderr may help with this. The two problems are almost surely not related. By the way: did you already upgrade to Python 2.1.2 and Zope 2.4.4 or Zope 2.5? There are known memory management problems in earlier Python/Zope versions. Dieter

1 0

Menu of Timezones
by John Wheeler 14 Feb '02

14 Feb '02

For an input form, I'd like to make a menu of time zones. I saw in Appendix B: API Reference of the Zope Book that there already is a DateTime module function that returns a list of timezones, so I thought I could simply use <dtml-in> to go through the list, wrapping each sequence-item with <option></option>. I tried every combination I could think of but got an error every time: <dtml-in {below}> Error Name Error Value ================= ========== =========== DateTime.Timezones KeyError DateTime.Timezones Timezones KeyError Timezones "_.Timezones()" AttributeError Timezones "DateTime.Timezones()" NameError global name 'DateTime' is not defined "_.DateTime.Timezones()" AttributeError class DateTime has no attribute 'Timezones' "DateTime[Timezones]" NameError global name 'DateTime' is not defined "_.DateTime[Timezones]" NameError global name 'Timezones' is not defined "_.DateTime._Timezones()" SyntaxError Line 2: "_Timezones" is an invalid attribute name because it starts with "_". I even tried writing a python method using "from DateTime import Timezones" but got an ImportError: import of "Timezones" from "DateTime" is unauthorized. Is it just not possible to access Timezones() through the web? If I'd have to go to an external method, I'll just hardcode the timezones into the DTML method by hand. _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx

2 1

connecting MySQL and Zope
by Raymond Norton 14 Feb '02

14 Feb '02

I have made several attempts to install the ZMySQLDA database adpapter and MySQL-python database driver according to the book "Zope web applications construction kit". I am getting errors with "make" 1) In function pythonify_row assignment from incompatible pointer type. 2)In function pythonify_res_fields invalid lvalue in unary 3) In function STH_fetchdict invalid lvalue in unary I am using RedHAt 7.1 with Python 1.5.2 and 2.1 It looks like "make" is trying to use 1.5.2 instead of 2.1. I am aware that my version of Zope 2.5 bianry comes with it's own install of 2.1, but am not sure how to force it to use it for this . I would appreciate any help clearing up the problem. -- Raymond Norton Little Crow Telemedia Network 320-234-0270

3 2

getitem?
by Ulrich Wisser 14 Feb '02

14 Feb '02

Hello, I tried <dtml-let item="sonstiges.help.sonstiges.err.getitem(_.str(httpcode))"> <dtml-if item> <dtml-var "item.title()"> <dtml-else> NO ITEM </dtml-if> <dtml-let> My "err" folder as several of DTML Methods which give an explanation for every HTTP error code. I want to retrieve that explanation. It has to be failsafe in cases where an explanation for the errorcode is missing. What is wrong with my code? Any ideas how to solve the problem? Thanks Ulrich

2 1

connet to MS-SQL database with ython script from with in zope
by mbagepll＠memphis.edu 14 Feb '02

14 Feb '02

Hi all, I am a newbie to zope as well as to python. I want to know if i can connect to a MS-SQL server database using python script from with in zope. I tried to import 'odbc' in the python script (from zope) and i got an error message saying "import 'odbc' is unauthorised". My code is: import odbc db=odbc.odbc('mydatabase') cursor=db.cursor() cursor.execute('select * from mytable') for i in fetchall() print i return printed I am a bit confused as to how to do this from zope. Is there a odbc library in zope that i have to import? i need some kind of help... --Madhavi

2 1

Problem with grouping of a sequence
by Doyon, Jean-Francois 14 Feb '02

14 Feb '02

Hello, I'm trying to group a sequence by their first letter to build a list of objects, but am having a problem: The <dtml-if first-sequence-letter> never becomes true! I can print out <dtml-var sequence-letter> just fine, but if I try to detect when they change, no dice, it never occurs! Here's my code: <dtml-var standard_html_header> <table> <dtml-in "portal_catalog.searchResults( meta_type='Archive Map', review_state='published')" sort=Title skip_unauthorized> <dtml-if first-sequence-Letter>true</dtml-if> <tr><td><dtml-var sequence-Letter></td></tr> <tr><td><dtml-var Title></td></tr> </dtml-in> </table> <dtml-var standard_html_footer> This should output each letter of the alphabet as they change, right? What am I doing wrong here? Is this a bug? Any help woul dbe greatly appreciated! I'd rather NOT have ot do 26 different queries :) Thanks, Jean-François Doyon Internet Service Development and Systems Support GeoAccess Division Canadian Center for Remote Sensing Natural Resources Canada http://atlas.gc.ca Phone: (613) 992-4902 Fax: (613) 947-2410

2 1

AQ Error
by Chris A. Bruce 14 Feb '02

14 Feb '02

Does anyone know why I would be getting this exception? Error: AttributeError - aq_acquire Traceback (most recent call last): File "/usr/local/www/Zope-2.4/lib/python/DocumentTemplate/DT_Try.py", line 221, in render_try_except result = render_blocks(self.section, md) File "/usr/local/www/Zope-2.4/lib/python/DocumentTemplate/DT_Let.py", line 148, in render return render_blocks(self.section, md) File "/usr/local/www/Zope-2.4/lib/python/DocumentTemplate/DT_Util.py", line 231, in eval return eval(code, d) File "<string>", line 2, in f File "/usr/local/www/Zope-2.4/lib/python/AccessControl/Role.py", line 234, in manage_permission for p in self.ac_inherited_permissions(1): File "/usr/local/www/Zope-2.4/lib/python/AccessControl/Role.py", line 152, in ac_inherited_permissions for p in self._subobject_permissions(): File "/usr/local/www/Zope-2.4/lib/python/OFS/ObjectManager.py", line 256, in _subobject_permissions return (Products.__ac_permissions__+ AttributeError: aq_acquire Code: <dtml-try> <dtml-call expr="REQUEST.set('roles',['Registered User'])"> <dtml-call expr="REQUEST.set('domains','')"> <dtml-call expr="REQUEST.set('name',REQUEST['UserName'])"> <dtml-call expr="acl_users.manage_users('Add',REQUEST)"> <dtml-except>   </dtml-try> <dtml-try> <dtml-let e="Users.UserFolders[REQUEST['UserName']]"> <dtml-call "e.manage_setLocalRoles(userid=REQUEST['UserName'],roles=['Owner'])"> <dtml-call "e.manage_permission(permission_to_manage='Access contents information',roles=['Owner','Manager'])"> <dtml-call "e.manage_permission(permission_to_manage='View',roles=['Owner','Manager'])"> </dtml-let> <dtml-let f="Users.RegistrationInfo[REQUEST['UserName']]"> <dtml-call "f.manage_setLocalRoles(userid=REQUEST['UserName'],roles=['Owner'])"> <dtml-call "f.propertysheets.email_list.manage_editProperties(REQUEST)"> <dtml-call "f.propertysheets.UserInfo.manage_editProperties(REQUEST)"> </dtml-let> ... UserFolders and RegistrationInfo are ZClasses that get added by ZClassEvent product. Thanks, Chris

2 1

Does Zope translate http-equiv statements?
by Lennart Regebro 14 Feb '02

14 Feb '02

Does Zope translate http-equiv statements? I always thought that the *client* interpreted http-equiv statements. But now I'm not sure anymore. Does Zope translate http-equiv statements in the HTML-header and put these into the HHTP-header?

4 7

ZClass permissions
by Tom Nixon 14 Feb '02

14 Feb '02

I have created a ZClass and a new View called "Edit" which displays a DTML Method containing an automatically generated Formulator form (both situated inside the ZClass). However when I create an instance of the ZClass then click the "edit" view, I am prompted to enter my username and password. If I change the DTML method to a simple "Hello World" message it works fine, so it seems to be something to do with the Formulator form. Obviously there is a permission problem somewhere, but where should I be looking? Zope Version (Zope 2.5.0 (binary release, python 2.1, win32-x86), python 2.1.2, win32) Python Version 2.1.2 (#31, Jan 15 2002, 17:28:11) [MSC 32 bit (Intel)] System Platform win32 T.

2 5