gmane.comp.apache.mod-log-sql

Fwd: Bug#666797: Building for apache 2.4

Thomas Goirand — 2012-04-21T07:27:53

Hi,

Here's the patch from Arno Töll, so that mod_log_sql can be built for
Apache 2.4.

Thomas

-------- Original Message --------
Subject: Bug#666797: Building for apache 2.4
Resent-Date: Fri, 20 Apr 2012 23:48:04 +0000
Resent-From: Arno Töll <arno-8fiUuRrzOP0dnm+yROfE0A< at >public.gmane.org>
Resent-To: debian-bugs-dist-0aAXYlwwYIJuHlm7Suoebg< at >public.gmane.org
Resent-CC: Thomas Goirand <thomas-/lR9RVWmqZhGWvitb5QawA< at >public.gmane.org>
Date: Sat, 21 Apr 2012 01:35:21 +0200
From: Arno Töll <arno-8fiUuRrzOP0dnm+yROfE0A< at >public.gmane.org>
Reply-To: Arno Töll <arno-8fiUuRrzOP0dnm+yROfE0A< at >public.gmane.org>, 666797-61a8vm9lEZVf4u+23C9RwQ< at >public.gmane.org
To: Thomas Goirand <thomas-/lR9RVWmqZhGWvitb5QawA< at >public.gmane.org>
CC: 666797-61a8vm9lEZVf4u+23C9RwQ< at >public.gmane.org,  General mod_log_sql discussion
<mod_log_sql-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI< at >public.gmane.org>, control-61a8vm9lEZVf4u+23C9RwQ< at >public.gmane.org

tags 666797 +upstream +patch
thanks

Hi Thomas,

please try the attached patch. I didn't verify whether

High number of MySQL threads when using mod_log_sql

Robert Krig — 2012-02-29T09:47:15

Hi there. I'm the admin for a very high volume website. Wie have 4 
webservers which we use to distribute the load of our website. We would 
like to use mod_log_sql to log apache logs to a central MySQL database.

So far, I've just enabled on of our webservers to log to a MySQL server 
running on a different host.

What I find a bit worrying, is the number of MySQL threads which this 
causes.
The one webserver I have logging to MySQL gets about 30-50 hits per 
second. And already this is causing about 150-200 MySQL server threads.

The load on the MySQL server is extremely low.
The host running the MySQL server is a 2x6 core Xeon Cpu with 
Hyperthreading, totalling 24 threads and equipped with 48GB of RAM.

What I find puzzling is that our central MySQL Database Server, which we 
use as a backend for our website, uses only about 12-30 MySQL threads in 
total. Thats for all our webservers.
Granted, this central database server uses SSD Harddrives for the 
database and handles 1500 Queries per second. But stil

mod_log_sql 1.101 With mod_dbd Support

Rene Kanzler — 2011-08-20T11:54:26

Hello 

Because Apache segfaults with mod_log_sql and mod_dbd and
the latest mod_log_sql version from CVS did not work for me.
Here is the patch to get mod_dbd support in mod_log_sql 1.101.
Of course it includes the "VH_GECOS" and "X-Forwarded-For" header 
stuff from my previous patch for mod_log_sql 1.100.

Hopefully somebody finds this useful. 
The patch is attached ;-) 

Bye
Rene_______________________________________________
Download the latest version at http://www.outoforder.cc/projects/apache/mod_log_sql/

To unsubscribe send an e-mail to 
mod_log_sql-unsubscribe-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI< at >public.gmane.org

[error] Log Format 'i' unknown

Dan Bunyard — 2011-01-02T17:41:53

Alright I have been trying to figure this out for a few days now and have
not been able to.  I am attempting to get mod_log_sql working correctly on
my Fedora 14 box.  Everything is working fine until I enable the logging of
bytes_in and bytes_out using "i" and "o" respectively.  As soon as I add
these two letter to the LogSQLTransferLogFormat configuration option my
Apache error_log is flooded with:

[Sun Jan 02 10:26:20 2011] [error] Log Format 'i' unknown
[Sun Jan 02 10:26:20 2011] [error] Log Format 'o' unknown
[Sun Jan 02 10:26:20 2011] [error] Log Format 'i' unknown
[Sun Jan 02 10:26:20 2011] [error] Log Format 'o' unknown
[Sun Jan 02 10:26:23 2011] [error] Log Format 'i' unknown
[Sun Jan 02 10:26:23 2011] [error] Log Format 'o' unknown
[Sun Jan 02 10:26:24 2011] [error] Log Format 'i' unknown
[Sun Jan 02 10:26:24 2011] [error] Log Format 'o' unknown
[Sun Jan 02 10:26:37 2011] [error] Log Format 'i' unknown
[Sun Jan 02 10:26:37 2011] [error] Log Format 'o' unknown

