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

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



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


Please find below the output of the commands -

[t...@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)

[t...@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

ETH Zürich
Michele Marcionelli
IT Support Gruppe D-MATH
HG G 32.1
Rämistrasse 101
CH–8092 Zürich


+41 44 632 6193 Telefon
+41 44 632 1354 Fax
Zope-DB mailing list

Reply via email to