Mailing List Archive: Zope: DB

Fwd: Zope_Database_issue

Index | Next | Previous | View Threaded

smita.kamdar00 at gmail

Nov 17, 2010, 3:07 AM

Post #1 of 6 (1644 views)
Permalink

Fwd: Zope_Database_issue

Hi,

Thanks a lot for your suggestion!!

But I am specifically told to use ZPsycopgDA to connect zope & postgres. I
am trying a lot to add a new ZPsycopg database connection from Zope
Management Interface screen, But that option does not exist in Add drop -box
of Zope Management Interface screen. Should Zope software home & zope
Instance home be same?? If no then where should I install ZPsycopgDA??

Also do I need to install anything else other than ZPsycopgDA to connect
zope & postgres?

I am using Zope 2.11.4, python 2.4.4, Postgres 7.4.13, egenix 2.0.6 &
Psycopg 1.1.6

I am really in a mess! Really need your help!

---------- Forwarded message ----------

From: Andreas Jung <lists [at] zopyx>

Date: Tue, 16 Nov 2010 18:46:59 +0100

Subject: Re: [Zope-DB] Zope_Database_issue

To: smita kamdar <smita.kamdar00 [at] gmail>

Cc: zope-db [at] zope

Try using Products.SQLAlchemyDA instead.

-aj

2010/11/16 smita kamdar <smita.kamdar00 [at] gmail>

>

> Hi,

>

>

>

> I am a beginner in zope with no prior experience. I am supposed to setup a

> development environment with zope, postgres, python, openflow, egenix &

> psycopg.

>

>

>

> I have installed all of them on Red Hat Linux. All of them are installed

> successfully.

>

>

>

> I have properly installed Psycopg in the zope path i.e.

> (lib/python/Products) & that too with proper permissions.

>

>

>

> Now after installing psycopg, when I restart zope, I am not able to see
the

> option ‘Add ZPsycopg Database Connection’ in the Zope Management Screen.

>

>

>

> And because of that I am not able to setup a database for the project.

>

>

>

> I request you to please help me for this. Any advice from you will really

> help me in a great way.

>

>

>

> Kindly suggest me something.

>

>

>

> Thanks a lot!!

>

>

>

>

>

> Thanks & Regards,

>

> Smita Kamdar

>

>

> _______________________________________________

> Zope-DB mailing list

> Zope-DB [at] zope

> https://mail.zope.org/mailman/listinfo/zope-db

>

>

charlie at egenix

Nov 17, 2010, 3:13 AM

Post #2 of 6 (1599 views)
Permalink

Re: Fwd: Zope_Database_issue [In reply to]

Am 17.11.10 12:07, schrieb smita kamdar:
> Hi,
>
> Thanks a lot for your suggestion!!
>
> But I am specifically told to use ZPsycopgDA to connect zope & postgres. I
> am trying a lot to add a new ZPsycopg database connection from Zope
> Management Interface screen, But that option does not exist in Add drop -box
> of Zope Management Interface screen. Should Zope software home & zope
> Instance home be same?? If no then where should I install ZPsycopgDA??
>
> Also do I need to install anything else other than ZPsycopgDA to connect
> zope & postgres?
>
> I am using Zope 2.11.4, python 2.4.4, Postgres 7.4.13, egenix 2.0.6 &
> Psycopg 1.1.6
>
> I am really in a mess! Really need your help!

Hi Smita,

if you can start Zope from the shell:

bin/zopetcl fg

You should get a Python traceback that says what is stopping the ZPsycopgDA
starting.

Charlie Clark
--
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 [at] zope
https://mail.zope.org/mailman/listinfo/zope-db

smita.kamdar00 at gmail

Nov 19, 2010, 5:40 AM

Post #3 of 6 (1596 views)
Permalink

Fwd: Zope_Database_issue [In reply to]

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:

[test [at] tes 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

michele.marcionelli at math

Nov 19, 2010, 5:46 AM

Post #4 of 6 (1594 views)
Permalink

Re: Fwd: Zope_Database_issue [In reply to]

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:
>
>
> [test [at] tes 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 [at] zope
> 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.marcionelli [at] math
http://www.math.ethz.ch/~michele

+41 44 632 6193 Telefon
+41 44 632 1354 Fax

lists at zopyx

Nov 19, 2010, 5:47 AM

Post #5 of 6 (1592 views)
Permalink

Re: Fwd: Zope_Database_issue [In reply to]

-----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:
>
>
>
> [test [at] tes 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 [at] zope
> 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-----

Attachments:

lists.vcf (0.31 KB)

charlie at egenix

Nov 19, 2010, 8:27 AM

Post #6 of 6 (1590 views)
Permalink

Re: Fwd: Zope_Database_issue [In reply to]

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 [at] zope
https://mail.zope.org/mailman/listinfo/zope-db

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads