Парсер csv-файла

Регулярное выражение для разбивки файла access_log

Параметры файла: текстовый, разделитель между полями - пробел, текстовые типы заключены в двойные кавычки, дата - в квадратные скобки.

\s".+?"|\s\[.+?\]|\s*[^ ]+

Собранную статистику "плохих" (статус 303 и 403) запросов можно посмотреть тут. Система "отсечения" срабатывает один раз в день на один "плохой" запрос и вносит URL с параметрами в статистику. На один день блокируются запросы с выловленного IP. На следующий день доступ опять появляется.

Пример вывода данных

строк в файле: 79 [27-07-2024 10:31:54]

IPURL
3.139.85.161 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /articles/nastroyka-nntp-servera-inn2/ HTTP/1.0" [27/Jul/2024:06:29:16 +0300]
3.17.159.48 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /articles/invert-color/ HTTP/1.0" [27/Jul/2024:06:34:22 +0300]
213.180.203.159 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET / HTTP/1.0" [27/Jul/2024:06:34:32 +0300]
18.118.146.169 +*
  • status: 200 - 2
url: 2
  1. 200 - 2
    • "GET /articles/command-line-1s8/ HTTP/1.0" [27/Jul/2024:06:34:33 +0300]
    • "GET /articles/pryamoy-dostup-cherez-ODBC/ HTTP/1.0" [27/Jul/2024:06:53:43 +0300]
213.180.203.224 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET / HTTP/1.0" [27/Jul/2024:06:34:53 +0300]
95.163.255.62 +*
  • status: 200 - 2
url: 2
  1. 200 - 2
    • "GET /articles/urlencode/ HTTP/1.0" [27/Jul/2024:06:43:57 +0300]
    • "GET /articles/jquery-selektory/ HTTP/1.0" [27/Jul/2024:08:18:17 +0300]
3.138.69.153 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /articles/kak-vybrat-dvijok-dlya-sayta/ HTTP/1.0" [27/Jul/2024:06:44:18 +0300]
195.2.78.191 +*
  • status: 200 - 4
url: 4
  1. 200 - 4
    • "GET /articles/pryamoy-dostup-cherez-ODBC/ HTTP/1.0" [27/Jul/2024:06:45:53 +0300]
    • "GET /contacts/ HTTP/1.0" [27/Jul/2024:06:45:53 +0300]
    • "GET /articles/pryamoy-dostup-cherez-ODBC/ HTTP/1.0" [27/Jul/2024:07:47:48 +0300]
    • "GET /contacts/ HTTP/1.0" [27/Jul/2024:07:47:48 +0300]
23.22.35.162 +*
  • status: 301 - 1
url: 1
  1. 301 - 1
    • "GET /doroga-k-domu/ HTTP/1.0" [27/Jul/2024:06:52:54 +0300]
198.235.24.37 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET / HTTP/1.0" [27/Jul/2024:06:55:03 +0300]
66.249.74.71 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /sitemap/ HTTP/1.0" [27/Jul/2024:06:55:03 +0300]
3.149.23.112 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /tools/file-list-vbs/ HTTP/1.0" [27/Jul/2024:07:15:37 +0300]
79.134.37.138 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /favicon.ico?v=1 HTTP/1.0" [27/Jul/2024:07:18:04 +0300]
51.254.49.99 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET / HTTP/1.0" [27/Jul/2024:07:20:14 +0300]
3.17.176.60 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /tools/bank-tinkoff/ HTTP/1.0" [27/Jul/2024:07:35:49 +0300]
213.180.203.47 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET / HTTP/1.0" [27/Jul/2024:07:44:16 +0300]
66.249.74.70 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /articles/nastroyka-nntp-servera-inn2/ HTTP/1.0" [27/Jul/2024:07:54:11 +0300]
216.244.66.194 +*
  • status: 303 - 1
url: 1
  1. 303 - 1
    • "GET /img/red_doc.png HTTP/1.0" [27/Jul/2024:07:56:13 +0300]
95.108.213.183 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET / HTTP/1.0" [27/Jul/2024:08:08:55 +0300]
95.163.255.65 +*
  • status: 200 - 2
url: 2
  1. 200 - 2
    • "GET /download/1S77/Redaktor_spravochnikov/ HTTP/1.0" [27/Jul/2024:08:20:46 +0300]
    • "GET /reg/ HTTP/1.0" [27/Jul/2024:10:30:39 +0300]
