[Apache] 아파치 로그 -> MySQL DB저장하기
작성일 13-03-07 09:18
페이지 정보
작성자서방님 조회 302회 댓글 0건본문
<아파치 이외의 바이너리 파일 이용 - LogToMysql - piped logging from Apache to MySQL> - 추천 1 (가장 직관적이고 간편해보임)
http://logtomysql.sourceforge.net
(현제 글 게시 시점의 최신 버전(v0.95)은 첨부파일로 첨부 처리)
<아파치 모듈 이용 - 1.3x, 2.0.x 문서> - mod_log_mysql.c - 추전 2
http://www.outoforder.cc/projects/apache/mod_log_sql
<아파치 모듈 이용 - 2.0.x 문서> - mod_log_sql
http://www.onlamp.com/pub/a/apache/2005/02/10/database_logs.html
- 검색결과, 가장 눈에 뛰는 것으로 위 3개를 모아 보았으며, 첫번째 것은 로컬, 리모트 모두 테스팅 되었음. 아래에 로컬 테스팅 결과 첨부
- 기타 다른 방법도 apache log mysql 로 검색해보면 많이 나옴.
* 1번 문서 테스팅 결과 (redhat9 + mysql 5.x + apache 1.3.x + php 4.x)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| maillog |
| mysql |
| snort |
| vpopmail |
| weblog |
+--------------------+
6 rows in set (0.03 sec)
mysql> use weblog;
Database changed
mysql> show tables;
+------------------+
| Tables_in_weblog |
+------------------+
| errorlog |
| log |
+------------------+
2 rows in set (0.00 sec)
mysql> select * from errorlog;
+---------------------+-------------------------------------------------------------------------------------------------------------------------+
| datetime | message |
+---------------------+-------------------------------------------------------------------------------------------------------------------------+
| 2006-09-28 15:51:20 | [Thu Sep 28 15:51:20 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:24 | [Thu Sep 28 15:51:24 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:25 | [Thu Sep 28 15:51:25 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:26 | [Thu Sep 28 15:51:26 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:26 | [Thu Sep 28 15:51:26 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:27 | [Thu Sep 28 15:51:27 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:28 | [Thu Sep 28 15:51:28 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:29 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:51:59 | [Thu Sep 28 15:51:29 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:52:06 | [Thu Sep 28 15:52:06 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:52:08 | [Thu Sep 28 15:52:08 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:52:10 | [Thu Sep 28 15:52:10 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:52:15 | [Thu Sep 28 15:52:15 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:52:16 | [Thu Sep 28 15:52:16 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:52:23 | [Thu Sep 28 15:52:23 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:52:24 | [Thu Sep 28 15:52:24 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:52:36 | [Thu Sep 28 15:52:36 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:52:38 | [Thu Sep 28 15:52:38 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:53:03 | [Thu Sep 28 15:53:03 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:53:04 | [Thu Sep 28 15:53:04 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:53:05 | [Thu Sep 28 15:53:05 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:53:19 | [Thu Sep 28 15:53:19 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:53:20 | [Thu Sep 28 15:53:20 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:53:20 | [Thu Sep 28 15:53:20 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:53:42 | [Thu Sep 28 15:53:42 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/acid_main.php |
| 2006-09-28 15:53:50 | [Thu Sep 28 15:53:50 2006] [error] [client 218.154.176.98] File does not exist: /home/365managed/public_html/index.html |
+---------------------+-------------------------------------------------------------------------------------------------------------------------+
56 rows in set (0.00 sec)
mysql> select * from log;
+----------------+------------------------------+--------------------------------+----------------------------------------+-----------------------------------------------------------------+-------+-----------+-----------+
| hostname | datetime | url | refer | agent | ident | resp_code | xfer_size |
+----------------+------------------------------+--------------------------------+----------------------------------------+-----------------------------------------------------------------+-------+-----------+-----------+
| 218.154.176.98 | [28/Sep/2006:15:50:46 +0900] | "GET / HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 200 | 169 |
| 218.154.176.98 | [28/Sep/2006:15:50:47 +0900] | "GET /acid_main.php HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 200 | 11573 |
| 218.154.176.98 | [28/Sep/2006:15:50:48 +0900] | "GET /acid_style.css HTTP/1.1" | "http://test.365managed.net/acid_main.php" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 304 | 0 |
| 218.154.176.98 | [28/Sep/2006:15:50:54 +0900] | "GET /acid_main.php HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 200 | 11572 |
| 218.154.176.98 | [28/Sep/2006:15:50:54 +0900] | "GET /acid_style.css HTTP/1.1" | "http://test.365managed.net/acid_main.php" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 304 | 0 |
| 218.154.176.98 | [28/Sep/2006:15:50:56 +0900] | "GET /acid_main.php HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 200 | 11572 |
| 218.154.176.98 | [28/Sep/2006:15:50:56 +0900] | "GET /acid_style.css HTTP/1.1" | "http://test.365managed.net/acid_main.php" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 304 | 0 |
| 218.154.176.98 | [28/Sep/2006:15:51:20 +0900] | "GET /acid_main.php HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 404 | 291 |
| 218.154.176.98 | [28/Sep/2006:15:51:24 +0900] | "GET /acid_main.php HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 404 | 291 |
| 218.154.176.98 | [28/Sep/2006:15:51:25 +0900] | "GET /acid_main.php HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 404 | 291 |
| 218.154.176.98 | [28/Sep/2006:15:51:26 +0900] | "GET /acid_main.php HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 404 | 291 |
| 218.154.176.98 | [28/Sep/2006:15:51:26 +0900] | "GET /acid_main.php HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 404 | 291 |
| 218.154.176.98 | [28/Sep/2006:15:51:27 +0900] | "GET /acid_main.php HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 404 | 291 |
| 218.154.176.98 | [28/Sep/2006:15:51:28 +0900] | "GET /acid_main.php HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 404 | 291 |
| 218.154.176.98 | [28/Sep/2006:15:51:29 +0900] | "GET /acid_main.php HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 404 | 291 |
| 218.154.176.98 | [28/Sep/2006:15:52:06 +0900] | "GET /acid_main.php HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 404 | 291 |
| 218.154.176.98 | [28/Sep/2006:15:52:08 +0900] | "GET /acid_main.php HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 404 | 291 |
| 218.154.176.98 | [28/Sep/2006:15:52:10 +0900] | "GET /acid_main.php HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 404 | 291 |
| 218.154.176.98 | [28/Sep/2006:15:52:15 +0900] | "GET /acid_main.php HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 404 | 291 |
| 218.154.176.98 | [28/Sep/2006:15:52:16 +0900] | "GET /acid_main.php HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 404 | 291 |
| 218.154.176.98 | [28/Sep/2006:15:52:23 +0900] | "GET /acid_main.php HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 404 | 291 |
| 218.154.176.98 | [28/Sep/2006:15:52:24 +0900] | "GET /acid_main.php HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 404 | 291 |
| 218.154.176.98 | [28/Sep/2006:15:52:36 +0900] | "GET /acid_main.php HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 404 | 291 |
| 218.154.176.98 | [28/Sep/2006:15:52:38 +0900] | "GET /acid_main.php HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 404 | 291 |
| 218.154.176.98 | [28/Sep/2006:15:53:03 +0900] | "GET /acid_main.php HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 404 | 291 |
| 218.154.176.98 | [28/Sep/2006:15:53:04 +0900] | "GET /acid_main.php HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 404 | 291 |
| 218.154.176.98 | [28/Sep/2006:15:53:05 +0900] | "GET /acid_main.php HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 404 | 291 |
| 218.154.176.98 | [28/Sep/2006:15:53:19 +0900] | "GET /acid_main.php HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 404 | 291 |
| 218.154.176.98 | [28/Sep/2006:15:53:20 +0900] | "GET /acid_main.php HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 404 | 291 |
| 218.154.176.98 | [28/Sep/2006:15:53:20 +0900] | "GET /acid_main.php HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 404 | 291 |
| 218.154.176.98 | [28/Sep/2006:15:53:42 +0900] | "GET /acid_main.php HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 404 | 291 |
| 218.154.176.98 | [28/Sep/2006:15:53:50 +0900] | "GET /index.html HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 404 | 288 |
| 218.154.176.98 | [28/Sep/2006:15:53:53 +0900] | "GET /index.php HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 200 | 7213 |
| 218.154.176.98 | [28/Sep/2006:15:53:56 +0900] | "GET /index.php HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 200 | 7213 |
| 218.154.176.98 | [28/Sep/2006:15:53:56 +0900] | "GET /index.php HTTP/1.1" | "-" | "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET C | - | 200 | 7213 |
+----------------+------------------------------+--------------------------------+----------------------------------------+-----------------------------------------------------------------+-------+-----------+-----------+
35 rows in set (0.00 sec)
mysql> select xfer_size from log;
+-----------+
| xfer_size |
+-----------+
| 169 |
| 11573 |
| 0 |
| 11572 |
| 0 |
| 11572 |
| 0 |
| 291 |
| 291 |
| 291 |
| 291 |
| 291 |
| 291 |
| 291 |
| 291 |
| 291 |
| 291 |
| 291 |
| 291 |
| 291 |
| 291 |
| 291 |
| 291 |
| 291 |
| 291 |
| 291 |
| 291 |
| 291 |
| 291 |
| 291 |
| 291 |
| 288 |
| 7213 |
| 7213 |
| 7213 |
+-----------+
35 rows in set (0.00 sec)
mysql> select datetime from log;
+------------------------------+
| datetime |
+------------------------------+
| [28/Sep/2006:15:50:46 +0900] |
| [28/Sep/2006:15:50:47 +0900] |
| [28/Sep/2006:15:50:48 +0900] |
| [28/Sep/2006:15:50:54 +0900] |
| [28/Sep/2006:15:50:54 +0900] |
| [28/Sep/2006:15:50:56 +0900] |
| [28/Sep/2006:15:50:56 +0900] |
| [28/Sep/2006:15:51:20 +0900] |
| [28/Sep/2006:15:51:24 +0900] |
| [28/Sep/2006:15:51:25 +0900] |
| [28/Sep/2006:15:51:26 +0900] |
| [28/Sep/2006:15:51:26 +0900] |
| [28/Sep/2006:15:51:27 +0900] |
| [28/Sep/2006:15:51:28 +0900] |
| [28/Sep/2006:15:51:29 +0900] |
| [28/Sep/2006:15:52:06 +0900] |
| [28/Sep/2006:15:52:08 +0900] |
| [28/Sep/2006:15:52:10 +0900] |
| [28/Sep/2006:15:52:15 +0900] |
| [28/Sep/2006:15:52:16 +0900] |
| [28/Sep/2006:15:52:23 +0900] |
| [28/Sep/2006:15:52:24 +0900] |
| [28/Sep/2006:15:52:36 +0900] |
| [28/Sep/2006:15:52:38 +0900] |
| [28/Sep/2006:15:53:03 +0900] |
| [28/Sep/2006:15:53:04 +0900] |
| [28/Sep/2006:15:53:05 +0900] |
| [28/Sep/2006:15:53:19 +0900] |
| [28/Sep/2006:15:53:20 +0900] |
| [28/Sep/2006:15:53:20 +0900] |
| [28/Sep/2006:15:53:42 +0900] |
| [28/Sep/2006:15:53:50 +0900] |
| [28/Sep/2006:15:53:53 +0900] |
| [28/Sep/2006:15:53:56 +0900] |
| [28/Sep/2006:15:53:56 +0900] |
+------------------------------+
35 rows in set (0.00 sec)
mysql> select url from log;
+--------------------------------+
| url |
+--------------------------------+
| "GET / HTTP/1.1" |
| "GET /acid_main.php HTTP/1.1" |
| "GET /acid_style.css HTTP/1.1" |
| "GET /acid_main.php HTTP/1.1" |
| "GET /acid_style.css HTTP/1.1" |
| "GET /acid_main.php HTTP/1.1" |
| "GET /acid_style.css HTTP/1.1" |
| "GET /acid_main.php HTTP/1.1" |
| "GET /acid_main.php HTTP/1.1" |
| "GET /acid_main.php HTTP/1.1" |
| "GET /acid_main.php HTTP/1.1" |
| "GET /acid_main.php HTTP/1.1" |
| "GET /acid_main.php HTTP/1.1" |
| "GET /acid_main.php HTTP/1.1" |
| "GET /acid_main.php HTTP/1.1" |
| "GET /acid_main.php HTTP/1.1" |
| "GET /acid_main.php HTTP/1.1" |
| "GET /acid_main.php HTTP/1.1" |
| "GET /acid_main.php HTTP/1.1" |
| "GET /acid_main.php HTTP/1.1" |
| "GET /acid_main.php HTTP/1.1" |
| "GET /acid_main.php HTTP/1.1" |
| "GET /acid_main.php HTTP/1.1" |
| "GET /acid_main.php HTTP/1.1" |
| "GET /acid_main.php HTTP/1.1" |
| "GET /acid_main.php HTTP/1.1" |
| "GET /acid_main.php HTTP/1.1" |
| "GET /acid_main.php HTTP/1.1" |
| "GET /acid_main.php HTTP/1.1" |
| "GET /acid_main.php HTTP/1.1" |
| "GET /acid_main.php HTTP/1.1" |
| "GET /index.html HTTP/1.1" |
| "GET /index.php HTTP/1.1" |
| "GET /index.php HTTP/1.1" |
| "GET /index.php HTTP/1.1" |
+--------------------------------+
35 rows in set (0.00 sec)
mysql> select refer from log;
+----------------------------------------+
| refer |
+----------------------------------------+
| "-" |
| "-" |
| "http://test.365managed.net/acid_main.php" |
| "-" |
| "http://test.365managed.net/acid_main.php" |
| "-" |
| "http://test.365managed.net/acid_main.php" |
| "-" |
| "-" |
| "-" |
| "-" |
| "-" |
| "-" |
| "-" |
| "-" |
| "-" |
| "-" |
| "-" |
| "-" |
| "-" |
| "-" |
| "-" |
| "-" |
| "-" |
| "-" |
| "-" |
| "-" |
| "-" |
| "-" |
| "-" |
| "-" |
| "-" |
| "-" |
| "-" |
| "-" |
+----------------------------------------+
35 rows in set (0.00 sec)
* 위와 같이 기본적인 로그를 전체 또는 필드별로 구분할수 있고, 필요에 따라 logtomysql.c 소스 수정과 mysql 테이블 수정을 통해 원하는 입맛대로 로깅을 DB에 저장할수 있을것이다.
첨부파일
- LogToMySQL_0.95.tar.gz (30.9K) 1회 다운로드 | DATE : 2013-03-07 09:18:48
댓글목록
등록된 댓글이 없습니다.