[Zope] SQL Session woes (urgent for me)

[Jérôme Loisel]

Hello all!


I am having problems with SQLSession. I e-mailed Anthony about it two
days ago, but have not heard from him yet. And I need this resolved
quickly for deadline reasons. Can someone here help me out, please?

I am running Zope 2.2 and SQLSession 0.3 on a fresh RedHat 6.2 install +
Helix Gnome. (Is 0.3 the version I should be using for production work?
Maybe 0.2.3 would be more appropriate?) I tried FSSession as well, but
dropped it because it was generating errors.

I have a /groupe folder which contains a dedicated ZGadfly connection
with its own var/gadfly/ subdirectory (with proper permissions set).
Zope reports that database connection as open. I have also created in
the same folder an SQL_Session object which uses that database
connection in base64oneline format.

I get the following error message when trying <dtml-call Session>:

"""
KeyError

Sorry, a Zope error occurred.

Traceback (innermost last):
File /usr/local/Zope-2.2.0-linux2-x86/lib/python/ZPublisher/Publish.py,
line 222, in publish_module
File /usr/local/Zope-2.2.0-linux2-x86/lib/python/ZPublisher/Publish.py,
line 187, in publish
File /usr/local/Zope-2.2.0-linux2-x86/lib/python/Zope/__init__.py, line
221, in zpublisher_exception_hook
   (Object: ElementWithAttributes)
File /usr/local/Zope-2.2.0-linux2-x86/lib/python/ZPublisher/Publish.py,
line 171, in publish
File /usr/local/Zope-2.2.0-linux2-x86/lib/python/ZPublisher/mapply.py,
line 160, in mapply
   (Object: index_html)
File /usr/local/Zope-2.2.0-linux2-x86/lib/python/ZPublisher/Publish.py,
line 112, in call_object
   (Object: index_html)
File /usr/local/Zope-2.2.0-linux2-x86/lib/python/OFS/DTMLMethod.py, line
167, in __call__
   (Object: index_html)
File
/usr/local/Zope-2.2.0-linux2-x86/lib/python/DocumentTemplate/DT_String.py,
line 502, in __call__
   (Object: index_html)
File /usr/local/Zope-2.2.0-linux2-x86/lib/python/OFS/DTMLMethod.py, line
163, in __call__
   (Object: standard_html_header)
File
/usr/local/Zope-2.2.0-linux2-x86/lib/python/DocumentTemplate/DT_String.py,
line 502, in __call__
   (Object: standard_html_header)
File
/usr/local/Zope-2.2.0-linux2-x86/lib/python/Products/SQLSession/SQLSession.py,
line 317, in __call__
   (Object: Session)
File
/usr/local/Zope-2.2.0-linux2-x86/lib/python/Products/SQLSession/SQLSession.py,
line 347, in newSession
   (Object: Session)
File /usr/local/Zope-2.2.0-linux2-x86/lib/python/Shared/DC/ZRDB/DA.py,
line 450, in __call__
   (Object: sqlSessionCreate)
File
/usr/local/Zope-2.2.0-linux2-x86/lib/python/Products/ZGadflyDA/db.py,
line 178, in query
File
/usr/local/Zope-2.2.0-linux2-x86/lib/python/Products/ZGadflyDA/gadfly/gadfly.py,
line 349, in execute
File
/usr/local/Zope-2.2.0-linux2-x86/lib/python/Products/ZGadflyDA/gadfly/sqlmod.py,
line 596, in relbind
File
/usr/local/Zope-2.2.0-linux2-x86/lib/python/Products/ZGadflyDA/gadfly/gfdb0.py,
line 206, in get_for_update
File
/usr/local/Zope-2.2.0-linux2-x86/lib/python/Products/ZGadflyDA/gadfly/gfdb0.py,
line 1051, in __getitem__
KeyError: ZSESSIONS
"""

I would very much appreciate any help you could give me with regards to
that. Thank you very much for your time.

Cheers,

Jérôme Loisel