Mysql user auth products?
Hi, I am looking for a product that will allow me to do user authentication and authorization from a mysql database. My primary needs here are stability as this will be going into a production environment. Does anyone have any experience of these kinds of products and would they recommend any? I am using zope 2.5.0 btw. Thanks Paul.
Paul writes:
I am looking for a product that will allow me to do user authentication and authorization from a mysql database. My primary needs here are stability as this will be going into a production environment. Does anyone have any experience of these kinds of products and would they recommend any? I am using zope 2.5.0 btw. Look for "exUserFolder"...
Dieter
Hi, I have had a look at this product and read the docs, but I am unclear how this will allow me to authenticate against a mysql database. Postgresql is supported however. Any hints greatly appreciated. Paul.
-----Original Message----- From: Dieter Maurer [mailto:dieter@handshake.de] Sent: 08 April 2002 18:05 To: Paul Cc: zope@zope.org Subject: Re: [Zope] Mysql user auth products?
Paul writes:
I am looking for a product that will allow me to do user authentication and authorization from a mysql database. My primary needs here are stability as this will be going into a production environment. Does anyone have any experience of these kinds of products and would they recommend any? I am using zope 2.5.0 btw. Look for "exUserFolder"...
Dieter
At 8:11 PM +0100 4/8/02, Paul wrote:
Hi, I have had a look at this product and read the docs, but I am unclear how this will allow me to authenticate against a mysql database. Postgresql is supported however. Any hints greatly appreciated.
I just did this, so here goes... - I created an ex User Folder in the folder I wish to protect. - I chose a user authentication source; - I chose a null Properties and Membership source; - I chose cookie-based authentication; You will then have a container called usAuthSource. If you go look at the source for this in the exUserFolder package on your drive (lib/python/Products/exUserFolder/usAuthSource/usAuthSource.py), you will be able to determine all the scripts you need to implement: usCreateUser usCryptPassword (only if your pwds are not kept in cleartext) usDeleteUsers usListOneUser usListUserNames usListUsers (do this one _first_) usUpdateUser I found it helpful to create sql scripts to wrap the db operations: sqlCreateUser sqlDeleteOneUser sqlListOneUser sqlListUsers sqlUpdateUser BTW, it is very helpful to do these one at a time and test them _under another name_ before you rename them to usXXX. If you don't, you may have to move out to the top and back out your changes. HTH, - rmgw http://www.electricfish.com/hawkfish/ ---------------------------------------------------------------------------- Richard Wesley Electric Fish, Inc. hawkfish@electricfish.com "Grownups have the most uninteresting explanations for things." - C. S. Lewis, _The Magician's Nephew_
participants (3)
-
Dieter Maurer -
Paul -
Richard Wesley