Re: Error logging int mod_log_sql

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Friday, June 13, 2003 08:23, Rob Horton wrote:
> I'm wondering if it's possible to log server errors to the MySQL
> database - is this what the LogSQLNotesLogTable and LogSQLWhichNotes
> directives are for? I did start to look at the source but it's Friday
> afternoon :)

Hi, Rob.  Actually, logging server errors to mod_log_sql has potential to 
be bad -- here's why:

4.1.5 Why doesn't the module also replace the Apache ErrorLog?

There are circumstances when that would be quite unwise - for example, if 
Apache could not reach the MySQL server for some reason and needed to log 
that fact. Without a text-based error log you'd never know anything was 
wrong, because Apache would be trying to log a database connection error 
to the database... you get the point.

Error logs are usually not very high-traffic and are really best left as 
text files on a web server machine. 


As for the notes log, this is a specialty animal for certain other modules 
which set "notes" during their operation.  An example of this is mod_gzip; 
it uses notes to record things such as the compression ratio it achieved 
for that request.  Using the LogSQLWhichNotes facility you can extact that 
info and log it for later perusal.

Regards,
Chris
- -- 
Chris Powell
[email protected]
(206) 783-5104 voice, (815) 461-4456 fax

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE+6fHcYLVoao8MjQkRAgrLAJsHaXvg25+qYvJ4brE1dAhdp4neegCeLCvl
dA6VWW5H7jk9EuVsRoI7vyc=
=3rn2
-----END PGP SIGNATURE-----

__________________________________________________________________
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/