Re: Problem with libpq.so.5 in pgadmin3-1.10.2

Hello,

I installed pgadmin3-1.10.2 and I got an error that might strange...

bash-3.1# /usr/local/pgadmin3/bin/pgadmin3
/usr/local/pgadmin3/bin/pgadmin3: error while loading shared libraries:
libpq.so.5: cannot open shared object file: No such file or directory

I have the libpq.so.5 in /usr/lib and /usr/local/lib.

I installed the wxWidgets 2.8.10, libxslt-1.1.24, libxml2-2.7.4-1 and
postgresql-libs-8.4.2-6.

I'm on Slackware 13 - 64 bit.

Thanks

Le 17/03/2010 14:09, Vinicius Borges a écrit :
> Hello,
>
> I installed pgadmin3-1.10.2 and I got an error that might strange...
>
> bash-3.1# /usr/local/pgadmin3/bin/pgadmin3
> /usr/local/pgadmin3/bin/pgadmin3: error while loading shared libraries:
> libpq.so.5: cannot open shared object file: No such file or directory
>
> I have the libpq.so.5 in /usr/lib and /usr/local/lib.
>
> I installed the wxWidgets 2.8.10, libxslt-1.1.24, libxml2-2.7.4-1 and
> postgresql-libs-8.4.2-6.
>
> I'm on Slackware 13 - 64 bit.
>
> Thanks
>

Can you do the following command:

ldd /usr/local/pgadmin3/bin/pgadmin3

How did you install pgAdmin3? is it a precompiled version?

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com

Please keep the list on CC.

Le 17/03/2010 15:22, Vinicius Borges a écrit :
> #$ ldd /usr/local/pgadmin3/bin/pgadmin3
>[...]
> libpq.so.5 => not found

