Date: Tue, 30 Nov 2004 16:26:56 -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: <41AC9F50.25874.1E62279@localhost> In-Reply-To: <005701c4d70f$657ae290$453035ce@cerberus>
next in thread | previous in thread | raw e-mail | index | archive | help
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: <mario.lobo@ipad.com.br> > To: "Arun Pereira" <arun@velcom.com> > Cc: <freebsd-hackers@freebsd.org> > 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"
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?41AC9F50.25874.1E62279>