+ Responder ao Tópico



  1. #1

    Padrão Bronca GRAAAANDE mo Mysql

    Pessoal,

    Estou enfrentando a maior bronca aqui no meu mysql, quando o instalo, recebo os segintes erros:

    [[email protected] 4.1.12]# rpm -ivh MySQL-server-4.1.12-1.i386.rpm
    aviso: MySQL-server-4.1.12-1.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
    A preparar... ########################################### [100%]
    1:MySQL-server ########################################### [100%]
    050708 21:28:34 [Warning] Asked for 196608 thread stack, but got 126976
    050708 21:28:34 [Warning] Can't create test file /var/lib/mysql/fred.lower-test
    ERROR: 1 Can't create/write to file './mysql/db.frm' (Errcode: 13)
    ERROR: 1146 Table 'mysql.db' doesn't exist
    ERROR: 1146 Table 'mysql.db' doesn't exist
    ERROR: 1 Can't create/write to file './mysql/host.frm' (Errcode: 13)
    ERROR: 1 Can't create/write to file './mysql/user.frm' (Errcode: 13)
    ERROR: 1146 Table 'mysql.user' doesn't exist
    ERROR: 1146 Table 'mysql.user' doesn't exist
    ERROR: 1146 Table 'mysql.user' doesn't exist
    ERROR: 1146 Table 'mysql.user' doesn't exist
    ERROR: 1 Can't create/write to file './mysql/func.frm' (Errcode: 13)
    ERROR: 1 Can't create/write to file './mysql/tables_priv.frm' (Errcode: 13)
    ERROR: 1 Can't create/write to file './mysql/columns_priv.frm' (Errcode: 13)
    ERROR: 1 Can't create/write to file './mysql/help_topic.frm' (Errcode: 13)
    ERROR: 1 Can't create/write to file './mysql/help_category.frm' (Errcode: 13)
    ERROR: 1 Can't create/write to file './mysql/help_relation.frm' (Errcode: 13)
    ERROR: 1 Can't create/write to file './mysql/help_keyword.frm' (Errcode: 13)
    ERROR: 1 Can't create/write to file './mysql/time_zone_name.frm' (Errcode: 13)
    ERROR: 1 Can't create/write to file './mysql/time_zone.frm' (Errcode: 13)
    ERROR: 1 Can't create/write to file './mysql/time_zone_transition.frm' (Errcode: 13)
    ERROR: 1 Can't create/write to file './mysql/time_zone_transition_type.frm' (Errcode: 13)
    ERROR: 1 Can't create/write to file './mysql/time_zone_leap_second.frm' (Errcode: 13)
    050708 21:28:34 [Warning] Asked for 196608 thread stack, but got 126976
    050708 21:28:34 [Warning] Can't create test file /var/lib/mysql/fred.lower-test
    ERROR: 1146 Table 'mysql.help_topic' doesn't exist
    ERROR: 1146 Table 'mysql.help_category' doesn't exist
    ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_category' doesn't exist
    ERROR: 1146 Table 'mysql.help_category' doesn't exist
    ERROR: 1146 Table 'mysql.help_topic' doesn't exist
    ERROR: 1146 Table 'mysql.help_topic' doesn't exist
    ERROR: 1146 Table 'mysql.help_topic' doesn't exist
    ERROR: 1146 Table 'mysql.help_topic' doesn't exist
    ERROR: 1146 Table 'mysql.help_topic' doesn't exist
    ERROR: 1146 Table 'mysql.help_topic' doesn't exist
    ERROR: 1146 Table 'mysql.help_topic' doesn't exist
    ERROR: 1146 Table 'mysql.help_topic' doesn't exist
    ERROR: 1146 Table 'mysql.help_topic' doesn't exist
    ERROR: 1146 Table 'mysql.help_topic' doesn't exist
    ERROR: 1146 Table 'mysql.help_topic' doesn't exist
    ERROR: 1146 Table 'mysql.help_topic' doesn't exist
    ERROR: 1146 Table 'mysql.help_topic' doesn't exist
    ERROR: 1146 Table 'mysql.help_topic' doesn't exist
    ERROR: 1146 Table 'mysql.help_topic' doesn't exist
    ERROR: 1146 Table 'mysql.help_topic' doesn't exist
    ERROR: 1146 Table 'mysql.help_topic' doesn't exist
    ERROR: 1146 Table 'mysql.help_topic' doesn't exist
    ERROR: 1146 Table 'mysql.help_topic' doesn't exist
    ERROR: 1146 Table 'mysql.help_topic' doesn't exist
    ERROR: 1146 Table 'mysql.help_topic' doesn't exist
    ERROR: 1146 Table 'mysql.help_topic' doesn't exist
    ERROR: 1146 Table 'mysql.help_topic' doesn't exist
    ERROR: 1146 Table 'mysql.help_topic' doesn't exist
    ERROR: 1146 Table 'mysql.help_topic' doesn't exist
    ERROR: 1146 Table 'mysql.help_topic' doesn't exist
    ERROR: 1146 Table 'mysql.help_topic' doesn't exist
    ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
    ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
    ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
    ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
    ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
    ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
    ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
    ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
    ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
    ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
    ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
    ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
    ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
    ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
    ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
    ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
    ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
    ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
    ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
    ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
    ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
    ERROR: 1146 Table 'mysql.help_keyword' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    ERROR: 1146 Table 'mysql.help_relation' doesn't exist
    PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
    To do so, start the server, then issue the following commands:
    /usr/bin/mysqladmin -u root password 'new-password'
    /usr/bin/mysqladmin -u root -h fred password 'new-password'
    See the manual for more instructions.

    Please report any problems with the /usr/bin/mysqlbug script!

    The latest information about MySQL is available on the web at
    http://www.mysql.com
    Support MySQL by buying support/licenses at https://order.mysql.com
    Starting MySQL...................................[FALHOU]
    [[email protected] 4.1.12]#

    Logado no arquivo /var/log/mysql.log

    [[email protected] 4.1.12]# tail -f /var/log/mysqld.log
    050708 21:28:35 [Warning] Asked for 196608 thread stack, but got 126976
    050708 21:28:35 [Warning] Can't create test file /var/lib/mysql/fred.lower-test
    050708 21:28:35 [ERROR] Can't start server : Bind on unix socket: Permission denied
    050708 21:28:35 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
    050708 21:28:35 [ERROR] Aborting

    050708 21:28:35 [Note] /usr/sbin/mysqld: Shutdown complete

    050708 21:28:35 mysqld ended

    Logado no arquivo /var/log/messages
    Jul 8 21:28:34 fred kernel: audit(1120868914.306:0): avc: denied { write } for pid=5549 exe=/usr/sbin/mysqld name=mysql dev=hda7 ino=99709 scontext=root:system_r:mysqld_t tcontext=rootbject_r:var_lib_t tclass=dir
    Jul 8 21:28:34 fred kernel: audit(1120868914.332:0): avc: denied { write } for pid=5553 exe=/usr/sbin/mysqld name=mysql dev=hda7 ino=99710 scontext=root:system_r:mysqld_t tcontext=rootbject_r:var_lib_t tclass=dir
    Jul 8 21:28:34 fred kernel: audit(1120868914.353:0): avc: denied { write } for pid=5553 exe=/usr/sbin/mysqld name=mysql dev=hda7 ino=99710 scontext=root:system_r:mysqld_t tcontext=rootbject_r:var_lib_t tclass=dir
    Jul 8 21:28:34 fred kernel: audit(1120868914.354:0): avc: denied { write } for pid=5553 exe=/usr/sbin/mysqld name=mysql dev=hda7 ino=99710 scontext=root:system_r:mysqld_t tcontext=rootbject_r:var_lib_t tclass=dir
    Jul 8 21:28:34 fred kernel: audit(1120868914.370:0): avc: denied { write } for pid=5553 exe=/usr/sbin/mysqld name=mysql dev=hda7 ino=99710 scontext=root:system_r:mysqld_t tcontext=rootbject_r:var_lib_t tclass=dir
    Jul 8 21:28:34 fred kernel: audit(1120868914.399:0): avc: denied { write } for pid=5553 exe=/usr/sbin/mysqld name=mysql dev=hda7 ino=99710 scontext=root:system_r:mysqld_t tcontext=rootbject_r:var_lib_t tclass=dir
    Jul 8 21:28:34 fred kernel: audit(1120868914.400:0): avc: denied { write } for pid=5553 exe=/usr/sbin/mysqld name=mysql dev=hda7 ino=99710 scontext=root:system_r:mysqld_t tcontext=rootbject_r:var_lib_t tclass=dir
    Jul 8 21:28:34 fred kernel: audit(1120868914.416:0): avc: denied { write } for pid=5553 exe=/usr/sbin/mysqld name=mysql dev=hda7 ino=99710 scontext=root:system_r:mysqld_t tcontext=rootbject_r:var_lib_t tclass=dir
    Jul 8 21:28:34 fred kernel: audit(1120868914.455:0): avc: denied { write } for pid=5553 exe=/usr/sbin/mysqld name=mysql dev=hda7 ino=99710 scontext=root:system_r:mysqld_t tcontext=rootbject_r:var_lib_t tclass=dir
    Jul 8 21:28:34 fred kernel: audit(1120868914.491:0): avc: denied { write } for pid=5557 exe=/usr/sbin/mysqld name=mysql dev=hda7 ino=99709 scontext=root:system_r:mysqld_t tcontext=rootbject_r:var_lib_t tclass=dir
    Jul 8 21:28:35 fred kernel: audit(1120868915.405:0): avc: denied { write } for pid=5606 exe=/usr/sbin/mysqld name=mysql dev=hda7 ino=99709 scontext=root:system_r:mysqld_t tcontext=rootbject_r:var_lib_t tclass=dir
    Jul 8 21:28:35 fred kernel: audit(1120868915.407:0): avc: denied { write } for pid=5606 exe=/usr/sbin/mysqld name=mysql dev=hda7 ino=99709 scontext=root:system_r:mysqld_t tcontext=rootbject_r:var_lib_t tclass=dir
    Jul 8 21:29:11 fred lsb_log_message: failed

  2. #2

    Padrão Bronca GRAAAANDE mo Mysql

    Parece que ele esta dando erro de permissão neste diretorio /var/lib/mysql/ vc ja verificou se ele existe? se existir vc pode mover para outra pasta e veja no que dá. outra solucao seria vc da permissao total ao dir chmod 777 /var/lib/mysql/



  3. #3

    Padrão Bronca GRAAAANDE mo Mysql

    Cara ja nao tem um mysql instalado ae nao??

    falows

  4. #4

    Padrão Bronca GRAAAANDE mo Mysql

    Sinceramente e o que ta parecendo !!! hehehe



  5. #5

    Padrão Bronca GRAAAANDE mo Mysql

    O diretório existia, já havia colocado a permissão total nele.
    Desinnstaei o mysql, e quando instalava novamente me aparecia esse erro.
    Eu deeletava o diretório, removia o usuario e grupo mysql para que o instalador os criasse, e nada feito.

    Não sei o que cargas d'água aconteceu.

    A solução foi reinstalar o Linux.
    Ai funcionou correamente.

  6. #6

    Padrão Bronca GRAAAANDE mo Mysql

    cara quando der esse problemas da um rpm -Uvh nomedoarquivo.rpm pq ae se o arquivo ja exite ele atualiza, se nao existe ele instala

    falows



  7. #7

    Padrão Bronca GRAAAANDE mo Mysql

    Meu velho.
    Eu já havia tentado isso. Meu mysql era da versão 3.xx tentei atualizálo para 4.1.12 eo problema continuou.

    Eu tentei de tudo.