<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <TITLE>Mensaje</TITLE> <META content="MSHTML 6.00.2712.300" name=GENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=#ffffff> <DIV>Thanks to everybody, its working now, I will make test tonight I'm also interested if somebody migrated data form xdb std files to xdb_sql or mysql tables.</DIV> <DIV> </DIV> <DIV> </DIV> <DIV>dedalo</DIV> <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"> <DIV></DIV> <DIV class=OutlookMessageHeader lang=es dir=ltr align=left>-----Mensaje original----- De: Glenn MacGregor [mailto:gtm@oracom.com] Enviado el: Martes, 15 de Enero de 2002 10:51 a.m. Para: jdev@jabber.org Asunto: Re: [JDEV] Installing xdb_sql </DIV> <DIV>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)</DIV> <DIV> </DIV> <DIV> </DIV> <DIV>    Glenn</DIV> <BLOCKQUOTE style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"> <DIV style="FONT: 10pt arial">----- Original Message ----- </DIV> <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: <A title=dedalo@ferengi.com.ar href="mailto:dedalo@ferengi.com.ar">Rodrigo Roman</A> </DIV> <DIV style="FONT: 10pt arial">To: <A title=jdev@jabber.org href="mailto:'jdev@jabber.org'">'jdev@jabber.org'</A> </DIV> <DIV style="FONT: 10pt arial">Sent: Tuesday, January 15, 2002 7:26 AM</DIV> <DIV style="FONT: 10pt arial">Subject: [JDEV] Installing xdb_sql</DIV> <DIV> </DIV> I have warnings and errors while making xdb_sql I will use mysql. Any help will be very much apreciated ;-) Here is it: <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 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 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 xdb_sql_auth0k.c: In function `xdbsql_auth0k_get': xdb_sql_auth0k.c:70: warning: unused variable `rowcount' 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 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 -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 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 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 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 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 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 -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 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 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 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 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 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 make: *** No rule to make target ` ', needed by `xdb_sql.so'.  Stop. This is my Makefile root@poseidon:/usr/local/jabber/jabber-1.4.1/xdb_sql > cat Makefile # -------------------------------------------------------------------------- # #  This program was developed by IDEALX (<A href="http://www.IDEALX.org" target=_blank>http://www.IDEALX.org</A>), for #  LibertySurf Télécom (<A href="http://www.libertysurftelecom.fr" target=_blank>http://www.libertysurftelecom.fr</A>), based on #  code developped by members of the Jabber Team in xdb/mysql. # #  Initial release in xdb_sql 1.0, (C) 2000 - 2001 LibertySurf #  Télécom # #  Individual authors' names can be found in the AUTHORS file # #  Usage, modification and distribution rights reserved. See file #  COPYING for details. # # -------------------------------------------------------------------------- # $Id: Makefile,v 1.13 2001/10/12 09:10:03 borihuela Exp $ # # This Makefile is intended to be used in the Jabber environment # include ../platform-settings # Uncomment the flags that are needed for your DB CFLAGS:= -I. -I../jabberd $(CFLAGS) # -I/usr/local/pgsql/include/  !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Should Be the following:  CFLAGS:= -I. -I../jabberd $(CFLAGS) You may need the include location of mysql headers as well !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! # Uncomment the flags that are needed for your DB CPPFLAGS= -DMYSQL_BACKEND # -DPOSTGRESQL_BACKEND -DODBC_BACKEND -DMYSQL_BACKEND # Uncomment the file that corresponds to your DB xdb_sql_OBJECTS= \         xdb_sql.o \         xdb_sql_auth0k.o \         xdb_sql_auth.o \         xdb_sql_offline.o \         xdb_sql_register.o \         xdb_sql_config.o \         xdb_sql_querydef.o \         xdb_sql_roster.o \         xdb_sql_last.o \         xdb_sql_backend.o \         xdb_sql_vcard.o \         xdb_sql_filter.o \         xdb_sql_generic.o \         xdb_sql_mysql.o \ !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Should be xdb_sql_mysql.o !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! #       xdb_sql_pgsql.o #       xdb_sql_odbc.o all: xdb_sql.so # Uncomment the lib that is used by your DB xdb_sql.so: $(xdb_sql_OBJECTS) $(CC) $(CFLAGS) $(MCFLAGS) -o xdb_sql.so $(xdb_sql_OBJECTS) $(LDFLAGS) $(LIBS) -static -lmysqlclient # -L/usr/local/pgsql/lib -lpq -lmysqlclient clean:         rm -f $(xdb_sql_OBJECTS) xdb_sql.so         rm -rf xdb_sql.1.0 dist: all         mkdir xdb_sql.1.0         cat FILES | cut -d":" -f 1 | xargs cp --target-directory=xdb_sql.1.0/         tar cvzf xdb_sql.1.0.tar.gz xdb_sql.1.0 </BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>