On Wed, 2010-07-28 at 12:13, Arnau Rebassa wrote: > Hi Nikos, > > 2010/7/28 Nikos Balkanas <nbalka...@gmail.com>: > > Hi, > > > >>> I'm running this sqlbox on a debian unstable and using the kannel and > >>> kannel-sqlbox packages from the official repositories. Do I have to > >>> recompile sqlbox to include postgresql support? > > > > Definitely, unless you downloaded a postgress specific binary. To confirm > > what you have please type: > > > > ldd $(which sqlbox) > > > > you will see that the binary is for mysql, not postgress. > > > debian:/usr/local/src# ldd $(which sqlbox) > linux-gate.so.1 => (0xb787d000) > libpq.so.5 => /usr/lib/libpq.so.5 (0xb7852000) ^^ This is the postgresql client library.
> libdl.so.2 => /lib/i686/cmov/libdl.so.2 (0xb784e000) > libpam.so.0 => /lib/libpam.so.0 (0xb7841000) > librt.so.1 => /lib/i686/cmov/librt.so.1 (0xb7838000) > libresolv.so.2 => /lib/i686/cmov/libresolv.so.2 (0xb7824000) > libnsl.so.1 => /lib/i686/cmov/libnsl.so.1 (0xb780d000) > libm.so.6 => /lib/i686/cmov/libm.so.6 (0xb77e7000) > libpthread.so.0 => /lib/i686/cmov/libpthread.so.0 (0xb77cd000) > libxml2.so.2 => /usr/lib/libxml2.so.2 (0xb76a3000) > libpcreposix.so.3 => /usr/lib/libpcreposix.so.3 (0xb76a1000) > libpcre.so.3 => /lib/libpcre.so.3 (0xb766c000) > libmysqlclient_r.so.16 => /usr/lib/libmysqlclient_r.so.16 (0xb746e000) > libsqlite.so.0 => /usr/lib/libsqlite.so.0 (0xb7414000) > libsqlite3.so.0 => /usr/lib/libsqlite3.so.0 (0xb738a000) > libcrypto.so.0.9.8 => /usr/lib/i686/cmov/libcrypto.so.0.9.8 > (0xb7232000) > libssl.so.0.9.8 => /usr/lib/i686/cmov/libssl.so.0.9.8 (0xb71e8000) > libc.so.6 => /lib/i686/cmov/libc.so.6 (0xb70a1000) > libkrb5.so.3 => /usr/lib/libkrb5.so.3 (0xb6fef000) > libcom_err.so.2 => /lib/libcom_err.so.2 (0xb6feb000) > libgssapi_krb5.so.2 => /usr/lib/libgssapi_krb5.so.2 (0xb6fbc000) > libcrypt.so.1 => /lib/i686/cmov/libcrypt.so.1 (0xb6f8a000) > libldap_r-2.4.so.2 => /usr/lib/libldap_r-2.4.so.2 (0xb6f47000) > /lib/ld-linux.so.2 (0xb787e000) > libz.so.1 => /usr/lib/libz.so.1 (0xb6f33000) > libk5crypto.so.3 => /usr/lib/libk5crypto.so.3 (0xb6f0f000) > libkrb5support.so.0 => /usr/lib/libkrb5support.so.0 (0xb6f08000) > libkeyutils.so.1 => /lib/libkeyutils.so.1 (0xb6f05000) > liblber-2.4.so.2 => /usr/lib/liblber-2.4.so.2 (0xb6ef8000) > libsasl2.so.2 => /usr/lib/libsasl2.so.2 (0xb6ee1000) > libgnutls.so.26 => /usr/lib/libgnutls.so.26 (0xb6e48000) > libtasn1.so.3 => /usr/lib/libtasn1.so.3 (0xb6e38000) > libgcrypt.so.11 => /usr/lib/libgcrypt.so.11 (0xb6dc4000) > libgpg-error.so.0 => /usr/lib/libgpg-error.so.0 (0xb6dc0000) > > > It seems there is no postgresql support. I have recompiled it but > again the same result. Anybody know how to enable it? It is there. If it is not, ldd will say 'not found'. -- Kind regards, Milan -------------------------------------------------- Arvanta, IT Security http://www.arvanta.net Please do not send me e-mail containing HTML code.