- Zope - Zope lists

Problems with HTML-Document/IEDocument
by Markus Koelle 27 Feb '02

27 Feb '02

I've installed the latest HTMLDocument-product/IEDocument. All works well besides this problems: FTP-users with non-manager roles are not able zu download their own(!) files, the error message in the ftp-client: 530 Unauthorized. The ftp-Client shown this wrong rights: --w--w---- 1 maier zope 358 Feb 27 08:59 htmlfile.html Deletion of the permitted files is possible. What's going wrong with the permissions? Sincerely Markus Koelle

1 0

Re: [Jython-users] Jython and Zope
by Terry Hancock 27 Feb '02

27 Feb '02

Nicolas Bill Russell wrote: > I just want to know if Jython is supported by Zope? I'm new to Python > so go easy on me. :) As far as I know (and I've been looking -- still am), there's no direct support for Jython in Zope. However, Jython is strictly a *client-side* technology and Zope is strictly *server-side* -- so in principle, there isn't much overlap. You could use DTML Methods/ Documents and File objects to hold the Jython code and the interpreter. What would be kind of cool, though, is a Zope product to encapsulate a Jython applet as a Zope object. I think it ought to: 1) Provide a syntax-sensitive editing interface (can we just use the one currently provided for Python scripts? I'm not sure if the syntax is similar enough. I mean -- is the syntax checker aware of standard modules (which may differ) or just legal Python syntax (which should be the same)? Actually, it occurs to me that this may not really be a "syntax checker" -- is it actually just importing the module and reporting the traceback from that? In which case, this is really the same as #3 below. 2) Automatically provide the wrapper code to deliver the Jython interpreter applet and generate the correct <applet> tags, etc. This would be akin to what Zope does for images. 3) It might be good to actually pre-compile into a .jar file (or whatever is appropriate -- I'm a Java/Jython newbie, so go easy on _me_ too ;) ), on the server. Probably one should do this whenever the program is edited on the server, and report errors/traceback from the program. This probably has to be done from an unrestricted Python module (which may in turn call other programs on the server, such as jythonc), so that means putting it in as an External method, or (better) including it in a Zope Product. With Jython, there's an obvious cache-optimization problem -- you want to make sure you only download the core/interpreter part once, and the applets separately. You also want to avoid triggering various security problems with client-side code, which seem to happen when you evaluate/execute strings inside of Python. This probably ought to be done on the server if it can't be avoided (?). It seems to me that there's enough repetitive work here to justify making a special product to simplify it. If you had this, I think you could just edit a Jython client-side method in Zope, save it (which would compile and store on the server), and then embed it into a DTML document, using <dtml-var myJythonObject>. I was thinking of waiting until the O'Reilly book on Jython comes out (I'm not experienced at Java, so I don't think the other book is going to help me so much), and then having a go at writing such a product myself, since I want to do a fairly large amount of Jython stuff with Zope. My attraction to this is the beauty of having both server and client programmed in the same programming language (Python), instead of having to learn and interface between two different ones. This would also reduce the burden of deciding where to draw the line between server- and client-side components, since they would then be relatively easy to port back and forth. So ... Has anyone already done this (and I'm just not so good at finding it), or is anyone interested in collaborating / discussing this with me? Cheers, Terry -- ------------------------------------------------------ Terry Hancock hancock(a)anansispaceworks.com Anansi Spaceworks http://www.anansispaceworks.com P.O. Box 60583 Pasadena, CA 91116-6583 ------------------------------------------------------

7 9

Installation of MySQLDatabaseAdabpter : i have the error ' Impo rtError: No module named _mysql'
by Gostnerr 27 Feb '02

27 Feb '02

Hello, First of all, I have installed MySQL under /user/local/mysql ( it was the sorce version) then under /zopehome I have extract the ZMySQLDA-2.0.9b1.tar.gz ( it extracted to /zopehome/lib/python/Product/ZMySQLDA then under /zopehome/lib/python/Product I have extracted MySQL-python-0.9.0.tar.gz then i do ' python setup.py build ' ( there was an error message) then I edit the setup.py file under ' /zopehome/lib/python/Product/MySQL-python-09' ( because there was this error : mysql.h .. no such file or dirctory ) a) elif os.name == "posix": #most linux platforms include_dirs = ['usr/include/mysql'] libary_dirs = [' usr/lib/mysql'] ----------> include_dirs = ['usr/local/mysql/include/mysql'] libary_dirs = [' usr/local/mysql/lib/mysql'] (because there was the file mysql.h) after that i do ' python setup.py build ' ( there was no error message) and then ' python setup.py install' ( also no error message) After that all I started the zope server , and i received an Error Message Anybody knows why ?? I have no idea ! Roswitha ------------------------------------------- there is the bash output ---------------------------------------------------------------------- linux:/usr/local/ZopePark/Testserver/lib/python/Products/MySQL-python-0.9.0 # python setup.py build running build running build_py not copying CompatMysqldb.py (output up-to-date) not copying _mysql_exceptions.py (output up-to-date) not copying MySQLdb/__init__.py (output up-to-date) not copying MySQLdb/converters.py (output up-to-date) not copying MySQLdb/connections.py (output up-to-date) not copying MySQLdb/cursors.py (output up-to-date) not copying MySQLdb/sets.py (output up-to-date) not copying MySQLdb/times.py (output up-to-date) not copying MySQLdb/constants/__init__.py (output up-to-date) not copying MySQLdb/constants/CR.py (output up-to-date) not copying MySQLdb/constants/FIELD_TYPE.py (output up-to-date) not copying MySQLdb/constants/ER.py (output up-to-date) not copying MySQLdb/constants/FLAG.py (output up-to-date) not copying MySQLdb/constants/REFRESH.py (output up-to-date) not copying MySQLdb/constants/CLIENT.py (output up-to-date) running build_ext skipping '_mysql' extension (up-to-date) linux:/usr/local/ZopePark/Testserver/lib/python/Products/MySQL-python-0.9.0 # python setup.py install# invalid command name 'install#' linux:/usr/local/ZopePark/Testserver/lib/python/Products/MySQL-python-0.9.0 # python setup.py install running install running build running build_py not copying CompatMysqldb.py (output up-to-date) not copying _mysql_exceptions.py (output up-to-date) not copying MySQLdb/__init__.py (output up-to-date) not copying MySQLdb/converters.py (output up-to-date) not copying MySQLdb/connections.py (output up-to-date) not copying MySQLdb/cursors.py (output up-to-date) not copying MySQLdb/sets.py (output up-to-date) not copying MySQLdb/times.py (output up-to-date) not copying MySQLdb/constants/__init__.py (output up-to-date) not copying MySQLdb/constants/CR.py (output up-to-date) not copying MySQLdb/constants/FIELD_TYPE.py (output up-to-date) not copying MySQLdb/constants/ER.py (output up-to-date) not copying MySQLdb/constants/FLAG.py (output up-to-date) not copying MySQLdb/constants/REFRESH.py (output up-to-date) not copying MySQLdb/constants/CLIENT.py (output up-to-date) running build_ext skipping '_mysql' extension (up-to-date) running install_lib not copying build/lib.linux-i686-2.1/CompatMysqldb.py (output up-to-date) not copying build/lib.linux-i686-2.1/_mysql_exceptions.py (output up-to-date) not copying build/lib.linux-i686-2.1/MySQLdb/__init__.py (output up-to-date) not copying build/lib.linux-i686-2.1/MySQLdb/converters.py (output up-to-date) not copying build/lib.linux-i686-2.1/MySQLdb/connections.py (output up-to-date) not copying build/lib.linux-i686-2.1/MySQLdb/cursors.py (output up-to-date) not copying build/lib.linux-i686-2.1/MySQLdb/sets.py (output up-to-date) not copying build/lib.linux-i686-2.1/MySQLdb/times.py (output up-to-date) not copying build/lib.linux-i686-2.1/MySQLdb/constants/__init__.py (output up-to-date) not copying build/lib.linux-i686-2.1/MySQLdb/constants/CR.py (output up-to-date) not copying build/lib.linux-i686-2.1/MySQLdb/constants/FIELD_TYPE.py (output up-to-date) not copying build/lib.linux-i686-2.1/MySQLdb/constants/ER.py (output up-to-date) not copying build/lib.linux-i686-2.1/MySQLdb/constants/FLAG.py (output up-to-date) not copying build/lib.linux-i686-2.1/MySQLdb/constants/REFRESH.py (output up-to-date) not copying build/lib.linux-i686-2.1/MySQLdb/constants/CLIENT.py (output up-to-date) not copying build/lib.linux-i686-2.1/_mysql.so (output up-to-date) skipping byte-compilation of /usr/lib/python2.1/site-packages/CompatMysqldb.py to CompatMysqldb.pyc skipping byte-compilation of /usr/lib/python2.1/site-packages/_mysql_exceptions.py to _mysql_exceptions.pyc skipping byte-compilation of /usr/lib/python2.1/site-packages/MySQLdb/__init__.py to __init__.pyc skipping byte-compilation of /usr/lib/python2.1/site-packages/MySQLdb/converters.py to converters.pyc skipping byte-compilation of /usr/lib/python2.1/site-packages/MySQLdb/connections.py to connections.pyc skipping byte-compilation of /usr/lib/python2.1/site-packages/MySQLdb/cursors.py to cursors.pyc skipping byte-compilation of /usr/lib/python2.1/site-packages/MySQLdb/sets.py to sets.pyc skipping byte-compilation of /usr/lib/python2.1/site-packages/MySQLdb/times.py to times.pyc skipping byte-compilation of /usr/lib/python2.1/site-packages/MySQLdb/constants/__init__.py to __init__.pyc skipping byte-compilation of /usr/lib/python2.1/site-packages/MySQLdb/constants/CR.py to CR.pyc skipping byte-compilation of /usr/lib/python2.1/site-packages/MySQLdb/constants/FIELD_TYPE.py to FIELD_TYPE.pyc skipping byte-compilation of /usr/lib/python2.1/site-packages/MySQLdb/constants/ER.py to ER.pyc skipping byte-compilation of /usr/lib/python2.1/site-packages/MySQLdb/constants/FLAG.py to FLAG.pyc skipping byte-compilation of /usr/lib/python2.1/site-packages/MySQLdb/constants/REFRESH.py to REFRESH.pyc skipping byte-compilation of /usr/lib/python2.1/site-packages/MySQLdb/constants/CLIENT.py to CLIENT.pyc linux:/usr/local/ZopePark/Testserver/lib/python/Products/MySQL-python-0.9.0 # cd .. linux:/usr/local/ZopePark/Testserver/lib/python/Products # cd .. linux:/usr/local/ZopePark/Testserver/lib/python # cd .. linux:/usr/local/ZopePark/Testserver/lib # cd .. linux:/usr/local/ZopePark/Testserver # ./start & [1] 1239 linux:/usr/local/ZopePark/Testserver # ------ 2002-02-26T09:20:11 ERROR(200) Zope Could not import Products.ZMySQLDA Traceback (innermost last): File /usr/local/ZopePark/Testserver/lib/python/OFS/Application.py, line 563, in import_product File /usr/local/ZopePark/Testserver/lib/python/Products/ZMySQLDA/__init__.py, line 91, in ? File /usr/local/ZopePark/Testserver/lib/python/Products/ZMySQLDA/DA.py, line 92, in ? File /usr/local/ZopePark/Testserver/lib/python/Products/ZMySQLDA/db.py, line 89, in ? ImportError: No module named _mysql ------ 2002-02-26T09:20:11 PANIC(300) z2 Startup exception Traceback (innermost last): File /usr/local/ZopePark/Testserver/z2.py, line 564, in ? File <string>, line 1, in ? File /usr/local/ZopePark/Testserver/lib/python/Zope/__init__.py, line 110, in ? File /usr/local/ZopePark/Testserver/lib/python/ZODB/FileStorage.py, line 267, in __init__ File /usr/local/ZopePark/Testserver/lib/python/ZODB/lock_file.py, line 101, in lock_file StorageSystemError: Could not lock the database file. There must be another process that has opened the file. <p> [1]+ Done ./start linux:/usr/local/ZopePark/Testserver # ./stop linux:/usr/local/ZopePark/Testserver # ./start ------ 2002-02-26T09:21:45 ERROR(200) Zope Could not import Products.ZMySQLDA Traceback (innermost last): File /usr/local/ZopePark/Testserver/lib/python/OFS/Application.py, line 563, in import_product File /usr/local/ZopePark/Testserver/lib/python/Products/ZMySQLDA/__init__.py, line 91, in ? File /usr/local/ZopePark/Testserver/lib/python/Products/ZMySQLDA/DA.py, line 92, in ? File /usr/local/ZopePark/Testserver/lib/python/Products/ZMySQLDA/db.py, line 89, in ? ImportError: No module named _mysql ------ 2002-02-26T09:21:47 INFO(0) ZServer HTTP server started at Tue Feb 26 10:21:47 2002 Hostname: localhost Port: 8080 ------ 2002-02-26T09:21:47 INFO(0) ZServer FTP server started at Tue Feb 26 10:21:47 2002 Hostname: linux Port: 8021 ------ 2002-02-26T09:21:47 INFO(0) ZServer PCGI Server started at Tue Feb 26 10:21:47 2002 Unix socket: /usr/local/ZopePark/Testserver/var/pcgi.soc

1 0

manage_change_history
by Zimmermann, Mark 27 Feb '02

27 Feb '02

hi, i heard about "manage_change_history" is there someone who can tell me how i could create a list of all history versions of a dtml document ? like dtml-in manage_change_history version number user date content of DTML Document /dtml-in I already use <dtml-if manage_change_history> <dtml-in manage_change_history mapping> <dtml-if sequence-start> <dtml-var user_name> </dtml-if> </dtml-in> </dtml-if> but this gives me only "one" user_name back :-(

1 0

RE: [Zope] Convert Help
by Smith, Neil 27 Feb '02

27 Feb '02

It sounds to me like you want a ZSQL method that contains code something like: Argument myList:list:int Code: <dtml-if myList> <dtml-in myList> <dtml-if "_['sequence-item']"> insert into myTable values (<dtml-var "_['sequence-item']">) <dtml-var sql_delimiter> </dtml-if> </dtml-in> </dtml-if> Neil -----Original Message----- From: Todd Loomis [mailto:tloomis@dmso.mil] Sent: 26 February 2002 18:26 To: zope(a)zope.org Subject: [Zope] Convert Help All: I need to take the elements in the list ['1', '2', '3'] and make them separate SQL Statements: insert into table values ('1') insert into table values ('2') insert into table values ('3') how can i do this? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Todd Loomis SAIC - DMSO Support 1901 N. Beauregard Street, Suite 500 Alexandria, VA 22311 Office: 703.824.3407 Fax: 703.379.3778 tloomis(a)dmso.mil ********************************************************************** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify postmaster(a)npower.com (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277 This e-mail may be sent on behalf of a member of the Innogy plc group of companies. **********************************************************************

1 0

Create Image on the Fly
by Zimmermann, Mark 27 Feb '02

27 Feb '02

Hi, last year i work with Perl and PHP and there i can create Text within images. Is there a ZOPE Product to create text within images ? I have a "empty" buttonimage and with this product i hope i can create textbuttons.

1 0

Zope hangs with the help section
by Juan Garcia Garcia 27 Feb '02

27 Feb '02

Hi, my problem is that Zope hangs when i want to enter in the Help section. I installed Zope a few months ago and it worked perfectly, but since yesterday i have the problem explained before. I haven't installed or upgraded nothing in the last weeks. I have Zope 2.4.2 in Debian/woody. Has anyone seen this problem before? Thanks. Bye Juan

1 0

Security issue with the Guest book example in Zope Book
by Joakim Nicander 27 Feb '02

27 Feb '02

Hi, I'm relatively new to Zope so I hope I haven't missed anything obvious. I'm building a small project manager for an intranet site. Normally I use MySQL to store data but this time I store the information in DTML Documents as the Guest book example. Text in the document and adding properties to the document. The information is added to Zope via an input form exactly as in the example. Then rendering the document with html_qoute so the cant sneak in html code. But it doesn't stop sneaking in DTML code as I found out when I tested. Ok maybe I missed something I thought, so I implemented the guest book from the Zope book. Still no protection against DTML code. I can get information form Zope and of course crash the guest book. I can easily change my project manager to add the text in a property so it wont render. Other suggestions? But I don't think an example in the Zope book should have this security issue. I hope I missed something. /Nocke

1 0

user accounts
by Richard Hewison 27 Feb '02

27 Feb '02

This is a problem that has dogged us for ages, and this is probably the third time we've asked for help here. Basically, new users added to specific folders within Zope (via the acl_users folder) cannot login to the system. The only account that seems to work fine is the one for the 'admin' user. The most annoying thing about this is that it *did* work when we first installed Zope, but somewhere down the line it stopped. This has happened on two different servers with two different operating systems (Sun SOlaris and now Linux) and two different versions of Zope (2.4.1 and 2.4.3). It's a fairly serious problem if we want to use Zope to handle our main web site in the future. Anyone had this and solved it? Does v2.5 have this as well? Richard H.

3 3

HOWTO collection
by Tille, Andreas 27 Feb '02

27 Feb '02

Hello, I just builded Debian packages from the Zope Book and Zope Development Guide. I consider the collection of the various HOWTOs as a valuable resource which I would like to check when developing offline. Thus I would like a tar archive of the HOWTO collection which I could easily handle (or even build a Debian package from it). Is there any possibility to get all the HOWTOs in a handy format? Kind regards Andreas.

1 0