messages.  I am using version 1.101 a

Any plans to support %D ?

James Po — 2010-10-27T13:22:32

Hi,

just started using mod_log_sql, very easy to set up.

I'd be very interested in getting more details on the amount of time a
response takes, similar to the %D operative in flatfile logging.

http://httpd.apache.org/docs/2.0/mod/mod_log_config.html

%...D               The time taken to serve the request, in microseconds.


Any chance of this enhancement being made?


Thanks


James
_______________________________________________
Download the latest version at http://www.outoforder.cc/projects/apache/mod_log_sql/

To unsubscribe send an e-mail to 
mod_log_sql-unsubscribe-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI< at >public.gmane.org

configure: WARNING: ** libDBI client libraries notfound!

Horace Ho — 2010-08-24T04:02:12

Dear all,

After running:

./configure --with-mysql=/usr/bin/mysql

got 2 warnings in the output:

checking for dbi_version in -ldbi... no
configure: WARNING: ** libDBI client libraries not found!

Can I simply ignore it and proceed with compilation?

I already installed libdbi-devel by: yum install libdbi-devel

Thanks
horace

p.s. full output:

# ./configure --with-mysql=/usr/bin/mysql configure: creating config.nice
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 for gcc option to accept ANSI C... none needed
checking build system type... i686-pc-linux-gnu
checking host system type... i686-pc-linux-gnu
checking target system type... i686-pc-linux-gnu
checking for apxs... /usr/sbin/apxs
checking for Apache 2.0 ver

[error] mysql_query returned (1)

2010-05-10T11:32:15

Greetings,

I have several errors from the module mod_log_sql. And sometimes, i have 
a big error which fridge all the requests on Apache.

With "LogLevel warn" :

[13:22:58] root< at >****:~$  tail -f /var/log/httpd/error.log
[Mon May 10 13:23:06 2010] [error] mysql_query returned (1)
[Mon May 10 13:23:06 2010] [notice] db reconnect successful
[Mon May 10 13:23:07 2010] [error] mysql_query returned (1)
[Mon May 10 13:23:07 2010] [notice] db reconnect successful
[Mon May 10 13:23:07 2010] [error] mysql_query returned (1)
[Mon May 10 13:23:07 2010] [notice] db reconnect successful
[Mon May 10 13:23:07 2010] [error] mysql_query returned (1)
[Mon May 10 13:23:07 2010] [notice] db reconnect successful
........ (etc)

and sometimes :
Mon May 10 12:12:47 2010] [error] mod_log_sql_mysql: database connection 
error: mysql error: Lost connection to MySQL server at 'reading initial 
communication packet', system error: 0
Mon May 10 12:12:47 2010] [error] reconnect failed, unable to reach 
database. SQL logging stopped unti

using mod_log_sql segmentation fault

ax — 2009-09-28T22:50:53

Iam running tests on using mod_log_sql in production

Having in the apache2.conf

===========
LogSQLLoginInfo mysql://apache:apacheapache< at >localhost/apache
LogSQLCreateTables on
#LogSQLTransferLogTable test
LogSQLTransferLogFormat AabcfHhIlMmPpRrSsTtUuvio
===========

and after trying to access some page on the Testserver the page  
actually never loads, and in the error.log I get

===== error.log
[Tue Sep 29 02:32:46 2009] [info] server seems busy, (you may need to  
increase StartServers, or Min/MaxSpareServers), spawning 32 children,  
there are 0 idle, and 0 total children
[Tue Sep 29 02:32:46 2009] [notice] child pid 19004 exit signal  
Segmentation fault (11)
[Tue Sep 29 02:32:46 2009] [notice] child pid 19005 exit signal  
Segmentation fault (11)
=====
Commenting out the log_sql directives its working again.



I have php installed (actually running latest stable Debian) using  
latest stable PHP from apt.

Its stated in
http://www.outoforder.cc/projects/apache/mod_log_sql/docs-2.0/?chapter=/4/#id_4_1