summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
Diffstat
-rw-r--r--Documentation/documentation.lyx1347
-rw-r--r--Makefile27
2 files changed, 913 insertions, 461 deletions
diff --git a/Documentation/documentation.lyx b/Documentation/documentation.lyx
index ecee913..4fc8020 100644
--- a/Documentation/documentation.lyx
+++ b/Documentation/documentation.lyx
@@ -1,22 +1,24 @@
1#LyX 1.1 created this file. For more info see http://www.lyx.org/ 1#LyX 1.2 created this file. For more info see http://www.lyx.org/
2\lyxformat 218 2\lyxformat 220
3\textclass article 3\textclass article
4\language english 4\language english
5\inputencoding default 5\inputencoding default
6\fontscheme default 6\fontscheme default
7\graphics default 7\graphics default
8\float_placement !hptb 8\float_placement !htbp
9\paperfontsize 10 9\paperfontsize 10
10\spacing single 10\spacing single
11\papersize letterpaper 11\papersize letterpaper
12\paperpackage a4 12\paperpackage a4
13\use_geometry 1 13\use_geometry 1
14\use_amsmath 0 14\use_amsmath 0
15\use_natbib 0
16\use_numerical_citations 0
15\paperorientation portrait 17\paperorientation portrait
16\leftmargin 1in 18\leftmargin 1in
17\topmargin 0.5in 19\topmargin 0.5in
18\rightmargin 1in 20\rightmargin 1in
19\bottommargin 1in 21\bottommargin 0.65in
20\secnumdepth 3 22\secnumdepth 3
21\tocdepth 3 23\tocdepth 3
22\paragraph_separation indent 24\paragraph_separation indent
@@ -255,6 +257,102 @@ Additionally, if you want to be able to log SSL information such as keysize
255 Both are available as RPMs. 257 Both are available as RPMs.
256\layout Subsection 258\layout Subsection
257 259
260Platform-specific notes
261\layout Standard
262
263These installation documents assume a relatively modern GNU/Linux scenario.
264 mod_log_sql has been ported to other platforms; notes on compiling the
265 module on those platforms are noted here.
266\layout Subsubsection
267
268Solaris
269\layout Standard
270
271The nanosleep() function used in mod_log_sql relies on linking aginst the
272 librt library.
273 Make the following alterations before proceeding:
274\layout Enumerate
275
276In Makefile, search for the string
277\begin_inset Quotes eld
278\end_inset
279
280-lmysqlclient -lz
281\begin_inset Quotes erd
282\end_inset
283
284 and change it to read
285\begin_inset Quotes eld
286\end_inset
287
288-lmysqlclient -lz -lrt
289\begin_inset Quotes erd
290\end_inset
291
292
293\layout Enumerate
294
295In part
296\begin_inset LatexCommand \ref{step:Linking}
297
298\end_inset
299
300 of section
301\begin_inset LatexCommand \ref{sec:Static}
302
303\end_inset
304
305 below, change
306\begin_inset Quotes eld
307\end_inset
308
309-lmysqlclient -lm -lz
310\begin_inset Quotes erd
311\end_inset
312
313 to read
314\begin_inset Quotes eld
315\end_inset
316
317-lmysqlclient -lm -lz -lrt
318\begin_inset Quotes erd
319\end_inset
320
321
322\layout Subsubsection
323
324BSD
325\layout Standard
326
327No notes are available at present, but they are desired.
328 If you have successfully ported mod_log_sql to BSD,
329\emph on
330please
331\emph default
332contact
333\begin_inset LatexCommand \url[the maintaniner, Chris Powell]{(chris@grubbybaby.com)}
334
335\end_inset
336
337 and help fill in this section.
338\layout Subsubsection
339
340Win32
341\layout Standard
342
343No notes are available at present, but they are desired.
344 If you have successfully ported mod_log_sql to Win32,
345\emph on
346please
347\emph default
348contact
349\begin_inset LatexCommand \url[the maintaniner, Chris Powell]{(chris@grubbybaby.com)}
350
351\end_inset
352
353 and help fill in this section.
354\layout Subsection
355
258Do I want a DSO? 356Do I want a DSO?
259\layout Standard 357\layout Standard
260 358
@@ -281,7 +379,10 @@ Perform all the following steps as root so that you have install privs,
281\begin_deeper 379\begin_deeper
282\layout LyX-Code 380\layout LyX-Code
283 381
284# tar zxf mod_log_sql.tar.gz -C /usr/local/src # cd /usr/local/src/mod_log_sql 382# tar zxf mod_log_sql.tar.gz -C /usr/local/src
383\layout LyX-Code
384
385# cd /usr/local/src/mod_log_sql
285\end_deeper 386\end_deeper
286\layout Enumerate 387\layout Enumerate
287 388
@@ -335,19 +436,15 @@ You should see output similar to the following:
335\begin_deeper 436\begin_deeper
336\layout LyX-Code 437\layout LyX-Code
337 438
338/usr/local/Apache/bin/apxs -Wc,-O2 -Wc,-Wall -Wc,-DEAPI -c -I/usr/include/mysql 439/usr/local/Apache/bin/apxs -Wc,-O2 -Wc,-Wall -Wc,-DEAPI -c -I/usr/incl...
339 -I/usr/local/src/apache_1.3.27-dso/src/modules/ssl -L/usr/lib -lmysqlclient 440
340 -lz mod_log_sql.c
341\layout LyX-Code 441\layout LyX-Code
342 442
343gcc -DLINUX=22 -DNO_DBM_REWRITEMAP -DMOD_SSL=208111 -DUSE_HSREGEX -DEAPI 443gcc -DLINUX=22 -DNO_DBM_REWRITEMAP -DMOD_SSL=208111 -DUSE_HSREGEX -DEAPI...
344 -DUSE_EXPAT -I../lib/expat-lite -fpic -DSHARED_CORE -DSHARED_MODULE -I/usr/local/ 444
345Apache/include -O2 -Wall -DEAPI -I/usr/include/mysql -I/usr/local/src/apache_1.3.2
3467-dso/src/modules/ssl -c mod_log_sql.c
347\layout LyX-Code 445\layout LyX-Code
348 446
349gcc -shared -o mod_log_sql.so mod_log_sql.o -Wc,-O2 -Wc,-Wall -Wc,-DEAPI -L/usr/li 447gcc -shared -o mod_log_sql.so mod_log_sql.o -Wc,-O2 -Wc,-Wall -Wc,-DEAPI...
350b -lmysqlclient -lz -lm -lcrypt -ldb
351\layout Standard 448\layout Standard
352 449
353You should see no errors and have a file called "mod_log_sql.so" in your 450You should see no errors and have a file called "mod_log_sql.so" in your
@@ -406,6 +503,11 @@ Now skip below to the "Configuration" section.
406\end_deeper 503\end_deeper
407\layout Subsection 504\layout Subsection
408 505
506
507\begin_inset LatexCommand \label{sec:Static}
508
509\end_inset
510
409Installation as a static module compiled into httpd 511Installation as a static module compiled into httpd
410\layout Enumerate 512\layout Enumerate
411 513
@@ -489,6 +591,11 @@ Re-make your httpd binary as follows.
489\begin_deeper 591\begin_deeper
490\layout Enumerate 592\layout Enumerate
491 593
594
595\begin_inset LatexCommand \label{step:Linking}
596
597\end_inset
598
492Edit Configuration.apaci as follows... 599Edit Configuration.apaci as follows...
493\begin_deeper 600\begin_deeper
494\layout Itemize 601\layout Itemize
@@ -633,7 +740,9 @@ Create a specific MySQL userid that httpd will use to authenticate and enter
633\layout LyX-Code 740\layout LyX-Code
634 741
635mysql> grant insert,create on apachelogs.* to loguser@my.apachemachine.com 742mysql> grant insert,create on apachelogs.* to loguser@my.apachemachine.com
636 identified by 'l0gger'; 743\layout LyX-Code
744
745identified by 'l0gger';
637\end_deeper 746\end_deeper
638\layout Enumerate 747\layout Enumerate
639 748
@@ -646,8 +755,10 @@ You may be especially security-paranoid and not want "loguser" to have "create"
646\begin_deeper 755\begin_deeper
647\layout LyX-Code 756\layout LyX-Code
648 757
649mysql> grant insert on apachelogs.* to loguser@my.apachemachine.com identified 758mysql> grant insert on apachelogs.* to loguser@my.apachemachine.com
650 by 'l0gger'; 759\layout LyX-Code
760
761identified by 'l0gger';
651\end_deeper 762\end_deeper
652\layout Enumerate 763\layout Enumerate
653 764
@@ -845,7 +956,7 @@ After LogSQLTransferLogFormat you supply a string of characters that tell
845 and the request; you'd use: 956 and the request; you'd use:
846\layout LyX-Code 957\layout LyX-Code
847 958
848LogSQLTransferLogFormat HUS 959LogSQLTransferLogFormat hUS
849\layout Standard 960\layout Standard
850 961
851A more appropriate string to use is 962A more appropriate string to use is
@@ -964,25 +1075,16 @@ You already have a single table containing access requests.
964 in that module and employ the LogSQLTransferLogFormat character 'I'). 1075 in that module and employ the LogSQLTransferLogFormat character 'I').
965 Each request gets a unique ID that can be thought of as a primary key within 1076 Each request gets a unique ID that can be thought of as a primary key within
966 the database. 1077 the database.
967\layout Standard 1078 So let's add several new tables: a notes table, a cookies table, and tables
968
969So, let's add several new tables: a notes table, a cookies table, and tables
970 for inbound and outbound headers. 1079 for inbound and outbound headers.
971 We have a certain request, let's say its unique ID is 1080
972\begin_inset Quotes eld 1081\layout Standard
973\end_inset
974 1082
975XYZ123
976\begin_inset Quotes erd
977\end_inset
978 1083
979. 1084\begin_inset Float table
980 Within each separate table will be multiple entries with that request ID: 1085wide false
981 several cookie entries, several header entries, etc. 1086collapsed false
982 Something like this:
983\layout Standard
984 1087
985\begin_float tab
986\layout Caption 1088\layout Caption
987 1089
988 1090
@@ -995,13 +1097,13 @@ access_log
995\align center 1097\align center
996 1098
997\begin_inset Tabular 1099\begin_inset Tabular
998<lyxtabular version="2" rows="2" columns="3"> 1100<lyxtabular version="3" rows="2" columns="3">
999<features rotate="false" islongtable="false" endhead="0" endfirsthead="0" endfoot="0" endlastfoot="0"> 1101<features>
1000<column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> 1102<column alignment="left" valignment="top" leftline="true" width="0pt">
1001<column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> 1103<column alignment="left" valignment="top" leftline="true" width="0pt">
1002<column alignment="left" valignment="top" leftline="true" rightline="true" width="" special=""> 1104<column alignment="left" valignment="top" leftline="true" rightline="true" width="0pt">
1003<row topline="true" bottomline="true" newpage="false"> 1105<row topline="true" bottomline="true">
1004<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 1106<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
1005\begin_inset Text 1107\begin_inset Text
1006 1108
1007\layout Standard 1109\layout Standard
@@ -1009,7 +1111,7 @@ access_log
1009id 1111id
1010\end_inset 1112\end_inset
1011</cell> 1113</cell>
1012<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 1114<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
1013\begin_inset Text 1115\begin_inset Text
1014 1116
1015\layout Standard 1117\layout Standard
@@ -1017,7 +1119,7 @@ id
1017remote_host 1119remote_host
1018\end_inset 1120\end_inset
1019</cell> 1121</cell>
1020<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 1122<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
1021\begin_inset Text 1123\begin_inset Text
1022 1124
1023\layout Standard 1125\layout Standard
@@ -1026,8 +1128,8 @@ request_uri
1026\end_inset 1128\end_inset
1027</cell> 1129</cell>
1028</row> 1130</row>
1029<row topline="true" bottomline="true" newpage="false"> 1131<row topline="true" bottomline="true">
1030<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 1132<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
1031\begin_inset Text 1133\begin_inset Text
1032 1134
1033\layout Standard 1135\layout Standard
@@ -1035,7 +1137,7 @@ request_uri
1035XYZ123 1137XYZ123
1036\end_inset 1138\end_inset
1037</cell> 1139</cell>
1038<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 1140<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
1039\begin_inset Text 1141\begin_inset Text
1040 1142
1041\layout Standard 1143\layout Standard
@@ -1043,7 +1145,7 @@ XYZ123
1043foo.bar.com 1145foo.bar.com
1044\end_inset 1146\end_inset
1045</cell> 1147</cell>
1046<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 1148<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
1047\begin_inset Text 1149\begin_inset Text
1048 1150
1049\layout Standard 1151\layout Standard
@@ -1057,8 +1159,13 @@ foo.bar.com
1057\end_inset 1159\end_inset
1058 1160
1059 1161
1060\end_float 1162\end_inset
1061\begin_float tab 1163
1164
1165\begin_inset Float table
1166wide false
1167collapsed false
1168
1062\layout Caption 1169\layout Caption
1063 1170
1064 1171
@@ -1071,13 +1178,13 @@ notes_log
1071\align center 1178\align center
1072 1179
1073\begin_inset Tabular 1180\begin_inset Tabular
1074<lyxtabular version="2" rows="3" columns="3"> 1181<lyxtabular version="3" rows="3" columns="3">
1075<features rotate="false" islongtable="false" endhead="0" endfirsthead="0" endfoot="0" endlastfoot="0"> 1182<features>
1076<column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> 1183<column alignment="left" valignment="top" leftline="true" width="0pt">
1077<column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> 1184<column alignment="left" valignment="top" leftline="true" width="0pt">
1078<column alignment="left" valignment="top" leftline="true" rightline="true" width="" special=""> 1185<column alignment="left" valignment="top" leftline="true" rightline="true" width="0pt">
1079<row topline="true" bottomline="true" newpage="false"> 1186<row topline="true" bottomline="true">
1080<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 1187<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
1081\begin_inset Text 1188\begin_inset Text
1082 1189
1083\layout Standard 1190\layout Standard
@@ -1085,7 +1192,7 @@ notes_log
1085id 1192id
1086\end_inset 1193\end_inset
1087</cell> 1194</cell>
1088<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 1195<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
1089\begin_inset Text 1196\begin_inset Text
1090 1197
1091\layout Standard 1198\layout Standard
@@ -1093,7 +1200,7 @@ id
1093item 1200item
1094\end_inset 1201\end_inset
1095</cell> 1202</cell>
1096<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 1203<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
1097\begin_inset Text 1204\begin_inset Text
1098 1205
1099\layout Standard 1206\layout Standard
@@ -1102,8 +1209,8 @@ val
1102\end_inset 1209\end_inset
1103</cell> 1210</cell>
1104</row> 1211</row>
1105<row topline="true" bottomline="false" newpage="false"> 1212<row topline="true">
1106<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 1213<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
1107\begin_inset Text 1214\begin_inset Text
1108 1215
1109\layout Standard 1216\layout Standard
@@ -1111,7 +1218,7 @@ val
1111XYZ123 1218XYZ123
1112\end_inset 1219\end_inset
1113</cell> 1220</cell>
1114<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 1221<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
1115\begin_inset Text 1222\begin_inset Text
1116 1223
1117\layout Standard 1224\layout Standard
@@ -1119,7 +1226,7 @@ XYZ123
1119mod_gzip_result 1226mod_gzip_result
1120\end_inset 1227\end_inset
1121</cell> 1228</cell>
1122<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 1229<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
1123\begin_inset Text 1230\begin_inset Text
1124 1231
1125\layout Standard 1232\layout Standard
@@ -1128,8 +1235,8 @@ OK
1128\end_inset 1235\end_inset
1129</cell> 1236</cell>
1130</row> 1237</row>
1131<row topline="true" bottomline="true" newpage="false"> 1238<row topline="true" bottomline="true">
1132<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 1239<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
1133\begin_inset Text 1240\begin_inset Text
1134 1241
1135\layout Standard 1242\layout Standard
@@ -1137,7 +1244,7 @@ OK
1137XYZ123 1244XYZ123
1138\end_inset 1245\end_inset
1139</cell> 1246</cell>
1140<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 1247<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
1141\begin_inset Text 1248\begin_inset Text
1142 1249
1143\layout Standard 1250\layout Standard
@@ -1145,7 +1252,7 @@ XYZ123
1145mod_gzip_compression_ratio 1252mod_gzip_compression_ratio
1146\end_inset 1253\end_inset
1147</cell> 1254</cell>
1148<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 1255<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
1149\begin_inset Text 1256\begin_inset Text
1150 1257
1151\layout Standard 1258\layout Standard
@@ -1159,10 +1266,16 @@ mod_gzip_compression_ratio
1159\end_inset 1266\end_inset
1160 1267
1161 1268
1162\end_float 1269\end_inset
1270
1271
1163\layout Standard 1272\layout Standard
1164 1273
1165\begin_float tab 1274
1275\begin_inset Float table
1276wide false
1277collapsed false
1278
1166\layout Caption 1279\layout Caption
1167 1280
1168 1281
@@ -1175,13 +1288,13 @@ headers_log
1175\align center 1288\align center
1176 1289
1177\begin_inset Tabular 1290\begin_inset Tabular
1178<lyxtabular version="2" rows="5" columns="3"> 1291<lyxtabular version="3" rows="5" columns="3">
1179<features rotate="false" islongtable="false" endhead="0" endfirsthead="0" endfoot="0" endlastfoot="0"> 1292<features>
1180<column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> 1293<column alignment="left" valignment="top" leftline="true" width="0pt">
1181<column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> 1294<column alignment="left" valignment="top" leftline="true" width="0pt">
1182<column alignment="left" valignment="top" leftline="true" rightline="true" width="" special=""> 1295<column alignment="left" valignment="top" leftline="true" rightline="true" width="0pt">
1183<row topline="true" bottomline="true" newpage="false"> 1296<row topline="true" bottomline="true">
1184<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 1297<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
1185\begin_inset Text 1298\begin_inset Text
1186 1299
1187\layout Standard 1300\layout Standard
@@ -1189,7 +1302,7 @@ headers_log
1189id 1302id
1190\end_inset 1303\end_inset
1191</cell> 1304</cell>
1192<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 1305<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
1193\begin_inset Text 1306\begin_inset Text
1194 1307
1195\layout Standard 1308\layout Standard
@@ -1197,7 +1310,7 @@ id
1197item 1310item
1198\end_inset 1311\end_inset
1199</cell> 1312</cell>
1200<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 1313<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
1201\begin_inset Text 1314\begin_inset Text
1202 1315
1203\layout Standard 1316\layout Standard
@@ -1206,8 +1319,8 @@ val
1206\end_inset 1319\end_inset
1207</cell> 1320</cell>
1208</row> 1321</row>
1209<row topline="true" bottomline="false" newpage="false"> 1322<row topline="true">
1210<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 1323<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
1211\begin_inset Text 1324\begin_inset Text
1212 1325
1213\layout Standard 1326\layout Standard
@@ -1215,7 +1328,7 @@ val
1215XYZ123 1328XYZ123
1216\end_inset 1329\end_inset
1217</cell> 1330</cell>
1218<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 1331<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
1219\begin_inset Text 1332\begin_inset Text
1220 1333
1221\layout Standard 1334\layout Standard
@@ -1223,7 +1336,7 @@ XYZ123
1223Content-Type 1336Content-Type
1224\end_inset 1337\end_inset
1225</cell> 1338</cell>
1226<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 1339<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
1227\begin_inset Text 1340\begin_inset Text
1228 1341
1229\layout Standard 1342\layout Standard
@@ -1232,8 +1345,8 @@ text/html
1232\end_inset 1345\end_inset
1233</cell> 1346</cell>
1234</row> 1347</row>
1235<row topline="true" bottomline="false" newpage="false"> 1348<row topline="true">
1236<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 1349<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
1237\begin_inset Text 1350\begin_inset Text
1238 1351
1239\layout Standard 1352\layout Standard
@@ -1241,7 +1354,7 @@ text/html
1241XYZ123 1354XYZ123
1242\end_inset 1355\end_inset
1243</cell> 1356</cell>
1244<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 1357<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
1245\begin_inset Text 1358\begin_inset Text
1246 1359
1247\layout Standard 1360\layout Standard
@@ -1249,7 +1362,7 @@ XYZ123
1249Accept-Encoding 1362Accept-Encoding
1250\end_inset 1363\end_inset
1251</cell> 1364</cell>
1252<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 1365<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
1253\begin_inset Text 1366\begin_inset Text
1254 1367
1255\layout Standard 1368\layout Standard
@@ -1258,8 +1371,8 @@ gzip, deflate
1258\end_inset 1371\end_inset
1259</cell> 1372</cell>
1260</row> 1373</row>
1261<row topline="true" bottomline="false" newpage="false"> 1374<row topline="true">
1262<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 1375<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
1263\begin_inset Text 1376\begin_inset Text
1264 1377
1265\layout Standard 1378\layout Standard
@@ -1267,7 +1380,7 @@ gzip, deflate
1267XYZ123 1380XYZ123
1268\end_inset 1381\end_inset
1269</cell> 1382</cell>
1270<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 1383<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
1271\begin_inset Text 1384\begin_inset Text
1272 1385
1273\layout Standard 1386\layout Standard
@@ -1275,7 +1388,7 @@ XYZ123
1275Expires 1388Expires
1276\end_inset 1389\end_inset
1277</cell> 1390</cell>
1278<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 1391<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
1279\begin_inset Text 1392\begin_inset Text
1280 1393
1281\layout Standard 1394\layout Standard
@@ -1284,8 +1397,8 @@ Tue, 28 May 2002 10:00:18 GMT
1284\end_inset 1397\end_inset
1285</cell> 1398</cell>
1286</row> 1399</row>
1287<row topline="true" bottomline="true" newpage="false"> 1400<row topline="true" bottomline="true">
1288<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 1401<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
1289\begin_inset Text 1402\begin_inset Text
1290 1403
1291\layout Standard 1404\layout Standard
@@ -1293,7 +1406,7 @@ Tue, 28 May 2002 10:00:18 GMT
1293XYZ123 1406XYZ123
1294\end_inset 1407\end_inset
1295</cell> 1408</cell>
1296<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 1409<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
1297\begin_inset Text 1410\begin_inset Text
1298 1411
1299\layout Standard 1412\layout Standard
@@ -1301,7 +1414,7 @@ XYZ123
1301Cache-Control 1414Cache-Control
1302\end_inset 1415\end_inset
1303</cell> 1416</cell>
1304<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 1417<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
1305\begin_inset Text 1418\begin_inset Text
1306 1419
1307\layout Standard 1420\layout Standard
@@ -1315,10 +1428,23 @@ max-age=86400
1315\end_inset 1428\end_inset
1316 1429
1317 1430
1318\end_float 1431\end_inset
1432
1433
1319\layout Standard 1434\layout Standard
1320 1435
1321As you can see in tables 1436We have a certain request, and its unique ID is
1437\begin_inset Quotes eld
1438\end_inset
1439
1440XYZ123
1441\begin_inset Quotes erd
1442\end_inset
1443
1444.
1445 Within each separate table will be multiple entries with that request ID:
1446 several cookie entries, several header entries, etc.
1447 As you can see in tables
1322\begin_inset LatexCommand \ref{tblAcc} 1448\begin_inset LatexCommand \ref{tblAcc}
1323 1449
1324\end_inset 1450\end_inset
@@ -1348,21 +1474,24 @@ select
1348\layout LyX-Code 1474\layout LyX-Code
1349 1475
1350select a.remote_host, a.request_uri, n.item, n.val from access_log a, notes_log 1476select a.remote_host, a.request_uri, n.item, n.val from access_log a, notes_log
1351 n where a.id=n.id and a.id='PPIDskBRH30AAGPtAsg'; 1477 n
1478\layout LyX-Code
1479
1480where a.id=n.id and a.id='PPIDskBRH30AAGPtAsg';
1352\layout LyX-Code 1481\layout LyX-Code
1353 1482
1354\layout Standard 1483\layout Standard
1355\align center 1484\align center
1356 1485
1357\begin_inset Tabular 1486\begin_inset Tabular
1358<lyxtabular version="2" rows="3" columns="4"> 1487<lyxtabular version="3" rows="3" columns="4">
1359<features rotate="false" islongtable="false" endhead="0" endfirsthead="0" endfoot="0" endlastfoot="0"> 1488<features>
1360<column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> 1489<column alignment="left" valignment="top" leftline="true" width="0pt">
1361<column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> 1490<column alignment="left" valignment="top" leftline="true" width="0pt">
1362<column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> 1491<column alignment="left" valignment="top" leftline="true" width="0pt">
1363<column alignment="left" valignment="top" leftline="true" rightline="true" width="" special=""> 1492<column alignment="left" valignment="top" leftline="true" rightline="true" width="0pt">
1364<row topline="true" bottomline="true" newpage="false"> 1493<row topline="true" bottomline="true">
1365<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 1494<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
1366\begin_inset Text 1495\begin_inset Text
1367 1496
1368\layout Standard 1497\layout Standard
@@ -1370,7 +1499,7 @@ select a.remote_host, a.request_uri, n.item, n.val from access_log a, notes_log
1370remote_host 1499remote_host
1371\end_inset 1500\end_inset
1372</cell> 1501</cell>
1373<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 1502<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
1374\begin_inset Text 1503\begin_inset Text
1375 1504
1376\layout Standard 1505\layout Standard
@@ -1378,7 +1507,7 @@ remote_host
1378request_uri 1507request_uri
1379\end_inset 1508\end_inset
1380</cell> 1509</cell>
1381<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 1510<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
1382\begin_inset Text 1511\begin_inset Text
1383 1512
1384\layout Standard 1513\layout Standard
@@ -1386,7 +1515,7 @@ request_uri
1386item 1515item
1387\end_inset 1516\end_inset
1388</cell> 1517</cell>
1389<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 1518<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
1390\begin_inset Text 1519\begin_inset Text
1391 1520
1392\layout Standard 1521\layout Standard
@@ -1395,8 +1524,8 @@ val
1395\end_inset 1524\end_inset
1396</cell> 1525</cell>
1397</row> 1526</row>
1398<row topline="true" bottomline="false" newpage="false"> 1527<row topline="true">
1399<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 1528<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
1400\begin_inset Text 1529\begin_inset Text
1401 1530
1402\layout Standard 1531\layout Standard
@@ -1404,7 +1533,7 @@ val
1404zerberus.aiacs.net 1533zerberus.aiacs.net
1405\end_inset 1534\end_inset
1406</cell> 1535</cell>
1407<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 1536<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
1408\begin_inset Text 1537\begin_inset Text
1409 1538
1410\layout Standard 1539\layout Standard
@@ -1412,7 +1541,7 @@ zerberus.aiacs.net
1412/mod_log_sql/style_1.css 1541/mod_log_sql/style_1.css
1413\end_inset 1542\end_inset
1414</cell> 1543</cell>
1415<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 1544<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
1416\begin_inset Text 1545\begin_inset Text
1417 1546
1418\layout Standard 1547\layout Standard
@@ -1420,7 +1549,7 @@ zerberus.aiacs.net
1420mod_gzip_result 1549mod_gzip_result
1421\end_inset 1550\end_inset
1422</cell> 1551</cell>
1423<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 1552<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
1424\begin_inset Text 1553\begin_inset Text
1425 1554
1426\layout Standard 1555\layout Standard
@@ -1429,8 +1558,8 @@ DECLINED:EXCLUDED
1429\end_inset 1558\end_inset
1430</cell> 1559</cell>
1431</row> 1560</row>
1432<row topline="true" bottomline="true" newpage="false"> 1561<row topline="true" bottomline="true">
1433<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 1562<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
1434\begin_inset Text 1563\begin_inset Text
1435 1564
1436\layout Standard 1565\layout Standard
@@ -1438,7 +1567,7 @@ DECLINED:EXCLUDED
1438zerberus.aiacs.net 1567zerberus.aiacs.net
1439\end_inset 1568\end_inset
1440</cell> 1569</cell>
1441<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 1570<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
1442\begin_inset Text 1571\begin_inset Text
1443 1572
1444\layout Standard 1573\layout Standard
@@ -1446,7 +1575,7 @@ zerberus.aiacs.net
1446/mod_log_sql/style_1.css 1575/mod_log_sql/style_1.css
1447\end_inset 1576\end_inset
1448</cell> 1577</cell>
1449<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 1578<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
1450\begin_inset Text 1579\begin_inset Text
1451 1580
1452\layout Standard 1581\layout Standard
@@ -1454,7 +1583,7 @@ zerberus.aiacs.net
1454mod_gzip_compression_ratio 1583mod_gzip_compression_ratio
1455\end_inset 1584\end_inset
1456</cell> 1585</cell>
1457<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 1586<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
1458\begin_inset Text 1587\begin_inset Text
1459 1588
1460\layout Standard 1589\layout Standard
@@ -1944,860 +2073,1053 @@ Each character in the format-string defines an attribute of the request
1944\layout Quote 2073\layout Quote
1945 2074
1946 2075
2076\size footnotesize
2077
1947\begin_inset Tabular 2078\begin_inset Tabular
1948<lyxtabular version="2" rows="20" columns="5"> 2079<lyxtabular version="3" rows="20" columns="5">
1949<features rotate="false" islongtable="false" endhead="1" endfirsthead="1" endfoot="0" endlastfoot="0"> 2080<features>
1950<column alignment="center" valignment="top" leftline="true" rightline="true" width="" special=""> 2081<column alignment="center" valignment="top" leftline="true" rightline="true" width="0pt">
1951<column alignment="left" valignment="top" leftline="false" rightline="false" width="" special=""> 2082<column alignment="left" valignment="top" width="0pt">
1952<column alignment="left" valignment="top" leftline="true" rightline="true" width="" special=""> 2083<column alignment="left" valignment="top" leftline="true" rightline="true" width="0pt">
1953<column alignment="left" valignment="top" leftline="false" rightline="false" width="" special=""> 2084<column alignment="left" valignment="top" width="0pt">
1954<column alignment="left" valignment="top" leftline="true" rightline="true" width="" special=""> 2085<column alignment="left" valignment="top" leftline="true" rightline="true" width="0pt">
1955<row topline="true" bottomline="true" newpage="false"> 2086<row topline="true" bottomline="true" endhead="true">
1956<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="true" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2087<cell alignment="center" valignment="top" topline="true" bottomline="true" leftline="true" usebox="none">
1957\begin_inset Text 2088\begin_inset Text
1958 2089
1959\layout Standard 2090\layout Standard
1960 2091
1961
1962\series bold
1963Char
1964\end_inset 2092\end_inset
1965</cell> 2093</cell>
1966<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2094<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
1967\begin_inset Text 2095\begin_inset Text
1968 2096
1969\layout Standard 2097\layout Standard
1970 2098
1971 2099
1972\series bold 2100\series bold
2101\size footnotesize
1973What is this? 2102What is this?
1974\end_inset 2103\end_inset
1975</cell> 2104</cell>
1976<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2105<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
1977\begin_inset Text 2106\begin_inset Text
1978 2107
1979\layout Standard 2108\layout Standard
1980 2109
1981 2110
1982\series bold 2111\series bold
1983MySQL DB field 2112\size footnotesize
2113Data field
1984\end_inset 2114\end_inset
1985</cell> 2115</cell>
1986<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2116<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
1987\begin_inset Text 2117\begin_inset Text
1988 2118
1989\layout Standard 2119\layout Standard
1990 2120
1991 2121
1992\series bold 2122\series bold
2123\size footnotesize
1993Column type 2124Column type
1994\end_inset 2125\end_inset
1995</cell> 2126</cell>
1996<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2127<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
1997\begin_inset Text 2128\begin_inset Text
1998 2129
1999\layout Standard 2130\layout Standard
2000 2131
2001 2132
2002\series bold 2133\series bold
2134\size footnotesize
2003Example 2135Example
2004\end_inset 2136\end_inset
2005</cell> 2137</cell>
2006</row> 2138</row>
2007<row topline="true" bottomline="false" newpage="false"> 2139<row topline="true">
2008<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2140<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2009\begin_inset Text 2141\begin_inset Text
2010 2142
2011\layout Standard 2143\layout Standard
2012 2144
2145
2146\size footnotesize
2013A 2147A
2014\end_inset 2148\end_inset
2015</cell> 2149</cell>
2016<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2150<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2017\begin_inset Text 2151\begin_inset Text
2018 2152
2019\layout Standard 2153\layout Standard
2020 2154
2155
2156\size footnotesize
2021User agent 2157User agent
2022\end_inset 2158\end_inset
2023</cell> 2159</cell>
2024<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2160<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2025\begin_inset Text 2161\begin_inset Text
2026 2162
2027\layout Standard 2163\layout Standard
2028 2164
2165
2166\size footnotesize
2029agent 2167agent
2030\end_inset 2168\end_inset
2031</cell> 2169</cell>
2032<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2170<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2033\begin_inset Text 2171\begin_inset Text
2034 2172
2035\layout Standard 2173\layout Standard
2036 2174
2175
2176\size footnotesize
2037varchar(255) 2177varchar(255)
2038\end_inset 2178\end_inset
2039</cell> 2179</cell>
2040<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2180<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2041\begin_inset Text 2181\begin_inset Text
2042 2182
2043\layout Standard 2183\layout Standard
2044 2184
2185
2186\size footnotesize
2045Mozilla/4.0 (compat; MSIE 6.0; Windows) 2187Mozilla/4.0 (compat; MSIE 6.0; Windows)
2046\end_inset 2188\end_inset
2047</cell> 2189</cell>
2048</row> 2190</row>
2049<row topline="true" bottomline="false" newpage="false"> 2191<row topline="true">
2050<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2192<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2051\begin_inset Text 2193\begin_inset Text
2052 2194
2053\layout Standard 2195\layout Standard
2054 2196
2197
2198\size footnotesize
2055b 2199b
2056\end_inset 2200\end_inset
2057</cell> 2201</cell>
2058<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2202<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2059\begin_inset Text 2203\begin_inset Text
2060 2204
2061\layout Standard 2205\layout Standard
2062 2206
2207
2208\size footnotesize
2063Bytes transfered 2209Bytes transfered
2064\end_inset 2210\end_inset
2065</cell> 2211</cell>
2066<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2212<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2067\begin_inset Text 2213\begin_inset Text
2068 2214
2069\layout Standard 2215\layout Standard
2070 2216
2217
2218\size footnotesize
2071bytes_sent 2219bytes_sent
2072\end_inset 2220\end_inset
2073</cell> 2221</cell>
2074<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2222<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2075\begin_inset Text 2223\begin_inset Text
2076 2224
2077\layout Standard 2225\layout Standard
2078 2226
2227
2228\size footnotesize
2079int unsigned 2229int unsigned
2080\end_inset 2230\end_inset
2081</cell> 2231</cell>
2082<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2232<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2083\begin_inset Text 2233\begin_inset Text
2084 2234
2085\layout Standard 2235\layout Standard
2086 2236
2237
2238\size footnotesize
208732561 223932561
2088\end_inset 2240\end_inset
2089</cell> 2241</cell>
2090</row> 2242</row>
2091<row topline="true" bottomline="false" newpage="false"> 2243<row topline="true">
2092<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2244<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2093\begin_inset Text 2245\begin_inset Text
2094 2246
2095\layout Standard 2247\layout Standard
2096 2248
2249
2250\size footnotesize
2097c 2251c
2098\end_inset 2252\end_inset
2099</cell> 2253</cell>
2100<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2254<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2101\begin_inset Text 2255\begin_inset Text
2102 2256
2103\layout Standard 2257\layout Standard
2104 2258
2259
2260\size footnotesize
2105Text of cookie 2261Text of cookie
2106\end_inset 2262\end_inset
2107</cell> 2263</cell>
2108<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2264<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2109\begin_inset Text 2265\begin_inset Text
2110 2266
2111\layout Standard 2267\layout Standard
2112 2268
2269
2270\size footnotesize
2113cookie 2271cookie
2114\end_inset 2272\end_inset
2115</cell> 2273</cell>
2116<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2274<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2117\begin_inset Text 2275\begin_inset Text
2118 2276
2119\layout Standard 2277\layout Standard
2120 2278
2279
2280\size footnotesize
2121varchar(255) 2281varchar(255)
2122\end_inset 2282\end_inset
2123</cell> 2283</cell>
2124<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2284<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2125\begin_inset Text 2285\begin_inset Text
2126 2286
2127\layout Standard 2287\layout Standard
2128 2288
2289
2290\size footnotesize
2129Apache=sdyn.fooonline.net.1300102700823 2291Apache=sdyn.fooonline.net.1300102700823
2130\end_inset 2292\end_inset
2131</cell> 2293</cell>
2132</row> 2294</row>
2133<row topline="true" bottomline="false" newpage="false"> 2295<row topline="true">
2134<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2296<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2135\begin_inset Text 2297\begin_inset Text
2136 2298
2137\layout Standard 2299\layout Standard
2138 2300
2301
2302\size footnotesize
2139H 2303H
2140\end_inset 2304\end_inset
2141</cell> 2305</cell>
2142<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2306<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2143\begin_inset Text 2307\begin_inset Text
2144 2308
2145\layout Standard 2309\layout Standard
2146 2310
2311
2312\size footnotesize
2147HTTP request protocol 2313HTTP request protocol
2148\end_inset 2314\end_inset
2149</cell> 2315</cell>
2150<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2316<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2151\begin_inset Text 2317\begin_inset Text
2152 2318
2153\layout Standard 2319\layout Standard
2154 2320
2321
2322\size footnotesize
2155request_protocol 2323request_protocol
2156\end_inset 2324\end_inset
2157</cell> 2325</cell>
2158<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2326<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2159\begin_inset Text 2327\begin_inset Text
2160 2328
2161\layout Standard 2329\layout Standard
2162 2330
2331
2332\size footnotesize
2163varchar(10) 2333varchar(10)
2164\end_inset 2334\end_inset
2165</cell> 2335</cell>
2166<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2336<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2167\begin_inset Text 2337\begin_inset Text
2168 2338
2169\layout Standard 2339\layout Standard
2170 2340
2341
2342\size footnotesize
2171HTTP/1.1 2343HTTP/1.1
2172\end_inset 2344\end_inset
2173</cell> 2345</cell>
2174</row> 2346</row>
2175<row topline="true" bottomline="false" newpage="false"> 2347<row topline="true">
2176<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2348<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2177\begin_inset Text 2349\begin_inset Text
2178 2350
2179\layout Standard 2351\layout Standard
2180 2352
2353
2354\size footnotesize
2181h 2355h
2182\end_inset 2356\end_inset
2183</cell> 2357</cell>
2184<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2358<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2185\begin_inset Text 2359\begin_inset Text
2186 2360
2187\layout Standard 2361\layout Standard
2188 2362
2363
2364\size footnotesize
2189Name of remote host 2365Name of remote host
2190\end_inset 2366\end_inset
2191</cell> 2367</cell>
2192<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2368<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2193\begin_inset Text 2369\begin_inset Text
2194 2370
2195\layout Standard 2371\layout Standard
2196 2372
2373
2374\size footnotesize
2197remote_host 2375remote_host
2198\end_inset 2376\end_inset
2199</cell> 2377</cell>
2200<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2378<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2201\begin_inset Text 2379\begin_inset Text
2202 2380
2203\layout Standard 2381\layout Standard
2204 2382
2383
2384\size footnotesize
2205varchar(50) 2385varchar(50)
2206\end_inset 2386\end_inset
2207</cell> 2387</cell>
2208<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2388<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2209\begin_inset Text 2389\begin_inset Text
2210 2390
2211\layout Standard 2391\layout Standard
2212 2392
2393
2394\size footnotesize
2213blah.foobar.com 2395blah.foobar.com
2214\end_inset 2396\end_inset
2215</cell> 2397</cell>
2216</row> 2398</row>
2217<row topline="true" bottomline="false" newpage="false"> 2399<row topline="true">
2218<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2400<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2219\begin_inset Text 2401\begin_inset Text
2220 2402
2221\layout Standard 2403\layout Standard
2222 2404
2405
2406\size footnotesize
2223I 2407I
2224\end_inset 2408\end_inset
2225</cell> 2409</cell>
2226<cell multicolumn="0" alignment="left" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2410<cell alignment="left" valignment="top" topline="true" leftline="true" usebox="none">
2227\begin_inset Text 2411\begin_inset Text
2228 2412
2229\layout Standard 2413\layout Standard
2230 2414
2415
2416\size footnotesize
2231Request ID (from mod_unique_id) 2417Request ID (from mod_unique_id)
2232\end_inset 2418\end_inset
2233</cell> 2419</cell>
2234<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2420<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2235\begin_inset Text 2421\begin_inset Text
2236 2422
2237\layout Standard 2423\layout Standard
2238 2424
2425
2426\size footnotesize
2239id 2427id
2240\end_inset 2428\end_inset
2241</cell> 2429</cell>
2242<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2430<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2243\begin_inset Text 2431\begin_inset Text
2244 2432
2245\layout Standard 2433\layout Standard
2246 2434
2435
2436\size footnotesize
2247char(19) 2437char(19)
2248\end_inset 2438\end_inset
2249</cell> 2439</cell>
2250<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2440<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2251\begin_inset Text 2441\begin_inset Text
2252 2442
2253\layout Standard 2443\layout Standard
2254 2444
2445
2446\size footnotesize
2255POlFcUBRH30AAALdBG8 2447POlFcUBRH30AAALdBG8
2256\end_inset 2448\end_inset
2257</cell> 2449</cell>
2258</row> 2450</row>
2259<row topline="true" bottomline="false" newpage="false"> 2451<row topline="true">
2260<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2452<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2261\begin_inset Text 2453\begin_inset Text
2262 2454
2263\layout Standard 2455\layout Standard
2264 2456
2457
2458\size footnotesize
2265l 2459l
2266\end_inset 2460\end_inset
2267</cell> 2461</cell>
2268<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2462<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2269\begin_inset Text 2463\begin_inset Text
2270 2464
2271\layout Standard 2465\layout Standard
2272 2466
2467
2468\size footnotesize
2273Ident user info 2469Ident user info
2274\end_inset 2470\end_inset
2275</cell> 2471</cell>
2276<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2472<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2277\begin_inset Text 2473\begin_inset Text
2278 2474
2279\layout Standard 2475\layout Standard
2280 2476
2477
2478\size footnotesize
2281remote_logname 2479remote_logname
2282\end_inset 2480\end_inset
2283</cell> 2481</cell>
2284<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2482<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2285\begin_inset Text 2483\begin_inset Text
2286 2484
2287\layout Standard 2485\layout Standard
2288 2486
2487
2488\size footnotesize
2289varchar(50) 2489varchar(50)
2290\end_inset 2490\end_inset
2291</cell> 2491</cell>
2292<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2492<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2293\begin_inset Text 2493\begin_inset Text
2294 2494
2295\layout Standard 2495\layout Standard
2296 2496
2497
2498\size footnotesize
2297bobby 2499bobby
2298\end_inset 2500\end_inset
2299</cell> 2501</cell>
2300</row> 2502</row>
2301<row topline="true" bottomline="false" newpage="false"> 2503<row topline="true">
2302<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2504<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2303\begin_inset Text 2505\begin_inset Text
2304 2506
2305\layout Standard 2507\layout Standard
2306 2508
2509
2510\size footnotesize
2307m 2511m
2308\end_inset 2512\end_inset
2309</cell> 2513</cell>
2310<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2514<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2311\begin_inset Text 2515\begin_inset Text
2312 2516
2313\layout Standard 2517\layout Standard
2314 2518
2519
2520\size footnotesize
2315HTTP request method 2521HTTP request method
2316\end_inset 2522\end_inset
2317</cell> 2523</cell>
2318<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2524<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2319\begin_inset Text 2525\begin_inset Text
2320 2526
2321\layout Standard 2527\layout Standard
2322 2528
2529
2530\size footnotesize
2323request_method 2531request_method
2324\end_inset 2532\end_inset
2325</cell> 2533</cell>
2326<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2534<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2327\begin_inset Text 2535\begin_inset Text
2328 2536
2329\layout Standard 2537\layout Standard
2330 2538
2539
2540\size footnotesize
2331varchar(6) 2541varchar(6)
2332\end_inset 2542\end_inset
2333</cell> 2543</cell>
2334<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2544<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2335\begin_inset Text 2545\begin_inset Text
2336 2546
2337\layout Standard 2547\layout Standard
2338 2548
2549
2550\size footnotesize
2339GET 2551GET
2340\end_inset 2552\end_inset
2341</cell> 2553</cell>
2342</row> 2554</row>
2343<row topline="true" bottomline="false" newpage="false"> 2555<row topline="true">
2344<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2556<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2345\begin_inset Text 2557\begin_inset Text
2346 2558
2347\layout Standard 2559\layout Standard
2348 2560
2561
2562\size footnotesize
2349P 2563P
2350\end_inset 2564\end_inset
2351</cell> 2565</cell>
2352<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2566<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2353\begin_inset Text 2567\begin_inset Text
2354 2568
2355\layout Standard 2569\layout Standard
2356 2570
2571
2572\size footnotesize
2357httpd child PID 2573httpd child PID
2358\end_inset 2574\end_inset
2359</cell> 2575</cell>
2360<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2576<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2361\begin_inset Text 2577\begin_inset Text
2362 2578
2363\layout Standard 2579\layout Standard
2364 2580
2581
2582\size footnotesize
2365child_pid 2583child_pid
2366\end_inset 2584\end_inset
2367</cell> 2585</cell>
2368<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2586<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2369\begin_inset Text 2587\begin_inset Text
2370 2588
2371\layout Standard 2589\layout Standard
2372 2590
2591
2592\size footnotesize
2373smallint unsigned 2593smallint unsigned
2374\end_inset 2594\end_inset
2375</cell> 2595</cell>
2376<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2596<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2377\begin_inset Text 2597\begin_inset Text
2378 2598
2379\layout Standard 2599\layout Standard
2380 2600
2601
2602\size footnotesize
23813215 26033215
2382\end_inset 2604\end_inset
2383</cell> 2605</cell>
2384</row> 2606</row>
2385<row topline="true" bottomline="false" newpage="false"> 2607<row topline="true">
2386<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2608<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2387\begin_inset Text 2609\begin_inset Text
2388 2610
2389\layout Standard 2611\layout Standard
2390 2612
2613
2614\size footnotesize
2391p 2615p
2392\end_inset 2616\end_inset
2393</cell> 2617</cell>
2394<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2618<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2395\begin_inset Text 2619\begin_inset Text
2396 2620
2397\layout Standard 2621\layout Standard
2398 2622
2623
2624\size footnotesize
2399httpd port 2625httpd port
2400\end_inset 2626\end_inset
2401</cell> 2627</cell>
2402<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2628<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2403\begin_inset Text 2629\begin_inset Text
2404 2630
2405\layout Standard 2631\layout Standard
2406 2632
2633
2634\size footnotesize
2407server_port 2635server_port
2408\end_inset 2636\end_inset
2409</cell> 2637</cell>
2410<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2638<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2411\begin_inset Text 2639\begin_inset Text
2412 2640
2413\layout Standard 2641\layout Standard
2414 2642
2643
2644\size footnotesize
2415smallint unsigned 2645smallint unsigned
2416\end_inset 2646\end_inset
2417</cell> 2647</cell>
2418<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2648<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2419\begin_inset Text 2649\begin_inset Text
2420 2650
2421\layout Standard 2651\layout Standard
2422 2652
2653
2654\size footnotesize
242380 265580
2424\end_inset 2656\end_inset
2425</cell> 2657</cell>
2426</row> 2658</row>
2427<row topline="true" bottomline="false" newpage="false"> 2659<row topline="true">
2428<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2660<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2429\begin_inset Text 2661\begin_inset Text
2430 2662
2431\layout Standard 2663\layout Standard
2432 2664
2665
2666\size footnotesize
2433R 2667R
2434\end_inset 2668\end_inset
2435</cell> 2669</cell>
2436<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2670<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2437\begin_inset Text 2671\begin_inset Text
2438 2672
2439\layout Standard 2673\layout Standard
2440 2674
2675
2676\size footnotesize
2441Referer 2677Referer
2442\end_inset 2678\end_inset
2443</cell> 2679</cell>
2444<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2680<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2445\begin_inset Text 2681\begin_inset Text
2446 2682
2447\layout Standard 2683\layout Standard
2448 2684
2685
2686\size footnotesize
2449referer 2687referer
2450\end_inset 2688\end_inset
2451</cell> 2689</cell>
2452<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2690<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2453\begin_inset Text 2691\begin_inset Text
2454 2692
2455\layout Standard 2693\layout Standard
2456 2694
2695
2696\size footnotesize
2457varchar(255) 2697varchar(255)
2458\end_inset 2698\end_inset
2459</cell> 2699</cell>
2460<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2700<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2461\begin_inset Text 2701\begin_inset Text
2462 2702
2463\layout Standard 2703\layout Standard
2464 2704
2705
2706\size footnotesize
2465http://www.biglinks4u.com/linkpage.html 2707http://www.biglinks4u.com/linkpage.html
2466\end_inset 2708\end_inset
2467</cell> 2709</cell>
2468</row> 2710</row>
2469<row topline="true" bottomline="false" newpage="false"> 2711<row topline="true">
2470<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2712<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2471\begin_inset Text 2713\begin_inset Text
2472 2714
2473\layout Standard 2715\layout Standard
2474 2716
2717
2718\size footnotesize
2475r 2719r
2476\end_inset 2720\end_inset
2477</cell> 2721</cell>
2478<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2722<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2479\begin_inset Text 2723\begin_inset Text
2480 2724
2481\layout Standard 2725\layout Standard
2482 2726
2727
2728\size footnotesize
2483Request in full form 2729Request in full form
2484\end_inset 2730\end_inset
2485</cell> 2731</cell>
2486<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2732<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2487\begin_inset Text 2733\begin_inset Text
2488 2734
2489\layout Standard 2735\layout Standard
2490 2736
2737
2738\size footnotesize
2491request_line 2739request_line
2492\end_inset 2740\end_inset
2493</cell> 2741</cell>
2494<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2742<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2495\begin_inset Text 2743\begin_inset Text
2496 2744
2497\layout Standard 2745\layout Standard
2498 2746
2747
2748\size footnotesize
2499varchar(255) 2749varchar(255)
2500\end_inset 2750\end_inset
2501</cell> 2751</cell>
2502<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2752<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2503\begin_inset Text 2753\begin_inset Text
2504 2754
2505\layout Standard 2755\layout Standard
2506 2756
2757
2758\size footnotesize
2507GET /books-cycroad.html HTTP/1.1 2759GET /books-cycroad.html HTTP/1.1
2508\end_inset 2760\end_inset
2509</cell> 2761</cell>
2510</row> 2762</row>
2511<row topline="true" bottomline="false" newpage="false"> 2763<row topline="true">
2512<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2764<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2513\begin_inset Text 2765\begin_inset Text
2514 2766
2515\layout Standard 2767\layout Standard
2516 2768
2769
2770\size footnotesize
2517S 2771S
2518\end_inset 2772\end_inset
2519</cell> 2773</cell>
2520<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2774<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2521\begin_inset Text 2775\begin_inset Text
2522 2776
2523\layout Standard 2777\layout Standard
2524 2778
2779
2780\size footnotesize
2525Time of request in UNIX format 2781Time of request in UNIX format
2526\end_inset 2782\end_inset
2527</cell> 2783</cell>
2528<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2784<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2529\begin_inset Text 2785\begin_inset Text
2530 2786
2531\layout Standard 2787\layout Standard
2532 2788
2789
2790\size footnotesize
2533time_stamp 2791time_stamp
2534\end_inset 2792\end_inset
2535</cell> 2793</cell>
2536<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2794<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2537\begin_inset Text 2795\begin_inset Text
2538 2796
2539\layout Standard 2797\layout Standard
2540 2798
2799
2800\size footnotesize
2541int unsigned 2801int unsigned
2542\end_inset 2802\end_inset
2543</cell> 2803</cell>
2544<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2804<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2545\begin_inset Text 2805\begin_inset Text
2546 2806
2547\layout Standard 2807\layout Standard
2548 2808
2809
2810\size footnotesize
25491005598029 28111005598029
2550\end_inset 2812\end_inset
2551</cell> 2813</cell>
2552</row> 2814</row>
2553<row topline="true" bottomline="false" newpage="false"> 2815<row topline="true">
2554<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2816<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2555\begin_inset Text 2817\begin_inset Text
2556 2818
2557\layout Standard 2819\layout Standard
2558 2820
2821
2822\size footnotesize
2559s 2823s
2560\end_inset 2824\end_inset
2561</cell> 2825</cell>
2562<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2826<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2563\begin_inset Text 2827\begin_inset Text
2564 2828
2565\layout Standard 2829\layout Standard
2566 2830
2831
2832\size footnotesize
2567HTTP status of request 2833HTTP status of request
2568\end_inset 2834\end_inset
2569</cell> 2835</cell>
2570<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2836<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2571\begin_inset Text 2837\begin_inset Text
2572 2838
2573\layout Standard 2839\layout Standard
2574 2840
2841
2842\size footnotesize
2575status 2843status
2576\end_inset 2844\end_inset
2577</cell> 2845</cell>
2578<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2846<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2579\begin_inset Text 2847\begin_inset Text
2580 2848
2581\layout Standard 2849\layout Standard
2582 2850
2851
2852\size footnotesize
2583smallint unsigned 2853smallint unsigned
2584\end_inset 2854\end_inset
2585</cell> 2855</cell>
2586<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2856<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2587\begin_inset Text 2857\begin_inset Text
2588 2858
2589\layout Standard 2859\layout Standard
2590 2860
2861
2862\size footnotesize
2591404 2863404
2592\end_inset 2864\end_inset
2593</cell> 2865</cell>
2594</row> 2866</row>
2595<row topline="true" bottomline="false" newpage="false"> 2867<row topline="true">
2596<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2868<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2597\begin_inset Text 2869\begin_inset Text
2598 2870
2599\layout Standard 2871\layout Standard
2600 2872
2873
2874\size footnotesize
2601T 2875T
2602\end_inset 2876\end_inset
2603</cell> 2877</cell>
2604<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2878<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2605\begin_inset Text 2879\begin_inset Text
2606 2880
2607\layout Standard 2881\layout Standard
2608 2882
2883
2884\size footnotesize
2609Seconds to service request 2885Seconds to service request
2610\end_inset 2886\end_inset
2611</cell> 2887</cell>
2612<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2888<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2613\begin_inset Text 2889\begin_inset Text
2614 2890
2615\layout Standard 2891\layout Standard
2616 2892
2893
2894\size footnotesize
2617request_duration 2895request_duration
2618\end_inset 2896\end_inset
2619</cell> 2897</cell>
2620<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2898<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2621\begin_inset Text 2899\begin_inset Text
2622 2900
2623\layout Standard 2901\layout Standard
2624 2902
2903
2904\size footnotesize
2625smallint unsigned 2905smallint unsigned
2626\end_inset 2906\end_inset
2627</cell> 2907</cell>
2628<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2908<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2629\begin_inset Text 2909\begin_inset Text
2630 2910
2631\layout Standard 2911\layout Standard
2632 2912
2913
2914\size footnotesize
26332 29152
2634\end_inset 2916\end_inset
2635</cell> 2917</cell>
2636</row> 2918</row>
2637<row topline="true" bottomline="false" newpage="false"> 2919<row topline="true">
2638<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2920<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2639\begin_inset Text 2921\begin_inset Text
2640 2922
2641\layout Standard 2923\layout Standard
2642 2924
2925
2926\size footnotesize
2643t 2927t
2644\end_inset 2928\end_inset
2645</cell> 2929</cell>
2646<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2930<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2647\begin_inset Text 2931\begin_inset Text
2648 2932
2649\layout Standard 2933\layout Standard
2650 2934
2935
2936\size footnotesize
2651Time of request in human format 2937Time of request in human format
2652\end_inset 2938\end_inset
2653</cell> 2939</cell>
2654<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2940<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2655\begin_inset Text 2941\begin_inset Text
2656 2942
2657\layout Standard 2943\layout Standard
2658 2944
2945
2946\size footnotesize
2659request_time 2947request_time
2660\end_inset 2948\end_inset
2661</cell> 2949</cell>
2662<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2950<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2663\begin_inset Text 2951\begin_inset Text
2664 2952
2665\layout Standard 2953\layout Standard
2666 2954
2955
2956\size footnotesize
2667char(28) 2957char(28)
2668\end_inset 2958\end_inset
2669</cell> 2959</cell>
2670<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2960<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2671\begin_inset Text 2961\begin_inset Text
2672 2962
2673\layout Standard 2963\layout Standard
2674 2964
2965
2966\size footnotesize
2675[02/Dec/2001:15:01:26 -0800] 2967[02/Dec/2001:15:01:26 -0800]
2676\end_inset 2968\end_inset
2677</cell> 2969</cell>
2678</row> 2970</row>
2679<row topline="true" bottomline="false" newpage="false"> 2971<row topline="true">
2680<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2972<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2681\begin_inset Text 2973\begin_inset Text
2682 2974
2683\layout Standard 2975\layout Standard
2684 2976
2977
2978\size footnotesize
2685U 2979U
2686\end_inset 2980\end_inset
2687</cell> 2981</cell>
2688<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2982<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2689\begin_inset Text 2983\begin_inset Text
2690 2984
2691\layout Standard 2985\layout Standard
2692 2986
2987
2988\size footnotesize
2693Request in simple form 2989Request in simple form
2694\end_inset 2990\end_inset
2695</cell> 2991</cell>
2696<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 2992<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2697\begin_inset Text 2993\begin_inset Text
2698 2994
2699\layout Standard 2995\layout Standard
2700 2996
2997
2998\size footnotesize
2701request_uri 2999request_uri
2702\end_inset 3000\end_inset
2703</cell> 3001</cell>
2704<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3002<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2705\begin_inset Text 3003\begin_inset Text
2706 3004
2707\layout Standard 3005\layout Standard
2708 3006
3007
3008\size footnotesize
2709varchar(255) 3009varchar(255)
2710\end_inset 3010\end_inset
2711</cell> 3011</cell>
2712<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3012<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2713\begin_inset Text 3013\begin_inset Text
2714 3014
2715\layout Standard 3015\layout Standard
2716 3016
3017
3018\size footnotesize
2717/books-cycroad.html 3019/books-cycroad.html
2718\end_inset 3020\end_inset
2719</cell> 3021</cell>
2720</row> 3022</row>
2721<row topline="true" bottomline="false" newpage="false"> 3023<row topline="true">
2722<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3024<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2723\begin_inset Text 3025\begin_inset Text
2724 3026
2725\layout Standard 3027\layout Standard
2726 3028
3029
3030\size footnotesize
2727u 3031u
2728\end_inset 3032\end_inset
2729</cell> 3033</cell>
2730<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3034<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2731\begin_inset Text 3035\begin_inset Text
2732 3036
2733\layout Standard 3037\layout Standard
2734 3038
2735User info from HTTP authentication 3039
3040\size footnotesize
3041User info from HTTP auth
2736\end_inset 3042\end_inset
2737</cell> 3043</cell>
2738<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3044<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2739\begin_inset Text 3045\begin_inset Text
2740 3046
2741\layout Standard 3047\layout Standard
2742 3048
3049
3050\size footnotesize
2743remote_user 3051remote_user
2744\end_inset 3052\end_inset
2745</cell> 3053</cell>
2746<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3054<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2747\begin_inset Text 3055\begin_inset Text
2748 3056
2749\layout Standard 3057\layout Standard
2750 3058
3059
3060\size footnotesize
2751varchar(50) 3061varchar(50)
2752\end_inset 3062\end_inset
2753</cell> 3063</cell>
2754<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3064<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2755\begin_inset Text 3065\begin_inset Text
2756 3066
2757\layout Standard 3067\layout Standard
2758 3068
3069
3070\size footnotesize
2759bobby 3071bobby
2760\end_inset 3072\end_inset
2761</cell> 3073</cell>
2762</row> 3074</row>
2763<row topline="true" bottomline="true" newpage="false"> 3075<row topline="true" bottomline="true">
2764<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3076<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2765\begin_inset Text 3077\begin_inset Text
2766 3078
2767\layout Standard 3079\layout Standard
2768 3080
3081
3082\size footnotesize
2769v 3083v
2770\end_inset 3084\end_inset
2771</cell> 3085</cell>
2772<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3086<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2773\begin_inset Text 3087\begin_inset Text
2774 3088
2775\layout Standard 3089\layout Standard
2776 3090
3091
3092\size footnotesize
2777Virtual host servicing the request 3093Virtual host servicing the request
2778\end_inset 3094\end_inset
2779</cell> 3095</cell>
2780<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3096<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2781\begin_inset Text 3097\begin_inset Text
2782 3098
2783\layout Standard 3099\layout Standard
2784 3100
3101
3102\size footnotesize
2785virtual_host 3103virtual_host
2786\end_inset 3104\end_inset
2787</cell> 3105</cell>
2788<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3106<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2789\begin_inset Text 3107\begin_inset Text
2790 3108
2791\layout Standard 3109\layout Standard
2792 3110
3111
3112\size footnotesize
2793varchar(50) 3113varchar(50)
2794\end_inset 3114\end_inset
2795</cell> 3115</cell>
2796<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3116<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2797\begin_inset Text 3117\begin_inset Text
2798 3118
2799\layout Standard 3119\layout Standard
2800 3120
3121
3122\size footnotesize
2801www.foobar.com 3123www.foobar.com
2802\end_inset 3124\end_inset
2803</cell> 3125</cell>
@@ -2814,25 +3136,22 @@ If you have compiled mod_log_sql with WANT_SSL_LOGGING, you also get these:
2814 3136
2815 3137
2816\begin_inset Tabular 3138\begin_inset Tabular
2817<lyxtabular version="2" rows="4" columns="5"> 3139<lyxtabular version="3" rows="4" columns="5">
2818<features rotate="false" islongtable="false" endhead="0" endfirsthead="0" endfoot="0" endlastfoot="0"> 3140<features>
2819<column alignment="center" valignment="top" leftline="true" rightline="false" width="" special=""> 3141<column alignment="center" valignment="top" leftline="true" width="0pt">
2820<column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> 3142<column alignment="left" valignment="top" leftline="true" width="0pt">
2821<column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> 3143<column alignment="left" valignment="top" leftline="true" width="0pt">
2822<column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> 3144<column alignment="left" valignment="top" leftline="true" width="0pt">
2823<column alignment="left" valignment="top" leftline="true" rightline="true" width="" special=""> 3145<column alignment="left" valignment="top" leftline="true" rightline="true" width="0pt">
2824<row topline="true" bottomline="true" newpage="false"> 3146<row topline="true" bottomline="true">
2825<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3147<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2826\begin_inset Text 3148\begin_inset Text
2827 3149
2828\layout Standard 3150\layout Standard
2829 3151
2830
2831\series bold
2832Char
2833\end_inset 3152\end_inset
2834</cell> 3153</cell>
2835<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3154<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2836\begin_inset Text 3155\begin_inset Text
2837 3156
2838\layout Standard 3157\layout Standard
@@ -2842,17 +3161,17 @@ Char
2842What is this? 3161What is this?
2843\end_inset 3162\end_inset
2844</cell> 3163</cell>
2845<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3164<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2846\begin_inset Text 3165\begin_inset Text
2847 3166
2848\layout Standard 3167\layout Standard
2849 3168
2850 3169
2851\series bold 3170\series bold
2852MySQL DB field 3171Data field
2853\end_inset 3172\end_inset
2854</cell> 3173</cell>
2855<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3174<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2856\begin_inset Text 3175\begin_inset Text
2857 3176
2858\layout Standard 3177\layout Standard
@@ -2862,7 +3181,7 @@ MySQL DB field
2862Column Type 3181Column Type
2863\end_inset 3182\end_inset
2864</cell> 3183</cell>
2865<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 3184<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
2866\begin_inset Text 3185\begin_inset Text
2867 3186
2868\layout Standard 3187\layout Standard
@@ -2873,8 +3192,8 @@ Example
2873\end_inset 3192\end_inset
2874</cell> 3193</cell>
2875</row> 3194</row>
2876<row topline="true" bottomline="false" newpage="false"> 3195<row topline="true">
2877<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3196<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2878\begin_inset Text 3197\begin_inset Text
2879 3198
2880\layout Standard 3199\layout Standard
@@ -2882,7 +3201,7 @@ Example
2882z 3201z
2883\end_inset 3202\end_inset
2884</cell> 3203</cell>
2885<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3204<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2886\begin_inset Text 3205\begin_inset Text
2887 3206
2888\layout Standard 3207\layout Standard
@@ -2890,7 +3209,7 @@ z
2890SSL cipher used 3209SSL cipher used
2891\end_inset 3210\end_inset
2892</cell> 3211</cell>
2893<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3212<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2894\begin_inset Text 3213\begin_inset Text
2895 3214
2896\layout Standard 3215\layout Standard
@@ -2898,7 +3217,7 @@ SSL cipher used
2898ssl_cipher 3217ssl_cipher
2899\end_inset 3218\end_inset
2900</cell> 3219</cell>
2901<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3220<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2902\begin_inset Text 3221\begin_inset Text
2903 3222
2904\layout Standard 3223\layout Standard
@@ -2906,7 +3225,7 @@ ssl_cipher
2906varchar(25) 3225varchar(25)
2907\end_inset 3226\end_inset
2908</cell> 3227</cell>
2909<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 3228<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
2910\begin_inset Text 3229\begin_inset Text
2911 3230
2912\layout Standard 3231\layout Standard
@@ -2915,8 +3234,8 @@ RC4-MD5
2915\end_inset 3234\end_inset
2916</cell> 3235</cell>
2917</row> 3236</row>
2918<row topline="true" bottomline="false" newpage="false"> 3237<row topline="true">
2919<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3238<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2920\begin_inset Text 3239\begin_inset Text
2921 3240
2922\layout Standard 3241\layout Standard
@@ -2924,7 +3243,7 @@ RC4-MD5
2924q 3243q
2925\end_inset 3244\end_inset
2926</cell> 3245</cell>
2927<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3246<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2928\begin_inset Text 3247\begin_inset Text
2929 3248
2930\layout Standard 3249\layout Standard
@@ -2932,7 +3251,7 @@ q
2932Keysize of the SSL connection 3251Keysize of the SSL connection
2933\end_inset 3252\end_inset
2934</cell> 3253</cell>
2935<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3254<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2936\begin_inset Text 3255\begin_inset Text
2937 3256
2938\layout Standard 3257\layout Standard
@@ -2940,7 +3259,7 @@ Keysize of the SSL connection
2940ssl_keysize 3259ssl_keysize
2941\end_inset 3260\end_inset
2942</cell> 3261</cell>
2943<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3262<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2944\begin_inset Text 3263\begin_inset Text
2945 3264
2946\layout Standard 3265\layout Standard
@@ -2948,7 +3267,7 @@ ssl_keysize
2948smallint unsigned 3267smallint unsigned
2949\end_inset 3268\end_inset
2950</cell> 3269</cell>
2951<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 3270<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
2952\begin_inset Text 3271\begin_inset Text
2953 3272
2954\layout Standard 3273\layout Standard
@@ -2957,8 +3276,8 @@ smallint unsigned
2957\end_inset 3276\end_inset
2958</cell> 3277</cell>
2959</row> 3278</row>
2960<row topline="true" bottomline="true" newpage="false"> 3279<row topline="true" bottomline="true">
2961<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3280<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2962\begin_inset Text 3281\begin_inset Text
2963 3282
2964\layout Standard 3283\layout Standard
@@ -2966,7 +3285,7 @@ smallint unsigned
2966Q 3285Q
2967\end_inset 3286\end_inset
2968</cell> 3287</cell>
2969<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3288<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2970\begin_inset Text 3289\begin_inset Text
2971 3290
2972\layout Standard 3291\layout Standard
@@ -2974,7 +3293,7 @@ Q
2974Maximum keysize supported 3293Maximum keysize supported
2975\end_inset 3294\end_inset
2976</cell> 3295</cell>
2977<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3296<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2978\begin_inset Text 3297\begin_inset Text
2979 3298
2980\layout Standard 3299\layout Standard
@@ -2982,7 +3301,7 @@ Maximum keysize supported
2982ssl_maxkeysize 3301ssl_maxkeysize
2983\end_inset 3302\end_inset
2984</cell> 3303</cell>
2985<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3304<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
2986\begin_inset Text 3305\begin_inset Text
2987 3306
2988\layout Standard 3307\layout Standard
@@ -2990,7 +3309,7 @@ ssl_maxkeysize
2990smallint unsigned 3309smallint unsigned
2991\end_inset 3310\end_inset
2992</cell> 3311</cell>
2993<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 3312<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
2994\begin_inset Text 3313\begin_inset Text
2995 3314
2996\layout Standard 3315\layout Standard
@@ -3015,8 +3334,7 @@ Syntax: LogSQLWhichCookie cookiename
3015Example: LogSQLWhichCookie Clicks 3334Example: LogSQLWhichCookie Clicks
3016\layout LyX-Code 3335\layout LyX-Code
3017 3336
3018Default: None. 3337Default: None
3019 You must set this if you wish to capture cookies.
3020\layout LyX-Code 3338\layout LyX-Code
3021 3339
3022Context: virtual host 3340Context: virtual host
@@ -3027,17 +3345,19 @@ In HTTP, cookies have names to distinguish them from each other.
3027 a name with the CookieName directive. 3345 a name with the CookieName directive.
3028\layout Quote 3346\layout Quote
3029 3347
3030If you have activated cookie logging in LogSQLTransferLogFormat, then LogSQLWhic 3348You must include a 'c' character in LogSQLTransferLogFormat for this directive
3031hCookie tells mod_log_sql which cookie to log. 3349 to take effect; once you specify 'c', LogSQLWhichCookie tells mod_log_sql
3032 This is useful because many times you will be setting and receiving more 3350 which cookie to log.
3033 than one cookie from a client; without this directive you'd be unable to 3351 This is necessary because many times you will be setting and receiving
3034 choose which cookie is your mod_usertrack cookie. 3352 more than one cookie from a client; without this directive you'd be unable
3353 to choose which cookie is your mod_usertrack cookie.
3035\layout Quote 3354\layout Quote
3036 3355
3037Note: although this was intended for people who are using mod_usertrack 3356Note: although this was intended for people who are using mod_usertrack
3038 to set user-tracking cookies, you aren't restricted in any way. 3357 to set user-tracking cookies, you aren't restricted in any way.
3039 You can choose which cookie you wish to log to the database, and it doesn't 3358 You can choose which cookie you wish to log to the database --any cookie
3040 necessarily have to have anything to do with mod_usertrack. 3359 at all -- and it doesn't necessarily have to have anything to do with mod_usert
3360rack.
3041\layout Subsubsection 3361\layout Subsubsection
3042 3362
3043LogSQLWhichCookies 3363LogSQLWhichCookies
@@ -3057,7 +3377,23 @@ Context: virtual host
3057\layout Quote 3377\layout Quote
3058 3378
3059Defines the list of cookies you would like logged. 3379Defines the list of cookies you would like logged.
3060 Works in conjunction with LogSQLCookieLogTable. 3380 This works in conjunction with LogSQLCookieLogTable.
3381 This directive does not require any additional characters to be added to
3382 the LogSQLTransferLogFormat string.
3383 The feature is activated simply by including this directive, upon which
3384 you will begin populating the separate cookie table with data.
3385\layout Quote
3386
3387Note that you must have already created the table (see create-tables.sql,
3388 included in the package), or LogSQLCreateTables must be set to
3389\begin_inset Quotes eld
3390\end_inset
3391
3392on
3393\begin_inset Quotes erd
3394\end_inset
3395
3396.
3061\layout Subsubsection 3397\layout Subsubsection
3062 3398
3063LogSQLWhichHeadersIn 3399LogSQLWhichHeadersIn
@@ -3077,7 +3413,23 @@ Context: virtual host
3077\layout Quote 3413\layout Quote
3078 3414
3079Defines the list of inbound headers you would like logged. 3415Defines the list of inbound headers you would like logged.
3080 Works in conjunction with LogSQLHeadersInLogTable. 3416 This works in conjunction with LogSQLHeadersInLogTable.
3417 This directive does not require any additional characters to be added to
3418 the LogSQLTransferLogFormat string.
3419 The feature is activated simply by including this directive, upon which
3420 you will begin populating the separate inbound-headers table with data.
3421\layout Quote
3422
3423Note that you must have already created the table (see create-tables.sql,
3424 included in the package), or LogSQLCreateTables must be set to
3425\begin_inset Quotes eld
3426\end_inset
3427
3428on
3429\begin_inset Quotes erd
3430\end_inset
3431
3432.
3081\layout Subsubsection 3433\layout Subsubsection
3082 3434
3083LogSQLWhichHeadersOut 3435LogSQLWhichHeadersOut
@@ -3097,7 +3449,23 @@ Context: virtual host
3097\layout Quote 3449\layout Quote
3098 3450
3099Defines the list of outbound headers you would like logged. 3451Defines the list of outbound headers you would like logged.
3100 Works in conjunction with LogSQLHeadersOutLogTable. 3452 This works in conjunction with LogSQLHeadersOutLogTable.
3453 This directive does not require any additional characters to be added to
3454 the LogSQLTransferLogFormat string.
3455 The feature is activated simply by including this directive, upon which
3456 you will begin populating the separate outbound-headers table with data.
3457\layout Quote
3458
3459Note that you must have already created the table (see create-tables.sql,
3460 included in the package), or LogSQLCreateTables must be set to
3461\begin_inset Quotes eld
3462\end_inset
3463
3464on
3465\begin_inset Quotes erd
3466\end_inset
3467
3468.
3101\layout Subsubsection 3469\layout Subsubsection
3102 3470
3103LogSQLWhichNotes 3471LogSQLWhichNotes
@@ -3117,7 +3485,23 @@ Context: virtual host
3117\layout Quote 3485\layout Quote
3118 3486
3119Defines the list of notes you would like logged. 3487Defines the list of notes you would like logged.
3120 Works in conjunction with LogSQLNotesLogTable. 3488 This works in conjunction with LogSQLNotesLogTable.
3489 This directive does not require any additional characters to be added to
3490 the LogSQLTransferLogFormat string.
3491 The feature is activated simply by including this directive, upon which
3492 you will begin populating the separate notes table with data.
3493\layout Quote
3494
3495Note that you must have already created the table (see create-tables.sql,
3496 included in the package), or LogSQLCreateTables must be set to
3497\begin_inset Quotes eld
3498\end_inset
3499
3500on
3501\begin_inset Quotes erd
3502\end_inset
3503
3504.
3121\layout Subsubsection 3505\layout Subsubsection
3122 3506
3123LogSQLCookieLogTable 3507LogSQLCookieLogTable
@@ -3140,6 +3524,18 @@ Defines which table is used for logging of cookies.
3140 request's associated cookies to a separate table. 3524 request's associated cookies to a separate table.
3141 For meaningful data retrieval the cookie table is keyed to the access table 3525 For meaningful data retrieval the cookie table is keyed to the access table
3142 by the unique request ID supplied by the standard Apache module mod_unique_id. 3526 by the unique request ID supplied by the standard Apache module mod_unique_id.
3527\layout Quote
3528
3529Note that you must create the table (see create-tables.sql, included in the
3530 package), or LogSQLCreateTables must be set to
3531\begin_inset Quotes eld
3532\end_inset
3533
3534on
3535\begin_inset Quotes erd
3536\end_inset
3537
3538.
3143\layout Subsubsection 3539\layout Subsubsection
3144 3540
3145LogSQLHeadersInLogTable 3541LogSQLHeadersInLogTable
@@ -3163,6 +3559,18 @@ Defines which table is used for logging of inbound headers.
3163 For meaningful data retrieval the headers table is keyed to the access 3559 For meaningful data retrieval the headers table is keyed to the access
3164 table by the unique request ID supplied by the standard Apache module mod_uniqu 3560 table by the unique request ID supplied by the standard Apache module mod_uniqu
3165e_id. 3561e_id.
3562\layout Quote
3563
3564Note that you must create the table (see create-tables.sql, included in the
3565 package), or LogSQLCreateTables must be set to
3566\begin_inset Quotes eld
3567\end_inset
3568
3569on
3570\begin_inset Quotes erd
3571\end_inset
3572
3573.
3166\layout Subsubsection 3574\layout Subsubsection
3167 3575
3168LogSQLHeadersOutLogTable 3576LogSQLHeadersOutLogTable
@@ -3186,6 +3594,18 @@ Defines which table is used for logging of outbound headers.
3186 For meaningful data retrieval the headers table is keyed to the access 3594 For meaningful data retrieval the headers table is keyed to the access
3187 table by the unique request ID supplied by the standard Apache module mod_uniqu 3595 table by the unique request ID supplied by the standard Apache module mod_uniqu
3188e_id. 3596e_id.
3597\layout Quote
3598
3599Note that you must create the table (see create-tables.sql, included in the
3600 package), or LogSQLCreateTables must be set to
3601\begin_inset Quotes eld
3602\end_inset
3603
3604on
3605\begin_inset Quotes erd
3606\end_inset
3607
3608.
3189\layout Subsubsection 3609\layout Subsubsection
3190 3610
3191LogSQLNotesLogTable 3611LogSQLNotesLogTable
@@ -3208,6 +3628,18 @@ Defines which table is used for logging of notes.
3208 request's associated notes to a separate table. 3628 request's associated notes to a separate table.
3209 For meaningful data retrieval the notes table is keyed to the access table 3629 For meaningful data retrieval the notes table is keyed to the access table
3210 by the unique request ID supplied by the standard Apache module mod_unique_id. 3630 by the unique request ID supplied by the standard Apache module mod_unique_id.
3631\layout Quote
3632
3633Note that you must create the table (see create-tables.sql, included in the
3634 package), or LogSQLCreateTables must be set to
3635\begin_inset Quotes eld
3636\end_inset
3637
3638on
3639\begin_inset Quotes erd
3640\end_inset
3641
3642.
3211\layout Section 3643\layout Section
3212 3644
3213FAQ 3645FAQ
@@ -3226,13 +3658,12 @@ To begin with, let's get it out of the way: logging to a database is not
3226Chores like log rotation go away, as you can DELETE records from the SQL 3658Chores like log rotation go away, as you can DELETE records from the SQL
3227 database once they are no longer useful. 3659 database once they are no longer useful.
3228 For example, the excellent and popular log-analysis tool 3660 For example, the excellent and popular log-analysis tool
3229\begin_inset LatexCommand \url[Webalizer]{http://www.webalizer.com} 3661\begin_inset LatexCommand \url[Webalizer]{(http://www.webalizer.com)}
3230 3662
3231\end_inset 3663\end_inset
3232 3664
3233 does not need historic logs after it has processed them, enabling you to 3665 does not need historic logs after it has processed them, enabling you to
3234 delete older logs. 3666 delete older logs.
3235
3236\layout Itemize 3667\layout Itemize
3237 3668
3238People with clusters of web servers (for high availability) will benefit 3669People with clusters of web servers (for high availability) will benefit
@@ -3250,22 +3681,24 @@ For example, do you want to see all your 404's? Do this:
3250\layout LyX-Code 3681\layout LyX-Code
3251 3682
3252select remote_host,status,request_uri,bytes_sent,from_unixtime(time_stamp) 3683select remote_host,status,request_uri,bytes_sent,from_unixtime(time_stamp)
3253 from acc_log_tbl where status=404 order by time_stamp; 3684\layout LyX-Code
3685
3686from acc_log_tbl where status=404 order by time_stamp;
3254\layout LyX-Code 3687\layout LyX-Code
3255 3688
3256\layout Standard 3689\layout Standard
3257\align center 3690\align center
3258 3691
3259\begin_inset Tabular 3692\begin_inset Tabular
3260<lyxtabular version="2" rows="5" columns="5"> 3693<lyxtabular version="3" rows="5" columns="5">
3261<features rotate="false" islongtable="false" endhead="0" endfirsthead="0" endfoot="0" endlastfoot="0"> 3694<features>
3262<column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> 3695<column alignment="left" valignment="top" leftline="true" width="0pt">
3263<column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> 3696<column alignment="left" valignment="top" leftline="true" width="0pt">
3264<column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> 3697<column alignment="left" valignment="top" leftline="true" width="0pt">
3265<column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> 3698<column alignment="left" valignment="top" leftline="true" width="0pt">
3266<column alignment="left" valignment="top" leftline="true" rightline="true" width="" special=""> 3699<column alignment="left" valignment="top" leftline="true" rightline="true" width="0pt">
3267<row topline="true" bottomline="true" newpage="false"> 3700<row topline="true" bottomline="true">
3268<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3701<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3269\begin_inset Text 3702\begin_inset Text
3270 3703
3271\layout Standard 3704\layout Standard
@@ -3273,7 +3706,7 @@ select remote_host,status,request_uri,bytes_sent,from_unixtime(time_stamp)
3273remote_host 3706remote_host
3274\end_inset 3707\end_inset
3275</cell> 3708</cell>
3276<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3709<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3277\begin_inset Text 3710\begin_inset Text
3278 3711
3279\layout Standard 3712\layout Standard
@@ -3281,7 +3714,7 @@ remote_host
3281status 3714status
3282\end_inset 3715\end_inset
3283</cell> 3716</cell>
3284<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3717<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3285\begin_inset Text 3718\begin_inset Text
3286 3719
3287\layout Standard 3720\layout Standard
@@ -3289,7 +3722,7 @@ status
3289request_uri 3722request_uri
3290\end_inset 3723\end_inset
3291</cell> 3724</cell>
3292<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3725<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3293\begin_inset Text 3726\begin_inset Text
3294 3727
3295\layout Standard 3728\layout Standard
@@ -3297,7 +3730,7 @@ request_uri
3297bytes_sent 3730bytes_sent
3298\end_inset 3731\end_inset
3299</cell> 3732</cell>
3300<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 3733<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
3301\begin_inset Text 3734\begin_inset Text
3302 3735
3303\layout Standard 3736\layout Standard
@@ -3306,8 +3739,8 @@ from_unixtime(time_stamp)
3306\end_inset 3739\end_inset
3307</cell> 3740</cell>
3308</row> 3741</row>
3309<row topline="true" bottomline="false" newpage="false"> 3742<row topline="true">
3310<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3743<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3311\begin_inset Text 3744\begin_inset Text
3312 3745
3313\layout Standard 3746\layout Standard
@@ -3315,7 +3748,7 @@ from_unixtime(time_stamp)
3315marge.mmm.co.uk 3748marge.mmm.co.uk
3316\end_inset 3749\end_inset
3317</cell> 3750</cell>
3318<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3751<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3319\begin_inset Text 3752\begin_inset Text
3320 3753
3321\layout Standard 3754\layout Standard
@@ -3323,7 +3756,7 @@ marge.mmm.co.uk
3323404 3756404
3324\end_inset 3757\end_inset
3325</cell> 3758</cell>
3326<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3759<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3327\begin_inset Text 3760\begin_inset Text
3328 3761
3329\layout Standard 3762\layout Standard
@@ -3331,7 +3764,7 @@ marge.mmm.co.uk
3331/favicon.ico 3764/favicon.ico
3332\end_inset 3765\end_inset
3333</cell> 3766</cell>
3334<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3767<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3335\begin_inset Text 3768\begin_inset Text
3336 3769
3337\layout Standard 3770\layout Standard
@@ -3339,7 +3772,7 @@ marge.mmm.co.uk
3339321 3772321
3340\end_inset 3773\end_inset
3341</cell> 3774</cell>
3342<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 3775<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
3343\begin_inset Text 3776\begin_inset Text
3344 3777
3345\layout Standard 3778\layout Standard
@@ -3348,8 +3781,8 @@ marge.mmm.co.uk
3348\end_inset 3781\end_inset
3349</cell> 3782</cell>
3350</row> 3783</row>
3351<row topline="true" bottomline="false" newpage="false"> 3784<row topline="true">
3352<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3785<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3353\begin_inset Text 3786\begin_inset Text
3354 3787
3355\layout Standard 3788\layout Standard
@@ -3357,7 +3790,7 @@ marge.mmm.co.uk
335762.180.239.251 379062.180.239.251
3358\end_inset 3791\end_inset
3359</cell> 3792</cell>
3360<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3793<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3361\begin_inset Text 3794\begin_inset Text
3362 3795
3363\layout Standard 3796\layout Standard
@@ -3365,7 +3798,7 @@ marge.mmm.co.uk
3365404 3798404
3366\end_inset 3799\end_inset
3367</cell> 3800</cell>
3368<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3801<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3369\begin_inset Text 3802\begin_inset Text
3370 3803
3371\layout Standard 3804\layout Standard
@@ -3373,7 +3806,7 @@ marge.mmm.co.uk
3373/favicon.ico 3806/favicon.ico
3374\end_inset 3807\end_inset
3375</cell> 3808</cell>
3376<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3809<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3377\begin_inset Text 3810\begin_inset Text
3378 3811
3379\layout Standard 3812\layout Standard
@@ -3381,7 +3814,7 @@ marge.mmm.co.uk
3381333 3814333
3382\end_inset 3815\end_inset
3383</cell> 3816</cell>
3384<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 3817<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
3385\begin_inset Text 3818\begin_inset Text
3386 3819
3387\layout Standard 3820\layout Standard
@@ -3390,8 +3823,8 @@ marge.mmm.co.uk
3390\end_inset 3823\end_inset
3391</cell> 3824</cell>
3392</row> 3825</row>
3393<row topline="true" bottomline="false" newpage="false"> 3826<row topline="true">
3394<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3827<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3395\begin_inset Text 3828\begin_inset Text
3396 3829
3397\layout Standard 3830\layout Standard
@@ -3399,7 +3832,7 @@ marge.mmm.co.uk
3399212.234.12.66 3832212.234.12.66
3400\end_inset 3833\end_inset
3401</cell> 3834</cell>
3402<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3835<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3403\begin_inset Text 3836\begin_inset Text
3404 3837
3405\layout Standard 3838\layout Standard
@@ -3407,7 +3840,7 @@ marge.mmm.co.uk
3407404 3840404
3408\end_inset 3841\end_inset
3409</cell> 3842</cell>
3410<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3843<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3411\begin_inset Text 3844\begin_inset Text
3412 3845
3413\layout Standard 3846\layout Standard
@@ -3415,7 +3848,7 @@ marge.mmm.co.uk
3415/favicon.ico 3848/favicon.ico
3416\end_inset 3849\end_inset
3417</cell> 3850</cell>
3418<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3851<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3419\begin_inset Text 3852\begin_inset Text
3420 3853
3421\layout Standard 3854\layout Standard
@@ -3423,7 +3856,7 @@ marge.mmm.co.uk
3423321 3856321
3424\end_inset 3857\end_inset
3425</cell> 3858</cell>
3426<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 3859<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
3427\begin_inset Text 3860\begin_inset Text
3428 3861
3429\layout Standard 3862\layout Standard
@@ -3432,8 +3865,8 @@ marge.mmm.co.uk
3432\end_inset 3865\end_inset
3433</cell> 3866</cell>
3434</row> 3867</row>
3435<row topline="true" bottomline="true" newpage="false"> 3868<row topline="true" bottomline="true">
3436<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3869<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3437\begin_inset Text 3870\begin_inset Text
3438 3871
3439\layout Standard 3872\layout Standard
@@ -3441,7 +3874,7 @@ marge.mmm.co.uk
3441212.210.78.254 3874212.210.78.254
3442\end_inset 3875\end_inset
3443</cell> 3876</cell>
3444<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3877<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3445\begin_inset Text 3878\begin_inset Text
3446 3879
3447\layout Standard 3880\layout Standard
@@ -3449,7 +3882,7 @@ marge.mmm.co.uk
3449404 3882404
3450\end_inset 3883\end_inset
3451</cell> 3884</cell>
3452<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3885<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3453\begin_inset Text 3886\begin_inset Text
3454 3887
3455\layout Standard 3888\layout Standard
@@ -3457,7 +3890,7 @@ marge.mmm.co.uk
3457/favicon.ico 3890/favicon.ico
3458\end_inset 3891\end_inset
3459</cell> 3892</cell>
3460<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3893<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3461\begin_inset Text 3894\begin_inset Text
3462 3895
3463\layout Standard 3896\layout Standard
@@ -3465,7 +3898,7 @@ marge.mmm.co.uk
3465333 3898333
3466\end_inset 3899\end_inset
3467</cell> 3900</cell>
3468<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 3901<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
3469\begin_inset Text 3902\begin_inset Text
3470 3903
3471\layout Standard 3904\layout Standard
@@ -3488,21 +3921,27 @@ Or do you want to see how many bytes you've sent within a certain directory
3488\layout LyX-Code 3921\layout LyX-Code
3489 3922
3490select request_uri,sum(bytes_sent) as bytes,count(request_uri) as howmany 3923select request_uri,sum(bytes_sent) as bytes,count(request_uri) as howmany
3491 from acc_log_tbl where request_uri like '%mod_log_sql%' group by request_uri 3924 from
3492 order by howmany desc; 3925\layout LyX-Code
3926
3927acc_log_tbl where request_uri like '%mod_log_sql%' group by request_uri
3928 order
3929\layout LyX-Code
3930
3931by howmany desc;
3493\layout LyX-Code 3932\layout LyX-Code
3494 3933
3495\layout Standard 3934\layout Standard
3496\align center 3935\align center
3497 3936
3498\begin_inset Tabular 3937\begin_inset Tabular
3499<lyxtabular version="2" rows="5" columns="3"> 3938<lyxtabular version="3" rows="5" columns="3">
3500<features rotate="false" islongtable="false" endhead="0" endfirsthead="0" endfoot="0" endlastfoot="0"> 3939<features>
3501<column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> 3940<column alignment="left" valignment="top" leftline="true" width="0pt">
3502<column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> 3941<column alignment="left" valignment="top" leftline="true" width="0pt">
3503<column alignment="left" valignment="top" leftline="true" rightline="true" width="" special=""> 3942<column alignment="left" valignment="top" leftline="true" rightline="true" width="0pt">
3504<row topline="true" bottomline="true" newpage="false"> 3943<row topline="true" bottomline="true">
3505<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3944<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3506\begin_inset Text 3945\begin_inset Text
3507 3946
3508\layout Standard 3947\layout Standard
@@ -3510,7 +3949,7 @@ select request_uri,sum(bytes_sent) as bytes,count(request_uri) as howmany
3510request_uri 3949request_uri
3511\end_inset 3950\end_inset
3512</cell> 3951</cell>
3513<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3952<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3514\begin_inset Text 3953\begin_inset Text
3515 3954
3516\layout Standard 3955\layout Standard
@@ -3518,7 +3957,7 @@ request_uri
3518bytes 3957bytes
3519\end_inset 3958\end_inset
3520</cell> 3959</cell>
3521<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 3960<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
3522\begin_inset Text 3961\begin_inset Text
3523 3962
3524\layout Standard 3963\layout Standard
@@ -3527,8 +3966,8 @@ howmany
3527\end_inset 3966\end_inset
3528</cell> 3967</cell>
3529</row> 3968</row>
3530<row topline="true" bottomline="false" newpage="false"> 3969<row topline="true">
3531<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3970<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3532\begin_inset Text 3971\begin_inset Text
3533 3972
3534\layout Standard 3973\layout Standard
@@ -3536,7 +3975,7 @@ howmany
3536/mod_log_sql/style_1.css 3975/mod_log_sql/style_1.css
3537\end_inset 3976\end_inset
3538</cell> 3977</cell>
3539<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3978<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3540\begin_inset Text 3979\begin_inset Text
3541 3980
3542\layout Standard 3981\layout Standard
@@ -3544,7 +3983,7 @@ howmany
3544157396 3983157396
3545\end_inset 3984\end_inset
3546</cell> 3985</cell>
3547<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 3986<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
3548\begin_inset Text 3987\begin_inset Text
3549 3988
3550\layout Standard 3989\layout Standard
@@ -3553,8 +3992,8 @@ howmany
3553\end_inset 3992\end_inset
3554</cell> 3993</cell>
3555</row> 3994</row>
3556<row topline="true" bottomline="false" newpage="false"> 3995<row topline="true">
3557<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 3996<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3558\begin_inset Text 3997\begin_inset Text
3559 3998
3560\layout Standard 3999\layout Standard
@@ -3562,7 +4001,7 @@ howmany
3562/mod_log_sql/ 4001/mod_log_sql/
3563\end_inset 4002\end_inset
3564</cell> 4003</cell>
3565<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 4004<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3566\begin_inset Text 4005\begin_inset Text
3567 4006
3568\layout Standard 4007\layout Standard
@@ -3570,7 +4009,7 @@ howmany
35702514337 40092514337
3571\end_inset 4010\end_inset
3572</cell> 4011</cell>
3573<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 4012<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
3574\begin_inset Text 4013\begin_inset Text
3575 4014
3576\layout Standard 4015\layout Standard
@@ -3579,8 +4018,8 @@ howmany
3579\end_inset 4018\end_inset
3580</cell> 4019</cell>
3581</row> 4020</row>
3582<row topline="true" bottomline="false" newpage="false"> 4021<row topline="true">
3583<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 4022<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3584\begin_inset Text 4023\begin_inset Text
3585 4024
3586\layout Standard 4025\layout Standard
@@ -3588,7 +4027,7 @@ howmany
3588/mod_log_sql/mod_log_sql.tar.gz 4027/mod_log_sql/mod_log_sql.tar.gz
3589\end_inset 4028\end_inset
3590</cell> 4029</cell>
3591<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 4030<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3592\begin_inset Text 4031\begin_inset Text
3593 4032
3594\layout Standard 4033\layout Standard
@@ -3596,7 +4035,7 @@ howmany
35969769312 40359769312
3597\end_inset 4036\end_inset
3598</cell> 4037</cell>
3599<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 4038<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
3600\begin_inset Text 4039\begin_inset Text
3601 4040
3602\layout Standard 4041\layout Standard
@@ -3605,8 +4044,8 @@ howmany
3605\end_inset 4044\end_inset
3606</cell> 4045</cell>
3607</row> 4046</row>
3608<row topline="true" bottomline="true" newpage="false"> 4047<row topline="true" bottomline="true">
3609<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 4048<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3610\begin_inset Text 4049\begin_inset Text
3611 4050
3612\layout Standard 4051\layout Standard
@@ -3614,7 +4053,7 @@ howmany
3614/mod_log_sql/faq.html 4053/mod_log_sql/faq.html
3615\end_inset 4054\end_inset
3616</cell> 4055</cell>
3617<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 4056<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3618\begin_inset Text 4057\begin_inset Text
3619 4058
3620\layout Standard 4059\layout Standard
@@ -3622,7 +4061,7 @@ howmany
36225038728 40615038728
3623\end_inset 4062\end_inset
3624</cell> 4063</cell>
3625<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 4064<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
3626\begin_inset Text 4065\begin_inset Text
3627 4066
3628\layout Standard 4067\layout Standard
@@ -3643,20 +4082,22 @@ howmany
3643Or maybe you want to see who's linking to you? Do this: 4082Or maybe you want to see who's linking to you? Do this:
3644\layout LyX-Code 4083\layout LyX-Code
3645 4084
3646select count(referer) as num,referer from acc_log_tbl where request_uri='/mod_lo 4085select count(referer) as num,referer from acc_log_tbl where
3647g_sql/' group by referer order by num desc;
3648\layout LyX-Code 4086\layout LyX-Code
3649 4087
4088request_uri='/mod_log_sql/' group by referer order by num desc;
3650\layout LyX-Code 4089\layout LyX-Code
4090
4091\layout Standard
3651\align center 4092\align center
3652 4093
3653\begin_inset Tabular 4094\begin_inset Tabular
3654<lyxtabular version="2" rows="5" columns="2"> 4095<lyxtabular version="3" rows="5" columns="2">
3655<features rotate="false" islongtable="false" endhead="0" endfirsthead="0" endfoot="0" endlastfoot="0"> 4096<features>
3656<column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> 4097<column alignment="left" valignment="top" leftline="true" width="0pt">
3657<column alignment="left" valignment="top" leftline="true" rightline="true" width="" special=""> 4098<column alignment="left" valignment="top" leftline="true" rightline="true" width="0pt">
3658<row topline="true" bottomline="true" newpage="false"> 4099<row topline="true" bottomline="true">
3659<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 4100<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3660\begin_inset Text 4101\begin_inset Text
3661 4102
3662\layout Standard 4103\layout Standard
@@ -3664,7 +4105,7 @@ g_sql/' group by referer order by num desc;
3664num 4105num
3665\end_inset 4106\end_inset
3666</cell> 4107</cell>
3667<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 4108<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
3668\begin_inset Text 4109\begin_inset Text
3669 4110
3670\layout Standard 4111\layout Standard
@@ -3673,8 +4114,8 @@ referer
3673\end_inset 4114\end_inset
3674</cell> 4115</cell>
3675</row> 4116</row>
3676<row topline="true" bottomline="false" newpage="false"> 4117<row topline="true">
3677<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 4118<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3678\begin_inset Text 4119\begin_inset Text
3679 4120
3680\layout Standard 4121\layout Standard
@@ -3682,7 +4123,7 @@ referer
3682271 4123271
3683\end_inset 4124\end_inset
3684</cell> 4125</cell>
3685<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 4126<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
3686\begin_inset Text 4127\begin_inset Text
3687 4128
3688\layout Standard 4129\layout Standard
@@ -3691,8 +4132,8 @@ http://freshmeat.net/projects/mod_log_sql/
3691\end_inset 4132\end_inset
3692</cell> 4133</cell>
3693</row> 4134</row>
3694<row topline="true" bottomline="false" newpage="false"> 4135<row topline="true">
3695<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 4136<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3696\begin_inset Text 4137\begin_inset Text
3697 4138
3698\layout Standard 4139\layout Standard
@@ -3700,7 +4141,7 @@ http://freshmeat.net/projects/mod_log_sql/
370096 414196
3701\end_inset 4142\end_inset
3702</cell> 4143</cell>
3703<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 4144<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
3704\begin_inset Text 4145\begin_inset Text
3705 4146
3706\layout Standard 4147\layout Standard
@@ -3709,8 +4150,8 @@ http://modules.apache.org/search?id=339
3709\end_inset 4150\end_inset
3710</cell> 4151</cell>
3711</row> 4152</row>
3712<row topline="true" bottomline="false" newpage="false"> 4153<row topline="true">
3713<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 4154<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3714\begin_inset Text 4155\begin_inset Text
3715 4156
3716\layout Standard 4157\layout Standard
@@ -3718,7 +4159,7 @@ http://modules.apache.org/search?id=339
371848 415948
3719\end_inset 4160\end_inset
3720</cell> 4161</cell>
3721<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 4162<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
3722\begin_inset Text 4163\begin_inset Text
3723 4164
3724\layout Standard 4165\layout Standard
@@ -3727,8 +4168,8 @@ http://freshmeat.net/
3727\end_inset 4168\end_inset
3728</cell> 4169</cell>
3729</row> 4170</row>
3730<row topline="true" bottomline="true" newpage="false"> 4171<row topline="true" bottomline="true">
3731<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 4172<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
3732\begin_inset Text 4173\begin_inset Text
3733 4174
3734\layout Standard 4175\layout Standard
@@ -3736,7 +4177,7 @@ http://freshmeat.net/
37368 41778
3737\end_inset 4178\end_inset
3738</cell> 4179</cell>
3739<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 4180<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
3740\begin_inset Text 4181\begin_inset Text
3741 4182
3742\layout Standard 4183\layout Standard
@@ -3929,8 +4370,10 @@ When done with your runs, clean these many thousands of requests out of
3929 your database: 4370 your database:
3930\layout LyX-Code 4371\layout LyX-Code
3931 4372
3932mysql> delete from access_log where agent like 'ApacheBench%'; mysql> optimize 4373mysql> delete from access_log where agent like 'ApacheBench%';
3933 table access_log; 4374\layout LyX-Code
4375
4376mysql> optimize table access_log;
3934\layout Subsection 4377\layout Subsection
3935 4378
3936Who's using mod_log_sql? 4379Who's using mod_log_sql?
@@ -3938,11 +4381,11 @@ Who's using mod_log_sql?
3938 4381
3939Good question! It would be great to find out! If you are a production-level 4382Good question! It would be great to find out! If you are a production-level
3940 mod_log_sql user, please contact 4383 mod_log_sql user, please contact
3941\begin_inset LatexCommand \url[the maintainer, Chris Powell]{chris@grubbybaby.com} 4384\begin_inset LatexCommand \url[the maintainer, Chris Powell]{(chris@grubbybaby.com)}
3942 4385
3943\end_inset 4386\end_inset
3944 4387
3945so that you can be mentioned here. 4388 so that you can be mentioned here.
3946\layout Subsection 4389\layout Subsection
3947 4390
3948How do I extract the data in a format that my analysis tool can understand? 4391How do I extract the data in a format that my analysis tool can understand?
@@ -3967,15 +4410,13 @@ For example, let's say that you want your web statistics updated once per
3967 4410
3968\layout LyX-Code 4411\layout LyX-Code
3969 4412
397005 04 * * * root /usr/local/sbin/make_combined_log.pl 1 www.grubbybaby.com 441305 04 * * * root make_combined_log.pl 1 www.grubbybaby.com > /var/log/temp01
3971 > /var/log/httpd/mysql-grubbybaby
3972\layout LyX-Code 4414\layout LyX-Code
3973 4415
3974# Run webalizer on httpd log 4416# Run webalizer on httpd log
3975\layout LyX-Code 4417\layout LyX-Code
3976 4418
397730 04 * * * root /usr/local/bin/webalizer -c /etc/webalizer.conf; rm -f /var/log/ 441930 04 * * * root webalizer -c /etc/webalizer.conf; rm -f /var/log/temp01
3978httpd/mysql-grubbybaby
3979\layout Standard 4420\layout Standard
3980 4421
3981Or if you have a newer system that puts files in /etc/cron.daily etc., create 4422Or if you have a newer system that puts files in /etc/cron.daily etc., create
@@ -4114,16 +4555,16 @@ Perform some hits on your server and run a select:
4114mysql> select request_uri,cookie from access_log where cookie is not null; 4555mysql> select request_uri,cookie from access_log where cookie is not null;
4115\layout LyX-Code 4556\layout LyX-Code
4116 4557
4117\layout LyX-Code 4558\layout Standard
4118\align center 4559\align center
4119 4560
4120\begin_inset Tabular 4561\begin_inset Tabular
4121<lyxtabular version="2" rows="4" columns="2"> 4562<lyxtabular version="3" rows="4" columns="2">
4122<features rotate="false" islongtable="false" endhead="0" endfirsthead="0" endfoot="0" endlastfoot="0"> 4563<features>
4123<column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> 4564<column alignment="left" valignment="top" leftline="true" width="0pt">
4124<column alignment="left" valignment="top" leftline="true" rightline="true" width="" special=""> 4565<column alignment="left" valignment="top" leftline="true" rightline="true" width="0pt">
4125<row topline="true" bottomline="true" newpage="false"> 4566<row topline="true" bottomline="true">
4126<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 4567<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
4127\begin_inset Text 4568\begin_inset Text
4128 4569
4129\layout Standard 4570\layout Standard
@@ -4131,7 +4572,7 @@ mysql> select request_uri,cookie from access_log where cookie is not null;
4131request_uri 4572request_uri
4132\end_inset 4573\end_inset
4133</cell> 4574</cell>
4134<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 4575<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
4135\begin_inset Text 4576\begin_inset Text
4136 4577
4137\layout Standard 4578\layout Standard
@@ -4140,8 +4581,8 @@ cookie
4140\end_inset 4581\end_inset
4141</cell> 4582</cell>
4142</row> 4583</row>
4143<row topline="true" bottomline="false" newpage="false"> 4584<row topline="true">
4144<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 4585<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
4145\begin_inset Text 4586\begin_inset Text
4146 4587
4147\layout Standard 4588\layout Standard
@@ -4149,7 +4590,7 @@ cookie
4149/mod_log_sql/ 4590/mod_log_sql/
4150\end_inset 4591\end_inset
4151</cell> 4592</cell>
4152<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 4593<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
4153\begin_inset Text 4594\begin_inset Text
4154 4595
4155\layout Standard 4596\layout Standard
@@ -4158,8 +4599,8 @@ ool-18e4.dyn.optonline.net.130051007102700823
4158\end_inset 4599\end_inset
4159</cell> 4600</cell>
4160</row> 4601</row>
4161<row topline="true" bottomline="false" newpage="false"> 4602<row topline="true">
4162<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 4603<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
4163\begin_inset Text 4604\begin_inset Text
4164 4605
4165\layout Standard 4606\layout Standard
@@ -4167,7 +4608,7 @@ ool-18e4.dyn.optonline.net.130051007102700823
4167/mod_log_sql/usa.gif 4608/mod_log_sql/usa.gif
4168\end_inset 4609\end_inset
4169</cell> 4610</cell>
4170<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 4611<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
4171\begin_inset Text 4612\begin_inset Text
4172 4613
4173\layout Standard 4614\layout Standard
@@ -4176,8 +4617,8 @@ ool-18e4.dyn.optonline.net.130051007102700823
4176\end_inset 4617\end_inset
4177</cell> 4618</cell>
4178</row> 4619</row>
4179<row topline="true" bottomline="true" newpage="false"> 4620<row topline="true" bottomline="true">
4180<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 4621<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
4181\begin_inset Text 4622\begin_inset Text
4182 4623
4183\layout Standard 4624\layout Standard
@@ -4185,7 +4626,7 @@ ool-18e4.dyn.optonline.net.130051007102700823
4185/mod_log_sql/style_1.css 4626/mod_log_sql/style_1.css
4186\end_inset 4627\end_inset
4187</cell> 4628</cell>
4188<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 4629<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
4189\begin_inset Text 4630\begin_inset Text
4190 4631
4191\layout Standard 4632\layout Standard
@@ -4303,22 +4744,24 @@ Perform some hits on your server and run a select:
4303\layout LyX-Code 4744\layout LyX-Code
4304 4745
4305mysql> select remote_host,request_uri,ssl_cipher,ssl_keysize,ssl_maxkeysize 4746mysql> select remote_host,request_uri,ssl_cipher,ssl_keysize,ssl_maxkeysize
4306 from access_log where ssl_cipher is not null;
4307\layout LyX-Code 4747\layout LyX-Code
4308 4748
4749from access_log where ssl_cipher is not null;
4309\layout LyX-Code 4750\layout LyX-Code
4751
4752\layout Standard
4310\align center 4753\align center
4311 4754
4312\begin_inset Tabular 4755\begin_inset Tabular
4313<lyxtabular version="2" rows="4" columns="5"> 4756<lyxtabular version="3" rows="4" columns="5">
4314<features rotate="false" islongtable="false" endhead="0" endfirsthead="0" endfoot="0" endlastfoot="0"> 4757<features>
4315<column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> 4758<column alignment="left" valignment="top" leftline="true" width="0pt">
4316<column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> 4759<column alignment="left" valignment="top" leftline="true" width="0pt">
4317<column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> 4760<column alignment="left" valignment="top" leftline="true" width="0pt">
4318<column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> 4761<column alignment="left" valignment="top" leftline="true" width="0pt">
4319<column alignment="left" valignment="top" leftline="true" rightline="true" width="" special=""> 4762<column alignment="left" valignment="top" leftline="true" rightline="true" width="0pt">
4320<row topline="true" bottomline="true" newpage="false"> 4763<row topline="true" bottomline="true">
4321<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 4764<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
4322\begin_inset Text 4765\begin_inset Text
4323 4766
4324\layout Standard 4767\layout Standard
@@ -4326,7 +4769,7 @@ mysql> select remote_host,request_uri,ssl_cipher,ssl_keysize,ssl_maxkeysize
4326remote_host 4769remote_host
4327\end_inset 4770\end_inset
4328</cell> 4771</cell>
4329<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 4772<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
4330\begin_inset Text 4773\begin_inset Text
4331 4774
4332\layout Standard 4775\layout Standard
@@ -4334,7 +4777,7 @@ remote_host
4334request_uri 4777request_uri
4335\end_inset 4778\end_inset
4336</cell> 4779</cell>
4337<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 4780<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
4338\begin_inset Text 4781\begin_inset Text
4339 4782
4340\layout Standard 4783\layout Standard
@@ -4342,7 +4785,7 @@ request_uri
4342ssl_cipher 4785ssl_cipher
4343\end_inset 4786\end_inset
4344</cell> 4787</cell>
4345<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 4788<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
4346\begin_inset Text 4789\begin_inset Text
4347 4790
4348\layout Standard 4791\layout Standard
@@ -4350,7 +4793,7 @@ ssl_cipher
4350ssl_keysize 4793ssl_keysize
4351\end_inset 4794\end_inset
4352</cell> 4795</cell>
4353<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 4796<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
4354\begin_inset Text 4797\begin_inset Text
4355 4798
4356\layout Standard 4799\layout Standard
@@ -4359,8 +4802,8 @@ ssl_maxkeysize
4359\end_inset 4802\end_inset
4360</cell> 4803</cell>
4361</row> 4804</row>
4362<row topline="true" bottomline="false" newpage="false"> 4805<row topline="true">
4363<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 4806<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
4364\begin_inset Text 4807\begin_inset Text
4365 4808
4366\layout Standard 4809\layout Standard
@@ -4368,7 +4811,7 @@ ssl_maxkeysize
4368216.190.52.4 4811216.190.52.4
4369\end_inset 4812\end_inset
4370</cell> 4813</cell>
4371<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 4814<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
4372\begin_inset Text 4815\begin_inset Text
4373 4816
4374\layout Standard 4817\layout Standard
@@ -4376,7 +4819,7 @@ ssl_maxkeysize
4376/dir/somefile.html 4819/dir/somefile.html
4377\end_inset 4820\end_inset
4378</cell> 4821</cell>
4379<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 4822<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
4380\begin_inset Text 4823\begin_inset Text
4381 4824
4382\layout Standard 4825\layout Standard
@@ -4384,7 +4827,7 @@ ssl_maxkeysize
4384RC4-MD5 4827RC4-MD5
4385\end_inset 4828\end_inset
4386</cell> 4829</cell>
4387<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 4830<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
4388\begin_inset Text 4831\begin_inset Text
4389 4832
4390\layout Standard 4833\layout Standard
@@ -4392,7 +4835,7 @@ RC4-MD5
4392128 4835128
4393\end_inset 4836\end_inset
4394</cell> 4837</cell>
4395<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 4838<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
4396\begin_inset Text 4839\begin_inset Text
4397 4840
4398\layout Standard 4841\layout Standard
@@ -4401,8 +4844,8 @@ RC4-MD5
4401\end_inset 4844\end_inset
4402</cell> 4845</cell>
4403</row> 4846</row>
4404<row topline="true" bottomline="false" newpage="false"> 4847<row topline="true">
4405<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 4848<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
4406\begin_inset Text 4849\begin_inset Text
4407 4850
4408\layout Standard 4851\layout Standard
@@ -4410,7 +4853,7 @@ RC4-MD5
4410216.190.52.4 4853216.190.52.4
4411\end_inset 4854\end_inset
4412</cell> 4855</cell>
4413<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 4856<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
4414\begin_inset Text 4857\begin_inset Text
4415 4858
4416\layout Standard 4859\layout Standard
@@ -4418,7 +4861,7 @@ RC4-MD5
4418/dir/somefile.gif 4861/dir/somefile.gif
4419\end_inset 4862\end_inset
4420</cell> 4863</cell>
4421<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 4864<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
4422\begin_inset Text 4865\begin_inset Text
4423 4866
4424\layout Standard 4867\layout Standard
@@ -4426,7 +4869,7 @@ RC4-MD5
4426RC4-MD5 4869RC4-MD5
4427\end_inset 4870\end_inset
4428</cell> 4871</cell>
4429<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 4872<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
4430\begin_inset Text 4873\begin_inset Text
4431 4874
4432\layout Standard 4875\layout Standard
@@ -4434,7 +4877,7 @@ RC4-MD5
4434128 4877128
4435\end_inset 4878\end_inset
4436</cell> 4879</cell>
4437<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 4880<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
4438\begin_inset Text 4881\begin_inset Text
4439 4882
4440\layout Standard 4883\layout Standard
@@ -4443,8 +4886,8 @@ RC4-MD5
4443\end_inset 4886\end_inset
4444</cell> 4887</cell>
4445</row> 4888</row>
4446<row topline="true" bottomline="true" newpage="false"> 4889<row topline="true" bottomline="true">
4447<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 4890<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
4448\begin_inset Text 4891\begin_inset Text
4449 4892
4450\layout Standard 4893\layout Standard
@@ -4452,7 +4895,7 @@ RC4-MD5
4452216.190.52.4 4895216.190.52.4
4453\end_inset 4896\end_inset
4454</cell> 4897</cell>
4455<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 4898<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
4456\begin_inset Text 4899\begin_inset Text
4457 4900
4458\layout Standard 4901\layout Standard
@@ -4460,7 +4903,7 @@ RC4-MD5
4460/dir/somefile.jpg 4903/dir/somefile.jpg
4461\end_inset 4904\end_inset
4462</cell> 4905</cell>
4463<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 4906<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
4464\begin_inset Text 4907\begin_inset Text
4465 4908
4466\layout Standard 4909\layout Standard
@@ -4468,7 +4911,7 @@ RC4-MD5
4468RC4-MD5 4911RC4-MD5
4469\end_inset 4912\end_inset
4470</cell> 4913</cell>
4471<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> 4914<cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none">
4472\begin_inset Text 4915\begin_inset Text
4473 4916
4474\layout Standard 4917\layout Standard
@@ -4476,7 +4919,7 @@ RC4-MD5
4476128 4919128
4477\end_inset 4920\end_inset
4478</cell> 4921</cell>
4479<cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> 4922<cell alignment="center" valignment="top" topline="true" leftline="true" rightline="true" usebox="none">
4480\begin_inset Text 4923\begin_inset Text
4481 4924
4482\layout Standard 4925\layout Standard
@@ -4515,8 +4958,8 @@ You do have control over where mod_log_sql looks for the socket.
4515 (Applies to mod_log_sql 1.16 or later only.) 4958 (Applies to mod_log_sql 1.16 or later only.)
4516\layout Subsection 4959\layout Subsection
4517 4960
4518Why do I occasionally see a "connection lost, attempting reconnect" message 4961Why do I occasionally see a "lost connection to MySQL server" message in
4519 in my error-log? 4962 my error-log?
4520\layout Standard 4963\layout Standard
4521 4964
4522This message may appear every now and then in your Apache error log, especially 4965This message may appear every now and then in your Apache error log, especially
@@ -4530,15 +4973,23 @@ This message may appear every now and then in your Apache error log, especially
4530 That event is what is being logged, and looks like this: 4973 That event is what is being logged, and looks like this:
4531\layout LyX-Code 4974\layout LyX-Code
4532 4975
4533[Thu Dec 13 05:42:18 2001] [error] mod_log_sql: connection lost, attempting 4976[Tue Nov 12 19:04:10 2002] [error] mod_log_sql: first attempt failed,
4534 reconnect 4977\layout LyX-Code
4978
4979 API said: error 2013, Lost connection to MySQL server during query
4980\layout LyX-Code
4981
4982[Tue Nov 12 19:04:10 2002] [error] mod_log_sql: reconnect successful
4983\layout LyX-Code
4984
4985[Tue Nov 12 19:04:10 2002] [error] mod_log_sql: second attempt successful
4986
4535\layout LyX-Code 4987\layout LyX-Code
4536 4988
4537[Thu Dec 13 05:42:18 2001] [error] mod_log_sql: reconnect successful
4538\layout Standard 4989\layout Standard
4539 4990
4540Reference: 4991Reference:
4541\begin_inset LatexCommand \url[MySQL documentation]{http://www.mysql.com/documentation/mysql/bychapter/manual_Problems.html#Gone_away} 4992\begin_inset LatexCommand \url[MySQL documentation]{(http://www.mysql.com/documentation/mysql/bychapter/manual_Problems.html#Gone_away)}
4542 4993
4543\end_inset 4994\end_inset
4544 4995
@@ -4573,7 +5024,7 @@ I have discovered a bug.
4573\layout Standard 5024\layout Standard
4574 5025
4575Please contact 5026Please contact
4576\begin_inset LatexCommand \url[the maintainer]{chris@grubbybaby.com} 5027\begin_inset LatexCommand \url[the maintainer]{(chris@grubbybaby.com)}
4577 5028
4578\end_inset 5029\end_inset
4579 5030
diff --git a/Makefile b/Makefile
index 845b225..0c7a7a3 100644
--- a/Makefile
+++ b/Makefile
@@ -1,4 +1,4 @@
1# $Id: Makefile,v 1.13 2002/11/14 22:52:54 helios Exp $ 1# $Id: Makefile,v 1.14 2002/11/15 03:55:25 helios Exp $
2 2
3##################################### 3#####################################
4# Important: 4# Important:
@@ -8,7 +8,7 @@
8APACHEINST = /usr/local/Apache 8APACHEINST = /usr/local/Apache
9MYSQLLIBS = /usr/lib 9MYSQLLIBS = /usr/lib
10MYSQLHDRS = /usr/include/mysql 10MYSQLHDRS = /usr/include/mysql
11#MODSSLHDRS = /usr/local/src/apache_1.3.27-dso/src/modules/ssl 11MODSSLHDRS = /usr/local/src/apache_1.3.27-dso/src/modules/ssl
12 12
13APACHESOURCE = /usr/local/src/apache_1.3.27-dso 13APACHESOURCE = /usr/local/src/apache_1.3.27-dso
14OPNSSLHDRS = /usr/include/openssl 14OPNSSLHDRS = /usr/include/openssl
@@ -26,9 +26,10 @@ CC = gcc
26INSTALL = /usr/bin/install -m 664 26INSTALL = /usr/bin/install -m 664
27RM = /bin/rm 27RM = /bin/rm
28LYX = /usr/bin/lyx 28LYX = /usr/bin/lyx
29LATEX = /usr/bin/latex
29DVIPS = /usr/bin/dvips 30DVIPS = /usr/bin/dvips
30LINKS = /usr/bin/links 31LINKS = /usr/bin/links
31LATEX2HTML=/usr/bin/latex2html 32L2H = /usr/local/bin/latex2html
32 33
33ifdef MODSSLHDRS 34ifdef MODSSLHDRS
34 SSLDEF = -DWANT_SSL_LOGGING 35 SSLDEF = -DWANT_SSL_LOGGING
@@ -70,7 +71,7 @@ clean:
70 $(RM) -f Documentation/*.ps 71 $(RM) -f Documentation/*.ps
71 $(RM) -f Documentation/*.txt 72 $(RM) -f Documentation/*.txt
72 73
73distro: all 74distro: documentation
74 cp -f CHANGELOG $(APACHEINST)/html/mod_log_sql/ 75 cp -f CHANGELOG $(APACHEINST)/html/mod_log_sql/
75 cd ..; tar zcf mod_log_sql-$(MLMVERS).tar.gz --exclude mod_log_sql/CVS --exclude mod_log_sql/Documentation/CVS mod_log_sql/; $(INSTALL) mod_log_sql-$(MLMVERS).tar.gz $(APACHEINST)/html/mod_log_sql/; rm -f mod_log_sql-$(MLMVERS).tar.gz 76 cd ..; tar zcf mod_log_sql-$(MLMVERS).tar.gz --exclude mod_log_sql/CVS --exclude mod_log_sql/Documentation/CVS mod_log_sql/; $(INSTALL) mod_log_sql-$(MLMVERS).tar.gz $(APACHEINST)/html/mod_log_sql/; rm -f mod_log_sql-$(MLMVERS).tar.gz
76 $(RM) $(APACHEINST)/html/mod_log_sql/mod_log_sql.tar.gz 77 $(RM) $(APACHEINST)/html/mod_log_sql/mod_log_sql.tar.gz
@@ -79,19 +80,19 @@ distro: all
79documentation: Documentation/documentation.lyx 80documentation: Documentation/documentation.lyx
80 @echo "Creating LaTeX docs..." 81 @echo "Creating LaTeX docs..."
81 @$(LYX) --export latex Documentation/documentation.lyx 2>/dev/null 82 @$(LYX) --export latex Documentation/documentation.lyx 2>/dev/null
82 @echo "Creating DVI docs..." 83 @echo "Creating cross-references...run 1"
83 @$(LYX) --export dvi Documentation/documentation.lyx 2>/dev/null 84 @cd Documentation ; $(LATEX) documentation.tex >/dev/null 2>&1
85 @echo "Creating cross-references...run 2"
86 @cd Documentation ; $(LATEX) documentation.tex >/dev/null 2>&1
87 @echo "Creating cross-references...run 3"
88 @cd Documentation ; $(LATEX) documentation.tex >/dev/null 2>&1
84 @echo "Creating PostScript docs..." 89 @echo "Creating PostScript docs..."
85 @$(DVIPS) Documentation/documentation.dvi -o Documentation/documentation.ps 2>/dev/null 90 @$(DVIPS) Documentation/documentation.dvi -o Documentation/documentation.ps 2>/dev/null
86 @echo "Creating HTML docs..." 91 @echo "Creating HTML docs..."
87 @$(LATEX2HTML) -show_section_numbers -split 4 -navigation -noindex_in_navigation -contents_in_navigation -dir Documentation/HTML Documentation/documentation.tex >/dev/null 2>&1 92 @$(L2H) -show_section_numbers -split 4 -navigation -noindex_in_navigation -contents_in_navigation -dir Documentation/HTML Documentation/documentation.tex >/dev/null 2>&1
88 @echo "Creating plain text docs..." 93 @echo "Creating plain text docs..."
89 @$(LATEX2HTML) -show_section_numbers -split 0 -dir Documentation/ Documentation/documentation.tex >/dev/null 2>&1 94 @$(L2H) -show_section_numbers -split 0 -dir Documentation/ Documentation/documentation.tex >/dev/null 2>&1
90 @$(LINKS) -dump Documentation/documentation.html > Documentation/documentation.txt 2>/dev/null 95 @$(LINKS) -dump Documentation/documentation.html > Documentation/documentation.txt 2>/dev/null
91 @echo "Cleaning up..." 96 @echo "Cleaning up..."
92 @$(RM) -f Documentation/*.html Documentation/WARNINGS Documentation/*.pl Documentation/*.aux Documentation/*.css Documentation/*.toc Documentation/*.log 97 @$(RM) -f Documentation/*.html Documentation/WARNINGS Documentation/*.pl Documentation/*.aux Documentation/*.css Documentation/*.toc Documentation/*.log
93 @$(RM) -f Documentation/HTML/WARNINGS Documentation/HTML/*.pl 98 @$(RM) -f Documentation/HTML/WARNINGS Documentation/HTML/*.pl
94
95
96
97 \ No newline at end of file
generated by cgit (git 2.34.1) at 2024-11-09 21:56:14 +0000