January 2001 - Zope - Zope lists

Design Q: Product vs. External Methods
by tilo.schwarz＠daimlerchrysler.com 15 Jan '01

15 Jan '01

Hi Zope-Experts, one question concerning design using zope: Assume, I have a bunch of python modules / scripts, which I want to make accessible via zope. Is it better to use the external methods to bring the python modules into zope or should I make a Product out of my python modules. I also would like to know, if it is possible to update a bunch of external method zope objects simultaneously, or do I have to click 'edit' on every single external method object after editing the corresponding python method? This would be a bit tedious with 30 or more external methods... Thanks a lot for any hints! Tilo

4 5

Re: MySQLDA and MySQL-python - patch needed?
by paul_s_johnson＠urscorp.com 15 Jan '01

15 Jan '01

Brian, I finally got it working. Here's what I did: I uninstalled all of ZMySQLDA and MySQL-python (formerly MySQLdb - this name change didn't help any although in the big picture it probably needed to be done) deleting any trace of it. I then followed all the directions starting from here: http://www.zope.org/Members/adustman/MySQLdb - This is the MySQL-python module. I used the version of ZMySQLDA that Andy Dustman points to here (there's more than one floating about and I may have latched onto a MySQL-python-incompatible one at some point): http://www.zope.org/Members/adustman/ZMySQLDA - installing this is just of matter of untarring in the correct Zope directory. To install MySQL-python I followed the directions that Andy lays out in his README.txt. It required that I had to install the rpms mysql-devel and python-devel which I tracked down at http://rpmfind.net for my flavor of Linux (RedHat) and MySQL (3.22.32). Once these were installed I was able to build it exactly as Andy stipulates. Being a Linux/Zope newbie this seemed daunting but it was more painless that I originally anticipated. With these installed I was then getting the error "_mysql module not found" (or something like that). The python of Zope was not finding the modules I just built from my main system python. I changed my Zope start-up script appending the PYTHONPATH variable to include the path where the module installed to. I added these lines: PYTHONPATH=$PYTHONPATH:/usr/lib/python1.5/site-packages export PYTHONPATH BINGO everything then worked. Hope that helps. My hunch is that there is some version incompatibilities going on between MySQL-python and ZMySQLDA that prevent MySQL query results from returning to Zope. BTW, thanks to everyone that responded to my emails for help. Even though none of them was the exact answer I needed they all supplied some missing critical piece of the puzzle. Opensource is a cool thing, but none of it would amount to much without lists like this to help folks out. Keep it coming. -PSJ >Hello All, > >I have the exact same problem. I am running slack 7.1 and I have >installed all of the goodies (i.e. zope, python, mysql, etc.) from >the source code. After finally figuring out that my /etc/ld.so.conf >was not seeing the mysqlclient libraries i was able to compile >MySQLdb-python modules and ZMySQLDA says that it is installed >properly. But I have the same issues with the SELECT queries >returning no data (There was no data matching this test_sql query. ) >That is straight from Zope. When I INSERT data to my columns in the >table it works fine though. I have verified this from the console. >Please advise if there are any suggestions. Thanks. > >Brian L Gautreau

1 0

OpenBSD 2.8 woes
by Jan Muenther 15 Jan '01

15 Jan '01

Hello folks, first of all, I've installed Zope on my FreeBSD workstation (from the ports) and I love it. I can't really do anything productive yet ;o)), but the potential and power of the program's clear to me. Now, after talking to my boss, I plan to set up the relaunch of our website to be based on Zope. As OS I'd like to pick OpenBSD, since it's nice, fast and secure and I generally have an affection towards xBSDs.... However, after installing the Python packages that comes shipped with the OpenBSD 2.8 CDs, the Zope installation script runs nicely, but when I try and access the management screen, I only see LOADS of error messages: Zope Error Zope has encountered an error while publishing this resource. Error Type: ParserError Error Value: Expected node type 12, got 312. Could anybody enlighten me??? I don't know Python (yet), so the tracebacks are not too informative for me ... Cheers, Jan -- Radio HUNDERT,6 Medien GmbH Berlin - EDV - j.muenther(a)radio.hundert6.de

4 5

RE: ZMySQLDA and aggregate functions on Win
by Markus Kemmerling 15 Jan '01

15 Jan '01

