- Zope - Zope lists

Report generation systems
by Dennis Allison 16 Mar '05

16 Mar '05

I am looking for a report generation system for Zope that would allow a user to dynamically specifiy a report using information drawn from our backend MySQL server. Crystal Reports is a commercial product in this space, but has many more features than we need and is costly.

1 0

How to change default python interpreter when launching zope with pythonservice.exe
by rdevriese＠comcast.net 16 Mar '05

16 Mar '05

Hello, Can someone point me to documentation that describes how to specify a different instance of the python interpreter when starting zope with pythonservice.exe. I have zope running on windows xp. Everything works fine if I use the runzope.bat file from the zope/bin directory, but when I have zope start as a service it uses the python interpreter that is bundled with zope. -- Thanks Rick

1 0

zClasses & MailHost Privileges
by Gre7g Luterman 16 Mar '05

16 Mar '05

I've created a product with zClasses that includes a script. The script must create a file in the current directory and then send a notification e-mail. (I put the MailHost instance in the product also.) I set the manager proxy on the script so that it would have sufficient access when run anonymously, but it didn't seem to work. The weird thing is that the script has enough rights to create the file -- so the proxy thing is obviously happening -- but it can't send the e-mail. Instead I get an unauthorized error: You are not allowed to access 'send' in this context. My guess is that the fact that this script is running within a zClass product is somehow restricting some, but not all, of the rights. That doesn't shock me, but the vital question is "How the heck do I make sure that my product has enough rights to send e-mail?" I tried to install that VerboseSecurity package, but I guess I didn't do it correctly because the error messages and log messages have no changed. They give me no new information about the problem. Can anyone out there please give me a quick step-by-step of what I have to change so that my product will have the right to send e-mail? Thanks in advance, Gre7g

1 1

COREBlog skins
by Brian Sullivan 16 Mar '05

16 Mar '05

I am thinking about using the COREBlog product as a blog on Zope. The supplied default skins however are somewhat less than visually pleasing (at least to my eye). Does anybody have any other skins -- or can point to sites using CoreBlog that have a different look?

2 2

Re: [Zope] Re: Regarding connecting to ZODB.
by Chris Withers 16 Mar '05

16 Mar '05

Karthikeyan palani wrote: > Hi, > I am developing a content management system based on Plone. i need to > know how to connect to a zodb.(Data.fs) and retrive infomation from > Data.fs. > Please send me an example code. Go ask on a Plone list... Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk

1 0

building a Javascript array with TAL in ZPT
by Etienne Desgagné 16 Mar '05

16 Mar '05

Hi everyone, I need to buid a javascript array of this form: var theArray = new Array("123|Beth","543|John","234|Ben","43|Leia","76|Steven","45|Rebecca","7686|Travis","3456|Kirk"); but by using TAL in a ZPT. The values come from a ZSQL method. It could look like this: var theArray = new Array( 1, ); but this is not working. (the ZSQL method contain the two columns of value) Someone have an idea? Thanks Etienne

4 3

Double and Triple Posts
by Andy Yates 16 Mar '05

16 Mar '05

I have a form that posts to a python script which can take several seconds to run. Sometimes the script gets called 2 or 3 times in the same request. It is not easy to reproduce but it seems to happen at least once every 20 requests. This is happening on two different versions of Zope and in two completely different projects. Zope only logs a single request. However, I know it is getting called more than once because the script writes to syslog. I've packet sniffed the browser and it is only sending one post. It happens in IE and FireFox but seems to be easier to reproduce in IE. IE will let you click more than once on the submit button. When I click the submit button twice sometimes I get 3 or 4 runs of the script. I would expect to get only two. It seems to happen much more often when I do this. (FireFox will only let you press the submit button once) It seems to happen if the script reads and writes values to context.REQUEST.SESSION. When I take this out it seems to stop. (It can be hard to reproduce) To reproduce this I created a script that calls an external method to syslog a message. Then it reads and writes to context.REQUEST.SESSION. Then it calls another external method to sleep 15 seconds. Finally it prints a message and returns. I see this behavior on Zope-2.7.3 and Zope-2.6.1. context.zsyslog('Snooze test' ) foo = context.REQUEST.SESSION.get('foo', 1) if foo==1 : context.REQUEST.SESSION.set('foo', 0) context.REQUEST.SESSION.set('bar',123) context.Snooze(15) print "I'm awake now!" return printed Please let me know if this is happening anywhere else. Andy

4 4

RE: [Zope] Troubleshooting Zope 100% CPU utilization
by Matthew X. Economou 15 Mar '05

15 Mar '05

