[JDEV] xdb_sql make error.

[Joe Breeden]

All, here is a little more information to pass on to hopefully help someone help me solve my problem.


I made a change to xdb_sql_pgsql.h (see below) to point it to the correct directory containing libpq-fe.h. The output of a diff of that change:

[jbreeden at shrieker xdb_sql]# diff xdb_sql_pgsql.h.orig xdb_sql_pgsql.h
20c20
< #include <pgsql/libpq-fe.h>
---
> #include <libpq-fe.h>


This change allowed the compile to finish, but when I try to start jabber I get the following:
[jbreeden at shrieker jabber-1.4.2]# jabberd/jabberd
Loading ./xdb_sql/xdb_sql.so failed: 'libpq.so.2: cannot open shared object file: No such file or directory'

Invalid Configuration in instance 'xdb':
<load>
      <xdb_sql>./xdb_sql/xdb_sql.so</xdb_sql>
    </load>



I did a locate to find the file in question (libpq.so.2) and it is in the standard place for it to be as shown below:
[jbreeden at shrieker jabber-1.4.2]# locate libpq.so.2
/usr/local/pgsql/lib/libpq.so.2
/usr/local/pgsql/lib/libpq.so.2.2

I do have an environment variable POSTGRES_LIB set pointing to the proper directory. I used, what I consider, a fairly common set of options to compile and install postgres:

configure --with-perl --with-tcl --enable-odbc
make
make install

So I think my install of Postgres is not unusual and the only thing I did during my RedHat install was to not load the postgres RPM so I could make sure and have a good install. I think one possible solution would be to make a symbolic link to libpq.so.2, but I'm not sure where the link should go. Should it go in the same directory as xdb_sql.so?

Any help would be appreciated. Thanks,

Joe



> -----Original Message-----
> From: Joe Breeden 
> Sent: Thursday, July 18, 2002 10:07 AM
> To: jdev at jabber.org
> Subject: [JDEV] xdb_sql make error.
> 
> 
> I am trying to "make" the xdb_sql and have come across this 
> error: (I have included the complete output from make as it 
> is only a few lines). I am compiling on a RedHat 7.3 system. 
> The standard jabberd server is running ok. I want to use 
> PostgreSQL as the backend db server. PostgreSQL version 7.2.1 
> is installed and running properly and in the standard places 
> on the system I am trying to compile the xdb_sql component. I 
> hope this is enough info to get an answer, thanks in advance 
> for the help.
> 
> 
> [jbreeden at shrieker xdb_sql]# make
> gcc -I. -I../jabberd -g -Wall -I. -I.. 
> -I/usr/local/jabber/jabber-1.4.2/jabberd/pth-1.4.0 -fPIC 
> -I/usr/local/pgsql/include/   -DPOSTGRESQL_BACKEND   -c -o 
> xdb_sql.o xdb_sql.c
> gcc -I. -I../jabberd -g -Wall -I. -I.. 
> -I/usr/local/jabber/jabber-1.4.2/jabberd/pth-1.4.0 -fPIC 
> -I/usr/local/pgsql/include/   -DPOSTGRESQL_BACKEND   -c -o 
> xdb_sql_auth0k.o xdb_sql_auth0k.c
> xdb_sql_auth0k.c: In function `xdbsql_auth0k_get':
> xdb_sql_auth0k.c:70: warning: unused variable `rowcount'
> gcc -I. -I../jabberd -g -Wall -I. -I.. 
> -I/usr/local/jabber/jabber-1.4.2/jabberd/pth-1.4.0 -fPIC 
> -I/usr/local/pgsql/include/   -DPOSTGRESQL_BACKEND   -c -o 
> xdb_sql_auth.o xdb_sql_auth.c
> xdb_sql_auth.c: In function `xdbsql_auth_get':
> xdb_sql_auth.c:30: warning: unused variable `rowcount'
> xdb_sql_auth.c: In function `xdbsql_user_exists':
> xdb_sql_auth.c:233: warning: unused variable `rowcount'
> gcc -I. -I../jabberd -g -Wall -I. -I.. 
> -I/usr/local/jabber/jabber-1.4.2/jabberd/pth-1.4.0 -fPIC 
> -I/usr/local/pgsql/include/   -DPOSTGRESQL_BACKEND   -c -o 
> xdb_sql_offline.o xdb_sql_offline.c
> gcc -I. -I../jabberd -g -Wall -I. -I.. 
> -I/usr/local/jabber/jabber-1.4.2/jabberd/pth-1.4.0 -fPIC 
> -I/usr/local/pgsql/include/   -DPOSTGRESQL_BACKEND   -c -o 
> xdb_sql_register.o xdb_sql_register.c
> gcc -I. -I../jabberd -g -Wall -I. -I.. 
> -I/usr/local/jabber/jabber-1.4.2/jabberd/pth-1.4.0 -fPIC 
> -I/usr/local/pgsql/include/   -DPOSTGRESQL_BACKEND   -c -o 
> xdb_sql_config.o xdb_sql_config.c
> gcc -I. -I../jabberd -g -Wall -I. -I.. 
> -I/usr/local/jabber/jabber-1.4.2/jabberd/pth-1.4.0 -fPIC 
> -I/usr/local/pgsql/include/   -DPOSTGRESQL_BACKEND   -c -o 
> xdb_sql_querydef.o xdb_sql_querydef.c
> gcc -I. -I../jabberd -g -Wall -I. -I.. 
> -I/usr/local/jabber/jabber-1.4.2/jabberd/pth-1.4.0 -fPIC 
> -I/usr/local/pgsql/include/   -DPOSTGRESQL_BACKEND   -c -o 
> xdb_sql_roster.o xdb_sql_roster.c
> xdb_sql_roster.c: In function `xdbsql_roster_set':
> xdb_sql_roster.c:435: warning: suggest explicit braces to 
> avoid ambiguous `else'
> gcc -I. -I../jabberd -g -Wall -I. -I.. 
> -I/usr/local/jabber/jabber-1.4.2/jabberd/pth-1.4.0 -fPIC 
> -I/usr/local/pgsql/include/   -DPOSTGRESQL_BACKEND   -c -o 
> xdb_sql_last.o xdb_sql_last.c
> gcc -I. -I../jabberd -g -Wall -I. -I.. 
> -I/usr/local/jabber/jabber-1.4.2/jabberd/pth-1.4.0 -fPIC 
> -I/usr/local/pgsql/include/   -DPOSTGRESQL_BACKEND   -c -o 
> xdb_sql_backend.o xdb_sql_backend.c
> In file included from xdb_sql_backend.c:29:
> xdb_sql_pgsql.h:20:28: pgsql/libpq-fe.h: No such file or directory
> make: *** [xdb_sql_backend.o] Error 1
> 
> 
> --Joe Breeden
> 
> We don't do Extreme Programming here - we prefer Ludicrous Programming
> _______________________________________________
> jdev mailing list
> jdev at jabber.org
> http://mailman.jabber.org/listinfo/jdev
>