<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi Smita<div><br></div><div>you should probably install the postgres libraries as user "<font class="Apple-style-span" face="Courier">test</font>"... just to simplify your life ;-) Otherwise you can try changing the permissions so that user "<font class="Apple-style-span" face="Courier">test</font>" can access the "<font class="Apple-style-span" face="Courier">libpg.so.3</font>". Try following (as user "<font class="Apple-style-span" face="Courier">root</font>"):</div><div><br></div><div><div><font class="Apple-style-span" face="Courier">chmod 755 /home/postgres</font></div></div><div><div><font class="Apple-style-span" face="Courier">chmod 755 /home/postgres/7.4.13</font></div></div><div><div><font class="Apple-style-span" face="Courier">chmod 755 /home/postgres/7.4.13/lib</font></div></div><div><font class="Apple-style-span" face="Courier">chmod 644 /home/postgres/7.4.13/lib/libpq.so.3</font></div><div><br></div><div>Then following should work:</div><div><br></div><div><font class="Apple-style-span" face="Courier">su - test</font></div><div><span class="Apple-style-span" style="font-family: Courier; ">ls -l /home/postgres/7.4.13/lib/libpq.so.3</span></div><div><font class="Apple-style-span" face="Courier">export LD_LIBRARY_PATH=/home/postgres/7.4.13/lib</font></div><div><font class="Apple-style-span" color="#000000"><span class="Apple-style-span" style="background-color: transparent;"><font class="Apple-style-span" face="Courier">ldd /home/test/Python/2.4.4/lib/python2.4/site-packages/psycopgmodule.so | grep libpq.so</font></span></font></div><div><br></div><div>If this works, try starting zope again.</div><div><br></div><div>About the "PYTHONPATH" variable I'm not sure. Andreas?</div><div><br></div><div>Cheers,</div><div>Michele</div><div><br></div><div><br><div><div>On Nov 19, 2010, at 10:34 , 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"><span class="Apple-style-span" style="font-family: 'Times New Roman'; font-size: 16px; ">HI,</span><br><div lang="EN-US" link="blue" vlink="blue" style="word-wrap:break-word"><div><div><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font><br class="webkit-block-placeholder"></div><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">While installing Postgresql, I installed it as user postgres & so
the entire folder in which it is installed have owner as postgres. </span></font></p><div><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font><br class="webkit-block-placeholder"></div><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">Other than Postgresql, all the other installations (i.e. Zope, Python,
egenix & psycopg) are done as user test. </span></font></p><div><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font><br class="webkit-block-placeholder"></div><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">Zope is also working as user test. </span></font></p><div><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font><br class="webkit-block-placeholder"></div><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">I tried to run the below as user test & it gave the following output:</span></font></p><div><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font><br class="webkit-block-placeholder"></div><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">[test@test ~]$ ls -l /home/postgres/7.4.13/lib/libpq.so.3</span></font></p><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">ls: cannot access /home/postgres/7.4.13/lib/libpq.so.3: Permission
denied </span></font></p><div><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font><br class="webkit-block-placeholder"></div><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">Do you think I should change any permissions?</span></font></p><div><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font><br class="webkit-block-placeholder"></div><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">& I think you are right, in zopectl file, the variable PYTHONPATH
is not correct.</span></font></p><div><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font><br class="webkit-block-placeholder"></div><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">I have changed the value of that variable to’<i><span style="font-style:italic"> </span></i><font color="#993300"><span style="color:#993300">/home/test/Python/2.4.4/lib</span></font>’
Is this path correct?</span></font></p><div><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font><br class="webkit-block-placeholder"></div><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">Thanks a lot!!</span></font></p><div><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font><br class="webkit-block-placeholder"></div><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">Regards,</span></font></p><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">Smita Kamdar</span></font></p><p class="MsoNormal"><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon">-------------------------------------------------------------------------------------------------------------------------------------------------------------------</span></font></p>
<div><div><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font><br class="webkit-block-placeholder"></div><p class="MsoNormal"><b><font size="2" face="Tahoma"><span style="font-size:10.0pt;font-family:Tahoma;font-weight:bold">From:</span></font></b><font size="2" face="Tahoma"><span style="font-size:10.0pt;font-family:Tahoma"> Michele
Marcionelli [mailto:<a href="mailto:michele.marcionelli@math.ethz.ch" target="_blank">michele.marcionelli@math.ethz.ch</a>] <br>
<b><span style="font-weight:bold">Sent:</span></b> Thursday, November 18, 2010
11:55 PM<br>
<b><span style="font-weight:bold">To:</span></b> smita kamdar<br>
<b><span style="font-weight:bold">Cc:</span></b> <a href="mailto:zope-db@zope.org" target="_blank">zope-db@zope.org</a><br>
<b><span style="font-weight:bold">Subject:</span></b> Re: [Zope-DB]
Zope_Database_issue</span></font></p>
</div><div><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font><br class="webkit-block-placeholder"></div><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">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?</span></font></p>
<div><div><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font><br class="webkit-block-placeholder"></div>
</div>
<div><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">Try as user "test" following:</span></font></p>
</div>
<div><div><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font><br class="webkit-block-placeholder"></div>
</div>
<div><p class="MsoNormal"><font size="3" face="Courier"><span style="font-size:12.0pt;font-family:Courier"> ls
-l /home/postgres/7.4.13/lib/libpq.so.3</span></font></p>
<div><div><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font><br class="webkit-block-placeholder"></div>
</div>
<div><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">Can you see the file?</span></font></p>
</div>
<div><div><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font><br class="webkit-block-placeholder"></div>
</div>
<div><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">By the way: in the </span></font><font face="Courier"><span style="font-family:Courier">zopectl</span></font> script you declared the
variable <span><font face="Courier"><span style="font-family:Courier">PYTHONPATH="/opt/zope/lib/python" </span></font></span>and
here you speak of <font face="Courier"><span style="font-family:Courier">/home/test/Python/2.4.4/lib/python2.4/site-packages</span></font>...
are you sure that this variable is correct?</p>
</div>
<div><div><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font><br class="webkit-block-placeholder"></div>
</div>
<div><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">Cheers,</span></font></p>
</div>
<div><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">Michele</span></font></p>
</div>
<div><div><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font><br class="webkit-block-placeholder"></div>
</div>
<div><div><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font><br class="webkit-block-placeholder"></div>
</div>
<div>
<div>
<div><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">On Nov 18, 2010, at 18:27 , smita kamdar wrote:</span></font></p>
</div><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"><br>
<br>
</span></font></p>
<div>
<div vlink="purple" link="blue">
<div><p class="MsoNormal"><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon">Hi,</span></font></p><p class="MsoNormal"><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon">Please find below the output of the commands - </span></font></p>
<div><div><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon"> </span></font><br class="webkit-block-placeholder"></div>
</div><p class="MsoNormal"><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;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 size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon"> linux-gate.so.1
=> (0x00e6f000)</span></font></p><p class="MsoNormal"><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon"> libpq.so.3 => not
found</span></font></p><p class="MsoNormal"><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon"> libcrypt.so.1 =>
/lib/libcrypt.so.1 (0x0045d000)</span></font></p><p class="MsoNormal"><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon"> libpthread.so.0 =>
/lib/libpthread.so.0 (0x00110000)</span></font></p><p class="MsoNormal"><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon"> libdl.so.2 =>
/lib/libdl.so.2 (0x00e05000)</span></font></p><p class="MsoNormal"><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon"> libutil.so.1 =>
/lib/libutil.so.1 (0x003fe000)</span></font></p><p class="MsoNormal"><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon"> libc.so.6 =>
/lib/libc.so.6 (0x0073d000)</span></font></p><p class="MsoNormal"><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon"> libfreebl3.so =>
/usr/lib/libfreebl3.so (0x0012a000)</span></font></p><p class="MsoNormal"><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon"> /lib/ld-linux.so.2
(0x004af000)</span></font></p>
<div><div><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon"> </span></font><br class="webkit-block-placeholder"></div>
</div><p class="MsoNormal"><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;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 size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon"> libpq.so.3 => not
found</span></font></p>
<div><div><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon"> </span></font><br class="webkit-block-placeholder"></div>
</div><p class="MsoNormal"><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon">& also please find attached the zopectl file. </span></font></p>
<div><div><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon"> </span></font><br class="webkit-block-placeholder"></div>
</div><p class="MsoNormal"><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon">I also created the symbolic link –</span></font></p>
<div><div><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon"> </span></font><br class="webkit-block-placeholder"></div>
</div><p class="MsoNormal"><font size="3" color="#993300" face="Times New Roman"><span style="font-size:12.0pt;color:#993300">ln -s /home/postgres/7.4.13/lib/libpq.so.3 /usr/lib/libpq.so.3</span></font></p>
<div><div><font size="3" color="#993300" face="Times New Roman"><span style="font-size:12.0pt;color:#993300"> </span></font><br class="webkit-block-placeholder"></div>
</div><p class="MsoNormal"><font size="3" color="#993300" face="Times New Roman"><span style="font-size:12.0pt;color:#993300">Please do tel me if I can try something else.</span></font></p>
<div><div><font size="3" color="#993300" face="Times New Roman"><span style="font-size:12.0pt;color:#993300"> </span></font><br class="webkit-block-placeholder"></div>
</div><p class="MsoNormal"><font size="3" color="#993300" face="Times New Roman"><span style="font-size:12.0pt;color:#993300">Thanks a lot!!</span></font></p>
</div>
</div>
<table border="0" cellpadding="0">
<tbody><tr>
<td bgcolor="white" style="background:white;padding:.75pt .75pt .75pt .75pt"><pre><font size="2" color="black" face="Courier New"><span style="font-size:10.0pt;color:black"> </span></font></pre></td>
</tr>
</tbody></table>
</div><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"><br>
<zopectl.txt>_______________________________________________<br>
Zope-DB mailing list<br>
<a href="mailto:Zope-DB@zope.org" target="_blank">Zope-DB@zope.org</a><br>
<a href="https://mail.zope.org/mailman/listinfo/zope-db" target="_blank">https://mail.zope.org/mailman/listinfo/zope-db</a></span></font></p>
</div><div><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font><br class="webkit-block-placeholder"></div>
<div><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">-- <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" target="_blank">michele.marcionelli@math.ethz.ch</a><br>
<a href="http://www.math.ethz.ch/~michele" target="_blank">http://www.math.ethz.ch/~michele</a><br>
<br>
+41 44 632 6193 Telefon<br>
+41 44 632 1354 Fax </span></font></p>
</div><div><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font><br class="webkit-block-placeholder"></div>
</div>
</div>
</div>
</div>
</div>
_______________________________________________<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></body></html>