From owner-freebsd-hackers@FreeBSD.ORG Tue Nov 30 19:04:08 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 1E6EF16A4CE for ; Tue, 30 Nov 2004 19:04:08 +0000 (GMT) Received: from mx1.velcom.com (mx1.velcom.com [209.67.60.32]) by mx1.FreeBSD.org (Postfix) with SMTP id 5ADD843D2D for ; Tue, 30 Nov 2004 19:04:05 +0000 (GMT) (envelope-from arun@velcom.com) Received: (qmail 92955 invoked from network); 30 Nov 2004 19:03:34 -0000 Received: from unknown (HELO cerberus) (206.53.48.69) by mx1.velcom.com with SMTP; 30 Nov 2004 19:03:34 -0000 Message-ID: <005701c4d70f$657ae290$453035ce@cerberus> From: "Arun Pereira" To: References: <41AC8297.27850.175F014@localhost> Date: Tue, 30 Nov 2004 14:04:19 -0500 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 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 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:04:08 -0000 hrmm. Can you try switching the port to another port number? Perhaps a lower port number? See if you can get it to connect in that way? In your log file, does it print messages about having successfully started up? Do you have ipfw or any other packet filter on your machine? ----- 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 " <=====**** " I typed a my.cnf from another machine. only the port differs. ============== Yeah, it is the only one on that port. The worst part is that the connection attempt doesn´t 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=/bd/mysql/data socket=/home/xxxxxxx/mysql/mysql.sock port=5007 <=====**** set-variable = max_connections=2000 [mysql.server] user=xxxxxxx basedir=/bd/ [safe_mysqld] err-log=/home/xxxxxxx/mysql/mysqld.log pid-file=/home/xxxxxxx/mysql/mysqld.pid > > I know this might sound rather obvious but have you checked whether mysql > 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.org"