[Zope-DB] Zope_Database_issue

[Michele Marcionelli]

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:
> 
>  
> [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
> 
>  
> _______________________________________________
> 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/a0b7f31b/attachment.html