- Zope - Zope lists

Problems with Zope and SQL methods
by Neil McIntosh 03 Jun '01

03 Jun '01

Hello all, I have recently upgraded and moved a zope server to 2.3.2. This has proved a difficult task as we are using it to access an intranet database running on Postgresql back end. Whenever a query is run where an oid is returned it hangs the ZServer and core dumps. eg select * from people OR select p.oid, p.name from people p This can be avoided by setting the type as follows. select p.oid::int, p.name from people p However the following will still cause a core dump select p.oid::int, p.* from people p. I have noticed that others have been having similar problems but not seen any solutions on this list. I am using the following ZPoPyDA 1.2 ZSQLMethods 1.2.1 and quite a lot else. postgres 7.1-1 for reference. Thanks, Neil McIntosh IT Manager Sentec Ltd.

1 0

RE: [Zope] I want to script in Python and not Zope-Python
by sean.upton＠uniontrib.com 03 Jun '01

03 Jun '01

ZPublisher / External Methods / Product API - 3 different ways to do python using Zope (or portions thereof). What more does one need? I guess I don't understand why not just build your classes, and wrap them using the Python product API? Everything you do in python is thinly wrapped in a bit of management, allowing for to be persistence. If you don't want/like/need that, just use ZPublisher to publish objects from your classes instead of a complete Zope - you lose persistence, but if you have no need for it... If one wanted to do something really strange, one could write code that used the ZODB outside of Zope, and use ZPublisher to publish it.. oh wait, I think that's been done before... :) If your code is not really OO, I think there might be something out there like Python server pages, or something equally as dilute, but external methods are still an easier concept, IMHO... ZPublisher might buy you what you are looking for, though I have to say, personally, that OOP without an object database now seems like Cola without fizz and caffeine to me - either that, or someone has been secretly adding addictive substances to the Zope releases - i.e. acquisition, not to mention that extra caffeine ;) ... Cheers, Sean -----Original Message----- From: Tim Cook [mailto:twcook@iswt.com] Sent: Saturday, June 02, 2001 8:56 PM To: tom smith Cc: E. Seifert; zope(a)zope.org Subject: Re: [Zope] I want to script in Python and not Zope-Python tom smith wrote: > > >> Is there any way to let python scripts to have access to all the bits and > >> bobs I've got going with python, like MySQL (or Tk even) rather than have > > to > >> deal with python-in-zope. > > > > This is a question of security. You can't let Zope users use all aspects of > > Zope. > > What if I'm the only zope authorer? I fairly sure I can trust myself. > > >> ...And don't want to muck about with external methods. I want FULL python > >> power within zope. > > > > To leverage the full power of Zope just use external methods. They allow to > > write fully functional python applications which you can access from within > > Zope. > > Hello?! I don't want to use external methods. > Well Tom. I would suggest one of three choices. 1) Use something else instead of Zope (you will be using a lesser tool though). 2) Rebuild your copy so it works the way you want (you have the source). 3) Get used to external methods. Personally, I picked # 3. <s> -- Tim Cook, President - FreePM,Inc. http://www.FreePM.com Office: (731) 884-4126 ONLINE DEMO: http://www.freepm.org:8080/FreePM _______________________________________________ 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 )

1 0

DocumentLibrary FileConverter / pdf.py problem (write to /tmp)
by sean.upton＠uniontrib.com 02 Jun '01

02 Jun '01

I wanted to say, so far, DocumentLibrary seems to be a wonderful product - very useful, organized, and looks very easy to customize - I'm impressed. I am, however, having a bit of a problem... I installed DocumentLibrary on Zope 2.3.2 the other day. I have a problem with the PDF conversion, though I have verified the pdftotext works properly on all my files. I commented out in pdf.py the code to delete the file in /tmp, so I could do a diff on the output with the original PDF - but I didn't need to: the file sizes were radically different: www:/tmp# ls -l *pdf* -rw-r--r-- 1 www-data www-data 123512 Jun 1 20:34 pdf_tmp_991452845.246 -rw-r--r-- 1 root root 320120 Jun 2 16:26 text.pdf ...where text.pdf is a copy of the original. Hexdump output shows these files to be identical, just that the pdf being dumped out of Zope on to the fs seems to be truncated abruptly. I've used several PDFs generated from different sources. My config is the binary package install of Zope on Debian using the 2.3.2-2 deb under Debian unstable/intel, using nothing fancy in the setup... wvWare/word converter works fine, I tested several differnt packages and source installs for xpdf, and all worked fine (this was before I realized that this wasn't a pdftotext issue)... www-date (the user Zope runs as on Debian) has write privileges to /tmp, and the file starts to write out there part way; what might prevent the pdf.py code from fully writing the file to /tmp from the ODB? Any thoughts might be appreciated... Sean P.S. I am interested in possibly contributing effort to write / integrate other sorts of document/file converters into DocumentLibrary. Specifically, I might be interested in adding the ability to treat raster images (JPG, etc) as documents, with the ability to use the binary IPTC caption data (the caption you can add to an image in photoshop) as the full text... ========================= Sean Upton Senior Programmer/Analyst SignOnSanDiego.com The San Diego Union-Tribune 619.718.5241 sean.upton(a)uniontrib.com =========================

