KarimJedda

sqlite3 /home/logger/logs.db "create table todo (ip TEXT, timestamp TEXT, status_code TEXT, bytes_sent TEXT, request_method TEXT, request_url TEXT,  request_protocol TEXT, referrer TEXT, user_agent TEXT);"

KarimJedda

# Get all the logs
tail -f /var/log/nginx/access.log | 

# Extract IP and Timestamp for example
awk '{print  $1  " " substr($4, 2, length($4) - 7)}' FPAT='[^ ]*|"[^"]*"|\\[[^]]*\\]'

KarimJedda

tail -f /var/log/nginx/access.log | \
# parsing every line 
gawk '{print  $1  " " substr($4, 2, length($4) - 8) " " $6 " " $7 " " substr($5, 2, length($5) -2)  " " substr($8, 2, length($8)-2) " "  $9; system("")}' FPAT='[^ ]*|"[^"]*"|\\[[^]]*\\]' | \
# inserting every new line into sqlite
(while read ip timestamp status_code bytes_sent request_method request_url request_protocol referrer user_agent; do sqlite3 -batch /home/logger/logs.db "insert into todo (ip, timestamp, status_code, bytes_sent, request_method, request_url, request_protocol, referrer, user_agent) values (\"$ip\",\"$timestamp\", \"$status_code\", \"$bytes_sent\", \"$request_method\", \"$request_url\", \"$request_protocol\" ,\"$referrer\" , $user_agent);"; done )

KarimJedda

vim /etc/nginx/nginx.conf: 

#add:
log_format mycombined '$remote_addr - $remote_user [$time_iso8601] "$request" $status $body_bytes_sent "$http_referer" "$http_user_agent"';
access_log /var/log/nginx/access.log mycombined;

nginx -s reload 

KarimJedda

import pyautogui 
import time
import random

screenWidth, screenHeight = pyautogui.size() 
currentMouseX, currentMouseY = pyautogui.position() 

while True:
	pyautogui.moveTo(random.randint(1, 1000), random.randint(1, 500)) 
	time.sleep(20)