Re: Build Problems for Apache 2 port of mod_log_sql

Hi Edward,

> Hmm..  What version of MySQL are you compiling against? I'm guessing
version 4..

Yes, that's true, version 4.0.17.

> IF so change the definition of char *real_error_str = NULL;
> to const char *real_error_str = NULL; That should fix the warning..
MySQL 3.23 defines the mysql_error function as char* where as 4 defines
it as const char*.. hence the warning.. And since I have -Werror enabled
for compiling it bails.. Sorry..

Yes, that fixed it. It compiled without any complaints. However, I ran the
command make install and I got the message:

# make install
/usr/local/apache/bin/apxs -i -a -n  mod_log_sql.la
Usage: apxs -g [-S <var>=<val>] -n <modname>
       apxs -q [-S <var>=<val>] <query> ...
       apxs -c [-S <var>=<val>] [-o <dsofile>] [-D <name>[=<value>]]
               [-I <incdir>] [-L <libdir>] [-l <libname>] [-Wc,<flags>]
[-Wl,<flags>] [-p] <files> ...
       apxs -i [-S <var>=<val>] [-a] [-A] [-n <modname>] <dsofile> ...
apxs -e [-S <var>=<val>] [-a] [-A] [-n <modname>] <dsofile> ...
*** Error code 1

Stop in /usr/local/mod-log-sql-1.91.

Well, I am not sure if I was supposed to type make install or not...
Installing the module like this worked:

# /usr/local/apache/bin/apxs -i mod_log_sql.la

I hope I did not miss something.

> Also, I have not tested the module for thread safety issues.. I have
only tested it in the prefork MPM..

That's what I use here, too. I will start testing the module right now and
provide you with more feedback. Thanks,

Dave

> On Mon, 2003-12-29 at 15:07, David Meier wrote:
>> I am trying to install the module for Apache 2.0.48 on FreeBSD 4.9. I
downloaded the version 1.91 from www.outoforder.cc. I am somewhat
unsure
>> about installation (could not find that promised Documentation
>> directory...).
>> Anyway, this is how far I got:
>> # ./configure --with-apache=/usr/local/apache
>> --with-myslq=/usr/local/include/mysql
>> checking for gcc... gcc
>> checking for C compiler default output... a.out
>> checking whether the C compiler works... yes
>> checking whether we are cross compiling... no
>> checking for suffix of executables...
>> checking for suffix of object files... o
>> checking whether we are using the GNU C compiler... yes
>> checking whether gcc accepts -g... yes
>> checking build system type... i386-unknown-freebsd4.9
>> checking host system type... i386-unknown-freebsd4.9
>> checking target system type... i386-unknown-freebsd4.9
>> checking for apxs... /usr/local/apache/bin/apxs
>> checking for Apache - version >= 2.0.44... yes
>> checking for floor in -lm... yes
>> checking for gzclose in -lz... yes
>> checking for mysql_init in -lmysqlclient... yes
>> checking for mysql_real_escape_string... yes
>> checking whether mysql clients can run... yes
>> configure: creating ./config.status
>> config.status: creating stamp-h
>> config.status: creating Makefile
>> config.status: creating config.h
>> So far so good. When I try to build it I receive:
>> # make
>> "Makefile", line 121: Could not find /usr/local/mod-log-sql-1.91/.deps
make: fatal errors encountered -- cannot continue
>> So I created an empty file.
>> # touch .deps
>> and retried which results in:
>> # make
>> /usr/local/apache/bin/apxs -c -o mod_log_sql.la
>> -I/usr/local/mysql/include
>> -I/usr/include/mysql -I/usr/mysql/include -I/usr/local/include/mysql
-I/usr/local/mysql/include/mysql -I/usr/mysql/include/mysql -Wc,-Wall
-Wc,-Werror -Wc,-fno-strict-aliasing -L/usr/local/mysql/lib
>> -L/usr/lib/mysql -L/usr/mysql/lib -L/usr/local/lib/mysql
>> -L/usr/local/mysql/lib/mysql -L/usr/mysql/lib/mysql -lmysqlclient -lz -lm
>> -DHAVE_CONFIG_H mod_log_sql.c
>> /usr/local/apache/build/libtool --silent --mode=compile gcc -prefer-pic
-DAP_HAVE_DESIGNATED_INITIALIZER -D_REENTRANT -D_THREAD_SAFE -g -O2
-I/usr/local/apache/include  -I/usr/local/apache/include
>> -I/usr/local/apache/include -I/usr/local/include -Wall -Werror
>> -fno-strict-aliasing -I/usr/local/mysql/include -I/usr/include/mysql
-I/usr/mysql/include -I/usr/local/include/mysql
>> -I/usr/local/mysql/include/mysql -I/usr/mysql/include/mysql
>> -DHAVE_CONFIG_H  -c -o mod_log_sql.lo mod_log_sql.c && touch
>> mod_log_sql.slo
>> cc1: warnings being treated as errors
>> mod_log_sql.c: In function `safe_sql_query':
>> mod_log_sql.c:806: warning: assignment discards qualifiers from pointer
target type
>> apxs:Error: Command failed with rc=65536
>> .
>> *** Error code 1
>> Stop in /usr/local/mod-log-sql-1.91.
>> Any ideas?
>> ____________________________________________________________________
Reminder: to unsubscribe, send email to <[email protected]> with
the words "unsubscribe mod_log_sql" in the body (w/o quotes). The
module homepage is http://www.grubbybaby.com/mod_log_sql/
>> The list archives are here:
>> http://news.gmane.org/thread.php?group=gmane.comp.apache.mod-log-sql
> --
> Edward Rudd <[email protected]>
> Home Page <http://urkle.drip.ws/>
>