Re: Zope_Database_issue
Michele Marcionelli <[email protected]> Thu, 18 Nov 2010 19:25:05 +0100
| Newsgroups | gmane.comp.web.zope.database |
|---|---|
| Message-ID | <[email protected]> |
--===============0412631773295688346==
Content-Type: multipart/alternative; boundary="Apple-Mail-4-412376418"
--Apple-Mail-4-412376418
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset="windows-1252"
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=3D"/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,
>=20
> Please find below the output of the commands -
>=20
> =20
> [test@test site-packages]$ ldd =
/home/test/Python/2.4.4/lib/python2.4/site-packages/psycopgmodule.so
>=20
> linux-gate.so.1 =3D> (0x00e6f000)
>=20
> libpq.so.3 =3D> not found
>=20
> libcrypt.so.1 =3D> /lib/libcrypt.so.1 (0x0045d000)
>=20
> libpthread.so.0 =3D> /lib/libpthread.so.0 (0x00110000)
>=20
> libdl.so.2 =3D> /lib/libdl.so.2 (0x00e05000)
>=20
> libutil.so.1 =3D> /lib/libutil.so.1 (0x003fe000)
>=20
> libc.so.6 =3D> /lib/libc.so.6 (0x0073d000)
>=20
> libfreebl3.so =3D> /usr/lib/libfreebl3.so (0x0012a000)
>=20
> /lib/ld-linux.so.2 (0x004af000)
>=20
> =20
> [test@test site-packages]$ ldd =
/home/test/Python/2.4.4/lib/python2.4/site-packages/psycopgmodule.so | =
grep libpq.so
>=20
> libpq.so.3 =3D> not found
>=20
> =20
> & also please find attached the zopectl file.
>=20
> =20
> I also created the symbolic link =96
>=20
> =20
> ln -s /home/postgres/7.4.13/lib/libpq.so.3 /usr/lib/libpq.so.3
>=20
> =20
> Please do tel me if I can try something else.
>=20
> =20
> Thanks a lot!!
>=20
> =20
>=20
> <zopectl.txt>_______________________________________________
> Zope-DB mailing list
> [email protected]
> https://mail.zope.org/mailman/listinfo/zope-db
--=20
ETH Z=FCrich
Michele Marcionelli
IT Support Gruppe D-MATH
HG G 32.1
R=E4mistrasse 101
CH=968092 Z=FCrich
[email protected]
http://www.math.ethz.ch/~michele
+41 44 632 6193 Telefon
+41 44 632 1354 Fax
--Apple-Mail-4-412376418
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="windows-1252"
<html><head></head><body style=3D"word-wrap: break-word; =
-webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">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?<div><br></div><div>Try as user "test" =
following:</div><div><br></div><div><font class=3D"Apple-style-span" =
face=3D"Courier"> ls =
-l /home/postgres/7.4.13/lib/libpq.so.3<br></font><div><br></div><div=
>Can you see the file?</div><div><br></div><div>By the way: in the <font =
class=3D"Apple-style-span" face=3D"Courier">zopectl</font> script you =
declared the variable <span class=3D"Apple-style-span" =
style=3D"font-family: Courier; =
">PYTHONPATH=3D"/opt/zope/lib/python" </span>and here you speak =
of <font class=3D"Apple-style-span" =
face=3D"Courier">/home/test/Python/2.4.4/lib/python2.4/site-packages</font=
>... are you sure that this variable is =
correct?</div><div><br></div><div>Cheers,</div><div>Michele</div><div><br>=
</div><div><br></div><div><div><div>On Nov 18, 2010, at 18:27 , smita =
kamdar wrote:</div><br class=3D"Apple-interchange-newline"><blockquote =
type=3D"cite"><meta http-equiv=3D"Content-Type" content=3D"text/html; =
charset=3DWindows-1252"><div class=3D"gmail_quote">
<div lang=3D"EN-US" vlink=3D"purple" link=3D"blue">
<div><p class=3D"MsoNormal"><font face=3D"Times New Roman" =
color=3D"maroon" size=3D"3"><span style=3D"FONT-SIZE: 12pt; COLOR: =
maroon">Hi,</span></font></p><p class=3D"MsoNormal"><font face=3D"Times =
New Roman" color=3D"maroon" size=3D"3"><span style=3D"FONT-SIZE: 12pt; =
COLOR: maroon">Please find below the output of the commands - =
</span></font></p><div><font face=3D"Times New Roman" color=3D"maroon" =
size=3D"3"><span style=3D"FONT-SIZE: 12pt; COLOR: =
maroon"> </span></font><br =
class=3D"webkit-block-placeholder"></div><p class=3D"MsoNormal"><font =
face=3D"Times New Roman" color=3D"maroon" size=3D"3"><span =
style=3D"FONT-SIZE: 12pt; COLOR: maroon">[test@test site-packages]$ ldd =
/home/test/Python/2.4.4/lib/python2.4/site-packages/psycopgmodule.so</span=
></font></p><p class=3D"MsoNormal"><font face=3D"Times New Roman" =
color=3D"maroon" size=3D"3"><span style=3D"FONT-SIZE: 12pt; COLOR: =
maroon"> linux-gate.so.1 =
=3D> (0x00e6f000)</span></font></p><p class=3D"MsoNormal"><font =
face=3D"Times New Roman" color=3D"maroon" size=3D"3"><span =
style=3D"FONT-SIZE: 12pt; COLOR: =
maroon"> libpq.so.3 =3D> =
not found</span></font></p><p class=3D"MsoNormal"><font face=3D"Times =
New Roman" color=3D"maroon" size=3D"3"><span style=3D"FONT-SIZE: 12pt; =
COLOR: maroon"> libcrypt.so.1 =
=3D> /lib/libcrypt.so.1 (0x0045d000)</span></font></p><p =
class=3D"MsoNormal"><font face=3D"Times New Roman" color=3D"maroon" =
size=3D"3"><span style=3D"FONT-SIZE: 12pt; COLOR: =
maroon"> libpthread.so.0 =3D>=
/lib/libpthread.so.0 (0x00110000)</span></font></p><p =
class=3D"MsoNormal"><font face=3D"Times New Roman" color=3D"maroon" =
size=3D"3"><span style=3D"FONT-SIZE: 12pt; COLOR: =
maroon"> libdl.so.2 =3D> =
/lib/libdl.so.2 (0x00e05000)</span></font></p><p class=3D"MsoNormal"><font=
face=3D"Times New Roman" color=3D"maroon" size=3D"3"><span =
style=3D"FONT-SIZE: 12pt; COLOR: =
maroon"> libutil.so.1 =3D> =
/lib/libutil.so.1 (0x003fe000)</span></font></p><p =
class=3D"MsoNormal"><font face=3D"Times New Roman" color=3D"maroon" =
size=3D"3"><span style=3D"FONT-SIZE: 12pt; COLOR: =
maroon"> libc.so.6 =3D> =
/lib/libc.so.6 (0x0073d000)</span></font></p><p class=3D"MsoNormal"><font =
face=3D"Times New Roman" color=3D"maroon" size=3D"3"><span =
style=3D"FONT-SIZE: 12pt; COLOR: =
maroon"> libfreebl3.so =3D> =
/usr/lib/libfreebl3.so (0x0012a000)</span></font></p><p =
class=3D"MsoNormal"><font face=3D"Times New Roman" color=3D"maroon" =
size=3D"3"><span style=3D"FONT-SIZE: 12pt; COLOR: =
maroon"> /lib/ld-linux.so.2 =
(0x004af000)</span></font></p><div><font face=3D"Times New Roman" =
color=3D"maroon" size=3D"3"><span style=3D"FONT-SIZE: 12pt; COLOR: =
maroon"> </span></font><br =
class=3D"webkit-block-placeholder"></div><p class=3D"MsoNormal"><font =
face=3D"Times New Roman" color=3D"maroon" size=3D"3"><span =
style=3D"FONT-SIZE: 12pt; COLOR: maroon">[test@test site-packages]$ ldd =
/home/test/Python/2.4.4/lib/python2.4/site-packages/psycopgmodule.so | =
grep libpq.so</span></font></p><p class=3D"MsoNormal"><font face=3D"Times =
New Roman" color=3D"maroon" size=3D"3"><span style=3D"FONT-SIZE: 12pt; =
COLOR: maroon"> libpq.so.3 =
=3D> not found</span></font></p><div><font face=3D"Times New Roman" =
color=3D"maroon" size=3D"3"><span style=3D"FONT-SIZE: 12pt; COLOR: =
maroon"> </span></font><br =
class=3D"webkit-block-placeholder"></div><p class=3D"MsoNormal"><font =
face=3D"Times New Roman" color=3D"maroon" size=3D"3"><span =
style=3D"FONT-SIZE: 12pt; COLOR: maroon">& also please find attached =
the zopectl file. </span></font></p><div><font face=3D"Times New Roman" =
color=3D"maroon" size=3D"3"><span style=3D"FONT-SIZE: 12pt; COLOR: =
maroon"> </span></font><br =
class=3D"webkit-block-placeholder"></div><p class=3D"MsoNormal"><font =
face=3D"Times New Roman" color=3D"maroon" size=3D"3"><span =
style=3D"FONT-SIZE: 12pt; COLOR: maroon">I also created the symbolic =
link =96</span></font></p><div><font face=3D"Times New Roman" =
color=3D"maroon" size=3D"3"><span style=3D"FONT-SIZE: 12pt; COLOR: =
maroon"> </span></font><br =
class=3D"webkit-block-placeholder"></div><p class=3D"MsoNormal"><font =
face=3D"Times New Roman" color=3D"#993300" size=3D"3"><span =
style=3D"FONT-SIZE: 12pt; COLOR: #993300">ln -s =
/home/postgres/7.4.13/lib/libpq.so.3 =
/usr/lib/libpq.so.3</span></font></p><div><font face=3D"Times New Roman" =
color=3D"#993300" size=3D"3"><span style=3D"FONT-SIZE: 12pt; COLOR: =
#993300"> </span></font><br =
class=3D"webkit-block-placeholder"></div><p class=3D"MsoNormal"><font =
face=3D"Times New Roman" color=3D"#993300" size=3D"3"><span =
style=3D"FONT-SIZE: 12pt; COLOR: #993300">Please do tel me if I can try =
something else.</span></font></p><div><font face=3D"Times New Roman" =
color=3D"#993300" size=3D"3"><span style=3D"FONT-SIZE: 12pt; COLOR: =
#993300"> </span></font><br =
class=3D"webkit-block-placeholder"></div><p class=3D"MsoNormal"><font =
face=3D"Times New Roman" color=3D"#993300" size=3D"3"><span =
style=3D"FONT-SIZE: 12pt; COLOR: #993300">Thanks a =
lot!!</span></font></p></div></div>
<table>
<tbody>
<tr>
<td bgcolor=3D"#ffffff"><font =
color=3D"#000000"><pre> </pre></font></td></tr></tbody></table></div>=
<br>
=
<span><zopectl.txt></span>__________________________________________=
_____<br>Zope-DB mailing list<br><a =
href=3D"mailto:[email protected]">[email protected]</a><br>https://mail.zope=
.org/mailman/listinfo/zope-db<br></blockquote></div><br><div>
-- <br>ETH Z=FCrich<br>Michele Marcionelli<br>IT Support Gruppe =
D-MATH<br>HG G 32.1<br>R=E4mistrasse 101<br>CH=968092 Z=FCrich<br><br><a =
href=3D"mailto:[email protected]">michele.marcionelli@math.=
ethz.ch</a><br>http://www.math.ethz.ch/~michele<br><br>+41 44 632 6193 =
Telefon<br>+41 44 632 1354 Fax
</div>
<br></div></div></body></html>=
--Apple-Mail-4-412376418--
--===============0412631773295688346==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
_______________________________________________
Zope-DB mailing list
[email protected]
https://mail.zope.org/mailman/listinfo/zope-db
--===============0412631773295688346==--