Oliver Elphick wrote:
On Wed, 2004-11-03 at 12:56 +0100, Carlos Ojea Castro wrote:
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
^^^^^^^^ Did you spell that right? Where does that library come from? It sounds as if it belongs to some package that calls Pg; it isn't part of Pg itself.
libsqlpg.so is located at /usr/local/kylix3/bin, and its a link to /usr/local/kylix3/bin/libsqlpg.so.1.0
Finally I get the connection working in Debian Sarge, kernel 2.4.27 doing this:postgresql database.
Anyone knows how can I make my connection work again?
Thank you, Carlos
1.- Install libpgsql2.7.2.1-2woody6_i386.deb
I presume you mean libpgsql2-7.2.1-2woody6_i386.deb. This is the
libpq.so.2 library from PostgreSQL 7.2.1, so it is not very suitable for
7.4. On the other hand, judging by what you write below, you may not
actually be using it.
Yes, I mean libpgsql2-7.2.1-2woody6_i386.deb, maybe that installation is useless.
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
That ought to fail if libpq.so is already there, since you aren't using -f, or have you got the names reversed?
Well, I did 'rm libpq.so' before making the link :)
libpq.so is only used for linking into binaries when a program is compiled; the linked library loaded by a program at runtime is libpq.so.x, where x is the library major version number. You seem to be wanting to tell kylix that the libpq.so.2 library is at /usr/local/pgsql/lib/libpq.so, and at the same time make that a symbolic link to the libpq.so.3 library.
At the same time make that a simbolic link to: libpq.so.2.2
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.
I think I'm not surprised; I don't know if this error is directly caused by the library mismatch, but you seem to be going out of your way to confuse things! You don't mention running ldconfig, so I'm not even sure which library is going to be called; run ldd on your executable and see what it says. You might be getting the libpq.so.2 library from the libpgsql2 package from 7.2.1 and using it to connect to a 7.4 database; or you might be connecting with a library that is masquerading as libpq.so.2 but is actually libpq.so.3.
ldd c_admin_v380: libX11.so.6 => /usr/X11R6/lib/libX11.so.6 libpthread.so.0 => /lib/libpthread.so.0 libdl.so.2 => /lib/libdl.so.2 libc.so.6 => /lib/libc.so.6 /lib/ld-linux.so.2 => /lib/ld-linux.so.2
You are right. After reading your post, I tried 'ldconfig /usr/local/pgsql/lib' and the connection with my database works in my computer with Debian Sarge kernel 2.6.8-1.Any ideas for Debian Sarge, kernel 2.6.8-1?
The kernel version should have nothing to do with it. Library loading is handled by the C library, libc6 and ldd.so.
My first suggestion is to get a version of Kylix that is built for PostgreSQL 7.4.
Thank you very much!
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
