[Apache] 아파치 로그 -> MySQL DB저장하기 > php

본문 바로가기
사이트 내 전체검색

php

[Apache] 아파치 로그 -> MySQL DB저장하기

페이지 정보

작성자 서방님 댓글 0건 조회 86회 작성일 13-03-07 09:18

본문

[Apache] 아파치 로그 -> MySQL DB저장하기 문서

<아파치 이외의 바이너리 파일 이용 - 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에 저장할수 있을것이다.

첨부파일

댓글목록

등록된 댓글이 없습니다.

Total 612건 29 페이지
php 목록
번호 제목 글쓴이 조회 날짜
192
에러/예외를 set_error_handler(), set_exception_handler()로 커스텀 처리 …
서방님 96 03-07
191
DB 관련 에러가 날때 include로 이쁜 페이지 보여주기]
서방님 110 03-07
190
웹앱
서방님 0 03-07
189
사이트 로딩스피드 확인하기
서방님 106 03-07
188
.htaccess 파일을 이용한 404 오류 페이지 만들기 댓글+ 1개
서방님 108 03-07
187
codeigniter, 시간 내서 확인해 볼 것!
서방님 96 03-07
186
PHP 에러로그
서방님 0 03-07
열람중
[Apache] 아파치 로그 -> MySQL DB저장하기
서방님 87 03-07
184
PHP display_errors = off 상태에서 에러 보기 [커스텀 에러 설정]
서방님 79 03-07
183
로깅(Logging) 전략
서방님 0 03-07
182
PHP mysql 5.0용 DB class (자동오류 저장지원)
서방님 117 03-07
181
웹페이지 로딩시간 체크 툴
서방님 132 02-18
180
PHP Mysql연동, DB 연결 해제, 소멸
서방님 86 02-15
179
crontab, 스케쥴러
서방님 107 02-13
178
서버 호스팅이 아닌 웹호스팅에서도 '크론(cron)'활용이 가능하다? _ 카페24 호스팅 매뉴얼
서방님 0 02-13
게시물 검색

notice

회원로그인

접속자집계

오늘
229
어제
225
최대
1,347
전체
154,988
Latest Crypto Fear & Greed Index
그누보드5
Copyright © 서방님.kr All rights reserved.