[JDEV] xdb_sql make error.
Joe Breeden
jbreeden at ena.com
Thu Jul 18 16:22:56 CDT 2002
Thanks,
That seems to have done the trick.
Joe
> -----Original Message-----
> From: Dave [mailto:dave at dave.tj]
> Sent: Thursday, July 18, 2002 3:29 PM
> To: jdev at jabber.org
> 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 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
> >
>
> _______________________________________________
> jdev mailing list
> jdev at jabber.org
> http://mailman.jabber.org/listinfo/jdev
>
More information about the JDev
mailing list