<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Installing xdb_sql</TITLE>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="MSHTML 5.00.3103.1000" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>You need to get rid of the slash after
xdb_sql_mysql.o and the comment mark in the Makefile (I have changed it
below)</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2> Glenn</FONT></DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A href="mailto:dedalo@ferengi.com.ar" title=dedalo@ferengi.com.ar>Rodrigo
Roman</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A href="mailto:'jdev@jabber.org'"
title=jdev@jabber.org>'jdev@jabber.org'</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, January 15, 2002 7:26
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [JDEV] Installing xdb_sql</DIV>
<DIV><BR></DIV>
<P><FONT size=2>I have warnings and errors while making xdb_sql</FONT>
<BR><FONT size=2>I will use mysql.</FONT> <BR><FONT size=2>Any help will be
very much apreciated ;-)</FONT> </P>
<P><FONT size=2>Here is it:</FONT> </P>
<P><FONT size=2><A
href="mailto:root@poseidon:/usr/local/jabber/jabber-1.4.1/xdb_sql">root@poseidon:/usr/local/jabber/jabber-1.4.1/xdb_sql</A>
> make</FONT> <BR><FONT size=2>gcc -I. -I../jabberd -g -Wall -fPIC -I. -I..
-I/usr/local/jabber/jabber-1.4.1/jabberd/pth-1.3.7 -DMYSQL_BACKEND
-c -o xdb_sql.o xdb_sql.c</FONT></P>
<P><FONT size=2>gcc -I. -I../jabberd -g -Wall -fPIC -I. -I..
-I/usr/local/jabber/jabber-1.4.1/jabberd/pth-1.3.7 -DMYSQL_BACKEND
-c -o xdb_sql_auth0k.o xdb_sql_auth0k.c</FONT></P>
<P><FONT size=2>xdb_sql_auth0k.c: In function `xdbsql_auth0k_get':</FONT>
<BR><FONT size=2>xdb_sql_auth0k.c:70: warning: unused variable
`rowcount'</FONT> <BR><FONT size=2>gcc -I. -I../jabberd -g -Wall -fPIC -I.
-I.. -I/usr/local/jabber/jabber-1.4.1/jabberd/pth-1.3.7
-DMYSQL_BACKEND -c -o xdb_sql_auth.o xdb_sql_auth.c</FONT></P>
<P><FONT size=2>xdb_sql_auth.c: In function `xdbsql_auth_get':</FONT>
<BR><FONT size=2>xdb_sql_auth.c:30: warning: unused variable `rowcount'</FONT>
<BR><FONT size=2>xdb_sql_auth.c: In function `xdbsql_user_exists':</FONT>
<BR><FONT size=2>xdb_sql_auth.c:233: warning: unused variable
`rowcount'</FONT> <BR><FONT size=2>gcc -I. -I../jabberd -g -Wall -fPIC -I.
-I.. -I/usr/local/jabber/jabber-1.4.1/jabberd/pth-1.3.7
-DMYSQL_BACKEND -c -o xdb_sql_offline.o xdb_sql_offline.c</FONT></P>
<P><FONT size=2>gcc -I. -I../jabberd -g -Wall -fPIC -I. -I..
-I/usr/local/jabber/jabber-1.4.1/jabberd/pth-1.3.7 -DMYSQL_BACKEND
-c -o xdb_sql_register.o xdb_sql_register.c</FONT></P>
<P><FONT size=2>gcc -I. -I../jabberd -g -Wall -fPIC -I. -I..
-I/usr/local/jabber/jabber-1.4.1/jabberd/pth-1.3.7 -DMYSQL_BACKEND
-c -o xdb_sql_config.o xdb_sql_config.c</FONT></P>
<P><FONT size=2>gcc -I. -I../jabberd -g -Wall -fPIC -I. -I..
-I/usr/local/jabber/jabber-1.4.1/jabberd/pth-1.3.7 -DMYSQL_BACKEND
-c -o xdb_sql_querydef.o xdb_sql_querydef.c</FONT></P>
<P><FONT size=2>gcc -I. -I../jabberd -g -Wall -fPIC -I. -I..
-I/usr/local/jabber/jabber-1.4.1/jabberd/pth-1.3.7 -DMYSQL_BACKEND
-c -o xdb_sql_roster.o xdb_sql_roster.c</FONT></P>
<P><FONT size=2>xdb_sql_roster.c: In function `xdbsql_roster_set':</FONT>
<BR><FONT size=2>xdb_sql_roster.c:435: warning: suggest explicit braces to
avoid ambiguous `else'</FONT> <BR><FONT size=2>gcc -I. -I../jabberd -g -Wall
-fPIC -I. -I.. -I/usr/local/jabber/jabber-1.4.1/jabberd/pth-1.3.7
-DMYSQL_BACKEND -c -o xdb_sql_last.o xdb_sql_last.c</FONT></P>
<P><FONT size=2>gcc -I. -I../jabberd -g -Wall -fPIC -I. -I..
-I/usr/local/jabber/jabber-1.4.1/jabberd/pth-1.3.7 -DMYSQL_BACKEND
-c -o xdb_sql_backend.o xdb_sql_backend.c</FONT></P>
<P><FONT size=2>gcc -I. -I../jabberd -g -Wall -fPIC -I. -I..
-I/usr/local/jabber/jabber-1.4.1/jabberd/pth-1.3.7 -DMYSQL_BACKEND
-c -o xdb_sql_vcard.o xdb_sql_vcard.c</FONT></P>
<P><FONT size=2>gcc -I. -I../jabberd -g -Wall -fPIC -I. -I..
-I/usr/local/jabber/jabber-1.4.1/jabberd/pth-1.3.7 -DMYSQL_BACKEND
-c -o xdb_sql_filter.o xdb_sql_filter.c</FONT></P>
<P><FONT size=2>gcc -I. -I../jabberd -g -Wall -fPIC -I. -I..
-I/usr/local/jabber/jabber-1.4.1/jabberd/pth-1.3.7 -DMYSQL_BACKEND
-c -o xdb_sql_generic.o xdb_sql_generic.c</FONT></P>
<P><FONT size=2>gcc -I. -I../jabberd -g -Wall -fPIC -I. -I..
-I/usr/local/jabber/jabber-1.4.1/jabberd/pth-1.3.7 -DMYSQL_BACKEND
-c -o xdb_sql_mysql.o xdb_sql_mysql.c</FONT></P>
<P><FONT size=2>make: *** No rule to make target ` ', needed by
`xdb_sql.so'. Stop.</FONT> </P><BR>
<P><FONT size=2>This is my Makefile</FONT> <BR><FONT
size=2>root@poseidon:/usr/local/jabber/jabber-1.4.1/xdb_sql > cat
Makefile</FONT> <BR><FONT size=2>#
--------------------------------------------------------------------------</FONT>
<BR><FONT size=2>#</FONT> <BR><FONT size=2># This program was developed
by IDEALX (<A href="http://www.IDEALX.org"
target=_blank>http://www.IDEALX.org</A>), for</FONT> <BR><FONT size=2>#
LibertySurf Télécom (<A href="http://www.libertysurftelecom.fr"
target=_blank>http://www.libertysurftelecom.fr</A>), based on</FONT> <BR><FONT
size=2># code developped by members of the Jabber Team in
xdb/mysql.</FONT> <BR><FONT size=2>#</FONT> <BR><FONT size=2># Initial
release in xdb_sql 1.0, (C) 2000 - 2001 LibertySurf</FONT> <BR><FONT
size=2># Télécom</FONT> <BR><FONT size=2>#</FONT> <BR><FONT
size=2># Individual authors' names can be found in the AUTHORS
file</FONT> <BR><FONT size=2>#</FONT> <BR><FONT size=2># Usage,
modification and distribution rights reserved. See file</FONT> <BR><FONT
size=2># COPYING for details.</FONT> <BR><FONT size=2>#</FONT> <BR><FONT
size=2>#
--------------------------------------------------------------------------</FONT>
</P>
<P><FONT size=2># $Id: Makefile,v 1.13 2001/10/12 09:10:03 borihuela Exp
$</FONT> </P>
<P><FONT size=2>#</FONT> <BR><FONT size=2># This Makefile is intended to be
used in the Jabber environment</FONT> <BR><FONT size=2>#</FONT> </P>
<P><FONT size=2>include ../platform-settings</FONT> </P>
<P><FONT size=2># Uncomment the flags that are needed for your DB</FONT>
<BR><FONT size=2>CFLAGS:= -I. -I../jabberd $(CFLAGS) #
-I/usr/local/pgsql/include/ </FONT></P>
<P><FONT
size=2>!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!</FONT></P>
<P><FONT size=2>Should Be the following: </FONT></P>
<P><FONT size=2><FONT size=2>CFLAGS:= -I. -I../jabberd $(CFLAGS)
</FONT></FONT></P>
<P><FONT size=2>You may need the include location of mysql headers as
well</FONT></P>
<P><FONT
size=2>!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!</FONT></P>
<P><FONT size=2># Uncomment the flags that are needed for your DB</FONT>
<BR><FONT size=2>CPPFLAGS= -DMYSQL_BACKEND</FONT> <BR><FONT size=2>#
-DPOSTGRESQL_BACKEND -DODBC_BACKEND -DMYSQL_BACKEND</FONT> </P>
<P><FONT size=2># Uncomment the file that corresponds to your DB</FONT>
<BR><FONT size=2>xdb_sql_OBJECTS= \</FONT> <BR><FONT
size=2> xdb_sql.o \</FONT> <BR><FONT
size=2> xdb_sql_auth0k.o \</FONT>
<BR><FONT size=2> xdb_sql_auth.o
\</FONT> <BR><FONT size=2>
xdb_sql_offline.o \</FONT> <BR><FONT
size=2> xdb_sql_register.o \</FONT>
<BR><FONT size=2> xdb_sql_config.o
\</FONT> <BR><FONT size=2>
xdb_sql_querydef.o \</FONT> <BR><FONT
size=2> xdb_sql_roster.o \</FONT>
<BR><FONT size=2> xdb_sql_last.o
\</FONT> <BR><FONT size=2>
xdb_sql_backend.o \</FONT> <BR><FONT
size=2> xdb_sql_vcard.o \</FONT>
<BR><FONT size=2> xdb_sql_filter.o
\</FONT> <BR><FONT size=2>
xdb_sql_generic.o \</FONT> <BR><FONT
size=2> xdb_sql_mysql.o \
</FONT></P>
<P><FONT
size=2>!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!</FONT></P>
<P><FONT size=2>Should be </FONT></P>
<P><FONT size=2>xdb_sql_mysql.o</FONT></P>
<P><FONT
size=2>!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!<BR>#
xdb_sql_pgsql.o <BR>#
xdb_sql_odbc.o</FONT> </P>
<P><FONT size=2>all: xdb_sql.so</FONT> </P>
<P><FONT size=2># Uncomment the lib that is used by your DB</FONT> <BR><FONT
size=2>xdb_sql.so: $(xdb_sql_OBJECTS) $(CC) $(CFLAGS) $(MCFLAGS) -o xdb_sql.so
$(xdb_sql_OBJECTS) $(LDFLAGS) $(LIBS) -static -lmysqlclient</FONT></P>
<P><FONT size=2># -L/usr/local/pgsql/lib -lpq -lmysqlclient</FONT> </P>
<P><FONT size=2>clean:</FONT> <BR><FONT
size=2> rm -f $(xdb_sql_OBJECTS)
xdb_sql.so</FONT> <BR><FONT size=2>
rm -rf xdb_sql.1.0</FONT> </P>
<P><FONT size=2>dist: all</FONT> <BR><FONT
size=2> mkdir xdb_sql.1.0</FONT>
<BR><FONT size=2> cat FILES | cut
-d":" -f 1 | xargs cp --target-directory=xdb_sql.1.0/</FONT> <BR><FONT
size=2> tar cvzf xdb_sql.1.0.tar.gz
xdb_sql.1.0</FONT> </P><BR><BR></BLOCKQUOTE></BODY></HTML>