Re: Logging Errors to the database

Edward Perry <[email protected]> Sat, 06 Sep 2008 10:55:27 -0400
Newsgroups gmane.comp.apache.mod-log-sql
Message-ID <C4E8121F.88E3%[email protected]>
> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--===============1393729118==
Content-type: multipart/alternative;
	boundary="B_3303543327_57037749"

> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--B_3303543327_57037749
Content-type: text/plain;
	charset="US-ASCII"
Content-transfer-encoding: 7bit

Syslog is a good idea, with syslog-ng you can put that data right in to a
database, I did it at my last job and it worked great.




On 9/5/08 10:28 PM, "Edward Rudd" <[email protected]> wrote:

> Unfortunately, mod_log_sql does not do anything with the error log.
> 
> Also read 
> http://www.outoforder.cc/projects/apache/mod_log_sql/docs-2.0/?chapter=/4/#id_
> 4_1_1_5
> 
> Also, there are no module hooks to intercept the error log to redirect
> it somewhere else.
> 
> There are some other options, that would probably be better suited to
> your needs.
> 
> Using syslog, or a custom script.
> 
> Read
> http://httpd.apache.org/docs/2.2/mod/core.html#errorlog
> 
> and also
> http://www.oreillynet.com/pub/a/sysadmin/2006/10/12/httpd-syslog.html
> 
> On Sep 5, 2008, at 10:43 AM, Matthew Macdonald-Wallace wrote:
> 
>> > Hi All,
>> >
>> > I've recently started using mod_log_sql for a linux-ha based
>> > webcluster
>> > to ensure that I don't have any issues with logging across nodes
>> > (mainly for awstats generation!).
>> >
>> > Is it possible to specify another table to use for error logs?
>> >
>> > Ideally I want to be able to run analysis across this data as well.
>> >
>> > Thanks in advance,
>> >
>> > Matt
>> > --
>> > Matthew Macdonald-Wallace
>> > [email protected]
>> > http://www.truthisfreedom.org.uk
>> > _______________________________________________
>> > 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
> 
> _______________________________________________
> 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
> 



--B_3303543327_57037749
Content-type: text/html;
	charset="US-ASCII"
Content-transfer-encoding: quoted-printable

<HTML>
<HEAD>
<TITLE>Re: [Mod_log_sql] Logging Errors to the database</TITLE>
</HEAD>
<BODY>
<FONT FACE=3D"Verdana, Helvetica, Arial"><SPAN STYLE=3D'font-size:12.0px'>Syslo=
g is a good idea, with syslog-ng you can put that data right in to a databas=
e, I did it at my last job and it worked great.<BR>
<BR>
<BR>
<BR>
<BR>
On 9/5/08 10:28 PM, &quot;Edward Rudd&quot; &lt;[email protected]&gt; wro=
te:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE=3D"Verdana, Helvetica, Arial"><SPAN STYL=
E=3D'font-size:12.0px'>Unfortunately, mod_log_sql does not do anything with th=
e error log.<BR>
<BR>
Also read <a href=3D"http://www.outoforder.cc/projects/apache/mod_log_sql/doc=
s-2.0/?chapter=3D/4/#id_4_1_1_5">http://www.outoforder.cc/projects/apache/mod_=
log_sql/docs-2.0/?chapter=3D/4/#id_4_1_1_5</a><BR>
<BR>
Also, there are no module hooks to intercept the error log to redirect <BR>
it somewhere else.<BR>
<BR>
There are some other options, that would probably be better suited to <BR>
your needs.<BR>
<BR>
Using syslog, or a custom script.<BR>
<BR>
Read<BR>
<a href=3D"http://httpd.apache.org/docs/2.2/mod/core.html#errorlog">http://ht=
tpd.apache.org/docs/2.2/mod/core.html#errorlog</a><BR>
<BR>
and also<BR>
<a href=3D"http://www.oreillynet.com/pub/a/sysadmin/2006/10/12/httpd-syslog.h=
tml">http://www.oreillynet.com/pub/a/sysadmin/2006/10/12/httpd-syslog.html</=
a><BR>
<BR>
On Sep 5, 2008, at 10:43 AM, Matthew Macdonald-Wallace wrote:<BR>
<BR>
&gt; Hi All,<BR>
&gt;<BR>
&gt; I've recently started using mod_log_sql for a linux-ha based <BR>
&gt; webcluster<BR>
&gt; to ensure that I don't have any issues with logging across nodes<BR>
&gt; (mainly for awstats generation!).<BR>
&gt;<BR>
&gt; Is it possible to specify another table to use for error logs?<BR>
&gt;<BR>
&gt; Ideally I want to be able to run analysis across this data as well.<BR=
>
&gt;<BR>
&gt; Thanks in advance,<BR>
&gt;<BR>
&gt; Matt<BR>
&gt; --<BR>
&gt; Matthew Macdonald-Wallace<BR>
&gt; [email protected]<BR>
&gt; <a href=3D"http://www.truthisfreedom.org.uk">http://www.truthisfreedom.o=
rg.uk</a><BR>
&gt; _______________________________________________<BR>
&gt; Download the latest version at <a href=3D"http://www.outoforder.cc/proje=
cts/apache/mod_log_sql/">http://www.outoforder.cc/projects/apache/mod_log_sq=
l/</a><BR>
&gt;<BR>
&gt; To unsubscribe send an e-mail to<BR>
&gt; mod_log_sql-unsubscribe-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org<BR>
<BR>
_______________________________________________<BR>
Download the latest version at <a href=3D"http://www.outoforder.cc/projects/a=
pache/mod_log_sql/">http://www.outoforder.cc/projects/apache/mod_log_sql/</a=
><BR>
<BR>
To unsubscribe send an e-mail to<BR>
mod_log_sql-unsubscribe-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org<BR>
<BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE=3D"Verdana, Helvetica, Arial"><SPAN STY=
LE=3D'font-size:12.0px'><BR>
</SPAN></FONT>
</BODY>
</HTML>


--B_3303543327_57037749--


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

--===============1393729118==--