- Zope - Zope lists

MySQL & lost server connections
by John Eikenberry 01 Jun '99

01 Jun '99

I seem to remember this being asked before, but I couldn't find anything in the archives... :P Basically, it looks like I'm losing my connection from Zope to the MySQL database. While the site remains busy, it stays connected, but if there's a long dead period the connection goes away. Both Zope and MySQL are running on the same BSDI 3.1 machine. Its Zope-1.10.2 and MySQL-3.21.33b. Is there anything I can do to fix this? Here's the traceback and error: ------------------------------------------------------------------ Error type: Error value: Lost connection to MySQL server during query Traceback (innermost last): File /usr/local/lib/Zope-1.10.2/lib/python/ZPublisher/Publish.py, line 877, in publish_module File /usr/local/lib/Zope-1.10.2/lib/python/ZPublisher/Publish.py, line 590, in publish (Info: /members/index2) File /usr/local/lib/Zope-1.10.2/lib/python/OFS/DTMLMethod.py, line 155, in __call__ (Object: index2) File /usr/local/lib/Zope-1.10.2/lib/python/OFS/DTMLMethod.py, line 151, in __call__ (Object: index2) File /usr/local/lib/Zope-1.10.2/lib/python/DocumentTemplate/DT_String.py, line 513, in __call__ (Object: index2) File /usr/local/lib/Zope-1.10.2/lib/python/DocumentTemplate/DT_With.py, line 138, in render (Object: db) File /usr/local/lib/Zope-1.10.2/lib/python/DocumentTemplate/DT_In.py, line 617, in renderwob (Object: userid) File /usr/local/lib/Zope-1.10.2/lib/python/Shared/DC/ZRDB/DA.py, line 390, in __call__ (Object: CopySource) File /usr/local/lib/Zope-1.10.2/lib/python/Products/ZMySQLDA/db.py, line 171, in query error: (see above) --- John Eikenberry [jae(a)kavi.com - http://taos.kavi.com/~jae/] ______________________________________________________________ "A society that will trade a little liberty for a little order will deserve neither and lose both." --B. Franklin

3 2

RE: [Zope] Zope as a mail list server
by Jay, Dylan 01 Jun '99

01 Jun '99

> -----Original Message----- > From: Paul Everitt [mailto:Paul@digicool.com] > Sent: Wednesday, June 02, 1999 00:30 > To: 'Jay, Dylan'; 'zope(a)zope.org' > Subject: RE: [Zope] Zope as a mail list server > > > > Dylan wrote: > > Comments in the press release for "Zope portal" (whatever > > that is) seems to > > indicate that mailing list type functionality might be > > available from inside > > zope. Or at least the web archive part of a mail list. Is this true? > > The portal toolkit will leverage the IMAP adapter to allow integration > of email content into the portal. A "Z Mailman", while on > the radar for > this year, isn't on the radar for the first portal release. > > > My current situation is as follows. I have a zope website > > using an odbc > > database for a user base of around 500 or so users. I want to > > support both > > discussion lists and annoucement style lists for my users. I > > want to be able > > to view, search and submit mails from inside my zope website. > > Viewing and searching are awfully easy with the IMAP adapter. You can > do your searches on the IMAP server. > > If, on the other hand, you'd like to integrate the email messages into > Zope as Zope database entries and Zope Catalog entries, that > would take > some noodling. Not much, but a bit. > > > I want users > > to manage their subscription from both the website and from > > traditional > > listserv like mail commands. I want to be able to store the > > user lists in > > flexible way in my user database. I preferably want some > > flexibility on how > > I store the archived messages. > > Ahh, yes, you're definately talking something like Mailman. > > > Its seems to me that all the list servers I'm looking at > > suffer from two > > problems. One is lack of flexibility on the backend data > > storage. Another is > > their intergration with existing web pages. Zope seems > > ideally placed to > > bridge this gap. Is this planned? If so perhaps rather than > > hack togeather > > some connection between an existing list server I should wait > > for the zope > > version. > > Since we have Ken Manheimer, one of the key people from Mailman, here > now we've talked a lot about the overlap between Mailman and > Zope. Ken > has done some experiments with putting a Zope front end on Mailman. > > You could probably reduce the code in Mailman tenfold and increase its > breadth ten fold by just doing a straight port. OTOH, you could > reinvent Mailman based on the Zope model of turning over control. Its seems to me there are two ways to merge. One is to put in a an abstract framework in place inside zope for managing long running servers and thus make mailman a service of zope. The ability to have objects run for longer than just the web request is something that is missing in zope (and has been explained to me by others as being reasonably essential for a weblication). Long running processes can accept input from a variaty of sources and intergrate it into the repository or stream it off to other processes such as applets in web pages. The other way is the one I dreamed up last night. You could seperate out the membership storage code and the archive code in mailman. Then you could override the these routines to interface instead to a private zope pages. That way zope could be used to manage the data in the variaty of backends it supports. I'm going to check the mailman code now to see how hard this is to do. If its easy then I'll do it now as I'm running out of nice solutions. My only other solution it seems is to buy listserv as that intergrates with odbc. > Anyway, the imminent version of the portal toolkit will be > more like an > archive manager.

1 0

RE: [Zope] Zope on Mac OS X Server
by Jeffrey Shell 01 Jun '99

01 Jun '99

This is basically what I did to get it working. I think the libraries being in a weird place stem from the --with-next-framework option which I assume expects to be put into an Openstep framework setup and set's Pythons paths to be:: .../lib/ instead of the usual:: .../lib/python1.5/ (the source says it's because NeXT's Frameworks do automatic versioning). This gets compiled _right into Python!_, but none of the makefiles and friends seem to catch it. My blue box STILL refuses to work (waaa!), so I spend a lot of time in either MacOS 8.6 or MacOS X Server (mostly in 8.6 due to (a) a better browser, and (b) more familier tools (yay Alpha!):)). Thus, I don't have access to that particular bit of patched Python source right now. It made things significantly easier, but was kindof a hack. I'd be very interested in getting more information about the NeXT Frameworks and maybe configuring the default Python makefiles to have a "make framework" option that basically acts like "make install", but takes into account any existing Python framework (like Objective Everything's for example) and follows the right versioning behaviour and other NeXT framework setups. That LDLIBRARY option not being included in Makefile.pre.in is rather a pain. -----Original Message----- From: Jim Washington [mailto:jwashin@mail.vt.edu] Sent: Monday, May 31, 1999 8:39 AM To: Greg Pierce; zope(a)zope.org Subject: Re: [Zope] Zope on Mac OS X Server Hi, Greg Yup. There was a note on the Python site from Jeffrey Shell with his solution. http://www.python.org/pipermail/pythonmac-sig/1999-May/001106.html I did something similar. Essentially: for Python: ./configure --with-next-framework --with-threads --with-dyld --prefix=[whatever] then put libpython1.5.dylib into /usr/lib No matter what you use for --prefix, this will put python and its development libraries in a really weird configuration that zope will not understand properly, so I symlinked the heck out of what I had to make it look like it was in "standard" locations. I suppose you could really move them around, too. adding LDLIBRARY=/usr/lib/libpython($VERSION).dylib into python's Makefile.pre.in in /lib/python1.5/config fixes the problems with finding the dylib change "sys.executable" to "[whatever]/bin/python" in wo_pcgi.py and do.py in your zope root. and I may have forgotten a thing or two, but it should compile and run. If you take better notes and get it working, you might post those to the list. I have a feeling OS X is going to be yet another popular platform for Zope. Now I need to try to get Mailman working... Good luck. --Jim Washington > i was wondering if anyone's gotten Zope running on Mac OS X server > (theoretically, BSD 4.4 compliant). i already had built Python 1.5.2 > and have been using it w/o incident. i downloaded the Zope 1.10.2 > sources, and tried a build--which got pretty far along, but then > failed on a number of counts and never created the config and > launching files (the best i could tell). > _______________________________________________ Zope maillist - Zope(a)zope.org http://www.zope.org/mailman/listinfo/zope (For developer-specific issues, use the companion list, zope-dev(a)zope.org - http://www.zope.org/mailman/listinfo/zope-dev )

