diff options
Diffstat (limited to 'CHANGELOG')
-rw-r--r-- | CHANGELOG | 53 |
1 files changed, 40 insertions, 13 deletions
@@ -1,9 +1,10 @@ | |||
1 | $Id: CHANGELOG,v 1.15 2002/09/04 18:46:00 helios Exp $ | 1 | $Id: CHANGELOG,v 1.16 2002/11/14 03:51:34 helios Exp $ |
2 | 2 | ||
3 | 3 | ||
4 | TODO: | 4 | TODO: |
5 | * Rethink documentation flow and rewrite? | 5 | * Rethink documentation flow and rewrite? |
6 | * Port connection portion to other DBMS? Genericize the module? Start with PostgreSQL. | 6 | * Port connection portion to other DBMS? Genericize the module? Start with |
7 | PostgreSQL. | ||
7 | * check for mandatory conf directives / syntax quit if not | 8 | * check for mandatory conf directives / syntax quit if not |
8 | * GNU autoconf | 9 | * GNU autoconf |
9 | * merge server config into vh config | 10 | * merge server config into vh config |
@@ -14,13 +15,36 @@ TODO: | |||
14 | * new format char: IP as bigint? | 15 | * new format char: IP as bigint? |
15 | * socket-based middleman daemon with configurable conns? | 16 | * socket-based middleman daemon with configurable conns? |
16 | 17 | ||
17 | * go ahead and allow dashes - quote the table name! | 18 | |
18 | * maxlength of request field should be longer | 19 | * Cookies in separate table |
20 | * ignore by cookie | ||
21 | |||
22 | |||
19 | 23 | ||
20 | 24 | ||
21 | CHANGES: | 25 | CHANGES: |
22 | 26 | ||
23 | 1.17: | 27 | 1.17: |
28 | * In make_combined_log.pl, backtick-quoted the table name and added an | ||
29 | order-by clause within the select statement. | ||
30 | * TCP port number for db connection is now configurable using LogSqlTCPPort | ||
31 | * New directive LogSQLForcePreserve sends all log entries directly to the | ||
32 | preserve file and *entirely bypasses* the db. Useful for debugging, but | ||
33 | can be dangerous if you forget it's set! | ||
34 | * Table names are now quoted in all cases with backticks in order to permit | ||
35 | names containing dashes (since many hostnames contain dashes). | ||
36 | * The request_method field is now created as a varchar(10) instead of (6), | ||
37 | after it was pointed out to me that some methods can be longer than 6. | ||
38 | * New directive LogSQLMachineID sets a string identifier for the webserver | ||
39 | machine. This is useful if you have a cluster of many webservers and you | ||
40 | want to differentiate between them in the logs: you can tell which log | ||
41 | entries came from each machine and thereby analyze your loadbalacing | ||
42 | performance. Activate with the TransferLogFormat character 'M'. Much | ||
43 | faster than doing some sort of wacky IP addr lookup via local_addr(). | ||
44 | * Added an alternative way of logging cookies. If you need to associate | ||
45 | multiple cookies with each request, the new way involves using | ||
46 | LogSQLWhichCookies (note the plural) and LogSQLCookieLogTable. | ||
47 | |||
24 | * Renamed the module mod_log_sql to conform to the project goal of | 48 | * Renamed the module mod_log_sql to conform to the project goal of |
25 | database-inspecificity. | 49 | database-inspecificity. |
26 | * Added capability of logging Notes field. This is useful for folks using | 50 | * Added capability of logging Notes field. This is useful for folks using |
@@ -35,11 +59,11 @@ CHANGES: | |||
35 | be opened.) | 59 | be opened.) |
36 | * Changed default socket file to /tmp/mysql.sock because that's the | 60 | * Changed default socket file to /tmp/mysql.sock because that's the |
37 | default on a compiled MySQL. | 61 | default on a compiled MySQL. |
38 | * Also check for '-' when I'm creating the table when MySQLMassVirtualHosting | 62 | * Put back-quotes (`) around table name so that names with dashes are |
39 | is on, and change it to underscore. (Already did this with '.') | 63 | legal. |
40 | * Took away the prepend of /tmp to the preserve filename. Now the | 64 | * Took away the prepend of /tmp to the preserve filename. Now the |
41 | user can specify whatever local path they want. I figure that | 65 | user can specify whatever local path they want. I figure that |
42 | filesystem permissions will prevent people from doing anything | 66 | filesystem permissions will prevent people from doing anything |
43 | really dumb, and people have requested this change. | 67 | really dumb, and people have requested this change. |
44 | * Better checking in the extract_cookie routine. Before, it could | 68 | * Better checking in the extract_cookie routine. Before, it could |
45 | segfault if a person specified "c" but didn't define MySQLWhichCookie. | 69 | segfault if a person specified "c" but didn't define MySQLWhichCookie. |
@@ -58,9 +82,10 @@ CHANGES: | |||
58 | * Minor: remind user not to set createtables when massvirtual is on. | 82 | * Minor: remind user not to set createtables when massvirtual is on. |
59 | * If Apache started but MySQL was unavailable, the module would do | 83 | * If Apache started but MySQL was unavailable, the module would do |
60 | everything it was supposed to (preserve entries, etc.) but not notify | 84 | everything it was supposed to (preserve entries, etc.) but not notify |
61 | the sysadmin. Added a log message to alert sysadmin if MySQL is | 85 | the sysadmin. Added a log message to alert sysadmin if MySQL is |
62 | unreachable at startup. | 86 | unreachable at startup. |
63 | * New config key 'I' to extract & log unique_id, provided by mod_unique_id. | 87 | * New config key 'I' to extract & log unique_id, provided by mod_unique_id. |
88 | unique_id is the key that links separate tables (access, notes, etc.) | ||
64 | * Migrated to the Artistic License (as used by Perl). | 89 | * Migrated to the Artistic License (as used by Perl). |
65 | * Moved table creation into its own callable function | 90 | * Moved table creation into its own callable function |
66 | * Robustifying table creation | 91 | * Robustifying table creation |
@@ -161,7 +186,7 @@ CHANGES: | |||
161 | (e.g. GET, PUT, etc.) | 186 | (e.g. GET, PUT, etc.) |
162 | * New config capabilities: 'z' 'q' & 'Q' to log SSL_CIPHER, | 187 | * New config capabilities: 'z' 'q' & 'Q' to log SSL_CIPHER, |
163 | SSL_CIPHER_USEKEYSIZE and SSL_CIPHER_ALGKEYSIZE. These require | 188 | SSL_CIPHER_USEKEYSIZE and SSL_CIPHER_ALGKEYSIZE. These require |
164 | openssl and glibc-devel to be installed. (See the online | 189 | openssl and glibc-devel to be installed. (See the online |
165 | directives documentation and FAQ.) | 190 | directives documentation and FAQ.) |
166 | * Fixed a bug in make_combined_log.pl that caused it to generate | 191 | * Fixed a bug in make_combined_log.pl that caused it to generate |
167 | incorrect output on single-digit days. | 192 | incorrect output on single-digit days. |
@@ -182,11 +207,13 @@ CHANGES: | |||
182 | MySQLTransferLogFormat | 207 | MySQLTransferLogFormat |
183 | Instruct the module what information to log to the MySQL transfer log | 208 | Instruct the module what information to log to the MySQL transfer log |
184 | MySQLRefererIgnore | 209 | MySQLRefererIgnore |
185 | List of referers to ignore, accesses that match will not be logged to MySQL | 210 | List of referers to ignore, accesses that match will not be logged to |
211 | MySQL | ||
186 | MySQLRequestIgnore | 212 | MySQLRequestIgnore |
187 | List of URIs to ignore, accesses that match will not be logged to MySQL | 213 | List of URIs to ignore, accesses that match will not be logged to MySQL |
188 | MySQLRemhostIgnore | 214 | MySQLRemhostIgnore |
189 | List of remote hosts to ignore, accesses that match will not be logged to MySQL | 215 | List of remote hosts to ignore, accesses that match will not be logged |
216 | to MySQL | ||
190 | MySQLDatabase | 217 | MySQLDatabase |
191 | The name of the MySQL database for logging | 218 | The name of the MySQL database for logging |
192 | MySQLWhichCookie | 219 | MySQLWhichCookie |
@@ -256,7 +283,7 @@ CHANGES: | |||
256 | more. | 283 | more. |
257 | * Now include a headerfile (http_log.h) that was missing. Its | 284 | * Now include a headerfile (http_log.h) that was missing. Its |
258 | absence was giving us this warning message: "implicit declaration of | 285 | absence was giving us this warning message: "implicit declaration of |
259 | function `ap_log_error_old'." | 286 | function `ap_log_error_old'." |
260 | * For numerics that Apache customarily logs as a "-" we now log a zero | 287 | * For numerics that Apache customarily logs as a "-" we now log a zero |
261 | instead of a -1. This seems to be more intuitive, e.g. in the | 288 | instead of a -1. This seems to be more intuitive, e.g. in the |
262 | "bytes_sent" column. | 289 | "bytes_sent" column. |
@@ -285,7 +312,7 @@ CHANGES: | |||
285 | 1.03: | 312 | 1.03: |
286 | 313 | ||
287 | * Changed the check for 'mysql server has gone away' to be case | 314 | * Changed the check for 'mysql server has gone away' to be case |
288 | insensitive, so that it works with MySQL 3.21 | 315 | insensitive, so that it works with MySQL 3.21 |
289 | * Changed the behavior so that a link isn't established until it's | 316 | * Changed the behavior so that a link isn't established until it's |
290 | necessary (e.g., if SQL logging is used for one virtual IP, a link | 317 | necessary (e.g., if SQL logging is used for one virtual IP, a link |
291 | won't be opened until there's an access to that IP). | 318 | won't be opened until there's an access to that IP). |