[Zope-PTK] SQL user database with the Portal Wizard (revisited?)

[Kurt D. Bollacker]

I'm trying to create a portal with the wizard, and use a MySQL
database to store user information.  I created the tables

create table users (
username varchar(255),
password varchar(255),
domains varchar(255),
roles varchar(255));

create table propertysheets (
username varchar(255),
propertysheet varchar(255),
property varchar(255),
value varchar(255));

but when I try to <Finish> the portal creation, I get:

 Zope has encountered an error while publishing this resource. 
 
              Error Type: AttributeError
              Error Value: __propsets__

(traceback included below)

Bill Anderson asked about this (or a very similar) problem 9 months
ago, with little resolution.  I'm creating an entire site around the
PTK, and I need the user info to be in an SQL database.  Is there a
way to solve the above problem or some other way to get an SQL DB to
work with the PTK? There was some talk about using LoginManager, but
that seems still in early development, so I don't know if it's stable
enough.  If anyone has an SQL implementation for LoginManager, that
would be great as well.

Any information is greatly appreciated.

							Kurt :-)

              Oo........................................oO
                            Kurt D. Bollacker
                         The Long Now Foundation
              P.O. Box 29462, San Francisco, CA 94129-0462
                    415-561-6582   kurt@longnow.org
              Oo........................................oO


Traceback (innermost last):
  File /usr/local/www/Zope/lib/python/ZPublisher/Publish.py, line 222, in publish_module
  File /usr/local/www/Zope/lib/python/ZPublisher/Publish.py, line 187, in publish
  File /usr/local/www/Zope/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook
    (Object: RoleManager)
  File /usr/local/www/Zope/lib/python/ZPublisher/Publish.py, line 171, in publish
  File /usr/local/www/Zope/lib/python/ZPublisher/mapply.py, line 160, in mapply
    (Object: Portal_add)
  File /usr/local/www/Zope/lib/python/ZPublisher/Publish.py, line 112, in call_object
    (Object: Portal_add)
  File /usr/local/www/Zope/lib/python/OFS/DTMLMethod.py, line 172, in __call__
    (Object: Portal_add)
  File /usr/local/www/Zope/lib/python/DocumentTemplate/DT_String.py, line 528, in __call__
    (Object: Portal_add)
  File /usr/local/www/Zope/lib/python/DocumentTemplate/DT_With.py, line 146, in render
    (Object: Portal.createInObjectManager(REQUEST['id'], REQUEST))
  File /usr/local/www/Zope/lib/python/DocumentTemplate/DT_Let.py, line 147, in render
    (Object: RESPONSE="_.None")
  File /usr/local/www/Zope/lib/python/DocumentTemplate/DT_Util.py, line 337, in eval
    (Object: portal_registration.addMember(username, password,
        ('Member', 'Manager', 'Reviewer'), '', REQUEST))
    (Info: username)
  File <string>, line 0, in ?
  File /usr/local/www/Zope/lib/python/Products/PTKBase/RegistrationTool.py, line 154, in addMember
    (Object: portal_registration)
  File /usr/local/www/Zope/lib/python/Products/PTKBase/RegistrationTool.py, line 185, in isMemberIdAllowed
    (Object: portal_registration)
  File /usr/local/www/Zope/lib/python/Products/PTKBase/MembershipTool.py, line 192, in getMemberById
    (Object: portal_membership)
  File /usr/local/www/Zope/lib/python/Products/PTKDemo/SQLMember.py, line 186, in getUser
    (Object: DemoSQLMemberFolderBase)
  File /usr/local/www/Zope/lib/python/OFS/PropertySheets.py, line 639, in __getitem__
    (Object: Traversable)
  File /usr/local/www/Zope/lib/python/ZClasses/Property.py, line 407, in __propsets__
    (Object: Traversable)
  File /usr/local/www/Zope/lib/python/OFS/PropertySheets.py, line 628, in __propsets__
    (Object: Traversable)
AttributeError: (see above)