summaryrefslogtreecommitdiffstats
path: root/README
diff options
context:
space:
mode:
Diffstat (limited to 'README')
-rw-r--r--README23
1 files changed, 18 insertions, 5 deletions
diff --git a/README b/README
index 23b8a91..9fee671 100644
--- a/README
+++ b/README
@@ -1,4 +1,4 @@
1$Id: README,v 1.1 2001/11/28 05:26:54 helios Exp $ 1$Id: README,v 1.2 2001/12/03 19:54:02 helios Exp $
2 2
3 3
4Homepage 4Homepage
@@ -51,8 +51,11 @@ Supported directives
51Please see the web-based documentation for full explanation of all 51Please see the web-based documentation for full explanation of all
52supported run-time directives. 52supported run-time directives.
53 53
54http://www.grubbybaby.com/mod_log_mysql/directives.html 54 http://www.grubbybaby.com/mod_log_mysql/directives.html
55 55
56See the FAQ for some handy examples:
57
58 http://www.grubbybaby.com/mod_log_mysql/faq.html
56 59
57 60
58What gets logged by default? 61What gets logged by default?
@@ -64,7 +67,8 @@ accept this default and employ the enclosed access_log.sql to
64format your table. Customize your logging format after you've 67format your table. Customize your logging format after you've
65had a chance to experiment with the default first. 68had a chance to experiment with the default first.
66 69
67The MySQL table looks like this if you use the enclosed access_log.sql: 70If you just want to log enough data to be able to reconstruct
71a Combined Log Format log, log these:
68 72
69+------------------+------------------+ 73+------------------+------------------+
70| Field | Type | 74| Field | Type |
@@ -72,13 +76,14 @@ The MySQL table looks like this if you use the enclosed access_log.sql:
72| remote_host | varchar(50) | 76| remote_host | varchar(50) |
73| remote_user | varchar(50) | 77| remote_user | varchar(50) |
74| request_uri | varchar(50) | 78| request_uri | varchar(50) |
75| request_duration | smallint(6) |
76| virtual_host | varchar(50) | 79| virtual_host | varchar(50) |
77| time_stamp | int(10) unsigned | 80| time_stamp | int(10) unsigned |
78| status | smallint(6) | 81| status | smallint(6) |
79| bytes_sent | int(11) | 82| bytes_sent | int(11) |
80| referer | varchar(255) | 83| referer | varchar(255) |
81| agent | varchar(255) | 84| agent | varchar(255) |
85| request_method | varchar(6) |
86| request_protocol | varchar(10) |
82+------------------+------------------+ 87+------------------+------------------+
83 88
84remote_host: corresponds to the Apache %h directive. Contains the remote 89remote_host: corresponds to the Apache %h directive. Contains the remote
@@ -129,7 +134,15 @@ agent: corresponds to the Apache "%{User-Agent}" directive. Contains the
129 broswer type (user agent) of the software that made the request. 134 broswer type (user agent) of the software that made the request.
130 Example: Mozilla/3.0 (Slurp/si; slurp@inktomi.com; http://www.inktomi.com/slurp.html) 135 Example: Mozilla/3.0 (Slurp/si; slurp@inktomi.com; http://www.inktomi.com/slurp.html)
131 136
132 137request_method: corresponds to the Apache %m directive. Contains the type
138 of request sent: GET, PUT, etc.
139 Example: GET
140
141request_protocol: corresponds to the Apache %H directive. Contains the HTTP
142 protocol that was used.
143 Example: HTTP/1.1
144
145
133Notes 146Notes
134----- 147-----
135 148