配置tomcat 将详细日志写入mysql数据库

参考:

http://tomcat.apache.org/tomcat-6.0-doc/api/org/apache/catalina/valves/JDBCAccessLogValve.html

 

 

 

 

conf/server.xml

 

      <Host name="www.xx888.com"  appBase="D:/opt/Tomcat/xx888"
            unpackWARs="false" autoDeploy="false"
            xmlValidation="false" xmlNamespaceAware="false">
        <Valve className="org.apache.catalina.valves.JDBCAccessLogValve "
                driverName="com.mysql.jdbc.Driver"
                connectionURL="jdbc:mysql://localhost:3306/xx888"
                connectionName ="root"
                connectionPassword="123456789 "
                tableName = "tomcat_access"
                pattern="combined"
                   resolveHosts="false"
                   />
      </Host>

 

 

 

mysql中建立表:

CREATE TABLE tomcat_access (

 id INT UNSIGNED AUTO_INCREMENT NOT NULL,
 remoteHost CHAR(15) NOT NULL,
 userName CHAR(15),
 timestamp TIMESTAMP NOT NULL,
 virtualHost VARCHAR(64) NOT NULL,
 method VARCHAR(8) NOT NULL,
 query VARCHAR(255) NOT NULL,
 status SMALLINT UNSIGNED NOT NULL,
 bytes INT UNSIGNED NOT NULL,
 referer VARCHAR(300),
 userAgent VARCHAR(300),
 PRIMARY KEY (id),
 INDEX (timestamp),
 INDEX (remoteHost),
 INDEX (virtualHost),
 INDEX (query),
 INDEX (userAgent)
 );

 

 

 

mysql jdbc jar文件放到相应的目录,这个自不必说了.