Re: [Zope] problems installing PoPy-1.3.4 (fwd)
There was a patch to the source that fixed this in 1.3.3, but it looks like the same problem is cropping up. I would contact federico ([EMAIL PROTECTED]) and see what he's got to say...he really helped out with my 1.3.x problems. - Steve On Fri, 01 September 2000, Sebastien Billard wrote: I'm on a suse 6.4 system, with postgresql installed. I've got the latest zope installed from tarball.. and I get this problem trying to install PoPy ./autogen.sh --with-postgres-libraries=/usr/lib/pgsql/lib --with-postgres-includes=/usr/lib/pgsql/include loading cache ./config.cache checking for python... /usr/bin/python checking python version... 1.5 checking python installation prefix... /usr checking python installation exec_prefix... /usr checking definitions in Python library makefile... done checking location of python library... $(prefix)/lib/python1.5/site-packages checking location of python shared modules... $(exec_prefix)/lib/python1.5/site-packages checking for PQconnectStart in -lpq... no configure: error: can't build without PostgreSQL libraries Now type 'make' to compile PoPy python module. ___ 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] Newbie SQL problem: Query Error: Cannot render query template
Troy- Have you tried running this from the DOS prompt? I ran into all sorts of problems running 2.1.6 on NT4WS with the ODBCDA. Everything was fine when I used the start and stop scripts from the command line. When I moved to starting zope as a service, my ODBC connections kept failing. Never did find an NT solution, I just moved everything to Linux. It's worth a try. - Steve On Wed, 30 August 2000, "Farrell, Troy" wrote: Hello. I am running Zope as a service on NT4WS. I have multiple MS Access databases connected to different ZJetDAs and I am not able to modify the data in them with SQL statements. For example, INSERT INTO test VALUES (dtml-sqlvar value_one type=string, dtml-sqlvar value_two type=int) returns the error "Query Error: Cannot render query template". Can you tell me what the cause is. I think it might be a permissions problem, but I have everything wide open and I can't figure it out. Thanks. Troy Farrell Troy Farrell Video Operations Technician II Williams VYVX Services 918.573.3029 918.573.1441 fax mailto:[EMAIL PROTECTED] http://www.williams.com ___ 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] ALERT: rally to the flag, troops!
I hate it when this happens - I just had the IS department throw out 2 months of work because it doesn't conform to corporate standards. That's because they have no standard and all the developers do is fight over what vendors to use and who will do the development. I hope your project goes better than mine... Good Luck. - Steve On Thu, 31 August 2000, Jean Jordaan wrote: Hello Zopers This is serious business. As you know, I've been asking questions of various levels of ineptitude during the last few weeks. Meantime I've been building some entry-level ZClasses as part of the insides of Mosaic's Intranet. This culminated in a demo a couple of days ago, when I showed the one CEO and the rest of the communications department what I have been doing. __ 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: [Zope]compile ZPoPyDA product problem (the patch)
Ed - Sorry, I guess it was just sent to me. Please enjoy, and good luck. - Steve --- Start of forwarded message --- Subject: Re: [Zope]compile ZPoPyDA product problem (continued) To: Stephen Nosal [EMAIL PROTECTED] From: [EMAIL PROTECTED] (Federico Di Gregorio) Date: Sat, 5 Aug 2000 10:21:02 +0200 hi, it is my fault. i let a buglet infiltrate the last distribution. you can solve it in two ways: 1/ ln -s /opt/pgsql/lib/libpq.so /usr/lib/libpq.so (dirty!) 2/ apply attached patch 3/ wait a couple of days until 1.3.4 hits the ftp server have fun with popy... ciao, federico p.s. to apply patch: cd /your/popy/directory patch -p1 /the/path/to/the/patch -- Federico Di Gregorio MIXAD LIVE System Programmer [EMAIL PROTECTED] Debian GNU/Linux Developer Italian Press Contact[EMAIL PROTECTED] A short story: I want you. I love you. I'll miss you. -- Me __ Get your Private, Anti-Spam, Free Email at http://e3mil.com and Step into a Friendly Universe! Index: PoPy/ChangeLog diff -u PoPy/ChangeLog:1.27 PoPy/ChangeLog:1.28 --- PoPy/ChangeLog:1.27 Thu Aug 3 12:16:25 2000 +++ PoPy/ChangeLog Sat Aug 5 10:21:06 2000 @@ -1,3 +1,9 @@ +2000-08-05 Federico Di Gregorio [EMAIL PROTECTED] + + * configure.in: fixed bug in --with-postgres-libraries switch. now + the library path is correctly added to LDFLAGS *before* checking + for libpq. + 2000-08-03 Federico Di Gregorio [EMAIL PROTECTED] * Makefile.pre.in: defines VERSION from POPY_VERSION in Index: PoPy/configure.in diff -u PoPy/configure.in:1.10 PoPy/configure.in:1.11 --- PoPy/configure.in:1.10 Thu Aug 3 12:07:14 2000 +++ PoPy/configure.in Sat Aug 5 10:21:06 2000 @@ -8,11 +8,13 @@ dnl postgresql headers and libraries (by default in /usr/lib and dnl /usr/include/postgresql, can be changed with --with-postgres-* options) -AC_ARG_WITH(postgres-libraries, [ --with-postgres-libraries=DIR PostgreSQL libs in DIR [/usr/lib]], PGSQLLIBS="-L $withval", PGSQLLIBS="") +AC_ARG_WITH(postgres-libraries, [ --with-postgres-libraries=DIR PostgreSQL +libs in DIR [/usr/lib]], PGSQLLIBS="-L$withval", PGSQLLIBS="") AC_ARG_WITH(postgres-includes, [ --with-postgres-includes=DIR PostgreSQL includes in DIR [/usr/include/postgresql]], PGSQLFLAGS="-I$withval", PGSQLFLAGS="-I/usr/include/postgresql") +LDFLAGS="$PGSQLLIBS $LDFLAGS" + AC_CHECK_LIB(pq, PQconnectStart, PGSQLLIBS="$PGSQLLIBS -lpq", - AC_MSG_ERROR(can't build without PostgreSQL libraries)) + AC_MSG_ERROR(can't build without PostgreSQL libraries), -lcrypt) AC_SUBST(PGSQLFLAGS) AC_SUBST(PGSQLLIBS)
Re: [Zope] Re: Help with installing PoPy ZPoPyDA
Folks - Federico sent me a patch for the popy-1.3.3 source. I needed it to tell it where the postgresql libraries are..if you need it please let me know and I will send it along. You may also find it in the archives from earlier this month. - Steve On Fri, 11 August 2000, "Hung Jung Lu" wrote: --- In [EMAIL PROTECTED], ed colmar [EMAIL PROTECTED] wrote: Hi, I downloaded the current versions of ZPoPyDA, and PoPy from www.mixadlive.com, and I cannot figure out how to execute the installation. Run the autogen.sh script first, instead of the ./configure. Could you send an e-mail to Eric (one of the authors) [EMAIL PROTECTED]? So things can get fixed properly in the documentation. I've already told him the problem, but in all freeware things, the authors need to be reminded of the problems. After two different users mentioning the same problem, usually it gets fixed. :) __ 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] database functions zope
Folks - How do I execute SQL statements such as select count(*) from db_table? I'm running zope 2.2 with the SybaseDA 2.0b2. My connection to the database works fine, ie select * from small_table where amount1000 produces a valid result set. Using just the DA connection test, the statement select count(*) from db_table comes up with the error: Error Type: ValueError Error Value: Empty column name, Any insight here would be great - I couldn't find anything documented about database functions. - 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] database functions zope
Bob - That did it! Thanks for the quick help and explanation. - Steve On Tue, 08 August 2000, Bob Tierney wrote: One of the requirements of a DA is to return information about the result set columns. Does Sybase give a name to column "count(*)". Some database products do and some don't. Try giving the column an alias name like so select count(*) as total from db_table assuming Sybase supports this of course. Regards, Bob -- Robert E. Tierney[EMAIL PROTECTED] Going Virtualhttp://www.goingv.com 10800 Independence Pointe Pkwy Phone: 1-704-849-0731 x109 Matthews, NC 28105Fax: 1-704-849-2279 AOL-IM: RETierney -- On 8 Aug 2000, Stephen Nosal wrote: Folks - How do I execute SQL statements such as select count(*) from db_table? I'm running zope 2.2 with the SybaseDA 2.0b2. My connection to the database works fine, ie select * from small_table where amount1000 produces a valid result set. Using just the DA connection test, the statement select count(*) from db_table comes up with the error: Error Type: ValueError Error Value: Empty column name, Any insight here would be great - I couldn't find anything documented about database functions. - 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 ) ___ 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] Success! ZPoPyDA 0.6.1 works!
First, I would like to say thanks to everyone, who gave me a hand with this, especially [EMAIL PROTECTED] I learned a lot, and I am more comfortable with my system than ever. Below is a little note and question for Federico, who provided the patch that got the whole thing going again. Thanks again, - Steve Federico - This is the output of my compilation of ZPoPyDA 0.6.1 Two questions: 1) It looks for README before it creates it. 2) Make appears to do nothing. Just trying to figure it all out. - Steve root@fastclose:/opt/src/ZPoPyDA ./autogen.sh --with-zope-datadir=/opt/fastclose automake: configure.in: installing `./install-sh' automake: configure.in: installing `./mkinstalldirs' automake: configure.in: installing `./missing' automake: Makefile.am: installing `./INSTALL' automake: Makefile.am: required file `./README' not found creating cache ./config.cache checking for a BSD compatible install... /usr/bin/ginstall -c checking whether build environment is sane... yes checking whether make sets ${MAKE}... yes checking for working aclocal... found checking for working autoconf... found checking for working automake... found checking for working autoheader... found checking for working makeinfo... found updating cache ./config.cache creating ./config.status creating Makefile creating README Now type 'make' to compile ZPoPyDA. root@fastclose:/opt/src/ZPoPyDA make make: Nothing to be done for `all'. root@fastclose:/opt/src/ZPoPyDA make install make[1]: Entering directory `/opt/src/ZPoPyDA' make[1]: Nothing to be done for `install-exec-am'. install -d /opt/fastclose/lib/python/Products//ZPoPyDA /usr/bin/ginstall -c -m 644 ./PoPyconnectionAdd.dtml PoPyconnectionStatus.dtml PoPyconnectionEdit.dtml PoPyconnectionTestForm.dtml __init__.py PoPy_db.py DA.py README ChangeLog AUTHORS COPYING PoPyconnectionAdd.dtml PoPyconnectionStatus.dtml PoPyconnectionEdit.dtml PoPyconnectionTestForm.dtml __init__.py PoPy_db.py DA.py \ /opt/fastclose/lib/python/Products//ZPoPyDA/ make[1]: Leaving directory `/opt/src/ZPoPyDA' root@fastclose:/opt/src/ZPoPyDA __ 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)
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 )
[Zope] Re:[Zope]compile ZPoPyDA product problem (continued)
Federico - I downloaded PoPy-1.3.3.tgz and I'm running into the following problems: PostgreSQL was compiled from 7.0.2 source from ftp.postgresql.org Run as root: root@fastclose:/opt/src/PoPy ./autogen.sh --with-postgres-libraries=/opt/pgsql/lib --with-postgres-includes=/opt/pgsql/include Results: creating cache ./config.cache checking for python... /usr/bin/python checking python version... 1.5 checking python installation prefix... /usr checking python installation exec_prefix... /usr checking definitions in Python library makefile... done checking location of python library... $(prefix)/lib/python1.5/site-packages checking location of python shared modules... $(exec_prefix)/lib/python1.5/site-packages checking for PQconnectStart in -lpq... no configure: error: can't build without PostgreSQL libraries Now type 'make' to compile PoPy python module. root@fastclose:/opt/src/PoPy What am I missing? the libraries are in /opt/pgsql/lib, the includes in /opt/pgsql/include, posgresql is in /opt/pgsql/bin. I've modified ld.so.conf and run ldconfig, I've also run export LD_LIBRARY_PATH=/opt/pgsql/lib No luck. Please give me a hand here. I've got ZPyGreSQLDA running, but I'm just failing with ZPoPyDA. I'm running a new install of Suse 6.4 Linux. - Steve Thanks. On Wed, 02 August 2000, Federico Di Gregorio wrote: 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 ) __ 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 )
[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 )
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 "stdin", 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 )
[Zope] Zope Sybase DA Zope 2.2
Folks - Anyone have any info or pointers running the Zope Sybase DA Zope 2.2 yet? I'm looking to get it up and running on suse Linux 6.4 and Zope 2.2 connecting to a remote Sybase DB. Love to hear any news on this. Thanks. - 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] Zope Sybase DA Zope 2.2
Haven't gotten that far yet - I'm looking for 'gotchas' before I start. I'm already having a tough time with the open client 11.9.2 - apparently it is not available for download anymore, but still free for development. I'm waiting for Sybase to get back to me on this one. - Steve On Wed, 26 July 2000, Chris McDonough wrote: What's the problem? Does it not work? -Original Message- From: Stephen Nosal [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 26, 2000 10:00 AM To: [EMAIL PROTECTED] Subject: [Zope] Zope Sybase DA Zope 2.2 Folks - Anyone have any info or pointers running the Zope Sybase DA Zope 2.2 yet? I'm looking to get it up and running on suse Linux 6.4 and Zope 2.2 connecting to a remote Sybase DB. Love to hear any news on this. Thanks. - 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 ) ___ 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] Who is uid 506?
Folks - I've installed Zope 2.2 (binary rpm) on my Linux box (suse 6.4) and I notice that many files are owned by uid 506. I don't have a uid 506 on my box. Should I create a zope user with this id? Should I ignore it? - 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 )