December 2002 - Zope

Mysql-Connection in Python-Script
by Lukas Pitschl 18 Dec '02

18 Dec '02

I would like to use a Mysql-Connection in a Zope-Python-Script. Could someone explain how that works? I have to import some CSV-data into a database thanks in advance lukas -- ============================== > lukas pitschl > web development > > peer internet solutions > http://www.peer.biz > pillhof 25 - 39010 frangart > tel. +39/0471 63 10 80 > fax +39/0471 63 17 24

4 3

Win32, Zope and FTP
by toman 18 Dec '02

18 Dec '02

I'm trying to put together a collaboration app that allows users to share large datasets. When I ftp the data, which has numerous folders and large (~100Meg) and small files in them, to a Zope 2.6.0 server running on Windows XP, it will transfer many but not all of the datasets. Then if I try to make another object, say a folder, through ftp or the management screens, the server hangs. The same test on a Linux box running Mandrake 8.something doesn't show this problem at all. Ideas? I would guess that it's a threading problem, mostly because in my experience threads suck on Windows, but I don't know enough about the Zope internals to prove it. Changing the backend from FileStorage to DirectoryStorage(lawn) didn't seem to change the behavior either. Any help, yada yada... J. Toman

3 3

swocket integration
by Ed Colmar 18 Dec '02

18 Dec '02

I remember seeing a post about someone trying to use swocket with zope... Just searched the archives, no luck... Has anyone been playing with this? If not, any ideas if it would work ok? If I start the swocketserver from within a zope product, I should have access to self. and inheritance and all that from within swocket? Sounds like it would be a cool little add on, and it sure would make persistant connections easy. (from within flash at least) With XML-RPC for flash coming along, and a socket server, it could make zope a lethal alternative to the macromedia proprietary product. Any ideas? -ed- -- Green Graphics ::: Print and Web Design ::: 510.923.0000

2 1

Upgrading zope
by Mark Gibsonz 18 Dec '02

18 Dec '02

I have a client working on zope 2.3.3. What are the advantages to upgrading zope to the latest version? It's likely to be a big job, how can I justify this? What are the risks to upgrading? Thanks, Mark _______________________________________________ Join Excite! - http://www.excite.com The most personalized portal on the Web!

4 3

zope error<200>
by Francoise Guilbault 18 Dec '02

18 Dec '02

Platform: W2K I installed localizer in the products sub-dir and started up the zserver and got the following error: Zope could not import Products.Localizer Traceback <innermost last>: Module OFS.application, line 541, in import_product Module Products.Localizer, line 290, in ? Module App.ImageFile, line 44, in __init__ IOError: [Errno 21] No such file or directory: xxxx\\xxxxx\\xxxxx...... Any clues would be greatly appreciated. TIA frankie guilbaultf(a)agr.gc.ca

2 1

RE: [Zope] My Zope is leaking memory ... Still no luck. (PythonSc ript bug)
by Jean-Francois.Doyon＠CCRS.NRCan.gc.ca 18 Dec '02

18 Dec '02

Hello, Well, I tried to look at the PythonScript issue, and it looks like there's definitely something "odd" going on here ... As Jo suggested, I tried "cleaning out" my variables at the end of my Python Scripts ... I didn't do this for ALL of them though, just the most used ones, which actually aren't CMF related (Search Engine is one) ... And now what happens is the memory grows, BUT, at some point, the Zope process DIES with a SIG11 (Aieeee!), restarts, and voila, of course, the memory is clean. This I suppose is a blessing is disguise, as I don't have to keep an eye on it anymore, I can actually rely on a SIG11 occuring and restarting the leaking process for me !!! But this to me indicates some worrying problems with the PythonScript implementation. Although I have looked everywhere else for the source of my memory leak, this is the best candidate yet. I even looked at this document: http://www.zope.org/Members/mcdonc/HowTos/PreventAndDebugMemLeaks and looked through my scripts for global variables that don't get reset, and circular references, but not luck ... I am confused about the following statements though: "DO use REQUEST.set and REQUEST.__setitem__ sparingly." "DONT stuff things that are acquisition-wrapped into REQUEST or into a session, or into any other object that is transient." What does that mean exactly? :) I don't use SESSION's , but I like to stuff things into my REQUEST object indeed quite a bit. Could this be it? And if so ... out of pure curiosity, why is this bad? I have found using dtml-let to be awkward to use at times ... and "DO use global variables sparingly." "DONT stuff things into a global variable without later clearing or deleting the variable." Global in reference to what ? :) In my External Methods, I have no global variables, that is no variables that don't belong inside a def'ed function (and allways "reset" before being used) ... In PythonScripts themselves, I think I NEVER use functions, just straight code, so by definition all variables ARE global to that script ... Is this bad? Thanks again to everyone for the help and comments! J.F. -----Original Message----- From: Jo Meder [mailto:jo@meder.de] Sent: Friday, November 29, 2002 5:29 PM To: Jean-Francois.Doyon(a)ccrs.nrcan.gc.ca Cc: zope(a)zope.org Subject: Re: [Zope] My Zope is leaking memory ... Still no luck. Am 29.11.2002, 21:06 Uhr schrob Jean-Francois.Doyon(a)CCRS.NRCan.gc.ca <Jean-Francois.Doyon(a)CCRS.NRCan.gc.ca>: [Forcing transient objects to be deleted at end of PythonScripts to avoid memory leaks] > Really? Wow, you'd think such a required behavior would be documented ... > Unless I missed it somewhere. AFAIK it isn't documented and IMHO it's a bug anyway, so I suppose it should not be documented but solved. Sigh. So much to do and so little time. > I do indeed use quite a bit of Python Scripts ... Problem is many of them > are part of the CMF ... Perhaps we have a pattern here. Just like you we use CMF, but we started with an older version (that was mostly DTML and only some PythonScripts) and have since then rewritten or at least changed almost everything in the skins folders. One problem wrt to the memory leaks we have not solved yet: When we refresh one of our products that is part of our CMS Zope starts to leak memory like there's no tomorrow. Restarting Zope immediately stops this. > I really don't want to have to go through every bit of python script I > have to do this, and would much prefer finding the root cause! If you have any success, even clues or insights: I'd very much appreciate it if you kept me (or the list, of course) posted. Jo. -- Internetmanufaktur Jo Meder ---------------------- Berlin, Germany http://www.meder.de/ ------------------- fon: ++49-30-417 17 63 33 Kollwitzstr. 75 ------------------------ fax: ++49-30-417 17 63 45 10435 Berlin --------------------------- mob: ++49-170- 2 98 89 97 Public GnuPG-Key ---------- http://www.meder.de/keys/jo-pubkey.txt