1 0

Object creation time
by Jay, Dylan 01 Jun '99

01 Jun '99

I'm trying to get the date an object was created (rather than its modification time). What method is this?

2 1

RE: [Zope] Zope as a mail list server
by Paul Everitt 01 Jun '99

01 Jun '99

Dylan wrote: > Comments in the press release for "Zope portal" (whatever > that is) seems to > indicate that mailing list type functionality might be > available from inside > zope. Or at least the web archive part of a mail list. Is this true? The portal toolkit will leverage the IMAP adapter to allow integration of email content into the portal. A "Z Mailman", while on the radar for this year, isn't on the radar for the first portal release. > My current situation is as follows. I have a zope website > using an odbc > database for a user base of around 500 or so users. I want to > support both > discussion lists and annoucement style lists for my users. I > want to be able > to view, search and submit mails from inside my zope website. Viewing and searching are awfully easy with the IMAP adapter. You can do your searches on the IMAP server. If, on the other hand, you'd like to integrate the email messages into Zope as Zope database entries and Zope Catalog entries, that would take some noodling. Not much, but a bit. > I want users > to manage their subscription from both the website and from > traditional > listserv like mail commands. I want to be able to store the > user lists in > flexible way in my user database. I preferably want some > flexibility on how > I store the archived messages. Ahh, yes, you're definately talking something like Mailman. > Its seems to me that all the list servers I'm looking at > suffer from two > problems. One is lack of flexibility on the backend data > storage. Another is > their intergration with existing web pages. Zope seems > ideally placed to > bridge this gap. Is this planned? If so perhaps rather than > hack togeather > some connection between an existing list server I should wait > for the zope > version. Since we have Ken Manheimer, one of the key people from Mailman, here now we've talked a lot about the overlap between Mailman and Zope. Ken has done some experiments with putting a Zope front end on Mailman. You could probably reduce the code in Mailman tenfold and increase its breadth ten fold by just doing a straight port. OTOH, you could reinvent Mailman based on the Zope model of turning over control. Anyway, the imminent version of the portal toolkit will be more like an archive manager. --Paul

