From owner-freebsd-security@FreeBSD.ORG Mon Jan 21 09:50:15 2008 Return-Path: Delivered-To: freebsd-security@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 50E1E16A420 for ; Mon, 21 Jan 2008 09:50:15 +0000 (UTC) (envelope-from jordi.espasa@opengea.org) Received: from mail.opengea.org (mail.opengea.org [85.48.253.234]) by mx1.freebsd.org (Postfix) with ESMTP id E251A13C467 for ; Mon, 21 Jan 2008 09:50:14 +0000 (UTC) (envelope-from jordi.espasa@opengea.org) Received: from localhost (tartarus [127.0.0.1]) by mail.opengea.org (Opengea.org Project MailServer) with ESMTP id CF957D50039 for ; Mon, 21 Jan 2008 10:53:38 +0100 (CET) X-Virus-Scanned: amavisd-new at opengea.org Received: from mail.opengea.org ([127.0.0.1]) by localhost (mail.opengea.org [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id cv92m6EUMy4e for ; Mon, 21 Jan 2008 10:53:38 +0100 (CET) Received: from jespasac.cdmon.com (62.Red-217-126-43.staticIP.rima-tde.net [217.126.43.62]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: jordi.espasa@opengea.org) by mail.opengea.org (Opengea.org Project MailServer) with ESMTP id 7B7D2D50033 for ; Mon, 21 Jan 2008 10:53:38 +0100 (CET) Message-ID: <47946AD3.2020601@opengea.org> Date: Mon, 21 Jan 2008 10:50:11 +0100 From: Jordi Espasa Clofent User-Agent: Thunderbird 2.0.0.9 (X11/20071219) MIME-Version: 1.0 To: freebsd-security@freebsd.org Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit Subject: denyhosts-like app for MySQLd? X-BeenThere: freebsd-security@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: "Security issues \[members-only posting\]" List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 21 Jan 2008 09:50:15 -0000 Hi all, żIs there any app like denyhosts[1] but intended for MySQLd service? We have a mysql ports (3306) opened for remote connections, and obviously the /var/db/mysql/machine_name.log is full of these kind of entries: ........... 936012 Connect Access denied for user 'user'@'85.19.95.10' (using password: YES) 936013 Connect Access denied for user 'user'@'85.19.95.10' (using password: YES) 936014 Connect Access denied for user 'user'@'85.19.95.10' (using password: YES) 936016 Connect Access denied for user 'user'@'85.19.95.10' (using password: YES) 936018 Connect Access denied for user 'user'@'85.19.95.10' (using password: YES) 936019 Connect Access denied for user 'user'@'85.19.95.10' (using password: YES) ............. The idea is blocking the abusive IPs in automated way. [1] http://denyhosts.sourceforge.net/ -- Thanks, Jordi Espasa Clofent