[Zope] UserDb - Please just WORK

Phil Harris phil.harris@zope.co.uk
Wed, 18 Oct 2000 15:29:46 +0100


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 )