January 2005 - Zope - Zope lists

New ZMysql adapter connection problem
by Larry McDonnell 18 Jan '05

18 Jan '05

Hi, I'm test 2.7.3 out and I cannot create a connection to my database. I am using the new adapter ZMySQLDA-2.0.9b2 <http://sourceforge.net/projects/mysql-python/> .and I loaded MySQL-python.exe-0.9.2.win32-py2.3.exe pointing it to the bin directory of my zope installation. It added it to my product list but when I try to make a connection I see the following: Traceback (innermost last): * Module ZPublisher.Publish, line 175, in publish_module_standard * Module ZPublisher.Publish, line 132, in publish * Module Zope.App.startup, line 204, in zpublisher_exception_hook * Module ZPublisher.Publish, line 101, in publish * Module ZPublisher.mapply, line 88, in mapply * Module ZPublisher.Publish, line 39, in call_object * Module Products.ZMySQLDA.DA, line 106, in manage_addZMySQLConnection * Module Shared.DC.ZRDB.Connection, line 64, in __init__ * Module Shared.DC.ZRDB.Connection, line 97, in edit * Module Products.ZMySQLDA.DA, line 126, in connect * Module Products.ZMySQLDA.db, line 183, in __init__ AttributeError: server_capabilities (Also, an error occurred while attempting to render the standard error message.) I also tried a password option but still no connection. I know I could do the above in 2.6.1. Thanks, Larry

4 7

kinterbasdbDA Open Connection
by Ashley 18 Jan '05

18 Jan '05

Apologies if this has been answered previously - I have seen some similar posts from years ago, but could not find any solutions. I have defined a K Interbase Database Connection in my ZMI. Everything appears fine until I attempt to open the connection using the "Status" page in the ZMI. At this point, I get a standard "page not found" screen. This is not a Zope error page, just a standard IE "HTTP 400 - Bad Request" page, which of course gives me no useful information. It appears from the form on the previous page that the page that is being called is "manage_open_connection". If I attempt to change connection properties using the "Properties" page, then as long as "Connect Immediately" is not checked, then everything is ok, and the changes are saved. If it is checked, then I get the same error page. The page that is being called from here appears to be "manage_edit". The Zope version is actually from a Plone 2.0.5 installation (this is not taking place inside the Plone instance, hence posting here), Plone Controller 0.3, Python 2.3.3 on win32. I cannot find anthing including "manage_open_connection" in the kinterbase folders, but from a previous post I guess it is aiming for the function in "Plone\Zope\lib\python\Shared\DC\ZRDB\Connection.py". What I don't have any idea about is why it isn't working, and what I can do about it. Can anybody help? Thanks in advance Ashley

2 1

Zope xmlrpc crashes without traceback
by Herman Geldenhhuys 18 Jan '05

18 Jan '05

Hi. We are using a javascript xmlrpc(VCXMLRPC.js) library to essentially communicate with zope to retreive and display records in a browser. After a while, Zope just crashes without warning or any traceback of what caused the problem. It completely dies. When running in a command prompt, it dies silently as if the python interpreter crashed. We're running version 2.7 of zope with Python 2.3 on multiple window$ NT servers. Has anybody got a solution for this problem? -- G M S Software Factory Tel. +27 (11) 695 0400 x210 Fax +27 (11) 312 0265 Cell+27 (82) 770 7198 www.gmsonline.co.za <http://www.gmsonline.co.za/>

4 4

Programmatically delete an object
by jlegris 18 Jan '05

18 Jan '05

Hi All, I am having trouble finding an example of how to programmatically delete an object from a folder in Zope. Any info or direction in this regards would be greatly appreciated. Thanks, Joel

9 9

uploading a file via an external method
by Kate Legere 18 Jan '05

18 Jan '05

