[Zope-DB] ZPyscopyDA installation gudie

CY cyhoong@pc.jaring.my
Tue, 15 Apr 2003 17:00:08 +0800

You may be better off uinsg mxODBCDA from egenix on Windows platform.
RedHat had stopped development on cygwin.

I do not think there is any installation guide.  This is my own guide for
your perusal which I believe it will be similar on Win2K platform.


Platform: Redhat Linux
General Note:
Install the tarball per the directions.
You can test to make sure the package was installed correctly by starting a
python shell and issueing the command
import mx.DateTime.   It should not return anything or check mx module at

i.    login as zadmin (directory's owner)
ii.   tar xvfz egenix-mx-base-2.0.4.tar.gz to $Zope_Dir
iii.  run "$Zope_Dir/bin/python setup.py install"

ZPsycopgDA installation
Download file psycopg-1.0.13.tar.gz, which can be obtained from
http://www.zope.org/Members/fog/psycopg, use the following configuration

i.    login zadmin
ii.   cd $ZOPE_DIR (my case - /opt/zope2)
iii.  ./configure --with-zope=$Zope_Dir  \
me/mxDateTime \
 --with-postgres-includes=/usr/include/pgsql/server \
 --with-postgres-libraries=/usr/lib/pgsql  \
 --with-python-version=2.1 \
iv.   make
v.    make install
vi.   make install-zope

This will create pyscopgmodule.so at /usr/local/lib/python2.1/site-packages.

***Note:  You need to "chmod 0744 $Zope_Dir/lib/python2.1/config/*" before
              The makesetup file is change during the configure.

Start Zope
login as zadmin
cd  $Zope_Dir
./start &

Create Database Connection

1.Select 'add Z Psycopg Database Connection'
2.enter id  -  dbcYourDatabaseName
3.enter connection string - user=zadmin dbname=YourDatabaseName
4.select Add
5.select Browse to test connection

+++++++++++++++++++  GOD BLESS ++++++++++++++++++++