Thread: No lidbl.so in libpq.so (postgresql 8.4.4)

No lidbl.so in libpq.so (postgresql 8.4.4)

From
Gary Fu
Date:
Hi,

On my mandriva linux, I don't have problem to build pgpool 2.3.3 with
postgresql 8.4.2.  But when I upgraded to 8.4.4, I cannot build pgpool
again due to the libdl.so is not required in libpq.so (from the ldd
command).  Do you know how to build the 8.4.4 so that libdl.so is
required in libpq.so ?

10:16am 32 gfu@nppdist:~/postgres/postgresql-8.4.4> locate libdl
/lib/libdl-2.6.1.so
/lib/libdl.so.2

10:16am 33 gfu@nppdist:~/postgres/postgresql-8.4.4> ldd
./src/interfaces/libpq/libpq.so
    linux-gate.so.1 =>  (0xffffe000)
    libcrypt.so.1 => /lib/libcrypt.so.1 (0x40026000)
    libc.so.6 => /lib/i686/libc.so.6 (0x40054000)
    /lib/ld-linux.so.2 (0x80000000)


Thanks,
Gary

Re: No lidbl.so in libpq.so (postgresql 8.4.4)

From
Nilesh Govindarajan
Date:
On Tue, May 25, 2010 at 7:48 PM, Gary Fu <gary.fu@sigmaspace.com> wrote:
> Hi,
>
> On my mandriva linux, I don't have problem to build pgpool 2.3.3 with
> postgresql 8.4.2.  But when I upgraded to 8.4.4, I cannot build pgpool again
> due to the libdl.so is not required in libpq.so (from the ldd command).  Do
> you know how to build the 8.4.4 so that libdl.so is required in libpq.so ?
>
> 10:16am 32 gfu@nppdist:~/postgres/postgresql-8.4.4> locate libdl
> /lib/libdl-2.6.1.so
> /lib/libdl.so.2
>
> 10:16am 33 gfu@nppdist:~/postgres/postgresql-8.4.4> ldd
> ./src/interfaces/libpq/libpq.so
>        linux-gate.so.1 =>  (0xffffe000)
>        libcrypt.so.1 => /lib/libcrypt.so.1 (0x40026000)
>        libc.so.6 => /lib/i686/libc.so.6 (0x40054000)
>        /lib/ld-linux.so.2 (0x80000000)
>
>
> Thanks,
> Gary
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>


Could you please explain a little more what you want to do actually ?

--
Nilesh Govindarajan
Facebook: nilesh.gr
Twitter: nileshgr
Website: www.itech7.com

Re: No lidbl.so in libpq.so (postgresql 8.4.4)

From
Nilesh Govindarajan
Date:
On Fri, May 28, 2010 at 10:13 PM, Gary Fu <gfu@sigmaspace.com> wrote:
> Nilesh Govindarajan wrote:
>>
>> On Tue, May 25, 2010 at 7:48 PM, Gary Fu <gary.fu@sigmaspace.com> wrote:
>>
>>>
>>> Hi,
>>>
>>> On my mandriva linux, I don't have problem to build pgpool 2.3.3 with
>>> postgresql 8.4.2.  But when I upgraded to 8.4.4, I cannot build pgpool
>>> again
>>> due to the libdl.so is not required in libpq.so (from the ldd command).
>>>  Do
>>> you know how to build the 8.4.4 so that libdl.so is required in libpq.so
>>> ?
>>>
>>> 10:16am 32 gfu@nppdist:~/postgres/postgresql-8.4.4> locate libdl
>>> /lib/libdl-2.6.1.so
>>> /lib/libdl.so.2
>>>
>>> 10:16am 33 gfu@nppdist:~/postgres/postgresql-8.4.4> ldd
>>> ./src/interfaces/libpq/libpq.so
>>>       linux-gate.so.1 =>  (0xffffe000)
>>>       libcrypt.so.1 => /lib/libcrypt.so.1 (0x40026000)
>>>       libc.so.6 => /lib/i686/libc.so.6 (0x40054000)
>>>       /lib/ld-linux.so.2 (0x80000000)
>>>
>>>
>>> Thanks,
>>> Gary
>>>
>>> --
>>> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>>> To make changes to your subscription:
>>> http://www.postgresql.org/mailpref/pgsql-general
>>>
>>>
>>
>>
>> Could you please explain a little more what you want to do actually ?
>>
>>
>
> I have the following problem to run 'configure' when building pgpool 2.3.3
> with libpq from normal built of postgreSQL 8.4.4.
>
> configure:24789: result: no
> configure:24799: error: libpq is not installed or libpq is old
>
>
> However, when I rebuilt the 8.4.4 with 'LDFLAGS='-ldl' during configure, I
> don't have problem to build pgpool 2.3.3.
>
> Thanks,
> Gary
>
>
>
>


