From owner-freebsd-questions@FreeBSD.ORG  Tue Jul  4 16:42:11 2006
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 314AE16A4E7
	for <freebsd-questions@freebsd.org>;
	Tue,  4 Jul 2006 16:42:11 +0000 (UTC) (envelope-from csar@123.com.sv)
Received: from asgard1.americatelsal.com (asgard.americatelsal.com
	[200.13.161.7]) by mx1.FreeBSD.org (Postfix) with ESMTP id 7D47F43D45
	for <freebsd-questions@freebsd.org>;
	Tue,  4 Jul 2006 16:42:09 +0000 (GMT) (envelope-from csar@123.com.sv)
Received: (qmail 75432 invoked from network); 4 Jul 2006 17:00:36 -0000
Received: from unknown (HELO ?192.168.10.251?) (200.13.161.68)
	by asgard1.americatelsal.com with SMTP; 4 Jul 2006 17:00:36 -0000
Message-ID: <44AA9A86.5000602@123.com.sv>
Date: Tue, 04 Jul 2006 10:42:46 -0600
From: =?ISO-8859-1?Q?C=E9sar_Amaya?= <csar@123.com.sv>
User-Agent: Thunderbird 1.5.0.4 (Windows/20060516)
MIME-Version: 1.0
To: freebsd-questions@freebsd.org
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
Subject: 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 <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 04 Jul 2006 16:42:11 -0000

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?