#1  
Old 27th January 2011, 02:35
pititis pititis is offline
Senior Member
 
Join Date: Dec 2010
Location: München
Posts: 364
Thanks: 39
Thanked 89 Times in 68 Posts
Default Fail2ban and mysql

Hello,

Why fail2ban don't support mysql? I have found a patch to make it work but I think that mysql logging can be a performance killer. I have test to logging and in minutes I get a very heavy log (logging with "General query log" level ). There is any way to log only connections in mysql?

Cheers!
Reply With Quote
Sponsored Links
  #2  
Old 9th February 2012, 19:37
tgs tgs is offline
Junior Member
 
Join Date: Feb 2012
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Fail2ban does not work well with mysql.log because MySQL does not log the client IP address of the failed login attempt.

The part after the '@' in the "Access denied for user 'name'@'host.doma.in'" message is the result of a reverse DNS lookup on the client IP address, which may or may not resolve back to the original IP address. If it doesn't, fail2ban will fail, or worse, ban the wrong address.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Companion Script #2 for The Perfect Server - Fedora 13 x86_64 [ISPConfig 3]" MrCompTech Tips/Tricks/Mods 0 10th July 2010 06:11
fail2ban apache filters cjhmdm Installation/Configuration 1 9th June 2010 15:35
installing fail2ban and rkhunter after ISPc3 Slowhand Installation/Configuration 2 5th June 2009 19:53
fail2ban configuration issues... hemajanger Server Operation 0 15th May 2009 21:53
Preventing Brute Force Attacks With Fail2ban On Debian Etch Jarek Buczyński HOWTO-Related Questions 6 10th August 2007 20:23


All times are GMT +2. The time now is 03:35.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.