Tag Archives: Security

Troubleshooting with MySQL binary logs

MySQL replication has a wide range of uses, including debugging applications writing to the DB being replicated. Once set up, all statements “that update data or potentially could have updated it” are stored in one or more binary logs (MySQL … Continue reading

Posted in MySQL | Tagged , , | Leave a comment

Watching a fork bomb explode

Fork bombs are simple pieces of programming logic that can bring down the mightiest of servers in seconds (in fact, the faster the server, the faster it goes down). They are quite easy to protect against, but some operating systems … Continue reading

Posted in Security | Tagged , , , | Leave a comment

mysql_secure_installation: A useful first step in securing a MySQL server

This won’t be an exhaustive post on how to secure a MySQL server. I just want to mention a useful utility packaged with MySQL server: mysql_secure_installation. Simply run it from the command line once MySQL server is installed and running. … Continue reading

Posted in MySQL | Tagged , , | Leave a comment

More Tasty Tips for DenyHosts

After living with DenyHosts for some time, I have made some additional configuration changes that are quite helpful. Whitelist known good IPsI found after not very long that my home IP address had been added to my webserver’s hosts.deny file … Continue reading

Posted in CLI | Tagged , , , | Leave a comment

DenyHosts: Watches your SSH log for you

While I knew that brute-force attacks on SSH servers are very common, I had not taken the time to look at the connection attempt logs on my home servers until recently. To do that on Ubuntu run: 1sudo tail -n … Continue reading

Posted in CLI | Tagged , , , | Leave a comment