Populating mySQL with fail2ban information and banhammer

Fail2SQL – An SQL logger for fail2ban can be found at https://fail2sql.sourceforge.net/

But i will do two things at the same time as i also found this https://www.byteme.org.uk/2014/04/21/ban-hammer-fail2ban-geo-ip-on-google-maps/ which will give me statistics on the web with google maps about banned IPS with geo location. So for the next to do this in correct order, Download fail2SQL and then follow RobinC howto along side when activating Fail2SQL. Read More

Time for fail2ban installation

As i see auth.log is filled with brute force attack on all services that are open to the internet its always good to have protection and fail2ban provides good features to be able to minimize those attacks. fail2ban will alter iptables configuration on the fly on predefined number of unsuccessful login attempts. In the beginning i will configure fail2ban to alter iptables locally on my server but will change that so it is my gateway (mikrotik) that will be the firewall that blocks the banned IP’s. But first installation of fail2ban locally only. Read More

Ubuntu Server 14.04 Project

Was time to refresh my server skills so i started project Ubuntu Server 14.04 on new hardware and clean install, everything from scratch. How big the project is going to be i have no idea but so far i have installed the system, configured for my home network.

So far i have installed and configured MySQL, Apache2, PHP and SSH server

Not so much to write about the installation process other than my computer refused to complete installation via USB for some reason, google did not have an solution so i just burned an CD and installed to get it going. After installation was done i installed SSHD and configured it like i normally do, Root login not allowed and only RSA/DSA key logins accepted no password login via SSH at all.

Installation of Apache2, PHP and MySQL and default configs works for now. Just created an database for the server to use for various things as i like to store information in SQL.

It Works! So far so good, Easy. Next post will be soon about Fail2ban with fail2sql and banhammer web statistics.