1 0

Automatically restarting ZPyGreSQLDA connection
by Hannu Krosing 01 Jun '99

01 Jun '99

Hi, Is there any way to catch the error from a Zope Database Adapter and restart it ? I'm experiencing what I suspect are timeout problems (sometimes a bunch of imapd's drive the load to >10 and make the computer really slow). The symptom is that at some point I get a traceback from _pgmodule instead of nice page. The only way to fix it after that is going to manage screens and shutdown/startup the connection I would like to catch this exception and do the shutdown/startup automatically (and perhaps log that it happened) Or would the only reasonable place to do such things be inside the DA ? The latter should not be too hard, just try: to send an empty query before the real one (con.query("")) and in except: open a new one (and log the error if desired) The overhead should be almost nothing, at least when using domain sockets. --------------- Hannu

2 1

Re: [Zope] problems sorting with in-tag
by Martijn Pieters 01 Jun '99

01 Jun '99

At 14:54 31/05/99 , Sebastian Luehnsdorf wrote: >hi! > >i got a problem trying to sort the results from an in tag. i have three >different conditions, and want to unite these into one solution. something >like > >  > >where 'sortby' designates the variable to be sorted by. now i would like >to access the document with the in tag like this: > > abc.dtml?sortby=thisval > >this doesn't work. what am i doing wrong? > >ciao, basti The sort attribute cannot be dynamically assigned.. What happens is this: DTML is pre-parsed, and all the DTML tags are replaced by object instances representing those tags. The attributes are stored as instance variables. This means that 'sortby' is evaluated only once, when you save the DTML code. Right now there is no real solution to your problem, other then creating different #in tags and selecting one with an if - elseif - else structure. -- Martijn Pieters, Web Developer | Antraciet http://www.antraciet.nl | Tel: +31-35-6254545 Fax: +31-35-6254555 | mailto:mj@antraciet.nl http://www.antraciet.nl/~mj | PGP: http://wwwkeys.nl.pgp.net:11371/pks/lookup?op=get&search=0xA8A32149 ------------------------------------------