2 1

newbie: why can't I list directories under ftp on RH7.2?
by Ray Peck 18 Dec '02

18 Dec '02

Hi! I'm a new Zope user / admin and so far am pretty happy with the system. I've been a software developer for about 12 years (I was a CPU engineer before that), working on things as diverse as object-code rewriting, RISC assembler code graphics libraries, writing a Java distributed object platform and rewriting a WYSIWYG web-based website editor to use an XML page representation. I'm impressed with the comprehensiveness of what's available in Zope and am happy to be here. Question: I've set up the server on my rh7.2 machine, connected through Apache and using virtual hosts and SiteRoot. All is going well so far (my initial site is http://www.sfbagc.com) except for ftp. I've opened up port 8021 using ipchains to my local network, and I can ftp to the server from localhost or from a Windows ftp client, and can log in. But I can't get a directory listing ("Unauthorized") or change to directories that I thounk ought to be there ("/Diaries"). I haven't been able to find any clues using Google. Am I missing some important Zope or system config? Any clues would help. Thanks! ---------------------------------------------------------------------- "Experience is that marvelous thing that enables you to recognize a mistake when you make it again." - F. P. Jones

2 1

CatalogPathAwareness and manage_beforeDelete
by Bakhtiar A Hamid 18 Dec '02

18 Dec '02

hello all i have a product that subclass CatalogPathAwareness and SimpleItem all works ok. i,e an object instance will be added and deleted from the catalog however, if i override manage_beforeDelete, the catalog is not cleared when i delete the object instance is that natural? do i have to supply my own uncatalog_object ? with this snippet, it still doesnt work. i guess i don't get what uid for uncatalog_object is ... here's the snippet def manage_beforeDelete(self, item, container): """method for delete /cut/paste/rename""" img_dir = getattr(self.aq_parent, 'images') img_dir.manage_delObjects([item.getId()+'_image']) self.uncatalog_object(item.absolute_url(1)) thanks -- http://www.kedai.com.my/ http://www.kedai.com.my/eZine http://www.zope.org/Members/kedai http://www.my-zope.org Am I Evil?

3 2

which one is better running zope with it own python or with the OS python
by Hamzat Kamal 18 Dec '02

18 Dec '02

Dear All, I have a Linus Redhat OS with zope server running on it. Firstly, how do I know if zope is using it own python or is using the python that come with the OS. Secondly, which one will give me optimum performance? that is running zope with it own python or with the OS python. And lastly, how do i configure zope to either use it own python or OS python. Thanks and God bless U all. ===== Hamzat kamaldeen Ishola Dnet Systems Limited. 223 Ikorodu Road, Lagos. Nigeria. 234 1 7749381, 234 08033011305 --- If Mistake is an opportunity to see better,�then do not fear it, but ready to admit it. NOTE: Sentimental decisions are not mistakes but failures !!!� __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com

3 2

Transparent Folder problem on windows
by Shashank Ashtikar 18 Dec '02

18 Dec '02

Hi guys, thnx for ur quick response to my question yesterday. I hv another problem but this time regarding transparent folders. I am using a single transparent folder in the product which contains some dtml and python scripts which I am using frequently in my products Interface. On a linux m/c product works fine but on a windows m/c product runs in to problem with the transparent folder. What I am doing is as follows. I have an instance of product say 'SomeInstance' inside this I have a transparent folder as 'Programs' which is containing dtml and python script files which I need. If I type the path as follows "http://localhost:8080/SomeInstance/scriptname" this works on linux perfectly fine( I use mozilla as well as galeon for managing zope server ) but when I type the same path on a windows m/c using IE 6.0, IE throws an error saying "can not locate "http://localhost:8080/SomeInstance/scriptname" if I modify the path as follows then it works. "http://localhost:8080/SomeInstance/Programs/scriptname" can some one tell me why this is hapening and is there a solution to solve this problem. thnx in advnc Shashank A newbie to zope

2 1