[Zope] "Zope DB instance has no attribute 'lock'"

[Joel Burton]

On Mon, 4 Mar 2002, Derek Simkowiak wrote:

>
> 	I installed the Z MySQL Database Adaptor product and configured a
> connection with the simple 'database username password' connection string.
>
> 	Now I get the above when I try "select * from applicants" in the
> 'test' view of my database adaptor.  I have no idea what it means, or how
> to troubleshoot it.  Is the problem in my database?  In Zope?  WTF?  The
> database connections shows itself as 'open', so I think it can talk to the
> database okay.
>
> 	What do I do next?  I'd post more information but I'm not sure
> what information is necessary... Here is the traceback from the error
> message page's source HTML:
>
> <!--
> Traceback (innermost last):
>   File /usr/lib/python2.1/site-packages/ZPublisher/Publish.py, line 223, in publish_module
>   File /usr/share/zope/lib/python/Products/Localizer/__init__.py, line 53, in new_publish
>   File /usr/lib/python2.1/site-packages/ZPublisher/Publish.py, line 187, in publish
>   File /usr/share/zope/lib/python/Zope/__init__.py, line 226, in zpublisher_exception_hook
>     (Object: MySQL_database_connection)
>   File /usr/lib/python2.1/site-packages/ZPublisher/Publish.py, line 175, in publish
>   File /usr/share/zope/lib/python/Zope/__init__.py, line 240, in commit
>   File /usr/share/zope/lib/python/ZODB/Transaction.py, line 325, in commit
>   File /usr/share/zope/lib/python/Shared/DC/ZRDB/TM.py, line 122, in tpc_finish
>   File /usr/share/zope/lib/python/Products/ZMySQLDA/db.py, line 351, in _finish
> AttributeError: (see above)
>
> -->

No idea, don't use MySQLFolder. Did want to say that exUserFolder, which
is similar but includes properties & caching, and can use many backends,
works out of the box with MySQL for authentication. (It says its only for
PostgreSQL, and if you want to store new attributes, you'll have to tweak
the SQL slightly for MySQL, but for usernames/passwords/roles, it works
fine w/o changes).

The nice thing about exUserFolder is that if/when you switch
databases/switch to LDAP/switch to SMB authentication/whatever, it will
still be there for you.

-- 

Joel BURTON  |  joel@joelburton.com  |  joelburton.com  |  aim: wjoelburton
Independent Knowledge Management Consultant