Página 1 de 2 12 ÚltimoÚltimo
+ Responder ao Tópico



  1. Pessoal,

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

    [root@fred 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]
    [root@fred 4.1.12]#

    Logado no arquivo /var/log/mysql.log

    [root@fred 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. 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. Cara ja nao tem um mysql instalado ae nao??

    falows

  4. Sinceramente e o que ta parecendo !!! hehehe



  5. 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.






Tópicos Similares

  1. Radius com MySQL
    Por eclaudin no fórum Servidores de Rede
    Respostas: 1
    Último Post: 16-12-2002, 11:18
  2. Php com Mysql
    Por no fórum Servidores de Rede
    Respostas: 3
    Último Post: 07-10-2002, 16:13
  3. ERRO qdo crio uma chamada para o banco MYSQL
    Por thiagog no fórum Servidores de Rede
    Respostas: 3
    Último Post: 07-10-2002, 16:02
  4. Postfix+MySQL
    Por eclaudin no fórum Servidores de Rede
    Respostas: 0
    Último Post: 26-04-2002, 10:25
  5. configurando o mysql
    Por no fórum Servidores de Rede
    Respostas: 2
    Último Post: 28-03-2002, 10:52

Visite: BR-Linux ·  VivaOLinux ·  Dicas-L