Zope_Database_issue
smita kamdar <[email protected]> Fri, 19 Nov 2010 15:04:33 +0530
| Newsgroups | gmane.comp.web.zope.database |
|---|---|
| Message-ID | <[email protected]> |
--===============4587139568036431816== Content-Type: multipart/alternative; boundary=000e0cd4026c39fbfe0495649dc7 --000e0cd4026c39fbfe0495649dc7 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable HI, While installing Postgresql, I installed it as user postgres & so the entir= e 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@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=92* */home/test/Python/2.4.4/l= ib=92 Is this path correct? Thanks a lot!! Regards, Smita Kamdar ---------------------------------------------------------------------------= ---------------------------------------------------------------------------= ------------- *From:* Michele Marcionelli [mailto:[email protected]] *Sent:* Thursday, November 18, 2010 11:55 PM *To:* smita kamdar *Cc:* [email protected] *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 wil= l probably run as another user, for instance "zope". Does all these users hav= e 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, Please find below the output of the commands - [test@test site-packages]$ ldd /home/test/Python/2.4.4/lib/python2.4/site-packages/psycopgmodule.so linux-gate.so.1 =3D> (0x00e6f000) libpq.so.3 =3D> not found libcrypt.so.1 =3D> /lib/libcrypt.so.1 (0x0045d000) libpthread.so.0 =3D> /lib/libpthread.so.0 (0x00110000) libdl.so.2 =3D> /lib/libdl.so.2 (0x00e05000) libutil.so.1 =3D> /lib/libutil.so.1 (0x003fe000) libc.so.6 =3D> /lib/libc.so.6 (0x0073d000) libfreebl3.so =3D> /usr/lib/libfreebl3.so (0x0012a000) /lib/ld-linux.so.2 (0x004af000) [test@test site-packages]$ ldd /home/test/Python/2.4.4/lib/python2.4/site-packages/psycopgmodule.so | grep libpq.so libpq.so.3 =3D> not found & also please find attached the zopectl file. I also created the symbolic link =96 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 [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 --000e0cd4026c39fbfe0495649dc7 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable <div class=3D"gmail_quote"><br><br><br> <div lang=3D"EN-US" link=3D"blue" vlink=3D"blue" style=3D"word-wrap:break-w= ord"> <div> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">HI,</span></font></p> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">=A0</span></font></p> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"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> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">=A0</span></font></p> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"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> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">=A0</span></font></p> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">Zope is also working as user test. </span></font></p= > <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">=A0</span></font></p> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">I tried to run the below as user test & it gave = the following output:</span></font></p> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">=A0</span></font></p> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">[test@test ~]$ ls -l /home/postgres/7.4.13/lib/libpq= .so.3</span></font></p> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">ls: cannot access /home/postgres/7.4.13/lib/libpq.so= .3: Permission denied </span></font></p> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">=A0</span></font></p> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">Do you think I should change any permissions?</span>= </font></p> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">=A0</span></font></p> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">& I think you are right, in zopectl file, the va= riable PYTHONPATH is not correct.</span></font></p> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">=A0</span></font></p> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">I have changed the value of that variable to=92<i><s= pan style=3D"font-style:italic"> </span></i><font color=3D"#993300"><span s= tyle=3D"color:#993300">/home/test/Python/2.4.4/lib</span></font>=92 Is this path correct?</span></font></p> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">=A0</span></font></p> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">Thanks a lot!!</span></font></p> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">=A0</span></font></p> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">Regards,</span></font></p> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">Smita Kamdar</span></font></p> <p class=3D"MsoNormal"><font size=3D"3" color=3D"maroon" face=3D"Times New = Roman"><span style=3D"font-size:12.0pt;color:maroon">----------------------= ---------------------------------------------------------------------------= ------------------------------------------------------------------</span></= font></p> <div> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">=A0</span></font></p> <p class=3D"MsoNormal"><b><font size=3D"2" face=3D"Tahoma"><span style=3D"f= ont-size:10.0pt;font-family:Tahoma;font-weight:bold">From:</span></font></b= ><font size=3D"2" face=3D"Tahoma"><span style=3D"font-size:10.0pt;font-fami= ly:Tahoma"> Michele Marcionelli [mailto:<a href=3D"mailto:[email protected]" tar= get=3D"_blank">[email protected]</a>] <br> <b><span style=3D"font-weight:bold">Sent:</span></b> Thursday, November 18,= 2010 11:55 PM<br> <b><span style=3D"font-weight:bold">To:</span></b> smita kamdar<br> <b><span style=3D"font-weight:bold">Cc:</span></b> <a href=3D"mailto:zope-d= [email protected]" target=3D"_blank">[email protected]</a><br> <b><span style=3D"font-weight:bold">Subject:</span></b> Re: [Zope-DB] Zope_Database_issue</span></font></p> </div> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">=A0</span></font></p> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"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 enou= gh rights?</span></font></p> <div> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">=A0</span></font></p> </div> <div> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">Try as user "test" following:</span></font= ></p> </div> <div> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">=A0</span></font></p> </div> <div> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Courier"><span style=3D"fon= t-size:12.0pt;font-family:Courier">=A0=A0 =A0ls -l=A0/home/postgres/7.4.13/lib/libpq.so.3</span></font></p> <div> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">=A0</span></font></p> </div> <div> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">Can you see the file?</span></font></p> </div> <div> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">=A0</span></font></p> </div> <div> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">By the way: in the </span></font><font face=3D"Couri= er"><span style=3D"font-family:Courier">zopectl</span></font> script you de= clared the variable=A0<span><font face=3D"Courier"><span style=3D"font-family:Courier"= >PYTHONPATH=3D"/opt/zope/lib/python"=A0</span></font></span>and here you speak of=A0<font face=3D"Courier"><span style=3D"font-family:Couri= er">/home/test/Python/2.4.4/lib/python2.4/site-packages</span></font>... are you sure that this variable is correct?</p> </div> <div> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">=A0</span></font></p> </div> <div> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">Cheers,</span></font></p> </div> <div> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">Michele</span></font></p> </div> <div> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">=A0</span></font></p> </div> <div> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">=A0</span></font></p> </div> <div> <div> <div> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">On Nov 18, 2010, at 18:27 , smita kamdar wrote:</spa= n></font></p> </div> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt"><br> <br> </span></font></p> <div> <div vlink=3D"purple" link=3D"blue"> <div> <p class=3D"MsoNormal"><font size=3D"3" color=3D"maroon" face=3D"Times New = Roman"><span style=3D"font-size:12.0pt;color:maroon">Hi,</span></font></p> <p class=3D"MsoNormal"><font size=3D"3" color=3D"maroon" face=3D"Times New = Roman"><span style=3D"font-size:12.0pt;color:maroon">Please find below the = output of the commands - </span></font></p> <div> <p class=3D"MsoNormal"><font size=3D"3" color=3D"maroon" face=3D"Times New = Roman"><span style=3D"font-size:12.0pt;color:maroon">=A0</span></font></p> </div> <p class=3D"MsoNormal"><font size=3D"3" color=3D"maroon" face=3D"Times New = Roman"><span style=3D"font-size:12.0pt;color:maroon">[test@test site-packag= es]$ ldd /home/test/Python/2.4.4/lib/python2.4/site-packages/psycopgmodule.so</span>= </font></p> <p class=3D"MsoNormal"><font size=3D"3" color=3D"maroon" face=3D"Times New = Roman"><span style=3D"font-size:12.0pt;color:maroon">=A0=A0=A0=A0=A0=A0=A0 = linux-gate.so.1 =3D>=A0 (0x00e6f000)</span></font></p> <p class=3D"MsoNormal"><font size=3D"3" color=3D"maroon" face=3D"Times New = Roman"><span style=3D"font-size:12.0pt;color:maroon">=A0=A0=A0=A0=A0=A0=A0 = libpq.so.3 =3D> not found</span></font></p> <p class=3D"MsoNormal"><font size=3D"3" color=3D"maroon" face=3D"Times New = Roman"><span style=3D"font-size:12.0pt;color:maroon">=A0=A0=A0=A0=A0=A0=A0 = libcrypt.so.1 =3D> /lib/libcrypt.so.1 (0x0045d000)</span></font></p> <p class=3D"MsoNormal"><font size=3D"3" color=3D"maroon" face=3D"Times New = Roman"><span style=3D"font-size:12.0pt;color:maroon">=A0=A0=A0=A0=A0=A0=A0 = libpthread.so.0 =3D> /lib/libpthread.so.0 (0x00110000)</span></font></p> <p class=3D"MsoNormal"><font size=3D"3" color=3D"maroon" face=3D"Times New = Roman"><span style=3D"font-size:12.0pt;color:maroon">=A0=A0=A0=A0=A0=A0=A0 = libdl.so.2 =3D> /lib/libdl.so.2 (0x00e05000)</span></font></p> <p class=3D"MsoNormal"><font size=3D"3" color=3D"maroon" face=3D"Times New = Roman"><span style=3D"font-size:12.0pt;color:maroon">=A0=A0=A0=A0=A0=A0=A0 = libutil.so.1 =3D> /lib/libutil.so.1 (0x003fe000)</span></font></p> <p class=3D"MsoNormal"><font size=3D"3" color=3D"maroon" face=3D"Times New = Roman"><span style=3D"font-size:12.0pt;color:maroon">=A0=A0=A0=A0=A0=A0=A0 = libc.so.6 =3D> /lib/libc.so.6 (0x0073d000)</span></font></p> <p class=3D"MsoNormal"><font size=3D"3" color=3D"maroon" face=3D"Times New = Roman"><span style=3D"font-size:12.0pt;color:maroon">=A0=A0=A0=A0=A0=A0=A0 = libfreebl3.so =3D> /usr/lib/libfreebl3.so (0x0012a000)</span></font></p> <p class=3D"MsoNormal"><font size=3D"3" color=3D"maroon" face=3D"Times New = Roman"><span style=3D"font-size:12.0pt;color:maroon">=A0=A0=A0=A0=A0 =A0=A0= /lib/ld-linux.so.2 (0x004af000)</span></font></p> <div> <p class=3D"MsoNormal"><font size=3D"3" color=3D"maroon" face=3D"Times New = Roman"><span style=3D"font-size:12.0pt;color:maroon">=A0</span></font></p> </div> <p class=3D"MsoNormal"><font size=3D"3" color=3D"maroon" face=3D"Times New = Roman"><span style=3D"font-size:12.0pt;color:maroon">[test@test site-packag= es]$ 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 size=3D"3" color=3D"maroon" face=3D"Times New = Roman"><span style=3D"font-size:12.0pt;color:maroon">=A0=A0=A0=A0=A0=A0=A0 = libpq.so.3 =3D> not found</span></font></p> <div> <p class=3D"MsoNormal"><font size=3D"3" color=3D"maroon" face=3D"Times New = Roman"><span style=3D"font-size:12.0pt;color:maroon">=A0</span></font></p> </div> <p class=3D"MsoNormal"><font size=3D"3" color=3D"maroon" face=3D"Times New = Roman"><span style=3D"font-size:12.0pt;color:maroon">& also please find= attached the zopectl file. </span></font></p> <div> <p class=3D"MsoNormal"><font size=3D"3" color=3D"maroon" face=3D"Times New = Roman"><span style=3D"font-size:12.0pt;color:maroon">=A0</span></font></p> </div> <p class=3D"MsoNormal"><font size=3D"3" color=3D"maroon" face=3D"Times New = Roman"><span style=3D"font-size:12.0pt;color:maroon">I also created the sym= bolic link =96</span></font></p> <div> <p class=3D"MsoNormal"><font size=3D"3" color=3D"maroon" face=3D"Times New = Roman"><span style=3D"font-size:12.0pt;color:maroon">=A0</span></font></p> </div> <p class=3D"MsoNormal"><font size=3D"3" color=3D"#993300" face=3D"Times New= Roman"><span style=3D"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> <p class=3D"MsoNormal"><font size=3D"3" color=3D"#993300" face=3D"Times New= Roman"><span style=3D"font-size:12.0pt;color:#993300">=A0</span></font></p= > </div> <p class=3D"MsoNormal"><font size=3D"3" color=3D"#993300" face=3D"Times New= Roman"><span style=3D"font-size:12.0pt;color:#993300">Please do tel me if = I can try something else.</span></font></p> <div> <p class=3D"MsoNormal"><font size=3D"3" color=3D"#993300" face=3D"Times New= Roman"><span style=3D"font-size:12.0pt;color:#993300">=A0</span></font></p= > </div> <p class=3D"MsoNormal"><font size=3D"3" color=3D"#993300" face=3D"Times New= Roman"><span style=3D"font-size:12.0pt;color:#993300">Thanks a lot!!</span= ></font></p> </div> </div> <table border=3D"0" cellpadding=3D"0"> <tbody><tr> <td bgcolor=3D"white" style=3D"background:white;padding:.75pt .75pt .75pt= .75pt"><pre><font size=3D"2" color=3D"black" face=3D"Courier New"><span st= yle=3D"font-size:10.0pt;color:black">=A0</span></font></pre></td> </tr> </tbody></table> </div> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt"><br> <zopectl.txt>_______________________________________________<br> Zope-DB mailing list<br> <a href=3D"mailto:[email protected]" target=3D"_blank">[email protected]</a><= br> <a href=3D"https://mail.zope.org/mailman/listinfo/zope-db" target=3D"_blank= ">https://mail.zope.org/mailman/listinfo/zope-db</a></span></font></p> </div> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">=A0</span></font></p> <div> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">--=A0<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]" target=3D"_blank">miche= [email protected]</a><br> <a href=3D"http://www.math.ethz.ch/~michele" target=3D"_blank">http://www.m= ath.ethz.ch/~michele</a><br> <br> +41 44 632 6193 Telefon<br> +41 44 632 1354 Fax </span></font></p> </div> <p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl= e=3D"font-size:12.0pt">=A0</span></font></p> </div> </div> </div> </div> </div> --000e0cd4026c39fbfe0495649dc7-- --===============4587139568036431816== 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 --===============4587139568036431816==--