March 2000 - Zope - Zope lists

Re: [Zope] WorldPilot Calendar fixes and (UW) IMAP Options available
by rossini＠biostat.washington.edu 13 Mar '00

13 Mar '00

>>>>> "RH" == Ryan Hughes <rh(a)n-h.net> writes: RH> I took a look at the imap code. it basically complains that RH> the SELECTed folder is not read writable. As far as I can RH> remember the problem may be that UW IMAP locks your folders RH> when they get selected. Possibly you're accessing that folder RH> with a different client concurrently? Yes! But I think that the concurrency might be happening from Zope/WorldPilot? I.e. that it is submitting another command prior to the first results? I ran (the patched) imaplib.py by itself (it has a "sample session") which gave "reasonable" results... RH> Let me know if that's the problem, since I have heard about RH> this problem a few times, and I thought it was a locking issue RH> on UW IMAP. Or, it might be an instance of the way recent UW imap daemons deal with the maildir issue, copying files to the local user account from the mail spool... (see documentation, which I'm not yet sure that I understand; but then again, I'm a research biostatistician, not a sysadmin/www-master...). I replicated it using UW imap locally on the linux (debian) box. Maybe I'll try firing up Cyrus -- does anyone know if it "drops in" in the same way that UW Imap does? (i.e. install and go...). Debian's got it, so maybe I can do that... best, -tony -- A.J. Rossini Research Assistant Professor of Biostatistics Biostatistics/Univ. of Washington (Th) Box 357232 206-543-1044 (3286=fax) Center for AIDS Research/HMC/UW (M/F) Box 359931 206-731-3647 (3693=fax) VTN/SCHARP/FHCRC (Tu/W) Box 358080 206-667-7025 (4812=fax) rossini(a)(biostat.washington.edu|u.washington.edu|hivnet.fhcrc.org) http://www.biostat.washington.edu/~rossini

4 5

date comparison
by Kyle Burnett 13 Mar '00

13 Mar '00

anyone know a quick way to compare two date strings without having to complete tear the string apart? thanks, kyle

3 3

Python or C Library error?
by Eric L. Walstad 13 Mar '00

13 Mar '00

Well, I thought I had it working... I am trying to get MySQL to work with Zope. I installed ZMySQLDA and was able to make a connection to a database. I was even able to make an SQL method that added records to the table. However, when I added a method to lookup a record in the table, I get the following error when I "Add and Test" it from Zope: Error, exceptions.ImportError: /usr/lib/python1.5/site-packages/_mysqlmodule.so: undefined symbol: Py_InitModule3 This is the same error I got when I tried to install MySQLdb. That's why I tried to install MySQLDA instead. However, I can't tell if this error stems from C or from Python. I don't know much about Python (the book I ordered isn't here yet), but it looks like the error is starting there. If anyone has run into this error before, or has a clue as to how to fix it, please let me know. OR, if you have a working Zope/MySQL combo and wouldn't mind sending me a copy of your '_mysqlmodule.so' binary, maybe that would do it? Thanks, Eric.

2 1

Simple Count Method
by Joseph A. Archer 13 Mar '00

13 Mar '00

