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
