From owner-freebsd-questions@FreeBSD.ORG Tue Jul 4 17:20:15 2006 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 8A50316A4E1 for ; Tue, 4 Jul 2006 17:20:15 +0000 (UTC) (envelope-from kdk@daleco.biz) Received: from ezekiel.daleco.biz (southernuniform.com [66.76.92.18]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8159943D46 for ; Tue, 4 Jul 2006 17:20:14 +0000 (GMT) (envelope-from kdk@daleco.biz) Received: from [192.168.2.2] ([69.27.149.254]) by ezekiel.daleco.biz (8.13.4/8.13.1) with ESMTP id k64HIYo5040513; Tue, 4 Jul 2006 12:18:55 -0500 (CDT) (envelope-from kdk@daleco.biz) Message-ID: <44AAA2DD.20108@daleco.biz> Date: Tue, 04 Jul 2006 12:18:21 -0500 From: Kevin Kinsey User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.8.0.4) Gecko/20060623 SeaMonkey/1.0.2 MIME-Version: 1.0 To: =?ISO-8859-1?Q?C=E9sar_Amaya?= References: <44AA9A86.5000602@123.com.sv> In-Reply-To: <44AA9A86.5000602@123.com.sv> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit Cc: freebsd-questions@freebsd.org Subject: Re: snort and mysql connection at start troubles X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 04 Jul 2006 17:20:15 -0000 César Amaya wrote: > Hi list > > I am installing SNORT 2.4.5 to log into a MySQL-5.1 database. snort logs > are being stored fine into the db, but whe the system start snort fails > because of this: snort[396]: FATAL ERROR: database: mysql_error: Can't > connect to local MySQL server through socket '/tmp/mysql.sock' (2) > > this is the configuration line in the snort.conf file > > output database: log, mysql, user=snortids password=PswIdS dbname=snort > host=localhost > > when I changed the 'localhost' name to 127.0.0.1 I got the following error > > snort[401]: FATAL ERROR: database: mysql_error: Can't connect to MySQL > server on '127.0.0.1' (61) > > All of this happens at start time. After system started I start snort > manually and connect to mysql just fine. > > It seems that snort start earlier than mysql. I want to start mysql > earlier than snort but I don´t know how. > > Can some body help me? > I think you should take a look at rcorder(8). Kevin Kinsey -- Think honk if you're a telepath.