[Zope] ZOracleDA causing instability
Hi, Just wondering if anyone else sees this: I run a moderately high-traffic (a couple hundred thousand hits/day) with Zope and Oracle (most of the site is forms interacting with the Oracle database, the rest being help/support files for those forms and a couple images). Products used: - FSSession-0-4-2 - GenericUserFolder 1-2-4 - PythonMethod-0-1-7 - SiteAccess-2-0-0b3 - the latest ZOracleDA (the __version__ string in __init__.py says: "$Revision: 1.4 $") Zope 2.2.2 (source release) run with RewriteRule proxying behind apache 1.3.14. Oracle 8.1.6 (aka 8i release 2) installed on the same machine. The problem is that the whole thing is very unstable, and I suspect ZOracleDA to be the culprit. Sometimes the whole Zope just hangs (actually so often, that we are restarting it from cron each 15 minutes, but it's a bad solution since all the GUF cookies are lost and customers are logged out), other times it goes mad and eats lots of memory (I've seen it consuming 800 megs of memory, and the whole unpacked Data.fs is 9 megs!), other times it gives a very strange error: ZSQL methods raise exceptions whose contents is queries ran in other threads!. Does anyone have any ideea of what is happening, and how to fix it ? -- Petru Paler, mailto:[EMAIL PROTECTED] http://www.ppetru.net - ICQ: 41817235 ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] ZOracleDA problem
Hello, Ive successfully compiled the DCOracle package and then moved the compiled modules to the DCOracle directory of ZOracleDA, and now the DA shows up as non-broken in my Zope installation.. However, when I try to add a ZOracleDA connection object to my Zope website, I get a "this document contained no data" page... back.. it wont work. DCOracle passed the connection test so I know it isnt that.. Does anyone have any idea what I might be doing wrong? I'm using Zope 2.16 Thank you ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] ZOracleDA
On Wed, Jul 26, 2000 at 06:28:55PM -0400, Satheesh Babu wrote: Hi, If you are running Zope on 1. Linux: You need to install Oracle client libraries to compile ZOracleDA. As far as I know, Oracle does not give any easy way to install only the clients. So, if you've enough disk space, install Oracle with the minimum DB options, and compile ZOracleDA. You DON'T NEED to run Oracle DB on your Zope machine, to have zope connect to your actual DB machine. I think that 8.1.5i had an option to install client. stuff (beacuse that is what i did at first). However, you need to compile the ZOracleDA on a machine where the entire oracle is installed, because some crucial haeder files only come with the full install. Then, just remember to set up the tns listener on server and the tnsnames.ora on the client, but that stuff is out of this list's scope. -- Riku Voipio [EMAIL PROTECTED] 09-862 60764 ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
RE: [Zope] ZOracleDA
Thanks for the reply... I was planning to install Zope on the database server, compile DCOracle there, and then just copy the *.so files to the webservers, where the real Zope install is. Do you need the oracle client libraries on the webservers to make the connection or are the two shared libraries that you compile, (oci_.so and Buffer.so) enough to make the connection to the web server? Thanks for your help, Aaron Bostick Network Architect Exodus Professional Services -Original Message- From: Satheesh Babu [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 26, 2000 3:29 PM To: Aaron Bostick; [EMAIL PROTECTED] Subject: Re: [Zope] ZOracleDA Hi, If you are running Zope on 1. Linux: You need to install Oracle client libraries to compile ZOracleDA. As far as I know, Oracle does not give any easy way to install only the clients. So, if you've enough disk space, install Oracle with the minimum DB options, and compile ZOracleDA. You DON'T NEED to run Oracle DB on your Zope machine, to have zope connect to your actual DB machine. 2. Win NT/2000/98 You can install only the client libraries from the Oracle CD, get ZOracleDA compiled and run Zope. I've used it both ways. Somewhere on the net there was a tarred version of client-only-oracle-4-linux. Check freshmeat.net and gnome.org for some GTK apps for accessing Oracle. It was there in the homepage for that suite of apps. - Original Message - From: Aaron Bostick [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 26, 2000 4:45 PM Subject: [Zope] ZOracleDA Zope list members, I have been developing a zope site with oracle on linux as a backend. Currently, I run both zope and oracle on the same machine using the ZOracleDA for connectivity. However, for production, I plan to seperate the tiers and run zope and and oracle on different servers. From looking at the build instructions for the DCOracle, it seems as though it will only work when the web server and database server are on the same filesystem/in the same memory space. Is there a way to have my zope server talk to a remote (across the network somewhere) database server? Do I have to move to something like ODBC for this? Thanks for your help! Aaron Bostick Network Architect Exodus Professional Services ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] ZOracleDA
Michal Bukovjan wrote: Avoid using Oracle 8.1.5 at all costs. It has mislinked executables and libraries, I can't believe Oracle could have released such a shit. Instead, download and try Oracle 8.1.6 R2 - the current release. It fixes a number of issues (though not all of them) and at least it works. I've downloaded Oracle 8.1.6, but the 8.1.5 setup file doesn't work anymore. Does anyone have the 8.1.6 setup file? I'm not sure how to make it myself. -- Kiran Jonnalagadda http://lunateks.com baby.sh: while true; do echo "^G^G^G^G^G"; sed -e 's/food/poop/'; sync; sync; sleep 15; done ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] ZOracleDA
Avoid using Oracle 8.1.5 at all costs. It has mislinked executables and libraries, I can't believe Oracle could have released such a shit. Instead, download and try Oracle 8.1.6 R2 - the current release. It fixes a number of issues (though not all of them) and at least it works. Michal Bukovjan Citace Kiran Jonnalagadda [EMAIL PROTECTED]: Hi, I'm trying to install ZOracleDA. I've managed to get DCOracle to build, but the test fails with this traceback: - [root@balrog src]# python DCOracle_test.py Traceback (innermost last): File "DCOracle_test.py", line 1, in ? import Buffer, oci_, sys ImportError: /u01/app/oracle/product/8.1.5/lib/libordvir8.so: undefined symbol: __pure_virtual - I'm running Zope 2.1.6 with Python 1.5.2 on Linux. DCOracle and ZOracleDA are both the stab;e releases. Oracle is 8.1.5 (needed the Setup file from this list). I added -lordvir8 a couple of times extra to Setup to see if this problem went away, but it wouldn't. nm on libordvir8.so says that it contains the __pure_virtual symbol. Does anyone know how to get around this? -- Kiran Jonnalagadda http://lunateks.com baby.sh: while true; do echo "^G^G^G^G^G"; sed -e 's/food/poop/'; sync; sync; sleep 15; done ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] ZOracleDA and Zope 2.2?
Hi! I am encountering the following problem when using ZOracleDA 2.2.0b1 and Zope 2.2b2/3: When creating a ZOracle Connection and giving the wrong connection string then whole Zopes crashs with OCI_ERROR at oci_8.c:283 ORA-12541: TNS:no listener OCI_ERROR at oci_8.c:283 ORA-12154: TNS:could not resolve service name (this is just a test with no Oracle running). Sometimes it automatically restarts but sometimes not (after the second try). I cannot remember to have this seen in 2.1, so a new bug? (When you give the right string everything is ok) regards, Christian -- COM.lounge http://comlounge.net/ communication design [EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] ZOracleDA
Hi, I'm trying to install ZOracleDA. I've managed to get DCOracle to build, but the test fails with this traceback: - [root@balrog src]# python DCOracle_test.py Traceback (innermost last): File "DCOracle_test.py", line 1, in ? import Buffer, oci_, sys ImportError: /u01/app/oracle/product/8.1.5/lib/libordvir8.so: undefined symbol: __pure_virtual - I'm running Zope 2.1.6 with Python 1.5.2 on Linux. DCOracle and ZOracleDA are both the stab;e releases. Oracle is 8.1.5 (needed the Setup file from this list). I added -lordvir8 a couple of times extra to Setup to see if this problem went away, but it wouldn't. nm on libordvir8.so says that it contains the __pure_virtual symbol. Does anyone know how to get around this? -- Kiran Jonnalagadda http://lunateks.com baby.sh: while true; do echo "^G^G^G^G^G"; sed -e 's/food/poop/'; sync; sync; sleep 15; done ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] ZOracleDA binary for NT?
Hi folks, I've been trying to access a Oracle DB with ODBC driver from NT4 running Zope 2.1.6. Lot of problems and now I'm stumped in that this driver does not seem to support LONG data types. ZOracleDA on Linux works beautifully, but I'm required to build the site on NT (sigh). So, any one out there has a precompiled ZOracleDA for NT, which he/she doesn't mind sharing with me? Or, any hints on using LONG datatypes with ZODBC driver? Thanks in advance. ~ V.Satheesh Babu [EMAIL PROTECTED](Xt: 5348) . . http://vsbabu.csoft.net /V\ - Duct tape is like the force. It has // \\ a light side, and a dark side, and /( )\ it holds the universe together ... ^'~'^ ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] ZOracleDA woes - cannot connect
Please help!!! I am trying to connect to Oracle server. Running Zope 2.1.4, ZServer alone (for now), Debian frozen(potato). I have stable ZOracleDA 2.1.0. After a lot of work, I succeeded to compile the DCOracle package, and I am able to connect with the Python script DCOracle_test.py, which is included. I am only able to connect when I am a user 'oracle'. But when I try to connect from Zope, the connection never happens,and Zope returns "Document contained no data. Contact your network administrator". Sometimes, Zope dies. I am really desperate by now, as I try to make connection for three days now. I searched all FAQs on Zope site, nothing found. Any idea what I am doing wrong? Thanks, Michal Bukovjan ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )