From owner-freebsd-hackers@FreeBSD.ORG Tue Nov 30 16:52:36 2004 Return-Path: Delivered-To: freebsd-hackers@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id B067E16A4CE for ; Tue, 30 Nov 2004 16:52:36 +0000 (GMT) Received: from recife.ipadnet.com.br (recife.ipadnet.com.br [200.249.204.129]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4E32543D3F for ; Tue, 30 Nov 2004 16:52:35 +0000 (GMT) (envelope-from mario.lobo@ipad.com.br) Received: from marioLobo ([200.249.204.142]) by recife.ipadnet.com.br (8.12.8/8.12.8) with ESMTP id iAUGvSMr003245; Tue, 30 Nov 2004 13:57:30 -0300 From: mario.lobo@ipad.com.br Organization: IPAD To: "Arun Pereira" Date: Tue, 30 Nov 2004 13:55:58 -0300 MIME-Version: 1.0 Message-ID: <41AC7BEE.2530.15BE9EB@localhost> Priority: normal In-reply-to: <005f01c4d6eb$e659cd00$453035ce@cerberus> X-mailer: Pegasus Mail for Windows (4.21c) Content-type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: Quoted-printable Content-description: Mail message body cc: freebsd-hackers@freebsd.org Subject: Re: MYSQL connection problem X-BeenThere: freebsd-hackers@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: mario.lobo@ipad.com.br List-Id: Technical Discussions relating to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 30 Nov 2004 16:52:36 -0000 Yeah, it is the only one on that port. The worst part is that the connecti= on attempt doesn=B4t even generates a log entry !! I looked into the log also !! netstat -an | grep LIST tcp4 0 0 *.5007 *.* LISTEN tcp4 0 0 *.199 *.* LISTEN tcp4 0 0 *.443 *.* LISTEN tcp4 0 0 *.80 *.* LISTEN tcp4 0 0 127.0.0.1.25 *.* LISTEN tcp4 0 0 *.22 *.* LISTEN here is my.cnf [mysqld] datadir=3D/bd/mysql/data socket=3D/home/xxxxxxx/mysql/mysql.sock port=3D5004 set-variable =3D max_connections=3D2000 [mysql.server] user=3Dxxxxxxx basedir=3D/bd/ [safe_mysqld] err-log=3D/home/xxxxxxx/mysql/mysqld.log pid-file=3D/home/xxxxxxx/mysql/mysqld.pid > > I know this might sound rather obvious but have you checked whether mysq= l is > actually listening on that port? Perhaps that port is being used by ano= ther > daemon or process and mysql cannot bind to it while starting. > use netstat to check this. Also try and look at the error log file for t= he > mysql daemon. Usually this is located in the /var/db/mysql directory. > -- //| //|| // | // || -//--//---|| ARIO LOBO // // || --------------------------------- mario.lobo@ipad.com.br http://www.ipad.com.br