Re: [Zope-DB] Zope_Database_issue

2010-11-18 Thread Michele Marcionelli
As I can see you execute the "ldd" command as user "test"; the postgres libraries belongs to the user "postgres" in the respective home... Zope will probably run as another user, for instance "zope". Does all these users have enough rights? Try as user "test" following: ls -l /home/postgre

Re: [Zope-DB] Zope_Database_issue

2010-11-18 Thread Andreas Jung
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 smita kamdar wrote: > > Please do tel me if I can try something else. Are the read permission set correctly? - -aj -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQGUBA

[Zope-DB] Zope_Database_issue

2010-11-18 Thread smita kamdar
Hi, Please find below the output of the commands - [t...@test site-packages]$ ldd /home/test/Python/2.4.4/lib/python2.4/site-packages/psycopgmodule.so linux-gate.so.1 => (0x00e6f000) libpq.so.3 => not found libcrypt.so.1 => /lib/libcrypt.so.1 (0x0045d000) li

Re: [Zope-DB] Zope_Database_issue

2010-11-18 Thread Michele Marcionelli
Hi Smita sorry... can you send me also the "zopectl" file? And if it's possible the output of this command ldd /_psycopg.so" On my system I get following: r...@russell ~# ldd /usr/lib64/python2.6/site-packages/psycopg2/_psycopg.so | grep libpq.so libpq.so.5 => /usr/lib64/libpq.so.

[Zope-DB] Zope_Database_issue

2010-11-18 Thread smita kamdar
HI, Please find attached 2 files: 1) Postgres_lib_list.txt : This file contains the output of ‘ls -l /home/postgres/7.4.13/lib’ 2) ZPsycopgDA_error_log: This file contains the error log when zope is started in debug mode (/bin/zopectl fg) Thanks a lot! I really appreciate t

Re: [Zope-DB] Zope_Database_issue

2010-11-18 Thread Michele Marcionelli
Can you send me the output of "ls -l /home/postgres/7.4.13/lib" and the whole error message that you get? thanx, Michele On Nov 18, 2010, at 14:13 , smita kamdar wrote: > Hi, > > Thanks a lot for your suggesstions!! > > > I included the line: > > > LD_LIBRARY_PATH="/home/postgres/7.4.13

[Zope-DB] Zope_Database_issue

2010-11-18 Thread smita kamdar
Hi, Thanks a lot for your suggesstions!! I included the line: LD_LIBRARY_PATH="/home/postgres/7.4.13/lib" export LD_LIBRARY_PATH with proper case & spacing. Still facing the same error. Somewhere I had read that I need to include the same dir path i.e. (/home/postgres/7.4.13/lib) in

Re: [Zope-DB] Zope_Database_issue

2010-11-18 Thread Michele Marcionelli
Hi Smita ... and pay attention to the spaces. Use this: export LD_LIBRARY_PATH=/home/postgres/7.4.13/lib Maybe you should put this line to your start/stop script (zopectl). Kind regards, Michele On Nov 18, 2010, at 13:21 , Andreas Jung wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1

Re: [Zope-DB] Zope_Database_issue

2010-11-18 Thread Andreas Jung
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 smita kamdar wrote: > LD_Library_path = /home/postgres/7.4.13/lib. But this didnt work. I > still got the same error. check your *spelling* - environment variablea are *case-sensitive*. - -aj -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (Dar

[Zope-DB] Zope_Database_issue

2010-11-18 Thread smita kamdar
Hi, I have installed Postgresql in the path '/home/postgres/7.4.13' & so i set the variable LD_Library_path = /home/postgres/7.4.13/lib. But this didnt work. I still got the same error. At the time of installing psycopg, in the first step of installation i.e. ./configure --prefix...

Re: [Zope-DB] Zope_Database_issue

2010-11-18 Thread Andreas Jung
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Charlie Clark wrote: > BTW. I think that you may well be better off with psycopg2 as the library. ...which is a mandatory requirement for ZPsycopgDA - and as said: SQLAlchemyDA is much easier to install and handle. - -aj -BEGIN PGP SIGNATURE

Re: [Zope-DB] Zope_Database_issue

2010-11-18 Thread Charlie Clark
Am 18.11.10 10:13, schrieb smita kamdar: > But I can see the library �libpq.so.3� in the Postgres lib directory & also > while installing Psycopg I gave the same path of Postgres library. > > Now what else I need to do? Hi Smita, the problem is not with Zope but with the underlying psycopg libra

Re: [Zope-DB] Zope_Database_issue

2010-11-18 Thread Andreas Jung
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Why can't you read short answers carefully? Using the LD_LIBRARY_PATH environment variable is likely the solution for your problem. - -aj smita kamdar wrote: > > > HI, > > > > But I can see the library ‘ libpq.so.3’ in the Postgres lib directo

[Zope-DB] Zope_Database_issue

2010-11-18 Thread smita kamdar
HI, But I can see the library ‘libpq.so.3’ in the Postgres lib directory & also while installing Psycopg I gave the same path of Postgres library. Now what else I need to do? Thanks a lot!! -- Forwarded message -- From: *Andreas Jung* Date: Thu, Nov 18, 2010 at 1:14 PM Su