ldd doesn't find it too. Kind of strange. How did you install libpq? did
you install the 32-bits library? (which would explain where it is
located and why ldd didn't find it). But it won't explain why you could
compile without the library.

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com

Hello,

I saw that libpq.so.5 wasn't in /usr/lib64/. Then I installed libpq.so.5 for
64-bit. from

http://rpm.pbone.net/index.php3/stat/4/idpl/13529891/dir/fedora_other/com/postgresql-libs-8.4.2-6.fc13.x86_64.rpm.html

But now appears other error.
#$ /usr/local/pgadmin3/bin/pgadmin3
/usr/local/pgadmin3/bin/pgadmin3: error while loading shared libraries:
/usr/lib64/libpq.so.5: ELF file OS ABI invalid

thanks

2010/3/17 Guillaume Lelarge <guillaume(at)lelarge(dot)info>

> Please keep the list on CC.
>
> Le 17/03/2010 15:22, Vinicius Borges a écrit :
> > #$ ldd /usr/local/pgadmin3/bin/pgadmin3
> >[...]
> > libpq.so.5 => not found
>
> ldd doesn't find it too. Kind of strange. How did you install libpq? did
> you install the 32-bits library? (which would explain where it is
> located and why ldd didn't find it). But it won't explain why you could
> compile without the library.
>
>
> --
> Guillaume.
> http://www.postgresqlfr.org
> http://dalibo.com
>

On Wed, 2010-03-17 at 12:37 -0300, Vinicius Borges wrote:
> /usr/local/pgadmin3/bin/pgadmin3: error while loading shared
> libraries:
> /usr/lib64/libpq.so.5: ELF file OS ABI invalid

You may need to compile your own libpq from using PostgreSQL 8.2...
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz

Hello Devrim,

Right. How can I do that?

thanks

2010/3/17 Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>

> On Wed, 2010-03-17 at 12:37 -0300, Vinicius Borges wrote:
> > /usr/local/pgadmin3/bin/pgadmin3: error while loading shared
> > libraries:
> > /usr/lib64/libpq.so.5: ELF file OS ABI invalid
>
> You may need to compile your own libpq from using PostgreSQL 8.2...
> --
> Devrim GÜNDÜZ
> PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
> PostgreSQL RPM Repository: http://yum.pgrpms.org
> Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
> http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
>

On Wed, 2010-03-17 at 13:33 -0300, Vinicius Borges wrote:

> Right. How can I do that?

Just compile PostgreSQL sources (don't run make install). When make is
finished, manually copy libpq,libecpg and libpgtypes to related
directories, and see what happens.
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz

What is the output of the following commands:
*file /usr/local/pgadmin3/bin/pgadmin3*
*file /usr/local/lib/libpq.so.5*

--
Ashesh

On Wed, Mar 17, 2010 at 6:39 PM, Vinicius Borges <contatovrpb(at)gmail(dot)com>wrote:

> Hello,
>
> I installed pgadmin3-1.10.2 and I got an error that might strange...
>
> bash-3.1# /usr/local/pgadmin3/bin/pgadmin3
> /usr/local/pgadmin3/bin/pgadmin3: error while loading shared libraries:
> libpq.so.5: cannot open shared object file: No such file or directory
>
> I have the libpq.so.5 in /usr/lib and /usr/local/lib.
>
> I installed the wxWidgets 2.8.10, libxslt-1.1.24, libxml2-2.7.4-1 and
> postgresql-libs-8.4.2-6.
>
> I'm on Slackware 13 - 64 bit.
>
> Thanks
>
>

Hello Ashesh,

when I type

bash-3.1# file /usr/local/pgadmin3/bin/pgadmin3
/usr/local/pgadmin3/bin/pgadmin3: ELF 64-bit LSB executable, x86-64, version
1 (SYSV), dynamically linked (uses shared libs), not stripped

and

bash-3.1# file /usr/local/lib/libpq.so.5
/usr/local/lib/libpq.so.5: ELF 32-bit LSB shared object, Intel 80386,
version 1 (GNU/Linux), dynamically linked, stripped

Thanks

2010/3/18 Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>

> What is the output of the following commands:
> *file /usr/local/pgadmin3/bin/pgadmin3*
> *file /usr/local/lib/libpq.so.5*
>
> --
> Ashesh
>
> On Wed, Mar 17, 2010 at 6:39 PM, Vinicius Borges <contatovrpb(at)gmail(dot)com>wrote:
>
>> Hello,
>>
>> I installed pgadmin3-1.10.2 and I got an error that might strange...
>>
>> bash-3.1# /usr/local/pgadmin3/bin/pgadmin3
>> /usr/local/pgadmin3/bin/pgadmin3: error while loading shared libraries:
>> libpq.so.5: cannot open shared object file: No such file or directory
>>
>> I have the libpq.so.5 in /usr/lib and /usr/local/lib.
>>
>> I installed the wxWidgets 2.8.10, libxslt-1.1.24, libxml2-2.7.4-1 and
>> postgresql-libs-8.4.2-6.
>>
>> I'm on Slackware 13 - 64 bit.
>>
>> Thanks
>>
>>
>

Hi Vinicius,

On Thu, Mar 18, 2010 at 4:04 PM, Vinicius Borges <contatovrpb(at)gmail(dot)com>wrote:

>
> Hello Ashesh,
>
> when I type
>
> bash-3.1# file /usr/local/pgadmin3/bin/pgadmin3
> /usr/local/pgadmin3/bin/pgadmin3: ELF 64-bit LSB executable, x86-64,
> version 1 (SYSV), dynamically linked (uses shared libs), not stripped
>

This says - pgadmin3 is 64 bit binary.

>
> and
>
> bash-3.1# file /usr/local/lib/libpq.so.5
> /usr/local/lib/libpq.so.5: ELF 32-bit LSB shared object, Intel 80386,
> version 1 (GNU/Linux), dynamically linked, stripped
>
And, libpq.so.5 is 32 bit binary.

In order to run the pgAdmin3, you need 64 bit libpq.so.5.

How did you install pgadmin3?

--
Thanks & Regards,
Ashesh Vashi

EnterpriseDB INDIA: Enterprise Postgres Company<http://www.enterprisedb.com>

I installed the pgadmin3 using the file INSTALL in the source path.
After installation, with this problems, I downloaded the
postgresql-libs(that has libpq.so.5) for 64 bit and manually copied the
libpq.so.5 to /usr/lib64 and /usr/lib.

Did I make a mistake?

Thanks

2010/3/18 Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>

> Hi Vinicius,
>
> On Thu, Mar 18, 2010 at 4:04 PM, Vinicius Borges <contatovrpb(at)gmail(dot)com>wrote:
>
>>
>> Hello Ashesh,
>>
>> when I type
>>
>> bash-3.1# file /usr/local/pgadmin3/bin/pgadmin3
>> /usr/local/pgadmin3/bin/pgadmin3: ELF 64-bit LSB executable, x86-64,
>> version 1 (SYSV), dynamically linked (uses shared libs), not stripped
>>
>
> This says - pgadmin3 is 64 bit binary.
>
>>
>> and
>>
>> bash-3.1# file /usr/local/lib/libpq.so.5
>> /usr/local/lib/libpq.so.5: ELF 32-bit LSB shared object, Intel 80386,
>> version 1 (GNU/Linux), dynamically linked, stripped
>>
> And, libpq.so.5 is 32 bit binary.
>
> In order to run the pgAdmin3, you need 64 bit libpq.so.5.
>
> How did you install pgadmin3?
>
> --
> Thanks & Regards,
> Ashesh Vashi
>
> EnterpriseDB INDIA: Enterprise Postgres Company<http://www.enterprisedb.com>
>

Yes, I just copied the libpq.so.5.

The output:

bash-3.1# ldd /usr/lib64/libpq.so.5
not a dynamic executable

Thanks

2010/3/18 Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>

>
>
> On Thu, Mar 18, 2010 at 5:43 PM, Vinicius Borges <contatovrpb(at)gmail(dot)com>wrote:
>
>> I installed the pgadmin3 using the file INSTALL in the source path.
>> After installation, with this problems, I downloaded the
>> postgresql-libs(that has libpq.so.5) for 64 bit and manually copied the
>> libpq.so.5 to /usr/lib64 and /usr/lib.
>>
>> Did I make a mistake?
>>
>
> I think - you copied only the libpq.so.5.
> Is that right or you also copied the other libraries too?
>
> What is the output of the following command?
> ldd /usr/lib64/libpq.so.5
>
> --
> Thanks & Regards,
> Ashesh Vashi
>
> EnterpriseDB INDIA: Enterprise Postgres Company<http://www.enterprisedb.com>
>
>

I think - there is something wrong with the file.
It says - libpq.so.5 is not a dynamic executable.

Can you please follow this steps?
- Change directory to /usr/local/pgadmin3
- Create lib directory (if not exits)
- Copy all the libraries from postgresql-lib to this directory
- Make sure each file in the lib directory are executable
i.e.
chmod a+x /usr/local/pgadmin3/lib/*
- Set environment variable LD_LIBRARY_PATH
i.e.
LD_LIBRARY_PATH=/usr/local/pgadmin3/lib:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH

Now, try to run pgadmin3.

--
Thanks & Regards,
Ashesh Vashi

EnterpriseDB INDIA: Enterprise Postgres Company<http://www.enterprisedb.com>