From owner-freebsd-hackers@FreeBSD.ORG Tue Nov 30 19:23:35 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 DD67A16A4DC for ; Tue, 30 Nov 2004 19:23:34 +0000 (GMT) Received: from recife.ipadnet.com.br (recife.ipadnet.com.br [200.249.204.129]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8BB5A43D31 for ; Tue, 30 Nov 2004 19:23:31 +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 iAUJSQMr028859; Tue, 30 Nov 2004 16:28:27 -0300 From: mario.lobo@ipad.com.br Organization: IPAD To: "Arun Pereira" Date: Tue, 30 Nov 2004 16:26:56 -0300 MIME-Version: 1.0 Message-ID: <41AC9F50.25874.1E62279@localhost> Priority: normal In-reply-to: <005701c4d70f$657ae290$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 (correction re-post) 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 19:23:36 -0000 Hi Arun; > hrmm. > Can you try switching the port to another port number? Perhaps a lower p= ort > number? > See if you can get it to connect in that way? Makes no difference > In your log file, does it print messages about having successfully start= ed > up? Yes, it does. Like I said, if I use mysql.sock I connect fine. The problem= is in TCP connections. > Do you have ipfw or any other packet filter on your machine? None whatsoever, of any kind. -- //| //|| // | // || -//--//---|| ARIO LOBO // // || --------------------------------- mario.lobo@ipad.com.br http://www.ipad.com.br > > ----- Original Message ----- > From: > To: "Arun Pereira" > Cc: > Sent: Tuesday, November 30, 2004 12:24 PM > Subject: Re: MYSQL connection problem (correction re-post) > > > Sorry for this :( . Correction marked with " <=3D=3D=3D=3D=3D**** " > > I typed a my.cnf from another machine. only the port differs. > > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > Yeah, it is the only one on that port. The worst part is that the connec= tion > attempt doesn=B4t even > generates a log entry !! I looked into the log also !! > > netstat -an | grep LIST > tcp4 0 0 *.5007 *.* LISTE= N > tcp4 0 0 *.199 *.* LISTE= N > tcp4 0 0 *.443 *.* LISTE= N > tcp4 0 0 *.80 *.* LISTE= N > tcp4 0 0 127.0.0.1.25 *.* LISTE= N > tcp4 0 0 *.22 *.* LISTE= N > > here is my.cnf > > [mysqld] > datadir=3D/bd/mysql/data > socket=3D/home/xxxxxxx/mysql/mysql.sock > > port=3D5007 <=3D=3D=3D=3D=3D**** > > 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 my= sql > > is > > actually listening on that port? Perhaps that port is being used by > > another > > 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= the > > mysql daemon. Usually this is located in the /var/db/mysql directory. > > > > -- > //| //|| > // | // || > -//--//---|| ARIO LOBO > // // || > --------------------------------- > mario.lobo@ipad.com.br > http://www.ipad.com.br > > _______________________________________________ > freebsd-hackers@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-hackers > To unsubscribe, send any mail to "freebsd-hackers-unsubscribe@freebsd.or= g" > > > > _______________________________________________ > freebsd-hackers@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-hackers > To unsubscribe, send any mail to "freebsd-hackers-unsubscribe@freebsd.or= g"