So your problem is sovled right ? Why worry then ?

--
Nilesh Govindarajan
Facebook: nilesh.gr
Twitter: nileshgr
Website: www.itech7.com

Re: No lidbl.so in libpq.so (postgresql 8.4.4)

From
Tatsuo Ishii
Date:
> On Fri, May 28, 2010 at 10:13 PM, Gary Fu <gfu@sigmaspace.com> wrote:
> > Nilesh Govindarajan wrote:
> >>
> >> On Tue, May 25, 2010 at 7:48 PM, Gary Fu <gary.fu@sigmaspace.com> wrote:
> >>
> >>>
> >>> Hi,
> >>>
> >>> On my mandriva linux, I don't have problem to build pgpool 2.3.3 with
> >>> postgresql 8.4.2.  But when I upgraded to 8.4.4, I cannot build pgpool
> >>> again
> >>> due to the libdl.so is not required in libpq.so (from the ldd command).
> >>>  Do
> >>> you know how to build the 8.4.4 so that libdl.so is required in libpq.so
> >>> ?
> >>>
> >>> 10:16am 32 gfu@nppdist:~/postgres/postgresql-8.4.4> locate libdl
> >>> /lib/libdl-2.6.1.so
> >>> /lib/libdl.so.2
> >>>
> >>> 10:16am 33 gfu@nppdist:~/postgres/postgresql-8.4.4> ldd
> >>> ./src/interfaces/libpq/libpq.so
> >>>       linux-gate.so.1 =>  (0xffffe000)
> >>>       libcrypt.so.1 => /lib/libcrypt.so.1 (0x40026000)
> >>>       libc.so.6 => /lib/i686/libc.so.6 (0x40054000)
> >>>       /lib/ld-linux.so.2 (0x80000000)
> >>>
> >>>
> >>> Thanks,
> >>> Gary
> >>>
> >>> --
> >>> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> >>> To make changes to your subscription:
> >>> http://www.postgresql.org/mailpref/pgsql-general
> >>>
> >>>
> >>
> >>
> >> Could you please explain a little more what you want to do actually ?
> >>
> >>
> >
> > I have the following problem to run 'configure' when building pgpool 2.3.3
> > with libpq from normal built of postgreSQL 8.4.4.
> >
> > configure:24789: result: no
> > configure:24799: error: libpq is not installed or libpq is old
> >
> >
> > However, when I rebuilt the 8.4.4 with 'LDFLAGS='-ldl' during configure, I
> > don't have problem to build pgpool 2.3.3.

He didn't have problem with PostgreSQL 8.4.2+pgpool-II 2.3.3 and he's
wondering why he now starts to have a problem with 8.4.4, I think.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

Re: No lidbl.so in libpq.so (postgresql 8.4.4)

