Using mod_python apache module - Mailing list pgsql-interfaces

From Jim Hurlburt
Subject Using mod_python apache module
Date
Msg-id 01080219302702.32757@hex.diskworld
Whole thread Raw
List pgsql-interfaces
Sirs:

I have a linux system, a fairly heavly modified version of mandrake 7.1 
(upgraded a piece at a time instead of re-installing)2.4.5 kernelpython 2.1.1postgresql 7.1.2apache 1.3.20mod_python
apachemodule     (requires a copy of python compiled without threads)kde 2.1.1gcc 2.95.3 (came with mandrake)
 

Libraries etc such that all of the above except gcc were compiled on this 
system.

I fetched the tarball of postgresql 7.1.2, mxDateTime and built 
them.  mxDateTime appears to have installed correctly -- at least I can 
import mx.DateTime without an error.
Postgresql appears to have built and installed ok -- initdb worked, I started 
the server and was able to connect to the command line interface, create and 
manipulate tables and users.  Imported data to several tables from 
mysql.

I am in the process of building a web application (database driven mud server 
with attendant world editing capabilities) with a browser interface into the 
dataserver.

I am currently using python, with mod_python on apache, and mysql (MySQLdb) 
as the data engine.

For several reasons, not the least of which is subselects, I wish to move to 
postgresql.  I was able to compile and run the server with only normal hassle 
as I learned how to do it.  However, so far I am unable to use Pygresql, and 
my attempt to use PoPy failed with thread issues vs mod_python.

I sent an e-mail requesting enlightenment to the maintainer of pygresql 
(darcy@druid.net) and have recieved no reply.  I hesitate to bug him -- don't 
know what the customs are.

The results of attempting to use pygresql are --

this test script.
********************************
#!/usr/local/python
import sys, os, re, pg
print "Hello There"

*************************************************************
I got the following set of error messages.

******************************************************************
Traceback (most recent call last): File "./testpg.py", line 3, in ?   import sys, os, re, pg File
"/usr/local/lib/python2.1/pg.py",line 7, in ?   from _pg import *
 
ImportError: /usr/local/lib/python2.1/site-packages/_pgmodule.so: undefined 
symbol: PQoidValue
*******************************************************************

I got essentially the same error message when trying to run one of the test 
scripts in the postgresql source tree.

It would appear to me that either a header file was not found when 
_pgmodule.so was built, or my version of python is not viable for this module.

Any clues?  I would be happy to RTFM if I had any clue as to which manual, 
and what I might be looking for.  
I have dug thru the faq and other on line resources -- attempted to search 
the mailing list archive without success.  One thread that hinted that an 
install script for pygresql might need updating, but if a resolution, or even 
a clear description of the problem it was to solve, was there I didn't find 
it.

Bottom line is that I would like to use postgresql with python and apache.  I 
would much prefer to use the mod_python apache module, but would consider 
different ideas if necessary.

thanks in advance
Jim Hurlburt
Yakima, WA
jlh@yvn.com
A chair by fire -- A cat on the lap -- A drink at hand --A good book   -- Paradise


pgsql-interfaces by date:

Previous
From: Dave Page
Date:
Subject: RE: ODBC driver installation error
Next
From: "Mihai Gheorghiu"
Date:
Subject: Re: ODBC driver installation error