HI,
While installing Postgresql, I installed it as user postgres & so the entire folder in which it is installed have owner as postgres. Other than Postgresql, all the other installations (i.e. Zope, Python, egenix & psycopg) are done as user test. Zope is also working as user test. I tried to run the below as user test & it gave the following output: [t...@test ~]$ ls -l /home/postgres/7.4.13/lib/libpq.so.3 ls: cannot access /home/postgres/7.4.13/lib/libpq.so.3: Permission denied Do you think I should change any permissions? & I think you are right, in zopectl file, the variable PYTHONPATH is not correct. I have changed the value of that variable to’* */home/test/Python/2.4.4/lib’ Is this path correct? Thanks a lot!! Regards, Smita Kamdar ------------------------------------------------------------------------------------------------------------------------------------------------------------------- *From:* Michele Marcionelli [mailto:michele.marcione...@math.ethz.ch] *Sent:* Thursday, November 18, 2010 11:55 PM *To:* smita kamdar *Cc:* zope-db@zope.org *Subject:* Re: [Zope-DB] Zope_Database_issue 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/postgres/7.4.13/lib/libpq.so.3 Can you see the file? By the way: in the zopectl script you declared the variable PYTHONPATH="/opt/zope/lib/python" and here you speak of /home/test/Python/2.4.4/lib/python2.4/site-packages... are you sure that this variable is correct? Cheers, Michele On Nov 18, 2010, at 18:27 , smita kamdar wrote: 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) libpthread.so.0 => /lib/libpthread.so.0 (0x00110000) libdl.so.2 => /lib/libdl.so.2 (0x00e05000) libutil.so.1 => /lib/libutil.so.1 (0x003fe000) libc.so.6 => /lib/libc.so.6 (0x0073d000) libfreebl3.so => /usr/lib/libfreebl3.so (0x0012a000) /lib/ld-linux.so.2 (0x004af000) [t...@test site-packages]$ ldd /home/test/Python/2.4.4/lib/python2.4/site-packages/psycopgmodule.so | grep libpq.so libpq.so.3 => not found & also please find attached the zopectl file. I also created the symbolic link – ln -s /home/postgres/7.4.13/lib/libpq.so.3 /usr/lib/libpq.so.3 Please do tel me if I can try something else. Thanks a lot!! <zopectl.txt>_______________________________________________ Zope-DB mailing list Zope-DB@zope.org https://mail.zope.org/mailman/listinfo/zope-db -- ETH Zürich Michele Marcionelli IT Support Gruppe D-MATH HG G 32.1 Rämistrasse 101 CH–8092 Zürich michele.marcione...@math.ethz.ch http://www.math.ethz.ch/~michele +41 44 632 6193 Telefon +41 44 632 1354 Fax
_______________________________________________ Zope-DB mailing list Zope-DB@zope.org https://mail.zope.org/mailman/listinfo/zope-db
