[JDEV] xdb_sql make error.

[Dave]

Is /etc/ld.so.conf setup to look in /usr/pgsql/lib for libraries?
You may need to run /sbin/ldconfig to update the cache.

 - Dave


Joe Breeden wrote:
> 
> 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
> > 
> _______________________________________________
> jdev mailing list
> jdev at jabber.org
> http://mailman.jabber.org/listinfo/jdev
>