Thank you Dave for your answer. But what do you mean by you don't expect a SELECT returning a number to work? The error you got clearly is a mysql syntax error: If I have a table 'shop' and make a SELECT on 'show' I really wouldn't expect that to work ;-) But I don't get any mysql error, I get a python error. Let me repeat my problem and try to be a little bit more precise (I use your example): SELECT COUNT(*) FROM show GROUP BY article; works from the mysql command line, works from within Zope on linux, but breaks from within zope on windows. SELECT COUNT(*) FROM show; works from within Zope on windows, too. So the problem is to have a SELECT with COUNT() and GROUP BY-clause from within Zope on Windows. Since it works on the mysql command line, it is definitely not an SQL error. I use Zope 2.2.4, mysql 3.23gamma, ZMySQLDA 1.1.3 and the libmySQL.dll linked from the HowTo explaining the installation of ZMySQLDA on Win32. The error I get is of type 'KeyError' with value 'unhandeld' and occurs on line 191 of ZMySQLDA's db.py. This and the next lines read as follows: for d in desc: item={'name': d[0], 'type': defs[d[2]], 'width': d[3], } func(item) where 'desc' is the fieldlist of the result set returnded by the query and 'defs' is some kind of type-mapping defined at the top of db.py, that I don't really understand: defs={ "short": "i", "long": "i", "char": "s", "double": "n", "decimal": "n", "float": "n", "tiny blob": "t", "medium blob": "t", "long blob": "t", "blob": "t", "date": "d", "time": "s", "datetime": "d", "timestamp": "d", "varchar": "t", "string": "t", } The following little ugly hack makes my query work: for d in desc: try: item={'name': d[0], 'type': defs[d[2]], 'width': d[3], } func(item) except KeyError: item={'name': d[0], 'type': 'i', 'width': d[3], } func(item) So it seems to me that COUNT returns some field-type unknown to 'defs'. (What still confuses me is, that this only happens in combination with a GROUP BY-clause.) I wonder what's the value of d[2] for the COUNT()-column, but since I am quite new to python and Zope I still don't know how to debug. I also wonder if anybody running Zope with mysql on windows can reproduce this error. Or maybe someone with a good knowledge of ZMySQLDA and the python mysql-module has some hint? Sorry that this message got so long ... Markus Kemmerling > This is curious to me - I tried this on my Linux platform from > mysql and it > doesn't work. > Perhaps I misunderstand what you are trying to do: > > SELECT COUNT(*) FROM mytable - returns a number - so I really don't expect > it to work. > > I have a table - shop and a column in that table - article: > > mysql> select count(*) from show group by article; > ERROR 1064: You have an error in your SQL syntax near 'show group by > article' at line 1 > > Sorry if I misunderstand what you are trying to do - > > ================================= > Dave Woolston davew(a)digicool.com > Digital Creations www.digicool.com > (716) 262-4715 > > > > I have a problem with ZMySQLDA and aggregate functions in > combination with > > grouping on Windows. > > When I say: > > SELECT COUNT(*) FROM mytable GROUP BY myfield; > > I get an KeyError 'Unhandeld'. > > > > SELECT COUNT(*) FROM mytable; > > works fine, so does > > SELECT myfield FROM mytable GROUP BY myfield; > > but not the combination of both. > > Also on a linux machine the error doesn't occur. Of course I tested the > > queries from the mysql command line. > > > > Any help? > > > > Markus Kemmerling > >

1 0

How do I authenticate through pcgi and win2000 ????
by Max Møller Rasmussen 15 Jan '01

15 Jan '01

I have installed zope on port 8080 on a win 2K machine. It runs nicely, but due to firewalls and other reasons it has to run on port 80. So I have added zope.pcgi etc. to the IIS. And it runs nicely. But when I try to use a manage page I cannot log in without being a member of the win2K domain, and that is not feasible in this case. I have tried all setting, I think. Is there any way to do it? Should I make my own authentication page so users can log on through a form? If so how is this done? Regards Max M

1 0

Re: [Zope] hasRole bug or feature in 2.2.?
by Dieter Maurer 15 Jan '01

15 Jan '01

Chris McDonough writes: > You didn't protect the isMember document. It's viewable by Anonymous. The > Zope security machinery short-circuits authentication for resources that > don't require it. This means that when you view a resource that's > unprotected, you view it "as Anonymous". Anonymous doesn't have the Member > role, so you see "You are NOT a Member" when you view /isMember. > > I don't particularly like this behavior, but it seems not to bother anyone > else. I think it should authorize you and set AUTHENTICATED_USER if you > pass in auth info regardless of the protection on the resource you're trying > to view. It would bother me a lot, if you were right :-) Fortunately, you are not completely right. What really happens is the following: when ZPublisher has located the object addressed by the request URL, it starts going back its way along PARENTS to find a UserFolder that can authenticate a user with sufficient permissions to call the object. If the object is unprotected, then no permissions are required. In this case, the top level UserFolder will return "Anonymous", if it is reached and it cannot authenticate the user. Therefore, an unprotected object can be called by Anonymous and in this case, "hasRole" is that of "Anonymous", as Chris reported. However, if previously a protected object has been accessed, then your browser may (and usually will) send Authentication information with all following requests. A UserFolder will use this information (if present) to authenticate the user, even if no permissions are necessary for object access. If successful, AUTHENTICATED_USER will not be "Anonymous" even though the accessed object is unprotected. Dieter

4 4

Calling other frames
by Etienne Labuschagne 15 Jan '01

15 Jan '01

Hi there I have a navigation/sitemap object that shows the user where he is in the website at the current moment. I want this object eg. to sit in the left frame. This object must update every time the main (right) frame updates to reflect the position of the right frame. The website can be navigated both from this navigation/sitemap object or from links inside the website itself. Thus, the object must also update itself even if it is not used as the means to navigate the site. How do I "talk" to objects in other frames? Or is there a better way to do this? I know that this can probably be done with Javascript, but would prefer to use Zope as far as I can. Thanks! Etienne Tel: (012) 348 4586 Cel: 082 442 8981 Fax: (012) 361 8355

