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

[Gary Fu]

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 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
>>>>>