Date: Tue, 30 Nov 2004 13:55:58 -0300 From: mario.lobo@ipad.com.br To: "Arun Pereira" <arun@velcom.com> Cc: freebsd-hackers@freebsd.org Subject: Re: MYSQL connection problem Message-ID: <41AC7BEE.2530.15BE9EB@localhost> In-Reply-To: <005f01c4d6eb$e659cd00$453035ce@cerberus>
next in thread | previous in thread | raw e-mail | index | archive | help
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=5004 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?41AC7BEE.2530.15BE9EB>