All, I was able to get DeadlockDebugger working. I think my initial threadframe installation was corrupt, but re-installing both threadframe and DeadlockDebugger seemed to fix any issues there. With the following output, do I have enough information to go to someone with a bug report? At this point it seems Zope isn't the problem, but I want to know if there is any other information I can glean before reporting a bug in LDAPUserFolders or python-ldap. So: I have a spinning Zope and the DeadlockDebugger output. The last few lines of each thread look like: File "/var/www/zope/Products/LDAPUserFolder/SharedResource.py", line 110, in __call__ self._lock.acquire() File "/usr/local/lib/python2.4/threading.py", line 100, in acquire rc = self.__block.acquire(blocking) One thread is stuck here (possible race condition?): File "/usr/local/lib/python2.4/site-packages/ldap/ldapobject.py", line 169, in simple_bind return self._ldap_call(self._l.simple_bind,who,cred,serverctrls,clientctrls) File "/usr/local/lib/python2.4/site-packages/ldap/ldapobject.py", line 91, in _ldap_call self._ldap_object_lock.acquire() And finally, one thread is stuck here: File "/var/www/zope/Products/LDAPUserFolder/LDAPDelegate.py", line 292, in _connect connection.simple_bind_s(user_dn, user_pwd) File "/usr/local/lib/python2.4/site-packages/ldap/ldapobject.py", line 760, in simple_bind_s return SimpleLDAPObject.simple_bind_s(self,*args,**kwargs) File "/usr/local/lib/python2.4/site-packages/ldap/ldapobject.py", line 176, in simple_bind_s self.result(msgid,all=1,timeout=self.timeout) File "/usr/local/lib/python2.4/site-packages/ldap/ldapobject.py", line 399, in result res_type,res_data,res_msgid = self.result2(msgid,all,timeout) File "/usr/local/lib/python2.4/site-packages/ldap/ldapobject.py", line 405, in result2 return self._ldap_call(self._l.result2,msgid,all,timeout) File "/usr/local/lib/python2.4/site-packages/ldap/ldapobject.py", line 94, in _ldap_call result = func(*args,**kwargs) What do these thread backtraces show? What additional information can I gather? Best wishes, Matthew -- "The challenge of a moral life is to do nothing that requires forgiveness." - Roger Ebert in his review of _The Woodsman_

1 0

Problems with removing Verbose Security and possibly Apelib
by Chris Kratz 15 Mar '05

15 Mar '05

We've run into a very strange situation. We been running zope 2.7.3 with Abelib 1.0 and Verbose Security 0.6. Verbose Security is great during development, but it does cause somewhat of a performance hit on a live server. So, recently after profiling our app in zope and finding that Verbose Security was eating a fair amount of time, I decided to try and remove it on our production systems. I removed the Verbose Security from the products directory and from the Products list in the control panel and tried the app again. Unfortunately, this causes the app to break. What appears to happen is that on any object we have used proxy settings on, when run without verbose security, we get a security error. If I go into that object on to the proxy tab, the roles are still selected and clicking update (with making no other changes), "fixes" the problem for a user. What is even weirder is that because we are using apelib, it is easy to see the changes made to the object when we make changes in the zmi. In this particular instance, we can see that even though the object was saved in the ZMI, and the files on disk were modified, the contents of the objects did not change when we updated the proxy settings, yet zope now appears to obey them. The last piece of the puzzle is that returning the VerboseSecurity product allows the application to start working again, proxy roles and all. Any ideas as to why this might be? Is there a chance that the monkey patching Verbose Security does is not reversible? Or is there some weird problem caused by using Verbose Security and Apelib? Thanks for your time, -Chris --- Error example Error Type: Unauthorized Error Value: You are not allowed to access 'select' in this context ...last lines in traceback # PythonScript at /somefunction> Line 3 # Module Shared.DC.Scripts.Bindings, line 178, in __getattr__ Unauthorized: You are not allowed to access 'select' in this context

2 3

RE: [Zope] Troubleshooting Zope 100% CPU utilization
by Matthew X. Economou 15 Mar '05

15 Mar '05

The story thus far: 1. I installed DeadlockDebugger, but I couldn't get it to work. I kept getting errors when I tried to view its special URL, so I gave up on getting it working. 2. I upgraded to Python 2.4 as there were some fixes to threading support that haven't been backported to Python 2.3. Now, instead of hanging the entire instance when Zope begins spinning, it only hangs the Plone site (and I can access the Zope instance's root). 3. In my backtraces using GDB, I saw that Zope is stuck in a select loop waiting on an LDAP connection (I'm using LDAPUserFolders to authenticate to Active Directory). I don't know if the problem is in LDAPUserFolders, python-ldap, or OpenLDAP's client libraries. What is especially frustrating is that this same software works fine on a different architecture. The LDAP connection is in a CLOSE_WAIT state. The Zope instance sends a FIN/ACK and receives an ACK from the domain controller. The domain controller sends a FIN/ACK, but Zope never sends the final ACK to close the connection. Instead, it spins around a call to select(2) with the connection stuck in CLOSE_WAIT. I will continue to try to get DeadlockDebugger working and follow up with Dataflake, the python-ldap-dev mailing lists, or with the OpenLDAP maintainers (as the case may be). As always, your suggestions are most welcome. Best wishes, Matthew -- "The challenge of a moral life is to do nothing that requires forgiveness." - Roger Ebert in his review of _The Woodsman_

2 1