From
Gary Fu
Date:
Nilesh Govindarajan wrote:
> On Tue, May 25, 2010 at 7:48 PM, Gary Fu <gary.fu@sigmaspace.com> wrote:
>
>> Hi,
>>
>> On my mandriva linux, I don't have problem to build pgpool 2.3.3 with
>> postgresql 8.4.2.  But when I upgraded to 8.4.4, I cannot build pgpool again
>> due to the libdl.so is not required in libpq.so (from the ldd command).  Do
>> you know how to build the 8.4.4 so that libdl.so is required in libpq.so ?
>>
>> 10:16am 32 gfu@nppdist:~/postgres/postgresql-8.4.4> locate libdl
>> /lib/libdl-2.6.1.so
>> /lib/libdl.so.2
>>
>> 10:16am 33 gfu@nppdist:~/postgres/postgresql-8.4.4> ldd
>> ./src/interfaces/libpq/libpq.so
>>        linux-gate.so.1 =>  (0xffffe000)
>>        libcrypt.so.1 => /lib/libcrypt.so.1 (0x40026000)
>>        libc.so.6 => /lib/i686/libc.so.6 (0x40054000)
>>        /lib/ld-linux.so.2 (0x80000000)
>>
>>
>> Thanks,
>> Gary
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
>>
>
>
> Could you please explain a little more what you want to do actually ?
>
>
I have the following problem to run 'configure' when building pgpool
2.3.3 with libpq from normal built of postgreSQL 8.4.4.

configure:24789: result: no
configure:24799: error: libpq is not installed or libpq is old


However, when I rebuilt the 8.4.4 with 'LDFLAGS='-ldl' during configure,
I don't have problem to build pgpool 2.3.3.

Thanks,
Gary




Re: No lidbl.so in libpq.so (postgresql 8.4.4)

From
Tom Lane
Date:
Gary Fu <gfu@sigmaspace.com> writes:
> Nilesh Govindarajan wrote:
>> Could you please explain a little more what you want to do actually ?

> I have the following problem to run 'configure' when building pgpool
> 2.3.3 with libpq from normal built of postgreSQL 8.4.4.

> configure:24789: result: no
> configure:24799: error: libpq is not installed or libpq is old

This is a bug in pgpool's configure script, which you should report to
them not us.  It's not our responsibility to supply libdl.

            regards, tom lane

Re: No lidbl.so in libpq.so (postgresql 8.4.4)

From
erobles
Date:

On 05/28/2010 02:16 PM, Tom Lane wrote:
> Gary Fu<gfu@sigmaspace.com>  writes:
>
>> Nilesh Govindarajan wrote:
>>
>>> Could you please explain a little more what you want to do actually ?
>>>
>
>> I have the following problem to run 'configure' when building pgpool
>> 2.3.3 with libpq from normal built of postgreSQL 8.4.4.
>>
>
>> configure:24789: result: no
>> configure:24799: error: libpq is not installed or libpq is old
>>
> This is a bug in pgpool's configure script, which you should report to
> them not us.  It's not our responsibility to supply libdl.
>
>             regards, tom lane
>
>


run pgpool's configure with the options:

--with-psql=/dir/where/you/have/pg844
--with-psql-includedir=/dir/dir/where/you/have/pg844/include
--with-psql-libdir=/dir/dir/where/you/have/pg844/lib

Re: No lidbl.so in libpq.so (postgresql 8.4.4)

From
Tatsuo Ishii
Date:
> Gary Fu <gfu@sigmaspace.com> writes:
> > Nilesh Govindarajan wrote:
> >> Could you please explain a little more what you want to do actually ?
>
> > I have the following problem to run 'configure' when building pgpool
> > 2.3.3 with libpq from normal built of postgreSQL 8.4.4.
>
> > configure:24789: result: no
> > configure:24799: error: libpq is not installed or libpq is old
>
> This is a bug in pgpool's configure script, which you should report to
> them not us.  It's not our responsibility to supply libdl.

Starting from pgpool-II 2.3 it provides SSL support and it needs
libssl then libssl needs libdl. Because pgpool's configure does not
link libdl(which is a bug), pgpool relies on libpq's reference to
libdl. Unfortunately libpq does not refer to libdl unless libpq
is configured with SSL support. Probably his PostgreSQL 8.4.4 build
was made without SSL support. Sorry for making a noise.

I'm studying now libpq's build to know how to refer to libdl if SSL is
enabled...
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp