diff options
Diffstat (limited to 'Documentation')
-rw-r--r-- | Documentation/README | 6 | ||||
-rw-r--r-- | Documentation/documentation.lyx | 2272 | ||||
-rw-r--r-- | Documentation/documentation.tex | 1534 |
3 files changed, 1950 insertions, 1862 deletions
diff --git a/Documentation/README b/Documentation/README new file mode 100644 index 0000000..df96ba1 --- /dev/null +++ b/Documentation/README | |||
@@ -0,0 +1,6 @@ | |||
1 | $Id: README,v 1.1 2002/11/14 22:52:56 helios Exp $ | ||
2 | |||
3 | The "original" document is the LyX file "documentation.lyx" -- all other | ||
4 | files here are derived from it. The most visually accurate document | ||
5 | and the one I'd recommend reading is the PostScript (.ps) file, although | ||
6 | a whole host of formats are made available here to suit your preference. | ||
diff --git a/Documentation/documentation.lyx b/Documentation/documentation.lyx index 48c3968..ecee913 100644 --- a/Documentation/documentation.lyx +++ b/Documentation/documentation.lyx | |||
@@ -5,6 +5,7 @@ | |||
5 | \inputencoding default | 5 | \inputencoding default |
6 | \fontscheme default | 6 | \fontscheme default |
7 | \graphics default | 7 | \graphics default |
8 | \float_placement !hptb | ||
8 | \paperfontsize 10 | 9 | \paperfontsize 10 |
9 | \spacing single | 10 | \spacing single |
10 | \papersize letterpaper | 11 | \papersize letterpaper |
@@ -12,8 +13,6 @@ | |||
12 | \use_geometry 1 | 13 | \use_geometry 1 |
13 | \use_amsmath 0 | 14 | \use_amsmath 0 |
14 | \paperorientation portrait | 15 | \paperorientation portrait |
15 | \paperwidth 8.5in | ||
16 | \paperheight 11in | ||
17 | \leftmargin 1in | 16 | \leftmargin 1in |
18 | \topmargin 0.5in | 17 | \topmargin 0.5in |
19 | \rightmargin 1in | 18 | \rightmargin 1in |
@@ -22,7 +21,7 @@ | |||
22 | \tocdepth 3 | 21 | \tocdepth 3 |
23 | \paragraph_separation indent | 22 | \paragraph_separation indent |
24 | \defskip medskip | 23 | \defskip medskip |
25 | \quotes_language swedish | 24 | \quotes_language english |
26 | \quotes_times 2 | 25 | \quotes_times 2 |
27 | \papercolumns 1 | 26 | \papercolumns 1 |
28 | \papersides 1 | 27 | \papersides 1 |
@@ -33,10 +32,7 @@ | |||
33 | Installing and Running mod_log_sql | 32 | Installing and Running mod_log_sql |
34 | \layout Author | 33 | \layout Author |
35 | 34 | ||
36 | Christopher Powell | 35 | Christopher Powell, <chris@grubbybaby.com> |
37 | \layout Date | ||
38 | |||
39 | 11/13/02 | ||
40 | \layout Standard | 36 | \layout Standard |
41 | \pagebreak_bottom | 37 | \pagebreak_bottom |
42 | 38 | ||
@@ -431,8 +427,6 @@ Unpack the archive into a working directory. | |||
431 | \end_inset | 427 | \end_inset |
432 | 428 | ||
433 | Edit Makefile for your system. | 429 | Edit Makefile for your system. |
434 | \newline | ||
435 | |||
436 | \begin_deeper | 430 | \begin_deeper |
437 | \layout Standard | 431 | \layout Standard |
438 | 432 | ||
@@ -588,7 +582,7 @@ Install your httpd binary. | |||
588 | Configuration | 582 | Configuration |
589 | \layout Subsection | 583 | \layout Subsection |
590 | 584 | ||
591 | Preparing MySQL | 585 | Preparing MySQL for logging |
592 | \layout Standard | 586 | \layout Standard |
593 | 587 | ||
594 | You have to prepare the database to receive data from mod_log_sql, and set | 588 | You have to prepare the database to receive data from mod_log_sql, and set |
@@ -673,7 +667,7 @@ Then restart MySQL. | |||
673 | \end_deeper | 667 | \end_deeper |
674 | \layout Subsection | 668 | \layout Subsection |
675 | 669 | ||
676 | Preparing Apache | 670 | A very basic logging setup in Apache |
677 | \layout Enumerate | 671 | \layout Enumerate |
678 | 672 | ||
679 | Tell the module what database to use and the appropriate authentication | 673 | Tell the module what database to use and the appropriate authentication |
@@ -689,8 +683,12 @@ EXAMPLE: Use the MySQL database called "apachelogs" running on "dbmachine.foo.co | |||
689 | 683 | ||
690 | So, edit httpd.conf and insert the following lines somewhere AFTER any LoadModule | 684 | So, edit httpd.conf and insert the following lines somewhere AFTER any LoadModule |
691 | / AddModule statements. | 685 | / AddModule statements. |
692 | Make sure these statements are "global," i.e. | 686 | |
693 | not inside any VirtualHost stanza. | 687 | \emph on |
688 | Make sure these statements are "global," i.e. | ||
689 | not inside any VirtualHost stanza | ||
690 | \emph default | ||
691 | . | ||
694 | \layout LyX-Code | 692 | \layout LyX-Code |
695 | 693 | ||
696 | LogSQLDatabase apachelogs | 694 | LogSQLDatabase apachelogs |
@@ -700,15 +698,20 @@ LogSQLLoginInfo dbmachine.foo.com loguser l0gger | |||
700 | \layout LyX-Code | 698 | \layout LyX-Code |
701 | 699 | ||
702 | LogSQLCreateTables on | 700 | LogSQLCreateTables on |
703 | \end_deeper | 701 | \layout Standard |
704 | \layout Enumerate | ||
705 | 702 | ||
706 | If your database resides on localhost instead of another host, specify the | 703 | If your database resides on localhost instead of another host, specify the |
707 | MySQL server's socket file as follows: | 704 | MySQL server's socket file as follows: |
708 | \begin_deeper | ||
709 | \layout LyX-Code | 705 | \layout LyX-Code |
710 | 706 | ||
711 | LogSQLSocketFile /your/path/to/mysql.sock | 707 | LogSQLSocketFile /your/path/to/mysql.sock |
708 | \layout Standard | ||
709 | |||
710 | If your database is listening on a port other than 3306, specify the correct | ||
711 | TCP port as follows: | ||
712 | \layout LyX-Code | ||
713 | |||
714 | LogSQLTCPPort 1234 | ||
712 | \end_deeper | 715 | \end_deeper |
713 | \layout Enumerate | 716 | \layout Enumerate |
714 | 717 | ||
@@ -724,20 +727,21 @@ access_log | |||
724 | 727 | ||
725 | by inserting a LogSQLTransferLogTable directive. | 728 | by inserting a LogSQLTransferLogTable directive. |
726 | (The LogSQLTransferLogTable directive is the minimum required to log -- | 729 | (The LogSQLTransferLogTable directive is the minimum required to log -- |
727 | other directives simply tune the module's behavior.) | 730 | other directives that you'll learn about later simply tune the module's |
731 | behavior.) | ||
728 | \begin_deeper | 732 | \begin_deeper |
729 | \layout LyX-Code | 733 | \layout LyX-Code |
730 | 734 | ||
731 | <VirtualHost 1.2.3.4> | 735 | <VirtualHost 1.2.3.4> |
732 | \layout LyX-Code | 736 | \layout LyX-Code |
733 | 737 | ||
734 | [snip] | 738 | [snip] |
735 | \layout LyX-Code | 739 | \layout LyX-Code |
736 | 740 | ||
737 | LogSQLTransferLogTable access_log | 741 | LogSQLTransferLogTable access_log |
738 | \layout LyX-Code | 742 | \layout LyX-Code |
739 | 743 | ||
740 | [snip] | 744 | [snip] |
741 | \layout LyX-Code | 745 | \layout LyX-Code |
742 | 746 | ||
743 | </VirtualHost> | 747 | </VirtualHost> |
@@ -752,7 +756,7 @@ Restart apache. | |||
752 | \end_deeper | 756 | \end_deeper |
753 | \layout Subsection | 757 | \layout Subsection |
754 | 758 | ||
755 | Testing the module | 759 | Testing the basic setup |
756 | \layout Enumerate | 760 | \layout Enumerate |
757 | 761 | ||
758 | Load your web site in a browser to trigger some hits, then confirm that | 762 | Load your web site in a browser to trigger some hits, then confirm that |
@@ -779,7 +783,7 @@ You now have basic functionality. | |||
779 | 783 | ||
780 | If you do not see any entries in the access_log, then something is preventing | 784 | If you do not see any entries in the access_log, then something is preventing |
781 | the inserts from happening. | 785 | the inserts from happening. |
782 | This problem could be caused by several things: | 786 | This problem could be caused by several things: |
783 | \begin_deeper | 787 | \begin_deeper |
784 | \layout Itemize | 788 | \layout Itemize |
785 | 789 | ||
@@ -815,34 +819,750 @@ You can now activate the advanced features of mod_log_sql. | |||
815 | These are all described in the next section. | 819 | These are all described in the next section. |
816 | \layout Subsection | 820 | \layout Subsection |
817 | 821 | ||
818 | Configuration directive reference | 822 | How to tune logging with run-time directives |
819 | \layout Subsubsection | 823 | \layout Subsubsection |
820 | 824 | ||
821 | LogSQLLoginInfo | 825 | Instructing the module what to log |
826 | \layout Standard | ||
827 | |||
828 | The LogSQLTransferLogFormat directive tells the module which information | ||
829 | to send to the database. | ||
830 | This directive resembles -- but is not identical to -- the Apache LogFormat | ||
831 | directive. | ||
832 | For each virtual host that you want to enable SQL logging, insert a LogSQLTrans | ||
833 | ferLogFormat directive into the VirtualHost stanza. | ||
834 | \layout Standard | ||
835 | |||
836 | After LogSQLTransferLogFormat you supply a string of characters that tell | ||
837 | the module what to log. | ||
838 | In the configuration directive reference (section | ||
839 | \begin_inset LatexCommand \ref{sec:ConfRef} | ||
840 | |||
841 | \end_inset | ||
842 | |||
843 | ) there is a table which clearly defines all the possible things to log. | ||
844 | Let's say you only wanted to log only the request time, the remote host, | ||
845 | and the request; you'd use: | ||
822 | \layout LyX-Code | 846 | \layout LyX-Code |
823 | 847 | ||
848 | LogSQLTransferLogFormat HUS | ||
849 | \layout Standard | ||
824 | 850 | ||
825 | \series bold | 851 | A more appropriate string to use is |
826 | MANDATORY | 852 | \layout LyX-Code |
827 | \series default | 853 | |
854 | LogSQLTransferLogFormat AbHhmRSsTUuv | ||
855 | \layout Standard | ||
856 | |||
857 | which logs all the information required to be compatible with the Combined | ||
858 | Log Format (CLF). | ||
859 | \layout Standard | ||
860 | |||
861 | If you don't choose to log everything that is available, that's fine. | ||
862 | The table in your database will have unused columns that will simply contain | ||
863 | NULL and do not cause issues. | ||
864 | \layout Standard | ||
865 | |||
866 | Some directives need a little extra configuration: | ||
867 | \layout Itemize | ||
868 | |||
869 | If you specify 'c' to indicate that you want to log the cookie value, you | ||
870 | need to also tell the module which cookie you want with LogSQLWhichCookie | ||
871 | -- after all, there could be many cookies associated with a given request. | ||
872 | Fail to specify LogSQLWhichCookie, and no cookie information at all will | ||
873 | be logged. | ||
828 | 874 | ||
875 | \layout Itemize | ||
876 | |||
877 | If you specify 'M' to indicate that you want to log the machine ID, you | ||
878 | need to also instruct the module this machine's identifier using the LogSQLMach | ||
879 | ineID directive. | ||
880 | Fail to specify LogSQLMachineID, and a simple '-' character will be logged | ||
881 | in the machine_id column. | ||
882 | \layout Subsubsection | ||
883 | |||
884 | Instructing the module what NOT to log | ||
885 | \layout Standard | ||
886 | |||
887 | Two | ||
888 | \begin_inset Quotes eld | ||
889 | \end_inset | ||
890 | |||
891 | ignore | ||
892 | \begin_inset Quotes srd | ||
893 | \end_inset | ||
894 | |||
895 | directives allow you to specify things that the module should not log. | ||
896 | This can be very handy for a variety of reasons, such as keeping your database | ||
897 | as uncluttered as possible, keeping your statistics free of unneeded numbers, | ||
898 | etc. | ||
899 | \layout Standard | ||
900 | |||
901 | You are able to tell the module to ignore based on LogSQLRemhostIgnore and | ||
902 | LogSQLRequestIgnore. | ||
903 | A good way to use LogSQLRemhostIgnore is to prevent the module from logging | ||
904 | the traffic that your internal hosts generate. | ||
905 | LogSQLRequestIgnore is great for preventing things like requests for favicon.ico | ||
906 | from cluttering up your database, as well as the various requests that | ||
907 | worms make, etc. | ||
908 | \layout Standard | ||
909 | |||
910 | You can specify a series of strings after each directive. | ||
911 | Do not use any type of globbing or regular-expression syntax -- each string | ||
912 | is considered a match if it is a substring of the larger request or remote-host. | ||
913 | In other words, if you want to match | ||
914 | \begin_inset Quotes eld | ||
915 | \end_inset | ||
916 | |||
917 | host1.corp.foo.com | ||
918 | \begin_inset Quotes srd | ||
919 | \end_inset | ||
920 | |||
921 | and | ||
922 | \begin_inset Quotes eld | ||
923 | \end_inset | ||
924 | |||
925 | host2.dmz.foo.com | ||
926 | \begin_inset Quotes srd | ||
927 | \end_inset | ||
928 | |||
929 | , simply specify: | ||
829 | \layout LyX-Code | 930 | \layout LyX-Code |
830 | 931 | ||
831 | Syntax: LogSQLLoginInfo host user password | 932 | LogSQLRemhostIgnore foo.com |
933 | \layout Standard | ||
934 | |||
935 | A great way to catch the vast majority of worm-attack requests and prevent | ||
936 | them from being logged is to specify: | ||
832 | \layout LyX-Code | 937 | \layout LyX-Code |
833 | 938 | ||
834 | Example: LogSQLLoginInfo foobar.baz.com logwriter passw0rd | 939 | LogSQLRequestIgnore root.exe cmd.exe default.ida |
940 | \layout Subsection | ||
941 | |||
942 | Advanced logging scenarios | ||
943 | \layout Subsubsection | ||
944 | |||
945 | |||
946 | \begin_inset LatexCommand \label{secMulTable} | ||
947 | |||
948 | \end_inset | ||
949 | |||
950 | Logging many-to-one data in separate tables | ||
951 | \layout Standard | ||
952 | |||
953 | A given HTTP request can have a one-to-many relationship with certain kinds | ||
954 | of data. | ||
955 | For example, a single HTTP request can have 4 cookies, 3 headers and 5 | ||
956 | mod_gzip notes associated with it. | ||
957 | mod_log_sql is capable of logging these relationships due to the elegance | ||
958 | of SQL relational data. | ||
959 | \layout Standard | ||
960 | |||
961 | You already have a single table containing access requests. | ||
962 | One of the columns in that table is 'id' which contains the unique request | ||
963 | ID supplied by the standard Apache module mod_unique_id (assuming you compile | ||
964 | 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 | ||
966 | the database. | ||
967 | \layout Standard | ||
968 | |||
969 | So, let's add several new tables: a notes table, a cookies table, and tables | ||
970 | for inbound and outbound headers. | ||
971 | We have a certain request, let's say its unique ID is | ||
972 | \begin_inset Quotes eld | ||
973 | \end_inset | ||
974 | |||
975 | XYZ123 | ||
976 | \begin_inset Quotes erd | ||
977 | \end_inset | ||
978 | |||
979 | . | ||
980 | Within each separate table will be multiple entries with that request ID: | ||
981 | several cookie entries, several header entries, etc. | ||
982 | Something like this: | ||
983 | \layout Standard | ||
984 | |||
985 | \begin_float tab | ||
986 | \layout Caption | ||
987 | |||
988 | |||
989 | \begin_inset LatexCommand \label{tblAcc} | ||
990 | |||
991 | \end_inset | ||
992 | |||
993 | access_log | ||
994 | \layout Standard | ||
995 | \align center | ||
996 | |||
997 | \begin_inset Tabular | ||
998 | <lyxtabular version="2" rows="2" columns="3"> | ||
999 | <features rotate="false" islongtable="false" endhead="0" endfirsthead="0" endfoot="0" endlastfoot="0"> | ||
1000 | <column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> | ||
1001 | <column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> | ||
1002 | <column alignment="left" valignment="top" leftline="true" rightline="true" width="" special=""> | ||
1003 | <row topline="true" bottomline="true" newpage="false"> | ||
1004 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
1005 | \begin_inset Text | ||
1006 | |||
1007 | \layout Standard | ||
1008 | |||
1009 | id | ||
1010 | \end_inset | ||
1011 | </cell> | ||
1012 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
1013 | \begin_inset Text | ||
1014 | |||
1015 | \layout Standard | ||
1016 | |||
1017 | remote_host | ||
1018 | \end_inset | ||
1019 | </cell> | ||
1020 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
1021 | \begin_inset Text | ||
1022 | |||
1023 | \layout Standard | ||
1024 | |||
1025 | request_uri | ||
1026 | \end_inset | ||
1027 | </cell> | ||
1028 | </row> | ||
1029 | <row topline="true" bottomline="true" newpage="false"> | ||
1030 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
1031 | \begin_inset Text | ||
1032 | |||
1033 | \layout Standard | ||
1034 | |||
1035 | XYZ123 | ||
1036 | \end_inset | ||
1037 | </cell> | ||
1038 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
1039 | \begin_inset Text | ||
1040 | |||
1041 | \layout Standard | ||
1042 | |||
1043 | foo.bar.com | ||
1044 | \end_inset | ||
1045 | </cell> | ||
1046 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
1047 | \begin_inset Text | ||
1048 | |||
1049 | \layout Standard | ||
1050 | |||
1051 | /index.html | ||
1052 | \end_inset | ||
1053 | </cell> | ||
1054 | </row> | ||
1055 | </lyxtabular> | ||
1056 | |||
1057 | \end_inset | ||
1058 | |||
1059 | |||
1060 | \end_float | ||
1061 | \begin_float tab | ||
1062 | \layout Caption | ||
1063 | |||
1064 | |||
1065 | \begin_inset LatexCommand \label{tblNotes} | ||
1066 | |||
1067 | \end_inset | ||
1068 | |||
1069 | notes_log | ||
1070 | \layout Standard | ||
1071 | \align center | ||
1072 | |||
1073 | \begin_inset Tabular | ||
1074 | <lyxtabular version="2" rows="3" columns="3"> | ||
1075 | <features rotate="false" islongtable="false" endhead="0" endfirsthead="0" endfoot="0" endlastfoot="0"> | ||
1076 | <column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> | ||
1077 | <column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> | ||
1078 | <column alignment="left" valignment="top" leftline="true" rightline="true" width="" special=""> | ||
1079 | <row topline="true" bottomline="true" newpage="false"> | ||
1080 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
1081 | \begin_inset Text | ||
1082 | |||
1083 | \layout Standard | ||
1084 | |||
1085 | id | ||
1086 | \end_inset | ||
1087 | </cell> | ||
1088 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
1089 | \begin_inset Text | ||
1090 | |||
1091 | \layout Standard | ||
1092 | |||
1093 | item | ||
1094 | \end_inset | ||
1095 | </cell> | ||
1096 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
1097 | \begin_inset Text | ||
1098 | |||
1099 | \layout Standard | ||
1100 | |||
1101 | val | ||
1102 | \end_inset | ||
1103 | </cell> | ||
1104 | </row> | ||
1105 | <row topline="true" bottomline="false" newpage="false"> | ||
1106 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
1107 | \begin_inset Text | ||
1108 | |||
1109 | \layout Standard | ||
1110 | |||
1111 | XYZ123 | ||
1112 | \end_inset | ||
1113 | </cell> | ||
1114 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
1115 | \begin_inset Text | ||
1116 | |||
1117 | \layout Standard | ||
1118 | |||
1119 | mod_gzip_result | ||
1120 | \end_inset | ||
1121 | </cell> | ||
1122 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
1123 | \begin_inset Text | ||
1124 | |||
1125 | \layout Standard | ||
1126 | |||
1127 | OK | ||
1128 | \end_inset | ||
1129 | </cell> | ||
1130 | </row> | ||
1131 | <row topline="true" bottomline="true" newpage="false"> | ||
1132 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
1133 | \begin_inset Text | ||
1134 | |||
1135 | \layout Standard | ||
1136 | |||
1137 | XYZ123 | ||
1138 | \end_inset | ||
1139 | </cell> | ||
1140 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
1141 | \begin_inset Text | ||
1142 | |||
1143 | \layout Standard | ||
1144 | |||
1145 | mod_gzip_compression_ratio | ||
1146 | \end_inset | ||
1147 | </cell> | ||
1148 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
1149 | \begin_inset Text | ||
1150 | |||
1151 | \layout Standard | ||
1152 | |||
1153 | 69 | ||
1154 | \end_inset | ||
1155 | </cell> | ||
1156 | </row> | ||
1157 | </lyxtabular> | ||
1158 | |||
1159 | \end_inset | ||
1160 | |||
1161 | |||
1162 | \end_float | ||
1163 | \layout Standard | ||
1164 | |||
1165 | \begin_float tab | ||
1166 | \layout Caption | ||
1167 | |||
1168 | |||
1169 | \begin_inset LatexCommand \label{tblHdr} | ||
1170 | |||
1171 | \end_inset | ||
1172 | |||
1173 | headers_log | ||
1174 | \layout Standard | ||
1175 | \align center | ||
1176 | |||
1177 | \begin_inset Tabular | ||
1178 | <lyxtabular version="2" rows="5" columns="3"> | ||
1179 | <features rotate="false" islongtable="false" endhead="0" endfirsthead="0" endfoot="0" endlastfoot="0"> | ||
1180 | <column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> | ||
1181 | <column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> | ||
1182 | <column alignment="left" valignment="top" leftline="true" rightline="true" width="" special=""> | ||
1183 | <row topline="true" bottomline="true" newpage="false"> | ||
1184 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
1185 | \begin_inset Text | ||
1186 | |||
1187 | \layout Standard | ||
1188 | |||
1189 | id | ||
1190 | \end_inset | ||
1191 | </cell> | ||
1192 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
1193 | \begin_inset Text | ||
1194 | |||
1195 | \layout Standard | ||
1196 | |||
1197 | item | ||
1198 | \end_inset | ||
1199 | </cell> | ||
1200 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
1201 | \begin_inset Text | ||
1202 | |||
1203 | \layout Standard | ||
1204 | |||
1205 | val | ||
1206 | \end_inset | ||
1207 | </cell> | ||
1208 | </row> | ||
1209 | <row topline="true" bottomline="false" newpage="false"> | ||
1210 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
1211 | \begin_inset Text | ||
1212 | |||
1213 | \layout Standard | ||
1214 | |||
1215 | XYZ123 | ||
1216 | \end_inset | ||
1217 | </cell> | ||
1218 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
1219 | \begin_inset Text | ||
1220 | |||
1221 | \layout Standard | ||
1222 | |||
1223 | Content-Type | ||
1224 | \end_inset | ||
1225 | </cell> | ||
1226 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
1227 | \begin_inset Text | ||
1228 | |||
1229 | \layout Standard | ||
1230 | |||
1231 | text/html | ||
1232 | \end_inset | ||
1233 | </cell> | ||
1234 | </row> | ||
1235 | <row topline="true" bottomline="false" newpage="false"> | ||
1236 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
1237 | \begin_inset Text | ||
1238 | |||
1239 | \layout Standard | ||
1240 | |||
1241 | XYZ123 | ||
1242 | \end_inset | ||
1243 | </cell> | ||
1244 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
1245 | \begin_inset Text | ||
1246 | |||
1247 | \layout Standard | ||
1248 | |||
1249 | Accept-Encoding | ||
1250 | \end_inset | ||
1251 | </cell> | ||
1252 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
1253 | \begin_inset Text | ||
1254 | |||
1255 | \layout Standard | ||
1256 | |||
1257 | gzip, deflate | ||
1258 | \end_inset | ||
1259 | </cell> | ||
1260 | </row> | ||
1261 | <row topline="true" bottomline="false" newpage="false"> | ||
1262 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
1263 | \begin_inset Text | ||
1264 | |||
1265 | \layout Standard | ||
1266 | |||
1267 | XYZ123 | ||
1268 | \end_inset | ||
1269 | </cell> | ||
1270 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
1271 | \begin_inset Text | ||
1272 | |||
1273 | \layout Standard | ||
1274 | |||
1275 | Expires | ||
1276 | \end_inset | ||
1277 | </cell> | ||
1278 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
1279 | \begin_inset Text | ||
1280 | |||
1281 | \layout Standard | ||
1282 | |||
1283 | Tue, 28 May 2002 10:00:18 GMT | ||
1284 | \end_inset | ||
1285 | </cell> | ||
1286 | </row> | ||
1287 | <row topline="true" bottomline="true" newpage="false"> | ||
1288 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
1289 | \begin_inset Text | ||
1290 | |||
1291 | \layout Standard | ||
1292 | |||
1293 | XYZ123 | ||
1294 | \end_inset | ||
1295 | </cell> | ||
1296 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
1297 | \begin_inset Text | ||
1298 | |||
1299 | \layout Standard | ||
1300 | |||
1301 | Cache-Control | ||
1302 | \end_inset | ||
1303 | </cell> | ||
1304 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
1305 | \begin_inset Text | ||
1306 | |||
1307 | \layout Standard | ||
1308 | |||
1309 | max-age=86400 | ||
1310 | \end_inset | ||
1311 | </cell> | ||
1312 | </row> | ||
1313 | </lyxtabular> | ||
1314 | |||
1315 | \end_inset | ||
1316 | |||
1317 | |||
1318 | \end_float | ||
1319 | \layout Standard | ||
1320 | |||
1321 | As you can see in tables | ||
1322 | \begin_inset LatexCommand \ref{tblAcc} | ||
1323 | |||
1324 | \end_inset | ||
1325 | |||
1326 | , | ||
1327 | \begin_inset LatexCommand \ref{tblNotes} | ||
1328 | |||
1329 | \end_inset | ||
1330 | |||
1331 | and | ||
1332 | \begin_inset LatexCommand \ref{tblHdr} | ||
1333 | |||
1334 | \end_inset | ||
1335 | |||
1336 | , you have a many-to-one relationship for request XYZ123: one access has | ||
1337 | two associated notes and four associated headers. | ||
1338 | You can extract this data easily using the power of SQL's | ||
1339 | \begin_inset Quotes eld | ||
1340 | \end_inset | ||
1341 | |||
1342 | select | ||
1343 | \begin_inset Quotes erd | ||
1344 | \end_inset | ||
1345 | |||
1346 | statement and table joins. | ||
1347 | To see the notes associated with a particular request: | ||
835 | \layout LyX-Code | 1348 | \layout LyX-Code |
836 | 1349 | ||
837 | Context: server config | 1350 | select a.remote_host, a.request_uri, n.item, n.val from access_log a, notes_log |
838 | \layout Quote | 1351 | n where a.id=n.id and a.id='PPIDskBRH30AAGPtAsg'; |
1352 | \layout LyX-Code | ||
839 | 1353 | ||
840 | Defines the general parameters of the MySQL host to which you will be logging. | 1354 | \layout Standard |
841 | host is the hostname or IP address of the MySQL machine. | 1355 | \align center |
842 | user is the MySQL userid (not a Unix userid!) with INSERT privileges on | 1356 | |
843 | the table defined in LogSQLTransferLogTable. | 1357 | \begin_inset Tabular |
844 | password is that user's password. | 1358 | <lyxtabular version="2" rows="3" columns="4"> |
845 | This is defined only once in the httpd.conf file. | 1359 | <features rotate="false" islongtable="false" endhead="0" endfirsthead="0" endfoot="0" endlastfoot="0"> |
1360 | <column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> | ||
1361 | <column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> | ||
1362 | <column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> | ||
1363 | <column alignment="left" valignment="top" leftline="true" rightline="true" width="" special=""> | ||
1364 | <row topline="true" bottomline="true" newpage="false"> | ||
1365 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
1366 | \begin_inset Text | ||
1367 | |||
1368 | \layout Standard | ||
1369 | |||
1370 | remote_host | ||
1371 | \end_inset | ||
1372 | </cell> | ||
1373 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
1374 | \begin_inset Text | ||
1375 | |||
1376 | \layout Standard | ||
1377 | |||
1378 | request_uri | ||
1379 | \end_inset | ||
1380 | </cell> | ||
1381 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
1382 | \begin_inset Text | ||
1383 | |||
1384 | \layout Standard | ||
1385 | |||
1386 | item | ||
1387 | \end_inset | ||
1388 | </cell> | ||
1389 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
1390 | \begin_inset Text | ||
1391 | |||
1392 | \layout Standard | ||
1393 | |||
1394 | val | ||
1395 | \end_inset | ||
1396 | </cell> | ||
1397 | </row> | ||
1398 | <row topline="true" bottomline="false" newpage="false"> | ||
1399 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
1400 | \begin_inset Text | ||
1401 | |||
1402 | \layout Standard | ||
1403 | |||
1404 | zerberus.aiacs.net | ||
1405 | \end_inset | ||
1406 | </cell> | ||
1407 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
1408 | \begin_inset Text | ||
1409 | |||
1410 | \layout Standard | ||
1411 | |||
1412 | /mod_log_sql/style_1.css | ||
1413 | \end_inset | ||
1414 | </cell> | ||
1415 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
1416 | \begin_inset Text | ||
1417 | |||
1418 | \layout Standard | ||
1419 | |||
1420 | mod_gzip_result | ||
1421 | \end_inset | ||
1422 | </cell> | ||
1423 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
1424 | \begin_inset Text | ||
1425 | |||
1426 | \layout Standard | ||
1427 | |||
1428 | DECLINED:EXCLUDED | ||
1429 | \end_inset | ||
1430 | </cell> | ||
1431 | </row> | ||
1432 | <row topline="true" bottomline="true" newpage="false"> | ||
1433 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
1434 | \begin_inset Text | ||
1435 | |||
1436 | \layout Standard | ||
1437 | |||
1438 | zerberus.aiacs.net | ||
1439 | \end_inset | ||
1440 | </cell> | ||
1441 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
1442 | \begin_inset Text | ||
1443 | |||
1444 | \layout Standard | ||
1445 | |||
1446 | /mod_log_sql/style_1.css | ||
1447 | \end_inset | ||
1448 | </cell> | ||
1449 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
1450 | \begin_inset Text | ||
1451 | |||
1452 | \layout Standard | ||
1453 | |||
1454 | mod_gzip_compression_ratio | ||
1455 | \end_inset | ||
1456 | </cell> | ||
1457 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
1458 | \begin_inset Text | ||
1459 | |||
1460 | \layout Standard | ||
1461 | |||
1462 | 0 | ||
1463 | \end_inset | ||
1464 | </cell> | ||
1465 | </row> | ||
1466 | </lyxtabular> | ||
1467 | |||
1468 | \end_inset | ||
1469 | |||
1470 | |||
1471 | \layout LyX-Code | ||
1472 | |||
1473 | \layout LyX-Code | ||
1474 | |||
1475 | \layout Standard | ||
1476 | |||
1477 | In order to use this capability of mod_log_sql, you must do several things: | ||
1478 | \layout Itemize | ||
1479 | |||
1480 | Compile mod_unique_id into Apache (statically or as a DSO). | ||
1481 | mod_log_sql employs the unique request ID that mod_unique_id provides in | ||
1482 | order to key between the separate tables. | ||
1483 | You can still log the data without mod_unqiue_id, but it will be completely | ||
1484 | uncorrelated and you will have no way to discern any meaning. | ||
1485 | \layout Itemize | ||
1486 | |||
1487 | Create the appropriate tables. | ||
1488 | This will be done for you if you permit mod_log_sql to create its own tables, | ||
1489 | or if you use the enclosed create_tables.sql script. | ||
1490 | \layout Itemize | ||
1491 | |||
1492 | Create a SQL index on the | ||
1493 | \begin_inset Quotes eld | ||
1494 | \end_inset | ||
1495 | |||
1496 | id | ||
1497 | \begin_inset Quotes erd | ||
1498 | \end_inset | ||
1499 | |||
1500 | column. | ||
1501 | Without this index, table joins will be deathly slow. | ||
1502 | I recommend you consult the MySQL documentation on the proper way to create | ||
1503 | a column index if you are not familiar with this operation. | ||
1504 | \layout Itemize | ||
1505 | |||
1506 | Within each appropriate VirtualHost stanza, use the LogSQLWhich* and LogSQL*LogT | ||
1507 | able directives to tell the module what and where to log the data. | ||
1508 | In the following example, I have specified a name for the notes table that | ||
1509 | is different from the default, whereas I have left the other table names | ||
1510 | at their defaults. | ||
1511 | I then specified the cookies, headers and notes that interest me. | ||
1512 | \layout LyX-Code | ||
1513 | |||
1514 | <VirtualHost 216.231.36.128> | ||
1515 | \layout LyX-Code | ||
1516 | |||
1517 | (snip) | ||
1518 | \layout LyX-Code | ||
1519 | |||
1520 | LogSQLNotesLogTable notestable | ||
1521 | \layout LyX-Code | ||
1522 | |||
1523 | LogSQLWhichCookies bluecookie redcookie greencookie | ||
1524 | \layout LyX-Code | ||
1525 | |||
1526 | LogSQLWhichNotes mod_gzip_result mod_gzip_compression_ratio | ||
1527 | \layout LyX-Code | ||
1528 | |||
1529 | LogSQLWhichHeadersOut Expires Content-Type Cache-Control | ||
1530 | \layout LyX-Code | ||
1531 | |||
1532 | LogSQLWhichHeadersIn UserAgent Accept-Encoding Host | ||
1533 | \layout LyX-Code | ||
1534 | |||
1535 | (snip) | ||
1536 | \layout LyX-Code | ||
1537 | |||
1538 | </VirtualHost> | ||
1539 | \layout LyX-Code | ||
1540 | |||
1541 | \layout Subsection | ||
1542 | |||
1543 | |||
1544 | \begin_inset LatexCommand \label{sec:ConfRef} | ||
1545 | |||
1546 | \end_inset | ||
1547 | |||
1548 | Configuration directive reference | ||
1549 | \layout Standard | ||
1550 | |||
1551 | It is imperative that you understand which directives are used | ||
1552 | \emph on | ||
1553 | only once | ||
1554 | \emph default | ||
1555 | in the main server config, and which are used inside VirtualHost stanzas | ||
1556 | and therefore multiple times within httpd.conf. | ||
1557 | The | ||
1558 | \begin_inset Quotes eld | ||
1559 | \end_inset | ||
1560 | |||
1561 | context | ||
1562 | \begin_inset Quotes srd | ||
1563 | \end_inset | ||
1564 | |||
1565 | listed with each entry informs you of this. | ||
846 | \layout Subsubsection | 1566 | \layout Subsubsection |
847 | 1567 | ||
848 | LogSQLDatabase | 1568 | LogSQLDatabase |
@@ -859,7 +1579,7 @@ Syntax: LogSQLDatabase database | |||
859 | Example: LogSQLDatabase loggingdb | 1579 | Example: LogSQLDatabase loggingdb |
860 | \layout LyX-Code | 1580 | \layout LyX-Code |
861 | 1581 | ||
862 | Context: server config | 1582 | Context: main server config |
863 | \layout Quote | 1583 | \layout Quote |
864 | 1584 | ||
865 | Defines the database that is used for logging. | 1585 | Defines the database that is used for logging. |
@@ -867,143 +1587,175 @@ Defines the database that is used for logging. | |||
867 | This is defined only once in the httpd.conf file. | 1587 | This is defined only once in the httpd.conf file. |
868 | \layout Subsubsection | 1588 | \layout Subsubsection |
869 | 1589 | ||
870 | LogSQLTransferLogTable | 1590 | LogSQLLoginInfo |
871 | \layout LyX-Code | 1591 | \layout LyX-Code |
872 | 1592 | ||
873 | 1593 | ||
874 | \series bold | 1594 | \series bold |
875 | MANDATORY | 1595 | MANDATORY |
1596 | \series default | ||
1597 | |||
876 | \layout LyX-Code | 1598 | \layout LyX-Code |
877 | 1599 | ||
878 | Syntax: LogSQLTransferLogTable table-name | 1600 | Syntax: LogSQLLoginInfo host user password |
879 | \layout LyX-Code | 1601 | \layout LyX-Code |
880 | 1602 | ||
881 | Example: LogSQLTransferLogTable access_log_table | 1603 | Example: LogSQLLoginInfo foobar.baz.com logwriter passw0rd |
882 | \layout LyX-Code | 1604 | \layout LyX-Code |
883 | 1605 | ||
884 | Context: virtual host | 1606 | Context: main server config |
885 | \layout Quote | 1607 | \layout Quote |
886 | 1608 | ||
887 | Defines which table is used for logging of Apache's transfers; this is analogous | 1609 | Defines the general parameters of the MySQL host to which you will be logging. |
888 | to Apache's TransferLog directive. | 1610 | host is the hostname or IP address of the MySQL machine. |
889 | table-name must be a valid table within the database defined in LogSQLDatabase. | 1611 | user is the MySQL userid (not a Unix userid!) with INSERT privileges on |
890 | \layout Quote | 1612 | the table defined in LogSQLTransferLogTable. |
891 | 1613 | password is that user's password. | |
892 | This directive is not necessary if you declare LogSQLMassVirtualHosting | 1614 | This is defined only once in the httpd.conf file. |
893 | On, since that directive activates dynamically-named tables. | ||
894 | If you attempt to use LogSQLTransferLogTable at the same time a warning | ||
895 | will be logged and it will be ignored, since LogSQLMassVirtualHosting takes | ||
896 | priority. | ||
897 | \layout Subsubsection | 1615 | \layout Subsubsection |
898 | 1616 | ||
899 | LogSQLRequestIgnore | 1617 | LogSQLTCPPort |
900 | \layout LyX-Code | 1618 | \layout LyX-Code |
901 | 1619 | ||
902 | Syntax: LogSQLRequestIgnore req1 req2 req3 ... | 1620 | Syntax: LogSQLTCPPort portnumber |
903 | reqN | ||
904 | \layout LyX-Code | 1621 | \layout LyX-Code |
905 | 1622 | ||
906 | Example: LogSQLRequestIgnore root.exe cmd.exe default.ida favicon.ico | 1623 | Example: LogSQLTCPPort 3309 |
907 | \layout LyX-Code | 1624 | \layout LyX-Code |
908 | 1625 | ||
909 | Context: virtual host | 1626 | Default: 3306 |
910 | \layout Quote | 1627 | \layout LyX-Code |
911 | 1628 | ||
912 | Lists a series of strings that, if present in the URI, will cause that request | 1629 | Context: main server config |
913 | NOT to be logged. | ||
914 | This directive is useful for cutting down on log clutter when you KNOW | ||
915 | that you do not want to log requests for certain objects. | ||
916 | (The example above is a genuinely useful one; it will prevent logging of | ||
917 | many common Microsoft-based worm intrusion attempts, as well as those ridiculou | ||
918 | s requests for the favicon.) | ||
919 | \layout Quote | 1630 | \layout Quote |
920 | 1631 | ||
921 | Each string is separated by a space, and NO regular expressions or globbing | 1632 | Your database may listen on a different port than the default. |
922 | are allowed. | 1633 | If so, use this directive to instruct the module which port to use. |
923 | Each string is evaluated as a substring of the URI using strstr(). | 1634 | This directive only applies if the database is on a different machine connected |
1635 | via TCP/IP. | ||
924 | \layout Subsubsection | 1636 | \layout Subsubsection |
925 | 1637 | ||
926 | LogSQLRemhostIgnore | 1638 | LogSQLSocketFile |
927 | \layout LyX-Code | 1639 | \layout LyX-Code |
928 | 1640 | ||
929 | Syntax: LogSQLRemhostIgnore host1 host2 host3 ... | 1641 | Syntax: LogSQLSocketFile filename |
930 | hostN | ||
931 | \layout LyX-Code | 1642 | \layout LyX-Code |
932 | 1643 | ||
933 | Example: LogSQLRemhostIgnore localnet.com | 1644 | Example: LogSQLSocketFile /tmp/mysql.sock |
934 | \layout LyX-Code | 1645 | \layout LyX-Code |
935 | 1646 | ||
936 | Context: virtual host | 1647 | Default: /var/lib/mysql/mysql.sock |
1648 | \layout LyX-Code | ||
1649 | |||
1650 | Context: main server config | ||
937 | \layout Quote | 1651 | \layout Quote |
938 | 1652 | ||
939 | Lists a series of strings that, if present in the REMOTE_HOST, will cause | 1653 | At Apache runtime you can specify the MySQL socket file to use. |
940 | that request NOT to be logged. | 1654 | Set this once in your main server config to override the default value. |
941 | This directive is useful for cutting down on log clutter when you KNOW | 1655 | This value is irrelevant if your database resides on a separate machine. |
942 | that you do not want to log requests from certain hosts, such as your own | ||
943 | internal network machines. | ||
944 | \layout Quote | 1656 | \layout Quote |
945 | 1657 | ||
946 | Each string is separated by a space, and NO regular expressions or globbing | 1658 | mod_log_sql will automatically employ the socket for db communications if |
947 | are allowed. | 1659 | the database resides on the local host. |
948 | Each string is evaluated as a substring of the REMOTE_HOST using strstr(). | 1660 | If the db resides on a separate host the module will automatically use |
1661 | TCP/IP. | ||
1662 | This is a function of the MySQL API and is not user-configurable. | ||
949 | \layout Subsubsection | 1663 | \layout Subsubsection |
950 | 1664 | ||
951 | LogSQLRefererIgnore | 1665 | LogSQLPreserveFile |
1666 | \layout LyX-Code | ||
1667 | |||
1668 | Syntax: LogSQLPreserveFile filename | ||
952 | \layout LyX-Code | 1669 | \layout LyX-Code |
953 | 1670 | ||
954 | Syntax: LogSQLRefererIgnore ref1 ref2 ref3 ... | 1671 | Example: LogSQLPreserveFile offline-preserve |
955 | refN | ||
956 | \layout LyX-Code | 1672 | \layout LyX-Code |
957 | 1673 | ||
958 | Example: LogSQLRefererIgnore google.com | 1674 | Default: /tmp/sql-preserve |
959 | \layout LyX-Code | 1675 | \layout LyX-Code |
960 | 1676 | ||
961 | Context: virtual host | 1677 | Context: virtual host |
962 | \layout Quote | 1678 | \layout Quote |
963 | 1679 | ||
964 | Lists a series of strings that, if present in the HTTP_REFERER, will cause | 1680 | mod_log_sql writes queries to this local preserve file in the event that |
965 | that request NOT to be logged. | 1681 | it cannot reach the database, and thus ensures that your high-availability |
966 | This directive is useful for cutting down on log clutter when you know | 1682 | web frontend does not lose logs during a temporary database outage. |
967 | that you do not want to log requests from certain referers. | 1683 | This could happen for a number of reasons: the database goes offline, the |
1684 | network breaks, etc. | ||
1685 | You will not lose entries since the module has this backup. | ||
1686 | The file consists of a series of SQL statements that can be imported into | ||
1687 | your database at your convenience; furthermore, because the SQL queries | ||
1688 | contain the access timestamps you do not need to worry about out-of-order | ||
1689 | data after the import. | ||
968 | \layout Quote | 1690 | \layout Quote |
969 | 1691 | ||
970 | Each string is separated by a space, and NO regular expressions or globbing | 1692 | If you do not define LogSQLPreserveFile then all virtual servers will log |
971 | are allowed. | 1693 | to the same default preserve file (/tmp/mysql-preserve). |
972 | Each string is evaluated as a substring of the HTTP_REFERER using strstr(). | 1694 | You can redefine this on a virtual-host basis in order to segregate your |
1695 | preserve files if you desire. | ||
1696 | Note that segregation is not really necessary, as the SQL statements that | ||
1697 | are written to the preserve file already distinguish between different | ||
1698 | virtual hosts if you include the 'v' character in your LogSQLTransferLogFormat | ||
1699 | directive. | ||
1700 | \layout Quote | ||
1701 | |||
1702 | The module will log to error-log if/when it notices a database outage, and | ||
1703 | upon database return. | ||
1704 | You will therefore know when the preserve file is being used, although | ||
1705 | it is your responsibility to import the file. | ||
1706 | \layout Quote | ||
1707 | |||
1708 | The file does not need to be created in advance. | ||
1709 | It is safe to remove or rename the file without interrupting Apache, as | ||
1710 | the module closes the filehandle immediately after completing the write. | ||
1711 | The file is created with the user & group ID of the running Apache process | ||
1712 | (e.g. | ||
1713 | 'nobody' on many Linux distributions). | ||
973 | \layout Subsubsection | 1714 | \layout Subsubsection |
974 | 1715 | ||
975 | LogSQLWhichCookie | 1716 | LogSQLForcePreserve |
976 | \layout LyX-Code | 1717 | \layout LyX-Code |
977 | 1718 | ||
978 | Syntax: LogSQLWhichCookie cookiename | 1719 | Syntax: LogSQLForcePreserve Flag |
979 | \layout LyX-Code | 1720 | \layout LyX-Code |
980 | 1721 | ||
981 | Example: LogSQLWhichCookie Clicks | 1722 | Example: LogSQLPreserveFile on |
982 | \layout LyX-Code | 1723 | \layout LyX-Code |
983 | 1724 | ||
984 | Default: None. | 1725 | Default: off |
985 | You must set this if you wish to capture cookies. | ||
986 | \layout LyX-Code | 1726 | \layout LyX-Code |
987 | 1727 | ||
988 | Context: virtual host | 1728 | Context: main server config |
989 | \layout Quote | 1729 | \layout Quote |
990 | 1730 | ||
991 | In HTTP, cookies have names to distinguish them from each other. | 1731 | You may need to perform debugging on your database and specifically want |
992 | Using mod_usertrack, for example, you can give your user-tracking cookies | 1732 | mod_log_sql to make no attempts to log to it. |
993 | a name with the CookieName directive. | 1733 | This directive instructs the module to send all its log entries directly |
1734 | to the preserve file and to make no database INSERT attempts. | ||
994 | \layout Quote | 1735 | \layout Quote |
995 | 1736 | ||
996 | If you have activated cookie logging in LogSQLTransferLogFormat, then LogSQLWhic | 1737 | This is presumably a directive for temporary use only; it could be dangerous |
997 | hCookie tells mod_log_sql which cookie to log. | 1738 | if you set it and forget it, as all your entries will simply pile up in |
998 | This is useful because many times you will be setting and receiving more | 1739 | the preserve file. |
999 | than one cookie from a client; without this directive you'd be unable to | 1740 | \layout Subsubsection |
1000 | choose which cookie is your mod_usertrack cookie. | 1741 | |
1742 | LogSQLMachineID | ||
1743 | \layout LyX-Code | ||
1744 | |||
1745 | Syntax: LogSQLMachineID somename | ||
1746 | \layout LyX-Code | ||
1747 | |||
1748 | Example: LogSQLMachineID web01 | ||
1749 | \layout LyX-Code | ||
1750 | |||
1751 | Context: main server config | ||
1001 | \layout Quote | 1752 | \layout Quote |
1002 | 1753 | ||
1003 | Note: although this was intended for people who are using mod_usertrack | 1754 | If you have a farm of webservers you may wish to log which particular machine |
1004 | to set user-tracking cookies, you aren't restricted in any way. | 1755 | made each entry; this is useful for analyzing your loadbalancing methodology. |
1005 | You can choose which cookie you wish to log to the database, and it doesn't | 1756 | LogSQLMachineID permits you to distinguish each machine's entries if you |
1006 | necessarily have to have anything to do with mod_usertrack. | 1757 | assign each machine its own LogSQLMachineID: for example, web01, web02, |
1758 | web03, etc. | ||
1007 | \layout Subsubsection | 1759 | \layout Subsubsection |
1008 | 1760 | ||
1009 | LogSQLCreateTables | 1761 | LogSQLCreateTables |
@@ -1018,10 +1770,10 @@ Example: LogSQLCreateTables On | |||
1018 | Default: Off | 1770 | Default: Off |
1019 | \layout LyX-Code | 1771 | \layout LyX-Code |
1020 | 1772 | ||
1021 | Context: server config | 1773 | Context: main server config |
1022 | \layout Quote | 1774 | \layout Quote |
1023 | 1775 | ||
1024 | mod_log_sql now has the ability to create its tables on-the-fly. | 1776 | mod_log_sql has the ability to create its tables on-the-fly. |
1025 | The advantage to this is convenience: you don't have to execute any SQL | 1777 | The advantage to this is convenience: you don't have to execute any SQL |
1026 | by hand to prepare the table. | 1778 | by hand to prepare the table. |
1027 | This is especially helpful for people with lots of virtual hosts (who should | 1779 | This is especially helpful for people with lots of virtual hosts (who should |
@@ -1038,7 +1790,7 @@ There is a slight disadvantage: if you wish to activate this feature, then | |||
1038 | CREATE on the logging database is reasonable. | 1790 | CREATE on the logging database is reasonable. |
1039 | \layout Quote | 1791 | \layout Quote |
1040 | 1792 | ||
1041 | This is defined only once in the httpd.conf file. | 1793 | Defined this only once in the httpd.conf file. |
1042 | \layout Subsubsection | 1794 | \layout Subsubsection |
1043 | 1795 | ||
1044 | LogSQLMassVirtualHosting | 1796 | LogSQLMassVirtualHosting |
@@ -1053,7 +1805,7 @@ Example: LogSQLMassVirtualHosting On | |||
1053 | Default: Off | 1805 | Default: Off |
1054 | \layout LyX-Code | 1806 | \layout LyX-Code |
1055 | 1807 | ||
1056 | Context: server config | 1808 | Context: main server config |
1057 | \layout Quote | 1809 | \layout Quote |
1058 | 1810 | ||
1059 | If you administer a site hosting many, many virtual hosts then this option | 1811 | If you administer a site hosting many, many virtual hosts then this option |
@@ -1086,85 +1838,86 @@ This is a huge boost in convenience for sites with many virtual servers. | |||
1086 | This is defined only once in the httpd.conf file. | 1838 | This is defined only once in the httpd.conf file. |
1087 | \layout Subsubsection | 1839 | \layout Subsubsection |
1088 | 1840 | ||
1089 | LogSQLPreserveFile | 1841 | LogSQLTransferLogTable |
1090 | \layout LyX-Code | 1842 | \layout LyX-Code |
1091 | 1843 | ||
1092 | Syntax: LogSQLPreserveFile filename | 1844 | |
1845 | \series bold | ||
1846 | MANDATORY (if not LogSQLMassVirtualHosting) | ||
1093 | \layout LyX-Code | 1847 | \layout LyX-Code |
1094 | 1848 | ||
1095 | Example: LogSQLPreserveFile offline-preserve | 1849 | Syntax: LogSQLTransferLogTable table-name |
1096 | \layout LyX-Code | 1850 | \layout LyX-Code |
1097 | 1851 | ||
1098 | Default: mysql-preserve (in /tmp) | 1852 | Example: LogSQLTransferLogTable access_log_table |
1099 | \layout LyX-Code | 1853 | \layout LyX-Code |
1100 | 1854 | ||
1101 | Context: virtual host | 1855 | Context: virtual host |
1102 | \layout Quote | 1856 | \layout Quote |
1103 | 1857 | ||
1104 | mod_log_sql writes queries to this local preserve file in the event that | 1858 | Defines which table is used for logging of Apache's transfers; this is analogous |
1105 | it cannot reach the database, and thus ensures that your high-availability | 1859 | to Apache's TransferLog directive. |
1106 | web frontend does not lose logs during a temporary database outage. | 1860 | table-name must be a valid table within the database defined in LogSQLDatabase. |
1107 | This could happen for a number of reasons: the database goes offline, the | ||
1108 | network breaks, etc. | ||
1109 | You will not lose entries since the module has this backup. | ||
1110 | The file consists of a series of SQL statements that can be imported into | ||
1111 | your database at your convenience; furthermore, because the SQL queries | ||
1112 | contain the access timestamps you do not need to worry about out-of-order | ||
1113 | data after the import. | ||
1114 | \layout Quote | 1861 | \layout Quote |
1115 | 1862 | ||
1116 | For security purposes the name you supply will be prepended with "/tmp/" | 1863 | This directive is not necessary if you declare LogSQLMassVirtualHosting |
1117 | to force creation of the file in /tmp. | 1864 | On, since that directive activates dynamically-named tables. |
1118 | \layout Quote | 1865 | If you attempt to use LogSQLTransferLogTable at the same time a warning |
1866 | will be logged and it will be ignored, since LogSQLMassVirtualHosting takes | ||
1867 | priority. | ||
1868 | \layout Subsubsection | ||
1119 | 1869 | ||
1120 | If you do not define LogSQLPreserveFile then all virtual servers will log | 1870 | LogSQLRequestIgnore |
1121 | to the same default preserve file (/tmp/mysql-preserve). | 1871 | \layout LyX-Code |
1122 | You can redefine this on a virtual-host basis in order to segregate your | 1872 | |
1123 | preserve files if you desire. | 1873 | Syntax: LogSQLRequestIgnore req1 req2 req3 ... |
1124 | Note that segregation is not really necessary, as the SQL statements that | 1874 | reqN |
1125 | are written to the preserve file already distinguish between different | 1875 | \layout LyX-Code |
1126 | virtual hosts. | 1876 | |
1877 | Example: LogSQLRequestIgnore root.exe cmd.exe default.ida favicon.ico | ||
1878 | \layout LyX-Code | ||
1879 | |||
1880 | Context: virtual host | ||
1127 | \layout Quote | 1881 | \layout Quote |
1128 | 1882 | ||
1129 | The module will log to error-log if/when it notices a database outage, and | 1883 | Lists a series of strings that, if present in the URI, will cause that request |
1130 | upon database return. | 1884 | NOT to be logged. |
1131 | You will therefore know when the preserve file is being used, although | 1885 | This directive is useful for cutting down on log clutter when you KNOW |
1132 | it is your responsibility to import the file. | 1886 | that you do not want to log requests for certain objects. |
1887 | (The example above is a genuinely useful one; it will prevent logging of | ||
1888 | many common Microsoft-based worm intrusion attempts, as well as those ridiculou | ||
1889 | s requests for the favicon.) | ||
1133 | \layout Quote | 1890 | \layout Quote |
1134 | 1891 | ||
1135 | The file does not need to be created in advance. | 1892 | Each string is separated by a space, and NO regular expressions or globbing |
1136 | It is safe to remove or rename the file without interrupting Apache, as | 1893 | are allowed. |
1137 | the module closes the filehandle immediately after completing the write. | 1894 | Each string is evaluated as a substring of the URI using strstr(). |
1138 | The file is created with the user & group ID of the running Apache process | ||
1139 | (e.g. | ||
1140 | 'nobody' on many Linux distributions). | ||
1141 | \layout Subsubsection | 1895 | \layout Subsubsection |
1142 | 1896 | ||
1143 | LogSQLSocketFile | 1897 | LogSQLRemhostIgnore |
1144 | \layout LyX-Code | ||
1145 | |||
1146 | Syntax: LogSQLSocketFile filename | ||
1147 | \layout LyX-Code | 1898 | \layout LyX-Code |
1148 | 1899 | ||
1149 | Example: LogSQLSocketFile /tmp/mysql.sock | 1900 | Syntax: LogSQLRemhostIgnore host1 host2 host3 ... |
1901 | hostN | ||
1150 | \layout LyX-Code | 1902 | \layout LyX-Code |
1151 | 1903 | ||
1152 | Default: /var/lib/mysql/mysql.sock | 1904 | Example: LogSQLRemhostIgnore localnet.com |
1153 | \layout LyX-Code | 1905 | \layout LyX-Code |
1154 | 1906 | ||
1155 | Context: server config | 1907 | Context: virtual host |
1156 | \layout Quote | 1908 | \layout Quote |
1157 | 1909 | ||
1158 | At Apache runtime you can specify the MySQL socket file to use. | 1910 | Lists a series of strings that, if present in the REMOTE_HOST, will cause |
1159 | Set this once in your main server config to override the default value. | 1911 | that request NOT to be logged. |
1160 | This value is irrelevant if your database resides on a separate machine. | 1912 | This directive is useful for cutting down on log clutter when you KNOW |
1913 | that you do not want to log requests from certain hosts, such as your own | ||
1914 | internal network machines. | ||
1161 | \layout Quote | 1915 | \layout Quote |
1162 | 1916 | ||
1163 | mod_log_sql will automatically employ the socket for db communications if | 1917 | Each string is separated by a space, and NO regular expressions or globbing |
1164 | the database resides on the local host. | 1918 | are allowed. |
1165 | If the db resides on a separate host the module will automatically use | 1919 | Each string is simply evaluated as a substring of the REMOTE_HOST using |
1166 | TCP/IP. | 1920 | strstr(). |
1167 | This is a function of the MySQL API and is not user-configurable. | ||
1168 | \layout Subsubsection | 1921 | \layout Subsubsection |
1169 | 1922 | ||
1170 | LogSQLTransferLogFormat | 1923 | LogSQLTransferLogFormat |
@@ -1207,7 +1960,7 @@ Each character in the format-string defines an attribute of the request | |||
1207 | 1960 | ||
1208 | 1961 | ||
1209 | \series bold | 1962 | \series bold |
1210 | Character | 1963 | Char |
1211 | \end_inset | 1964 | \end_inset |
1212 | </cell> | 1965 | </cell> |
1213 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | 1966 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> |
@@ -1237,7 +1990,7 @@ MySQL DB field | |||
1237 | 1990 | ||
1238 | 1991 | ||
1239 | \series bold | 1992 | \series bold |
1240 | Recommended column type | 1993 | Column type |
1241 | \end_inset | 1994 | \end_inset |
1242 | </cell> | 1995 | </cell> |
1243 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | 1996 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> |
@@ -1289,7 +2042,7 @@ varchar(255) | |||
1289 | 2042 | ||
1290 | \layout Standard | 2043 | \layout Standard |
1291 | 2044 | ||
1292 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 4.0) | 2045 | Mozilla/4.0 (compat; MSIE 6.0; Windows) |
1293 | \end_inset | 2046 | \end_inset |
1294 | </cell> | 2047 | </cell> |
1295 | </row> | 2048 | </row> |
@@ -1373,7 +2126,7 @@ varchar(255) | |||
1373 | 2126 | ||
1374 | \layout Standard | 2127 | \layout Standard |
1375 | 2128 | ||
1376 | Apache=sdyn.fooonline.net.130051007102700823 | 2129 | Apache=sdyn.fooonline.net.1300102700823 |
1377 | \end_inset | 2130 | \end_inset |
1378 | </cell> | 2131 | </cell> |
1379 | </row> | 2132 | </row> |
@@ -1383,7 +2136,7 @@ Apache=sdyn.fooonline.net.130051007102700823 | |||
1383 | 2136 | ||
1384 | \layout Standard | 2137 | \layout Standard |
1385 | 2138 | ||
1386 | f | 2139 | H |
1387 | \end_inset | 2140 | \end_inset |
1388 | </cell> | 2141 | </cell> |
1389 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | 2142 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> |
@@ -1391,6 +2144,7 @@ f | |||
1391 | 2144 | ||
1392 | \layout Standard | 2145 | \layout Standard |
1393 | 2146 | ||
2147 | HTTP request protocol | ||
1394 | \end_inset | 2148 | \end_inset |
1395 | </cell> | 2149 | </cell> |
1396 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | 2150 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> |
@@ -1398,7 +2152,7 @@ f | |||
1398 | 2152 | ||
1399 | \layout Standard | 2153 | \layout Standard |
1400 | 2154 | ||
1401 | request_file | 2155 | request_protocol |
1402 | \end_inset | 2156 | \end_inset |
1403 | </cell> | 2157 | </cell> |
1404 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | 2158 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> |
@@ -1406,7 +2160,7 @@ request_file | |||
1406 | 2160 | ||
1407 | \layout Standard | 2161 | \layout Standard |
1408 | 2162 | ||
1409 | varchar(255) | 2163 | varchar(10) |
1410 | \end_inset | 2164 | \end_inset |
1411 | </cell> | 2165 | </cell> |
1412 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | 2166 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> |
@@ -1414,6 +2168,7 @@ varchar(255) | |||
1414 | 2168 | ||
1415 | \layout Standard | 2169 | \layout Standard |
1416 | 2170 | ||
2171 | HTTP/1.1 | ||
1417 | \end_inset | 2172 | \end_inset |
1418 | </cell> | 2173 | </cell> |
1419 | </row> | 2174 | </row> |
@@ -1423,7 +2178,7 @@ varchar(255) | |||
1423 | 2178 | ||
1424 | \layout Standard | 2179 | \layout Standard |
1425 | 2180 | ||
1426 | H | 2181 | h |
1427 | \end_inset | 2182 | \end_inset |
1428 | </cell> | 2183 | </cell> |
1429 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | 2184 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> |
@@ -1431,7 +2186,7 @@ H | |||
1431 | 2186 | ||
1432 | \layout Standard | 2187 | \layout Standard |
1433 | 2188 | ||
1434 | HTTP request protocol | 2189 | Name of remote host |
1435 | \end_inset | 2190 | \end_inset |
1436 | </cell> | 2191 | </cell> |
1437 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | 2192 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> |
@@ -1439,7 +2194,7 @@ HTTP request protocol | |||
1439 | 2194 | ||
1440 | \layout Standard | 2195 | \layout Standard |
1441 | 2196 | ||
1442 | request_protocol | 2197 | remote_host |
1443 | \end_inset | 2198 | \end_inset |
1444 | </cell> | 2199 | </cell> |
1445 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | 2200 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> |
@@ -1447,7 +2202,7 @@ request_protocol | |||
1447 | 2202 | ||
1448 | \layout Standard | 2203 | \layout Standard |
1449 | 2204 | ||
1450 | varchar(10) | 2205 | varchar(50) |
1451 | \end_inset | 2206 | \end_inset |
1452 | </cell> | 2207 | </cell> |
1453 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | 2208 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> |
@@ -1455,7 +2210,7 @@ varchar(10) | |||
1455 | 2210 | ||
1456 | \layout Standard | 2211 | \layout Standard |
1457 | 2212 | ||
1458 | HTTP/1.1 | 2213 | blah.foobar.com |
1459 | \end_inset | 2214 | \end_inset |
1460 | </cell> | 2215 | </cell> |
1461 | </row> | 2216 | </row> |
@@ -1465,15 +2220,15 @@ HTTP/1.1 | |||
1465 | 2220 | ||
1466 | \layout Standard | 2221 | \layout Standard |
1467 | 2222 | ||
1468 | h | 2223 | I |
1469 | \end_inset | 2224 | \end_inset |
1470 | </cell> | 2225 | </cell> |
1471 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | 2226 | <cell multicolumn="0" alignment="left" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> |
1472 | \begin_inset Text | 2227 | \begin_inset Text |
1473 | 2228 | ||
1474 | \layout Standard | 2229 | \layout Standard |
1475 | 2230 | ||
1476 | Name of remote host | 2231 | Request ID (from mod_unique_id) |
1477 | \end_inset | 2232 | \end_inset |
1478 | </cell> | 2233 | </cell> |
1479 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | 2234 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> |
@@ -1481,7 +2236,7 @@ Name of remote host | |||
1481 | 2236 | ||
1482 | \layout Standard | 2237 | \layout Standard |
1483 | 2238 | ||
1484 | remote_host | 2239 | id |
1485 | \end_inset | 2240 | \end_inset |
1486 | </cell> | 2241 | </cell> |
1487 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | 2242 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> |
@@ -1489,7 +2244,7 @@ remote_host | |||
1489 | 2244 | ||
1490 | \layout Standard | 2245 | \layout Standard |
1491 | 2246 | ||
1492 | varchar(50) | 2247 | char(19) |
1493 | \end_inset | 2248 | \end_inset |
1494 | </cell> | 2249 | </cell> |
1495 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | 2250 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> |
@@ -1497,7 +2252,7 @@ varchar(50) | |||
1497 | 2252 | ||
1498 | \layout Standard | 2253 | \layout Standard |
1499 | 2254 | ||
1500 | blah.foobar.com | 2255 | POlFcUBRH30AAALdBG8 |
1501 | \end_inset | 2256 | \end_inset |
1502 | </cell> | 2257 | </cell> |
1503 | </row> | 2258 | </row> |
@@ -1507,7 +2262,7 @@ blah.foobar.com | |||
1507 | 2262 | ||
1508 | \layout Standard | 2263 | \layout Standard |
1509 | 2264 | ||
1510 | I | 2265 | l |
1511 | \end_inset | 2266 | \end_inset |
1512 | </cell> | 2267 | </cell> |
1513 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | 2268 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> |
@@ -1707,7 +2462,7 @@ varchar(255) | |||
1707 | 2462 | ||
1708 | \layout Standard | 2463 | \layout Standard |
1709 | 2464 | ||
1710 | http://www.biglinkstoyou.com/linkpage.html | 2465 | http://www.biglinks4u.com/linkpage.html |
1711 | \end_inset | 2466 | \end_inset |
1712 | </cell> | 2467 | </cell> |
1713 | </row> | 2468 | </row> |
@@ -2059,11 +2814,12 @@ If you have compiled mod_log_sql with WANT_SSL_LOGGING, you also get these: | |||
2059 | 2814 | ||
2060 | 2815 | ||
2061 | \begin_inset Tabular | 2816 | \begin_inset Tabular |
2062 | <lyxtabular version="2" rows="4" columns="4"> | 2817 | <lyxtabular version="2" rows="4" columns="5"> |
2063 | <features rotate="false" islongtable="false" endhead="0" endfirsthead="0" endfoot="0" endlastfoot="0"> | 2818 | <features rotate="false" islongtable="false" endhead="0" endfirsthead="0" endfoot="0" endlastfoot="0"> |
2064 | <column alignment="center" valignment="top" leftline="true" rightline="false" width="" special=""> | 2819 | <column alignment="center" valignment="top" leftline="true" rightline="false" width="" special=""> |
2065 | <column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> | 2820 | <column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> |
2066 | <column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> | 2821 | <column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> |
2822 | <column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> | ||
2067 | <column alignment="left" valignment="top" leftline="true" rightline="true" width="" special=""> | 2823 | <column alignment="left" valignment="top" leftline="true" rightline="true" width="" special=""> |
2068 | <row topline="true" bottomline="true" newpage="false"> | 2824 | <row topline="true" bottomline="true" newpage="false"> |
2069 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | 2825 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> |
@@ -2073,7 +2829,17 @@ If you have compiled mod_log_sql with WANT_SSL_LOGGING, you also get these: | |||
2073 | 2829 | ||
2074 | 2830 | ||
2075 | \series bold | 2831 | \series bold |
2076 | Character | 2832 | Char |
2833 | \end_inset | ||
2834 | </cell> | ||
2835 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
2836 | \begin_inset Text | ||
2837 | |||
2838 | \layout Standard | ||
2839 | |||
2840 | |||
2841 | \series bold | ||
2842 | What is this? | ||
2077 | \end_inset | 2843 | \end_inset |
2078 | </cell> | 2844 | </cell> |
2079 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | 2845 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> |
@@ -2083,7 +2849,7 @@ Character | |||
2083 | 2849 | ||
2084 | 2850 | ||
2085 | \series bold | 2851 | \series bold |
2086 | MySQL DB field it activates | 2852 | MySQL DB field |
2087 | \end_inset | 2853 | \end_inset |
2088 | </cell> | 2854 | </cell> |
2089 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | 2855 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> |
@@ -2093,7 +2859,7 @@ MySQL DB field it activates | |||
2093 | 2859 | ||
2094 | 2860 | ||
2095 | \series bold | 2861 | \series bold |
2096 | MySQL DB field it activatesRecommended column type | 2862 | Column Type |
2097 | \end_inset | 2863 | \end_inset |
2098 | </cell> | 2864 | </cell> |
2099 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | 2865 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> |
@@ -2121,6 +2887,14 @@ z | |||
2121 | 2887 | ||
2122 | \layout Standard | 2888 | \layout Standard |
2123 | 2889 | ||
2890 | SSL cipher used | ||
2891 | \end_inset | ||
2892 | </cell> | ||
2893 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
2894 | \begin_inset Text | ||
2895 | |||
2896 | \layout Standard | ||
2897 | |||
2124 | ssl_cipher | 2898 | ssl_cipher |
2125 | \end_inset | 2899 | \end_inset |
2126 | </cell> | 2900 | </cell> |
@@ -2155,6 +2929,14 @@ q | |||
2155 | 2929 | ||
2156 | \layout Standard | 2930 | \layout Standard |
2157 | 2931 | ||
2932 | Keysize of the SSL connection | ||
2933 | \end_inset | ||
2934 | </cell> | ||
2935 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
2936 | \begin_inset Text | ||
2937 | |||
2938 | \layout Standard | ||
2939 | |||
2158 | ssl_keysize | 2940 | ssl_keysize |
2159 | \end_inset | 2941 | \end_inset |
2160 | </cell> | 2942 | </cell> |
@@ -2189,6 +2971,14 @@ Q | |||
2189 | 2971 | ||
2190 | \layout Standard | 2972 | \layout Standard |
2191 | 2973 | ||
2974 | Maximum keysize supported | ||
2975 | \end_inset | ||
2976 | </cell> | ||
2977 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
2978 | \begin_inset Text | ||
2979 | |||
2980 | \layout Standard | ||
2981 | |||
2192 | ssl_maxkeysize | 2982 | ssl_maxkeysize |
2193 | \end_inset | 2983 | \end_inset |
2194 | </cell> | 2984 | </cell> |
@@ -2214,6 +3004,210 @@ smallint unsigned | |||
2214 | \end_inset | 3004 | \end_inset |
2215 | 3005 | ||
2216 | 3006 | ||
3007 | \layout Subsubsection | ||
3008 | |||
3009 | LogSQLWhichCookie | ||
3010 | \layout LyX-Code | ||
3011 | |||
3012 | Syntax: LogSQLWhichCookie cookiename | ||
3013 | \layout LyX-Code | ||
3014 | |||
3015 | Example: LogSQLWhichCookie Clicks | ||
3016 | \layout LyX-Code | ||
3017 | |||
3018 | Default: None. | ||
3019 | You must set this if you wish to capture cookies. | ||
3020 | \layout LyX-Code | ||
3021 | |||
3022 | Context: virtual host | ||
3023 | \layout Quote | ||
3024 | |||
3025 | In HTTP, cookies have names to distinguish them from each other. | ||
3026 | Using mod_usertrack, for example, you can give your user-tracking cookies | ||
3027 | a name with the CookieName directive. | ||
3028 | \layout Quote | ||
3029 | |||
3030 | If you have activated cookie logging in LogSQLTransferLogFormat, then LogSQLWhic | ||
3031 | hCookie tells mod_log_sql which cookie to log. | ||
3032 | This is useful because many times you will be setting and receiving more | ||
3033 | than one cookie from a client; without this directive you'd be unable to | ||
3034 | choose which cookie is your mod_usertrack cookie. | ||
3035 | \layout Quote | ||
3036 | |||
3037 | Note: although this was intended for people who are using mod_usertrack | ||
3038 | 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 | ||
3040 | necessarily have to have anything to do with mod_usertrack. | ||
3041 | \layout Subsubsection | ||
3042 | |||
3043 | LogSQLWhichCookies | ||
3044 | \layout LyX-Code | ||
3045 | |||
3046 | Syntax: LogSQLWhichCookies cookie1 cookie2 ... | ||
3047 | cookieN | ||
3048 | \layout LyX-Code | ||
3049 | |||
3050 | Example: LogSQLWhichCookies userlogin foobar foobaz | ||
3051 | \layout LyX-Code | ||
3052 | |||
3053 | Default: None | ||
3054 | \layout LyX-Code | ||
3055 | |||
3056 | Context: virtual host | ||
3057 | \layout Quote | ||
3058 | |||
3059 | Defines the list of cookies you would like logged. | ||
3060 | Works in conjunction with LogSQLCookieLogTable. | ||
3061 | \layout Subsubsection | ||
3062 | |||
3063 | LogSQLWhichHeadersIn | ||
3064 | \layout LyX-Code | ||
3065 | |||
3066 | Syntax: LogSQLWhichHeadersIn item1 item2 ... | ||
3067 | itemN | ||
3068 | \layout LyX-Code | ||
3069 | |||
3070 | Example: LogSQLWhichHeadersIn UserAgent Accept-Encoding Host | ||
3071 | \layout LyX-Code | ||
3072 | |||
3073 | Default: None | ||
3074 | \layout LyX-Code | ||
3075 | |||
3076 | Context: virtual host | ||
3077 | \layout Quote | ||
3078 | |||
3079 | Defines the list of inbound headers you would like logged. | ||
3080 | Works in conjunction with LogSQLHeadersInLogTable. | ||
3081 | \layout Subsubsection | ||
3082 | |||
3083 | LogSQLWhichHeadersOut | ||
3084 | \layout LyX-Code | ||
3085 | |||
3086 | Syntax: LogSQLWhichHeadersOut item1 item2 ... | ||
3087 | itemN | ||
3088 | \layout LyX-Code | ||
3089 | |||
3090 | Example: LogSQLWhichHeadersOut Expires Content-Type Cache-Control | ||
3091 | \layout LyX-Code | ||
3092 | |||
3093 | Default: None | ||
3094 | \layout LyX-Code | ||
3095 | |||
3096 | Context: virtual host | ||
3097 | \layout Quote | ||
3098 | |||
3099 | Defines the list of outbound headers you would like logged. | ||
3100 | Works in conjunction with LogSQLHeadersOutLogTable. | ||
3101 | \layout Subsubsection | ||
3102 | |||
3103 | LogSQLWhichNotes | ||
3104 | \layout LyX-Code | ||
3105 | |||
3106 | Syntax: LogSQLWhichNotes item1 item2 ... | ||
3107 | itemN | ||
3108 | \layout LyX-Code | ||
3109 | |||
3110 | Example: LogSQLWhichNotes mod_gzip_result mod_gzip_compression_ratio | ||
3111 | \layout LyX-Code | ||
3112 | |||
3113 | Default: None | ||
3114 | \layout LyX-Code | ||
3115 | |||
3116 | Context: virtual host | ||
3117 | \layout Quote | ||
3118 | |||
3119 | Defines the list of notes you would like logged. | ||
3120 | Works in conjunction with LogSQLNotesLogTable. | ||
3121 | \layout Subsubsection | ||
3122 | |||
3123 | LogSQLCookieLogTable | ||
3124 | \layout LyX-Code | ||
3125 | |||
3126 | Syntax: LogSQLCookieLogTable table-name | ||
3127 | \layout LyX-Code | ||
3128 | |||
3129 | Example: LogSQLCookieLogTable cookie_log | ||
3130 | \layout LyX-Code | ||
3131 | |||
3132 | Default: cookies | ||
3133 | \layout LyX-Code | ||
3134 | |||
3135 | Context: virtual host | ||
3136 | \layout Quote | ||
3137 | |||
3138 | Defines which table is used for logging of cookies. | ||
3139 | Working in conjunction with LogSQLWhichCookies, you can log many of each | ||
3140 | request's associated cookies to a separate table. | ||
3141 | 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. | ||
3143 | \layout Subsubsection | ||
3144 | |||
3145 | LogSQLHeadersInLogTable | ||
3146 | \layout LyX-Code | ||
3147 | |||
3148 | Syntax: LogSQLHeadersInLogTable table-name | ||
3149 | \layout LyX-Code | ||
3150 | |||
3151 | Example: LogSQLHeadersInLogTable headers | ||
3152 | \layout LyX-Code | ||
3153 | |||
3154 | Default: headers_in | ||
3155 | \layout LyX-Code | ||
3156 | |||
3157 | Context: virtual host | ||
3158 | \layout Quote | ||
3159 | |||
3160 | Defines which table is used for logging of inbound headers. | ||
3161 | Working in conjunction with LogSQLWhichHeadersIn, you can log many of each | ||
3162 | request's associated headers to a separate table. | ||
3163 | 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 | ||
3165 | e_id. | ||
3166 | \layout Subsubsection | ||
3167 | |||
3168 | LogSQLHeadersOutLogTable | ||
3169 | \layout LyX-Code | ||
3170 | |||
3171 | Syntax: LogSQLHeadersOutLogTable table-name | ||
3172 | \layout LyX-Code | ||
3173 | |||
3174 | Example: LogSQLHeadersOutLogTable headers | ||
3175 | \layout LyX-Code | ||
3176 | |||
3177 | Default: headers_out | ||
3178 | \layout LyX-Code | ||
3179 | |||
3180 | Context: virtual host | ||
3181 | \layout Quote | ||
3182 | |||
3183 | Defines which table is used for logging of outbound headers. | ||
3184 | Working in conjunction with LogSQLWhichHeadersOut, you can log many of | ||
3185 | each request's associated headers to a separate table. | ||
3186 | 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 | ||
3188 | e_id. | ||
3189 | \layout Subsubsection | ||
3190 | |||
3191 | LogSQLNotesLogTable | ||
3192 | \layout LyX-Code | ||
3193 | |||
3194 | Syntax: LogSQLNotesLogTable table-name | ||
3195 | \layout LyX-Code | ||
3196 | |||
3197 | Example: LogSQLNotesLogTable notes_log | ||
3198 | \layout LyX-Code | ||
3199 | |||
3200 | Default: notes | ||
3201 | \layout LyX-Code | ||
3202 | |||
3203 | Context: virtual host | ||
3204 | \layout Quote | ||
3205 | |||
3206 | Defines which table is used for logging of notes. | ||
3207 | Working in conjunction with LogSQLWhichNotes, you can log many of each | ||
3208 | request's associated notes to a separate table. | ||
3209 | 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. | ||
2217 | \layout Section | 3211 | \layout Section |
2218 | 3212 | ||
2219 | FAQ | 3213 | FAQ |
@@ -2231,9 +3225,13 @@ To begin with, let's get it out of the way: logging to a database is not | |||
2231 | 3225 | ||
2232 | Chores like log rotation go away, as you can DELETE records from the SQL | 3226 | Chores like log rotation go away, as you can DELETE records from the SQL |
2233 | database once they are no longer useful. | 3227 | database once they are no longer useful. |
2234 | For example, the excellent and popular log-analysis tool Webalizer (http://www.w | 3228 | For example, the excellent and popular log-analysis tool |
2235 | ebalizer.com/) does not need historic logs after it has processed them, enabling | 3229 | \begin_inset LatexCommand \url[Webalizer]{http://www.webalizer.com} |
2236 | you to delete older logs. | 3230 | |
3231 | \end_inset | ||
3232 | |||
3233 | does not need historic logs after it has processed them, enabling you to | ||
3234 | delete older logs. | ||
2237 | 3235 | ||
2238 | \layout Itemize | 3236 | \layout Itemize |
2239 | 3237 | ||
@@ -2255,36 +3253,234 @@ select remote_host,status,request_uri,bytes_sent,from_unixtime(time_stamp) | |||
2255 | from acc_log_tbl where status=404 order by time_stamp; | 3253 | from acc_log_tbl where status=404 order by time_stamp; |
2256 | \layout LyX-Code | 3254 | \layout LyX-Code |
2257 | 3255 | ||
2258 | +-----------------------------------+--------+--------------------------+------- | 3256 | \layout Standard |
2259 | -----+--------------------------- | 3257 | \align center |
2260 | \layout LyX-Code | ||
2261 | 3258 | ||
2262 | + remote_host | status | request_uri | 3259 | \begin_inset Tabular |
2263 | | bytes_sent | from_unixtime(time_stamp)| | 3260 | <lyxtabular version="2" rows="5" columns="5"> |
2264 | \layout LyX-Code | 3261 | <features rotate="false" islongtable="false" endhead="0" endfirsthead="0" endfoot="0" endlastfoot="0"> |
3262 | <column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> | ||
3263 | <column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> | ||
3264 | <column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> | ||
3265 | <column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> | ||
3266 | <column alignment="left" valignment="top" leftline="true" rightline="true" width="" special=""> | ||
3267 | <row topline="true" bottomline="true" newpage="false"> | ||
3268 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3269 | \begin_inset Text | ||
2265 | 3270 | ||
2266 | +-----------------------------------+--------+--------------------------+------- | 3271 | \layout Standard |
2267 | -----+--------------------------- | ||
2268 | \layout LyX-Code | ||
2269 | 3272 | ||
2270 | | marge.mmm.co.uk | 404 | /favicon.ico | 321 | 3273 | remote_host |
2271 | | 2001-11-20 02:30:56 | | 3274 | \end_inset |
2272 | \layout LyX-Code | 3275 | </cell> |
3276 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3277 | \begin_inset Text | ||
2273 | 3278 | ||
2274 | | 62.180.239.251 | 404 | /favicon.ico | 333 | 3279 | \layout Standard |
2275 | | 2001-11-20 02:45:25 | | 3280 | |
2276 | \layout LyX-Code | 3281 | status |
3282 | \end_inset | ||
3283 | </cell> | ||
3284 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3285 | \begin_inset Text | ||
3286 | |||
3287 | \layout Standard | ||
3288 | |||
3289 | request_uri | ||
3290 | \end_inset | ||
3291 | </cell> | ||
3292 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3293 | \begin_inset Text | ||
3294 | |||
3295 | \layout Standard | ||
3296 | |||
3297 | bytes_sent | ||
3298 | \end_inset | ||
3299 | </cell> | ||
3300 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
3301 | \begin_inset Text | ||
3302 | |||
3303 | \layout Standard | ||
3304 | |||
3305 | from_unixtime(time_stamp) | ||
3306 | \end_inset | ||
3307 | </cell> | ||
3308 | </row> | ||
3309 | <row topline="true" bottomline="false" newpage="false"> | ||
3310 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3311 | \begin_inset Text | ||
3312 | |||
3313 | \layout Standard | ||
3314 | |||
3315 | marge.mmm.co.uk | ||
3316 | \end_inset | ||
3317 | </cell> | ||
3318 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3319 | \begin_inset Text | ||
3320 | |||
3321 | \layout Standard | ||
3322 | |||
3323 | 404 | ||
3324 | \end_inset | ||
3325 | </cell> | ||
3326 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3327 | \begin_inset Text | ||
3328 | |||
3329 | \layout Standard | ||
3330 | |||
3331 | /favicon.ico | ||
3332 | \end_inset | ||
3333 | </cell> | ||
3334 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3335 | \begin_inset Text | ||
3336 | |||
3337 | \layout Standard | ||
3338 | |||
3339 | 321 | ||
3340 | \end_inset | ||
3341 | </cell> | ||
3342 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
3343 | \begin_inset Text | ||
3344 | |||
3345 | \layout Standard | ||
3346 | |||
3347 | 2001-11-20 02:30:56 | ||
3348 | \end_inset | ||
3349 | </cell> | ||
3350 | </row> | ||
3351 | <row topline="true" bottomline="false" newpage="false"> | ||
3352 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3353 | \begin_inset Text | ||
3354 | |||
3355 | \layout Standard | ||
3356 | |||
3357 | 62.180.239.251 | ||
3358 | \end_inset | ||
3359 | </cell> | ||
3360 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3361 | \begin_inset Text | ||
3362 | |||
3363 | \layout Standard | ||
3364 | |||
3365 | 404 | ||
3366 | \end_inset | ||
3367 | </cell> | ||
3368 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3369 | \begin_inset Text | ||
3370 | |||
3371 | \layout Standard | ||
3372 | |||
3373 | /favicon.ico | ||
3374 | \end_inset | ||
3375 | </cell> | ||
3376 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3377 | \begin_inset Text | ||
3378 | |||
3379 | \layout Standard | ||
3380 | |||
3381 | 333 | ||
3382 | \end_inset | ||
3383 | </cell> | ||
3384 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
3385 | \begin_inset Text | ||
3386 | |||
3387 | \layout Standard | ||
3388 | |||
3389 | 2001-11-20 02:45:25 | ||
3390 | \end_inset | ||
3391 | </cell> | ||
3392 | </row> | ||
3393 | <row topline="true" bottomline="false" newpage="false"> | ||
3394 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3395 | \begin_inset Text | ||
3396 | |||
3397 | \layout Standard | ||
3398 | |||
3399 | 212.234.12.66 | ||
3400 | \end_inset | ||
3401 | </cell> | ||
3402 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3403 | \begin_inset Text | ||
3404 | |||
3405 | \layout Standard | ||
3406 | |||
3407 | 404 | ||
3408 | \end_inset | ||
3409 | </cell> | ||
3410 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3411 | \begin_inset Text | ||
3412 | |||
3413 | \layout Standard | ||
3414 | |||
3415 | /favicon.ico | ||
3416 | \end_inset | ||
3417 | </cell> | ||
3418 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3419 | \begin_inset Text | ||
3420 | |||
3421 | \layout Standard | ||
3422 | |||
3423 | 321 | ||
3424 | \end_inset | ||
3425 | </cell> | ||
3426 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
3427 | \begin_inset Text | ||
3428 | |||
3429 | \layout Standard | ||
3430 | |||
3431 | 2001-11-20 03:01:00 | ||
3432 | \end_inset | ||
3433 | </cell> | ||
3434 | </row> | ||
3435 | <row topline="true" bottomline="true" newpage="false"> | ||
3436 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3437 | \begin_inset Text | ||
3438 | |||
3439 | \layout Standard | ||
3440 | |||
3441 | 212.210.78.254 | ||
3442 | \end_inset | ||
3443 | </cell> | ||
3444 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3445 | \begin_inset Text | ||
3446 | |||
3447 | \layout Standard | ||
3448 | |||
3449 | 404 | ||
3450 | \end_inset | ||
3451 | </cell> | ||
3452 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3453 | \begin_inset Text | ||
3454 | |||
3455 | \layout Standard | ||
3456 | |||
3457 | /favicon.ico | ||
3458 | \end_inset | ||
3459 | </cell> | ||
3460 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3461 | \begin_inset Text | ||
3462 | |||
3463 | \layout Standard | ||
3464 | |||
3465 | 333 | ||
3466 | \end_inset | ||
3467 | </cell> | ||
3468 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
3469 | \begin_inset Text | ||
3470 | |||
3471 | \layout Standard | ||
3472 | |||
3473 | 2001-11-20 03:26:05 | ||
3474 | \end_inset | ||
3475 | </cell> | ||
3476 | </row> | ||
3477 | </lyxtabular> | ||
3478 | |||
3479 | \end_inset | ||
2277 | 3480 | ||
2278 | | 212.234.12.66 | 404 | /favicon.ico | 321 | ||
2279 | | 2001-11-20 03:01:00 | | ||
2280 | \layout LyX-Code | ||
2281 | 3481 | ||
2282 | | 212.210.78.254 | 404 | /favicon.ico | 333 | ||
2283 | | 2001-11-20 03:26:05 | | ||
2284 | \layout LyX-Code | 3482 | \layout LyX-Code |
2285 | 3483 | ||
2286 | +-----------------------------------+--------+--------------------------+------- | ||
2287 | -----+---------------------------+ | ||
2288 | \layout Standard | 3484 | \layout Standard |
2289 | 3485 | ||
2290 | Or do you want to see how many bytes you've sent within a certain directory | 3486 | Or do you want to see how many bytes you've sent within a certain directory |
@@ -2296,46 +3492,152 @@ select request_uri,sum(bytes_sent) as bytes,count(request_uri) as howmany | |||
2296 | order by howmany desc; | 3492 | order by howmany desc; |
2297 | \layout LyX-Code | 3493 | \layout LyX-Code |
2298 | 3494 | ||
2299 | +-----------------------------------+---------+---------+ | 3495 | \layout Standard |
2300 | \layout LyX-Code | 3496 | \align center |
2301 | 3497 | ||
2302 | | request_uri | bytes | howmany | | 3498 | \begin_inset Tabular |
2303 | \layout LyX-Code | 3499 | <lyxtabular version="2" rows="5" columns="3"> |
3500 | <features rotate="false" islongtable="false" endhead="0" endfirsthead="0" endfoot="0" endlastfoot="0"> | ||
3501 | <column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> | ||
3502 | <column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> | ||
3503 | <column alignment="left" valignment="top" leftline="true" rightline="true" width="" special=""> | ||
3504 | <row topline="true" bottomline="true" newpage="false"> | ||
3505 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3506 | \begin_inset Text | ||
2304 | 3507 | ||
2305 | +-----------------------------------+---------+---------+ | 3508 | \layout Standard |
2306 | \layout LyX-Code | ||
2307 | 3509 | ||
2308 | | /mod_log_sql/style_1.css | 157396 | 1288 | | 3510 | request_uri |
2309 | \layout LyX-Code | 3511 | \end_inset |
3512 | </cell> | ||
3513 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3514 | \begin_inset Text | ||
2310 | 3515 | ||
2311 | | /mod_log_sql/ | 2514337 | 801 | | 3516 | \layout Standard |
2312 | \layout LyX-Code | ||
2313 | 3517 | ||
2314 | | /mod_log_sql/mod_log_sql.tar.gz | 9769312 | 456 | | 3518 | bytes |
2315 | \layout LyX-Code | 3519 | \end_inset |
3520 | </cell> | ||
3521 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
3522 | \begin_inset Text | ||
2316 | 3523 | ||
2317 | | /mod_log_sql/faq.html | 5038728 | 436 | | 3524 | \layout Standard |
2318 | \layout LyX-Code | ||
2319 | 3525 | ||
2320 | | /mod_log_sql/INSTALL | 1196161 | 202 | | 3526 | howmany |
2321 | \layout LyX-Code | 3527 | \end_inset |
3528 | </cell> | ||
3529 | </row> | ||
3530 | <row topline="true" bottomline="false" newpage="false"> | ||
3531 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3532 | \begin_inset Text | ||
2322 | 3533 | ||
2323 | | /mod_log_sql/directives.html | 1096821 | 171 | | 3534 | \layout Standard |
2324 | \layout LyX-Code | ||
2325 | 3535 | ||
2326 | | /mod_log_sql/CHANGELOG | 424481 | 107 | | 3536 | /mod_log_sql/style_1.css |
2327 | \layout LyX-Code | 3537 | \end_inset |
3538 | </cell> | ||
3539 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3540 | \begin_inset Text | ||
2328 | 3541 | ||
2329 | | /mod_log_sql/README | 796072 | 97 | | 3542 | \layout Standard |
2330 | \layout LyX-Code | 3543 | |
3544 | 157396 | ||
3545 | \end_inset | ||
3546 | </cell> | ||
3547 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
3548 | \begin_inset Text | ||
3549 | |||
3550 | \layout Standard | ||
3551 | |||
3552 | 1288 | ||
3553 | \end_inset | ||
3554 | </cell> | ||
3555 | </row> | ||
3556 | <row topline="true" bottomline="false" newpage="false"> | ||
3557 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3558 | \begin_inset Text | ||
3559 | |||
3560 | \layout Standard | ||
3561 | |||
3562 | /mod_log_sql/ | ||
3563 | \end_inset | ||
3564 | </cell> | ||
3565 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3566 | \begin_inset Text | ||
3567 | |||
3568 | \layout Standard | ||
3569 | |||
3570 | 2514337 | ||
3571 | \end_inset | ||
3572 | </cell> | ||
3573 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
3574 | \begin_inset Text | ||
3575 | |||
3576 | \layout Standard | ||
3577 | |||
3578 | 801 | ||
3579 | \end_inset | ||
3580 | </cell> | ||
3581 | </row> | ||
3582 | <row topline="true" bottomline="false" newpage="false"> | ||
3583 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3584 | \begin_inset Text | ||
3585 | |||
3586 | \layout Standard | ||
3587 | |||
3588 | /mod_log_sql/mod_log_sql.tar.gz | ||
3589 | \end_inset | ||
3590 | </cell> | ||
3591 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3592 | \begin_inset Text | ||
3593 | |||
3594 | \layout Standard | ||
3595 | |||
3596 | 9769312 | ||
3597 | \end_inset | ||
3598 | </cell> | ||
3599 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
3600 | \begin_inset Text | ||
3601 | |||
3602 | \layout Standard | ||
3603 | |||
3604 | 456 | ||
3605 | \end_inset | ||
3606 | </cell> | ||
3607 | </row> | ||
3608 | <row topline="true" bottomline="true" newpage="false"> | ||
3609 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3610 | \begin_inset Text | ||
3611 | |||
3612 | \layout Standard | ||
3613 | |||
3614 | /mod_log_sql/faq.html | ||
3615 | \end_inset | ||
3616 | </cell> | ||
3617 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3618 | \begin_inset Text | ||
3619 | |||
3620 | \layout Standard | ||
3621 | |||
3622 | 5038728 | ||
3623 | \end_inset | ||
3624 | </cell> | ||
3625 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
3626 | \begin_inset Text | ||
3627 | |||
3628 | \layout Standard | ||
3629 | |||
3630 | 436 | ||
3631 | \end_inset | ||
3632 | </cell> | ||
3633 | </row> | ||
3634 | </lyxtabular> | ||
3635 | |||
3636 | \end_inset | ||
2331 | 3637 | ||
2332 | | /mod_log_sql/directives-old.html | 42480 | 6 | | ||
2333 | \layout LyX-Code | ||
2334 | 3638 | ||
2335 | | /mod_log_sql/index.html | 9531 | 3 | | ||
2336 | \layout LyX-Code | 3639 | \layout LyX-Code |
2337 | 3640 | ||
2338 | +-----------------------------------+---------+---------+ | ||
2339 | \layout Standard | 3641 | \layout Standard |
2340 | 3642 | ||
2341 | Or maybe you want to see who's linking to you? Do this: | 3643 | Or maybe you want to see who's linking to you? Do this: |
@@ -2345,44 +3647,111 @@ select count(referer) as num,referer from acc_log_tbl where request_uri='/mod_lo | |||
2345 | g_sql/' group by referer order by num desc; | 3647 | g_sql/' group by referer order by num desc; |
2346 | \layout LyX-Code | 3648 | \layout LyX-Code |
2347 | 3649 | ||
2348 | +-----+------------------------------------------------------------------------- | ||
2349 | ------+ | ||
2350 | \layout LyX-Code | 3650 | \layout LyX-Code |
3651 | \align center | ||
2351 | 3652 | ||
2352 | | num | referer | 3653 | \begin_inset Tabular |
2353 | | | 3654 | <lyxtabular version="2" rows="5" columns="2"> |
2354 | \layout LyX-Code | 3655 | <features rotate="false" islongtable="false" endhead="0" endfirsthead="0" endfoot="0" endlastfoot="0"> |
3656 | <column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> | ||
3657 | <column alignment="left" valignment="top" leftline="true" rightline="true" width="" special=""> | ||
3658 | <row topline="true" bottomline="true" newpage="false"> | ||
3659 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3660 | \begin_inset Text | ||
2355 | 3661 | ||
2356 | +-----+------------------------------------------------------------------------- | 3662 | \layout Standard |
2357 | ------+ | ||
2358 | \layout LyX-Code | ||
2359 | 3663 | ||
2360 | | 271 | http://freshmeat.net/projects/mod_log_sql/ | 3664 | num |
2361 | | | 3665 | \end_inset |
2362 | \layout LyX-Code | 3666 | </cell> |
3667 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
3668 | \begin_inset Text | ||
2363 | 3669 | ||
2364 | | 96 | http://modules.apache.org/search?id=339 | 3670 | \layout Standard |
2365 | | | ||
2366 | \layout LyX-Code | ||
2367 | 3671 | ||
2368 | | 48 | http://freshmeat.net/ | 3672 | referer |
2369 | | | 3673 | \end_inset |
2370 | \layout LyX-Code | 3674 | </cell> |
3675 | </row> | ||
3676 | <row topline="true" bottomline="false" newpage="false"> | ||
3677 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3678 | \begin_inset Text | ||
2371 | 3679 | ||
2372 | | 8 | http://freshmeat.net | 3680 | \layout Standard |
2373 | | | 3681 | |
2374 | \layout LyX-Code | 3682 | 271 |
3683 | \end_inset | ||
3684 | </cell> | ||
3685 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
3686 | \begin_inset Text | ||
3687 | |||
3688 | \layout Standard | ||
3689 | |||
3690 | http://freshmeat.net/projects/mod_log_sql/ | ||
3691 | \end_inset | ||
3692 | </cell> | ||
3693 | </row> | ||
3694 | <row topline="true" bottomline="false" newpage="false"> | ||
3695 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3696 | \begin_inset Text | ||
3697 | |||
3698 | \layout Standard | ||
3699 | |||
3700 | 96 | ||
3701 | \end_inset | ||
3702 | </cell> | ||
3703 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
3704 | \begin_inset Text | ||
3705 | |||
3706 | \layout Standard | ||
3707 | |||
3708 | http://modules.apache.org/search?id=339 | ||
3709 | \end_inset | ||
3710 | </cell> | ||
3711 | </row> | ||
3712 | <row topline="true" bottomline="false" newpage="false"> | ||
3713 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3714 | \begin_inset Text | ||
3715 | |||
3716 | \layout Standard | ||
3717 | |||
3718 | 48 | ||
3719 | \end_inset | ||
3720 | </cell> | ||
3721 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
3722 | \begin_inset Text | ||
3723 | |||
3724 | \layout Standard | ||
3725 | |||
3726 | http://freshmeat.net/ | ||
3727 | \end_inset | ||
3728 | </cell> | ||
3729 | </row> | ||
3730 | <row topline="true" bottomline="true" newpage="false"> | ||
3731 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
3732 | \begin_inset Text | ||
3733 | |||
3734 | \layout Standard | ||
3735 | |||
3736 | 8 | ||
3737 | \end_inset | ||
3738 | </cell> | ||
3739 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
3740 | \begin_inset Text | ||
3741 | |||
3742 | \layout Standard | ||
3743 | |||
3744 | http://freshmeat.net | ||
3745 | \end_inset | ||
3746 | </cell> | ||
3747 | </row> | ||
3748 | </lyxtabular> | ||
3749 | |||
3750 | \end_inset | ||
2375 | 3751 | ||
2376 | | 7 | http://freshmeat.net/daily/2001/11/30/ | ||
2377 | | | ||
2378 | \layout LyX-Code | ||
2379 | 3752 | ||
2380 | | 6 | http://freshmeat.net/daily/2001/11/20/ | ||
2381 | | | ||
2382 | \layout LyX-Code | 3753 | \layout LyX-Code |
2383 | 3754 | ||
2384 | +-----+------------------------------------------------------------------------- | ||
2385 | ------+ | ||
2386 | \layout Standard | 3755 | \layout Standard |
2387 | 3756 | ||
2388 | As you can see, there are myriad possibilities that can be constructed with | 3757 | As you can see, there are myriad possibilities that can be constructed with |
@@ -2444,12 +3813,9 @@ Machine B: MySQL server | |||
2444 | \layout Itemize | 3813 | \layout Itemize |
2445 | 3814 | ||
2446 | Machines A and B connected with 100Mbps Ethernet | 3815 | Machines A and B connected with 100Mbps Ethernet |
2447 | \layout Standard | ||
2448 | |||
2449 | Webserver configuration: | ||
2450 | \layout Itemize | 3816 | \layout Itemize |
2451 | 3817 | ||
2452 | Celeron 400 128 MB RAM IDE storage | 3818 | Webserver: Celeron 400, 128 MB RAM, IDE storage |
2453 | \layout Standard | 3819 | \layout Standard |
2454 | 3820 | ||
2455 | Apache configuration: | 3821 | Apache configuration: |
@@ -2515,23 +3881,31 @@ Average of five runs employing MySQL | |||
2515 | \emph on | 3881 | \emph on |
2516 | and | 3882 | and |
2517 | \emph default | 3883 | \emph default |
2518 | standard text logging: 139.01 requests per second, zero errors. | 3884 | standard text logging: |
3885 | \series bold | ||
3886 | 139.01 requests per second, zero errors | ||
3887 | \series default | ||
3888 | . | ||
2519 | \layout Itemize | 3889 | \layout Itemize |
2520 | 3890 | ||
2521 | Average of five runs employing | 3891 | Average of five runs employing |
2522 | \emph on | 3892 | \emph on |
2523 | only | 3893 | only |
2524 | \emph default | 3894 | \emph default |
2525 | standard text logging: 139.96 requests per second, zero errors. | 3895 | standard text logging: |
3896 | \series bold | ||
3897 | 139.96 requests per second, zero errors | ||
3898 | \series default | ||
3899 | . | ||
2526 | \layout Standard | 3900 | \layout Standard |
2527 | 3901 | ||
2528 | In other words, any rate-limiting effects on this particular hardware setup | 3902 | In other words, any rate-limiting effects on this particular hardware setup |
2529 | are not caused by MySQL. | 3903 | are not caused by MySQL. |
2530 | Note that although this very simple webserver setup is hardly cutting-edge | 3904 | Note that although this very simple webserver setup is hardly cutting-edge |
2531 | -- it is, after all, a fairly small machine -- 139 requests per second | 3905 | -- it is, after all, a fairly small machine -- 139 requests per second |
2532 | equal over twelve million hits per day | 3906 | equal over |
2533 | \emph on | 3907 | \emph on |
2534 | . | 3908 | twelve million hits per day. |
2535 | \layout Standard | 3909 | \layout Standard |
2536 | 3910 | ||
2537 | If you run this benchmark yourself, take note of three things: | 3911 | If you run this benchmark yourself, take note of three things: |
@@ -2586,7 +3960,7 @@ mod_log_sql would be virtually useless if there weren't a way for you to | |||
2586 | 3960 | ||
2587 | For example, let's say that you want your web statistics updated once per | 3961 | For example, let's say that you want your web statistics updated once per |
2588 | day in the wee hours of the morning. | 3962 | day in the wee hours of the morning. |
2589 | A good way to accomplish that would be the following entries in /etc/crontab: | 3963 | A good way to accomplish that could be the following entries in /etc/crontab: |
2590 | \layout LyX-Code | 3964 | \layout LyX-Code |
2591 | 3965 | ||
2592 | # Generate the temporary apache logs from the MySQL database (for webalizer) | 3966 | # Generate the temporary apache logs from the MySQL database (for webalizer) |
@@ -2606,14 +3980,14 @@ httpd/mysql-grubbybaby | |||
2606 | 3980 | ||
2607 | Or if you have a newer system that puts files in /etc/cron.daily etc., create | 3981 | Or if you have a newer system that puts files in /etc/cron.daily etc., create |
2608 | a file called | 3982 | a file called |
2609 | \begin_inset Quotes sld | 3983 | \begin_inset Quotes eld |
2610 | \end_inset | 3984 | \end_inset |
2611 | 3985 | ||
2612 | webalizer | 3986 | webalizer |
2613 | \begin_inset Quotes srd | 3987 | \begin_inset Quotes srd |
2614 | \end_inset | 3988 | \end_inset |
2615 | 3989 | ||
2616 | in the cron.____ subdir of your choice. | 3990 | in the cron.daily subdirectory. |
2617 | Use the following as the contents of your file, and make sure to chmod | 3991 | Use the following as the contents of your file, and make sure to chmod |
2618 | 755 it when done. | 3992 | 755 it when done. |
2619 | \layout LyX-Code | 3993 | \layout LyX-Code |
@@ -2740,59 +4114,136 @@ Perform some hits on your server and run a select: | |||
2740 | mysql> select request_uri,cookie from access_log where cookie is not null; | 4114 | mysql> select request_uri,cookie from access_log where cookie is not null; |
2741 | \layout LyX-Code | 4115 | \layout LyX-Code |
2742 | 4116 | ||
2743 | +--------------------------------------------+---------------------------------- | ||
2744 | ------------------+ | ||
2745 | \layout LyX-Code | 4117 | \layout LyX-Code |
4118 | \align center | ||
2746 | 4119 | ||
2747 | | request_uri | | 4120 | \begin_inset Tabular |
2748 | cookie | | 4121 | <lyxtabular version="2" rows="4" columns="2"> |
2749 | \layout LyX-Code | 4122 | <features rotate="false" islongtable="false" endhead="0" endfirsthead="0" endfoot="0" endlastfoot="0"> |
4123 | <column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> | ||
4124 | <column alignment="left" valignment="top" leftline="true" rightline="true" width="" special=""> | ||
4125 | <row topline="true" bottomline="true" newpage="false"> | ||
4126 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
4127 | \begin_inset Text | ||
2750 | 4128 | ||
2751 | +--------------------------------------------+---------------------------------- | 4129 | \layout Standard |
2752 | ------------------+ | ||
2753 | \layout LyX-Code | ||
2754 | 4130 | ||
2755 | | /mod_log_sql/ | ool-18e4.dyn.optonline.net.1300510071 | 4131 | request_uri |
2756 | 02700823 | | 4132 | \end_inset |
2757 | \layout LyX-Code | 4133 | </cell> |
4134 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
4135 | \begin_inset Text | ||
4136 | |||
4137 | \layout Standard | ||
4138 | |||
4139 | cookie | ||
4140 | \end_inset | ||
4141 | </cell> | ||
4142 | </row> | ||
4143 | <row topline="true" bottomline="false" newpage="false"> | ||
4144 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
4145 | \begin_inset Text | ||
4146 | |||
4147 | \layout Standard | ||
4148 | |||
4149 | /mod_log_sql/ | ||
4150 | \end_inset | ||
4151 | </cell> | ||
4152 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
4153 | \begin_inset Text | ||
4154 | |||
4155 | \layout Standard | ||
4156 | |||
4157 | ool-18e4.dyn.optonline.net.130051007102700823 | ||
4158 | \end_inset | ||
4159 | </cell> | ||
4160 | </row> | ||
4161 | <row topline="true" bottomline="false" newpage="false"> | ||
4162 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
4163 | \begin_inset Text | ||
4164 | |||
4165 | \layout Standard | ||
4166 | |||
4167 | /mod_log_sql/usa.gif | ||
4168 | \end_inset | ||
4169 | </cell> | ||
4170 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
4171 | \begin_inset Text | ||
4172 | |||
4173 | \layout Standard | ||
4174 | |||
4175 | ool-18e4.dyn.optonline.net.130051007102700823 | ||
4176 | \end_inset | ||
4177 | </cell> | ||
4178 | </row> | ||
4179 | <row topline="true" bottomline="true" newpage="false"> | ||
4180 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
4181 | \begin_inset Text | ||
4182 | |||
4183 | \layout Standard | ||
4184 | |||
4185 | /mod_log_sql/style_1.css | ||
4186 | \end_inset | ||
4187 | </cell> | ||
4188 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
4189 | \begin_inset Text | ||
4190 | |||
4191 | \layout Standard | ||
4192 | |||
4193 | ool-18e4.dyn.optonline.net.130051007102700823 | ||
4194 | \end_inset | ||
4195 | </cell> | ||
4196 | </row> | ||
4197 | </lyxtabular> | ||
4198 | |||
4199 | \end_inset | ||
2758 | 4200 | ||
2759 | | /mod_log_sql/usa.gif | ool-18e4.dyn.optonline.net.13005100710 | ||
2760 | 2700823 | | ||
2761 | \layout LyX-Code | ||
2762 | 4201 | ||
2763 | | /mod_log_sql/style_1.css | ool-18e4.dyn.optonline.net.13005100710 | ||
2764 | 2700823 | | ||
2765 | \layout LyX-Code | 4202 | \layout LyX-Code |
2766 | 4203 | ||
2767 | ...etc... | ||
2768 | \layout Subsection | 4204 | \layout Subsection |
2769 | 4205 | ||
2770 | What if I want to log more than one cookie? | 4206 | What if I want to log more than one cookie? What is the difference between |
4207 | LogSQLWhichCookie and LogSQLWhichCookies? | ||
2771 | \layout Standard | 4208 | \layout Standard |
2772 | 4209 | ||
2773 | No problem. | 4210 | As of version 1.17, you have a choice in how you want cookie logging handled. |
2774 | As of version 1.17, you have a choice. | 4211 | \layout Standard |
2775 | If you are just interested in a single cookie, follow the instructions | 4212 | |
2776 | in section | 4213 | If you are interested in logging only one cookie per request, follow the |
4214 | instructions in section | ||
2777 | \begin_inset LatexCommand \ref{sec:cookie} | 4215 | \begin_inset LatexCommand \ref{sec:cookie} |
2778 | 4216 | ||
2779 | \end_inset | 4217 | \end_inset |
2780 | 4218 | ||
2781 | above. | 4219 | above. |
2782 | That cookie will be logged to a column in the regular access_log table. | 4220 | That cookie will be logged to a column in the regular access_log table, |
4221 | and the actual cookie you want to log is specified with LogSQLWhichCookie. | ||
4222 | Don't forget to specify the 'c' character in LogSQLTransferLogFormat. | ||
2783 | \layout Standard | 4223 | \layout Standard |
2784 | 4224 | ||
2785 | However, if you need to log multiple cookies, you'll employ the LogSQLWhichCooki | 4225 | If, however, you need to log multiple cookies per request, you must employ |
2786 | es (note the plural) directive. | 4226 | the LogSQLWhichCookies (note the plural) directive. |
2787 | The cookies you specify will be logged to a separate table, and entries | 4227 | The cookies you specify will be logged to a separate table (as discussed |
2788 | in that table will be linked to the regular access_log entries via the | 4228 | in section |
2789 | unique ID that is supplied by mod_unique_id. | 4229 | \begin_inset LatexCommand \ref{secMulTable} |
4230 | |||
4231 | \end_inset | ||
4232 | |||
4233 | ), and entries in that table will be linked to the regular access_log entries | ||
4234 | via the unique ID that is supplied by mod_unique_id. | ||
2790 | Without mod_unique_id the information will still be logged but you will | 4235 | Without mod_unique_id the information will still be logged but you will |
2791 | be unable to correlate which cookies go with which access-requests. | 4236 | be unable to correlate which cookies go with which access-requests. |
4237 | Furthermore, with LogSQLWhichCookies, you do | ||
4238 | \series bold | ||
4239 | not | ||
4240 | \series default | ||
4241 | need to include the 'c' character in LogSQLTransferLogFormat. | ||
2792 | \layout Standard | 4242 | \layout Standard |
2793 | 4243 | ||
2794 | LogSQLWhichCookie and LogSQLWhichCookies can coexist without conflict, but | 4244 | LogSQLWhichCookie and LogSQLWhichCookies can coexist without conflict because |
2795 | you're better off choosing the one you need. | 4245 | they operate on entireley different tables, but you're better off choosing |
4246 | the one you need. | ||
2796 | \layout Subsection | 4247 | \layout Subsection |
2797 | 4248 | ||
2798 | What are the SSL logging features, and how do I activate them? | 4249 | What are the SSL logging features, and how do I activate them? |
@@ -2814,8 +4265,8 @@ You can compile mod_log_sql with SSL logging support if you have the right | |||
2814 | \layout Standard | 4265 | \layout Standard |
2815 | 4266 | ||
2816 | You need to ensure that your database is set up to log the SSL data. | 4267 | You need to ensure that your database is set up to log the SSL data. |
2817 | Issue the following commands to MySQL once you have your basic access_log | 4268 | Issue the following commands to MySQL if your access table does not already |
2818 | table built: | 4269 | have them: |
2819 | \layout LyX-Code | 4270 | \layout LyX-Code |
2820 | 4271 | ||
2821 | alter table access_log add column ssl_cipher varchar(25); | 4272 | alter table access_log add column ssl_cipher varchar(25); |
@@ -2834,7 +4285,11 @@ Finally configure httpd.conf to activate the SSL fields. | |||
2834 | <VirtualHost 1.2.3.4:443> | 4285 | <VirtualHost 1.2.3.4:443> |
2835 | \layout LyX-Code | 4286 | \layout LyX-Code |
2836 | 4287 | ||
2837 | LogSQLTransferLogFormat AbHhmRSsTUuvcQqz | 4288 | LogSQLTransferLogFormat AbHhmRSsTUuvc |
4289 | \series bold | ||
4290 | Qqz | ||
4291 | \series default | ||
4292 | |||
2838 | \layout LyX-Code | 4293 | \layout LyX-Code |
2839 | 4294 | ||
2840 | </VirtualHost> | 4295 | </VirtualHost> |
@@ -2851,37 +4306,198 @@ mysql> select remote_host,request_uri,ssl_cipher,ssl_keysize,ssl_maxkeysize | |||
2851 | from access_log where ssl_cipher is not null; | 4306 | from access_log where ssl_cipher is not null; |
2852 | \layout LyX-Code | 4307 | \layout LyX-Code |
2853 | 4308 | ||
2854 | +--------------------------+---------------------------------------------------- | ||
2855 | +------------+-------------+----------------+ | ||
2856 | \layout LyX-Code | 4309 | \layout LyX-Code |
4310 | \align center | ||
2857 | 4311 | ||
2858 | | remote_host | request_uri | 4312 | \begin_inset Tabular |
2859 | | ssl_cipher | ssl_keysize | ssl_maxkeysize | | 4313 | <lyxtabular version="2" rows="4" columns="5"> |
2860 | \layout LyX-Code | 4314 | <features rotate="false" islongtable="false" endhead="0" endfirsthead="0" endfoot="0" endlastfoot="0"> |
4315 | <column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> | ||
4316 | <column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> | ||
4317 | <column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> | ||
4318 | <column alignment="left" valignment="top" leftline="true" rightline="false" width="" special=""> | ||
4319 | <column alignment="left" valignment="top" leftline="true" rightline="true" width="" special=""> | ||
4320 | <row topline="true" bottomline="true" newpage="false"> | ||
4321 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
4322 | \begin_inset Text | ||
2861 | 4323 | ||
2862 | +--------------------------+---------------------------------------------------- | 4324 | \layout Standard |
2863 | +------------+-------------+----------------+ | ||
2864 | \layout LyX-Code | ||
2865 | 4325 | ||
2866 | | 216.190.52.4 | /dir/somefile.html | 4326 | remote_host |
2867 | | RC4-MD5 | 128 | 128 | | 4327 | \end_inset |
2868 | \layout LyX-Code | 4328 | </cell> |
4329 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
4330 | \begin_inset Text | ||
4331 | |||
4332 | \layout Standard | ||
4333 | |||
4334 | request_uri | ||
4335 | \end_inset | ||
4336 | </cell> | ||
4337 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
4338 | \begin_inset Text | ||
4339 | |||
4340 | \layout Standard | ||
4341 | |||
4342 | ssl_cipher | ||
4343 | \end_inset | ||
4344 | </cell> | ||
4345 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
4346 | \begin_inset Text | ||
4347 | |||
4348 | \layout Standard | ||
4349 | |||
4350 | ssl_keysize | ||
4351 | \end_inset | ||
4352 | </cell> | ||
4353 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
4354 | \begin_inset Text | ||
4355 | |||
4356 | \layout Standard | ||
4357 | |||
4358 | ssl_maxkeysize | ||
4359 | \end_inset | ||
4360 | </cell> | ||
4361 | </row> | ||
4362 | <row topline="true" bottomline="false" newpage="false"> | ||
4363 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
4364 | \begin_inset Text | ||
4365 | |||
4366 | \layout Standard | ||
4367 | |||
4368 | 216.190.52.4 | ||
4369 | \end_inset | ||
4370 | </cell> | ||
4371 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
4372 | \begin_inset Text | ||
4373 | |||
4374 | \layout Standard | ||
4375 | |||
4376 | /dir/somefile.html | ||
4377 | \end_inset | ||
4378 | </cell> | ||
4379 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
4380 | \begin_inset Text | ||
4381 | |||
4382 | \layout Standard | ||
4383 | |||
4384 | RC4-MD5 | ||
4385 | \end_inset | ||
4386 | </cell> | ||
4387 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
4388 | \begin_inset Text | ||
4389 | |||
4390 | \layout Standard | ||
4391 | |||
4392 | 128 | ||
4393 | \end_inset | ||
4394 | </cell> | ||
4395 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
4396 | \begin_inset Text | ||
4397 | |||
4398 | \layout Standard | ||
4399 | |||
4400 | 128 | ||
4401 | \end_inset | ||
4402 | </cell> | ||
4403 | </row> | ||
4404 | <row topline="true" bottomline="false" newpage="false"> | ||
4405 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
4406 | \begin_inset Text | ||
4407 | |||
4408 | \layout Standard | ||
4409 | |||
4410 | 216.190.52.4 | ||
4411 | \end_inset | ||
4412 | </cell> | ||
4413 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
4414 | \begin_inset Text | ||
4415 | |||
4416 | \layout Standard | ||
4417 | |||
4418 | /dir/somefile.gif | ||
4419 | \end_inset | ||
4420 | </cell> | ||
4421 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
4422 | \begin_inset Text | ||
4423 | |||
4424 | \layout Standard | ||
4425 | |||
4426 | RC4-MD5 | ||
4427 | \end_inset | ||
4428 | </cell> | ||
4429 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
4430 | \begin_inset Text | ||
4431 | |||
4432 | \layout Standard | ||
4433 | |||
4434 | 128 | ||
4435 | \end_inset | ||
4436 | </cell> | ||
4437 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
4438 | \begin_inset Text | ||
4439 | |||
4440 | \layout Standard | ||
4441 | |||
4442 | 128 | ||
4443 | \end_inset | ||
4444 | </cell> | ||
4445 | </row> | ||
4446 | <row topline="true" bottomline="true" newpage="false"> | ||
4447 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
4448 | \begin_inset Text | ||
4449 | |||
4450 | \layout Standard | ||
4451 | |||
4452 | 216.190.52.4 | ||
4453 | \end_inset | ||
4454 | </cell> | ||
4455 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
4456 | \begin_inset Text | ||
4457 | |||
4458 | \layout Standard | ||
4459 | |||
4460 | /dir/somefile.jpg | ||
4461 | \end_inset | ||
4462 | </cell> | ||
4463 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
4464 | \begin_inset Text | ||
4465 | |||
4466 | \layout Standard | ||
4467 | |||
4468 | RC4-MD5 | ||
4469 | \end_inset | ||
4470 | </cell> | ||
4471 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="false" rotate="false" usebox="none" width="" special=""> | ||
4472 | \begin_inset Text | ||
4473 | |||
4474 | \layout Standard | ||
4475 | |||
4476 | 128 | ||
4477 | \end_inset | ||
4478 | </cell> | ||
4479 | <cell multicolumn="0" alignment="center" valignment="top" topline="true" bottomline="false" leftline="true" rightline="true" rotate="false" usebox="none" width="" special=""> | ||
4480 | \begin_inset Text | ||
4481 | |||
4482 | \layout Standard | ||
4483 | |||
4484 | 128 | ||
4485 | \end_inset | ||
4486 | </cell> | ||
4487 | </row> | ||
4488 | </lyxtabular> | ||
4489 | |||
4490 | \end_inset | ||
2869 | 4491 | ||
2870 | | 216.190.52.4 | /dir/somefile.gif | ||
2871 | | RC4-MD5 | 128 | 128 | | ||
2872 | \layout LyX-Code | ||
2873 | 4492 | ||
2874 | | 216.190.52.4 | /dir/somefile.jpg | ||
2875 | | RC4-MD5 | 128 | 128 | | ||
2876 | \layout LyX-Code | 4493 | \layout LyX-Code |
2877 | 4494 | ||
2878 | ...etc... | ||
2879 | \layout Subsection | 4495 | \layout Subsection |
2880 | 4496 | ||
2881 | Does mod_log_sql connect to MySQL via TCP/IP or a socket? | 4497 | Does mod_log_sql connect to MySQL via TCP/IP or a socket? |
2882 | \layout Standard | 4498 | \layout Standard |
2883 | 4499 | ||
2884 | It depends! Actually this isn't determined by mod_log_sql. | 4500 | It depends! This actually is not determined by mod_log_sql. |
2885 | mod_log_sql relies on a connection command that is supplied in the MySQL | 4501 | mod_log_sql relies on a connection command that is supplied in the MySQL |
2886 | API, and that command is somewhat intelligent. | 4502 | API, and that command is somewhat intelligent. |
2887 | When mod_log_sql issues the connect command to MySQL, this intelligent | 4503 | When mod_log_sql issues the connect command to MySQL, this intelligent |
diff --git a/Documentation/documentation.tex b/Documentation/documentation.tex deleted file mode 100644 index 0eb6359..0000000 --- a/Documentation/documentation.tex +++ /dev/null | |||
@@ -1,1534 +0,0 @@ | |||
1 | %% LyX 1.1 created this file. For more info, see http://www.lyx.org/. | ||
2 | %% Do not edit unless you really know what you are doing. | ||
3 | \documentclass[10pt,english]{article} | ||
4 | \usepackage[T1]{fontenc} | ||
5 | \usepackage{geometry} | ||
6 | \geometry{verbose,letterpaper,tmargin=0.5in,bmargin=1in,lmargin=1in,rmargin=1in} | ||
7 | \usepackage{babel} | ||
8 | \IfFileExists{url.sty}{\usepackage{url}} | ||
9 | {\newcommand{\url}{\texttt}} | ||
10 | |||
11 | \makeatletter | ||
12 | |||
13 | %%%%%%%%%%%%%%%%%%%%%%%%%%%%%% LyX specific LaTeX commands. | ||
14 | \providecommand{\LyX}{L\kern-.1667em\lower.25em\hbox{Y}\kern-.125emX\@} | ||
15 | |||
16 | %%%%%%%%%%%%%%%%%%%%%%%%%%%%%% Textclass specific LaTeX commands. | ||
17 | \newenvironment{lyxcode} | ||
18 | {\begin{list}{}{ | ||
19 | \setlength{\rightmargin}{\leftmargin} | ||
20 | \raggedright | ||
21 | \setlength{\itemsep}{0pt} | ||
22 | \setlength{\parsep}{0pt} | ||
23 | \normalfont\ttfamily}% | ||
24 | \item[]} | ||
25 | {\end{list}} | ||
26 | |||
27 | \makeatother | ||
28 | \begin{document} | ||
29 | |||
30 | \vfill{} | ||
31 | \title{Installing and Running mod\_log\_sql} | ||
32 | \vfill{} | ||
33 | |||
34 | |||
35 | \author{Christopher Powell } | ||
36 | |||
37 | |||
38 | \date{11/13/02} | ||
39 | |||
40 | \maketitle | ||
41 | \tableofcontents{} | ||
42 | \newpage | ||
43 | |||
44 | |||
45 | \section{Introduction} | ||
46 | |||
47 | |||
48 | \subsection{Homepage } | ||
49 | |||
50 | \begin{lyxcode} | ||
51 | http://www.grubbybaby.com/mod\_log\_sql/ | ||
52 | \end{lyxcode} | ||
53 | |||
54 | \subsection{Summary} | ||
55 | |||
56 | This Apache module will permit you to log Apache accesses (and a lot | ||
57 | of related information) to a SQL database. Unlike logging to a flat | ||
58 | text file (which is standard in Apache), there are a lot of powerful | ||
59 | advantages to logging to SQL. This module can either replace or happily | ||
60 | coexist with Apache's text file logging facility. | ||
61 | |||
62 | |||
63 | \subsection{Approach} | ||
64 | |||
65 | This project was formerly known as mod\_log\_mysql. It has been renamed | ||
66 | to mod\_log\_sql in order to reflect the project goal of database-inspecificity. | ||
67 | The module currently supports MySQL, and development for other database | ||
68 | backends is underway. | ||
69 | |||
70 | In order to save speed and overhead, links are kept alive in between | ||
71 | queries. This module uses one SQL link per httpd child. Among other | ||
72 | things, this means that this module supports logging into only one | ||
73 | MySQL server, and for now, also, only one SQL database. But that's | ||
74 | a small tradeoff compared to the blinding speed of this module. | ||
75 | |||
76 | Virtual hosts are supported in the same manner they are in the regular | ||
77 | logging modules. You define some basic 'global' directives in the | ||
78 | main server config, then you define more specific 'local' directives | ||
79 | inside each virtualhost stanza. | ||
80 | |||
81 | SQL links are opened by each child process when it is born. Error | ||
82 | reporting is robust throughout and will let you know about database | ||
83 | issues in the standard Apache error-log for the server or virtual | ||
84 | server. | ||
85 | |||
86 | A robust \char`\"{}preserve\char`\"{} capability has now been implemented. | ||
87 | This permits the module to preserve any failed INSERT commands to | ||
88 | a local file on its machine. In any situation that the database is | ||
89 | unavailable -- e.g. the network fails, you reboot the db host, etc. | ||
90 | -- mod\_log\_sql will note this in the error log and begin appending | ||
91 | its log entries to the preserve file (which is created with the user | ||
92 | \& group ID of the running Apache process, e.g. \char`\"{}nobody\char`\"{} | ||
93 | on many Linux installations). When your database becomes available | ||
94 | again, mod\_log\_sql seamlessly resumes logging to it. When convenient | ||
95 | for the sysadmin, he/she can easily import the preserve file into | ||
96 | the database because it is simply a series of SQL insert statements: | ||
97 | |||
98 | \begin{lyxcode} | ||
99 | \#~mysql~-uadminuser~-p~mydbname~<~/tmp/mysql-preserve | ||
100 | \end{lyxcode} | ||
101 | |||
102 | \subsection{Supported directives} | ||
103 | |||
104 | Please see the web-based documentation for full explanation of all | ||
105 | supported run-time directives. | ||
106 | |||
107 | http://www.grubbybaby.com/mod\_log\_sql/directives.html | ||
108 | |||
109 | See the FAQ for some handy examples: | ||
110 | |||
111 | http://www.grubbybaby.com/mod\_log\_sql/faq.html | ||
112 | |||
113 | |||
114 | \subsection{What gets logged by default? } | ||
115 | |||
116 | All the data that would be contained in the \char`\"{}Combined Log | ||
117 | Format\char`\"{} is logged by default, plus a little extra. Your best | ||
118 | bet is to begin by accepting this default, then later customize the | ||
119 | log configuration based on your needs. | ||
120 | |||
121 | The online documentation of the run-time directives includes a full | ||
122 | explanation of what you can log, including examples. | ||
123 | |||
124 | |||
125 | \subsection{Minor Notes} | ||
126 | |||
127 | \begin{itemize} | ||
128 | \item Note which directives go in the 'main server config' and which directives | ||
129 | apply to the 'virtual host config'. This is made clear in the directive | ||
130 | documentation. | ||
131 | \item The 'time\_stamp' field is stored in an UNSIGNED INTEGER column, in | ||
132 | the standard unix \char`\"{}seconds since 1/1/1970 12:00:00\char`\"{} | ||
133 | format. This is superior to storing the access time as a string due | ||
134 | to size requirements: an UNSIGNED INT type fits in 4 bytes, whereas | ||
135 | the Apache date string (e.g. \char`\"{}18/Nov/2001:13:59:52 -0800\char`\"{}) | ||
136 | requires 26 bytes -- significantly larger, and those extra 22 bytes | ||
137 | will add up over the thousands of accesses that a busy server will | ||
138 | experience. Besides, an INT type is far more flexible for comparisons, | ||
139 | etc. | ||
140 | |||
141 | |||
142 | In MySQL 3.21 and above you can easily convert this to a human readable | ||
143 | format using from\_unixtime(), e.g.: | ||
144 | |||
145 | \begin{lyxcode} | ||
146 | select~remote\_host,request\_uri,from\_unixtime(time\_stamp)~from~access\_log; | ||
147 | \end{lyxcode} | ||
148 | The enclosed perl program ''make\_combined\_log.pl'' shows how you | ||
149 | can extract your access records in a format that is completely Combined | ||
150 | Log Format compliant. You can then feed this to your favorite web | ||
151 | log analysis tool. | ||
152 | |||
153 | \item The table's string values can be CHAR or VARCHAR, at a length of your | ||
154 | choice. VARCHAR is superior because it truncates long strings; CHAR | ||
155 | types are fixed-length and will be padded with spaces. Just like the | ||
156 | time\_stamp described above, that kind of space waste will add up | ||
157 | over thousands of records. | ||
158 | \item Be careful not to go overboard setting fields to NOT NULL. If a field | ||
159 | is marked NOT NULL then it must contain data in the INSERT or the | ||
160 | INSERT will fail, sometimes in a really mysterious way to the frustrated | ||
161 | sysad. | ||
162 | \item Apache normally logs numeric fields with a '-' character to mean \char`\"{}not | ||
163 | applicable,\char`\"{} e.g. bytes\_sent on a request with a 304 response | ||
164 | code. Since '-' is an illegal character in an SQL numeric field, such | ||
165 | fields are assigned the value 0 instead of '-' which, of course, makes | ||
166 | perfect sense anyway. | ||
167 | \end{itemize} | ||
168 | |||
169 | \subsection{Author / Maintainer} | ||
170 | |||
171 | The actual logging code was taken from the already existing flat file | ||
172 | text modules, so all that credit goes to the Apache Server group. | ||
173 | |||
174 | The MySQL routines and directives were added by Zeev Suraski <bourbon@netvision.net.il>. | ||
175 | |||
176 | All changes from 1.06+ and the new documentation were added by Chris | ||
177 | Powell <chris@grubbybaby.com>. It seems that the module had fallen | ||
178 | into the \char`\"{}unmaintained\char`\"{} category -- it hadn't been | ||
179 | updated since 1998 -- so Chris adopted it as the new maintainer. | ||
180 | |||
181 | |||
182 | \section{Installation} | ||
183 | |||
184 | |||
185 | \subsection{Requirements} | ||
186 | |||
187 | \begin{itemize} | ||
188 | \item A compatible system. I have run mod\_log\_sql on Red Hat based systems | ||
189 | (Red Hat, Mandrake). These instructions should easily adapt to any | ||
190 | modern distro. | ||
191 | \item Apache 1.2 or 1.3 installed. (I run 1.3.22 and it works fine). You | ||
192 | should have already successfully compiled Apache and know what you're | ||
193 | doing there. | ||
194 | \item The MySQL development headers. This is called different things on | ||
195 | different distros. For example, Red Hat 6.x called this RPM \char`\"{}MySQL-devel\char`\"{} | ||
196 | whereas Mandrake calls it \char`\"{}libmysql10-devel\char`\"{}. | ||
197 | \item MySQL >= 3.23.15 configured, installed and running on either localhost | ||
198 | or an accessible networked machine. You should already have a basic | ||
199 | understanding of MySQL and how it functions. | ||
200 | \item Again, basic administrative skills with Apache and MySQL. I try to | ||
201 | make things as easy as possible in this file, but its purpose is not | ||
202 | to be an administrative tutorial. | ||
203 | \item Additionally, if you want to be able to log SSL information such as | ||
204 | keysize or cipher, you need OpenSSL and glibc-devel installed. Both | ||
205 | are available as RPMs. | ||
206 | \end{itemize} | ||
207 | |||
208 | \subsection{Do I want a DSO?} | ||
209 | |||
210 | You need to know the answer to this question before you proceed. The | ||
211 | answer is pretty straightforward: what have you done in the past? | ||
212 | If you like all your Apache modules to be dynamic, then you should | ||
213 | keep doing that. If you're more of an old-school type and prefer to | ||
214 | compile the modules right into apache, do that. Both methods work | ||
215 | equally well. | ||
216 | |||
217 | FWIW, the DSO method is more modern and increasing in popularity because | ||
218 | apxs takes care of a lot of dirty little details for you. As you'll | ||
219 | see below, the static-module method is a little more complex. | ||
220 | |||
221 | |||
222 | \subsection{Installation as an Apache DSO (Preferred) } | ||
223 | |||
224 | \begin{enumerate} | ||
225 | \item Perform all the following steps as root so that you have install privs, | ||
226 | etc. Unpack the archive into a working directory. | ||
227 | |||
228 | \begin{lyxcode} | ||
229 | \#~tar~zxf~mod\_log\_sql.tar.gz~-C~/usr/local/src~\#~cd~/usr/local/src/mod\_log\_sql | ||
230 | \end{lyxcode} | ||
231 | \item Edit Makefile for your system.\\ | ||
232 | |||
233 | |||
234 | |||
235 | NECESSARY: | ||
236 | |||
237 | \begin{itemize} | ||
238 | \item The location where you installed Apache -- usually /usr/local/apache, | ||
239 | 'locate apxs' can help you find it. | ||
240 | \item The location of your MySQL libraries, find using 'locate libmysqlclient' | ||
241 | \item The location of your MySQL header files, find using 'locate mysql.h' | ||
242 | \end{itemize} | ||
243 | OPTIONAL if you have included mod\_ssl in Apache and want to log SSL | ||
244 | data such as keysize and cipher type: | ||
245 | |||
246 | \begin{itemize} | ||
247 | \item The location of your SSL header files, find using 'locate mod\_ssl.h' | ||
248 | \end{itemize} | ||
249 | Now that you know these things, edit Makefile and replace the stock | ||
250 | values with your own. | ||
251 | |||
252 | IMPORTANT: If you are not logging SSL info, comment out MODSSLHDRS | ||
253 | by putting a \# character in front of it: | ||
254 | |||
255 | \begin{lyxcode} | ||
256 | \#MODSSLHDRS=/usr/include/... | ||
257 | \end{lyxcode} | ||
258 | \item Instruct apxs to compile the module as a DSO. | ||
259 | |||
260 | \begin{lyxcode} | ||
261 | \#~make~dso | ||
262 | \end{lyxcode} | ||
263 | \item You should see output similar to the following: | ||
264 | |||
265 | \begin{lyxcode} | ||
266 | /usr/local/Apache/bin/apxs~-Wc,-O2~-Wc,-Wall~-Wc,-DEAPI~-c~-I/usr/include/mysql~-I/usr/local/src/apache\_1.3.27-dso/src/modules/ssl~-L/usr/lib~-lmysqlclient~-lz~mod\_log\_sql.c~ | ||
267 | |||
268 | gcc~-DLINUX=22~-DNO\_DBM\_REWRITEMAP~-DMOD\_SSL=208111~-DUSE\_HSREGEX~-DEAPI~-DUSE\_EXPAT~-I../lib/expat-lite~-fpic~-DSHARED\_CORE~-DSHARED\_MODULE~-I/usr/local/Apache/include~-O2~-Wall~-DEAPI~-I/usr/include/mysql~-I/usr/local/src/apache\_1.3.27-dso/src/modules/ssl~-c~mod\_log\_sql.c~ | ||
269 | |||
270 | gcc~-shared~-o~mod\_log\_sql.so~mod\_log\_sql.o~-Wc,-O2~-Wc,-Wall~-Wc,-DEAPI~-L/usr/lib~-lmysqlclient~-lz~-lm~-lcrypt~-ldb | ||
271 | \end{lyxcode} | ||
272 | You should see no errors and have a file called \char`\"{}mod\_log\_sql.so\char`\"{} | ||
273 | in your directory. | ||
274 | |||
275 | \item Instruct apxs to install the DSO. | ||
276 | |||
277 | \begin{lyxcode} | ||
278 | \#~make~dsoinstall | ||
279 | \end{lyxcode} | ||
280 | You should see output similar to the following: | ||
281 | |||
282 | \begin{lyxcode} | ||
283 | /usr/local/Apache/bin/apxs~-i~mod\_log\_sql.so | ||
284 | |||
285 | cp~mod\_log\_sql.so~/usr/local/Apache/libexec/mod\_log\_sql.so | ||
286 | |||
287 | chmod~755~/usr/local/Apache/libexec/mod\_log\_sql.so | ||
288 | \end{lyxcode} | ||
289 | \item Module ordering within httpd.conf is important. If you are logging | ||
290 | SSL, you must make sure that | ||
291 | |||
292 | \begin{lyxcode} | ||
293 | LoadModule~ssl\_module~libexec/libssl.so | ||
294 | \end{lyxcode} | ||
295 | comes before | ||
296 | |||
297 | \begin{lyxcode} | ||
298 | LoadModule~sql\_log\_module~libexec/mod\_log\_sql.so | ||
299 | \end{lyxcode} | ||
300 | If you don't, you will get this error when you start Apache: | ||
301 | |||
302 | \begin{lyxcode} | ||
303 | /usr/local/apache/libexec/mod\_log\_mysql.so:~undefined~symbol:~ssl\_var\_lookup | ||
304 | |||
305 | /usr/local/apache/bin/apachectl~startssl:~httpd~could~not~be~started | ||
306 | \end{lyxcode} | ||
307 | (Because mod\_log\_sql doesn't yet have the required symbols that | ||
308 | mod\_ssl provides.) | ||
309 | |||
310 | Now skip below to the \char`\"{}Configuration\char`\"{} section. | ||
311 | |||
312 | \end{enumerate} | ||
313 | |||
314 | \subsection{Installation as a static module compiled into httpd} | ||
315 | |||
316 | \begin{enumerate} | ||
317 | \item Perform all the following steps as root so that you have install privs, | ||
318 | etc. | ||
319 | \item Unpack the archive into a working directory. | ||
320 | |||
321 | \begin{lyxcode} | ||
322 | \#~tar~zxf~mod\_log\_sql.tar.gz~-C~/usr/local/src~\#~cd~/usr/local/src/mod\_log\_sql | ||
323 | \end{lyxcode} | ||
324 | \item \label{step:editMF}Edit Makefile for your system.\\ | ||
325 | |||
326 | |||
327 | |||
328 | NECESSARY: | ||
329 | |||
330 | \begin{itemize} | ||
331 | \item The location where you installed Apache -- usually /usr/local/apache, | ||
332 | 'locate apxs' can help you find it. | ||
333 | \item The location of your Apache {*}sources{*}, find using 'locate ABOUT\_APACHE' | ||
334 | \item The location of your MySQL header files, find using 'locate mysql.h' | ||
335 | \item The location of your MySQL libraries, find using 'locate libmysqlclient' | ||
336 | \end{itemize} | ||
337 | OPTIONAL if you have included mod\_ssl in Apache and want to log SSL | ||
338 | data such as keysize and cipher type: | ||
339 | |||
340 | \begin{itemize} | ||
341 | \item The location of your mod\_ssl header files, find using 'locate mod\_ssl.h' | ||
342 | \item The location of your OpenSSL header files, find using 'locate x509.h' | ||
343 | \item The location of your db1 header files, find using 'locate mpool.h' | ||
344 | \end{itemize} | ||
345 | Now that you know these things, edit Makefile and replace the stock | ||
346 | values with your own. | ||
347 | |||
348 | IMPORTANT: If you are not logging SSL info, comment out MODSSLHDRS, | ||
349 | OPNSSLHDRS and DB1HDRS by putting a \# character in front of each | ||
350 | one, e.g. \#OPNSSLHDRS=/usr/include/... | ||
351 | |||
352 | \item \# make static | ||
353 | \item \# make statinstall | ||
354 | \item Change to your Apache source dir. | ||
355 | |||
356 | \begin{lyxcode} | ||
357 | \#~cd~/usr/local/src/apache-1.3.22/src | ||
358 | \end{lyxcode} | ||
359 | \item Re-make your httpd binary as follows. | ||
360 | |||
361 | \begin{enumerate} | ||
362 | \item Edit Configuration.apaci as follows... | ||
363 | |||
364 | \begin{itemize} | ||
365 | \item Append the following string to the EXTRA\_LIBS= line. (\char`\"{}/usr/lib/mysql\char`\"{} | ||
366 | is from step \ref{step:editMF}, where your MySQL libraries live): | ||
367 | \end{itemize} | ||
368 | \begin{lyxcode} | ||
369 | -L/usr/lib/mysql~-lmysqlclient~-lm~-lz | ||
370 | \end{lyxcode} | ||
371 | \begin{itemize} | ||
372 | \item Find the mod\_log\_config.o line, and add this line immediately after | ||
373 | it: | ||
374 | \end{itemize} | ||
375 | \begin{lyxcode} | ||
376 | AddModule~modules/sql/mod\_log\_sql.o | ||
377 | \end{lyxcode} | ||
378 | \item \# cp Configuration.apaci Configuration | ||
379 | \item \# ./Configure | ||
380 | \item \# make | ||
381 | \item \# strip httpd | ||
382 | \end{enumerate} | ||
383 | \item Test your new apache binary: | ||
384 | |||
385 | \begin{lyxcode} | ||
386 | \#~./httpd~-l | ||
387 | \end{lyxcode} | ||
388 | \item You should see something like: | ||
389 | |||
390 | \begin{lyxcode} | ||
391 | Compiled-in~modules:~ | ||
392 | |||
393 | http\_core.c | ||
394 | |||
395 | mod\_log\_sql.c~<-{}-~That's~the~line~you're~looking~for. | ||
396 | |||
397 | mod\_env.c~ | ||
398 | |||
399 | mod\_log\_config.c~ | ||
400 | |||
401 | mod\_mime.c~ | ||
402 | |||
403 | mod\_negotiation.c~... | ||
404 | |||
405 | etc... | ||
406 | \end{lyxcode} | ||
407 | \item Install your httpd binary. Copy it over your old httpd binary, wherever | ||
408 | it lives. You can and should rename your old httpd first so that you | ||
409 | can easily revert to that working version in case of bugs with the | ||
410 | new version. | ||
411 | |||
412 | \begin{lyxcode} | ||
413 | \#~/etc/rc.d/init.d/httpd~stop~ | ||
414 | |||
415 | \#~mv~/usr/local/Apache/bin/httpd~\textasciitilde{}/httpd-save~ | ||
416 | |||
417 | \#~cp~-f~./httpd~/usr/local/Apache/bin/ | ||
418 | \end{lyxcode} | ||
419 | \end{enumerate} | ||
420 | |||
421 | \section{Configuration} | ||
422 | |||
423 | |||
424 | \subsection{Preparing MySQL} | ||
425 | |||
426 | You have to prepare the database to receive data from mod\_log\_sql, | ||
427 | and set up run-time directives in httpd.conf to control how and what | ||
428 | mod\_log\_sql logs. | ||
429 | |||
430 | This section will discuss how to get started with a basic config. | ||
431 | Full documentation of the run-time directives is available here: http://www.grubbybaby.com/mod\_log\_sql/directives.html | ||
432 | |||
433 | \begin{enumerate} | ||
434 | \item mod\_log\_sql can make its own tables on-the-fly, or you can pre-make | ||
435 | the tables by hand. The advantage of letting the module make the tables | ||
436 | is ease-of-use, but for raw performance you will want to pre-make | ||
437 | the tables in order to save overhead. In this basic setup we'll let | ||
438 | the module create tables for us. | ||
439 | \item We still need to have a logging database created and ready, so run | ||
440 | the MySQL command line client and create a database: | ||
441 | |||
442 | \begin{lyxcode} | ||
443 | \#~mysql~-uadmin~-pmypassword~mysql>~create~database~apachelogs; | ||
444 | \end{lyxcode} | ||
445 | \item If you want to hand-create the tables, run the enclosed 'create-tables' | ||
446 | SQL script as follows: | ||
447 | |||
448 | \begin{lyxcode} | ||
449 | mysql>~source~create\_tables.sql | ||
450 | \end{lyxcode} | ||
451 | \item Create a specific MySQL userid that httpd will use to authenticate | ||
452 | and enter data. This userid need not be an actual Unix user. It is | ||
453 | a userid internal to MySQL with specific privileges. In the following | ||
454 | example command, \char`\"{}apachelogs\char`\"{} is the database, \char`\"{}loguser\char`\"{} | ||
455 | is the userid to create, \char`\"{}my.apachemachine.com\char`\"{} | ||
456 | is the name of the Apache machine, and \char`\"{}l0gger\char`\"{} | ||
457 | is the password to assign. Choose values that are different from these | ||
458 | examples. | ||
459 | |||
460 | \begin{lyxcode} | ||
461 | mysql>~grant~insert,create~on~apachelogs.{*}~to~loguser@my.apachemachine.com~identified~by~'l0gger'; | ||
462 | \end{lyxcode} | ||
463 | \item You may be especially security-paranoid and not want \char`\"{}loguser\char`\"{} | ||
464 | to have \char`\"{}create\char`\"{} capability within the \char`\"{}apachelogs\char`\"{} | ||
465 | databse. You can disable that but the cost is that you cannot use | ||
466 | the module's automatic-table-creation feature. If that's an acceptable | ||
467 | cost, hand-create the tables as described in step 1 and use the following | ||
468 | GRANT statement instead of the one above: | ||
469 | |||
470 | \begin{lyxcode} | ||
471 | mysql>~grant~insert~on~apachelogs.{*}~to~loguser@my.apachemachine.com~identified~by~'l0gger'; | ||
472 | \end{lyxcode} | ||
473 | \item Enable full logging of your MySQL daemon (at least temporarily for | ||
474 | debugging purposes) if you don't do this already. Edit /etc/my.cnf | ||
475 | and add the following line to your {[}mysqld{]} section: | ||
476 | |||
477 | \begin{lyxcode} | ||
478 | log=/var/log/mysql-messages | ||
479 | \end{lyxcode} | ||
480 | Then restart MySQL. | ||
481 | |||
482 | \begin{lyxcode} | ||
483 | \#~/etc/rc.d/init.d/mysql~restart | ||
484 | \end{lyxcode} | ||
485 | \end{enumerate} | ||
486 | |||
487 | \subsection{Preparing Apache} | ||
488 | |||
489 | \begin{enumerate} | ||
490 | \item Tell the module what database to use and the appropriate authentication | ||
491 | information. | ||
492 | |||
493 | \begin{description} | ||
494 | \item [EXAMPLE:]Use the MySQL database called \char`\"{}apachelogs\char`\"{} | ||
495 | running on \char`\"{}dbmachine.foo.com\char`\"{}. The module uses | ||
496 | username \char`\"{}loguser\char`\"{} and password \char`\"{}l0gger\char`\"{} | ||
497 | to authenticate to the database. The log entries will be INSERTed | ||
498 | into the table called \char`\"{}access\_log\char`\"{}. | ||
499 | \end{description} | ||
500 | So, edit httpd.conf and insert the following lines somewhere AFTER | ||
501 | any LoadModule / AddModule statements. Make sure these statements | ||
502 | are \char`\"{}global,\char`\"{} i.e. not inside any VirtualHost stanza. | ||
503 | |||
504 | \begin{lyxcode} | ||
505 | LogSQLDatabase~apachelogs | ||
506 | |||
507 | LogSQLLoginInfo~dbmachine.foo.com~loguser~l0gger~ | ||
508 | |||
509 | LogSQLCreateTables~on | ||
510 | \end{lyxcode} | ||
511 | \item If your database resides on localhost instead of another host, specify | ||
512 | the MySQL server's socket file as follows: | ||
513 | |||
514 | \begin{lyxcode} | ||
515 | LogSQLSocketFile~/your/path/to/mysql.sock | ||
516 | \end{lyxcode} | ||
517 | \item The actual logging is set up on a virtual-host-by-host basis. So, | ||
518 | skip down to the virtual host you want to set up. Instruct this virtual | ||
519 | host to log entries to the table ''access\_log'' by inserting a | ||
520 | LogSQLTransferLogTable directive. (The LogSQLTransferLogTable directive | ||
521 | is the minimum required to log -- other directives simply tune the | ||
522 | module's behavior.) | ||
523 | |||
524 | \begin{lyxcode} | ||
525 | <VirtualHost~1.2.3.4> | ||
526 | |||
527 | {[}snip{]} | ||
528 | |||
529 | LogSQLTransferLogTable~access\_log | ||
530 | |||
531 | {[}snip{]} | ||
532 | |||
533 | </VirtualHost> | ||
534 | \end{lyxcode} | ||
535 | \item Restart apache. | ||
536 | |||
537 | \begin{lyxcode} | ||
538 | \#~/etc/rc.d/init.d/httpd~start | ||
539 | \end{lyxcode} | ||
540 | \end{enumerate} | ||
541 | |||
542 | \subsection{Testing the module} | ||
543 | |||
544 | \begin{enumerate} | ||
545 | \item Load your web site in a browser to trigger some hits, then confirm | ||
546 | that the entries are being successfully logged: | ||
547 | |||
548 | \begin{lyxcode} | ||
549 | \#~mysql~-hmysql.host.com~-umysqladmin~-p~-e~\char`\"{}select~{*}~from~access\_log\char`\"{}~apachelogs~ | ||
550 | |||
551 | Enter~password: | ||
552 | |||
553 | (Several~lines~of~output~should~follow,~corresponding~to~your~hits~on~the~site.) | ||
554 | \end{lyxcode} | ||
555 | You now have basic functionality. Don't disable your regular Apache | ||
556 | logs until you feel comfortable that the database is behaving as you'd | ||
557 | like and that things are going well. | ||
558 | |||
559 | \item If you do not see any entries in the access\_log, then something is | ||
560 | preventing the inserts from happening. This problem could be caused | ||
561 | by several things: | ||
562 | |||
563 | \begin{itemize} | ||
564 | \item Improper privileges set up in the MySQL database | ||
565 | \item You aren't hitting a VirtualHost that has a LogSQLTransferLogTable | ||
566 | entry | ||
567 | \item You didn't specify the right host | ||
568 | \end{itemize} | ||
569 | If you have confirmed your LogSQL{*} directives and know them to be | ||
570 | correct, you should examine the httpd server logs for mod\_log\_sql | ||
571 | messages; the module will offer hints as to why it cannot connect, | ||
572 | etc. Also examine the MySQL log that you established in step 3. Ensure | ||
573 | that the INSERTs are not being rejected because of a malformed table | ||
574 | entry or other clerical error. If you see no INSERT attempts in the | ||
575 | log, the module isn't successfully connecting to the database. | ||
576 | |||
577 | The next thing to do is recompile the module with debugging output | ||
578 | activated. change the \char`\"{}\#undef DEBUG\char`\"{} on line 8 | ||
579 | of mod\_log\_sql.c to \char`\"{}\#define DEBUG\char`\"{} and recompile/reinstall. | ||
580 | The module will now output copious notes about what it is doing, and | ||
581 | this will help you (and the maintainer) solve the problem. | ||
582 | |||
583 | \end{enumerate} | ||
584 | You can now activate the advanced features of mod\_log\_sql. These | ||
585 | are all described in the next section. | ||
586 | |||
587 | |||
588 | \subsection{Configuration directive reference} | ||
589 | |||
590 | |||
591 | \subsubsection{LogSQLLoginInfo } | ||
592 | |||
593 | \begin{lyxcode} | ||
594 | \textbf{MANDATORY}~ | ||
595 | |||
596 | Syntax:~LogSQLLoginInfo~host~user~password | ||
597 | |||
598 | Example:~LogSQLLoginInfo~foobar.baz.com~logwriter~passw0rd~ | ||
599 | |||
600 | Context:~server~config | ||
601 | \end{lyxcode} | ||
602 | \begin{quote} | ||
603 | Defines the general parameters of the MySQL host to which you will | ||
604 | be logging. host is the hostname or IP address of the MySQL machine. | ||
605 | user is the MySQL userid (not a Unix userid!) with INSERT privileges | ||
606 | on the table defined in LogSQLTransferLogTable. password is that user's | ||
607 | password. This is defined only once in the httpd.conf file. | ||
608 | \end{quote} | ||
609 | |||
610 | \subsubsection{LogSQLDatabase } | ||
611 | |||
612 | \begin{lyxcode} | ||
613 | \textbf{MANDATORY} | ||
614 | |||
615 | Syntax:~LogSQLDatabase~database~ | ||
616 | |||
617 | Example:~LogSQLDatabase~loggingdb~ | ||
618 | |||
619 | Context:~server~config | ||
620 | \end{lyxcode} | ||
621 | \begin{quote} | ||
622 | Defines the database that is used for logging. database must be operating | ||
623 | on the MySQL host defined in LogSQLLoginInfo. This is defined only | ||
624 | once in the httpd.conf file. | ||
625 | \end{quote} | ||
626 | |||
627 | \subsubsection{LogSQLTransferLogTable} | ||
628 | |||
629 | \begin{lyxcode} | ||
630 | \textbf{MANDATORY~} | ||
631 | |||
632 | Syntax:~LogSQLTransferLogTable~table-name~ | ||
633 | |||
634 | Example:~LogSQLTransferLogTable~access\_log\_table~ | ||
635 | |||
636 | Context:~virtual~host | ||
637 | \end{lyxcode} | ||
638 | \begin{quote} | ||
639 | Defines which table is used for logging of Apache's transfers; this | ||
640 | is analogous to Apache's TransferLog directive. table-name must be | ||
641 | a valid table within the database defined in LogSQLDatabase. | ||
642 | |||
643 | This directive is not necessary if you declare LogSQLMassVirtualHosting | ||
644 | On, since that directive activates dynamically-named tables. If you | ||
645 | attempt to use LogSQLTransferLogTable at the same time a warning will | ||
646 | be logged and it will be ignored, since LogSQLMassVirtualHosting takes | ||
647 | priority. | ||
648 | \end{quote} | ||
649 | |||
650 | \subsubsection{LogSQLRequestIgnore} | ||
651 | |||
652 | \begin{lyxcode} | ||
653 | Syntax:~LogSQLRequestIgnore~req1~req2~req3~...~reqN~ | ||
654 | |||
655 | Example:~LogSQLRequestIgnore~root.exe~cmd.exe~default.ida~favicon.ico~ | ||
656 | |||
657 | Context:~virtual~host | ||
658 | \end{lyxcode} | ||
659 | \begin{quote} | ||
660 | Lists a series of strings that, if present in the URI, will cause | ||
661 | that request NOT to be logged. This directive is useful for cutting | ||
662 | down on log clutter when you KNOW that you do not want to log requests | ||
663 | for certain objects. (The example above is a genuinely useful one; | ||
664 | it will prevent logging of many common Microsoft-based worm intrusion | ||
665 | attempts, as well as those ridiculous requests for the favicon.) | ||
666 | |||
667 | Each string is separated by a space, and NO regular expressions or | ||
668 | globbing are allowed. Each string is evaluated as a substring of the | ||
669 | URI using strstr(). | ||
670 | \end{quote} | ||
671 | |||
672 | \subsubsection{LogSQLRemhostIgnore} | ||
673 | |||
674 | \begin{lyxcode} | ||
675 | Syntax:~LogSQLRemhostIgnore~host1~host2~host3~...~hostN~ | ||
676 | |||
677 | Example:~LogSQLRemhostIgnore~localnet.com~ | ||
678 | |||
679 | Context:~virtual~host | ||
680 | \end{lyxcode} | ||
681 | \begin{quote} | ||
682 | Lists a series of strings that, if present in the REMOTE\_HOST, will | ||
683 | cause that request NOT to be logged. This directive is useful for | ||
684 | cutting down on log clutter when you KNOW that you do not want to | ||
685 | log requests from certain hosts, such as your own internal network | ||
686 | machines. | ||
687 | |||
688 | Each string is separated by a space, and NO regular expressions or | ||
689 | globbing are allowed. Each string is evaluated as a substring of the | ||
690 | REMOTE\_HOST using strstr(). | ||
691 | \end{quote} | ||
692 | |||
693 | \subsubsection{LogSQLRefererIgnore} | ||
694 | |||
695 | \begin{lyxcode} | ||
696 | Syntax:~LogSQLRefererIgnore~ref1~ref2~ref3~...~refN~ | ||
697 | |||
698 | Example:~LogSQLRefererIgnore~google.com~ | ||
699 | |||
700 | Context:~virtual~host | ||
701 | \end{lyxcode} | ||
702 | \begin{quote} | ||
703 | Lists a series of strings that, if present in the HTTP\_REFERER, will | ||
704 | cause that request NOT to be logged. This directive is useful for | ||
705 | cutting down on log clutter when you know that you do not want to | ||
706 | log requests from certain referers. | ||
707 | |||
708 | Each string is separated by a space, and NO regular expressions or | ||
709 | globbing are allowed. Each string is evaluated as a substring of the | ||
710 | HTTP\_REFERER using strstr(). | ||
711 | \end{quote} | ||
712 | |||
713 | \subsubsection{LogSQLWhichCookie} | ||
714 | |||
715 | \begin{lyxcode} | ||
716 | Syntax:~LogSQLWhichCookie~cookiename~ | ||
717 | |||
718 | Example:~LogSQLWhichCookie~Clicks | ||
719 | |||
720 | Default:~None.~You~must~set~this~if~you~wish~to~capture~cookies. | ||
721 | |||
722 | Context:~virtual~host | ||
723 | \end{lyxcode} | ||
724 | \begin{quote} | ||
725 | In HTTP, cookies have names to distinguish them from each other. Using | ||
726 | mod\_usertrack, for example, you can give your user-tracking cookies | ||
727 | a name with the CookieName directive. | ||
728 | |||
729 | If you have activated cookie logging in LogSQLTransferLogFormat, then | ||
730 | LogSQLWhichCookie tells mod\_log\_sql which cookie to log. This is | ||
731 | useful because many times you will be setting and receiving more than | ||
732 | one cookie from a client; without this directive you'd be unable to | ||
733 | choose which cookie is your mod\_usertrack cookie. | ||
734 | |||
735 | Note: although this was intended for people who are using mod\_usertrack | ||
736 | to set user-tracking cookies, you aren't restricted in any way. You | ||
737 | can choose which cookie you wish to log to the database, and it doesn't | ||
738 | necessarily have to have anything to do with mod\_usertrack. | ||
739 | \end{quote} | ||
740 | |||
741 | \subsubsection{LogSQLCreateTables} | ||
742 | |||
743 | \begin{lyxcode} | ||
744 | Syntax:~LogSQLCreateTables~flag | ||
745 | |||
746 | Example:~LogSQLCreateTables~On~ | ||
747 | |||
748 | Default:~Off~ | ||
749 | |||
750 | Context:~server~config | ||
751 | \end{lyxcode} | ||
752 | \begin{quote} | ||
753 | mod\_log\_sql now has the ability to create its tables on-the-fly. | ||
754 | The advantage to this is convenience: you don't have to execute any | ||
755 | SQL by hand to prepare the table. This is especially helpful for people | ||
756 | with lots of virtual hosts (who should also see the LogSQLMassVirtualHosting | ||
757 | directive). | ||
758 | |||
759 | There is a slight disadvantage: if you wish to activate this feature, | ||
760 | then the user specified by LogSQLLoginInfo must have CREATE privileges | ||
761 | on the database. In an absolutely paranoid, locked-down situation | ||
762 | you may only want to grant your mod\_log\_sql user INSERT privileges | ||
763 | on the database; in that situation you are unable to take advantage | ||
764 | of LogSQLCreateTables. But most people -- even the very security-conscious | ||
765 | -- will find that granting CREATE on the logging database is reasonable. | ||
766 | |||
767 | This is defined only once in the httpd.conf file. | ||
768 | \end{quote} | ||
769 | |||
770 | \subsubsection{LogSQLMassVirtualHosting} | ||
771 | |||
772 | \begin{lyxcode} | ||
773 | Syntax:~LogSQLMassVirtualHosting~flag~ | ||
774 | |||
775 | Example:~LogSQLMassVirtualHosting~On~ | ||
776 | |||
777 | Default:~Off~ | ||
778 | |||
779 | Context:~server~config | ||
780 | \end{lyxcode} | ||
781 | \begin{quote} | ||
782 | If you administer a site hosting many, many virtual hosts then this | ||
783 | option will appeal to you. If you activate LogSQLMassVirtualHosting | ||
784 | then several things happen: | ||
785 | \begin{itemize} | ||
786 | \item the on-the-fly table creation feature is activated automatically | ||
787 | \item the transfer log table name is dynamically set from the virtual host's | ||
788 | name (example: a virtual host www.grubbybaby.com gets logged to table | ||
789 | access\_www\_grubbybaby\_com) | ||
790 | \item which, in turn, means that each virtual host logs to its own segregated | ||
791 | table. Because there is no data shared between virtual servers you | ||
792 | can grant your users access to the tables they need; they will be | ||
793 | unable to view others' data. | ||
794 | \end{itemize} | ||
795 | This is a huge boost in convenience for sites with many virtual servers. | ||
796 | Activating LogSQLMassVirtualHosting obviates the need to create every | ||
797 | virtual server's table and provides more granular security possibilities. | ||
798 | |||
799 | This is defined only once in the httpd.conf file. | ||
800 | \end{quote} | ||
801 | |||
802 | \subsubsection{LogSQLPreserveFile} | ||
803 | |||
804 | \begin{lyxcode} | ||
805 | Syntax:~LogSQLPreserveFile~filename~ | ||
806 | |||
807 | Example:~LogSQLPreserveFile~offline-preserve~ | ||
808 | |||
809 | Default:~mysql-preserve~(in~/tmp)~ | ||
810 | |||
811 | Context:~virtual~host | ||
812 | \end{lyxcode} | ||
813 | \begin{quote} | ||
814 | mod\_log\_sql writes queries to this local preserve file in the event | ||
815 | that it cannot reach the database, and thus ensures that your high-availability | ||
816 | web frontend does not lose logs during a temporary database outage. | ||
817 | This could happen for a number of reasons: the database goes offline, | ||
818 | the network breaks, etc. You will not lose entries since the module | ||
819 | has this backup. The file consists of a series of SQL statements that | ||
820 | can be imported into your database at your convenience; furthermore, | ||
821 | because the SQL queries contain the access timestamps you do not need | ||
822 | to worry about out-of-order data after the import. | ||
823 | |||
824 | For security purposes the name you supply will be prepended with \char`\"{}/tmp/\char`\"{} | ||
825 | to force creation of the file in /tmp. | ||
826 | |||
827 | If you do not define LogSQLPreserveFile then all virtual servers will | ||
828 | log to the same default preserve file (/tmp/mysql-preserve). You can | ||
829 | redefine this on a virtual-host basis in order to segregate your preserve | ||
830 | files if you desire. Note that segregation is not really necessary, | ||
831 | as the SQL statements that are written to the preserve file already | ||
832 | distinguish between different virtual hosts. | ||
833 | |||
834 | The module will log to error-log if/when it notices a database outage, | ||
835 | and upon database return. You will therefore know when the preserve | ||
836 | file is being used, although it is your responsibility to import the | ||
837 | file. | ||
838 | |||
839 | The file does not need to be created in advance. It is safe to remove | ||
840 | or rename the file without interrupting Apache, as the module closes | ||
841 | the filehandle immediately after completing the write. The file is | ||
842 | created with the user \& group ID of the running Apache process (e.g. | ||
843 | 'nobody' on many Linux distributions). | ||
844 | \end{quote} | ||
845 | |||
846 | \subsubsection{LogSQLSocketFile } | ||
847 | |||
848 | \begin{lyxcode} | ||
849 | Syntax:~LogSQLSocketFile~filename~ | ||
850 | |||
851 | Example:~LogSQLSocketFile~/tmp/mysql.sock~ | ||
852 | |||
853 | Default:~/var/lib/mysql/mysql.sock~ | ||
854 | |||
855 | Context:~server~config | ||
856 | \end{lyxcode} | ||
857 | \begin{quote} | ||
858 | At Apache runtime you can specify the MySQL socket file to use. Set | ||
859 | this once in your main server config to override the default value. | ||
860 | This value is irrelevant if your database resides on a separate machine. | ||
861 | |||
862 | mod\_log\_sql will automatically employ the socket for db communications | ||
863 | if the database resides on the local host. If the db resides on a | ||
864 | separate host the module will automatically use TCP/IP. This is a | ||
865 | function of the MySQL API and is not user-configurable. | ||
866 | \end{quote} | ||
867 | |||
868 | \subsubsection{LogSQLTransferLogFormat } | ||
869 | |||
870 | \begin{lyxcode} | ||
871 | Syntax:~LogSQLTransferLogFormat~format-string~ | ||
872 | |||
873 | Example:~LogSQLTransferLogFormat~huSUTv~ | ||
874 | |||
875 | Default:~AbHhmRSsTUuv~ | ||
876 | |||
877 | Context:~virtual~host | ||
878 | \end{lyxcode} | ||
879 | \begin{quote} | ||
880 | Each character in the format-string defines an attribute of the request | ||
881 | that you wish to log. The default logs the information required to | ||
882 | create Combined Log Format logs, plus several extras. Here is the | ||
883 | full list of allowable keys, which sometimes resemble their Apache | ||
884 | counterparts, but do not always: | ||
885 | |||
886 | \begin{tabular}{|c|l|l|l|l|} | ||
887 | \hline | ||
888 | \textbf{Character}& | ||
889 | \textbf{What is this?}& | ||
890 | \textbf{MySQL DB field}& | ||
891 | \textbf{Recommended column type}& | ||
892 | \textbf{Example}\\ | ||
893 | \hline | ||
894 | \hline | ||
895 | A& | ||
896 | User agent& | ||
897 | agent& | ||
898 | varchar(255)& | ||
899 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 4.0)\\ | ||
900 | \hline | ||
901 | b& | ||
902 | Bytes transfered& | ||
903 | bytes\_sent& | ||
904 | int unsigned& | ||
905 | 32561\\ | ||
906 | \hline | ||
907 | c& | ||
908 | Text of cookie& | ||
909 | cookie& | ||
910 | varchar(255)& | ||
911 | Apache=sdyn.fooonline.net.130051007102700823\\ | ||
912 | \hline | ||
913 | f& | ||
914 | & | ||
915 | request\_file& | ||
916 | varchar(255)& | ||
917 | \\ | ||
918 | \hline | ||
919 | H& | ||
920 | HTTP request protocol& | ||
921 | request\_protocol& | ||
922 | varchar(10)& | ||
923 | HTTP/1.1\\ | ||
924 | \hline | ||
925 | h& | ||
926 | Name of remote host& | ||
927 | remote\_host& | ||
928 | varchar(50)& | ||
929 | blah.foobar.com\\ | ||
930 | \hline | ||
931 | I& | ||
932 | Ident user info& | ||
933 | remote\_logname& | ||
934 | varchar(50)& | ||
935 | bobby\\ | ||
936 | \hline | ||
937 | m& | ||
938 | HTTP request method& | ||
939 | request\_method& | ||
940 | varchar(6)& | ||
941 | GET\\ | ||
942 | \hline | ||
943 | P& | ||
944 | httpd child PID& | ||
945 | child\_pid& | ||
946 | smallint unsigned& | ||
947 | 3215\\ | ||
948 | \hline | ||
949 | p& | ||
950 | httpd port& | ||
951 | server\_port& | ||
952 | smallint unsigned& | ||
953 | 80\\ | ||
954 | \hline | ||
955 | R& | ||
956 | Referer& | ||
957 | referer& | ||
958 | varchar(255)& | ||
959 | http://www.biglinkstoyou.com/linkpage.html\\ | ||
960 | \hline | ||
961 | r& | ||
962 | Request in full form& | ||
963 | request\_line& | ||
964 | varchar(255)& | ||
965 | GET /books-cycroad.html HTTP/1.1\\ | ||
966 | \hline | ||
967 | S& | ||
968 | Time of request in UNIX format& | ||
969 | time\_stamp& | ||
970 | int unsigned& | ||
971 | 1005598029\\ | ||
972 | \hline | ||
973 | s& | ||
974 | HTTP status of request& | ||
975 | status& | ||
976 | smallint unsigned& | ||
977 | 404\\ | ||
978 | \hline | ||
979 | T& | ||
980 | Seconds to service request& | ||
981 | request\_duration& | ||
982 | smallint unsigned& | ||
983 | 2\\ | ||
984 | \hline | ||
985 | t& | ||
986 | Time of request in human format& | ||
987 | request\_time& | ||
988 | char(28)& | ||
989 | {[}02/Dec/2001:15:01:26 -0800{]}\\ | ||
990 | \hline | ||
991 | U& | ||
992 | Request in simple form& | ||
993 | request\_uri& | ||
994 | varchar(255)& | ||
995 | /books-cycroad.html\\ | ||
996 | \hline | ||
997 | u& | ||
998 | User info from HTTP authentication& | ||
999 | remote\_user& | ||
1000 | varchar(50)& | ||
1001 | bobby\\ | ||
1002 | \hline | ||
1003 | v& | ||
1004 | Virtual host servicing the request& | ||
1005 | virtual\_host& | ||
1006 | varchar(50)& | ||
1007 | www.foobar.com\\ | ||
1008 | \hline | ||
1009 | \end{tabular} | ||
1010 | |||
1011 | If you have compiled mod\_log\_sql with WANT\_SSL\_LOGGING, you also | ||
1012 | get these: | ||
1013 | |||
1014 | \begin{tabular}{|c|l|l|l|} | ||
1015 | \hline | ||
1016 | \textbf{Character}& | ||
1017 | \textbf{MySQL DB field it activates}& | ||
1018 | \textbf{MySQL DB field it activatesRecommended column type}& | ||
1019 | \textbf{Example}\\ | ||
1020 | \hline | ||
1021 | \hline | ||
1022 | z& | ||
1023 | ssl\_cipher& | ||
1024 | varchar(25)& | ||
1025 | RC4-MD5\\ | ||
1026 | \hline | ||
1027 | q& | ||
1028 | ssl\_keysize& | ||
1029 | smallint unsigned& | ||
1030 | 56\\ | ||
1031 | \hline | ||
1032 | Q& | ||
1033 | ssl\_maxkeysize& | ||
1034 | smallint unsigned& | ||
1035 | 128\\ | ||
1036 | \hline | ||
1037 | \end{tabular} | ||
1038 | \end{quote} | ||
1039 | |||
1040 | \section{FAQ} | ||
1041 | |||
1042 | |||
1043 | \subsection{Why log to an SQL database?} | ||
1044 | |||
1045 | To begin with, let's get it out of the way: logging to a database | ||
1046 | is not a panacea. But while there are complexities with this solution, | ||
1047 | the benefit can be substantial for certain classes of administrator | ||
1048 | or people with advanced requirements: | ||
1049 | |||
1050 | \begin{itemize} | ||
1051 | \item Chores like log rotation go away, as you can DELETE records from the | ||
1052 | SQL database once they are no longer useful. For example, the excellent | ||
1053 | and popular log-analysis tool Webalizer (http://www.webalizer.com/) | ||
1054 | does not need historic logs after it has processed them, enabling | ||
1055 | you to delete older logs. | ||
1056 | \item People with clusters of web servers (for high availability) will benefit | ||
1057 | the most -- all their webservers can log to a single SQL database. | ||
1058 | This obviates the need to collate/interleave the many separate logfiles, | ||
1059 | which can be / highly/ problematic. | ||
1060 | \item People acquainted with the power of SQL SELECT statements will know | ||
1061 | the flexibility of the extraction possibilities at their fingertips. | ||
1062 | \end{itemize} | ||
1063 | For example, do you want to see all your 404's? Do this: | ||
1064 | |||
1065 | \begin{lyxcode} | ||
1066 | select~remote\_host,status,request\_uri,bytes\_sent,from\_unixtime(time\_stamp)~from~acc\_log\_tbl~where~status=404~order~by~time\_stamp; | ||
1067 | |||
1068 | +-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}- | ||
1069 | |||
1070 | +~~~~~~~~~~~~~~~~~~~~~~~remote\_host~|~status~|~request\_uri~~~~~~~~~~~~~~|~bytes\_sent~|~from\_unixtime(time\_stamp)| | ||
1071 | |||
1072 | +-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}- | ||
1073 | |||
1074 | |~marge.mmm.co.uk~~~~~~~~~~~~~~~~~~~|~404~~~~|~/favicon.ico~~~~~~~~~~~~~|~321~~~~~~~~|~2001-11-20~02:30:56~~~~~~| | ||
1075 | |||
1076 | |~62.180.239.251~~~~~~~~~~~~~~~~~~~~|~404~~~~|~/favicon.ico~~~~~~~~~~~~~|~333~~~~~~~~|~2001-11-20~02:45:25~~~~~~| | ||
1077 | |||
1078 | |~212.234.12.66~~~~~~~~~~~~~~~~~~~~~|~404~~~~|~/favicon.ico~~~~~~~~~~~~~|~321~~~~~~~~|~2001-11-20~03:01:00~~~~~~|~ | ||
1079 | |||
1080 | |~212.210.78.254~~~~~~~~~~~~~~~~~~~~|~404~~~~|~/favicon.ico~~~~~~~~~~~~~|~333~~~~~~~~|~2001-11-20~03:26:05~~~~~~|~ | ||
1081 | |||
1082 | +-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-+ | ||
1083 | \end{lyxcode} | ||
1084 | Or do you want to see how many bytes you've sent within a certain | ||
1085 | directory or site? Do this: | ||
1086 | |||
1087 | \begin{lyxcode} | ||
1088 | select~request\_uri,sum(bytes\_sent)~as~bytes,count(request\_uri)~as~howmany~from~acc\_log\_tbl~where~request\_uri~like~'\%mod\_log\_sql\%'~group~by~request\_uri~order~by~howmany~desc;~ | ||
1089 | |||
1090 | +-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-{}-+~ | ||
1091 | |||
1092 | |~request\_uri~~~~~~~~~~~~~~~~~~~~~~~|~bytes~~~|~howmany~|~ | ||
1093 | |||
1094 | +-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-{}-+~ | ||
1095 | |||
1096 | |~/mod\_log\_sql/style\_1.css~~~~~~~~~~|~157396~~|~~~~1288~|~ | ||
1097 | |||
1098 | |~/mod\_log\_sql/~~~~~~~~~~~~~~~~~~~~~|~2514337~|~~~~~801~|~ | ||
1099 | |||
1100 | |~/mod\_log\_sql/mod\_log\_sql.tar.gz~~~|~9769312~|~~~~~456~|~ | ||
1101 | |||
1102 | |~/mod\_log\_sql/faq.html~~~~~~~~~~~~~|~5038728~|~~~~~436~|~ | ||
1103 | |||
1104 | |~/mod\_log\_sql/INSTALL~~~~~~~~~~~~~~|~1196161~|~~~~~202~|~ | ||
1105 | |||
1106 | |~/mod\_log\_sql/directives.html~~~~~~|~1096821~|~~~~~171~|~ | ||
1107 | |||
1108 | |~/mod\_log\_sql/CHANGELOG~~~~~~~~~~~~|~424481~~|~~~~~107~|~ | ||
1109 | |||
1110 | |~/mod\_log\_sql/README~~~~~~~~~~~~~~~|~796072~~|~~~~~~97~|~ | ||
1111 | |||
1112 | |~/mod\_log\_sql/directives-old.html~~|~42480~~~|~~~~~~~6~| | ||
1113 | |||
1114 | |~/mod\_log\_sql/index.html~~~~~~~~~~~|~9531~~~~|~~~~~~~3~|~ | ||
1115 | |||
1116 | +-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-{}-+ | ||
1117 | \end{lyxcode} | ||
1118 | Or maybe you want to see who's linking to you? Do this: | ||
1119 | |||
1120 | \begin{lyxcode} | ||
1121 | select~count(referer)~as~num,referer~from~acc\_log\_tbl~where~request\_uri='/mod\_log\_sql/'~group~by~referer~order~by~num~desc; | ||
1122 | |||
1123 | +-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-+ | ||
1124 | |||
1125 | |~num~|~referer~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|~ | ||
1126 | |||
1127 | +-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-+ | ||
1128 | |||
1129 | |~271~|~http://freshmeat.net/projects/mod\_log\_sql/~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|~ | ||
1130 | |||
1131 | |~96~~|~http://modules.apache.org/search?id=339~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|~ | ||
1132 | |||
1133 | |~48~~|~http://freshmeat.net/~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|~ | ||
1134 | |||
1135 | |~8~~~|~http://freshmeat.net~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| | ||
1136 | |||
1137 | |~7~~~|~http://freshmeat.net/daily/2001/11/30/~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|~ | ||
1138 | |||
1139 | |~6~~~|~http://freshmeat.net/daily/2001/11/20/~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| | ||
1140 | |||
1141 | +-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-+ | ||
1142 | \end{lyxcode} | ||
1143 | As you can see, there are myriad possibilities that can be constructed | ||
1144 | with the wonderful SQL SELECT statement. Logging to an SQL database | ||
1145 | can be really quite useful! | ||
1146 | |||
1147 | |||
1148 | \subsection{Why use MySQL? Are there alternatives?} | ||
1149 | |||
1150 | MySQL is a robust, free, and very powerful production-quality database | ||
1151 | engine. It is well supported and comes with detailed documentation. | ||
1152 | Many 3rd-party software pacakges (e.g. Slashcode, the engine that | ||
1153 | powers Slashdot) run exclusively with MySQL. In other words, you will | ||
1154 | belong to a very robust and well-supported community by choosing MySQL. | ||
1155 | |||
1156 | That being said, there are alternatives. PostgreSQL is probably MySQL's | ||
1157 | leading \char`\"{}competitor\char`\"{} in the free database world. | ||
1158 | There is also an excellent module available for Apache to permit logging | ||
1159 | to a PostgreSQL database, called pgLOGd \url{(http://www.digitalstratum.com/pglogd/)}. | ||
1160 | |||
1161 | |||
1162 | \subsection{Is this code production-ready?} | ||
1163 | |||
1164 | By all accounts it is. It is known to work without a problem on many-thousands-of-hits-per-day | ||
1165 | webservers. Does that mean it is 100\% bug free? Well, no software | ||
1166 | is. But it is well-tested and /believed/ to be fully compatible with | ||
1167 | production environments. (The usual disclaimers apply. This software | ||
1168 | is provided without warranty of any kind.) | ||
1169 | |||
1170 | |||
1171 | \subsection{How well does it perform?} | ||
1172 | |||
1173 | mod\_log\_sql scales to very high loads. Apache 1.3.22 + mod\_log\_sql | ||
1174 | was benchmarked using the \char`\"{}ab\char`\"{} (Apache Bench) program | ||
1175 | that comes with the Apache distribution; here are the results. | ||
1176 | |||
1177 | Overall configuration: | ||
1178 | |||
1179 | \begin{itemize} | ||
1180 | \item Machine A: Apache webserver | ||
1181 | \item Machine B: MySQL server | ||
1182 | \item Machines A and B connected with 100Mbps Ethernet | ||
1183 | \end{itemize} | ||
1184 | Webserver configuration: | ||
1185 | |||
1186 | \begin{itemize} | ||
1187 | \item Celeron 400 128 MB RAM IDE storage | ||
1188 | \end{itemize} | ||
1189 | Apache configuration: | ||
1190 | |||
1191 | \begin{lyxcode} | ||
1192 | Timeout~300~ | ||
1193 | |||
1194 | KeepAlive~On~ | ||
1195 | |||
1196 | MaxKeepAliveRequests~100~ | ||
1197 | |||
1198 | KeepAliveTimeout~15~ | ||
1199 | |||
1200 | MinSpareServers~5~ | ||
1201 | |||
1202 | StartServers~10~ | ||
1203 | |||
1204 | MaxSpareServers~15~ | ||
1205 | |||
1206 | MaxClients~256~ | ||
1207 | |||
1208 | MaxRequestsPerChild~5000~ | ||
1209 | |||
1210 | LogSQLTransferLogFormat~AbHhmRSsTUuvc~ | ||
1211 | |||
1212 | LogSQLWhichCookie~Clicks~ | ||
1213 | |||
1214 | CookieTracking~on~ | ||
1215 | |||
1216 | CookieName~Clicks | ||
1217 | \end{lyxcode} | ||
1218 | \char`\"{}ab\char`\"{} commandline: | ||
1219 | |||
1220 | \begin{lyxcode} | ||
1221 | ./ab~-c~10~-t~20~-v~2~-C~Clicks=ab\_run~http://www.hostname.com/target~ | ||
1222 | \end{lyxcode} | ||
1223 | ( 10 concurrent requests; 20 second test; setting a cookie \char`\"{}Clicks=ab\_run\char`\"{}; | ||
1224 | target = the mod\_log\_sql homepage. ) | ||
1225 | |||
1226 | Ten total ab runs were conducted: five with MySQL logging enabled, | ||
1227 | and five with all MySQL directives commented out of httpd.conf. Then | ||
1228 | each five were averaged. The results: | ||
1229 | |||
1230 | \begin{itemize} | ||
1231 | \item Average of five runs employing MySQL \emph{and} standard text logging: | ||
1232 | 139.01 requests per second, zero errors. | ||
1233 | \item Average of five runs employing \emph{only} standard text logging: | ||
1234 | 139.96 requests per second, zero errors. | ||
1235 | \end{itemize} | ||
1236 | In other words, any rate-limiting effects on this particular hardware | ||
1237 | setup are not caused by MySQL. Note that although this very simple | ||
1238 | webserver setup is hardly cutting-edge -- it is, after all, a fairly | ||
1239 | small machine -- 139 requests per second equal over twelve million | ||
1240 | hits per day\emph{.} | ||
1241 | |||
1242 | If you run this benchmark yourself, take note of three things: | ||
1243 | |||
1244 | \begin{enumerate} | ||
1245 | \item Use a target URL that is on your own webserver :-). | ||
1246 | \item Wait until all your connections are closed out between runs; after | ||
1247 | several thousand requests your TCP/IP stack will be filled with hundreds | ||
1248 | of connections in TIME\_WAIT that need to close. Do a \char`\"{}netstat | ||
1249 | -t|wc -l\char`\"{} on the webserver to see. If you don't wait, you | ||
1250 | can expect to see a lot of messages like \char`\"{}ip\_conntrack: | ||
1251 | table full, dropping packet\char`\"{} in your logs. (This has nothing | ||
1252 | to do with mod\_log\_sql, this is simply the nature of the TCP/IP | ||
1253 | stack in the Linux kernel.) | ||
1254 | \item When done with your runs, clean these many thousands of requests out | ||
1255 | of your database: | ||
1256 | \end{enumerate} | ||
1257 | \begin{lyxcode} | ||
1258 | mysql>~delete~from~access\_log~where~agent~like~'ApacheBench\%';~mysql>~optimize~table~access\_log;~ | ||
1259 | \end{lyxcode} | ||
1260 | |||
1261 | \subsection{Who's using mod\_log\_sql?} | ||
1262 | |||
1263 | Good question! It would be great to find out! If you are a production-level | ||
1264 | mod\_log\_sql user, please contact the maintainer, Chris Powell \url{chris@grubbybaby.com}so | ||
1265 | that you can be mentioned here. | ||
1266 | |||
1267 | |||
1268 | \subsection{How do I extract the data in a format that my analysis tool can understand?} | ||
1269 | |||
1270 | mod\_log\_sql would be virtually useless if there weren't a way for | ||
1271 | you to extract the data from your database in a somewhat meaningful | ||
1272 | fashion. To that end there's a Perl script enclosed with the distribution. | ||
1273 | That script (make\_combined\_log.pl) is designed to extract N-many | ||
1274 | days worth of access logs and provide them in a Combined Log Format | ||
1275 | output. You can use this very tool right in /etc/crontab to extract | ||
1276 | logs on a regular basis so that your favorite web analysis tool can | ||
1277 | read them. Or you can examine the Perl code to construct your own | ||
1278 | custom tool. | ||
1279 | |||
1280 | For example, let's say that you want your web statistics updated once | ||
1281 | per day in the wee hours of the morning. A good way to accomplish | ||
1282 | that would be the following entries in /etc/crontab: | ||
1283 | |||
1284 | \begin{lyxcode} | ||
1285 | \#~Generate~the~temporary~apache~logs~from~the~MySQL~database~(for~webalizer)~ | ||
1286 | |||
1287 | 05~04~{*}~{*}~{*}~root~/usr/local/sbin/make\_combined\_log.pl~1~www.grubbybaby.com~>~/var/log/httpd/mysql-grubbybaby | ||
1288 | |||
1289 | \#~Run~webalizer~on~httpd~log~ | ||
1290 | |||
1291 | 30~04~{*}~{*}~{*}~root~/usr/local/bin/webalizer~-c~/etc/webalizer.conf;~rm~-f~/var/log/httpd/mysql-grubbybaby | ||
1292 | \end{lyxcode} | ||
1293 | Or if you have a newer system that puts files in /etc/cron.daily etc., | ||
1294 | create a file called ''webalizer'' in the cron.\_\_\_\_ subdir of | ||
1295 | your choice. Use the following as the contents of your file, and make | ||
1296 | sure to chmod 755 it when done. | ||
1297 | |||
1298 | \begin{lyxcode} | ||
1299 | \#!/bin/sh | ||
1300 | |||
1301 | /usr/local/sbin/make\_combined\_log.pl~1~www.yourdomain.com~>~/var/log/httpd/templog | ||
1302 | |||
1303 | /usr/local/bin/webalizer~-q~-c~/etc/webalizer.conf~ | ||
1304 | |||
1305 | rm~-f~/var/log/httpd/templog | ||
1306 | \end{lyxcode} | ||
1307 | See? Easy. | ||
1308 | |||
1309 | |||
1310 | \subsection{Why doesn't the module also replace the Apache ErrorLog?} | ||
1311 | |||
1312 | There are circumstances when that would be quite unwise -- for example, | ||
1313 | if Apache could not reach the MySQL server for some reason and needed | ||
1314 | to log that fact. Without a text-based error log you'd never know | ||
1315 | anything was wrong, because Apache would be trying to log a database | ||
1316 | connection error to the database... you get the point. | ||
1317 | |||
1318 | Error logs are usually not very high-traffic and are really best left | ||
1319 | as text files on a web server machine. | ||
1320 | |||
1321 | |||
1322 | \subsection{\label{sec:cookie}How can I log mod\_usertrack cookies?} | ||
1323 | |||
1324 | A number of people like to log mod\_usertrack cookies in their Apache | ||
1325 | TransferLog to aid in understanding their visitors' clickstreams. | ||
1326 | This is accomplished, for example, with a statement as follows: | ||
1327 | |||
1328 | \begin{lyxcode} | ||
1329 | LogFormat~\char`\"{}\%h~\%l~\%u~\%t~\textbackslash{}\char`\"{}\%r\textbackslash{}\char`\"{}~\%s~\%b~\textbackslash{}\char`\"{}\%\{Referer\}i\textbackslash{}\char`\"{}~\textbackslash{}\char`\"{}\%\{User-Agent\}i\textbackslash{}\char`\"{}\char`\"{}~\textbackslash{}\char`\"{}\%\{cookie\}n\textbackslash{}\char`\"{}\char`\"{} | ||
1330 | \end{lyxcode} | ||
1331 | Naturally it would be nice for mod\_log\_sql to permit the admin to | ||
1332 | log the cookie data as well, so as of version 1.10 you can do this. | ||
1333 | You need to have already compiled mod\_usertrack into httpd -- it's | ||
1334 | one of the standard Apache modules. | ||
1335 | |||
1336 | First make sure you have a column called \char`\"{}cookie\char`\"{} | ||
1337 | in the MySQL database to hold the cookies, which can be done as follows | ||
1338 | if you already have a working database: | ||
1339 | |||
1340 | \begin{lyxcode} | ||
1341 | alter~table~acc\_log\_tbl~add~column~cookie~varchar(255); | ||
1342 | \end{lyxcode} | ||
1343 | Next configure your server to set usertracking cookies as follows, | ||
1344 | and make sure you include the new 'c' directive in your LogSQLTransferLogFormat, | ||
1345 | which activates cookie logging. Here's an example: | ||
1346 | |||
1347 | \begin{lyxcode} | ||
1348 | <VirtualHost~1.2.3.4>~ | ||
1349 | |||
1350 | ~CookieTracking~on~ | ||
1351 | |||
1352 | ~CookieStyle~Cookie~ | ||
1353 | |||
1354 | ~CookieName~Foobar~ | ||
1355 | |||
1356 | ~LogSQLTransferLogFormat~huSUsbTvRAc~ | ||
1357 | |||
1358 | ~LogSQLWhichCookie~Foobar~ | ||
1359 | |||
1360 | </VirtualHost> | ||
1361 | \end{lyxcode} | ||
1362 | The first three lines configure mod\_usertrack to create a COOKIE | ||
1363 | (RFC 2109) format cookie called Foobar. The last two lines tell mod\_log\_sql | ||
1364 | to log cookies named Foobar. You have to choose which cookie to log | ||
1365 | because more than one cookie can/will be sent to the server by the | ||
1366 | client. | ||
1367 | |||
1368 | FYI, you are advised NOT to use CookieStyle Cookie2 -- it seems that | ||
1369 | even newer browsers (IE 5.5, etc.) have trouble with the new COOKIE2 | ||
1370 | (RFC 2965) format. Just stick with the standard COOKIE format and | ||
1371 | you'll be fine. | ||
1372 | |||
1373 | Perform some hits on your server and run a select: | ||
1374 | |||
1375 | \begin{lyxcode} | ||
1376 | mysql>~select~request\_uri,cookie~from~access\_log~where~cookie~is~not~null; | ||
1377 | |||
1378 | +-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-+ | ||
1379 | |||
1380 | |~request\_uri~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~cookie~|~ | ||
1381 | |||
1382 | +-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-+~ | ||
1383 | |||
1384 | |~/mod\_log\_sql/~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|~ool-18e4.dyn.optonline.net.130051007102700823~~~~~~|~ | ||
1385 | |||
1386 | |~/mod\_log\_sql/usa.gif~~~~~~~~~~~~~~~~~~~~~~~|~ool-18e4.dyn.optonline.net.130051007102700823~~~~~~|~ | ||
1387 | |||
1388 | |~/mod\_log\_sql/style\_1.css~~~~~~~~~~~~~~~~~~~|~ool-18e4.dyn.optonline.net.130051007102700823~~~~~~|~ | ||
1389 | |||
1390 | ...etc... | ||
1391 | \end{lyxcode} | ||
1392 | |||
1393 | \subsection{What if I want to log more than one cookie?} | ||
1394 | |||
1395 | No problem. As of version 1.17, you have a choice. If you are just | ||
1396 | interested in a single cookie, follow the instructions in section | ||
1397 | \ref{sec:cookie} above. That cookie will be logged to a column in | ||
1398 | the regular access\_log table. | ||
1399 | |||
1400 | However, if you need to log multiple cookies, you'll employ the LogSQLWhichCookies | ||
1401 | (note the plural) directive. The cookies you specify will be logged | ||
1402 | to a separate table, and entries in that table will be linked to the | ||
1403 | regular access\_log entries via the unique ID that is supplied by | ||
1404 | mod\_unique\_id. Without mod\_unique\_id the information will still | ||
1405 | be logged but you will be unable to correlate which cookies go with | ||
1406 | which access-requests. | ||
1407 | |||
1408 | LogSQLWhichCookie and LogSQLWhichCookies can coexist without conflict, | ||
1409 | but you're better off choosing the one you need. | ||
1410 | |||
1411 | |||
1412 | \subsection{What are the SSL logging features, and how do I activate them?} | ||
1413 | |||
1414 | If you run an SSL-enabled server you may benefit from logging some | ||
1415 | SSL details. mod\_log\_sql now supports this ability. By adding certain | ||
1416 | characters to your LogSQLTransferLogFormat string you can tell mod\_log\_sql | ||
1417 | to log the SSL cipher, the SSL keysize of the connection, and the | ||
1418 | Max-keysize that was available. This would let you tell, for example, | ||
1419 | which clients were using only export-grade security to access your | ||
1420 | secure software area. | ||
1421 | |||
1422 | You can compile mod\_log\_sql with SSL logging support if you have | ||
1423 | the right packages installed. If you already have an SSL-enabled Apache | ||
1424 | then you by definition have the correct packages already installed: | ||
1425 | OpenSSL and mod\_ssl. | ||
1426 | |||
1427 | You need to ensure that your database is set up to log the SSL data. | ||
1428 | Issue the following commands to MySQL once you have your basic access\_log | ||
1429 | table built: | ||
1430 | |||
1431 | \begin{lyxcode} | ||
1432 | alter~table~access\_log~add~column~ssl\_cipher~varchar(25); | ||
1433 | |||
1434 | alter~table~access\_log~add~column~ssl\_keysize~smallint~unsigned; | ||
1435 | |||
1436 | alter~table~access\_log~add~column~ssl\_maxkeysize~smallint~unsigned; | ||
1437 | \end{lyxcode} | ||
1438 | Finally configure httpd.conf to activate the SSL fields. Note that | ||
1439 | this is only meaningful in a VirtualHost that is set up for SSL. | ||
1440 | |||
1441 | \begin{lyxcode} | ||
1442 | <VirtualHost~1.2.3.4:443>~ | ||
1443 | |||
1444 | ~LogSQLTransferLogFormat~AbHhmRSsTUuvcQqz~ | ||
1445 | |||
1446 | </VirtualHost> | ||
1447 | \end{lyxcode} | ||
1448 | The last three characters (Qqz) in the directive are the SSL ones; | ||
1449 | see the directives documentation for details. | ||
1450 | |||
1451 | Perform some hits on your server and run a select: | ||
1452 | |||
1453 | \begin{lyxcode} | ||
1454 | mysql>~select~remote\_host,request\_uri,ssl\_cipher,ssl\_keysize,ssl\_maxkeysize~from~access\_log~where~ssl\_cipher~is~not~null; | ||
1455 | |||
1456 | +-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-+~ | ||
1457 | |||
1458 | |~remote\_host~~~~~~~~~~~~~~|~request\_uri~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|~ssl\_cipher~|~ssl\_keysize~|~ssl\_maxkeysize~| | ||
1459 | |||
1460 | +-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-+-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-{}-+~ | ||
1461 | |||
1462 | |~216.190.52.4~~~~~~~~~~~~~|~/dir/somefile.html~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|~RC4-MD5~~~~|~128~~~~~~~~~|~128~~~~~~~~~~~~|~ | ||
1463 | |||
1464 | |~216.190.52.4~~~~~~~~~~~~~|~/dir/somefile.gif~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|~RC4-MD5~~~~|~128~~~~~~~~~|~128~~~~~~~~~~~~|~ | ||
1465 | |||
1466 | |~216.190.52.4~~~~~~~~~~~~~|~/dir/somefile.jpg~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|~RC4-MD5~~~~|~128~~~~~~~~~|~128~~~~~~~~~~~~|~ | ||
1467 | |||
1468 | ...etc... | ||
1469 | \end{lyxcode} | ||
1470 | |||
1471 | \subsection{Does mod\_log\_sql connect to MySQL via TCP/IP or a socket?} | ||
1472 | |||
1473 | It depends! Actually this isn't determined by mod\_log\_sql. mod\_log\_sql | ||
1474 | relies on a connection command that is supplied in the MySQL API, | ||
1475 | and that command is somewhat intelligent. When mod\_log\_sql issues | ||
1476 | the connect command to MySQL, this intelligent connect command uses | ||
1477 | sockets to communicate with MySQL if the specified MySQL database | ||
1478 | is on the same machine (because sockets are more efficient than TCP/IP). | ||
1479 | However, if the specified MySQL db is on a different machine, mod\_log\_sql | ||
1480 | connects using TCP/IP. You don't have any control of which methodology | ||
1481 | is used. | ||
1482 | |||
1483 | You do have control over where mod\_log\_sql looks for the socket. | ||
1484 | The LogSQLSocketFile runtime configuration directive overrides the | ||
1485 | default of \char`\"{}/var/lib/mysql/mysql.sock\char`\"{} to whatever | ||
1486 | you wish. (Applies to mod\_log\_sql 1.16 or later only.) | ||
1487 | |||
1488 | |||
1489 | \subsection{Why do I occasionally see a \char`\"{}connection lost, attempting | ||
1490 | reconnect\char`\"{} message in my error-log?} | ||
1491 | |||
1492 | This message may appear every now and then in your Apache error log, | ||
1493 | especially on very lightly loaded servers. This doesn't mean that | ||
1494 | anything is necessarily wrong. Within each httpd child process, mod\_log\_sql | ||
1495 | will open (and keep open) a connection to the MySQL server. MySQL, | ||
1496 | however, will close connections that haven't been used in a while; | ||
1497 | the default timeout is 8 hours. When this occurs, mod\_log\_sql will | ||
1498 | notice and re-open the connection. That event is what is being logged, | ||
1499 | and looks like this: | ||
1500 | |||
1501 | \begin{lyxcode} | ||
1502 | {[}Thu~Dec~13~05:42:18~2001{]}~{[}error{]}~mod\_log\_sql:~connection~lost,~attempting~reconnect | ||
1503 | |||
1504 | {[}Thu~Dec~13~05:42:18~2001{]}~{[}error{]}~mod\_log\_sql:~reconnect~successful | ||
1505 | \end{lyxcode} | ||
1506 | Reference: MySQL documentation \url{http://www.mysql.com/documentation/mysql/bychapter/manual_Problems.html#Gone_away} | ||
1507 | |||
1508 | |||
1509 | \subsection{Does mod\_log\_sql work with Apache 2.x?} | ||
1510 | |||
1511 | As of this writing, no. The Apache Group significantly altered the | ||
1512 | module API with the release of Apache 2.0. All modules written for | ||
1513 | 1.3, including mod\_log\_sql, will not work with 2.0. | ||
1514 | |||
1515 | mod\_log\_sql will eventually be ported to Apache 2.x, but not immediately. | ||
1516 | It is going to take some time, and there are other features that have | ||
1517 | higher priority. Please sign up for the announcements list (on the | ||
1518 | main website) or monitor the website for updates to learn when the | ||
1519 | port (and other releases) are available. | ||
1520 | |||
1521 | <OPINION>If you're a {*}NIX user, stick with Apache 1.3.x for now. | ||
1522 | Major modules like mod\_ssl and PHP are not even ready for 2.0 yet, | ||
1523 | and the main benefits in 2.0 are for Win32 users anyway. Apache 1.3.x | ||
1524 | is rock-stable and performs equally well on {*}NIX as 2.0.</OPINION> | ||
1525 | |||
1526 | |||
1527 | \subsection{I have discovered a bug. Who can I contact?} | ||
1528 | |||
1529 | Please contact the maintainer \url{chris@grubbybaby.com}! Your comments, | ||
1530 | suggestions, bugfixes, bug catches, and usage testimonials are always | ||
1531 | welcome. As free software, mod\_log\_sql is intended to be a community | ||
1532 | effort -- any code contributions or other ideas will be fully and | ||
1533 | openly credited, of course. | ||
1534 | \end{document} | ||