summaryrefslogtreecommitdiffstats
path: root/INSTALL
diff options
context:
space:
mode:
authorGravatar Edward Rudd 2004-03-05 01:05:34 +0000
committerGravatar Edward Rudd 2004-03-05 01:05:34 +0000
commit9ac4be0b0c329de114fecf299284e79ea7bab8c9 (patch)
tree8798be20a2499c6a1bcafd4ad1f080e914f810f5 /INSTALL
parentf5f01100df8e5aa47642c5876abf52e4d81b425e (diff)
updated release date1.96
Diffstat (limited to 'INSTALL')
0 files changed, 0 insertions, 0 deletions
generated by cgit (git 2.34.1) at 2026-05-01 15:13:44 +0000
ation.lyx?h=1.96&id=5fdba37f40131f2803c056c071a2a6eafddbcbcb'>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