185.231.154.128 +*
  • status: 200 - 6
url: 6
  1. 200 - 6
    • "GET /articles/pryamoy-dostup-cherez-ODBC/ HTTP/1.0" [27/Jul/2024:08:20:47 +0300]
    • "GET /contacts/ HTTP/1.0" [27/Jul/2024:08:20:47 +0300]
    • "GET /articles/pryamoy-dostup-cherez-ODBC/ HTTP/1.0" [27/Jul/2024:08:48:35 +0300]
    • "GET /contacts/ HTTP/1.0" [27/Jul/2024:08:48:35 +0300]
    • "GET /articles/pryamoy-dostup-cherez-ODBC/ HTTP/1.0" [27/Jul/2024:10:02:41 +0300]
    • "GET /contacts/ HTTP/1.0" [27/Jul/2024:10:02:41 +0300]
95.142.47.113 +*
  • status: 200 - 2
url: 2
  1. 200 - 2
    • "GET /articles/pryamoy-dostup-cherez-ODBC/ HTTP/1.0" [27/Jul/2024:08:24:52 +0300]
    • "GET /contacts/ HTTP/1.0" [27/Jul/2024:08:24:52 +0300]
213.87.86.195 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /articles/regulyarnye-vyrajeniya/ HTTP/1.0" [27/Jul/2024:08:27:08 +0300]
176.57.188.111 +*
  • status: 301 - 1
url: 1
  1. 301 - 1
    • "POST / HTTP/1.0" [27/Jul/2024:08:28:42 +0300]
62.113.98.116 +*
  • status: 303 - 1
  • status: 200 - 1
url: 2
  1. 303 - 1
    • "GET /tools/free-man HTTP/1.0" [27/Jul/2024:08:34:58 +0300]
  2. 200 - 1
    • "GET /tools/free-man/ HTTP/1.0" [27/Jul/2024:08:34:58 +0300]
95.108.213.107 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET / HTTP/1.0" [27/Jul/2024:08:44:46 +0300]
62.113.113.162 +*
  • status: 200 - 2
url: 2
  1. 200 - 2
    • "GET /articles/pryamoy-dostup-cherez-ODBC/ HTTP/1.0" [27/Jul/2024:09:08:35 +0300]
    • "GET /contacts/ HTTP/1.0" [27/Jul/2024:09:08:35 +0300]
46.41.79.38 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /tools/convert/ HTTP/1.0" [27/Jul/2024:09:13:59 +0300]
18.116.15.3 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /download/1S77/skopirovat-podchinennye-elementy/ HTTP/1.0" [27/Jul/2024:09:24:13 +0300]
5.255.231.181 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET / HTTP/1.0" [27/Jul/2024:09:24:52 +0300]
178.20.45.159 +*
  • status: 200 - 2
url: 2
  1. 200 - 2
    • "GET /articles/pryamoy-dostup-cherez-ODBC/ HTTP/1.0" [27/Jul/2024:09:27:54 +0300]
    • "GET /contacts/ HTTP/1.0" [27/Jul/2024:09:27:54 +0300]
40.77.167.43 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /articles/mysql-set/ HTTP/1.0" [27/Jul/2024:09:28:34 +0300]
3.12.155.235 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /download/1S77/gruppirovschik-otchetov/ HTTP/1.0" [27/Jul/2024:09:28:47 +0300]
3.142.197.212 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /articles/ascii/ HTTP/1.0" [27/Jul/2024:09:34:12 +0300]
90.188.191.65 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /tools/free-man/ HTTP/1.0" [27/Jul/2024:09:35:32 +0300]
18.118.207.183 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /tools/free-man/ HTTP/1.0" [27/Jul/2024:09:38:54 +0300]
178.20.43.173 +*
  • status: 200 - 2
url: 2
  1. 200 - 2
    • "GET /articles/pryamoy-dostup-cherez-ODBC/ HTTP/1.0" [27/Jul/2024:09:39:51 +0300]
    • "GET /contacts/ HTTP/1.0" [27/Jul/2024:09:39:55 +0300]
3.147.69.132 +*
  • status: 200 - 2
url: 2
  1. 200 - 2
    • "GET /articles/1s8-subkonto/ HTTP/1.0" [27/Jul/2024:09:41:21 +0300]
    • "GET /articles/urlencode/ HTTP/1.0" [27/Jul/2024:10:27:33 +0300]
18.117.11.176 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /articles/mysql-date-function/ HTTP/1.0" [27/Jul/2024:09:42:21 +0300]
3.22.240.53 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /articles/key-code/ HTTP/1.0" [27/Jul/2024:09:47:56 +0300]
3.147.7.185 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /articles/palitra-excel/ HTTP/1.0" [27/Jul/2024:09:51:30 +0300]
3.12.120.25 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /tools/rnd/ HTTP/1.0" [27/Jul/2024:09:51:33 +0300]
18.118.164.187 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /tools/xml-parser/ HTTP/1.0" [27/Jul/2024:09:52:00 +0300]
195.2.74.148 +*
  • status: 200 - 2
url: 2
  1. 200 - 2
    • "GET /articles/pryamoy-dostup-cherez-ODBC/ HTTP/1.0" [27/Jul/2024:09:54:58 +0300]
    • "GET /contacts/ HTTP/1.0" [27/Jul/2024:09:54:58 +0300]
185.231.155.169 +*
  • status: 200 - 6
url: 6
  1. 200 - 6
    • "GET /articles/pryamoy-dostup-cherez-ODBC/ HTTP/1.0" [27/Jul/2024:10:01:57 +0300]
    • "GET /contacts/ HTTP/1.0" [27/Jul/2024:10:01:57 +0300]
    • "GET /articles/pryamoy-dostup-cherez-ODBC/ HTTP/1.0" [27/Jul/2024:10:30:15 +0300]
    • "GET /contacts/ HTTP/1.0" [27/Jul/2024:10:30:15 +0300]
    • "GET /articles/pryamoy-dostup-cherez-ODBC/ HTTP/1.0" [27/Jul/2024:10:30:49 +0300]
    • "GET /contacts/ HTTP/1.0" [27/Jul/2024:10:30:50 +0300]
36.226.208.80 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET / HTTP/1.0" [27/Jul/2024:10:05:57 +0300]
84.17.48.76 +*
  • status: 404 - 1
url: 1
  1. 404 - 1
    • "GET // HTTP/1.0" [27/Jul/2024:10:07:05 +0300]
3.145.46.4 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /download/1S77/Obrabotchik-dokumentov/ HTTP/1.0" [27/Jul/2024:10:07:25 +0300]
18.118.140.155 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /articles/maximum-length-mysql-int-field-types/ HTTP/1.0" [27/Jul/2024:10:08:12 +0300]
3.145.171.111 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /tools/ HTTP/1.0" [27/Jul/2024:10:08:37 +0300]
87.250.224.236 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET / HTTP/1.0" [27/Jul/2024:10:09:15 +0300]
3.135.192.97 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /articles/jquery-selektory/ HTTP/1.0" [27/Jul/2024:10:11:02 +0300]
18.224.52.125 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /articles/maximum-length-mysql-text-field-types/ HTTP/1.0" [27/Jul/2024:10:24:10 +0300]
3.128.30.45 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /articles/ HTTP/1.0" [27/Jul/2024:10:26:38 +0300]
18.224.44.21 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /download/1S77/redaktor-dokumentov/ HTTP/1.0" [27/Jul/2024:10:28:36 +0300]
3.146.176.223 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /tools/pdf-reader/ HTTP/1.0" [27/Jul/2024:10:30:32 +0300]

Статсистика URL

URLCount
/articles/invert-color/1
/articles/command-line-1s8/1
/articles/kak-vybrat-dvijok-dlya-sayta/1
/doroga-k-domu/1
/sitemap/1
/tools/file-list-vbs/1
/favicon.ico1
/tools/bank-tinkoff/1
/img/red_doc.png1
/download/1S77/Redaktor_spravochnikov/1
/articles/regulyarnye-vyrajeniya/1
/tools/free-man1
/tools/convert/1
/download/1S77/skopirovat-podchinennye-elementy/1
/articles/mysql-set/1
/download/1S77/gruppirovschik-otchetov/1
/articles/ascii/1
/articles/1s8-subkonto/1
/articles/mysql-date-function/1
/articles/key-code/1
/articles/palitra-excel/1
/tools/rnd/1
/tools/xml-parser/1
//1
/download/1S77/Obrabotchik-dokumentov/1
/articles/maximum-length-mysql-int-field-types/1
/tools/1
/articles/maximum-length-mysql-text-field-types/1
/articles/1
/download/1S77/redaktor-dokumentov/1
/tools/pdf-reader/1
/reg/1
/articles/nastroyka-nntp-servera-inn2/2
/articles/urlencode/2
/articles/jquery-selektory/2
/tools/free-man/3
/11
/contacts/13
/articles/pryamoy-dostup-cherez-ODBC/14

