diff options
Diffstat (limited to 'README')
-rw-r--r-- | README | 23 |
1 files changed, 18 insertions, 5 deletions
@@ -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 | ||
4 | Homepage | 4 | Homepage |
@@ -51,8 +51,11 @@ Supported directives | |||
51 | Please see the web-based documentation for full explanation of all | 51 | Please see the web-based documentation for full explanation of all |
52 | supported run-time directives. | 52 | supported run-time directives. |
53 | 53 | ||
54 | http://www.grubbybaby.com/mod_log_mysql/directives.html | 54 | http://www.grubbybaby.com/mod_log_mysql/directives.html |
55 | 55 | ||
56 | See the FAQ for some handy examples: | ||
57 | |||
58 | http://www.grubbybaby.com/mod_log_mysql/faq.html | ||
56 | 59 | ||
57 | 60 | ||
58 | What gets logged by default? | 61 | What gets logged by default? |
@@ -64,7 +67,8 @@ accept this default and employ the enclosed access_log.sql to | |||
64 | format your table. Customize your logging format after you've | 67 | format your table. Customize your logging format after you've |
65 | had a chance to experiment with the default first. | 68 | had a chance to experiment with the default first. |
66 | 69 | ||
67 | The MySQL table looks like this if you use the enclosed access_log.sql: | 70 | If you just want to log enough data to be able to reconstruct |
71 | a 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 | ||
84 | remote_host: corresponds to the Apache %h directive. Contains the remote | 89 | remote_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 | 137 | request_method: corresponds to the Apache %m directive. Contains the type | |
138 | of request sent: GET, PUT, etc. | ||
139 | Example: GET | ||
140 | |||
141 | request_protocol: corresponds to the Apache %H directive. Contains the HTTP | ||
142 | protocol that was used. | ||
143 | Example: HTTP/1.1 | ||
144 | |||
145 | |||
133 | Notes | 146 | Notes |
134 | ----- | 147 | ----- |
135 | 148 | ||