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