To all Zopist, (I am new to the list, and yes I am going through the archives for the answer, but haven't found it yet.) I have a simple two field table in MySQL, "whowhat", that pulls a user id from one table, and a class code from another. (It tells you "who" has "what" classes) I , being somewhat new to python & Zope, am having the darndest time trying to do a simple external method to do a count of how many times the class "so-and-so" is in the table. (That way, I know how many people have signed-up, and how close I am to the class max.) I have tried different searches. I have an SQL Method that does: select * from whowhat And I also have one that does: ... select * from whatwhat where classcode = <dtml-sqlvar class_name type=nb> I've been trying to create an External Method, but I just can't seem to get it to work. (yes, in the Extentions directory) I need to try to stay away from doing a "select count(classcode)..." in an SQL Method if I can. Any help to this tormented soul would be greatly appreciated. virtually, Joseph A. Archer IT Coordinator Facilities Management James Madison University archerja(a)jmu.edu

6 7

problem connecting to mysql
by Helmut Ahninger 13 Mar '00

13 Mar '00

hy i installed the mysqldb sucessfully (just exactly like the howto on http://www.zope.org/Members/alanpog/zmysqlda_steps explains) and checked all version numbers. i restarted zope and the Product ZMySQLDA is not broken then i want to make a database connection with the z_mysql_database_connection i type as connection string: database user password and get the following result: invalid connection string: Traceback (innermost last): File /usr/local/Zope-2.1.4-src/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /usr/local/Zope-2.1.4-src/lib/python/ZPublisher/Publish.py, line 179, in publish File /usr/local/Zope-2.1.4-src/lib/python/Zope/__init__.py, line 202, in zpublisher_exception_hook (Object: ElementWithAttributes) File /usr/local/Zope-2.1.4-src/lib/python/ZPublisher/Publish.py, line 165, in publish File /usr/local/Zope-2.1.4-src/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: addConnection) File /usr/local/Zope-2.1.4-src/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: addConnection) File /usr/local/Zope-2.1.4-src/lib/python/Products/ZMySQLDA/DA.py, line 123, in addConnection (Object: ElementWithAttributes) File /usr/local/Zope-2.1.4-src/lib/python/Shared/DC/ZRDB/Connection.py, line 129, in __init__ (Object: RoleManager) File /usr/local/Zope-2.1.4-src/lib/python/Shared/DC/ZRDB/Connection.py, line 158, in edit (Object: RoleManager) File /usr/local/Zope-2.1.4-src/lib/python/Shared/DC/ZRDB/Connection.py, line 227, in connect (Object: RoleManager) File /usr/local/Zope-2.1.4-src/lib/python/Products/ZMySQLDA/db.py, line 155, in __init__ BadRequest: (see above) what am i doing wrong ? please if u have had the same problem or know the answer send me an email thank u in advance Helmut Ahninger helmut(a)jouh.at

2 6

RE: [Zope] date format in other time-zone
by Alexander Staubo 13 Mar '00

13 Mar '00

Like so, for example: <dtml-var "MyDate.toZone('GMT')" fmt="ISO"> Date-time math is very simple with Zope's DateTime objects. DateTime supports fractional, C-type clock values -- 1.0 is one day, 0.5 is half a day, 1 / 24.0 ~= 0.0416 is one hour. So, <dtml-var "(ZopeTime() + 1).toZone('GMT+5')" fmt="ISO"> gives you the time tomorrow, adjusted to GMT+5. You can use named time zones such as "US/Eastern". -- Alexander Staubo http://alex.mop.no/ "`This must be Thursday,' said Arthur to himself, sinking low over his beer, `I never could get the hang of Thursdays.'" --Douglas Adams, _The Hitchhiker's Guide to the Galaxy_ > -----Original Message----- > From: Sin Hang Kin [mailto:iekentsin@infoez.com.mo] > Sent: Sunday, March 12, 2000 9:21 AM > To: Zope Admin list > Subject: [Zope] date format in other time-zone > > > Is it possible to format a date to GMT or in general in other > timezone other > zone? > > I have read through the Quick reference but do not have answer. The > ToZone(z) is listed there under DateTime. But How can I use that? > > Moreover, how can I make date-time calculate : adding 3 days > to current > time. Add 2 minutes to current time, etc. > > Rgs, > > Kent Sin > > > > _______________________________________________ > 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

Generic User Folder Gotcha
by Ben Leslie 12 Mar '00

12 Mar '00

Just thought I'd let people know about a small gotcha in the GUF. If you do not have a user folder in the root directory and then create a GUF in a subfolder using cookie-based permissions it will lock you out of that folder. GUF works fine in this situation if you use basic authentication just not with cookie based. The problem is that in cookie based authentication method it never checks whether you are the super user or not. It works fine if you have a user folder in the root becuase it then goes and checks it. I tried some code to get around it but didn't really have time to fix it esp when it is trivial bug/feature? to get around. Anyway just though this might save some people some time along the way. Oh and thanks to Zen GUF is a fantastic product ! Cheers, Benno

1 0

Re: [Zope] How do you Restrict ZServer socket connections
by Hung Jung Lu 12 Mar '00

12 Mar '00

<jo-(a)totient.demon.co.uk> wrote: >Fine, But Now I want to make Zserver only accept connections from >a set of known IP address (ie that where my apache server runs) If you are using Linux, this job is best done with the firewall itself (like ipchains.) Otherwise it is not very secure. That being said, inside Zope itself, you can put in your index_html (or equivalent) <dtml-if "REQUEST.REMOTE_ADDR != '127.0.0.1'"> <dtml-return "''"> </dtml-if> Of course, you can return a nasty message, or redirect the request to some other web addresses by using <dtml-var "RESPONSE.redirect(...)"> :) If you are using SiteAccess, you can put a hook at the root folder to bounce off anyone that you don't like. The REQUEST variable holds other environment variables that might be of your interest. You can either use <dtml-var REQUEST> to print out the variable content, or simply append /REQUEST to your URLs when you are browsing a Zope site: http://your.site.name/yourfolder/yourpage/REQUEST Hung Jung ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

1 0

How do you Restrict ZServer socket connections
by jon＠totient.demon.co.uk 12 Mar '00

12 Mar '00

Hi I've followed anser's How To on "Apache and ZServer (NOt CGI)" and now I have Zope served thru Apache via module ModProxy and the SiteAccess Zope Product. Fine, But Now I want to make Zserver only accept connections from a set of known IP address (ie that where my apache server runs) Any ideas how you do this? I can see there are options to say which ports it listens on but no mention of restricting the IP addresses it allows to connect. Thanks Jon

2 1

MySQLDA / MySQLdb problems
by Eric L. Walstad 12 Mar '00

12 Mar '00

Hello all, I have tried everything that I can think of (& a lot of what some of you could think of) to get MySQLdb to compile and install. I have had no luck. So, I am now trying to install MySQLDA (a step back) and am still having no luck. I'm hoping that the MySQLDA problem is related to the MySQLdb problem and that one of you will be able to point me in the right direction. Here's what happens when I try to install MySQLDA: First, the 'make -f Makefile.pre.in boot' script seems to work fine, but I'll include the output anyway, just in case. <OUTPUT OF make -f Makefile.pre.in boot> # make -f Makefile.pre.in boot rm -f *.o *~ rm -f *.a tags TAGS config.c Makefile.pre python sedscript rm -f *.so *.sl so_locations VERSION=`python -c "import sys; print sys.version[:3]"`; \ installdir=`python -c "import sys; print sys.prefix"`; \ exec_installdir=`python -c "import sys; print sys.exec_prefix"`; \ make -f ./Makefile.pre.in VPATH=. srcdir=. \ VERSION=$VERSION \ installdir=$installdir \ exec_installdir=$exec_installdir \ Makefile make[1]: Entering directory `/usr/local/Zope/lib/python/Products/ZMySQLDA/src' sed -n \ -e '1s/.*/1i\\/p' \ -e '2s%.*%# Generated automatically from Makefile.pre.in by sedscript.%p' \ -e '/^VERSION=/s/^VERSION=[ ]*$.*$/s%@VERSION[@]%\1%/p' \ -e '/^CC=/s/^CC=[ ]*$.*$/s%@CC[@]%\1%/p' \ -e '/^CCC=/s/^CCC=[ ]*$.*$/s%#@SET_CCC[@]%CCC=\1%/p' \ -e '/^LINKCC=/s/^LINKCC=[ ]*$.*$/s%@LINKCC[@]%\1%/p' \ -e '/^OPT=/s/^OPT=[ ]*$.*$/s%@OPT[@]%\1%/p' \ -e '/^LDFLAGS=/s/^LDFLAGS=[ ]*$.*$/s%@LDFLAGS[@]%\1%/p' \ -e '/^DEFS=/s/^DEFS=[ ]*$.*$/s%@DEFS[@]%\1%/p' \ -e '/^LIBS=/s/^LIBS=[ ]*$.*$/s%@LIBS[@]%\1%/p' \ in src]# ¡ -e '/^LIBC=/s/^LIBC=[ ]*$.*$/s%@LIBC[@]%\1%/p' \ -e '/^RANLIB=/s/^RANLIB=[ ]*$.*$/s%@RANLIB[@]%\1%/p' \ -e '/^MACHDEP=/s/^MACHDEP=[ ]*$.*$/s%@MACHDEP[@]%\1%/p' \ -e '/^SO=/s/^SO=[ ]*$.*$/s%@SO[@]%\1%/p' \ -e '/^LDSHARED=/s/^LDSHARED=[ ]*$.*$/s%@LDSHARED[@]%\1%/p' \ -e '/^CCSHARED=/s/^CCSHARED=[ ]*$.*$/s%@CCSHARED[@]%\1%/p' \ -e ORSHARED=/s/^LINKFORSHARED=[ ]*$.*$/s%@LINKFORSHARED[@]%\1%/p' \ -e '/^prefix=/s/^prefix=$.*$/s%^prefix=.*%prefix=\1%/p' \ -e '/^exec_prefix=/s/^exec_prefix=$.*$/s%^exec_prefix=.*%exec_prefix=\1%/p' \ /usr/lib/python1.5/config/Makefile >sedscript echo "/^#@SET_CCC@/d" >>sedscript echo "/^installdir=/s%=.*%= /usr%" >>sedscript echo "/^exec_installdir=/s%=.*%=/usr%" >>sedscript echo "/^srcdir=/s%=.*%= .%" >>sedscript echo "/^VPATH=/s%=.*%= .%" >>sedscript echo "/^LINKPATH=/s%=.*%= %" >>sedscript echo "/^BASELIB=/s%=.*%= %" >>sedscript echo "/^BASESETUP=/s%=.*%= %" >>sedscript sed -f sedscript ./Makefile.pre.in >Makefile.pre /usr/lib/python1.5/config/makesetup \ -m Makefile.pre -c /usr/lib/python1.5/config/config.c.in Setup -n /usr/lib/python1.5/config/Setup make -f Makefile do-it-again make[2]: Entering directory `/usr/local/Zope/lib/python/Products/ZMySQLDA/src' /usr/lib/python1.5/config/makesetup \ -m Makefile.pre -c /usr/lib/python1.5/config/config.c.in Setup -n /usr/lib/python1.5/config/Setup make[2]: Leaving directory `/usr/local/Zope/lib/python/Products/ZMySQLDA/src' make[1]: Leaving directory `/usr/local/Zope/lib/python/Products/ZMySQLDA/src' </OUTPUT OF make -f Makefile.pre.in boot> Next I ran 'make' <OUTPUT OF make> # make gcc -fpic -g -O2 -I/usr/include/python1.5 -I/usr/include/python1.5 -DHAVE_CO NFIG_H -I/usr/local/mysql/include -I/usr/include/mysql -c ./MySQLmodule.c ./MySQLmodule.c: In function `pythonify_row': ./MySQLmodule.c:238: warning: assignment from incompatible pointer type ./MySQLmodule.c: In function `pythonify_res_fields': ./MySQLmodule.c:384: invalid lvalue in unary `&' ./MySQLmodule.c: In function `STH_fetchdict': ./MySQLmodule.c:1125: invalid lvalue in unary `&' ./MySQLmodule.c:1147: invalid lvalue in unary `&' make: *** [MySQLmodule.o] Error 1 </OUTPUT OF make> Any help is greaty appreciated!! Eric.

4 4