[Zope-DB] Zope_Database_issue

[smita kamdar]

 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:



[test at 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.marcionelli at math.ethz.ch]
*Sent:* Thursday, November 18, 2010 11:55 PM
*To:* smita kamdar
*Cc:* zope-db at 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 -



[test at 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)



[test at 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 at 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.marcionelli at math.ethz.ch
http://www.math.ethz.ch/~michele

+41 44 632 6193 Telefon
+41 44 632 1354 Fax
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zope-db/attachments/20101119/5c786bbb/attachment-0001.html