You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@httpd.apache.org by zhang zhengquan <zh...@gmail.com> on 2009/04/03 22:45:47 UTC

[users@httpd] apache log directly to database

Dear apache community:

I am pretty new to apache and now I am confronted with a problem, I
would like to do download statistics for a huge access_log.  I can use
scripts to process it but it takes time. I wonder if ther is a log
daemon that can do auto parsing of the log file and do the data entry to
a database like mysql or etc...

Thanks for any pointers,

-- 
Zhengquan

---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org


Re: [users@httpd] apache log directly to database

Posted by zhang zhengquan <zh...@gmail.com>.
2009/4/3 John Armstrong <ja...@bepress.com>:
> You can use the mod log sql stuff
>
> Here is the debian package as an example:
>
> http://packages.debian.org/unstable/httpd/libapache2-mod-log-sql
>
> You can also use piped logs
>
> http://httpd.apache.org/docs/2.2/logs.html#piped
>
> John-
>
> On Fri, Apr 3, 2009 at 1:45 PM, zhang zhengquan
> <zh...@gmail.com> wrote:
>> Dear apache community:
>>
>> I am pretty new to apache and now I am confronted with a problem, I
>> would like to do download statistics for a huge access_log.  I can use
>> scripts to process it but it takes time. I wonder if ther is a log
>> daemon that can do auto parsing of the log file and do the data entry to
>> a database like mysql or etc...
>>
>> Thanks for any pointers,
>>
>> --
>> Zhengquan
>>
>> ---------------------------------------------------------------------
>> The official User-To-User support forum of the Apache HTTP Server Project.
>> See <URL:http://httpd.apache.org/userslist.html> for more info.
>> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
>>   "   from the digest: users-digest-unsubscribe@httpd.apache.org
>> For additional commands, e-mail: users-help@httpd.apache.org
>>
>>
>
>
>
> --
> John Armstrong
> Vice President, Engineering
> The Berkeley Electronic Press
> 510/665-1200 x160
> http://www.bepress.com/
>
> bepress: 10 years of accelerating and enhancing the flow of scholarly ideas
>
> ---------------------------------------------------------------------
> The official User-To-User support forum of the Apache HTTP Server Project.
> See <URL:http://httpd.apache.org/userslist.html> for more info.
> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
>   "   from the digest: users-digest-unsubscribe@httpd.apache.org
> For additional commands, e-mail: users-help@httpd.apache.org
>
>


Thanks, John, I will give them a go,

-- 
Zhengquan

---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org


Re: [users@httpd] apache log directly to database

Posted by John Armstrong <ja...@bepress.com>.
You can use the mod log sql stuff

Here is the debian package as an example:

http://packages.debian.org/unstable/httpd/libapache2-mod-log-sql

You can also use piped logs

http://httpd.apache.org/docs/2.2/logs.html#piped

John-

On Fri, Apr 3, 2009 at 1:45 PM, zhang zhengquan
<zh...@gmail.com> wrote:
> Dear apache community:
>
> I am pretty new to apache and now I am confronted with a problem, I
> would like to do download statistics for a huge access_log.  I can use
> scripts to process it but it takes time. I wonder if ther is a log
> daemon that can do auto parsing of the log file and do the data entry to
> a database like mysql or etc...
>
> Thanks for any pointers,
>
> --
> Zhengquan
>
> ---------------------------------------------------------------------
> The official User-To-User support forum of the Apache HTTP Server Project.
> See <URL:http://httpd.apache.org/userslist.html> for more info.
> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
>   "   from the digest: users-digest-unsubscribe@httpd.apache.org
> For additional commands, e-mail: users-help@httpd.apache.org
>
>



-- 
John Armstrong
Vice President, Engineering
The Berkeley Electronic Press
510/665-1200 x160
http://www.bepress.com/

bepress: 10 years of accelerating and enhancing the flow of scholarly ideas

---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org