> Ah well, we found some new bugs anyway... Apropos :-)
I have plenty of bugs that break down to (my) human failure in fact, here's another... My best friend is the compiling-the-postgres-driver-situation. Vlad knows, he often helps me with that but it's a neverending story. The base of the problem is we always compile Postgres from source and have no default installation directories. Example: Naviserver in /usr/local/nsroot_production Postgres in /u01/pgsql8.2.4-dev Say I checkout the modules/nsdbpg and try to compile, giving only the NAVISERVER variable: gmake NAVISERVER=/usr/local/nsroot_production/ gcc -pipe -O2 -fomit-frame-pointer -Wall -Wno-implicit-int -fPIC -pipe -I/usr/local/nsroot_production//include -I"/usr/local/nsroot_production/include" -DHAVE_CONFIG_H -c -o nsdbpg.o nsdbpg.c In file included from nsdbpg.c:37: dbpg.h:44:22: error: libpq-fe.h: No such file or directory In file included from nsdbpg.c:37: dbpg.h:52: error: expected specifier-qualifier-list before ‘PGconn’ [... lots of errors following] I try to be more specific: gmake NAVISERVER=/usr/local/nsroot_production \ CFLAGS="-I/u01/pgsql8.2.4-dev/lib \ -I/u01/pgsql8.2.4-dev/include \ -I/usr/local/nsroot_staging/include" (Some warnings, but finally:) gcc -pipe -shared -nostartfiles -L/usr/local/nsroot_production/lib -o nsdbpg.so nsdbpg.o tclcmds.o -lnsdb -lpq -lnsthread -lnsd -L/usr/local/nsroot_production/lib -ltcl8.4 -ldl -lgcc_s -lieee -lm -Wl,--export-dynamic -L/usr/local/nsroot_production/lib -Wl,-rpath,/usr/local/nsroot_production/lib /usr/lib/gcc/i586-suse-linux/4.1.0/../../../../i586-suse-linux/bin/ld: cannot find -lpq collect2: ld returned 1 exit status make: *** [nsdbpg.so] Error 1 So, after trying various things, I edited the Makefile and changed the line: MODLIBS = -lnsdb -lpq to MODLIBS = -L/usr/local/nsroot_production/include/nsdb.h -L/u01/pgsql8.2.4-dev/lib/libpq.a (or) = -lnsdb -L/u01/pgsql8.2.4-dev/lib/libpq.a and hey! that does it - theres the nsdbpg.so But: ldd nsdbpg.so linux-gate.so.1 => libnsdb.so => /usr/local/nsroot_production/lib/libnsdb.so libnsthread.so => /usr/local/nsroot_production/lib/libnsthread.so libnsd.so => /usr/local/nsroot_production/lib/libnsd.so libtcl8.4.so => /usr/local/nsroot_production/lib/libtcl8.4.so libdl.so.2 => /lib/libdl.so.2 libgcc_s.so.1 => /lib/libgcc_s.so.1 libm.so.6 => /lib/libm.so.6 libc.so.6 => /lib/libc.so.6 libz.so.1 => /lib/libz.so.1 libcrypt.so.1 => /lib/libcrypt.so.1 libpthread.so.0 => /lib/libpthread.so.0 /lib/ld-linux.so.2 This one does not work (" undefined symbol: PQsetdbLogin"), because of libpq et. al. missing. If I compare it with this working driver (and I simpy can't tell anymore what I made different with that one): (ignore the "not found" messages as I don't set the LD_LIBRARY_PATH, but this driver works then): linux-gate.so.1 => libnsdb.so => not found libpq.so.4 => /usr/lib/libpq.so.4 libnsthread.so => not found libnsd.so => not found libtcl8.4.so => /usr/lib/libtcl8.4.so libdl.so.2 => /lib/libdl.so.2 libcrypt.so.1 => /lib/libcrypt.so.1 libz.so.1 => /lib/libz.so.1 libgcc_s.so.1 => /lib/libgcc_s.so.1 libm.so.6 => /lib/libm.so.6 libc.so.6 => /lib/libc.so.6 libssl.so.0.9.8 => /usr/lib/libssl.so.0.9.8 libcrypto.so.0.9.8 => /usr/lib/libcrypto.so.0.9.8 libkrb5.so.3 => /usr/lib/libkrb5.so.3 libresolv.so.2 => /lib/libresolv.so.2 libnsl.so.1 => /lib/libnsl.so.1 libpthread.so.0 => /lib/libpthread.so.0 /lib/ld-linux.so.2 libk5crypto.so.3 => /usr/lib/libk5crypto.so.3 libcom_err.so.2 => /lib/libcom_err.so.2 libkrb5support.so.0 => /usr/lib/libkrb5support.so.0 Maybe it's something really simple to change? Something obvious? Bernd. ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ naviserver-devel mailing list naviserver-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/naviserver-devel