[Tutor] pyPgSQL and Slackware 9.1

[nik]

I'm afraid I'm not that familiar with the postgreSQL stuff myself, I'm 
using the firebird database with kinterbasdb. I think there's a 
pypgsql-users forum that might be a better place for an answer 
(http://lists.sourceforge.net/lists/listinfo/pypgsql-users )

Mike Hansen wrote:

> Thanks Nik. Changing the lib in the setup to /usr/local/pgsql/lib got 
> the build to work. The install behaved as well. However, when I run 
> the test cases, I get the failures below. I made a script that 
> connects to a database and prints some records and it seems to work. I 
> am concerned about these failures.
>
> $ python test/PgSQLTestCases.py
> ........................................F.F.......................
> ======================================================================
> FAIL: CheckDoMoreResultObjectChecks (__main__.PgSQLTestCases)
> ----------------------------------------------------------------------
> Traceback (most recent call last):
>  File "test/PgSQLTestCases.py", line 817, in 
> CheckDoMoreResultObjectChecks
>    self.fail(msg)
>  File "/usr/lib/python2.3/unittest.py", line 270, in fail
>    raise self.failureException, msg
> AssertionError: '7.4'
>
> ======================================================================
> FAIL: Test execute() with a singleton string as the parameter.
> ----------------------------------------------------------------------
> Traceback (most recent call last):
>  File "test/PgSQLTestCases.py", line 639, in CheckExecuteWithSingleton
>    "Length of cur.description is %d, it should be %d." %
>  File "/usr/lib/python2.3/unittest.py", line 302, in failUnlessEqual
>    raise self.failureException, \
> AssertionError: Length of cur.description is 11, it should be 4.
>
> ----------------------------------------------------------------------
> Ran 66 tests in 0.854s
>
> FAILED (failures=2)
>
>
> nik wrote:
>
>> I can't help much with your build problem, other than try using;
>> locate libpq
>> to see if the library is on your system (may have to do an updatedb 
>> first), and possibly put a symbolic link into /usr/lib (isn't the 
>> library normally in /usr/local/pgsql/lib ?)
>>
>> but otherwise
>> man hier
>> will give a good description of what goes where in linux...
>>
>> nik
>>
>> Mike Hansen wrote:
>>
>>> I'm having trouble getting _any_ postgre interface module to install 
>>> on one of our Slackware 9.1 servers. I can get around in Linux, but 
>>> pretty green on knowing where things are in Linux. Postgre 7.4.1 is 
>>> up and running on this server.(Many Perl web apps connect to it no 
>>> problem.) Python 2.3.1 is running on this server. Here's what 
>>> happens when I try to run the setup for pyPgSQL module as root:
>>>
>>> # python setup.py build
>>> /usr/lib/python2.3/distutils/dist.py:213: UserWarning: 'licence' 
>>> distribution o
>>> tion is deprecated; use 'license'
>>>  warnings.warn(msg)
>>> running build
>>> running build_py
>>> running build_ext
>>> building 'pyPgSQL.libpq.libpqmodule' extension
>>> gcc -pthread -shared build/temp.linux-i686-2.3/libpqmodule.o 
>>> build/temp.linux-i
>>> 86-2.3/pgboolean.o build/temp.linux-i686-2.3/pgint2object.o 
>>> build/temp.linux-i6
>>> 6-2.3/pgint8object.o build/temp.linux-i686-2.3/pgversion.o 
>>> build/temp.linux-i68
>>> -2.3/pglargeobject.o build/temp.linux-i686-2.3/pgnotify.o 
>>> build/temp.linux-i686
>>> 2.3/pgconnection.o build/temp.linux-i686-2.3/pgresult.o 
>>> build/temp.linux-i686-2
>>> 3/pymemstrdup.o build/temp.linux-i686-2.3/port/strtoll.o 
>>> build/temp.linux-i686-
>>> .3/port/strtoull.o build/temp.linux-i686-2.3/port/strtok.o 
>>> -L/usr/lib -lpq -o b
>>> ild/lib.linux-i686-2.3/pyPgSQL/libpq/libpqmodule.so
>>> /usr/lib/gcc-lib/i486-slackware-linux/3.2.3/../../../../i486-slackware-linux/bi 
>>>
>>> /ld: cannot find -lpq
>>> collect2: ld returned 1 exit status
>>> error: command 'gcc' failed with exit status 1
>>>
>>> Can someone tell what's causing the error? Do I need to tweak the 
>>> setup.py to change where it looks for the files it needs? I started 
>>> with pyPgSQL since I had used it before from Windows. Although as 
>>> long as I get a DB-API 2.0 compliant module working on this server, 
>>> I don't really care about which postgre interface module I use.
>>>
>>> While I'm asking questions, can anyone recommend a linux book that 
>>> discusses the typical directory structure, where to find things, and 
>>> why they are were they are?(If that makes any sense.)
>>>
>>> Thanks,
>>>
>>> Mike
>>> _______________________________________________
>>> Tutor maillist  -  Tutor at python.org
>>> http://mail.python.org/mailman/listinfo/tutor
>>>
>>>
>>
>> _______________________________________________
>> Tutor maillist  -  Tutor at python.org
>> http://mail.python.org/mailman/listinfo/tutor
>
>
> _______________________________________________
> Tutor maillist  -  Tutor at python.org
> http://mail.python.org/mailman/listinfo/tutor
>
>