Re: [Zope] compile ZPoPyDA product problems (continued)
Maybe I wasn't clear - my lib directory has the same links and files as yours (my libpq.a is smaller than yours). It's just that ldconfig -v gives me /opt/pgsql/lib: libpq.so.2.1 - libpq.so.2.1 OK, so does mine libpq.so.2.1 = libpq.so.2.1, so not. Exactly what message are you getting now? I'm still getting the same error: At the python interactive prompt, the command import PoPy results in the following: ImportError: /usr/lib/python1.5/site-packages/PoPymodule.so: undefined symbol: PQfsize Any additional help would be greatly appreciated. - Steve There is no reference to libpq.so, and I still receive the same error with import PoPy. I question if I need a libpq.o listing from ldconfig -v or not? Thanks for your prompt replies and help. I really appreciate it. __ Get your Private, Anti-Spam, Free Email at http://e3mil.com and Step into a Friendly Universe! ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] compile ZPoPyDA product problems (continued)
Exactly what message are you getting now? I'm still getting the same error: At the python interactive prompt, the command import PoPy results in the following: ImportError: /usr/lib/python1.5/site-packages/PoPymodule.so: undefined symbol: PQfsize Any additional help would be greatly appreciated. - Steve There is no reference to libpq.so, and I still receive the same error with import PoPy. I question if I need a libpq.o listing from ldconfig -v or not? Thanks for your prompt replies and help. I really appreciate it. Hokay.. go to /opt/pgsql/libs and execute strings libpq.so.2.1 | fgrep PQfsize On my system this returns PQfsize PQfsize If it returns similar on your system, then 1) ld is still not finding the library. This may perhaps be modified by rechecking ld.so.conf and rerunning ldconfig; or you can edit the start script of zope and insert something like export LD_LIBRARY_PATH=/opt/pgsql/lib or, if not, 2) The pgsql library is badly compiled. (get an update, or install your own postgres) Okay, this is really starting to get to me. strings libpq.so.2.1 |grep PQfsize returns: PQfsize PQfsize I checked ld.so.conf and reran ldconfig. I looks as though it knows where the libraries are. No luck. I did an export LD_LIBRARY_PATH=/opt/pgsql/lib export shows that it was recognized. Still No luck. The PostgreSQL install was compiled from the 7.0.2 source. I'm beginning to think the problem is in the PoPy source - ZPyGreSQLDA works just fine, and I think it's using the same libraries. I just downloaded the ZPoPy-1.3.3 tarball - still no luck yet, post to follow. Thanks again for all of your help, and if you can thnk of anything else... - Steve __ Get your Private, Anti-Spam, Free Email at http://e3mil.com and Step into a Friendly Universe! ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] compile ZPoPyDA product problems (continued)
On Fri, 04 August 2000, [EMAIL PROTECTED] wrote: On Fri, Aug 04, 2000 at 11:42:38AM -0700, Stephen Nosal wrote: OK, to start another line entirely-- does psql work? Sure does - no problems at all. Even have a database up and running with users... - Steve __ Get your Private, Anti-Spam, Free Email at http://e3mil.com and Step into a Friendly Universe! ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] compile ZPoPyDA product problems (continued)
Sorry, but I had one guy complain about PoPY, and psql did not even run! He was connecting to a very old pg on a sun with a recent libpg on Linux. What does ldd psql say? Crap, mine is statically linked. OK, what is ldd /whatever_the_path_is/PoPy_...? root@fastclose:~ ldd /usr/lib/python1.5/site-packages/PoPymodule.so libc.so.6 = /lib/libc.so.6 (0x4001) /lib/ld-linux.so.2 = /lib/ld-linux.so.2 (0x8000) and root@fastclose:~ ldd /opt/pgsql/bin/psql libpq.so.2.1 = /opt/pgsql/lib/libpq.so.2.1 (0x4001c000) libcrypt.so.1 = /lib/libcrypt.so.1 (0x4002a000) libnsl.so.1 = /lib/libnsl.so.1 (0x40057000) libdl.so.2 = /lib/libdl.so.2 (0x4006e000) libm.so.6 = /lib/libm.so.6 (0x40072000) libutil.so.1 = /lib/libutil.so.1 (0x4008f000) libreadline.so.4.0 = /lib/libreadline.so.4.0 (0x40093000) libncurses.so.5 = /lib/libncurses.so.5 (0x400b9000) libc.so.6 = /lib/libc.so.6 (0x40102000) /lib/ld-linux.so.2 = /lib/ld-linux.so.2 (0x4000) So it looks like PoPy isn't even looking for libpq. I am wonderig if PoPy is looking in a particular directory for libpq. - Steve __ Get your Private, Anti-Spam, Free Email at http://e3mil.com and Step into a Friendly Universe! ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev ) __ Get your Private, Anti-Spam, Free Email at http://e3mil.com and Step into a Friendly Universe! ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] compile ZPoPyDA product problems (continued)
Alright, slowly but surely. I've checked out ld.so.conf and the libraries appear to be setup correctly. The output of ldconfig -v shows (among other things): /opt/pgsql/lib: libpq.so.2.1 - libpq.so.2.1 * There is no entry for the generic libpq.so * libpq.so is a link to libpq.so.2.1 Is this potentially the problem? Are there solutions? Thanks for all of the help already. - Steve On Tue, 01 August 2000, [EMAIL PROTECTED] wrote: On Tue, Aug 01, 2000 at 02:01:45PM -0700, Stephen Nosal wrote: Well, I'm getting somewhere. The make and make install on the PoPymodule completed with no errors, but now in python the import PoPy returns the following: Traceback (innermost last): File "stdin", line 1, in ? ImportError: /usr/lib/python1.5/site-packages/PoPymodule.so: undefined symbol: PQfsize This is defined in libpq, so, it appears that PoPy is doing using libpq as a shared library. This makes sense. Now, you know where libpq lives. edit (as root) /etc/ld.so.conf. Add the path to the library as the last line in this file. Then run ldconfig. You might want to man ld.so and man ldconfig before you do this. This is not the kind of info to take on blind trust. This is from the PoPy-1.2.1 tarball. On another note, ZPyGreSQLDA appears to be up and running. Thanks for all of the help. - Steve On Tue, 01 August 2000, [EMAIL PROTECTED] wrote: On Tue, Aug 01, 2000 at 10:54:50AM -0700, Stephen Nosal wrote: Folks - I could use a hand here - I'm trying to compile the PoPy module for python so I can use the ZPoPyDA to connect to my PostgreSQL database. I keep getting the same compile error - gcc - shared PoPymodule.o -lpq -o PoPymodule.so /usr/i486-suse-linux/bin/ld: cannot find -lpq I have compiled other binaries on this machine, including Zope 2.2. Python runs fine, I just don't know enough about ld to understand the error. (I get the same error trying to compile ZPyGreSQLDA. This message is saying that the postgres library libpq cannot be found by the linker (postgres was formerly called PostQuel, hence pq). Not having Suse, which I have heard has somewhat unusual layout, I cannot tell you for sure what to do... but try find / -name "libpq*" THis should find any libpq's on your system Then if libpq is in /usr/lib/foo, do export LD_LIBRARY_PATH=/usr/lib/foo gcc - shared PoPymodule.o -lpq -o PoPymodule.so Any pointers would be greatly appreciated. - Steve __ Get your Private, Anti-Spam, Free Email at http://e3mil.com and Step into a Friendly Universe! ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev ) __ Get your Private, Anti-Spam, Free Email at http://e3mil.com and Step into a Friendly Universe! ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev ) __ Get your Private, Anti-Spam, Free Email at http://e3mil.com and Step into a Friendly Universe! ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] compile ZPoPyDA product problems (continued)
On Wed, 02 August 2000, [EMAIL PROTECTED] wrote: On Wed, Aug 02, 2000 at 08:51:14AM -0700, Stephen Nosal wrote: Alright, slowly but surely. I've checked out ld.so.conf and the libraries appear to be setup correctly. The output of ldconfig -v shows (among other things): /opt/pgsql/lib: libpq.so.2.1 - libpq.so.2.1 * There is no entry for the generic libpq.so * libpq.so is a link to libpq.so.2.1 Is this potentially the problem? Are there solutions? Actually, I am not so sure there. My /usr/lib (debian) has these links. -rw-r--r--1 root root88666 Jul 24 17:15 libpq.a lrwxrwxrwx1 root root 12 Jul 26 11:44 libpq.so - libpq.so.2.1 lrwxrwxrwx1 root root 12 Jul 26 11:44 libpq.so.2 - libpq.so.2.1 -rw-r--r--1 root root66296 Jul 24 17:15 libpq.so.2.1 Maybe I wasn't clear - my lib directory has the same links and files as yours (my libpq.a is smaller than yours). It's just that ldconfig -v gives me /opt/pgsql/lib: libpq.so.2.1 - libpq.so.2.1 There is no reference to libpq.so, and I still receive the same error with import PoPy. I question if I need a libpq.o listing from ldconfig -v or not? Thanks for your prompt replies and help. I really appreciate it. As root, you can cd /opt/pgsql/lib and ln -s libpq.so.2.1 libpq.so and then you will have the link! __ Get your Private, Anti-Spam, Free Email at http://e3mil.com and Step into a Friendly Universe! ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )