Dotaz: Nelze spustit mysqld - chybi soubor mysql-bin.index

[robin.w]

Jak nainstaluji chybejici soubory, jenz je potreba pro mysql-server? Instalaci jsem provedl z balicku pomoci apt-get. Pouzivam Ubuntu 6.06. Pri spusteni je vypsano:

robin@ubuntu:/etc$ mysqld
mysqld: File '/var/log/mysql/mysql-bin.index' not found (Errcode: 13)
060905 23:24:40 [ERROR] Aborting

060905 23:24:40 [Note] mysqld: Shutdown complete

Adresar /var/log/mysql/ je prazdny!

Odpovědi

[core]

A kdyz to spustite standardni cestou, tj. jako root /etc/init.d/mysql start ? na ubuntu asi teda sudo invoke-rc.d mysql start

mysql-bin.index je jen index od binarniho logu, to si mysql udela samo, ale kdyz ho spoustine jako bezny uzivatel, tak na to asi nebude mit prava, protoze /var/log/mysql by mel vlastnit uzivatel mysql

[robin.w]

Tak jsem to zkousel taky, ale nic.

root@ubuntu:/etc/init.d# mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Nevim si s tim vubec rady.

[Dalibor Smolík]

Teď jestli máte nainstalované všechny balíky - já to mám následovně:

server:/home/dalibor# dpkg -l | grep mysql
ii  libdbd-mysql-perl                3.0006-1                A Perl5 database interface to the MySQL data
ii  libmysqlclient14                 4.1.15-3                mysql database client library
rc  libmysqlclient15                 5.0.18-9                mysql database client library
ii  libmysqlclient15off              5.0.24a-1               mysql database client library
ii  mysql-client-5.0                 5.0.24a-1               mysql database client binaries
ii  mysql-common                     5.0.24a-3               mysql database common files (e.g. /etc/mysql
ii  mysql-server-5.0                 5.0.24a-1               mysql database server binaries
ii  php4-mysql                       4.4.4-1                 MySQL module for php4

[robin.w]

mam vsechno plus jeste neco navic:

robin@ubuntu:~$ dpkg -l |grep mysql
ii  kmysqladmin                            0.7.2-1                                 Kde graphical frontend for mysql servers
ii  libapache2-mod-auth-mysql              4.3.9-2ubuntu3                          Apache 2 module for MySQL authentication
ii  libdbd-mysql                           0.7.1-3ubuntu1                          MySQL database server driver for libdbi
ii  libdbd-mysql-perl                      3.0002-2build1                          A Perl5 database interface to the MySQL data
rc  libmysqlclient12                       4.0.24-10ubuntu2                        mysql database client library
ii  libmysqlclient14                       4.1.15-1ubuntu5                         mysql database client library
rc  libmysqlclient15                       5.0.18-8.1                              mysql database client library
ii  libmysqlclient15off                    5.0.22-0ubuntu6.06.2                    mysql database client library
ii  mysql-client                           5.0.22-0ubuntu6.06.2                    mysql database client (current version)
ii  mysql-client-5.0                       5.0.22-0ubuntu6.06.2                    mysql database client binaries
ii  mysql-common                           5.0.22-0ubuntu6.06.2                    mysql database common files (e.g. /etc/mysql
ii  mysql-navigator                        1.4.2-7                                 GUI client program for MySQL database server
ii  mysql-query-browser                    1.1.17-5ubuntu3                         Official GUI tool to query MySQL database
ii  mysql-query-browser-common             1.1.17-5ubuntu3                         Architecture independent files for MySQL Que
ii  mysql-server                           5.0.22-0ubuntu6.06.2                    mysql database server (current version)
ii  mysql-server-5.0                       5.0.22-0ubuntu6.06.2                    mysql database server binaries
ii  php5-mysql                             5.1.2-1ubuntu3.1                        MySQL module for php5
ii  php5-mysqli                            5.1.2-1ubuntu3.1                        MySQL Improved module for php5

[Boris Michelsz]

je to mozno preklep, ale mysql je klient.

Inak mozno problem v pravach.

--log-bin-index[=file_name]

The index file for binary log filenames. See Section 10.3, "The Binary Log". If you omit the filename, and if you didn't specify one with --log-bin, MySQL uses host_name-bin.index as the filename.

Neviem ako na Ubuntu, ale skus pozriet do /usr/bin/ ci tam nie je subor "mysqld_safe" a spustit ho.

(Mam Slack, a /etc/rc.d/rc.mysql odkazuje prave tam)

[robin.w]

taky nic.

root@ubuntu:/etc# mysqld_safe
Starting mysqld daemon with databases from /var/lib/mysql
mysqld_safe[21983]: started
STOPPING server from pid file /var/run/mysqld/mysqld.pid
mysqld_safe[21989]: ended

[robin.w]

myslim si, ze problem budu mit ve spatne nastavenych pravech. Pls, potreboval bych poradit, kterym adresarum mam zmenit prava a uzivatele na mysql. preden dekuji za odpoved

[Boris Michelsz]

mne

find / -user mysql -print

zobrazi:

/var/lib/mysql/
/var/run/mysql/

+ vsetky podadresare.

[robin.w]

tak uz fakt nevim. Zmenil jsem prist.prava porad nic.

root@ubuntu:/var/log/mysql# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.
.
...failed or took more than 6s.
        Please take a look at the syslog.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

[razor]

Experimentálně bych skusil vypnout binární logování jestli ho máš zaplé . Ten soubor /var/log/mysql/mysql-bin.index by se měl totiž právě týkat binárních logů.

[---]

Ahoj, řešení je jednoduché :)

1)Jako root pust si mc
2)jdi do adresare cd /var/log
3)vytvor adresar mysql
4)Tukni na Soubor > zmena vlastnika
5)v obou polozkach vyber mysql
6)Tukni na nastav
7)Prejdi na adresarcd /etc/init.d
8)./myslq start

Jan

[bedna]

Pozri na http://webixon.php5.sk