1 0

Apache ProxyPass directive and REMOTE_ ENV
by Denis 15 Jan '01

15 Jan '01

Hi, I'm confronted to the same problem as the one as discussed at that address : http://www.egroups.com/message/zope/43874?threaded=1 I'm trying to get back the REMOTE_ADDR variable because it's changed to the Server's address by a ProxyPass directive. I'm trying to use SetEnv or SetEnvIf directives to do that. But I can't manage to expand %{REMOTE_ADDR} to an IP address. I mean, if I use : SetEnv client_ip_1 %h SetEnv client_ip_2 %{Remote_Addr} SetEnv client_ip_3 %{ENV:Remote_Addr} I get : client_ip_1 = %h and not : client_ip_1 = 212.68.75.6 and the same for all my tries. Is there a way to expand those values ? A magic key to turn ? Have you found a better solution than the one exposed by HTH in the message above ? Thank you. -- Denis FRERE P3B : Club Free-Pytho-Linuxien Caroloregien http://www.p3b.org

1 0

Searching method due to situation
by Angietel 15 Jan '01

15 Jan '01

The following is my DTML code, purposely to valid the entry field and return the right sql Searching method according to the situation:- <dtml-if "_['<dtml-var custname>']!=""" AND "_['<dtml-var custid>']=="""> <dtml-in sqlSearchcust3> #// if the custid is blank and custname is not blank then will use sqlSearch3 <dtml-elif "_['<dtml-var custid>']!=""" AND "_['<dtml-var custname>']=="""> <dtml-in sqlSearchcust2> #// if the custid is not blank and custname is blank then will use sqlSearch2 <dtml-elif "_['<dtml-var custid>']==""" AND "_['<dtml-var custname>']=="""> <dtml-in sqlSearchcust> #// if the custname is not blank and custid is not blank then will use sqlSearch <dtml-else> <dtml-var expr="REQUEST['/Customer/View/searchallcust']"> #// if the custname is blank and custid is blank then will go to view a list of customer record. </dtml-if> The following is the ZOPE error:- Unexpected tag, for tag <dtml-elif "_['<dtml-var custid>']==""" AND "_['<dtml-var custname>']!=""">, on line 9 of a For my sql method syntax are as follow:- 1.sqlSearchcust3 select * from customer <dtml-sqlgroup where> <dtml-sqltest custid op=ne type=string> <dtml-and> <dtml-sqltest custname op=like'%%' type=string> </dtml-sqlgroup> 2. sqlSearchcust2 select * from customer <dtml-sqlgroup where> <dtml-sqltest custid op=eq type=string> <dtml-and> <dtml-sqltest custname op=ne type=string> </dtml-sqlgroup> 3. sqlSearchcust select * from customer <dtml-sqlgroup where> <dtml-sqltest custid op=eq type=string> <dtml-and> <dtml-sqltest custname op=like'%%' type=string> </dtml-sqlgroup> This is urgent! Please give me some solution, Thanks!

1 0

More than one condition in<dtml-if>
by Angietel 15 Jan '01

15 Jan '01

The following is my DTML code, purposely to valid the entry field and return the right sql method according to the situation:- <dtml-if "_['<dtml-var custname>']!=""" AND "_['<dtml-var custid>']=="""> <dtml-in sqlSearchcust3> #// if the custid is blank and custname is not blank then will use sqlSearch3 <dtml-elif "_['<dtml-var custid>']!=""" AND "_['<dtml-var custname>']=="""> <dtml-in sqlSearchcust2> #// if the custid is not blank and custname is blank then will use sqlSearch2 <dtml-elif "_['<dtml-var custid>']==""" AND "_['<dtml-var custname>']=="""> <dtml-in sqlSearchcust> #// if the custname is not blank and custid is not blank then will use sqlSearch <dtml-else> <dtml-var expr="REQUEST['/Customer/View/searchallcust']"> #// if the custname is blank and custid is blank then will go to view a list of customer record. </dtml-if> The following is the ZOPE error:- Unexpected tag, for tag <dtml-elif "_['<dtml-var custid>']==""" AND "_['<dtml-var custname>']!=""">, on line 9 of a For my sql method syntax are as follow:- 1.sqlSearchcust3 select * from customer <dtml-sqlgroup where> <dtml-sqltest custid op=ne type=string> <dtml-and> <dtml-sqltest custname op=like'%%' type=string> </dtml-sqlgroup> 2. sqlSearchcust2 select * from customer <dtml-sqlgroup where> <dtml-sqltest custid op=eq type=string> <dtml-and> <dtml-sqltest custname op=ne type=string> </dtml-sqlgroup> 3. sqlSearchcust select * from customer <dtml-sqlgroup where> <dtml-sqltest custid op=eq type=string> <dtml-and> <dtml-sqltest custname op=like'%%' type=string> </dtml-sqlgroup> This is urgent! Please give me some solution, Thanks!

1 0