ApacheLogToDB

ApacheLogToDB will provide developers with the right set of highly customizable tools to rapidly get the Apache server log to a database of their very own choice.

With ApacheLogToDB, you will be required to perform a few tasks once and then everything will be automated. All you have to do is deploy ApacheLogToDB in the BIN folder of your Apache server installation, choose the log format that best suits your preferences, enable logging in the httpd.conf file and define the newly selected log format.

The next part of the configuration process only takes a couple of minutes and here are the ApacheLogToDB.conf.xml available settings you might need to accomplish it: · dbType - Database system. Supported values are sqlsrv (Microsoft SQL Server) or mysql (MySQL). Default is sqlsrv. · dbHost - Name of the instance of SQL Server to which to connect. Default is localhost. Please, note that if SQL Server was installed as a named instance, dbHost must be specified as .\ or \. This particularly concerns SQL Server Express instances. Port can be specified as localhost:3306 · dbName - Name of the database in which log records must be stored. · dbTable - Name of the table in which log records must be stored. · dbUser - Login name of the database user. This user must have sufficient rights to create table, to write data into that table and (for SQL Server users) to use "dbo" scheme. To utilize Windows authentication, please, use the following format \;Integrated Security=SSPI · dbPassword - Database user's password. · apacheLogFormat - Log format string like |%h|%l|%u|%t|%r|%>s|%b, that was specified in Apache's configuration file. · maxParamLength - If any log record's parameter exceeds this number of characters, the overhead will be cut off. Default is 255. If maxParamLength is set to 0, no cutting occurs.