Re: [Announce] Release of version 1.101 of mod_log_sql

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--===============0177014249==
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="------------enigEC8052A8B6146ED81637805F"

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enigEC8052A8B6146ED81637805F
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Thomas Goirand wrote:
> Edward Rudd wrote:
>> This release also adds another sub-module that will log incoming and
>> outgoing bytes (logio) This modules is EXCLUSIVE to the mod_logio
>> module.
>=20
> I'm not sure I understood. What module is conflicting with wich one?

If you have mod_log_sql_logio loaded (to add in support for logging
ACTUAL incoming and outgoing bytes per request) and you have mod_logio
loaded as well then the outgoing byte traffic will ALWAYS be to ZERO for
one of the modules (which ever was loaded last)

example

LoadModule logio_module modules/mod_logio.so
LoadModule log_sql_module modules/mod_log_sql.so
LoadModule log_sql_mysql_module modules/mod_log_sql_mysql.so
LoadModule log_sql_logio_module modules/mod_log_sql_logio.so

CustomLog  logs/access_log combinedio
LogSQLLogFormat AbHhmRSsTUuvio

In this scenario, the access_log text file will have "0" for ALL
outgoing byte counts, whereas the SQL logging tables WILL have the
correct outgoing byte counts.

This is due to how the outgoing byte logging is performed from within
the apache core.  Apache calls an Optional function to actually send the
amount of bytes it just sent, however since there can only be ONE
function called, the LAST function of that name registered gets called.

In order to fix this, the core apache code would have to be changed so
that it is an optional hook.  OR the other way of working around this
WHOLE issue is to alter mod_log_config so that it exports a function so
that mod_log_sql can grab it's logging methods instead of having to
duplicate them in mod_log_sql.  I need to bring all this up on the
http-dev list and see what others opinions are on this.

>> Due to the addition of the logio two new fields are added to the log
>> tables. If you wish to use logging if IO then you MUST alter your
>> existing tables adding fields bytes_in and bytes out of type int unsig=
ned
>>
>> ALTER TABLE mylogingtable ADD COLUMN bytes_in INT UNSIGNED, ADD COLUMN=

>> bytes_out INT UNSIGNED
>=20
> Did you integrate my scoreboard patch to have monthly statistics about
> each sites?

No, not yet..  I will be getting that in next week and pushing out a
1.102 release with that functionality.  I just want to fiddle some more
around and see if I can get bug #27 at least partially implemented in
addition to your patch (since they have a related configuration directive=
)

> Thomas
>=20



--------------enigEC8052A8B6146ED81637805F
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org

iD8DBQFFW0BQvwMxRUUct20RAjrfAJkB8zuxLdnzUX/SqYjuDCo8NdQT7ACgi19e
gB6/kGh/xxGHplhiuD1qqJQ=
=Yax9
-----END PGP SIGNATURE-----

--------------enigEC8052A8B6146ED81637805F--

--===============0177014249==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
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@public.gmane.org

--===============0177014249==--