Re: [Zope] DCOracle2/ZOracleDA - Unable to create a connection
I think I might see the problem, on my installation I moved the entire DCOracle2 directory to /lib/python/Products, in fact I think I compilied it in there, but that shouldn't matter. Try and remove the DCOracle2 directory from lib/python/Products and move the whole enchilata from tmp and restart your zope. I don't think there is anything specific that needs to have python 2.1 but I'm not 100% on that. If it doesn't work try to recompile it again and repeat the steps above. here is the ls-l from my DCOracle2 in /lib/python/Products total 176 drwxr-xr-x 2 root root 4096 Dec 31 1969 binaries -rw-r--r-- 1 root root 9784 Nov 5 08:17 CHANGELOG -rwxr-xr-x 1 root root 10126 Oct 24 14:41 DABase.py -rw-r--r-- 1 root root 11048 Dec 16 09:51 DABase.pyc -rw-r--r-- 1 root root 7005 Aug 10 10:14 DA.py -rw-r--r-- 1 root root 4983 Dec 16 09:51 DA.pyc -rw-r--r-- 1 root root 9454 Nov 5 08:15 db.py -rw-r--r-- 1 root root 7499 Dec 16 09:51 db.pyc drwxr-xr-x 2 root root 4096 Dec 16 09:51 DCOracle2 drwxr-xr-x 3 root root 4096 Dec 31 1969 DCOracleStorage drwxr-xr-x 2 root root 4096 Dec 31 1969 doc drwxr-xr-x 2 root root 4096 Dec 16 09:56 dtml drwxr-xr-x 2 root root 4096 Dec 31 1969 icons -rw-r--r-- 1 root root 4113 Aug 10 10:14 __init__.py -rw-r--r-- 1 root root 671 Dec 16 09:51 __init__.pyc -rw-r--r-- 1 root root 819 Aug 7 20:28 INSTALL -rwxr-xr-x 1 root root 5011 Aug 8 05:15 install.py -rw-r--r-- 1 root root 1598 Jul 24 2000 LICENSE.txt -rw-r--r-- 1 root root 885 Aug 27 12:12 Makefile -rw-r--r-- 1 root root 1688 Aug 7 20:36 MANIFEST drwxr-xr-x 2 root root 4096 Dec 31 1969 proof -rw-r--r-- 1 root root 4480 Mar 26 2001 README -rw-r--r-- 1 root root 1892 Mar 26 2001 setup.py -rw-r--r-- 1 root root 7187 Oct 9 11:05 SP.py -rw-r--r-- 1 root root 5268 Dec 16 09:51 SP.pyc drwxr-xr-x 3 root root 4096 Dec 16 09:50 src drwxr-xr-x 2 root root 4096 Dec 31 1969 test drwxr-xr-x 2 root root 4096 Dec 31 1969 tests Let me know if that helps. Todd ----- Original Message -----
From: Zachery Bir <zbir@urbanape.com> To: Todd Graham <tgraham@speakeasy.net> Sent: Thursday, December 20, 2001 5:45 AM Subject: Re: [Zope] DCOracle2/ZOracleDA - Unable to create a connection
On Wednesday, December 19, 2001, at 08:51 , Todd Graham wrote:
Hi Zachery,
That is very strange, what OS are you running, version of python etc? How did you go about installing the product? From /lib/python/Products you should have a folder called DCOracle2, what are the contents of that folder?
Redhat Linux 6.2, running 2.2.17-33.beosmp kernel
Python 1.5.2
This is the binary Zope 2.3.2 installation ( Zope-2.3.2-linux2.tar.gz )
[root@www /root]# ls -l /usr/local/zope/2-3-2/lib/python/Products/DCOracle2/ total 288 -rw-r--r-- 1 root root 51179 Oct 25 14:46 DCOracle2.py -rw-r--r-- 1 root root 42565 Dec 18 15:15 DCOracle2.pyc -rw-r--r-- 1 root root 1725 Jan 24 2001 __init__.py -rw-r--r-- 1 root root 114 Dec 18 15:15 __init__.pyc -rwxr-xr-x 1 root root 179549 Dec 18 15:23 dco2.so
I've got the rest of the DCOracle2 package that I downloaded in /tmp:
[root@www /root]# ls -l /tmp/DCOracle2/ total 78 -rw-r--r-- 1 root root 9784 Nov 5 11:17 CHANGELOG -rw-r--r-- 1 root root 7005 Aug 10 13:14 DA.py -rwxr-xr-x 1 root root 10126 Oct 24 17:41 DABase.py drwxr-xr-x 2 root root 1024 Dec 18 15:26 DCOracle2 drwxr-xr-x 3 root root 1024 Dec 31 1969 DCOracleStorage -rw-r--r-- 1 root root 819 Aug 7 23:28 INSTALL -rw-r--r-- 1 root root 1598 Jul 24 2000 LICENSE.txt -rw-r--r-- 1 root root 1688 Aug 7 23:36 MANIFEST -rw-r--r-- 1 root root 885 Aug 27 15:12 Makefile -rw-r--r-- 1 root root 4480 Mar 26 2001 README -rw-r--r-- 1 root root 7187 Oct 9 14:05 SP.py -rw-r--r-- 1 root root 4113 Aug 10 13:14 __init__.py drwxr-xr-x 2 root root 1024 Dec 31 1969 binaries -rw-r--r-- 1 root root 9454 Nov 5 11:15 db.py drwxr-xr-x 2 root root 1024 Dec 31 1969 doc drwxr-xr-x 2 root root 1024 Dec 31 1969 dtml drwxr-xr-x 2 root root 1024 Dec 31 1969 icons -rwxr-xr-x 1 root root 5011 Aug 8 08:15 install.py drwxr-xr-x 2 root root 1024 Dec 31 1969 proof -rw-r--r-- 1 root root 1892 Mar 26 2001 setup.py drwxr-xr-x 3 root root 1024 Dec 18 15:26 src drwxr-xr-x 2 root root 1024 Dec 31 1969 test drwxr-xr-x 2 root root 1024 Dec 31 1969 tests
I was under the impression that I only needed to copy the DCOracle2 folder inside that to lib/python/Products/ in my Zope home.
Thanks for everything.
Zachery Bir <zbir@urbanape.com> <URL:http://www.urbanape.com/>
On Thursday, December 20, 2001, at 10:19 , Todd Graham wrote:
I think I might see the problem, on my installation I moved the entire DCOracle2 directory to /lib/python/Products, in fact I think I compilied it in there, but that shouldn't matter. Try and remove the DCOracle2 directory from lib/python/Products and move the whole enchilata from tmp and restart your zope. I don't think there is anything specific that needs to have python 2.1 but I'm not 100% on that. If it doesn't work try to recompile it again and repeat the steps above.
That works great! I don't know where I got sidetracked into only using the nested DCOracle2 folder, but no real harm done. Thanks for the help. Zachery Bir <zbir@urbanape.com> <URL:http://www.urbanape.com/>
Glad to help Zachary, I'm still using DCOracle in production and am testing the DCOracle2 let me know if you see any strange behavior with it. I have seen the adapter put a trailing character on some of my primary keys. Like if I have a sequence called my_id a the primary key and it's a numeric field I will sometimes get back 10002.0 in zope rather than 10002. Like I said I'm still testing it but it does seem to have some very cool features like debug and a separate object for Oracle Stored Procedures. Take it easy, Todd ----- Original Message ----- From: Zachery Bir <zbir@urbanape.com> To: Todd Graham <tgraham@speakeasy.net> Cc: <zope@zope.org> Sent: Thursday, December 20, 2001 7:17 AM Subject: Re: [Zope] DCOracle2/ZOracleDA - Unable to create a connection
On Thursday, December 20, 2001, at 10:19 , Todd Graham wrote:
I think I might see the problem, on my installation I moved the entire DCOracle2 directory to /lib/python/Products, in fact I think I compilied it in there, but that shouldn't matter. Try and remove the DCOracle2 directory from lib/python/Products and move the whole enchilata from tmp and restart your zope. I don't think there is anything specific that needs to have python 2.1 but I'm not 100% on that. If it doesn't work try to recompile it again and repeat the steps above.
That works great! I don't know where I got sidetracked into only using the nested DCOracle2 folder, but no real harm done.
Thanks for the help.
Zachery Bir <zbir@urbanape.com> <URL:http://www.urbanape.com/>
participants (2)
-
Todd Graham -
Zachery Bir