[Zope] ZOracleDA causing instability

2000-11-02 Thread Petru Paler

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

2000-08-16 Thread Chris Beaumont

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

2000-07-27 Thread Riku Voipio

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

2000-07-27 Thread Aaron Bostick

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

2000-07-01 Thread Kiran Jonnalagadda

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

2000-06-27 Thread Michal Bukovjan

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?

2000-06-27 Thread Christian Scholz

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

2000-06-26 Thread Kiran Jonnalagadda

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?

2000-06-06 Thread Satheesh Babu

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

2000-05-30 Thread Michal Bukovjan

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 )