Thread: : Unable to load libsqlpg.so

Hello:

I'm trying to use kylix3 and postgresql 7.4.1.

My distro was Debian Woody, kernel 2.20.
I make the link /usr/local/pgsql/lib/libpq.so pointing to libpq.so.2.2 
and connection with my database get fine.

But now, using Debian Sarge Testing, kernel 2.4.27 (I tried also with 
kernel 2.6.8-1) that link don't make things work anymore, I get the 
error 'Unable to load libsqlpg.so' and I cannot connect with my 
postgresql database.

Anyone knows how can I make my connection work again?

Thank you,
Carlos

Hi, there are a environment variable called     $LD_LIBRARY_PATH, this 
variable contain the path to the shared object, maybe you have installed the 
postgres from sources and the library doesnt point to the correct place 
where your .so file is, so try to put it like this
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/postgres/lib
by example, see ya.

_________________________________________________________________
MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/

miguel lam wrote:

>
> Hi, there are a environment variable called     $LD_LIBRARY_PATH, this 
> variable contain the path to the shared object, maybe you have 
> installed the postgres from sources and the library doesnt point to 
> the correct place where your .so file is, so try to put it like this
> export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/postgres/lib
> by example, see ya.
>
> _________________________________________________________________
> MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/
>
>
Finally I get the connection working in Debian Sarge, kernel 2.4.27 
doing this:
1.- Install libpgsql2.7.2.1-2woody6_i386.deb
2.- in /usr/local/kylix3/bin make the link: ln -s 
/usr/local/pgsql/lib/libpq.so libpq.so
3.- in /usr/local/pgsql/lib make the link: ln -s libpq.so.2.2 libpq.so

However, doing that in Debian Sarge, kernel 2.6.8-1 results in an error 
'Invalid username/password' when I try to connect to the database.
Any ideas for Debian Sarge, kernel 2.6.8-1?

Thanks,
Carlos