diff options
Diffstat (limited to 'Documentation')
-rw-r--r-- | Documentation/documentation.lyx | 129 |
1 files changed, 114 insertions, 15 deletions
diff --git a/Documentation/documentation.lyx b/Documentation/documentation.lyx index d15053b..efca178 100644 --- a/Documentation/documentation.lyx +++ b/Documentation/documentation.lyx | |||
@@ -528,11 +528,20 @@ in your httpd.conf file. | |||
528 | /usr/local/apache/bin/apachectl startssl: httpd could not be started | 528 | /usr/local/apache/bin/apachectl startssl: httpd could not be started |
529 | \layout Standard | 529 | \layout Standard |
530 | 530 | ||
531 | (This is because mod_log_sql doesn't yet have the required symbols that | 531 | (If the statements are out of order, mod_log_sql doesn't recognize the SSL |
532 | mod_ssl provides.) | 532 | symbols that mod_ssl provides.) |
533 | \layout Standard | 533 | \layout Standard |
534 | 534 | ||
535 | Now skip below to the "Configuration" section. | 535 | Now skip below to section |
536 | \begin_inset LatexCommand \ref{sec:Configuration} | ||
537 | |||
538 | \end_inset | ||
539 | |||
540 | , | ||
541 | \series bold | ||
542 | Configuration | ||
543 | \series default | ||
544 | . | ||
536 | \end_deeper | 545 | \end_deeper |
537 | \layout Subsection | 546 | \layout Subsection |
538 | 547 | ||
@@ -740,6 +749,11 @@ Install your httpd binary. | |||
740 | \end_deeper | 749 | \end_deeper |
741 | \layout Section | 750 | \layout Section |
742 | 751 | ||
752 | |||
753 | \begin_inset LatexCommand \label{sec:Configuration} | ||
754 | |||
755 | \end_inset | ||
756 | |||
743 | Configuration | 757 | Configuration |
744 | \layout Subsection | 758 | \layout Subsection |
745 | 759 | ||
@@ -774,11 +788,6 @@ mod_log_sql can make its own tables on-the-fly, or you can pre-make the | |||
774 | In this basic setup we'll just let the module create tables for us. | 788 | In this basic setup we'll just let the module create tables for us. |
775 | \layout Enumerate | 789 | \layout Enumerate |
776 | 790 | ||
777 | |||
778 | \begin_inset LatexCommand \label{part:CrTbl} | ||
779 | |||
780 | \end_inset | ||
781 | |||
782 | We still need to have a logging database created and ready, so run the MySQL | 791 | We still need to have a logging database created and ready, so run the MySQL |
783 | command line client and create a database: | 792 | command line client and create a database: |
784 | \begin_deeper | 793 | \begin_deeper |
@@ -794,6 +803,11 @@ mysql> create database apachelogs; | |||
794 | \end_deeper | 803 | \end_deeper |
795 | \layout Enumerate | 804 | \layout Enumerate |
796 | 805 | ||
806 | |||
807 | \begin_inset LatexCommand \label{part:CrTbl} | ||
808 | |||
809 | \end_inset | ||
810 | |||
797 | If you want to hand-create the tables, run the enclosed 'create-tables' | 811 | If you want to hand-create the tables, run the enclosed 'create-tables' |
798 | SQL script as follows: | 812 | SQL script as follows: |
799 | \begin_deeper | 813 | \begin_deeper |
@@ -969,6 +983,9 @@ Restart apache. | |||
969 | \begin_deeper | 983 | \begin_deeper |
970 | \layout LyX-Code | 984 | \layout LyX-Code |
971 | 985 | ||
986 | # /etc/rc.d/init.d/httpd stop | ||
987 | \layout LyX-Code | ||
988 | |||
972 | # /etc/rc.d/init.d/httpd start | 989 | # /etc/rc.d/init.d/httpd start |
973 | \end_deeper | 990 | \end_deeper |
974 | \layout Subsection | 991 | \layout Subsection |
@@ -1029,7 +1046,7 @@ So, first examine the MySQL log that you established in step | |||
1029 | 1046 | ||
1030 | . | 1047 | . |
1031 | Ensure that the INSERT statements are not being rejected because of a malformed | 1048 | Ensure that the INSERT statements are not being rejected because of a malformed |
1032 | table entry or other clerical error. | 1049 | table name or other typographical error. |
1033 | By enabling that log, you instructed MySQL to log every connection and | 1050 | By enabling that log, you instructed MySQL to log every connection and |
1034 | command it receives -- if you see no INSERT attempts in the log, the module | 1051 | command it receives -- if you see no INSERT attempts in the log, the module |
1035 | isn't successfully connecting to the database. | 1052 | isn't successfully connecting to the database. |
@@ -2800,7 +2817,7 @@ Each character in the format-string defines an attribute of the request | |||
2800 | \size footnotesize | 2817 | \size footnotesize |
2801 | 2818 | ||
2802 | \begin_inset Tabular | 2819 | \begin_inset Tabular |
2803 | <lyxtabular version="3" rows="20" columns="5"> | 2820 | <lyxtabular version="3" rows="21" columns="5"> |
2804 | <features> | 2821 | <features> |
2805 | <column alignment="center" valignment="top" leftline="true" rightline="true" width="0pt"> | 2822 | <column alignment="center" valignment="top" leftline="true" rightline="true" width="0pt"> |
2806 | <column alignment="left" valignment="top" width="0pt"> | 2823 | <column alignment="left" valignment="top" width="0pt"> |
@@ -2982,7 +2999,11 @@ c | |||
2982 | 2999 | ||
2983 | 3000 | ||
2984 | \size footnotesize | 3001 | \size footnotesize |
2985 | Text of cookie | 3002 | Text of cookie |
3003 | \begin_inset Formula $^{\textrm{1}}$ | ||
3004 | \end_inset | ||
3005 | |||
3006 | |||
2986 | \end_inset | 3007 | \end_inset |
2987 | </cell> | 3008 | </cell> |
2988 | <cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none"> | 3009 | <cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none"> |
@@ -3232,6 +3253,62 @@ bobby | |||
3232 | 3253 | ||
3233 | 3254 | ||
3234 | \size footnotesize | 3255 | \size footnotesize |
3256 | M | ||
3257 | \end_inset | ||
3258 | </cell> | ||
3259 | <cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none"> | ||
3260 | \begin_inset Text | ||
3261 | |||
3262 | \layout Standard | ||
3263 | |||
3264 | |||
3265 | \size footnotesize | ||
3266 | Machine ID | ||
3267 | \begin_inset Formula $^{\textrm{2}}$ | ||
3268 | \end_inset | ||
3269 | |||
3270 | |||
3271 | \end_inset | ||
3272 | </cell> | ||
3273 | <cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none"> | ||
3274 | \begin_inset Text | ||
3275 | |||
3276 | \layout Standard | ||
3277 | |||
3278 | |||
3279 | \size footnotesize | ||
3280 | machine_id | ||
3281 | \end_inset | ||
3282 | </cell> | ||
3283 | <cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none"> | ||
3284 | \begin_inset Text | ||
3285 | |||
3286 | \layout Standard | ||
3287 | |||
3288 | |||
3289 | \size footnotesize | ||
3290 | varchar(25) | ||
3291 | \end_inset | ||
3292 | </cell> | ||
3293 | <cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none"> | ||
3294 | \begin_inset Text | ||
3295 | |||
3296 | \layout Standard | ||
3297 | |||
3298 | |||
3299 | \size footnotesize | ||
3300 | web01 | ||
3301 | \end_inset | ||
3302 | </cell> | ||
3303 | </row> | ||
3304 | <row topline="true"> | ||
3305 | <cell alignment="center" valignment="top" topline="true" leftline="true" usebox="none"> | ||
3306 | \begin_inset Text | ||
3307 | |||
3308 | \layout Standard | ||
3309 | |||
3310 | |||
3311 | \size footnotesize | ||
3235 | m | 3312 | m |
3236 | \end_inset | 3313 | \end_inset |
3237 | </cell> | 3314 | </cell> |
@@ -3855,7 +3932,30 @@ www.foobar.com | |||
3855 | 3932 | ||
3856 | \layout Quote | 3933 | \layout Quote |
3857 | 3934 | ||
3858 | If you have compiled mod_log_sql with WANT_SSL_LOGGING, you also get these: | 3935 | |
3936 | \begin_inset Formula $^{\textrm{1}}$ | ||
3937 | \end_inset | ||
3938 | |||
3939 | You must also specify | ||
3940 | \noun on | ||
3941 | LogSQLWhichCookie | ||
3942 | \noun default | ||
3943 | for this to take effect. | ||
3944 | \layout Quote | ||
3945 | |||
3946 | |||
3947 | \begin_inset Formula $^{\textrm{2}}$ | ||
3948 | \end_inset | ||
3949 | |||
3950 | You must also specify | ||
3951 | \noun on | ||
3952 | LogSQLMachineID | ||
3953 | \noun default | ||
3954 | for this to take effect. | ||
3955 | \layout Quote | ||
3956 | |||
3957 | If you have compiled mod_log_sql with SSL logging capability, you also can | ||
3958 | use these: | ||
3859 | \layout Quote | 3959 | \layout Quote |
3860 | 3960 | ||
3861 | 3961 | ||
@@ -4078,9 +4178,8 @@ LogSQLTransferLogFormat | |||
4078 | LogSQLWhichCookie | 4178 | LogSQLWhichCookie |
4079 | \noun default | 4179 | \noun default |
4080 | tells mod_log_sql which cookie to log. | 4180 | tells mod_log_sql which cookie to log. |
4081 | This is necessary because many times you will be setting and receiving | 4181 | This is necessary because you will usually be setting and receiving more |
4082 | more than one cookie from a client; without this directive you'd be unable | 4182 | than one cookie from a client; this cookie designates which one to log. |
4083 | to choose which cookie is your mod_usertrack cookie. | ||
4084 | \layout Quote | 4183 | \layout Quote |
4085 | 4184 | ||
4086 | Note: although this was intended for people who are using mod_usertrack | 4185 | Note: although this was intended for people who are using mod_usertrack |