<html><head></head><body style="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="Apple-style-span" face="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="Apple-style-span" face="Courier">zopectl</font> script you declared the variable <span class="Apple-style-span" style="font-family: Courier; ">PYTHONPATH="/opt/zope/lib/python" </span>and here you speak of <font class="Apple-style-span" face="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="Apple-interchange-newline"><blockquote type="cite"><meta http-equiv="Content-Type" content="text/html; charset=Windows-1252"><div class="gmail_quote">
<div lang="EN-US" vlink="purple" link="blue">
<div><p class="MsoNormal"><font face="Times New Roman" color="maroon" size="3"><span style="FONT-SIZE: 12pt; COLOR: maroon">Hi,</span></font></p><p class="MsoNormal"><font face="Times New Roman" color="maroon" size="3"><span style="FONT-SIZE: 12pt; COLOR: maroon">Please find below the output of the commands - </span></font></p><div><font face="Times New Roman" color="maroon" size="3"><span style="FONT-SIZE: 12pt; COLOR: maroon"> </span></font><br class="webkit-block-placeholder"></div><p class="MsoNormal"><font face="Times New Roman" color="maroon" size="3"><span style="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="MsoNormal"><font face="Times New Roman" color="maroon" size="3"><span style="FONT-SIZE: 12pt; COLOR: maroon"> linux-gate.so.1 => (0x00e6f000)</span></font></p><p class="MsoNormal"><font face="Times New Roman" color="maroon" size="3"><span style="FONT-SIZE: 12pt; COLOR: maroon"> libpq.so.3 => not found</span></font></p><p class="MsoNormal"><font face="Times New Roman" color="maroon" size="3"><span style="FONT-SIZE: 12pt; COLOR: maroon"> libcrypt.so.1 => /lib/libcrypt.so.1 (0x0045d000)</span></font></p><p class="MsoNormal"><font face="Times New Roman" color="maroon" size="3"><span style="FONT-SIZE: 12pt; COLOR: maroon"> libpthread.so.0 => /lib/libpthread.so.0 (0x00110000)</span></font></p><p class="MsoNormal"><font face="Times New Roman" color="maroon" size="3"><span style="FONT-SIZE: 12pt; COLOR: maroon"> libdl.so.2 => /lib/libdl.so.2 (0x00e05000)</span></font></p><p class="MsoNormal"><font face="Times New Roman" color="maroon" size="3"><span style="FONT-SIZE: 12pt; COLOR: maroon"> libutil.so.1 => /lib/libutil.so.1 (0x003fe000)</span></font></p><p class="MsoNormal"><font face="Times New Roman" color="maroon" size="3"><span style="FONT-SIZE: 12pt; COLOR: maroon"> libc.so.6 => /lib/libc.so.6 (0x0073d000)</span></font></p><p class="MsoNormal"><font face="Times New Roman" color="maroon" size="3"><span style="FONT-SIZE: 12pt; COLOR: maroon"> libfreebl3.so => /usr/lib/libfreebl3.so (0x0012a000)</span></font></p><p class="MsoNormal"><font face="Times New Roman" color="maroon" size="3"><span style="FONT-SIZE: 12pt; COLOR: maroon"> /lib/ld-linux.so.2 (0x004af000)</span></font></p><div><font face="Times New Roman" color="maroon" size="3"><span style="FONT-SIZE: 12pt; COLOR: maroon"> </span></font><br class="webkit-block-placeholder"></div><p class="MsoNormal"><font face="Times New Roman" color="maroon" size="3"><span style="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="MsoNormal"><font face="Times New Roman" color="maroon" size="3"><span style="FONT-SIZE: 12pt; COLOR: maroon"> libpq.so.3 => not found</span></font></p><div><font face="Times New Roman" color="maroon" size="3"><span style="FONT-SIZE: 12pt; COLOR: maroon"> </span></font><br class="webkit-block-placeholder"></div><p class="MsoNormal"><font face="Times New Roman" color="maroon" size="3"><span style="FONT-SIZE: 12pt; COLOR: maroon">& also please find attached the zopectl file. </span></font></p><div><font face="Times New Roman" color="maroon" size="3"><span style="FONT-SIZE: 12pt; COLOR: maroon"> </span></font><br class="webkit-block-placeholder"></div><p class="MsoNormal"><font face="Times New Roman" color="maroon" size="3"><span style="FONT-SIZE: 12pt; COLOR: maroon">I also created the symbolic link –</span></font></p><div><font face="Times New Roman" color="maroon" size="3"><span style="FONT-SIZE: 12pt; COLOR: maroon"> </span></font><br class="webkit-block-placeholder"></div><p class="MsoNormal"><font face="Times New Roman" color="#993300" size="3"><span style="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="Times New Roman" color="#993300" size="3"><span style="FONT-SIZE: 12pt; COLOR: #993300"> </span></font><br class="webkit-block-placeholder"></div><p class="MsoNormal"><font face="Times New Roman" color="#993300" size="3"><span style="FONT-SIZE: 12pt; COLOR: #993300">Please do tel me if I can try something else.</span></font></p><div><font face="Times New Roman" color="#993300" size="3"><span style="FONT-SIZE: 12pt; COLOR: #993300"> </span></font><br class="webkit-block-placeholder"></div><p class="MsoNormal"><font face="Times New Roman" color="#993300" size="3"><span style="FONT-SIZE: 12pt; COLOR: #993300">Thanks a lot!!</span></font></p></div></div>
<table>
<tbody>
<tr>
<td bgcolor="#ffffff"><font color="#000000"><pre> </pre></font></td></tr></tbody></table></div><br>
<span><zopectl.txt></span>_______________________________________________<br>Zope-DB mailing list<br><a href="mailto:Zope-DB@zope.org">Zope-DB@zope.org</a><br>https://mail.zope.org/mailman/listinfo/zope-db<br></blockquote></div><br><div>
-- <br>ETH Zürich<br>Michele Marcionelli<br>IT Support Gruppe D-MATH<br>HG G 32.1<br>Rämistrasse 101<br>CH–8092 Zürich<br><br><a href="mailto:michele.marcionelli@math.ethz.ch">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>