Re: Mysql odmítá nastartovat
Martin
martin na prosperita.info
Pátek Duben 20 08:55:52 CEST 2007
Tady je jeste vypis, ktery by se mohl hodit:
tail (vybrano za dnesek, kdy jsem zova spustil apt-get install mysql)
Apr 20 07:47:42 louis mysqld_safe[8963]: ^G/usr/sbin/mysqld: Can't
read dir of
' /
tmp/' (Errcode: 13)
Apr 20 07:47:42 louis mysqld_safe[8963]: ^G/usr/sbin/mysqld: File '/
var/log/
mysq
l/mysql-bin.index' not found (Errcode: 13)
Apr 20 07:47:42 louis mysqld_safe[8963]: 070420 7:47:42 [ERROR]
Aborting
Apr 20 07:47:42 louis mysqld_safe[8963]:
Apr 20 07:47:42 louis mysqld_safe[8963]: 070420 7:47:42 [Note] /usr/
sbin/
mysqld :
Shutdown complete
Apr 20 07:47:42 louis mysqld_safe[8963]:
Apr 20 07:47:42 louis mysqld_safe[8963]: Installation of system tables
failed!
Apr 20 07:47:42 louis mysqld_safe[8963]:
Apr 20 07:47:42 louis mysqld_safe[8963]: Examine the logs in /var/lib/
mysql
for
more information.
Apr 20 07:47:42 louis mysqld_safe[8963]: You can also try to start the
mysqld
da
emon with:
Apr 20 07:47:42 louis mysqld_safe[8963]: /usr/sbin/mysqld --skip-grant
&
Apr 20 07:47:42 louis mysqld_safe[8963]: You can use the command line
tool
Apr 20 07:47:42 louis mysqld_safe[8963]: /usr/bin/mysql to connect to
the mysql
Apr 20 07:47:42 louis mysqld_safe[8963]: database and look at the
grant tables:
Apr 20 07:47:42 louis mysqld_safe[8963]:
Apr 20 07:47:42 louis mysqld_safe[8963]: shell> /usr/bin/mysql -u root
mysql
Apr 20 07:47:42 louis mysqld_safe[8963]: mysql> show tables
Apr 20 07:47:42 louis mysqld_safe[8963]:
Apr 20 07:47:42 louis mysqld_safe[8963]: Try 'mysqld --help' if you
have
problem
s with paths. Using --log
Apr 20 07:47:42 louis mysqld_safe[8963]: gives you a log in /var/lib/
mysql
that
may be helpful.
Apr 20 07:47:42 louis mysqld_safe[8963]:
Apr 20 07:47:42 louis mysqld_safe[8963]: The latest information about
MySQL is
a
vailable on the web at
Apr 20 07:47:42 louis mysqld_safe[8963]: http://www.mysql.com
Apr 20 07:47:42 louis mysqld_safe[8963]: Please consult the MySQL
manual
section :
'Problems running mysql_install_db',
Apr 20 07:47:42 louis mysqld_safe[8963]: and the manual section that
describes
p
roblems on your OS.
Apr 20 07:47:42 louis mysqld_safe[8963]: Another information source is
the
MySQL
email archive.
Apr 20 07:47:42 louis mysqld_safe[8963]: Please check all of the above
before
ma
iling us!
Apr 20 07:47:42 louis mysqld_safe[8963]: And if you do mail us, you
MUST use
the /
usr/bin/mysqlbug script!
Apr 20 07:47:42 louis mysqld_safe[8993]: ^G/usr/sbin/mysqld: Can't
read dir of
' /
tmp/' (Errcode: 13)
Apr 20 07:47:42 louis mysqld_safe[8993]: ^G/usr/sbin/mysqld: File '/
var/log/
mysq
l/mysql-bin.index' not found (Errcode: 13)
Apr 20 07:47:42 louis mysqld_safe[8993]: 070420 7:47:42 [ERROR]
Aborting
Apr 20 07:47:42 louis mysqld_safe[8993]:
Apr 20 07:47:42 louis mysqld_safe[8993]: 070420 7:47:42 [Note] /usr/
sbin/
mysqld :
Shutdown complete
Apr 20 07:47:42 louis mysqld_safe[8993]:
Apr 20 07:47:42 louis mysqld_safe[9001]: ^G/usr/sbin/mysqld: Can't
read dir of
' /
tmp/' (Errcode: 13)
Apr 20 07:47:42 louis mysqld_safe[9001]: ^G/usr/sbin/mysqld: File '/
var/log/
mysq
l/mysql-bin.index' not found (Errcode: 13)
Apr 20 07:47:42 louis mysqld_safe[9001]: 070420 7:47:42 [ERROR]
Aborting
Apr 20 07:47:42 louis mysqld_safe[9001]:
Apr 20 07:47:42 louis mysqld_safe[9001]: 070420 7:47:42 [Note] /usr/
sbin/
mysqld :
Shutdown complete
Apr 20 07:47:42 louis mysqld_safe[9001]:
Apr 20 07:47:42 louis mysqld_safe[9005]: ^G/usr/sbin/mysqld: Can't
read dir of
' /
tmp/' (Errcode: 13)
Apr 20 07:47:42 louis mysqld_safe[9005]: ^G/usr/sbin/mysqld: File '/
var/log/
mysq
l/mysql-bin.index' not found (Errcode: 13)
Apr 20 07:47:42 louis mysqld_safe[9005]: 070420 7:47:42 [ERROR]
Aborting
Apr 20 07:47:42 louis mysqld_safe[9005]:
Apr 20 07:47:42 louis mysqld_safe[9005]: 070420 7:47:42 [Note] /usr/
sbin/
mysqld :
Shutdown complete
Apr 20 07:47:42 louis mysqld_safe[9005]:
Apr 20 07:47:42 louis mysqld_safe[9009]: ^G/usr/sbin/mysqld: Can't
read dir of
' /
tmp/' (Errcode: 13)
Apr 20 07:47:42 louis mysqld_safe[9009]: ^G/usr/sbin/mysqld: File '/
var/log/
mysq
l/mysql-bin.index' not found (Errcode: 13)
Apr 20 07:47:42 louis mysqld_safe[9009]: 070420 7:47:42 [ERROR]
Aborting
Apr 20 07:47:42 louis mysqld_safe[9009]:
Apr 20 07:47:42 louis mysqld_safe[9009]: 070420 7:47:42 [Note] /usr/
sbin/
mysqld :
Shutdown complete
Apr 20 07:47:42 louis mysqld_safe[9009]:
Apr 20 07:47:42 louis mysqld_safe[9090]: started
Apr 20 07:47:42 louis mysqld[9093]: ^G/usr/sbin/mysqld: Can't read dir
of '/
tmp/
' (Errcode: 13)
Apr 20 07:47:42 louis mysqld[9093]: ^G/usr/sbin/mysqld: File '/var/log/
mysql/
mys
ql-bin.index' not found (Errcode: 13)
Apr 20 07:47:42 louis mysqld[9093]: 070420 7:47:42 [ERROR] Aborting
Apr 20 07:47:42 louis mysqld[9093]:
Apr 20 07:47:42 louis mysqld[9093]: 070420 7:47:42 [Note] /usr/sbin/
mysqld:
Shu
tdown complete
Apr 20 07:47:42 louis mysqld[9093]:
Apr 20 07:47:42 louis mysqld_safe[9095]: ended
Apr 20 07:47:56 louis /etc/init.d/mysql[9230]: 0 processes alive and '/
usr/bin/
m
ysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Apr 20 07:47:56 louis /etc/init.d/mysql[9230]: ^G/usr/bin/mysqladmin:
connect
to
server at 'localhost' failed
Apr 20 07:47:56 louis /etc/init.d/mysql[9230]: error: 'Can't connect
to local
My
SQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Apr 20 07:47:56 louis /etc/init.d/mysql[9230]: Check that mysqld is
running
and
that the socket: '/var/run/mysqld/mysqld.sock' exists!
Apr 20 07:47:56 louis /etc/init.d/mysql[9230]:
Filip Krejci napsal:
> Nebo jeste lepe :
>
> dejte tail -f /var/log/daemon.log
> a na jine konzoli provedte restart start mysql, pak pastnete co do toho
> logu vylezlo...
>
> Dulezite jsou zpravy z mysqld to dalsi uz je jen nasledek.
>
> Filip
>
> Filip Krejci napsal(a):
> > To dulezite tam chybi, zkuste delsi ocasek
> >
> > tail -n 40 /var/log/daemon.log
> >
> > Filip
> >
> > Martin napsal(a):
> >> Ted jsem zkusil instalaci jeste jednou.
> >> Pise to do logu toto:
> >>
> >> tail /var/log/daemon.log
> >> Apr 19 19:43:55 louis mysqld[3158]: 070419 19:43:55 [ERROR] Aborting
> >> Apr 19 19:43:55 louis mysqld[3158]:
> >> Apr 19 19:43:55 louis mysqld[3158]: 070419 19:43:55 [Note] /usr/sbin/
> >> mysqld: Shutdown complete
> >> Apr 19 19:43:55 louis mysqld[3158]:
> >> Apr 19 19:43:55 louis mysqld_safe[3160]: ended
> >> Apr 19 19:44:09 louis /etc/init.d/mysql[3295]: 0 processes alive and '/
> >> usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping'
> >> resulted in
> >> Apr 19 19:44:09 louis /etc/init.d/mysql[3295]: ^G/usr/bin/mysqladmin:
> >> connect to server at 'localhost' failed
> >> Apr 19 19:44:09 louis /etc/init.d/mysql[3295]: error: 'Can't connect
> >> to local MySQL server through socket '/var/run/mysqld/
> >> mysqld.sock' (2)'
> >> Apr 19 19:44:09 louis /etc/init.d/mysql[3295]: Check that mysqld is
> >> running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
> >> Apr 19 19:44:09 louis /etc/init.d/mysql[3295]:
> >>
> >>
> >> Martin
> >> JaV napsal:
> >>> Martin napsal(a):
> >>>> Přeji hezký den.
> >>>> Mám problém se startem MySQL.
> >>>> MySQL instaluji přes apt-get mysql-server, stáhne se (včetně
> >>>> potřebných balíků), následně se první balík nakonfiguruje a chce se
> >>>> spustit. V totmto okamžiku se objeví "Starting MySQL database server:
> >>>> mysqld . . . . . . . . . . . . . . failed!"
> >>>> Používám distribuci Debian 4 etch. Mám standardní instalaci + jsem
> >>>> porvedl pár nastavení popsaných na těchto 2 stránkách:
> >>>> - http://www.howtoforge.com/perfect_setup_debian_etch_p3
> >>>> - http://www.howtoforge.com/perfect_setup_debian_etch_p4
> >>>> [Jinak quotu mám naistalovanou na /home, nikoliv kořenu /.]
> >>>>
> >>>> Soubor /etc/mysql/my.cnf mám určitě správný.
> >>>> Potřebuju to nějak rozchodit. Dřív mi mysql fungovalo, než jsem
> >>>> provedl výše zmíněný úpravy.
> >>>> Snad mi tu někdo poradí. Alespoň jak zjistit, co je v nepořádku.
> >>>>
> >>>> Moc děkuji,
> >>>> Martin
> >>>>
> >>> napise neco do logu?
> >> _______________________________________________
> >> Linux mailing list
> >> Linux na linux.cz
> >> http://www.linux.cz/mailman/listinfo/linux
> >>
> >
> >
>
>
> --
> Filip Krejci <filip.krejci na datesoft.cz>
>
> line 6: syntax error near unexpected token `a'
Další informace o konferenci Linux