October 2000 - Zope - Zope lists

ZSQL Method & AUTHENTICATED_USER
by Aaron Straup Cope 18 Oct '00

18 Oct '00

Hi, I'm trying to perform a simple MySQL lookup based on the AUTHENTICATED_USER. When I test the ZSQL method from the management interface, everything works fine. However, when I try to call the method from a DTML document, [it] returns nothing. Is this a namespace issue? I'm stumped and hoping that I'm not staring right past the problem. Can anyone point out what it is I am doing wrong? Thanks, a) DTML Document : foo <dtml-with people> <dtml-in lookup_by_username> <dtml-var "username"> </dtml-in> </dtml-with> b) ZSQL Method : people.lookup_by_username select * from people where username = "<dtml-var "REQUEST.AUTHENTICATED_USER.getUserName()">"

1 0

RE: [Zope] Two questions regarding SQL
by Baker, Dennis [sjmr] 18 Oct '00

18 Oct '00

Dunno if someone replied to this, but try GUF. Let's you roll your own authentication. There is a howto out there for using GUF with an SQL server. -----Original Message----- From: //www.alomega.com/ [mailto:amadorm@usm.edu.ec] Sent: Tuesday, October 17, 2000 3:02 PM To: zope(a)zope.org Subject: [Zope] Two questions regarding SQL Hey 2 everyone: I have two questions. 1) I need to authenticate my Zope users against a Sybase SQL database. 2) I need to make my Zope ODBC database connection object use (i.e. connect with) the user and password of the AUTHENTICATED_USER because security is at the database level, for tables and stored procedures. How do I do that? Any pointers? LoginManager did not work for zope 2.2.2 here. Besides, the new Z ODBC connection form only lets me specify an ODBC dsn or a connection string. And as I understand, the connection string is the same for ALL zope users that use that object. Any practical solutions to the problem #2? Will I have to connect to the DB as DBA? If that's the case, I'll have to go with PHP. I'm sorry for my former HTML postings. Won't happen again. Thanks in advance. ---------------------------------------------------------- Universidad Federico Santa Maria - Campus Guayaquil _______________________________________________ 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] MySQL and Zope struggles
by Baker, Dennis [sjmr] 18 Oct '00

18 Oct '00

What about one sql method: select @noteid:=note_id from artist where <dtml-sqltest artist_id type=int> <dtml-var sql_delimiter> update note set notes =<dtml-sqlvar notes type=string> where note_id = @noteid -----Original Message----- From: Richard Moon [mailto:richard@dcs.co.uk] Sent: Monday, October 16, 2000 2:48 AM To: zope(a)zope.org Subject: [Zope] MySQL and Zope struggles I'm struggling to migrate an application from Zope/PostgreSQL to Zope MySQL (Why ? - because I've got a kind offer of free hosting if I use MySQL). MySQL offers a limited set of features and is missing, among other things, the ability to use subqueries - so for example in PostgreSQL you can say update note set notes =<dtml-sqlvar notes type=string> where note_id = (select note_id from artist where <dtml-sqltest artist_id type=int>) and in MySQL you can't. If you were working in a traditional programming environment you could overcome this by splitting the above into two parts - a select to retrieve the value of note_id from the artist table followed by an update of the note table using the returned value of note-id. For example select note-id into note-id-var from artist where artist-id = 23; update note set notes = 'asdasda' where note-id = note-id-var; The problem is that in Zope I believe you can't use a returned value within an SQL Method, so the above code would fail. The only way I can see to do the above is to have two separate SQL Methods, one for the select, returning the note-id-var and another for the update. This is very clumsy. I was wondering if anyone could tell me if there was a better way. Many thanks Richard Richard Moon richard(a)dcs.co.uk _______________________________________________ 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] Want to access ZClass Instance from external program
by Jon Prettyman 18 Oct '00

18 Oct '00

