|
Keith Randall
randallk at cpsc.ucalgary.ca
Mon Nov 24 09:37:03 EST 2003
On Mon, 24 Nov 2003, Julian Ciccale wrote: > Which python version are you using? > > Are you sure the python interpreter that you use from the command line and the one that gets called wihthin httpd are the same? > > Check it with > import sys > print sys.version > Yep, they're the same: apache: [Mon Nov 24 09:05:06 2003] [notice] Apache/2.0.48 (Unix) mod_python/3.1.2b Python/2.3.2 configured vs. python -v Python 2.3.2 (#2, Nov 12 2003, 23:39:57) [GCC 3.2.2 20030222 (Red Hat Linux 3.2.2-5)] on linux2 (and there's only one 2.3.2 installed ). sys.path is identical for both as well ( except for the script's own directory, which is chrooted to htdocs by apache as expected.) Also the path to pyPgSQL is readable by all, everything was built from source, no rpms. python 2.3.2 pyPgSQL 2.4 mod_python 3.1.2b apache 2.0.48 postgresql 7.4 Keith > > On Monday, November 24, 2003, at 07:02AM, Keith Randall <randallk at cpsc.ucalgary.ca> wrote: > > > > >Hi, > > > >I have a script that works fine with mod_python 2.7.8 + apache 1.3.28, > >and I want to run it under apache 2.0.48 with mod_python 3.1.2b for > >the session handling stuff. > > > >When I try to connect to my postgresql database in the following way: > > > >from pyPgSQL import PgSQL > >pdb = PgSQL.connect( host = 'foo' , port='5432',database='foo',user='joe') > > > > > >Apache error_log says: > > > >PythonHandler mod_python.publisher: AttributeError: 'module' object has no attribute 'connect' > > > >and indeed when I do a dir(pgSQL), it lists no connect function. > >When I do the same outside apache/mod_python I can see the connect function. > > > >Any thoughts? > > > > > >dir(PgSQL) > >running within mod_python: > > > >['BooleanType', 'BufferType', 'BuiltinFunctionType', > >'BuiltinMethodType', 'ClassType', 'CodeType', 'ComplexType', > >'DateTime', 'DictProxyType', 'DictType', 'DictionaryType', > >'EllipsisType', 'FileType', 'FloatType', 'FrameType', 'FunctionType', > >'GeneratorType', 'InstanceType', 'IntType', 'LambdaType', 'ListType', > >'LongType', 'MethodType', 'ModuleType', 'NoneType', > >'NotImplementedType', 'ObjectType', 'SliceType', 'StringType', > >'StringTypes', 'TracebackType', 'TupleType', 'TypeType', > >'UnboundMethodType', 'UnicodeType', 'XRangeType', '__builtins__', > >'__doc__', '__file__', '__name__', 'copy', 'getdefaultencoding', > >'getrefcount', 'new', 'noWeakRef', 're', 'string', 'sys', 'weakref'] > > > >dir(PgSQL) > >running outside mod_python: > > > >['BAD_RESPONSE', 'BINARY', 'BOOLEAN', 'BooleanType', 'BufferType', > >'BuiltinFunctionType', 'BuiltinMethodType', 'COMMAND_OK', > >'CONNECTION_BAD', 'CONNECTION_OK', 'COPY_IN', 'COPY_OUT', 'ClassType', > >'CodeType', 'ComplexType', 'Connection', 'Cursor', 'DATETIME', > >'DBAPITypeObject', 'DataError', 'DatabaseError', 'Date', > >'DateFromTicks', 'DateTime', 'DateTimeDelta', 'DateTimeDeltaType', > >'DateTimeType', 'DictProxyType', 'DictType', 'DictionaryType', > >'EMPTY_QUERY', 'EllipsisType', 'Error', 'FATAL_ERROR', 'FileType', > >'FloatType', 'FrameType', 'FunctionType', 'GeneratorType', > >'HAVE_LONG_LONG_SUPPORT', 'INV_READ', 'INV_SEEK_CUR', 'INV_SEEK_END', > >'INV_SEEK_SET', 'INV_WRITE', 'InstanceType', 'IntType', > >'IntegrityError', 'InterfaceError', 'InternalError', 'LambdaType', > >'ListType', 'LongType', 'MethodType', 'ModuleType', 'NONFATAL_ERROR', > >'NUMBER', 'NoneType', 'NotImplementedType', 'NotSupportedError', > >'OTHER', 'ObjectType', 'OperationalError', 'PG_ABSTIME', 'PG_ACLITEM', > >'PG_BIGINT', 'PG_BLOB', 'PG_BOOL', 'PG_BOX', 'PG_BPCHAR', 'PG_BYTEA', > >'PG_CASH', 'PG_CHAR', 'PG_CID', 'PG_CIDR', 'PG_CIRCLE', 'PG_DATE', > >'PG_FLOAT', 'PG_FLOAT4', 'PG_FLOAT8', 'PG_False', 'PG_INET', > >'PG_INT2', 'PG_INT2VECTOR', 'PG_INT4', 'PG_INT8', 'PG_INTEGER', > >'PG_INTERVAL', 'PG_LINE', 'PG_LSEG', 'PG_MACADDR', 'PG_MONEY', > >'PG_NAME', 'PG_NUMERIC', 'PG_OID', 'PG_OIDVECTOR', 'PG_PATH', > >'PG_POINT', 'PG_POLYGON', 'PG_REFCURSOR', 'PG_REGPROC', 'PG_RELTIME', > >'PG_ROWID', 'PG_SMALLINT', 'PG_TEXT', 'PG_TID', 'PG_TIME', > >'PG_TIMESTAMP', 'PG_TIMESTAMPTZ', 'PG_TIMETZ', 'PG_TINTERVAL', > >'PG_True', 'PG_UNKNOWN', 'PG_VARBIT', 'PG_VARCHAR', 'PG_XID', > >'PG_ZPBIT', 'POLLING_ACTIVE', 'POLLING_FAILED', 'POLLING_OK', > >'POLLING_READING', 'POLLING_WRITING', 'PQconndefaults', 'PQconnectdb', > >'PQftypeName', 'PQresStatus', 'PQresType', 'PgArray', 'PgBoolean', > >'PgBooleanFromInteger', 'PgBooleanFromString', 'PgBooleanType', > >'PgBytea', 'PgConnectionType', 'PgInt2', 'PgInt2Type', 'PgInt8', > >'PgInt8Type', 'PgLargeObject', 'PgLargeObjectType', 'PgMoney', > >'PgNumeric', 'PgOther', 'PgQuoteBytea', 'PgQuoteString', > >'PgResultSet', 'PgResultType', 'PgTypes', 'PgUnQuoteBytea', > >'PgVersion', 'PgVersionType', 'ProgrammingError', 'RESULT_DDL', > >'RESULT_DML', 'RESULT_DQL', 'RESULT_EMPTY', 'RESULT_ERROR', 'ROWID', > >'STRING', 'SliceType', 'StringType', 'StringTypes', 'TUPLES_OK', > >'Time', 'TimeFromTicks', 'Timestamp', 'TimestampFromTicks', > >'TracebackType', 'TupleType', 'TypeCache', 'TypeType', > >'UnboundMethodType', 'UnicodeType', 'Warning', 'XRangeType', > >'__builtins__', '__doc__', '__file__', '__name__', '_handleArray', > >'_quote', '_quoteall', 'apilevel', 'connect', 'copy', > >'dateTimeDelta2Interval', 'fetchReturnsList', 'getdefaultencoding', > >'getrefcount', 'libpq', 'make_PgResultSetClass', 'new', > >'noPostgresCursor', 'noWeakRef', 'paramstyle', 're', 're_4UP', > >'re_DQL', 're_DRI', 're_DRT', 'replace', 'string', 'sys', > >'threadsafety', 'version', 'weakref'] > > > > > >httpd.conf: > > > >LoadModule python_module /var/www2/modules/mod_python.so > ><Directory /var/www2/htdocs/billing> > >SetHandler python-program > >PythonHandler mod_python.publisher > ></Directory> > > > > > >_______________________________________________ > >Mod_python mailing list > >Mod_python at modpython.org > >http://mailman.modpython.org/mailman/listinfo/mod_python > > > > > _______________________________________________ > Mod_python mailing list > Mod_python at modpython.org > http://mailman.modpython.org/mailman/listinfo/mod_python >
|