Re: [Zope] Re: Zope + Oracle + Cron

2007-02-04 Thread Bryan Simmons

I always add my LD_LIBRARY_PATH variable to the zopectl and runzope
scripts so that this kind of thing never happens.

I have also found that I needed to add ORACLE_HOME to either the
zope.conf or zope start scripts when using DCOracle or some other
add-on that uses loadable libs.

In fact, you should put all important env vars in zope.conf under the
environment variables section.  This is the cleanest way to ensure
zope can see everything it needs to.

On 6/9/06, Tres Seaver [EMAIL PROTECTED] wrote:

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

David VanKirk wrote:
 We have zope installation that uses an Oracle backend to store data
 on.  We also have the system setup to do a backup of the database and
 Zope Installation everyday.  Everything runs smoothly until it comes
 time to start Zope back up.

 For some reason whenever the script tries to start Zope back up, it
 comes up but with a broken ZOracleDA product.  It complains about not
 being able to find the library file called libclntsh.so.9.0.

 If I try to start Zope myself from command line right after the script
 is done running (actually stop it then start it again) it works and
 connects to Oracle fine.

 I've tried using nice to up the priority level but it doesn't seem
 to work.  I also thought that maybe I wasn't giving oracle enough time
 to start up so I've tried adding sleep commands to the script, again,
 with no luck.

 If anyone has any experience in this field or has any suggestions,
 please let me know.  This is a quite annoying situation, as this
 server is quite important to the company and downtime is a bad thing.

Most likely 'libclntsh.so' is on an LD_LIBRARY_PATH for your user, which
the cron user does not have.

Why are you stopping Zope, BTW?  The standard backup script for the ZODB
filestorage is 'repozo.py', which does not need to have exclusive access
in order to create a backup.


Tres.
- --
===
Tres Seaver  +1 202-558-7113  [EMAIL PROTECTED]
Palladion Software   Excellence by Designhttp://palladion.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2.2 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFEidhW+gerLs4ltQ4RAhTsAKCLIlvVdjPhOJ2axPmMl9T2Ao54aACgwi2z
5baWO7v3IILAmDo/bmp55gQ=
=YDdz
-END PGP SIGNATURE-

___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists -
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )




--
Regards,

Bryan Simmons

 All parts should go together without forcing. You must remember
that the parts you are reassembling were disassembled by you.
Therefore, if you can't get them together again, there must be a
reason. By all means, do not use a hammer.
 -- IBM maintenance manual, 1925
___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
http://mail.zope.org/mailman/listinfo/zope-announce

http://mail.zope.org/mailman/listinfo/zope-dev )


[Zope] Re: Zope + Oracle + Cron

2006-06-09 Thread Tres Seaver
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

David VanKirk wrote:
 We have zope installation that uses an Oracle backend to store data
 on.  We also have the system setup to do a backup of the database and
 Zope Installation everyday.  Everything runs smoothly until it comes
 time to start Zope back up.
 
 For some reason whenever the script tries to start Zope back up, it
 comes up but with a broken ZOracleDA product.  It complains about not
 being able to find the library file called libclntsh.so.9.0.
 
 If I try to start Zope myself from command line right after the script
 is done running (actually stop it then start it again) it works and
 connects to Oracle fine.
 
 I've tried using nice to up the priority level but it doesn't seem
 to work.  I also thought that maybe I wasn't giving oracle enough time
 to start up so I've tried adding sleep commands to the script, again,
 with no luck.
 
 If anyone has any experience in this field or has any suggestions,
 please let me know.  This is a quite annoying situation, as this
 server is quite important to the company and downtime is a bad thing.

Most likely 'libclntsh.so' is on an LD_LIBRARY_PATH for your user, which
the cron user does not have.

Why are you stopping Zope, BTW?  The standard backup script for the ZODB
filestorage is 'repozo.py', which does not need to have exclusive access
in order to create a backup.


Tres.
- --
===
Tres Seaver  +1 202-558-7113  [EMAIL PROTECTED]
Palladion Software   Excellence by Designhttp://palladion.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2.2 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFEidhW+gerLs4ltQ4RAhTsAKCLIlvVdjPhOJ2axPmMl9T2Ao54aACgwi2z
5baWO7v3IILAmDo/bmp55gQ=
=YDdz
-END PGP SIGNATURE-

___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )