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

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

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

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

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

Господа горе-хакеры, даю подсказку - движок для этого сайта сделан точно не на базе wordpress, пожалуйста не тратьте своё время проверяя дырки wordpress, а то уже становится скучно.

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

Доступ к файлу статистики: 0600

строк в файле: 37 [11-07-2025 09:09:07]

IPURL
66.249.70.138 +*
  • status: 200 - 2
url: 2
  1. 200 - 2
    • "GET / HTTP/1.0" [11/Jul/2025:06:26:26 +0300] 18326 "-" "Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.7151.103 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
    • "GET /articles/report-to-web/ HTTP/1.0" [11/Jul/2025:08:09:30 +0300] 12880 "-" "Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.7151.103 Mobile Safari/537.36 (compatible; GoogleOther)"
2a11:bcc6:944:1de5:41c7:bd00:3bec:fed3 +*
  • status: 200 - 2
url: 2
  1. 200 - 2
    • "GET /?ysclid=mapedaynum565718067&utm_referrer=https://ya.ru/ HTTP/1.0" [11/Jul/2025:06:39:27 +0300] 18436 "-" "Mozilla/5.0 (Linux; Android 11; SM-A226B) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.7103.60 Mobile Safari/537.36"
    • "GET /favicon.ico?v=1 HTTP/1.0" [11/Jul/2025:06:39:28 +0300] 122 "https://baco.su/?ysclid=mapedaynum565718067&utm_referrer=https://ya.ru/" "Mozilla/5.0 (Linux; Android 11; SM-A226B) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.7103.60 Mobile Safari/537.36"
47.128.122.121 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /download/1S77/skopirovat-podchinennye-elementy/ HTTP/1.0" [11/Jul/2025:07:08:41 +0300] 11767 "-" "Mozilla/5.0 (Linux; Android 5.0) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; TikTokSpider; ttspider-feedback@tiktok.com)"
207.32.148.176 +*
  • status: 303 - 1
url: 1
  1. 303 - 1
    • "GET /shop/img/shop/logoff.jpg HTTP/1.0" [11/Jul/2025:07:11:50 +0300] 247 "https://www.google.com/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:72.0) Gecko/20100101 Firefox/72.0"
104.194.192.61 +*
  • status: 301 - 1
url: 1
  1. 301 - 1
    • "GET /shop/img/shop/logoff.jpg/ HTTP/1.0" [11/Jul/2025:07:11:53 +0300] 223 "https://www.google.com/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:72.0) Gecko/20100101 Firefox/72.0"
194.110.210.94 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET / HTTP/1.0" [11/Jul/2025:07:11:55 +0300] 18233 "https://www.google.com/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:72.0) Gecko/20100101 Firefox/72.0"
77.88.9.138 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET / HTTP/1.0" [11/Jul/2025:07:12:13 +0300] 18160 "-" "Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)"
87.250.233.1 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET / HTTP/1.0" [11/Jul/2025:07:12:14 +0300] 18333 "-" "Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)"
5.255.251.129 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET / HTTP/1.0" [11/Jul/2025:07:12:16 +0300] 18289 "-" "Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)"
77.88.9.1 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET / HTTP/1.0" [11/Jul/2025:07:12:18 +0300] 18409 "-" "Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)"
94.156.177.35 ++
  • status: 403 - 1
url: 1
  1. 403 - 1
    • "HEAD /bacosu.sql HTTP/1.0" [11/Jul/2025:07:12:19 +0300] - "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36"
156.244.31.210 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET / HTTP/1.0" [11/Jul/2025:07:12:32 +0300] 18302 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36"
77.88.47.24 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET / HTTP/1.0" [11/Jul/2025:07:18:40 +0300] 18246 "-" "Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)"
141.8.143.1 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET / HTTP/1.0" [11/Jul/2025:07:20:13 +0300] 18277 "-" "Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)"
213.180.203.14 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET / HTTP/1.0" [11/Jul/2025:07:20:31 +0300] 18415 "-" "Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)"
51.68.236.90 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET / HTTP/1.0" [11/Jul/2025:07:29:00 +0300] 18381 "-" "Mozilla/5.0 (compatible; MJ12bot/v2.0.2; http://mj12bot.com/)"
18.97.9.170 +*
  • status: 200 - 3
url: 3
  1. 200 - 3
    • "GET / HTTP/1.0" [11/Jul/2025:07:34:54 +0300] 18256 "-" "CCBot/2.0 (https://commoncrawl.org/faq/)"
    • "GET /articles/ascii/ HTTP/1.0" [11/Jul/2025:08:46:01 +0300] 12827 "-" "CCBot/2.0 (https://commoncrawl.org/faq/)"
    • "GET /articles/key-code/ HTTP/1.0" [11/Jul/2025:08:57:56 +0300] 12726 "-" "CCBot/2.0 (https://commoncrawl.org/faq/)"
2a11:fc87:408:f637:21dc:83:362:d294 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /tools/zametki/ HTTP/1.0" [11/Jul/2025:07:35:39 +0300] 16877 "-" "Mozilla/5.0 (Linux; Android 12; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Mobile Safari/537.36"
2a11:fc81:18f0:ef1:98e9:8afd:dab6:560e +*
  • status: 200 - 2
url: 2
  1. 200 - 2
    • "GET /favicon.ico?v=1 HTTP/1.0" [11/Jul/2025:07:35:43 +0300] 122 "https://baco.su/tools/zametki/" "Mozilla/5.0 (Linux; Android 12; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Mobile Safari/537.36"
    • "GET /favicon.ico?v=1 HTTP/1.0" [11/Jul/2025:07:35:43 +0300] 122 "https://baco.su/tools/zametki/" "Mozilla/5.0 (Linux; Android 12; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Mobile Safari/537.36"
2a0f:ca80::49 ++
  • status: 403 - 2
url: 2
  1. 403 - 2
    • "GET /wp-login.php HTTP/1.0" [11/Jul/2025:07:41:38 +0300] 9227 "-" "Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)"
    • "GET /articles/wp-login.php HTTP/1.0" [11/Jul/2025:07:41:38 +0300] 7688 "-" "Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)"
104.253.245.184 +*
  • status: 303 - 1
url: 1
  1. 303 - 1
    • "GET /download/1S77/gruppirovschik-otchetov/css/shape_1.svg HTTP/1.0" [11/Jul/2025:07:44:48 +0300] 276 "https://www.google.com/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:114.0) Gecko/20100101 Firefox/114.0"
207.32.143.0 +*
  • status: 404 - 1
url: 1
  1. 404 - 1
    • "GET /download/1S77/gruppirovschik-otchetov/css/shape_1.svg/ HTTP/1.0" [11/Jul/2025:07:44:49 +0300] 11336 "https://www.google.com/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:114.0) Gecko/20100101 Firefox/114.0"
93.158.91.12 +*
  • status: 200 - 2
url: 2
  1. 200 - 2
    • "GET / HTTP/1.0" [11/Jul/2025:07:48:20 +0300] 18224 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36"
    • "GET /favicon.ico?v=1 HTTP/1.0" [11/Jul/2025:07:48:21 +0300] 122 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36"
67.207.187.254 +*
  • status: 303 - 1
url: 1
  1. 303 - 1
    • "GET /shop/img/shop/site.jpg HTTP/1.0" [11/Jul/2025:08:17:52 +0300] 245 "https://www.google.com/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0.3 Safari/605.1.15"
51.68.236.68 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET / HTTP/1.0" [11/Jul/2025:08:30:30 +0300] 18330 "-" "Mozilla/5.0 (compatible; MJ12bot/v2.0.2; http://mj12bot.com/)"
212.33.255.53 ++
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET / HTTP/1.0" [11/Jul/2025:08:33:34 +0300] 18378 "https://yapl.ru/su/baco.su/" "Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:109.0) Gecko/20100101 Firefox/113.0"
209.99.143.8 +*
  • status: 303 - 1
url: 1
  1. 303 - 1
    • "GET /articles/report-to-web/css/shape_1.svg HTTP/1.0" [11/Jul/2025:08:39:05 +0300] 261 "https://www.google.com/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:114.0) Gecko/20100101 Firefox/114.0"
198.240.125.162 +*
  • status: 404 - 1
url: 1
  1. 404 - 1
    • "GET /articles/report-to-web/css/shape_1.svg/ HTTP/1.0" [11/Jul/2025:08:39:07 +0300] 11271 "https://www.google.com/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:114.0) Gecko/20100101 Firefox/114.0"
85.209.134.33 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET / HTTP/1.0" [11/Jul/2025:08:43:20 +0300] 18266 "https://google.com/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:137.0) Gecko/20100101 Firefox/137.0"
43.130.57.46 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET / HTTP/1.0" [11/Jul/2025:09:04:21 +0300] 18436 "http://baco.su" "Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1"

Качество запросов

статусрасшифровка
200

ссылок: 7

  1. /, повторов: 18
  2. /favicon.ico, повторов: 4
  3. /download/1S77/skopirovat-podchinennye-elementy/, повторов: 1
  4. /tools/zametki/, повторов: 1
  5. /articles/report-to-web/, повторов: 1
  6. /articles/ascii/, повторов: 1
  7. /articles/key-code/, повторов: 1

Всего запросов: 27 72.97%

303

ссылок: 4

  1. /shop/img/shop/logoff.jpg, повторов: 1
  2. /download/1S77/gruppirovschik-otchetov/css/shape_1.svg, повторов: 1
  3. /shop/img/shop/site.jpg, повторов: 1
  4. /articles/report-to-web/css/shape_1.svg, повторов: 1

Всего запросов: 4 10.81%

301

ссылок: 1

  1. /shop/img/shop/logoff.jpg/, повторов: 1

Всего запросов: 1 2.7%

403

ссылок: 3

  1. /bacosu.sql, повторов: 1
  2. /wp-login.php, повторов: 1
  3. /articles/wp-login.php, повторов: 1

Всего запросов: 3 8.11%

404

ссылок: 2

  1. /download/1S77/gruppirovschik-otchetov/css/shape_1.svg/, повторов: 1
  2. /articles/report-to-web/css/shape_1.svg/, повторов: 1

Всего запросов: 2 5.41%

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

URLCount
/download/1S77/skopirovat-podchinennye-elementy/1
/shop/img/shop/logoff.jpg1
/shop/img/shop/logoff.jpg/1
/bacosu.sql1
/tools/zametki/1
/wp-login.php1
/articles/wp-login.php1
/download/1S77/gruppirovschik-otchetov/css/shape_1.svg1
/download/1S77/gruppirovschik-otchetov/css/shape_1.svg/1
/articles/report-to-web/1
/shop/img/shop/site.jpg1
/articles/report-to-web/css/shape_1.svg1
/articles/report-to-web/css/shape_1.svg/1
/articles/ascii/1
/articles/key-code/1
/favicon.ico4
/18

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

IPдата/время
2a11:bcc6:944:1de5:41c7:bd00:3bec:fed3 [11/Jul/2025:06:39:28 +0300]
47.128.122.121 [11/Jul/2025:07:08:41 +0300]
207.32.148.176 [11/Jul/2025:07:11:50 +0300]
104.194.192.61 [11/Jul/2025:07:11:53 +0300]
194.110.210.94 [11/Jul/2025:07:11:55 +0300]
77.88.9.138 [11/Jul/2025:07:12:13 +0300]
87.250.233.1 [11/Jul/2025:07:12:14 +0300]
5.255.251.129 [11/Jul/2025:07:12:16 +0300]
77.88.9.1 [11/Jul/2025:07:12:18 +0300]
94.156.177.35 [11/Jul/2025:07:12:19 +0300]
156.244.31.210 [11/Jul/2025:07:12:32 +0300]
77.88.47.24 [11/Jul/2025:07:18:40 +0300]
141.8.143.1 [11/Jul/2025:07:20:13 +0300]
213.180.203.14 [11/Jul/2025:07:20:31 +0300]
51.68.236.90 [11/Jul/2025:07:29:00 +0300]
2a11:fc87:408:f637:21dc:83:362:d294 [11/Jul/2025:07:35:39 +0300]
2a11:fc81:18f0:ef1:98e9:8afd:dab6:560e [11/Jul/2025:07:35:43 +0300]
2a0f:ca80::49 [11/Jul/2025:07:41:38 +0300]
104.253.245.184 [11/Jul/2025:07:44:48 +0300]
207.32.143.0 [11/Jul/2025:07:44:49 +0300]
93.158.91.12 [11/Jul/2025:07:48:21 +0300]
66.249.70.138 [11/Jul/2025:08:09:30 +0300]
67.207.187.254 [11/Jul/2025:08:17:52 +0300]
51.68.236.68 [11/Jul/2025:08:30:30 +0300]
212.33.255.53 [11/Jul/2025:08:33:34 +0300]
209.99.143.8 [11/Jul/2025:08:39:05 +0300]
198.240.125.162 [11/Jul/2025:08:39:07 +0300]
85.209.134.33 [11/Jul/2025:08:43:20 +0300]
18.97.9.170 [11/Jul/2025:08:57:56 +0300]
43.130.57.46 [11/Jul/2025:09:04:21 +0300]

Вход


Регистрация