I run squid proxy server on my system to share internet connection with my friends on LAN. I just want to record data from /var/log/squid/access.log files to mysql database whenever my script detects restricted ip address in log file. How to do it? Is it possible to connect to databse from shell script?
I want to give quota for each user on my linux box, so that each one will get only specified amount of disk space.