[Zope] HELP: ZPyGreSQLDA doesn't work, db.py does.

Evan Simpson evan@tokenexchange.com
Fri, 28 May 1999 12:29:30 -0500


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