Re: [Pgpool-general] problem to build pgpool II 2.3.3 with postgresql 8.4.4
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 = (0xe000) libcrypt.so.1 = /lib/libcrypt.so.1 (0x4014c000) libc.so.6 = /lib/i686/libc.so.6 (0x4017a000) /lib/ld-linux.so.2 (0x8000) Thanks, Gary What does ldd show against libpq? Mine is: $ ldd /usr/local/pgsql/lib/libpq.so.5 linux-gate.so.1 = (0xe000) 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 (0x8000) 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 Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general
Re: [Pgpool-general] problem to build pgpool II 2.3.3 with postgresql 8.4.4
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 = (0xe000) libcrypt.so.1 = /lib/libcrypt.so.1 (0x4014c000) libc.so.6 = /lib/i686/libc.so.6 (0x4017a000) /lib/ld-linux.so.2 (0x8000) Thanks, Gary What does ldd show against libpq? Mine is: $ ldd /usr/local/pgsql/lib/libpq.so.5 linux-gate.so.1 = (0xe000) 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 (0x8000) 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 Index: configure.in === RCS file: /cvsroot/pgpool/pgpool-II/configure.in,v retrieving revision 1.35 diff -c -r1.35 configure.in *** configure.in17 Apr 2010 08:56:57 - 1.35 --- configure.in30 May 2010 02:47:55 - *** *** 292,297 --- 292,300 AC_MSG_WARN([header file openssl/ssl.h is required for SSL]) fi ]) + +AC_CHECK_LIB(crypto, CRYPTO_new_ex_data, [], [AC_MSG_ERROR([library 'crypto' is required for OpenSSL])]) +AC_CHECK_LIB(ssl,SSL_library_init, [], [AC_MSG_ERROR([library 'ssl' is required for OpenSSL])]) fi AC_ARG_WITH(pam, ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general
Re: [Pgpool-general] problem to build pgpool II 2.3.3 with postgresql 8.4.4
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 = (0xe000) libcrypt.so.1 = /lib/libcrypt.so.1 (0x4014c000) libc.so.6 = /lib/i686/libc.so.6 (0x4017a000) /lib/ld-linux.so.2 (0x8000) Thanks, Gary What does ldd show against libpq? Mine is: $ ldd /usr/local/pgsql/lib/libpq.so.5 linux-gate.so.1 = (0xe000) 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 (0x8000) 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 Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general
Re: [Pgpool-general] problem to build pgpool II 2.3.3 with postgresql 8.4.4
What does ldd show against libpq? Mine is: $ ldd /usr/local/pgsql/lib/libpq.so.5 linux-gate.so.1 = (0xe000) 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 (0x8000) 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 Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general
[Pgpool-general] problem to build pgpool II 2.3.3 with postgresql 8.4.4
Hi, 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 Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general