diff options
| author | 2002-01-15 18:40:14 +0000 | |
|---|---|---|
| committer | 2002-01-15 18:40:14 +0000 | |
| commit | ec06ba32ef1bfb3de7fd87ddc9c43468d5f5684e (patch) | |
| tree | 27ad8ccbf63b1ef08225c0086da04d927a9daae9 /INSTALL | |
| parent | cb854fe3e61b2590aeede8e6e94ee9feda919800 (diff) | |
Ported to mysql_real_connect, made a change for the mass-virtual-hosting1.13
folks, and enabled a socket name DEFINE.
Diffstat (limited to 'INSTALL')
| -rw-r--r-- | INSTALL | 33 |
1 files changed, 16 insertions, 17 deletions
| @@ -1,4 +1,4 @@ | |||
| 1 | $Id: INSTALL,v 1.3 2002/01/02 20:47:44 helios Exp $ | 1 | $Id: INSTALL,v 1.4 2002/01/15 18:40:14 helios Exp $ |
| 2 | 2 | ||
| 3 | 3 | ||
| 4 | Requirements | 4 | Requirements |
| @@ -31,10 +31,7 @@ Requirements | |||
| 31 | Installation (as an Apache DSO) | 31 | Installation (as an Apache DSO) |
| 32 | =============================== | 32 | =============================== |
| 33 | 33 | ||
| 34 | For folks interested in using this module as an Apache DSO, these | 34 | For folks interested in using this module as an Apache DSO: |
| 35 | instructions are currently UNTESTED but should work. (I would be | ||
| 36 | grateful to hear back from a DSO user as to my accuracy with these | ||
| 37 | instructions.) | ||
| 38 | 35 | ||
| 39 | 0) Perform all the following steps as root so that you have install | 36 | 0) Perform all the following steps as root so that you have install |
| 40 | privs, etc. | 37 | privs, etc. |
| @@ -44,7 +41,10 @@ instructions.) | |||
| 44 | # tar zxf mod_log_mysql.tar.gz -C /usr/local/src | 41 | # tar zxf mod_log_mysql.tar.gz -C /usr/local/src |
| 45 | # cd /usr/local/src/mod_log_mysql | 42 | # cd /usr/local/src/mod_log_mysql |
| 46 | 43 | ||
| 47 | 2) Instruct apxs to compile and install the module as a DSO. You need | 44 | 2) Edit Makefile and make any adjustments for your system. These are |
| 45 | fully explained in the Makefile. | ||
| 46 | |||
| 47 | 3) Instruct apxs to compile and install the module as a DSO. You need | ||
| 48 | to know two things before you run apxs: | 48 | to know two things before you run apxs: |
| 49 | - The location of the apxs binary, find using 'locate apxs' | 49 | - The location of the apxs binary, find using 'locate apxs' |
| 50 | - The location of your MySQL libraries, find using 'locate libmysqlclient' | 50 | - The location of your MySQL libraries, find using 'locate libmysqlclient' |
| @@ -57,13 +57,14 @@ instructions.) | |||
| 57 | ld -Bshareable -o mod_log_mysql.so mod_log_mysql.o | 57 | ld -Bshareable -o mod_log_mysql.so mod_log_mysql.o |
| 58 | cp mod_log_mysql.so <your path to Apache libexec>/mod_log_mysql.so | 58 | cp mod_log_mysql.so <your path to Apache libexec>/mod_log_mysql.so |
| 59 | chmod 755 <your path to Apache libexec>/mod_log_mysql.so | 59 | chmod 755 <your path to Apache libexec>/mod_log_mysql.so |
| 60 | [activating module foo' in /path/to/apache/etc/httpd.conf] | 60 | [activating module blah in /path/to/apache/etc/httpd.conf] |
| 61 | 61 | ||
| 62 | 3) Now go to step (9) in the instructions below to configure httpd.conf... | 62 | 4) Now go to step (9) in the instructions below to configure httpd.conf... |
| 63 | 63 | ||
| 64 | 64 | ||
| 65 | Installation (as a static module compiled into httpd) | 65 | Installation (as a static module compiled into httpd) |
| 66 | ===================================================== | 66 | ===================================================== |
| 67 | |||
| 67 | [This is what I do, FYI.] | 68 | [This is what I do, FYI.] |
| 68 | 69 | ||
| 69 | 0) Perform all the following steps as root so that you have install | 70 | 0) Perform all the following steps as root so that you have install |
| @@ -74,10 +75,8 @@ Installation (as a static module compiled into httpd) | |||
| 74 | # tar zxf mod_log_mysql.tar.gz -C /usr/local/src | 75 | # tar zxf mod_log_mysql.tar.gz -C /usr/local/src |
| 75 | # cd /usr/local/src/mod_log_mysql | 76 | # cd /usr/local/src/mod_log_mysql |
| 76 | 77 | ||
| 77 | 2) Edit Makefile and make any adjustments for your system: make sure | 78 | 2) Edit Makefile and make any adjustments for your system. These are |
| 78 | that APACHEDIR points to the location of your Apache source code, | 79 | fully explained in the Makefile. |
| 79 | and that CFLAGS points to the location of your Apache installation | ||
| 80 | directory (where your httpd binary lives). | ||
| 81 | 80 | ||
| 82 | 3) # make all | 81 | 3) # make all |
| 83 | (You should receive NO warnings or errors of any kind. | 82 | (You should receive NO warnings or errors of any kind. |
| @@ -133,8 +132,8 @@ Installation (as a static module compiled into httpd) | |||
| 133 | # cp -f ./httpd /usr/local/Apache/bin/ | 132 | # cp -f ./httpd /usr/local/Apache/bin/ |
| 134 | 133 | ||
| 135 | 9) Configure your apache daemon to log to your database. Here's a very | 134 | 9) Configure your apache daemon to log to your database. Here's a very |
| 136 | basic set of config lines to start you off. Full docs on them are | 135 | basic set of config lines to start you off. Full documentation is |
| 137 | included after this section. | 136 | available here: http://www.grubbybaby.com/mod_log_mysql/directives.html |
| 138 | 137 | ||
| 139 | EXAMPLE: Connect to the MySQL database called "apache" running | 138 | EXAMPLE: Connect to the MySQL database called "apache" running |
| 140 | on "dbmachine.foo.com". The module uses username "loguser" and | 139 | on "dbmachine.foo.com". The module uses username "loguser" and |
| @@ -157,7 +156,7 @@ Installation (as a static module compiled into httpd) | |||
| 157 | </VirtualHost> | 156 | </VirtualHost> |
| 158 | 157 | ||
| 159 | 158 | ||
| 160 | 9a) For users who have a DSO-enabled httpd: | 159 | 9a) Special step for users who have a DSO-enabled httpd: |
| 161 | 160 | ||
| 162 | If you you are building mod_log_mysql as a static module BUT | 161 | If you you are building mod_log_mysql as a static module BUT |
| 163 | your httpd is enabled for DSOs, add the following line to your | 162 | your httpd is enabled for DSOs, add the following line to your |
| @@ -186,9 +185,9 @@ Installation (as a static module compiled into httpd) | |||
| 186 | mysql> source access_log.sql | 185 | mysql> source access_log.sql |
| 187 | 186 | ||
| 188 | 187 | ||
| 189 | 11) Create a specific mysql userid that httpd will use to authenticate | 188 | 11) Create a specific MySQL userid that httpd will use to authenticate |
| 190 | and enter data. This userid need not be an actual Unix user. It | 189 | and enter data. This userid need not be an actual Unix user. It |
| 191 | is a userid specific to mysql with specific privileges. To create a | 190 | is a userid internal to MySQL with specific privileges. To create a |
| 192 | user called "loguser" with the password "l0gger" with only the | 191 | user called "loguser" with the password "l0gger" with only the |
| 193 | capability of INSERT to "access_log": | 192 | capability of INSERT to "access_log": |
| 194 | 193 | ||