3 2

How to reference PARENTS' Document
by T. C. Huang 01 Jun '99

01 Jun '99

Hi, If B is a folder of folder A, how can I reference a Document,eg, index_html of folder A in a DTML Document of folder B? I can reference a property of folder A by , but I can't figure out the above I asked. Any idea? T.C. Huang

2 1

2nd beehive zope barbecue - berlin, germany
by webman 01 Jun '99

01 Jun '99

hello all, this posting is really only relevant for companies working with zope in germany so the rest of the text is in german. *** beehive Zope barbecue, die zweite *** am 18. Juni findet das zweite Zope barbecue bei beehive in berlin statt. ziel ist es die barbecues in einem monatlichen rhythmus abzuhalten um so ein meeting place fuer zope user (und natuerlich die, die es werden wollen) zu werden. anfang: 13:00 addresse: beehive GmbH, fischerhuettenstr. 79b u-bahn: krumme lanke (u1) wir bitten darum, dass jede firma/person uns bis spaetestens naechsten montag darueber informiert, ob mit einer erscheinung zum barbecue zu rechnen ist. nur so koennen wir von beehive dafuer sorgen das es ausreichend zu essen und trinken gibt. falls ihr vegetarier mitbringt informiert uns bitte ueber die stueckzahl, da wir hier bei beehive alle vegetarier aus unserer firma rausgemobbt haben ;-) wir erwarten von allen firmen einen beitrag in form von getraenken, essen, oder geld (firmen 15DM, einzel personen 5 DM) inhaltlich wollen wir uns dem zu diesem zeitpunkt laut digital creations erhaeltlichen open source zope portal toolkit und auch neue fuer zope entwickelten releases widmen. feedback bitte an webman(a)beehive.de -------------------------------------------------------------------------- webman | _ beehive GmbH | ASCII ribbon campaign ( ) berlin, Germany | - against HTML email X http://www.beehive.de | & vcards / \

1 0

sysv init script for Zope 2
by Alex Rice 01 Jun '99

01 Jun '99

Here is an init script for Zope2/ZServer. Folks might find it useful just as a wrapper around z2.py. That's how I'm using it. On Redhat Linux, the init scripts are kind of covoluted-- I'm still not sure how it handles killing daemons. If you are comfortable with Redhat's init scripts, try putting a symlink to this script in /etc/rc.d/rc5.d/. #!/bin/sh # # Init script for the Zope2 application server (using ZServer) # # Alex Rice <alex(a)mindlube.com> # notes: # o don't put this in /etc/rc.d/rcX.d/ unless you know what you are doing # o format copied from other Redhat 6 init scripts # o make sure your network interface is up before you start zope! # adjust these as appropriate ZOPE_BASE=/usr/share/zope PYTHON=/usr/local/bin/python # there better way to get DNS server (like from /etc/resolv.conf) anyways... # put your DNS server here: NS=127.0.0.1 # See how we were called. case "$1" in start) echo -n "Starting Zope: " $PYTHON $ZOPE_BASE/z2.py -d $NS & echo ;; stop) echo -n "Shutting down zope: " $PYTHON $ZOPE_BASE/lib/python/ZPublisher/Client.py \ -u ` cat $ZOPE_BASE/access ` \ http://localhost:9673/Control_Panel/manage_shutdown \ > /dev/null 2>&1 echo ;; status) echo "Status of Zope: " echo "<this feature not yet implemented>" ;; restart) echo -n "Restarting zope: " $PYTHON $ZOPE_BASE/lib/python/ZPublisher/Client.py \ -u ` cat $ZOPE_BASE/access ` \ http://localhost:9673/Control_Panel/manage_restart echo ;; reload) echo -n "Reloading zope: " $PYTHON $ZOPE_BASE/lib/python/ZPublisher/Client.py \ -u ` cat $ZOPE_BASE/access ` \ http://localhost:9673/Control_Panel/manage_restart echo ;; *) echo "Usage: $0 {start|stop|restart|reload|status}" exit 1 esac exit 0

2 1