- Zope - Zope lists

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

where port num gone
by Andy Heath 12 Mar '00

12 Mar '00

I have this root ltscimages someimage somefolder somedtlmdoc and I'm running both apache and zope. Some pages get served zope-->apache and some direct from zope. ZServer is running on 8080. Within somedtmldoc I want an image from ltscimages. This code <dtml-var "ltscimages.someimage"> produces a reference to the image but without the port number. In the ouput html I want http://host:8080/ltecimages/someimage but I get http://host/ltscimages/someimage I can work around this by serving the image via the zope-->apache method but that's crummy - I want only to use apache when I have to because of the efficiency effect. Putting the port in explicity is also crummy because its less transportable. How can I either 1. always get the port num in or 2. get the port in if its not the default 80. Elswhere in the same code absolute_url() does this correctly for code inside a tree. Would there be a way to use this here? Sorry for so many newbie q's. I promise I'll give back when I can. Andy -- ------------------------------------------------- Andy Heath a.k.heath(a)open.ac.uk The Open University +44 (0) 114 2885738

2 1

date format in other time-zone
by Sin Hang Kin 12 Mar '00

12 Mar '00

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

2 1

how to access newly created object with python
by Philipp Dunkel 12 Mar '00

12 Mar '00

Hi Zopistas f=getattr(self.Members,name) f.manage_addDTMLMethod('index_html', title='guestmode',file=default_member_content) now I want to set some permissions to index_html but f.index_html.manage_permission(blabla) doesn't work how can I access the newly created index_html method? TIA philipp dunkel ** ** ** ** ** ** ** ** pgp public key available gpg public key available ICQ# 60149094

1 0