Hello, I've been quietly following the development of Zope and I'm VERY impressed and happy to see such a wonderful tool available as open source. I've been anxiously awaiting the release of DCOracle and the ZOracle database adapter and was overjoyed to see them arrive last week. Unfortunately, I've run into a little snag which I was hoping someone could help me through. I downloaded both DCOracle and the ZOracle DA (then realizing the ZOracle DA has DCOracle in the src directory...) I extracted the ZOracle DA product to the <Zope_Home>/lib/python/Products location and I then compiled the DCOracle piece in the <Zope_Home>/lib/python.Products/ZOracleDA/src directory. I ran the DCOracle_test.py file and got no errors. Having thought all was well I moved the Buffer.so and oci_.so shared libs to the <Zope_Home>/lib/python/Products/DCOracle directory. When I restarted Zope, the product appeared to be installed correctly as it wasn't 'broken' (no tracebacks), but when I tried to create a connection I got this traceback: ------------------------------------------------------------- Invalid connection string: webtools/webtools Traceback (innermost last): File /local/app/dc/Zope/lib/python/ZPublisher/Publish.py, line 879, in publish_module File /local/app/dc/Zope/lib/python/ZPublisher/Publish.py, line 595, in publish (Info: /Development/manage_addZOracleConnection) File lib/python/Products/ZOracleDA/DA.py, line 121, in manage_addZOracleConnection (Object: Navigation) File /local/app/dc/Zope/lib/python/Shared/DC/ZRDB/Connection.py, line 139, in __init__ (Object: RoleManager) File /local/app/dc/Zope/lib/python/Shared/DC/ZRDB/Connection.py, line 168, in edit (Object: RoleManager) File /local/app/dc/Zope/lib/python/Shared/DC/ZRDB/Connection.py, line 212, in connect (Object: RoleManager) File lib/python/Products/ZOracleDA/db.py, line 127, in __init__ File lib/python/Products/ZOracleDA/DCOracle/ocidb.py, line 65, in __init__ BadRequest: (see above) ------------------------------------------------------------- I have Zope being published through PCGI. I have an apache webserver which is running as a user which 'knows' where ORACLE_HOME so the PCGI process should 'know' this too. Did I just miss something obvioius? Any help is greatly appreciated, and once again thanks for a GREAT tool! Dave -- ---------------------------------------------------- David R. White Raytheon Electronic Systems Process Support (508) 440-2087 528 Boston Post Rd. Sudbury, MA 01776 davew@ed.ray.com ----------------------------------------------------
David White wrote:
Hello,
I've been quietly following the development of Zope and I'm VERY impressed and happy to see such a wonderful tool available as open source. I've been anxiously awaiting the release of DCOracle and the ZOracle database adapter and was overjoyed to see them arrive last week. Unfortunately, I've run into a little snag which I was hoping someone could help me through.
I downloaded both DCOracle and the ZOracle DA (then realizing the ZOracle DA has DCOracle in the src directory...) I extracted the ZOracle DA product to the <Zope_Home>/lib/python/Products location and I then compiled the DCOracle piece in the <Zope_Home>/lib/python.Products/ZOracleDA/src directory. I ran the DCOracle_test.py file and got no errors. Having thought all was well I moved the Buffer.so and oci_.so shared libs to the <Zope_Home>/lib/python/Products/DCOracle directory. When I restarted Zope, the product appeared to be installed correctly as it wasn't 'broken' (no tracebacks), but when I tried to create a connection I got this traceback:
-------------------------------------------------------------
Invalid connection string: xxxxxx
Note that I Xed out the connection string. Are you sure this was the correct connection string? Does this connectiuon string work with sqlplus? (snip)
I have Zope being published through PCGI. I have an apache webserver which is running as a user which 'knows' where ORACLE_HOME so the PCGI process should 'know' this too. Did I just miss something obvioius?
If you think that the connection string is correct, you should try setting ORACLE_HOME in the PCGI info file. If you still have problems, try sending mail to support@digicool.com. Jim -- Jim Fulton mailto:jim@digicool.com Technical Director (888) 344-4332 Python Powered! Digital Creations http://www.digicool.com http://www.python.org Under US Code Title 47, Sec.227(b)(1)(C), Sec.227(a)(2)(B) This email address may not be added to any commercial mail list with out my permission. Violation of my privacy with advertising or SPAM will result in a suit for a MINIMUM of $500 damages/incident, $1500 for repeats.
Hi, I am running PostGres 6.2.0 as supplied with RedHat 5.0. In that release there is no function called PQsetdbLogin as used in pgmodule.c in ZpyGreSQLDA/src. A quick fix is to change PQsetdbLogin to PQsetdb and omit the last three arguments (username, password, database). -- Guido
participants (3)
-
David White -
Guido Sohne -
Jim Fulton