Thanks, That seems to have done the trick.
Joe > -----Original Message----- > From: Dave [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 18, 2002 3:29 PM > To: [EMAIL PROTECTED] > Subject: Re: [JDEV] xdb_sql make error. > > > 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@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@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@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: [EMAIL PROTECTED] > > > 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@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 > > > [EMAIL PROTECTED] > > > http://mailman.jabber.org/listinfo/jdev > > > > > _______________________________________________ > > jdev mailing list > > [EMAIL PROTECTED] > > http://mailman.jabber.org/listinfo/jdev > > > > _______________________________________________ > jdev mailing list > [EMAIL PROTECTED] > http://mailman.jabber.org/listinfo/jdev > _______________________________________________ jdev mailing list [EMAIL PROTECTED] http://mailman.jabber.org/listinfo/jdev
