August 2000 - Zope - Zope lists

Re: [Zope] ZMySQLDA on Win32 - connect then crash
by William BC Crandall 09 Aug '00

09 Aug '00

Phil Harris wrote: > What version of MySQL are you using and also what version of the Zope > Adapter? > MySQL Server version: 3.23.21-beta-debug Was using: ZMySQLDA-1.1.3-nonbin, as per your How-To. Just got: ZMySQLDA-1-1-4 (most recent stable). Same problems. Non-results SQL, 'use tmm', works, but 'show tables' crashes Python/Zope. I installed contents of ZMySQLDA-1-1-4 in: <zope-dir>/lib/python/Products/ZMySQLDA Thanks again, William BC Crandall Wiesbaden, Germany wcra(a)beest.midat.de > > ----- Original Message ----- > From: "William BC Crandall" <wcra(a)beest.midat.de> > To: <phil.harris(a)zope.co.uk> > Cc: <zope(a)zope.org> > Sent: Wednesday, August 09, 2000 12:56 PM > Subject: [Zope] ZMySQLDA on Win32 - connect then crash > > > Dear Phil: > > > > Thanks for your "How-To: ZMySQLDA on Win32 (2000/02/14)". > > And for your inquiry about troubles with the set up. > > > > Following the steps you outlined, I was able to establish > > a (very) minimal working connection. That is to say, I can > > use Zope's 'Z MySQL Database Connection' 'Test' page with > > the SQL command 'use tmm' (tmm is the name of my database), > > with success: > > > > This statement returned no results. > > ----------------------------------- > > > > SQL Used: > > > > use tmm > > > > > > But, when I 'test' any more complex command > > ('show tables', or 'select * from city' -- > > all without the surrounding quotes ' ), Zope crashes. > > > > Specifically, I get a Window's message: > > > > 'Python: This program has performed an > > illegal operation and will be shut down.' > > > > Details: > > PYTHON executed an invalid instruction in > > module <unknown> at 0000:01670d74. > > Registers: > > EAX=017c81b1 CS=015f EIP=01670d74 EFLGS=00010286 > > EBX=00000001 SS=0167 ESP=01c8fa90 EBP=01670d70 > > ECX=1e10f91f DS=0167 ESI=ffffffff FS=1307 > > EDX=00000000 ES=0167 EDI=012d2a50 GS=0000 > > Bytes at CS:EIP: > > f0 a2 2d 01 30 19 46 01 3d 43 3a 5c 02 00 00 00 > > Stack dump: > > 00764580 1e16f958 00764580 00000000 > > 00764580 1e10f831 00b4bb40 00764580 > > 00000000 00b4bb40 00f169f4 1e10e74c > > 00b4bb40 00764580 00000000 00b04400 > > > > > > I am running MySQL with the --console option, > > which recorded: > > > > C:\mysql\bin\mysqld.exe: ready for connections > > 000809 12:53:27 Aborted connection 3 to db: 'tmm' > > user: 'root' host: `localhost' (Unknown error) > > 000809 12:53:27 Aborted connection 2 to db: 'tmm' > > user: 'root' host: `localhost' (Unknown error) > > > > > > My 'Z MySQL Database Connection' page shows: > > > > The Media Machine (connected) Status > > Id tmm_db > > Title The Media Machine > > Database Connection String tmm root > > > > The database connection is open. > > > > > > My environment: > > Windows 98 4.10.98 > > MySQL Server version: 3.23.21-beta-debug > > Zope version: Zope 2.2.0 (binary release, python 1.5.2, win32-x86) > > Python version: 1.5.2 (#0, Jul 30 1999, 09:52:18) [MSC 32 bit (Intel)] > > Computer: Acer Extensa 710TE, PentiumII, 160MB RAM > > > > Thanks in andvance for any thoughts. > > > > William BC Crandall > > Wiesbaden, Germany > > wcra(a)beest.midat.de > > > > > > _______________________________________________ > > 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

Re: [Zope] Client.py
by Oliver Bleutgen 09 Aug '00

09 Aug '00

> hi all > has anybody successfully used Client.py that ships with Zope-2.2.0? i > can't > seem to run it. even on the command line. i've searched the mailing > list, > but to no avail > this is what i did: > python Client.py http://www.zope.org > and here's the traceback. > Traceback (innermost last): > File "Client.py", line 639, in ? > main() > File "Client.py", line 632, in main > headers, body = apply(f,(),kw) > File "Client.py", line 221, in __call__ > raise NotAvailable, RemoteException( > bci.NotAvailable: argument 1: expected read-only character buffer, tuple > found (File: http://www.zope.org Line: > []) > None None for None > what did i do wrong? can i use Client.py from Zope-2.1.x? Hi, I guess Client.py or one of the libs it uses is somewhat broken. I get the exact same error when trying to use utilities/load_site.py from 2.2.0 (and Oleg Broytmann already sent a mail with the same problem to this list). load_site from 2.1.6 works fine though, perhaps that means you can use Client.py from 2.1.6. cheers, oliver

1 0

Very strange problem with updating an objects properties
by Peter Arvidsson 09 Aug '00

09 Aug '00

I have made two products, one news-product and one product for pressreleases. The products are exactly equal except that they have a bit different properties. All the code for processing these two products are equal (except then for the handling of their different properties). Everything works fine except when I want to update the properties of an object. For news this works perfectly but for pressreleases this doesnt work. I am completely puzzled because the code for doing this is the same for both of them. Here is how it looks: For news: <dtml-with "newsEntries"> <dtml-if "_.getitem(objId,0).approved == 0"> <dtml-call "REQUEST.set('approved', 1)"> <dtml-call "_[objId].propertysheets[1].manage_editProperties(REQUEST)"> <dtml-call "RESPONSE.redirect('approveNews')"> <dtml-else> <dtml-call "REQUEST.set('approved', 1)"> <dtml-call "_[objId].propertysheets[1].manage_editProperties(REQUEST)"> <dtml-call "RESPONSE.redirect('administerNews')"> </dtml-if> </dtml-with> For pressreleases: <dtml-with "pressEntries"> <dtml-call "_[objId].propertysheets[1].manage_editProperties(REQUEST)"> <dtml-call "RESPONSE.redirect('administerPress')"> </dtml-with> So the updating of both of the products are done by <dtml-call "_[objId].propertysheets[1].manage_editProperties(REQUEST)"> but when I try to update pressreleases is says I am unauthorized. However I am pretty sure this is not the problem. I cant set any proxy rules for the products, I am the manager and manager has got all permissions on those objects. I am still unauthorized when I try to login as superuser. I have been told I am unauthorized before when I in fact has tried to call the objects wrong so thats why I dont think this is a security-problem. Does any1 have a clue of what is wrong here? How can the same code work in one method and not in another? I am running 2.2 final. This is the traceback I get: Traceback (innermost last): File /usr/local/new.test.version.of.zope.DO.NOT.REMOVE/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /usr/local/new.test.version.of.zope.DO.NOT.REMOVE/lib/python/ZPublisher/Publish.py, line 187, in publish File /usr/local/new.test.version.of.zope.DO.NOT.REMOVE/lib/python/ZPublisher/Publish.py, line 171, in publish File /usr/local/new.test.version.of.zope.DO.NOT.REMOVE/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: handleAdministration) File /usr/local/new.test.version.of.zope.DO.NOT.REMOVE/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: handleAdministration) File /usr/local/new.test.version.of.zope.DO.NOT.REMOVE/lib/python/OFS/DTMLMethod.py, line 167, in __call__ (Object: handleAdministration) File /usr/local/new.test.version.of.zope.DO.NOT.REMOVE/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: handleAdministration) File /usr/local/new.test.version.of.zope.DO.NOT.REMOVE/lib/python/DocumentTemplate/DT_With.py, line 146, in render (Object: pressEntries) File /usr/local/zope/lib/python/DocumentTemplate/DT_Util.py, line 342, in eval (Object: _[objId].propertysheets[1].manage_editProperties(REQUEST)) (Info: REQUEST) File <string>, line 0, in ? File /usr/local/zope/lib/python/DocumentTemplate/DT_Util.py, line 168, in careful_getitem File /usr/local/new.test.version.of.zope.DO.NOT.REMOVE/lib/python/OFS/DTMLMethod.py, line 189, in validate (Object: handleAdministration) File /usr/local/new.test.version.of.zope.DO.NOT.REMOVE/lib/python/AccessControl/SecurityManager.py, line 139, in validate File /usr/local/new.test.version.of.zope.DO.NOT.REMOVE/lib/python/AccessControl/ZopeSecurityPolicy.py, line 159, in validate Unauthorized: webdav Since I am completely puzzled of what the issue could be here I would really appreciate if someone could solve this for me. Thanks.

1 0

Problems publishing simple object directly thru ZServer
by Max Møller Rasmussen 09 Aug '00

09 Aug '00

---------------------------------------------------------------------- I have made a very simple class that I am trying to publish thru ZServer: ---------------------------------------------------------------------- class hello: """A very simple publishable objet in zope""" def world(self): "DocStrings are NOT optional" return "hello world" ---------------------------------------------------------------------- I have changed the following in z2.py ---------------------------------------------------------------------- #zh = zhttp_handler(MODULE, '', HTTP_ENV) #hs.install_handler(zh) sys.path.insert(0,'C:/root/pythonScripts/hello') # add MyModule to the Python path my_handler = zhttp_handler('hello', '') # create a handler hs.install_handler(my_handler) # install it in the http server# ---------------------------------------------------------------------- And I get this traceback: ---------------------------------------------------------------------- Zope Error Zope has encountered an error while publishing this resource. exceptions.TypeError Sorry, a Zope error occurred. Traceback (innermost last): File C:\mxmZope\lib\python\ZPublisher\Publish.py, line 222, in publish_module File C:\mxmZope\lib\python\ZPublisher\Publish.py, line 171, in publish File C:\mxmZope\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: world) File C:\mxmZope\lib\python\ZPublisher\Publish.py, line 112, in call_object (Object: world) TypeError: unbound method must be called with class instance 1st argument ---------------------------------------------------------------------- Can anyone see the error of my ways? I can't. I would think that: "unbound method must be called with class instance 1st argument" would mean I had forgotten "self" in my method but this is clearly not the case. Kind Regards Max M

1 0

ZMySQLDA on Win32 - connect then crash
by William BC Crandall 09 Aug '00

09 Aug '00

Dear Phil: Thanks for your "How-To: ZMySQLDA on Win32 (2000/02/14)". And for your inquiry about troubles with the set up. Following the steps you outlined, I was able to establish a (very) minimal working connection. That is to say, I can use Zope's 'Z MySQL Database Connection' 'Test' page with the SQL command 'use tmm' (tmm is the name of my database), with success: This statement returned no results. ----------------------------------- SQL Used: use tmm But, when I 'test' any more complex command ('show tables', or 'select * from city' -- all without the surrounding quotes ' ), Zope crashes. Specifically, I get a Window's message: 'Python: This program has performed an illegal operation and will be shut down.' Details: PYTHON executed an invalid instruction in module <unknown> at 0000:01670d74. Registers: EAX=017c81b1 CS=015f EIP=01670d74 EFLGS=00010286 EBX=00000001 SS=0167 ESP=01c8fa90 EBP=01670d70 ECX=1e10f91f DS=0167 ESI=ffffffff FS=1307 EDX=00000000 ES=0167 EDI=012d2a50 GS=0000 Bytes at CS:EIP: f0 a2 2d 01 30 19 46 01 3d 43 3a 5c 02 00 00 00 Stack dump: 00764580 1e16f958 00764580 00000000 00764580 1e10f831 00b4bb40 00764580 00000000 00b4bb40 00f169f4 1e10e74c 00b4bb40 00764580 00000000 00b04400 I am running MySQL with the --console option, which recorded: C:\mysql\bin\mysqld.exe: ready for connections 000809 12:53:27 Aborted connection 3 to db: 'tmm' user: 'root' host: `localhost' (Unknown error) 000809 12:53:27 Aborted connection 2 to db: 'tmm' user: 'root' host: `localhost' (Unknown error) My 'Z MySQL Database Connection' page shows: The Media Machine (connected) Status Id tmm_db Title The Media Machine Database Connection String tmm root The database connection is open. My environment: Windows 98 4.10.98 MySQL Server version: 3.23.21-beta-debug Zope version: Zope 2.2.0 (binary release, python 1.5.2, win32-x86) Python version: 1.5.2 (#0, Jul 30 1999, 09:52:18) [MSC 32 bit (Intel)] Computer: Acer Extensa 710TE, PentiumII, 160MB RAM Thanks in andvance for any thoughts. William BC Crandall Wiesbaden, Germany wcra(a)beest.midat.de

1 0

how to override SERVER_URL?
by Roman Milner 09 Aug '00

09 Aug '00

I need to override SERVER_URL so I can trick Zope in to giving me the correct base href. I can't figure out how. I tried exporting it as an environment variable, and putting it in the http headers - but neither worked. Can anyone help? I'm runnig ZServer without apache. FWIW, the reason I need to do this is I'm trying to write a simple load balancing proxy server with failover support that works at the http level and not at the tcp level for use with ZEO. The problem is the base href returned to the client points to the actual zope server, not the proxy server. Thanks, ^Roman

3 2

Requested Zope feature
by J. Atwood 09 Aug '00

09 Aug '00

A lot of the time I end up going into a document/folder/method just so I can click on the 'view' tab popping up a new window so I can see it (option click / right click). It would be very nice if DC could add a icon (or take over the existing icon) to pop a new window with the object ( a target="top" href="object" ) so you could view the object without having to edit it. This would save about 2 steps for something that, personally, I do all the time. The link to the object would still be for editing it. Just a thought. Thanks, J

2 1

LDAP Usersource for LoginManager
by Chris Withers 09 Aug '00

09 Aug '00

Hi, Has anyone got an LDAP usersource working with LoginManager? More specifically, hitting the LDAP service provides my a Lotus Notes NAB... Any ideas? cheers, Chris

1 0

ZPoPyDA installation: help needed
by Hung Jung Lu 09 Aug '00

09 Aug '00

Hi, I have been trying to install ZPoPyDA (database adapter for PostGreSQL.) And I am kind of stuck. I was told to install the RedHat PostGreSQL development RPM first. But I can't even install this RPM. I must be missing something obvious. # rpm --install postgresql-devel-7.0.2-2.i386.rpm failed dependencies: postgresql = 7.0.2 is needed by postgresql-devel-7.0.2-2 libc.so.6(GLIBC_2.0) is needed by postgresql-devel-7.0.2-2 libc.so.6(GLIBC_2.1) is needed by postgresql-devel-7.0.2-2 what is the libc.so shared object? Is it part of standard C library? Is it part of Red Hat Linux? Where can I find/get it? Do I need to set any particular path? Do I need to modify the /etc/ld.so.conf file? regards, Hung Jung ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

3 2

broken Hyerlinks
by arno.gross＠consotec.de 09 Aug '00

09 Aug '00

Is it possible to check for broken hyperlinks in Zope? Arno Gross consotec arno.gross(a)consotec.de

1 0