+ Responder ao Tópico



  1. 08-07-2005, 21:30 #1
    fred_m
    fred_m está desconectado
    Avatar de fred_m
    Ingresso
    May 2004
    Posts
    449

    Padrão Bronca GRAAAANDE mo Mysql

    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
    Citação Citação
  2. 08-07-2005, 21:37 #2
    oyama
    oyama está desconectado
    Avatar de oyama
    Ingresso
    Apr 2004
    Posts
    1.327

    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/
    Citação Citação
  3. 08-07-2005, 22:53 #3
    ruyneto
    ruyneto está desconectado
    Avatar de ruyneto
    Ingresso
    Jul 2004
    Posts
    2.957
    Posts de Blog
    3

    Padrão Bronca GRAAAANDE mo Mysql

    Cara ja nao tem um mysql instalado ae nao??

    falows
    Citação Citação
  4. 09-07-2005, 10:11 #4
    gatoseco
    gatoseco está desconectado
    Avatar de gatoseco
    Ingresso
    Nov 2004
    Posts
    1.684

    Padrão Bronca GRAAAANDE mo Mysql

    Sinceramente e o que ta parecendo !!! hehehe
    Citação Citação
  5. 09-07-2005, 11:10 #5
    fred_m
    fred_m está desconectado
    Avatar de fred_m
    Ingresso
    May 2004
    Posts
    449

    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.
    Citação Citação
  6. 09-07-2005, 11:17 #6
    ruyneto
    ruyneto está desconectado
    Avatar de ruyneto
    Ingresso
    Jul 2004
    Posts
    2.957
    Posts de Blog
    3

    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
    Citação Citação
  7. 09-07-2005, 11:27 #7
    fred_m
    fred_m está desconectado
    Avatar de fred_m
    Ingresso
    May 2004
    Posts
    449

    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.
    Citação Citação



« Tópico Anterior | Próximo Tópico »