From d98a5b1a3da9aec6911b28d1104411a942dffb1e Mon Sep 17 00:00:00 2001 From: Edward Rudd Date: Wed, 5 May 2004 21:37:09 +0000 Subject: Added transferlog table --- Documentation/manual.xml | 219 ++++++++++++++++++++++++++++++++++++++++++++++- 1 file changed, 217 insertions(+), 2 deletions(-) diff --git a/Documentation/manual.xml b/Documentation/manual.xml index c45f204..880bf03 100644 --- a/Documentation/manual.xml +++ b/Documentation/manual.xml @@ -1,6 +1,6 @@ -urkle <at> outoforder <dot> cc"> ]>
@@ -867,7 +867,222 @@ where a.id=n.id and a.id='PPIDskBRH30AAGPtAsg'; Default: AbHhmRSsTUuv Context: virtual host Each character in the format-string defines an attribute of the request that you wish to log. The default logs the information required to create Combined Log Format logs, plus several extras. Here is the full list of allowable keys, which sometimes resemble their Apache counterparts, but do not always: - TODO: Insert Log Format Types Table + + Core LogFormat parameters + + + + + + + + + Symbol + Meaning + DB Field + Data Type + Example + + + + + A + User Agent + agent + varchar(255) + Mozilla/4.0 (compat; MSIE 6.0; Windows) + + + a + CGi request arguments + request_args + varchar(255) + user=Smith&cart=1231&item=532 + + + b + Bytes transfered + bytes_sent + int unsigned + 32561 + + + c + Text of cookie + cookie + varchar(255) + Apache=sdyn.fooonline.net 1300102700823 + + + f + Local filename requested + request_file + varchar(255) + /var/www/html/books-cycroad.html + + + H + HTTP request_protocol + request_protocol + varchar(10) + HTTP/1.1 + + + h + Name of remote host + remote_host + varchar(50) + blah.foobar.com + + + I + Request ID (from modd_unique_id) + id + char(19) + POlFcUBRH30AAALdBG8 + + + l + Ident user info + remote_logname + varcgar(50) + bobby + + + M + Machine ID + machine_id + varchar(25) + web01 + + + m + HTTP request method + request_method + varchar(10) + GET + + + P + httpd cchild PID + child_pid + smallint unsigned + 3215 + + + p + http port + server_port + smallint unsigned + 80 + + + R + Referer + referer + varchar(255) + http://www.biglinks4u.com/linkpage.html + + + r + Request in full form + request_line + varchar(255) + GET /books-cycroad.html HTTP/1.1 + + + S + Time of request in UNIX time_t format + time_stamp + int unsigned + 1005598029 + + + T + Seconds to service request + request_duration + smallint unsigned + 2 + + + t + Time of request in human format + request_time + char(28) + [02/Dec/2001:15:01:26 -0800] + + + U + Request in simple form + request_uri + varchar(255) + /books-cycroad.html + + + u + User info from HTTP auth + remote_user + varchar(50) + bobby + + + v + Virtual host servicing the request + virtual_host + varchar(255) + www.foobar.com + + + +
+ + [1] You must also specify LogSQLWhichCookie for this to take effect. + + + [2] You must also specify LogSQLmachineID for this to take effect. + + + SSL LogFormat Parameters + + + + + + + + + Symbol + Meaning + DB Field + Data Type + Example + + + + + z + SSL cipher used + ssl_cipher + varchar(25) + RC4-MD5 + + + q + Keysize of the SSL connection + ssl_keysize + smallint unsigned + 56 + + + Q + maximum keysize supported + ssl_maxkeysize + smallint unsigned + 128 + + + +
-- cgit