Re: Connection errors

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

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

peter wrote:
> Hi list
> I'm running a Debian Etch amd64 server and have mod-log-sql and
> mod-log-sql-mysql running.=20
>=20
> mysql server version: 5.0.32-Debian_7etch1-log
> MySQL client version: 5.0.32
>=20
> Apache 2.2
>=20
> It all seems to be working okay but there are a tremendous amount of
> connection errors occurring in my logs like the sample below. At the
> same time of course my mod_log_sql-preserve is filling up as well. I've=

> tried changing my access_log table to MyISAM and InnoDB but it has not
> helped.

Try verifying that the SQL queries placed in mod_log_sql-preserve are
actually valid SQL queries.  As when the [error] mysql_query returned
(1) shows up in the log file that means a SQL error occurred (table not
found, field not found, invalid SQL, etc...)

I have changes in the mod_log_sql SVN trunk to mod_log_sql_mysql.c that
produce much better logging of these mysql_query errors so it is easier
to figure out the issue. You download the file from SVN and replace it
in the 1.101 source distribution and rebuild.  But running the sql
queries manually in the mysql query browser or mysql shell will give you
the same information, ie. if there is something wrong w/ the query.

Also, paste the relevant LogSQL configuration options in your apache
configuration to the mailing list (removing your password from the
connect config option, of course) and it'll better help me diagnose the
issue.

> Any hints to fix this would be appreciated.=20
>=20
> [Sat Jul 14 19:46:02 2007] [error] mysql_query returned (1)
> [Sat Jul 14 19:46:02 2007] [notice] db reconnect successful
> [Sat Jul 14 19:46:02 2007] [error] mysql_query returned (1)
> [Sat Jul 14 19:46:02 2007] [error] second attempt failed
>=20
> Regards,
> Peter
>=20
> _______________________________________________
> Download the latest version at http://www.outoforder.cc/projects/apache=
/mod_log_sql/
>=20
> To unsubscribe send an e-mail to=20
> mod_log_sql-unsubscribe-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org



--------------enig3ABFCB8EA6068306F1161DE6
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.7 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org

iD8DBQFGm2r2vwMxRUUct20RArmoAJ9H0A/PCeFQL0WcRBOWEc6y9LPWTwCfeDKQ
vAjKH4eLwjv0CJJ2W03yJ70=
=VSVy
-----END PGP SIGNATURE-----

--------------enig3ABFCB8EA6068306F1161DE6--

--===============2075925966==
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

--===============2075925966==--