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