I've used this to upload files to a specific directory, not to Zope (or as an Zope object). The problem is that it's looking in the folder for the files and I'd like it to upload from a chosen directory (or my desktop) in the same way as manage_addFile does. Kate external method called upload_external: import os, shutil def upload_external(self,file,REQUEST): #check if file was sent correctly if file.read(1) == '': return '<h2>File does not exist</h2>' else: file.seek(0) iname=os.path.basename(file.filename) oname=os.path.join(self.savedir,iname) f=open(oname,"wb") f.write(file.read()) # let's get the mime information mime_type=file.headers.headers[1] user=str(REQUEST.AUTHENTICATED_USER) try: self.add_entry(path=self.savedir,filename=iname,owner=user) except: os.remove(oname) return '<h2>File upload not completed correctly</h2>' return '''<h2>%s was sent correctly, and saved in %s</h2><h3>The Mime Type of the file is</h3>%s<h3>Saved by</h3>%s''' % (iname,oname,mime_type,user) The self.savedir is a property set in the folder which contains the external method and tells the external method where to put the file. The self.add_entry is an update on a database to keep track of the files uploaded, etc. ---------- upload_html: <FORM ACTION="upload_external" METHOD="POST" ENCTYPE="multipart/form-data"> <TABLE CELLSPACING="2"> <TR> <TH ALIGN="LEFT" VALIGN="TOP">File</TH> <TD ALIGN="LEFT" VALIGN="TOP"> <INPUT TYPE="file" NAME="file" SIZE="25" VALUE=""> </TD> </TR> <TR> <TD></TD> <TD><BR><INPUT TYPE="SUBMIT" VALUE="Change"></TD> </TR> </TABLE> </FORM>

2 1

RE: [Zope] ZEO-Client
by Arenz, Ralph 18 Jan '05

18 Jan '05

-----Ursprüngliche Nachricht----- Von: Tino Wildenhain [mailto:tino@wildenhain.de] Gesendet: Mittwoch, 12. Januar 2005 13:47 An: Arenz, Ralph Cc: 'zope(a)zope.org' Betreff: RE: [Zope] ZEO-Client On Wed, 2005-01-12 at 11:42 +0100, Arenz, Ralph wrote: > > -----Ursprüngliche Nachricht----- > Von: Tino Wildenhain [mailto:tino@wildenhain.de] > Gesendet: Mittwoch, 12. Januar 2005 11:34 > An: Arenz, Ralph > Cc: 'zope(a)zope.org' > Betreff: Re: [Zope] ZEO-Client > > > On Wed, 2005-01-12 at 11:16 +0100, Arenz, Ralph wrote: > > Hi, > > > > i' am using Zope-2.7.3 and i wan't my client-storages to be connected at > > zope-startup. > > In Zope-2.6.3 i used "open_at_startup" in DBTab but this option seems not > to > > be included > > in release 2.7.3, however i can't find it in component.xml. If i add it to > > zope.conf anyway i get > > an exception. > > >What do you mean by "open_at_startup"? > >If you configured the storages in zope.conf, > >you go to ZMI and add a DBTab Mount point, > >check all storages you want to mount > >and add. From now on the clients are connected > >each time zope starts. > > >HTH > >Tino > > > The option "open_at_startup" means that the client-databases are opened at > zope-initialization (not when zope is already up). If this fails zope won't > come up. > That feature is useful if Zope shouldn't run without an paticular storage. >This works the same if you do it like I described. Once you use the >database, it is required for zope to start up. e.g. Zope will wait when does it wait, is the question! >until the database (zeo) is ready. >Regards >Tino If i using the option "open_at_startup" my stupid-log under 2.6.3 shows "client-connected" before ZServer is up on it's desired port. Without this option the connection takes place after ZServer is up on it's port, that the significant difference. Sometimes there is a time delay of a few minutes after zope is up before the connection is made (the mounted storage is about 6GB ;-)). I can't except these delay so i packed this into the initialization part (before zope is up) with the option "open_at_startup". So back to my first question, where ist that option gone in Zope-2.7.3? any ideas? Ralph

4 4

HOWTO add a new Python alongside an old
by hpinson＠indepthl.com 18 Jan '05

18 Jan '05

