Hi Smita you should probably install the postgres libraries as user "test"... just to simplify your life ;-) Otherwise you can try changing the permissions so that user "test" can access the "libpg.so.3". Try following (as user "root"):
chmod 755 /home/postgres chmod 755 /home/postgres/7.4.13 chmod 755 /home/postgres/7.4.13/lib chmod 644 /home/postgres/7.4.13/lib/libpq.so.3 Then following should work: su - test ls -l /home/postgres/7.4.13/lib/libpq.so.3 export LD_LIBRARY_PATH=/home/postgres/7.4.13/lib ldd /home/test/Python/2.4.4/lib/python2.4/site-packages/psycopgmodule.so | grep libpq.so If this works, try starting zope again. About the "PYTHONPATH" variable I'm not sure. Andreas? Cheers, Michele On Nov 19, 2010, at 10:34 , smita kamdar wrote: > 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 -- 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