ed, If I'm right it should be a fairly simple job to fix it. I use Interbase to hold my user database and out of the box I get almost exactly the same problems you do. The problem is that 'password' is a reserved word. The interbase solution is to rewrite the UserDB sql queries to be something like : select username, "PASSWORD",domains,roles from users Note the quotation marks around 'password'. Another solution involves editing UserDB.py, I can't remember the exact place, but you need to tell it to use a different name for the password field, I chose 'password_' at one time, which also fixed the problem. hth Phil phil.harris@zope.co.uk ----- Original Message ----- From: "ed colmar" <ecolmar@uswest.net> To: <zope@zope.org> Sent: Wednesday, October 18, 2000 2:40 PM Subject: [Zope] UserDb - Please just WORK
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)
_______________________________________________ Zope maillist - Zope@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 )