1 0

Problems with ZCatalog
by Stefan Heimann 02 Jun '01

02 Jun '01

Hi! I have created a ZCatalog, but whenever I try to access the 'Catalog' view in the management interface of the ZCatalog, I get en error message: Zope has encountered an error while publishing this resource. Error Type: AttributeError Error Value: class NoBrainer has no attribute '__call__' Traceback (innermost last): File /usr/local/Zope-2.3.1-src/lib/python/ZPublisher/Publish.py, line 223, in publish_module File /usr/local/Zope-2.3.1-src/lib/python/ZPublisher/Publish.py, line 187, in publish File /usr/local/Zope-2.3.1-src/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: Traversable) File /usr/local/Zope-2.3.1-src/lib/python/ZPublisher/Publish.py, line 171, in publish File /usr/local/Zope-2.3.1-src/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_catalogView) File /usr/local/Zope-2.3.1-src/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: manage_catalogView) File /usr/local/Zope-2.3.1-src/lib/python/Shared/DC/Scripts/Bindings.py, line 324, in __call__ (Object: manage_catalogView) File /usr/local/Zope-2.3.1-src/lib/python/Shared/DC/Scripts/Bindings.py, line 354, in _bindAndExec (Object: manage_catalogView) File /usr/local/Zope-2.3.1-src/lib/python/App/special_dtml.py, line 236, in _exec (Object: manage_catalogView) File /usr/local/Zope-2.3.1-src/lib/python/DocumentTemplate/DT_In.py, line 627, in renderwb (Object: searchResults) File /usr/local/Zope-2.3.1-src/lib/python/DocumentTemplate/DT_With.py, line 132, in render (Object: aq_self) AttributeError: (see above) This error also occurs when I try to find new objects for my catalog. I also created a product which uses ZClasses that are ZCatalog:aware, and I want these objects to get indexed automatically. Could this be a problem?? Here are some informations about my system: Zope 2.3.1 (source release, python 1.5.2, linux2) 2.1 (#1, Apr 26 2001, 10:44:51) [GCC 2.95.4 20010319 (Debian prerelease)] linux2 Thank you Stefan

2 1

Warning: self._setObject() failed for PluginIndexes/Installed product PluginIndexes
by Norman Khine 02 Jun '01

02 Jun '01

Hello, I just checked out a copy of the zope core and installed it. When I started Zope I got the following error: Warning: self._setObject() failed for PluginIndexes/Installed product PluginIndexes Zope Version (unreleased version) Python Version 2.1 (#1, Jun 2 2001, 10:12:16) [GCC 2.95.2 19991024 (release)] System Platform freebsd4 Also there is no link to add ZGadfly Database Connection from the Pull-down menu. Regrads Norman /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Norman Khine /*/ /*/ /*/ \*\_ |*| |*||*| mailto:khine@o-a-l.net /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Purley, UK /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ /*/ \*\

1 0

Z2.log wrong time stamps
by Felipe E. Barousse Boue 02 Jun '01

02 Jun '01

Hi all: I have been searching around and since about 1 year ago there are posts regarding systems where the Z2.log date stamps are wrong. I have not been able to find a definite answer/solution to this issue. I am running now Zope 2.3.2 with the hotfix 2001-05-01 installed, the problem of the wrong dates on the Z2.log is still there. I saw that someone even runs, at a later time, his logs through a script to correct the wrong time/date stamps. My case is as follows: I have Zope running behind Apache with pcgi all is working perfectly fine. The following line is the Apache log: 62.82.123.115 - - [02/Jun/2001:12:44:44 -0500] "GET /piensa/dir_foros/Principiantes/989360989/index_html HTTP/1.1" 200 10557 This is the line on Z2 for the object that was served by Zope 127.0.0.1- - [02/jun/2001:17:44:44 -0500] "GET /piensa/dir_gaceta/piensa/dir_foros/Principiantes/989360989/index_html" 200 10678 You can see the correct time is on the Apache log (02/Jun/2001:12:44:44 -0500]) but the Zope one has an 5 hour difference. I see no current relation to using GMT / UTC times with Zope. All my systems are running either Red Hat Linux 6.1, 6.2 or 7.x all with the same symptoms regarding this problem. Has anyone detected this problem in your system? Has it been solved? How? Hope to get some feedback this time. Felipe Barousse

1 0

passive FTP in Zope
by Arkaitz Bitorika 02 Jun '01

02 Jun '01

Hi all, Is it possible to use passive FTP with the Zope builtin FTP server? I'm behind a firewall that only allows passive ftp, and having lots of problems to use Emacs to edit a remote Zope site. Cheers, Arkaitz.

2 1

Something wrong with 2.4
by Norman Khine 02 Jun '01

02 Jun '01

Hello I just build a fresh install of 2.4 and also python2.1, ALL compiled correctly and without any problems. I also installe ZMySQLDA, which installed without a problem. Here is a copy of the products Type Name Size Last Modified ExternalMethod (Installed product ExternalMethod (External Method-1-0-0)) 2001-06-02 10:37 MIMETools (Installed product MIMETools) 2001-01-20 21:39 MailHost (Installed product MailHost (MailHost-1-2-0)) 2001-06-02 10:37 OFSP (Installed product OFSP (OFSP-1-0-0)) 2001-06-02 10:37 PluginIndexes (Installed product PluginIndexes) 2001-06-02 10:37 PythonScripts (Installed product PythonScripts (PythonScripts-2-0-0)) 2001-06-02 10:37 SiteAccess (Installed product SiteAccess (SiteAccess-2-0-0)) 2001-06-02 10:37 StandardCacheManagers (Installed product StandardCacheManagers (StandardCacheManagers-1-1-0)) 2001-06-02 10:37 ZCatalog (Installed product ZCatalog (ZCatalog-2-2-0)) 2001-06-02 10:37 ZGadflyDA (Installed product ZGadflyDA) 2001-01-20 21:39 ZMySQLDA (Installed product ZMySQLDA) 2001-06-02 11:14 ZSQLMethods (Installed product ZSQLMethods) 2001-06-02 10:37 ZopeTutorial (Installed product ZopeTutorial (Zope Tutorial 1.0)) 2001-06-02 10:38 OK, what is the problem, well when I try to add say either ZGadflyDA or ZMySQLDA from the Pull-down menu, I don't have the option to ADD this. Have I missed something with the security configuration/setup, that I have to do manually for these products? Thanks Norman /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Norman Khine /*/ /*/ /*/ \*\_ |*| |*||*| mailto:norman@khine.net /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Purley, UK /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ /*/ \*\

1 0

Zope Versions and Database Adapters
by Christian Theune 02 Jun '01

02 Jun '01

Ok i posted a few days ago, because my Zope was crashing. I found, that working concurrently in Versions is NOT good with the Core Session Tracking, because the internal DataContainer is modified via the ZODB and crashes through the versions. I told my people to work one day without any versions, so we managed versioning by talking to another who is modifying what. This day zope did not crash at least one time. I had the same encounter with the ZPoPyDA (possibly EVERY DA?) and found that there are things being modified through the ZODB and if you do so in concurrent version ... hmm you know ... locking problems. Any comments on this? -- Christian Theune - ct(a)gocept.com gocept gmbh & co.kg - schalaunische strasse 6 - 06366 koethen/anhalt tel.+49 3496 3099112 - fax.+49 3496 3099118 mob. - 0178 48 33 981 reduce(lambda x,y:x+y,map(lambda x:chr(ord(x)^42),tuple('zS^BED\nX_FOY\x0b')))

1 0

manage_main modification time
by Andrew Sydelko 02 Jun '01

02 Jun '01

Our Zope installation has this really strange problem associated with the displayed "Modification Time" shown for each file in the /manage_main of a folder. The time that is shown is exactly one-hour later than the system time. I think I've tracked down this to the bobobase_modification_time variable. Both reference to <dtml-var "ZopeTime()"> and <dtml-var "_.DateTime()"> show the system time. <dtml-var "_.DateTime().timezone()"> shows US/Eastern. This is really not our correct timezone, since we are in West Lafayette, Indiana, which has it's own timezone: US/East-Indiana, but where does Zope/python get this from? Any ideas why bobobase_modification_time is off by one hour? --andy. Purdue Engineering Computer Network

1 0