Tatsuo,
I tried the patch for 'configure.in' without rebuilding 8.4.4 with SSL
and still
got the same error.
I'll have SA to rebuild the 8.4.4 with SSL support to see what happen.
Thanks,
Gary
After more investigation, I found serious problem with pgpool's
configure script if SSL is enabled: it does not add any linkage to
libraries SSL support needes. Included is a patch which should fix the
problem. The reason why it has not been identified until today was,
pgpool links libpq which includes neccessary references to those SSL
related libarires if SSL support is enabled in PostgreSQL.
Gary, I suspect your 8.4.4 build is made without SSL support. Can you
ask your SA to fix it?
Or please use included patches to fix pgpool(I'm going to commit to
2.3-STABLE tree). Though you cannot enable SSL support in pgpool-II.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
Probably your SA forgot to install PostgreSQL dev packages?
I saw similar complains in the list:
http://archives.postgresql.org/pgsql-bugs/2009-09/msg00286.php
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
No, I don't see libdl.so listed with ldd command. What should I do ?
I think our SA installed the 8.4.4 from the Mandriva rpm without
building it
from scratch. Is this the problem ?
9:15am 3 g...@nppdist:~> ldd /usr/local/pgsql/lib/libpq.so.5
linux-gate.so.1 => (0xffffe000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x4014c000)
libc.so.6 => /lib/i686/libc.so.6 (0x4017a000)
/lib/ld-linux.so.2 (0x80000000)
Thanks,
Gary
What does ldd show against libpq?
Mine is:
$ ldd /usr/local/pgsql/lib/libpq.so.5
linux-gate.so.1 => (0xffffe000)
libssl.so.4 => /lib/libssl.so.4 (0xb7f4c000)
libcrypto.so.4 => /lib/libcrypto.so.4 (0xb7e43000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0xb7e15000)
libc.so.6 => /lib/i686/libc.so.6 (0xb7cf3000)
libdl.so.2 => /lib/libdl.so.2 (0xb7cef000)
/lib/ld-linux.so.2 (0x80000000)
Do you have libdl.so shown?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
After upgraded postgresql from 8.4.2 to 8.4.4, I have problem to run the
pgool II 2.3.3 with the following error message:
/pgpool: symbol lookup error: /usr/local/pgsql/lib/libpq.so.5: undefined
symbol: dlopen
When I tried to rebuild the pgpool II 2.3.3, the 'configure' failed with
the following message:
configure:24789: result: no
configure:24799: error: libpq is not installed or libpq is old
In the 'config.log' file, I found the following message:
configure:24727: checking for PQexecPrepared in -lpq
configure:24757: gcc -o conftest -g -O2 -Wall -Wmissing-prototypes
-Wmissing-declarations -L/home/gfu/pgpool2/tmp_lib conftest.c -lpq
-lcrypt -lresolv -lnsl -lm >&5
/home/gfu/pgpool2/tmp_lib/libpq.so: undefined reference to `dlsym'
/home/gfu/pgpool2/tmp_lib/libpq.so: undefined reference to `dlerror'
/home/gfu/pgpool2/tmp_lib/libpq.so: undefined reference to `dladdr'
/home/gfu/pgpool2/tmp_lib/libpq.so: undefined reference to `dlopen'
/home/gfu/pgpool2/tmp_lib/libpq.so: undefined reference to `dlclose'
collect2: ld returned 1 exit status
configure:24763: $? = 1
configure: failed program was:
| /* confdefs.h. */
|
| #define PACKAGE_NAME ""
| #define PACKAGE_TARNAME ""
| #define PACKAGE_VERSION ""
| #define PACKAGE_STRING ""
Does anyone know what's the problem and how to resolve it ?
Thanks,
Gary
_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general