Хронометраж IP

IPдата/время
3.139.85.161 [27/Jul/2024:06:29:16 +0300]
3.17.159.48 [27/Jul/2024:06:34:22 +0300]
213.180.203.159 [27/Jul/2024:06:34:32 +0300]
213.180.203.224 [27/Jul/2024:06:34:53 +0300]
3.138.69.153 [27/Jul/2024:06:44:18 +0300]
23.22.35.162 [27/Jul/2024:06:52:54 +0300]
18.118.146.169 [27/Jul/2024:06:53:43 +0300]
198.235.24.37 [27/Jul/2024:06:55:03 +0300]
66.249.74.71 [27/Jul/2024:06:55:03 +0300]
3.149.23.112 [27/Jul/2024:07:15:37 +0300]
79.134.37.138 [27/Jul/2024:07:18:04 +0300]
51.254.49.99 [27/Jul/2024:07:20:14 +0300]
3.17.176.60 [27/Jul/2024:07:35:49 +0300]
213.180.203.47 [27/Jul/2024:07:44:16 +0300]
195.2.78.191 [27/Jul/2024:07:47:48 +0300]
66.249.74.70 [27/Jul/2024:07:54:11 +0300]
216.244.66.194 [27/Jul/2024:07:56:13 +0300]
95.108.213.183 [27/Jul/2024:08:08:55 +0300]
95.163.255.62 [27/Jul/2024:08:18:17 +0300]
95.142.47.113 [27/Jul/2024:08:24:52 +0300]
213.87.86.195 [27/Jul/2024:08:27:08 +0300]
176.57.188.111 [27/Jul/2024:08:28:42 +0300]
62.113.98.116 [27/Jul/2024:08:34:58 +0300]
95.108.213.107 [27/Jul/2024:08:44:46 +0300]
62.113.113.162 [27/Jul/2024:09:08:35 +0300]
46.41.79.38 [27/Jul/2024:09:13:59 +0300]
18.116.15.3 [27/Jul/2024:09:24:13 +0300]
5.255.231.181 [27/Jul/2024:09:24:52 +0300]
178.20.45.159 [27/Jul/2024:09:27:54 +0300]
40.77.167.43 [27/Jul/2024:09:28:34 +0300]
3.12.155.235 [27/Jul/2024:09:28:47 +0300]
3.142.197.212 [27/Jul/2024:09:34:12 +0300]
90.188.191.65 [27/Jul/2024:09:35:32 +0300]
18.118.207.183 [27/Jul/2024:09:38:54 +0300]
178.20.43.173 [27/Jul/2024:09:39:55 +0300]
18.117.11.176 [27/Jul/2024:09:42:21 +0300]
3.22.240.53 [27/Jul/2024:09:47:56 +0300]
3.147.7.185 [27/Jul/2024:09:51:30 +0300]
3.12.120.25 [27/Jul/2024:09:51:33 +0300]
18.118.164.187 [27/Jul/2024:09:52:00 +0300]
195.2.74.148 [27/Jul/2024:09:54:58 +0300]
185.231.154.128 [27/Jul/2024:10:02:41 +0300]
36.226.208.80 [27/Jul/2024:10:05:57 +0300]
84.17.48.76 [27/Jul/2024:10:07:05 +0300]
3.145.46.4 [27/Jul/2024:10:07:25 +0300]
18.118.140.155 [27/Jul/2024:10:08:12 +0300]
3.145.171.111 [27/Jul/2024:10:08:37 +0300]
87.250.224.236 [27/Jul/2024:10:09:15 +0300]
3.135.192.97 [27/Jul/2024:10:11:02 +0300]
18.224.52.125 [27/Jul/2024:10:24:10 +0300]
3.128.30.45 [27/Jul/2024:10:26:38 +0300]
3.147.69.132 [27/Jul/2024:10:27:33 +0300]
18.224.44.21 [27/Jul/2024:10:28:36 +0300]
3.146.176.223 [27/Jul/2024:10:30:32 +0300]
95.163.255.65 [27/Jul/2024:10:30:39 +0300]
185.231.155.169 [27/Jul/2024:10:30:50 +0300]

Вход


Регистрация