I've got Zope 1.10.2 working great on a RedHat 5.1 i386 box, with Python 1.51, PostgreSQL 6.3.2, and the latest ZPyGreSQLDA from zope.org. If I run Python in the Products/ZPyGreSQLDA directory, I can do the following:
import db c=db.DB('zope nobody') c.query('select * from person') ([{'width': 4, 'name': 'name', 'type': 't'}, {'width': 5, 'name': 'phone', 'type': 't'}, {'width': 6, 'name': 'salary', 'type': 'n'}, {'width': 8, name': 'children', 'type': 'i'}], [('fred', '555-1212', 0.0, 0)])
I can run queries to my heart's delight, but when I fire up Zope the Product is broken, with: ZPyGreSQLDA Import Traceback Traceback (innermost last): File "/home/evan/Zope-1.10.2-src/lib/python/OFS/Application.py", line 395, in import_products product=__import__(pname, global_dict, global_dict, silly) File "/home/evan/Zope-1.10.2-src/lib/python/Products/ZPyGreSQLDA/__init__.py", line 89, in ? import sys, os, Globals, DA File "/home/evan/Zope-1.10.2-src/lib/python/Products/ZPyGreSQLDA/DA.py", line 91, in ? from db import DB File "/home/evan/Zope-1.10.2-src/lib/python/Products/ZPyGreSQLDA/db.py", line 89, in ? import _pg, regex, sys, types ImportError: /home/evan/Zope-1.10.2-src/lib/python/Products/ZPyGreSQLDA/_pgmodule.so: undefined symbol: PQsocket I compiled _pgmodule.so with -DNO_PQSOCKET. I get the same results when I copy _pgmodule.so to another machine running RedHat 6.0 with PostgreSQL 6.4 can-anyone-help?-<whimper>-ly yr's Evan Simpson