Re: [Zope-DB] Fwd: Zope_Database_issue
Am 19.11.10 14:47, schrieb Andreas Jung: > From my experience: psycopg2 usually installs without major issues. Indeed > So use pyscopg2 *and* SQLAlchemyDA (as adviced already several times). As the ZPsycopgDA generally works without problems and assuming Smita needs mxDateTime compatability it's probably best to pursue with that. I'm also slightly worried about Postgres 7.4 being in there as it's been deprecated for a while. However, I agree with you that so far Smita has demonstrated an inability to take simple advice. Smita, you need to find someone in your company with more experience in unix to help you. I'm no unix whizz myself but installing Zope 2, psycopg2 and ZPsycopgDA is pretty straightforward if you follow the instructions. Charlie -- Charlie Clark eGenix.com Professional Python Services directly from the Source >>> >>> Python/Zope Consulting and Support ...http://www.egenix.com/ >>> >>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/ >>> >>> mxODBC, mxDateTime, mxTextTools ...http://python.egenix.com/ ___ Zope-DB mailing list Zope-DB@zope.org https://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Fwd: Zope_Database_issue
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, you are resistent reading advices. We adviced you to use psycopg2 instead of psycopg1 psycopg2 is a *mandatory* requirements for using ZPsycopgDA. So please follow our recommendations instead of trying the wrong things. - From my experience: psycopg2 usually installs without major issues. So use pyscopg2 *and* SQLAlchemyDA (as adviced already several times). - -aj smita kamdar wrote: > > > > HI, > > > > I uninstalled Psycopg from my LINUX m/c & now zope is working fine. > > > > Again I started installing psycopg-1.1.6 & in the first step itsef it > gives the following error: > > > > [t...@test psycopg-1.1.6]$. /configure > > --prefix=/opt/zope/psycopg-1.1.6 > > > --with-mxdatetime-includes=/home/test/egenix/2.0.6/mx/DateTime/mxDateTime > > > --with-postgres-includes=/home/postgres/7.4.13/src/include > > > --with-postgres-libraries=/home/postgres/7.4.13/lib > > --with-zope=/opt/zope > > loading cache ./config.cache > > checking for python... /usr/bin/python > > checking python version... 2.4 > > checking python installation prefix... /home/test/Python/2.4.4 > > checking python installation exec_prefix... /home/test/Python/2.4.4 > > checking definitions in Python library makefile... done > > checking location of python library... $(prefix)/lib/python2.4/site-packages > > checking location of python shared modules... > $(exec_prefix)/lib/python2.4/site-packages > > checking for gcc... gcc -pthread > > checking whether the C compiler (gcc -pthread ) works... yes > > checking whether the C compiler (gcc -pthread ) is a cross-compiler... no > > checking whether we are using GNU C... yes > > checking whether gcc -pthread accepts -g... yes > > checking how to run the C preprocessor... gcc -pthread -E > > checking whether make sets ${MAKE}... yes > > checking for inline... inline > > *checking PostgreSQL version... configure: error: missing PostgreSQL > headers* > > > > Is it because of this error that I am not able to solve the issue? > Because last time when I Installed Psycopg I faced the same error. > > > > How shall I progress? > > > > Please Note: Paths of the Directories where my installables are – > > > > Zope --à /opt/zope > > Python à/home/test/Python/2.4.4 > > Egenix -à/home/test/egenix > > Postgresqlà/home/postgres/7.4.13 > > Psycopgà/opt/zope/psycopg-1.1.6 > > > > > > > > ___ > Zope-DB mailing list > Zope-DB@zope.org > https://mail.zope.org/mailman/listinfo/zope-db - -- ZOPYX Limited | zopyx group Charlottenstr. 37/1 | The full-service network for Zope & Plone D-72070 Tübingen| Produce & Publish www.zopyx.com | www.produce-and-publish.com - E-Publishing, Python, Zope & Plone development, Consulting -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQGUBAEBAgAGBQJM5n/5AAoJEADcfz7u4AZj86gLv2Grtv98HUMbESEX7D3dSO2Z iJzOLDU0gs48MFkJdniFuzQ51JimGm0oWcYPN3syfRSwKAJX36gHAObj+RAI4pJP XUQUFYEH17VkyE447xs7uaqodmvKSM8MMlpJ14rEc2TK7xtOPE+cF4g0ej07d7CR 6dABNDtz047mQ+OnDgPtFbMgVC39Mkj60mH1e0fwjZB+3as6vUZEmDPvAZ7r++0f 9D8BkSZwpwxkDSPRf+Qi/ddB5aR/tfu4FCU4v1TDb5Xre3b+vHm/7LdgtsHf1e86 SLUlJ8xvVVt84H6yApCYEsRr37hz2B6W6gp0USvDeOLCu6ujq8c+4f2rG8JNkByS cqK1l8Puw5QGnw2GUJ7j29PDfPueeyYq3PsozPBtLI92VoD3Si0n3ofIqRBWJnD3 p58slqr7DoCkWwvJ7OFnSJCaHf3Kxf9USptyYb2aQu8ziuqClFYJZsba/BAuXLbW 1d2OlIwVjEDdYyLzt6ECUE6TxUy5xck= =XZB7 -END PGP SIGNATURE- <>___ Zope-DB mailing list Zope-DB@zope.org https://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Fwd: Zope_Database_issue
Are you sure that the header file are in /home/postgres/7.4.13/src/include? And are readable for the user "test"? Normally I would expect to find them in something lik this /home/postgres/7.4.13/include M. PS: Why don't you install everything as "root" in /opt/? On Nov 19, 2010, at 14:40 , smita kamdar wrote: > > > > HI, > > > I uninstalled Psycopg from my LINUX m/c & now zope is working fine. > > > Again I started installing psycopg-1.1.6 & in the first step itsef it gives > the following error: > > > [t...@test psycopg-1.1.6]$. /configure > > --prefix=/opt/zope/psycopg-1.1.6 > > > --with-mxdatetime-includes=/home/test/egenix/2.0.6/mx/DateTime/mxDateTime > > > --with-postgres-includes=/home/postgres/7.4.13/src/include > > > --with-postgres-libraries=/home/postgres/7.4.13/lib > > --with-zope=/opt/zope > > loading cache ./config.cache > > checking for python... /usr/bin/python > > checking python version... 2.4 > > checking python installation prefix... /home/test/Python/2.4.4 > > checking python installation exec_prefix... /home/test/Python/2.4.4 > > checking definitions in Python library makefile... done > > checking location of python library... $(prefix)/lib/python2.4/site-packages > > checking location of python shared modules... > $(exec_prefix)/lib/python2.4/site-packages > > checking for gcc... gcc -pthread > > checking whether the C compiler (gcc -pthread ) works... yes > > checking whether the C compiler (gcc -pthread ) is a cross-compiler... no > > checking whether we are using GNU C... yes > > checking whether gcc -pthread accepts -g... yes > > checking how to run the C preprocessor... gcc -pthread -E > > checking whether make sets ${MAKE}... yes > > checking for inline... inline > > checking PostgreSQL version... configure: error: missing PostgreSQL headers > > > Is it because of this error that I am not able to solve the issue? Because > last time when I Installed Psycopg I faced the same error. > > > How shall I progress? > > > Please Note: Paths of the Directories where my installables are – > > > Zope --à /opt/zope > > Python à /home/test/Python/2.4.4 > > Egenix -à /home/test/egenix > > Postgresqlà /home/postgres/7.4.13 > > Psycopgà/opt/zope/psycopg-1.1.6 > > > > > ___ > Zope-DB mailing list > Zope-DB@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.marcione...@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@zope.org https://mail.zope.org/mailman/listinfo/zope-db
[Zope-DB] Fwd: Zope_Database_issue
HI, I uninstalled Psycopg from my LINUX m/c & now zope is working fine. Again I started installing psycopg-1.1.6 & in the first step itsef it gives the following error: [t...@test psycopg-1.1.6]$. /configure --prefix=/opt/zope/psycopg-1.1.6 --with-mxdatetime-includes=/home/test/egenix/2.0.6/mx/DateTime/mxDateTime --with-postgres-includes=/home/postgres/7.4.13/src/include --with-postgres-libraries=/home/postgres/7.4.13/lib --with-zope=/opt/zope loading cache ./config.cache checking for python... /usr/bin/python checking python version... 2.4 checking python installation prefix... /home/test/Python/2.4.4 checking python installation exec_prefix... /home/test/Python/2.4.4 checking definitions in Python library makefile... done checking location of python library... $(prefix)/lib/python2.4/site-packages checking location of python shared modules... $(exec_prefix)/lib/python2.4/site-packages checking for gcc... gcc -pthread checking whether the C compiler (gcc -pthread ) works... yes checking whether the C compiler (gcc -pthread ) is a cross-compiler... no checking whether we are using GNU C... yes checking whether gcc -pthread accepts -g... yes checking how to run the C preprocessor... gcc -pthread -E checking whether make sets ${MAKE}... yes checking for inline... inline *checking PostgreSQL version... configure: error: missing PostgreSQL headers * Is it because of this error that I am not able to solve the issue? Because last time when I Installed Psycopg I faced the same error. How shall I progress? Please Note: Paths of the Directories where my installables are – Zope --à /opt/zope Python à /home/test/Python/2.4.4 Egenix -à /home/test/egenix Postgresqlà /home/postgres/7.4.13 Psycopgà/opt/zope/psycopg-1.1.6 ___ Zope-DB mailing list Zope-DB@zope.org https://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Zope_Database_issue
Hi Smita running Zope (or a generally a server) as "root" is newer a good idea (for several reasons; one of them: security). Zope probably avoid this problem by producing the error message that you posted (I just tested it, and I also got the same message). Create a news user, let say: "zope" with group "zope", change the ownerships as follow: chown -R zope:zope /opt/zope and change the effective-user to zope and try again!! Cheers, Michele On Nov 19, 2010, at 12:32 , smita kamdar wrote: > > Hi, > > > To make the permissions, owner & group of all the installables same, I > changed the permissions to 777 & owner & group to root for all the > installables. > > > Now I am able to get the output of the following commands - > > [r...@test bin]# ls -l /home/postgres/7.4.13/lib/libpq.so.3 > > lrwxrwxrwx. 1 root root 12 2010-11-09 23:59 > /home/postgres/7.4.13/lib/libpq.so.3 -> libpq.so.3.1 > > > [r...@test bin]# export LD_LIBRARY_PATH=/home/postgres/7.4.13/lib > > [r...@test bin]# echo $LD_LIBRARY_PATH > > /home/postgres/7.4.13/lib > > > [r...@test bin]# ldd > /home/test/Python/2.4.4/lib/python2.4/site-packages/psycopgmodule.so | grep > libpq.so > > libpq.so.3 => /home/postgres/7.4.13/lib/libpq.so.3 (0x005b1000) > > > But when I start the zope as root user, I face the following error - > > > [r...@test bin]# ./zopectl fg > > /opt/zope/bin/runzope -X debug-mode=on > > 2010-11-19 21:10:21 INFO ZServer HTTP server started at Fri Nov 19 21:10:21 > 2010 > > Hostname: 0.0.0.0 > > Port: 8080 > > 2010-11-19 21:10:21 CRITICAL Zope A user was not specified to setuid to; fix > this to start as root (change the effective-user directive in zope.conf) > > Traceback (most recent call last): > > File "/opt/zope/lib/python/Zope2/Startup/run.py", line 56, in ? > > run() > > File "/opt/zope/lib/python/Zope2/Startup/run.py", line 21, in run > > starter.prepare() > > File "/opt/zope/lib/python/Zope2/Startup/__init__.py", line 105, in prepare > > self.dropPrivileges() > > File "/opt/zope/lib/python/Zope2/Startup/__init__.py", line 256, in > dropPrivileges > > return dropPrivileges(self.cfg) > > File "/opt/zope/lib/python/Zope2/Startup/__init__.py", line 425, in > dropPrivileges > > raise ZConfig.ConfigurationError(msg) > > ZConfig.ConfigurationError: A user was not specified to setuid to; fix this > to start as root (change the effective-user directive in zope.conf) > > > > The effective user part in /etc/zope.conf file looks as shown below - > > --- > > # Directive: effective-user > > # > > # Description: > > # If you intend to run Zope as the "root" user, you must supply this > > # directive with an effective username or userid number to which Zope > > # will 'suid' after the server ports are bound. This directive only > > # has effect under UNIX and if Zope is started as the root user. > > # > > # Default: unset > > # > > # Example: > > # > > # effective-user chrism > > - > > > As, they have said to change the effective-user directive in zope.conf, I > changed the effective user part in the file as shown below – > > > --- > > > # Directive: effective-user > > # > > # Description: > > # If you intend to run Zope as the "root" user, you must supply this > > # directive with an effective username or userid number to which Zope > > # will 'suid' after the server ports are bound. This directive only > > # has effect under UNIX and if Zope is started as the root user. > > # > > # Default: unset > > # > > # Example: > > # > > effective-user root > > > > After changing the above file, When I started zope as root, it is showing the > below error – > > > [r...@test bin]# ./zopectl fg > > /opt/zope/bin/runzope -X debug-mode=on > > 2010-11-19 21:19:47 INFO ZServer HTTP server started at Fri Nov 19 21:19:47 > 2010 > > Hostname: 0.0.0.0 > > Port: 8080 > > 2010-11-19 21:19:47 ERROR Zope Cannot start Zope with the effective user as > the root user > > Traceback (most recent call last): > > File "/opt/zope/lib/python/Zope2/Startup/run.py", line 56, in? > > run() > > File "/opt/zope/lib/python/Zope2/Startup/run.py", line 21, in run > > starter.prepare() > > File "/opt/zope/lib/python/Zope2/Startup/__init__.py", line 105, in prepare > > self.dropPrivileges() > > File "/opt/zope/lib/python/Zope2/Startup/__init__.py", line 2
Re: [Zope-DB] Zope_Database_issue
Am 19.11.10 12:32, schrieb smita kamdar: > Do you think I have done right? Or is this some other error? > Dear Smita, there was no need to set root as owner of the Postgres libraries. You just need to have permissions that are readable by the Zope user which is what Michele described. Once this is the case then Zope should start or at least give a different error. Please note that the errors you are experiencing are not related to Zope, Python or Postgres but unix and you should see if you can get some help from a sys admin in your company. Charlie -- Charlie Clark eGenix.com Professional Python Services directly from the Source >>> >>> Python/Zope Consulting and Support ...http://www.egenix.com/ >>> >>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/ >>> >>> mxODBC, mxDateTime, mxTextTools ...http://python.egenix.com/ ___ Zope-DB mailing list Zope-DB@zope.org https://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Zope_Database_issue
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: > > > [t...@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.marcione...@math.ethz.ch] > Sent: Thursday, November 18, 2010 11:55 PM > To: smita kamdar > Cc: zope-db@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 - > > > [t...@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 (0x0011) > > 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) > > > [t...@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!! > > > > ___ > Zope-DB mailing list > Zope-DB@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.marcione...@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@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.marcione...@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@zope.org https://mail.zope.org/mailman/listinfo/zope-db
[Zope-DB] Zope_Database_issue
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: [t...@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.marcione...@math.ethz.ch] *Sent:* Thursday, November 18, 2010 11:55 PM *To:* smita kamdar *Cc:* zope-db@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 - [t...@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 (0x0011) 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) [t...@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!! ___ Zope-DB mailing list Zope-DB@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.marcione...@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@zope.org https://mail.zope.org/mailman/listinfo/zope-db