[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
On 02/12/07 23:54:51, 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]: So what happens if you... telnet localhost 3306 ?? -- 'ooroo stinga...(:)-) --------------------------------------------------- Email: stinga@xxxxxxxxxxxxx o You need only two tools. o ///// A hammer and duct tape. If it /@ `\ /) ~ doesn't move and it should, > (O) X< ~ Fish!! use the hammer. If it moves and `\___/' \) ~ shouldn't, use the tape. \\\ --------------------------------------------------- -- 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