Re: Mysql odmítá nastartovat

[Martin]

A ještě tento výpis:

tail -f /var/log/daemon.log
Apr 20 08:21:35 louis mysqld[9887]: 070420  8:21:35 [ERROR] Aborting
Apr 20 08:21:35 louis mysqld[9887]:
Apr 20 08:21:35 louis mysqld[9887]: 070420  8:21:35 [Note] /usr/sbin/
mysqld: Shutdown complete
Apr 20 08:21:35 louis mysqld[9887]:
Apr 20 08:21:35 louis mysqld_safe[9889]: ended
Apr 20 08:21:49 louis /etc/init.d/mysql[10024]: 0 processes alive and
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping'
resulted in
Apr 20 08:21:49 louis /etc/init.d/mysql[10024]: ^G/usr/bin/mysqladmin:
connect to server at 'localhost' failed
Apr 20 08:21:49 louis /etc/init.d/mysql[10024]: error: 'Can't connect
to local MySQL server through socket '/var/run/mysqld/
mysqld.sock' (2)'
Apr 20 08:21:49 louis /etc/init.d/mysql[10024]: Check that mysqld is
running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Apr 20 08:21:49 louis /etc/init.d/mysql[10024]:
Apr 20 08:22:56 louis mysqld_safe[10096]: started
Apr 20 08:22:56 louis mysqld[10099]: ^G/usr/sbin/mysqld: Can't read
dir of '/tmp/' (Errcode: 13)
Apr 20 08:22:56 louis mysqld[10099]: ^G/usr/sbin/mysqld: File '/var/
log/mysql/mysql-bin.index' not found (Errcode: 13)
Apr 20 08:22:56 louis mysqld[10099]: 070420  8:22:56 [ERROR] Aborting
Apr 20 08:22:56 louis mysqld[10099]:
Apr 20 08:22:56 louis mysqld[10099]: 070420  8:22:56 [Note] /usr/sbin/
mysqld: Shutdown complete
Apr 20 08:22:56 louis mysqld[10099]:
Apr 20 08:22:56 louis mysqld_safe[10101]: ended
Apr 20 08:23:11 louis /etc/init.d/mysql[10236]: 0 processes alive and
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping'
resulted in
Apr 20 08:23:11 louis /etc/init.d/mysql[10236]: ^G/usr/bin/mysqladmin:
connect to server at 'localhost' failed
Apr 20 08:23:11 louis /etc/init.d/mysql[10236]: error: 'Can't connect
to local MySQL server through socket '/var/run/mysqld/
mysqld.sock' (2)'
Apr 20 08:23:11 louis /etc/init.d/mysql[10236]: Check that mysqld is
running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Apr 20 08:23:11 louis /etc/init.d/mysql[10236]:


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'