[Zope-dev] DCOracle 1.32 weirdness -- quick help needed

Shai Berger shai@aristocart.com
Tue, 07 Aug 2001 12:32:56 +0300


Hi Zopers,

Sorry for cross-posting -- I need help on this rather
fast...

I have been using ZOracleDA and DCOracle quite happily.
Now, I needed to branch a "test" zope from the "dev"
zope. As I was using the INSTANCE_HOME setup, this was
a breeze: I shut zope down, copied the instance directory
tree, meddled a little with the start scripts to give it
different ports, fixed my httpd.conf, et voila.
A new zope, up and running, independent of the first one.

Except...

Except that Oracle connections won't open. When I try
to open them manually, they say,

"""
<strong>Invalid connection string: </strong><CODE>not/gonna@tellya</CODE><br>
<!--
exceptions.TypeError
Expected an Oracle Connection object
-->
<PRE>
Traceback (innermost last):
  File /home/src/Zope-2.3.2-src/lib/python/ZPublisher/Publish.py, line 223, in publish_module
  File /home/src/Zope-2.3.2-src/lib/python/ZPublisher/Publish.py, line 187, in publish
  File /home/src/Zope-2.3.2-src/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook
    (Object: RoleManager)
  File /home/src/Zope-2.3.2-src/lib/python/ZPublisher/Publish.py, line 171, in publish
  File /home/src/dev/../Zope-2.3/lib/python/ZPublisher/mapply.py, line 160, in mapply
    (Object: manage_open_connection)
  File /home/src/Zope-2.3.2-src/lib/python/ZPublisher/Publish.py, line 112, in call_object
    (Object: manage_open_connection)
  File /home/src/Zope-2.3.1-src/lib/python/Shared/DC/ZRDB/Connection.py, line 220, in
manage_open_connection
    (Object: RoleManager)
  File /home/src/Zope-2.3.1-src/lib/python/Shared/DC/ZRDB/Connection.py, line 240, in connect
    (Object: RoleManager)
  File /home/src/test/Products/ZOracleDA/db.py, line 123, in __init__
  File /home/src/test/Products/ZOracleDA/DCOracle/ocidb.py, line 90, in cursor
  File /home/src/test/Products/ZOracleDA/DCOracle/ociCurs.py, line 105, in __init__
BadRequest: (see above)

</PRE>
"""

At first I thought it was some stupid system thing, where the paths
of the .pyc files were somehow encoded in them. So I went and deleted
them all, and restarted, to no avail.

Then I thought that it was the same problem, but with the python extensions.
But it couldn't be: they were not built on this machine at all, and some
files (Python's /lib/config/...) that are required in order to do this are
missing.

I have on the same Zope an installation of DCO2, patched to allow it to coexist
with ZOracleDA. This works flawlessly. And ZOracleDA works flawlessly on the
original, "dev" zope.

Zope 2.3.2
ZOracleDA 2.1 (I think; only indication is the CHANGES.txt file)
DCOracle 1.3.2 (I think)
Oracle 8.0.5 (I don't think this matters)
Red Hat 6.2 

Any ideas?

Thanks,
	Shai.