[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
Grant Sewell wrote: > On Sun, 02 Dec 2007 23:35:40 +0000 > Neil Stone wrote: > >> anything in the log files that would suggest why this is failing to fire >> up ?? >> >> I had a similar thing recently, turned out to be a crashed table, which >> mysql fixed.. >> > > Last few lines of syslog... the only logfile that seems to contain anything... > immediately after a "/etc/init.d/mysql start": > ---- > Dec 2 23:47:55 fileserver mysqld_safe[18960]: started > Dec 2 23:47:55 fileserver mysqld[18963]: 071202 23:47:55 InnoDB: Started; log > sequence number 0 2858885 > Dec 2 23:47:55 fileserver mysqld[18963]: 071202 23:47:55 [ERROR] Can't start > server: Bind on TCP/IP port: Cannot assign requested address > Dec 2 23:47:55 fileserver mysqld[18963]: 071202 23:47:55 [ERROR] Do you already > have another mysqld server running on port : 3306 ? > Dec 2 23:47:55 fileserver mysqld[18963]: 071202 23:47:55 [ERROR] Aborting > Dec 2 23:47:55 fileserver mysqld[18963]: > Dec 2 23:47:55 fileserver mysqld[18963]: 071202 23:47:55 InnoDB: Starting > shutdown... > Dec 2 23:47:58 fileserver mysqld[18963]: 071202 23:47:58 InnoDB: Shutdown > completed; log sequence number 0 2858885 > Dec 2 23:47:58 fileserver mysqld[18963]: 071202 23:47:58 [Note] /usr/sbin/mysqld: > Shutdown complete > Dec 2 23:47:58 fileserver mysqld[18963]: > Dec 2 23:47:58 fileserver mysqld_safe[18991]: ended > Dec 2 23:48:10 fileserver /etc/init.d/mysql[19110]: 0 processes alive and > '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in > Dec 2 23:48:10 fileserver /etc/init.d/mysql[19110]: /usr/bin/mysqladmin: connect > to server at 'localhost' failed > Dec 2 23:48:10 fileserver /etc/init.d/mysql[19110]: error: 'Can't connect to > local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' > Dec 2 23:48:10 fileserver /etc/init.d/mysql[19110]: Check that mysqld is running > and that the socket: '/var/run/mysqld/mysqld.sock' exists! > Dec 2 23:48:10 fileserver /etc/init.d/mysql[19110]: > ---- > I can't figure out why it can't bind to the port. > > Grant. > Looks like another process has grabbed that port netstat -nlp | grep 3360 might give a few clues here HTH.. Neil -- The Mailing List for the Devon & Cornwall LUG http://mailman.dclug.org.uk/listinfo/list FAQ: http://www.dcglug.org.uk/linux_adm/list-faq.html