Re: [Zope] compile ZPoPyDA product problems (continued)
> > So it looks like PoPy isn't even looking for libpq. > > Agreed. Something is definately wrong with the build! > You might want to try a hand build. My makefile generated this: > > gcc -fPIC -g -O2 -I/usr/include/python1.5 -I/usr/lib/python1.5/config -DHAVE_CO > NFIG_H=1 -DHAVE_POSTGRESQL_LIBPQ_FE_H=1 -DHAVE_POSTGRESQL_LIBPQ_LIBPQ_FS_H=1 - > c ./PoPymodule.c > gcc -shared -lc PoPymodule.o -lpq -o PoPymodule.so > > You might > export LD_LIBRARY_PATH=/opt/psql/lib > > and then execute those commands. Maybe this will fix your PoPY I'll give this a shot when I get back to the office Monday - Thanks for all of your help. - 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)
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)
> > > 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)
> > 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)
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 )
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 "", 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 )
[Zope] Re: [Soft] [Fwd: [Zope] compile ZPoPyDA product problems]
hi, > > I keep getting the same compile error - > > > > gcc - shared PoPymodule.o -lpq -o PoPymodule.so > > /usr/i486-suse-linux/bin/ld: cannot find -lpq > > -Find libpq.so on your machine. > -Edit the last? (going from memory) line of Makefile, adding >-L/directory/that/holds/your_libpq > (just the directory, not the filename) right before -lpq with the new versions of PoPy you can simply do: ./configure --with-postgres-libs=/directory/that/holds/your_libpq ciao, federico -- Federico Di Gregorio MIXAD LIVE System Programmer [EMAIL PROTECTED] Debian GNU/Linux Developer & Italian Press Contact[EMAIL PROTECTED] Debian. The best software from the best people [see above] -- brought to you by One Line Spam ___ 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
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 "", line 1, in ? ImportError: /usr/lib/python1.5/site-packages/PoPymodule.so: undefined symbol: PQfsize 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 )
Re: [Zope] compile ZPoPyDA product problems
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 -Find libpq.so on your machine. -Edit the last? (going from memory) line of Makefile, adding -L/directory/that/holds/your_libpq (just the directory, not the filename) right before -lpq There is certainly a more elegant way to do the same, but it worked for me. > > 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. > > Any pointers would be greatly appreciated. > > - Steve -- Patrick Lewis <[EMAIL PROTECTED]> ___ 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 )
[Zope] compile ZPoPyDA product problems
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. 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 )