Adding: try: for k in server.EBQ.id_company_apply_html.propertysheets.propertyIds(): print "%-15s:" % (k) except Error, v: print server print "ERROR", v Gives me output, although I'm pretty shure it's not the right thing. Output: title base Both of these are properties of server.EBQ. -jon Ender <kthangavelu(a)earthlink.net> writes: > Jon Prettyman wrote: > > > > Well, I've gotten xmlprclib and fixed it up so I can talk to my > > server. So far I can retrieve objectIds and retrieve objects via an > > objectid, but I can't figure out how to get to the property sheets. > > > > Here's what I've got: > > > > server = Server( "http://jonprettyman.com" ) > > > > print server > > > > for k,v in > > server.EBQ.id_company_apply_html.propertysheets.common.propertyItems(): > > print "%-15s: %s" % (k, v) > > -jon > > hmmm... > > try and take it a step back and query the propertysheet container for > names of propertysheets it contains. you'll need to check out the ZQR > for the syntax, i think its propertyIds(). > > > you might also want to check that your authenticating with a user > that has the proper security roles to query this info. > > > if you're still having problems tell me and i'll play with it once i get > back from work. > > Cheers > > Kapil > > _______________________________________________ > 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 )

2 1

How about removing broken things like Confera and ZDiscussions?
by Cary O'Brien 18 Oct '00

18 Oct '00

Why are things like ZDiscussions and Confera even on the zope download pages? They don't work! It would be better if they were moved to a section called "Things that worked once but aren't being maintained so they don't work any more". Otherwise people starting out might see all these seemingly useful things and get frustrated when they dont work. Arrrggg. I just want a bulletin board that works! I know what you are going to say, so I'll start digging through the python code before you yell at me... -- cary

7 13

Re: [Zope] __len__ Errors
by Chris Withers 18 Oct '00

18 Oct '00

Nope, the list might benefit from seeing the traceback though... cheers, Chris Scott Burton wrote: > > They are ZDiscussion based. I might have figured out why. I added my custom > properties to the discussion items. I did not know ZD was python-based and > not entirely ZClassed. > > I have been moving my products over to 2.2 on my server with the exception > of ZDiscussion which seems to be giving me a strange error when I try to > import the ZDiscussion.zexp. It is an A pickle error. I could give you the > trace back it has some strange errors in it regarding other product???. > > I will try some more this evening. > > Thanks, > > Scott > > > From: Chris Withers <chrisw(a)nipltd.com> > > Organization: New Information Paradigms > > Date: Wed, 18 Oct 2000 10:16:34 +0100 > > To: Scott Burton <scott(a)launchpoint.net> > > Subject: Re: [Zope] __len__ Errors > > > > Scott: No HTML mail! ;-) > > > > Are the discussions groups Squishdot-based? > > > > Any reason you can't upgrade to 2.2.2? > > > > cheers, > > > > Chris > > > > Scott Burton wrote: > >> > >> I seem to be getting __len__ errors: Error type: > >> exceptions.AttributeError > >> Error value: __len__ > >> When accessing any method with an <dtml-in > loop. > >> I am running 2.1.6, with the current hot fixes. It seems to have > >> started after installing the hot fixes. > >> I can replicate it with a simple <dtml-in> loop in a method. I read > >> somewhere about the hotfix changing objects ownerships. Could this be > >> causing this? If so, how do I remove a hotfix? It has rendered my > >> discussion groups useless. > >> > >> TIA > >> > >> Scott > >

1 0

Re: [Zope] Problems with PoPy 1.4 & ZPoPyDA 0.7
by Dustin 18 Oct '00

18 Oct '00

