[Pgpool-general] problem to build pgpool II 2.3.3 with postgresql 8.4.4

[Tatsuo Ishii]

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 gfu at 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
-------------- next part --------------
Index: configure.in
===================================================================
RCS file: /cvsroot/pgpool/pgpool-II/configure.in,v
retrieving revision 1.35
diff -c -r1.35 configure.in
*** configure.in	17 Apr 2010 08:56:57 -0000	1.35
--- configure.in	30 May 2010 02:47:55 -0000
***************
*** 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,