After some excellent suggestions, here is one way to add a new Python version alongside an old one (as one might need to do in the Fedora environment when upgrading Zope.) I chose to build a clean version of Python 2.3.4 and run it alongside other Python versions that were on the system (2.3.3) -- Get the version of Python you need from www.python.org (Check Zope/Plone dependancies) -- Put the tarball somewhere, like: /home/myhome/src/python/2.34 -- su to root $ cd /home/myhome/src/python/2.34 $ gunzip version_of_python.tgz $ tar -xvf version_of_python.tar $ cd version_of_python $ ./configure --prefix=/opt/python2.3.4 (Assuming that's where you want to put it. /usr/local could be used as well.) $ make $ make install $ ln -s /opt/python.2.3.4/bin/python2.3 /usr/bin/python2.3.4 $ cd /usr/bin $ chmod 755 python2.3.4 -- Test: $ python2.3.4 You should get a version listing of 2.3.4. Ctrl-D to exit. To be safe, you should rebuild the Zope extension modules after upgrading to the new Python: $ cd /path/to/Zope/src/ $ configure --prefix=/path/to/ZopeInstallation --with- python=/opt/python2.3.4/bin/python # + other args $ make $ make install -- Then modify zopectl and runzope in /etc/zope-instance/bin to the new path to Python 2.3.4. Back these up before making changes. -- Restart Zope: $ service zopectl restart (assuming you have created such a service) Hopefully, Zope will start. Harlow Pinson Indepth Learning Email: hpinson(a)indepthl.com Web: http://www.indepthl.com Voice: 505-994-2135 FAX: 208-475-7678

1 0

Re: Python 2.3.3 vs. Python 2.3.4
by hpinson＠indepthl.com 18 Jan '05

18 Jan '05

Ok. This seems to have worked for me on Fedora Core 1, where there is a risk of hosing your system python if you do not do this right. I chose to build a clean verion of Python 2.3.4 and run it alongside other Python versions that were on the system. Get Python from www.python.org Put the tarball somewhere, like: /home/myhome/src/python/2.34 su to root cd /home/myhome/src/python/2.34 gunzip version_of_python.tgz tar -xvf version_of_python.tar cd version_of_python ./configure --prefix=/opt/python2.3.4 make make install ln -s /opt/python.2.3.4/bin/python2.3 /usr/bin/python2.3.4 cd /usr/bin chmod 755 python2.3.4 To test, type: python2.3.4 You should get a version listing of 2.3.4 and the Python console. Ctrl-D to exit. Then modify zopectl and runzope in /etc/zope-instance/bin to point to the new path to Python 2.3.4. Back these files up before making changes. Restart Zope, hopefully without any problems: service zopectl restart (assuming you have created such a service) If Zope will not start, you can always revert the paths in zopectl and runzope to the old python, whatever that was. Again, be very careful on Redhat / Fedora systems that rely on Python for critical services... I would hate to hear that someone overwrote their system Python! Good luck to the next vict... er... I mean... lucky person who trys this. Harlow Pinson Indepth Learning Email: hpinson(a)indepthl.com Web: http://www.indepthl.com Voice: 505-994-2135 FAX: 208-475-7678

2 1

Bad performances with ordered folders
by Thierry FLORAC 18 Jan '05

18 Jan '05

Hi, I use Zope (2.6.1) and subclasses of the "old" OrderedFolder product (release 0.4) to handle my internal site. Each "sub-site" is a kind of "big folder", handled by a specific "sub-manager", containing until two levels of sub-folders. Each folder or sub-folder is a subclass of OrderedObjectManager, containing documents (stored as ExternalFile subclasses) as well as other instances of custom properties. I have an "index_html" method (in DTML) defined for each folder or sub-folder, which displays the ordered hierarchy of the given folders or sub-folders ; access is checked against every sub-folder, so that "private" folders or sub-folders are not displayed to unauthorized users. Data handling is OK, but while displaying my other custom classes instances is quite quick, displaying these OrderedObjectManager instances is quite slow, even when a sub-site is containing only a few number of folders or sub-folders. I've tried to use a profiler to find a bottleneck, but don't know Zope and Python internals very well so handling this problem is not very easy. Any help or advise would be very helpful. Thanks, Thierry

1 0

RE: [Zope] Python 2.3.3 vs. Python 2.3.4
by hpinson＠indepthl.com 18 Jan '05

18 Jan '05

>> perhaps an rpm -Uvh rather than an rom -ivh is a better idea >> when upgrading? I am literally terrified of overwriting the Fedora Core 1 System python in this manner (this is a production system). If I did that, FC1 would be trashed, as lots relys on the older version of Python. I have no way to judge if what you suggest is safe of not, except some vague Q&A's at python.org that might suggest that it is. My understanding is that -ivh will install alongside previous versions as opposed to upgrading them, and thus is a safer option. >> Build python This is maybe what I should do. Can and one provide definitive insight into how to do this alongside the existing FC1 python. The two python versions must be completely separate, or the system is toast. I'm guessing something along the lines of: cd python2.4 configure --prefix=/where/should/I/put/python? make make install Per above, I need help with the prefix-- what should the path to the new python be? There shold be no chance of overwriting the system python. Thanks! Harlow Pinson Indepth Learning Email: hpinson(a)indepthl.com Web: http://www.indepthl.com Voice: 505-994-2135 FAX: 208-475-7678

5 4