October 2000 - Zope - Zope lists

LoginManager - With SQL
by ed colmar 16 Oct '00

16 Oct '00

Thanks for the tips everyone! I keep going between UserDb and LoginManager to try to get this to work. UserDb gives me weird errors, and isn't really current, so I'm focusing on LM. I feel like I'm getting closer to a solution, but I'm still having difficuties... I followed jPenny's how to regarding accessing SQL method variables from within python, and wrapped the retrieveItem result in a User Class. It seems like it is at least running my code now, but no authentication... Am I close? Can Anyone working with LoginManager offer any insight into this? Thanks! -e- Here's the code I have in UserSources.py class User(BasicUser): """ A wrapper for the basic user class """ icon='misc_/UserDb/User_icon' def __init__(self, name, password, roles, domains): self.name =name self.__ =password self.roles =filter(None, map(strip, split(roles, ','))) self.domains=filter(None, map(strip, split(domains, ','))) def getUserName(self): return self.name def _getPassword(self): return self.__ def getRoles(self): return self.roles def getDomains(self): return self.domains class PGCryptUserSource(BasicUserSource): """ A sql based encrypted user source """ meta_type="PG Crypt User Source" __plugin_kind__="User Source" def retrieveItem(self, name): try: res=self.getuserbyusername(username=name) except: return None fields2index={} fieldnames=res._schema.items() for i in range(len(fieldnames)): fields2index[fieldnames[i][0]]=fieldnames[i][1] username=res[0][fields2index['username']] password=res[0][fields2index['password']] roles=res[0][fields2index['roles']] domains=res[0][fields2index['domains']] return User(username, password, roles, domains) def rolesForUser(self, user): name = user.getUserName() res = self.getuserbyusername(username=name) fields2index={} fieldnames=res._schema.items() for i in range(len(fieldnames)): fields2index[fieldnames[i][0]]=fieldnames[i][1] roles=res[0][fields2index['roles']] return roles def domainsForUser(self, user): name = user.getUserName() res = self.getuserbyusername(username=name) fields2index={} fieldnames=res._schema.items() for i in range(len(fieldnames)): fields2index[fieldnames[i][0]]=fieldnames[i][1] domains=res[0][fields2index['domains']] return domains def authenticateUser(self, user, password, request): name = user.getUserName() res = self.getuserbyusername(username=name) fields2index={} fieldnames=res._schema.items() for i in range(len(fieldnames)): fields2index[fieldnames[i][0]]=fieldnames[i][1] passwd=res[0][fields2index['password']] if crypt.crypt(password,'ab')==passwd: return 1 else: return 0 Here's one of the tracebacks that I get: 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/LoginManager/LoginManager.py, line 108, in validate (Object: ProviderContainer) File /usr/local/zope/lib/python/Products/LoginManager/LoginMethods.py, line 235, in findLogin (Object: PlugInBase) File /usr/local/zope/lib/python/Products/LoginManager/LoginManager.py, line 65, in getItem (Object: ProviderContainer) File /usr/local/zope/lib/python/Products/ZPatterns/Rack.py, line 60, in getItem (Object: ProviderContainer) File /usr/local/zope/lib/python/Products/LoginManager/UserSources.py, line 522, in retrieveItem (Object: ProviderContainer) File /usr/local/zope/lib/python/Products/LoginManager/UserSources.py, line 485, in __init__ TypeError: (see above)

1 0

How to use the date fmt's
by Jonathan Cheyne 16 Oct '00

16 Oct '00

Hi all, in the various docs it shows various fmt= to display different date types etc. It also shows some date formats that seem more like methods themselves, ie IsCurrentMonth returns true if etc. How can I use these in expressions? Jonathan

2 1

Manipulating acl_users with DTML methods
by Harris Peter 16 Oct '00

16 Oct '00

Hi I am new to this, and probably trying to do things the wrong way but: I have a PostgreSQL table of users for my Zope application, and ZSQL methods for inserting, updating and deleting users from the table. The only reason I am doing this is to associate their real name and email address with their user id. Is it possible to do some kind of dtml-call to insert, update or delete Zope users? I don't want the administrator of the application to have to maintain user information in 2 places. Also, is there some way for a user to change their own password, without them having permissions to manage other users? Peter Harris **************************************************************************** This message and any files transmitted with it are confidential. The contents may not be disclosed or used by anyone other than the addressee. If you have received this communication in error, please delete the message and notify JBB (Greater Europe) Plc immediately on 0141-249-6285. The views expressed in this email are not necessarily the views of JBB (Greater Europe) PLC. As it has been transmitted over a public network, JBB (Greater Europe) PLC makes no representation nor accepts any liability for the email's accuracy or completeness unless expressly stated to the contrary. Should you, as the intended recipient, suspect that the message has been intercepted or amended, please notify JBB (Greater Europe) Plc immediately on 0141-249-6285. ****************************************************************************