Thanks for the help Kapil. That was the problem, but what I did instead was copied the PoPymodule.so from the system python lib folder to /zope_home/lib/python. That did the trick. Dustin Kapil Thangavelu <kthangavelu(a)earthlink.net> said: > > hi dustin > > your probably not running the same python interpreters. > > check your start shell script and see which python interpreter its using > and compare > it to (i'm kinda of assuming your're on a *nix system) > > >which python > > they probably aren't the same. just edit the start script accordingly. > > kapil > > zope(a)engelhaupt.com wrote: > > > > I have a working install of Zope 2.2.2. I installed the python module PoPy > > 1.4 and then attempted to install the ZPoPyDA 0.7 DB adapter. The ZPoPyDA > > README said to run a configure script but there was none. So I just moved the > > ZPoPyDA directory it created into the lib/python/Products directory in my zope > > home. > > > > Now for the strange part. When I start zope, I get the following: > > > > 2000-10-17T20:25:51 ERROR(200) Zope Couldn't import Products.ZPoPyDA > > Traceback (innermost last): > > File /zope_home/lib/python/OFS/Application.py, line 397, in import_products > > (Object: string) > > File /zope_home/lib/python/Products/ZPoPyDA/__init__.py, line 32, in ? > > File /zope_home/lib/python/Products/ZPoPyDA/DA.py, line 35, in ? > > File /zope_home/lib/python/Products/ZPoPyDA/PoPy_db.py, line 27, in ? > > ImportError: No module named PoPy > > > > ZPoPyDA comes up as a broken product in the Control Panel. So I checked it out > > on my own. I created a file with the following line: > > > > import PoPy > > > > I ran 'python test' and no errors. I added the line: > > > > import bla > > > > And then ran 'python test' again just to be sure and it did die saying no such > > module bla. I even typed 'import PoPy' in the python interactive shell and > > nothing. So outside of zope, python seems to be able to import PoPy, but when > > zope tries to import ZPoPyDA it claims there is no PoPy module. > > > > Any ideas? > > > > Thanks in advance, > > Dustin > > > > _______________________________________________ > > 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 ) > > _______________________________________________ > 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

GUF, ZODB, and 2.2.2
by Jason Byron 18 Oct '00

18 Oct '00

Has anyone had luck getting GUF to work using ZODB to store the user info, and Zope version 2.2.2 (no hot fixes)? I had some code working fine in 2.2.1, but in 2.2.2 I am having lots of trouble getting GUF to work. The current implementation I have places a folder in the acl_users (GUF) folder and that is where I've put my own ZClass (representing each user) inside that folder. In a vain attempt to get it working I have made sure that there are no aquired rights in acl_users, and that anonymous has the Can Login, and Access contents rights. I've also changed all of the hooks I have and made them proxy as root. I've had trouble in the past with GUF but I've always gotten it working. Not so here. Has anyone tried this type of setup and gotten it working? __________________________________________________ Do You Yahoo!? Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/

1 0

UserDb - Please just WORK
by ed colmar 18 Oct '00

18 Oct '00

Since Login Manager isn't doing the trick, I've been trying User DB to authenticate to my postgresql DB. I get some strange errors, like when I try to view a page that is 'protected' by UserDb, I get the error message below. Also, when I click a user in the management screen, it says "the specified user does not exist". Arrggg this task is so simple but REALLY FRUSTRATING... Thank you, thank you, thank you... (to anyone who can help) Error Type: TypeError Error Value: argument 1: expected read-only character buffer, None found Traceback (innermost last): File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 187, in publish File /usr/local/zope/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: Traversable) File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 162, in publish File /usr/local/zope/lib/python/ZPublisher/BaseRequest.py, line 440, in traverse File /usr/local/zope/lib/python/Products/UserDb/UserDb.py, line 310, in validate (Object: RoleManager) File /usr/local/zope/lib/python/AccessControl/User.py, line 437, in validate (Object: RoleManager) File /usr/local/zope/lib/python/Products/UserDb/UserDb.py, line 147, in getUsers (Object: RoleManager) File /usr/local/zope/lib/python/Products/UserDb/UserDb.py, line 52, in __init__ TypeError: (see above)

2 1

SQL cursor error
by steve smith 18 Oct '00

18 Oct '00

Anyone know what this means? Error Type: sql.error Error Value: ('24000', 0, '[Microsoft][ODBC SQL Server Driver]Invalid cursor state' I get this when I try to submit a form which passes control to a dtml method. that method in turn makes a dtml-call to another, which calls a SQL method. Regards Steve Smith

2 1