[Zope-DB] Zope_Database_issue

smita kamdar smita.kamdar00 at gmail.com
Fri Nov 19 04:34:33 EST 2010


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

I have changed the value of that variable to’* */home/test/Python/2.4.4/lib’
Is this path correct?

Thanks a lot!!


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?



On Nov 18, 2010, at 18:27 , smita kamdar wrote:


Please find below the output of the commands -

[test at test site-packages]$ ldd

        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.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!!

Zope-DB mailing list
Zope-DB at zope.org

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

+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 

More information about the Zope-DB mailing list