1 0

Question!
by Carlos Vasconez 16 Oct '00

16 Oct '00

Hi I am read about zope. Question? I can use Zope with NT Server, IIS 4 and SQLServer ? I have a Database in SQLServer Thanks Carlos ---------

1 0

Re: [Zope] MySQL and Zope struggles
by administrator＠consotec.de 16 Oct '00

16 Oct '00

I don't know if the following link can solve your problem, but maybe it gives you an idea: http://www.zope.org/Members/Roug/new_record_with_subrecords (How-To: Creating a new record with subrecords in MySQL) Arno > 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 ) > > > To: zope(a)zope.org

1 0

product.dat
by Seb Bacon 16 Oct '00

16 Oct '00

In the Zope PTK there are a couple of products that have been packaged as product.dats. What format are these? How do I do it? Cheers seb

2 1

MySQL and Zope struggles
by Richard Moon 16 Oct '00

16 Oct '00

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

1 0

ZClass derrived from Image does not call "view" from within <dtml-var>
by Noah 16 Oct '00

16 Oct '00

Hi, I'm a Zope beginner. I'm trying to create an ImageTemplate ZClass. This will work similar to an Image, but the user can insert it directly in DTML using <dtml-var MyImage> and it will get expanded into HTML (with formatting, <img> tag, caption, etc.) This may be long and complicated, but I thought that #4 below was interesting because it demonstrates how to get at base class methods even if you have overridden them. OK, here's the situation: 1. I created a ZClass derived from Image. 2. I overloaded the index_html to add spit out some HTML instead of the image. 3. If I call an instance of the ZClass directly I get the expected results. The index_html is called and I get back some HTML. Here: http://63.199.26.229:8080/c/gato 4. To get to the image I created an External Method that calls the index_html method of the my base class (Image): # I create an External Method called IMG that calls this Python method: def super_index_html (self): for classy in self.__class__.__bases__: if classy.__name__ == 'Image': return classy.index_html (self, self.REQUEST,\ self.REQUEST.RESPONSE) Example: http://63.199.26.229:8080/c/gato/IMG So far, so good! Now all I want to do is insert my ZClass in some DTML. Here's what happens: 1. I try to insert in instance of my ZClass into a DTML Method using: <dtml-var gato> 2. The Publisher does not call the view method (index_html) of the object! Instead it calls str() which is __str__ in Image and that calls Image.tag(). I can't overload __str__ because Zope does not allow a method to start with _ underscore. I ran this in the debugger, Publish.publish() (line 173) has this code: if result is not response: response.setBody(result) This is where the trouble begins. setBody() calls str() function on the object. How do I insert my ZClass into DTML now? Yours, Noah

2 1

Python regular expression help
by Peter Bengtsson 16 Oct '00

16 Oct '00

[ this might be more of a Python question, but it's got a lot to do with the web and is to be used in Zope ] I want to replace all occurences of email address's and URLs in a textstring, to <a href="mailto:%s">%s</a> and <a href="%s">%s</a>. Must admit that I am not an regex expert, and I wasn't able to find a "precompiled" regex for neither email nor URL. Or is there anything available from the zope/python stack?

3 2

image attachments in dtml-sendmail and dtml-mime
by Matt 16 Oct '00

16 Oct '00

I have benn having a problem with attaching images to a dtml-sendmail. The following is my dtml code : <dtml-sendmail mailhost="MailHost"> To: Feedback Recipient <matt.bion(a)eudoramail.com> From: Zope Feedback Form <matt.bion(a)eudoramail.com> Subject: Feedback from the web Feedback from : Matt <dtml-mime type=image/jpeg encode=7bit><dtml-var "paris"> </dtml-mime> </dtml-sendmail> "paris" is the ID of an image I uploaded into a node inherited when I action this dtml document, so there are no key errors or similar. The result in the email I get is : Feedback from : Matt Comments: Hello there, this is a sample email message for testing. Content-Type: multipart/mixed; boundary="127.0.0.1.500.953.971655250.628.16056" --127.0.0.1.500.953.971655250.628.16056 Content-Type: image/jpeg Content-Transfer-Encoding: 7bit <img src="http://localhost:8080/admin_test/paris" alt="paris" height="630" width="472" border="0"> --127.0.0.1.500.953.971655250.628.16056-- I understand that the dtml-mime tag is modifying the action of dtml-var that follows it, but what I want is the actual text coded binary to be dumped and not a source tag ... i.e. it's an email, not a webpage. I thought of embedding that in an external method that returns the text coded binary w.r.t the encoding type placed in the attributes, but was wondering if there was a method like this already available, and maybe not just image centric. Matt Bion

2 3