The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL failed

Discussion in 'General Discussion' started by totalufo, Mar 7, 2002.

  1. totalufo

    totalufo Well-Known Member

    Joined:
    Jan 17, 2002
    Messages:
    160
    Likes Received:
    0
    Trophy Points:
    16
    I'm having trouble getting MySQL to work. Here's the message I get when I try to restart MySQL


    mysql status root 23318 0.3 0.2 2220 1028 ? S 17:33 0:00 /bin/sh /usr/bin/safe_mysqld --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/localhost.localdomain.pid



    mysql has failed, please contact the sysadmin.

    The weird thing is, under service status, I get a green light under MySQL.

    Also, when I tail the error logs, and messages, I get no errors. Any ideas?

    Thanks
     
  2. feanor

    feanor Well-Known Member

    Joined:
    Aug 13, 2001
    Messages:
    836
    Likes Received:
    0
    Trophy Points:
    16
    permissions on the directories are probably hosted

    what does /usr/lib/mysql look like for user and groups? And everything within?
    should be mysql.mysql or mysql.root on the top level and throughout all subdirectories/files

    I would also make sure you have the latest cpanel-support mysql RPM (/scripts/sysup)

    then restart mysql
     
  3. totalufo

    totalufo Well-Known Member

    Joined:
    Jan 17, 2002
    Messages:
    160
    Likes Received:
    0
    Trophy Points:
    16
    Here's what is in
    /usr/lib/mysql

    ./ libdbug.a* libmerge.a* libmyisammrg.a* libmysqlclient.la* libmysys.a* mysqld-max.sym*
    ../ libheap.a* libmyisam.a* libmysqlclient.a* libmystrings.a* libnisam.a* mysqld.sym*
     
  4. feanor

    feanor Well-Known Member

    Joined:
    Aug 13, 2001
    Messages:
    836
    Likes Received:
    0
    Trophy Points:
    16
    I meant /var/lib/mysql

    come on and kick me....
     
  5. totalufo

    totalufo Well-Known Member

    Joined:
    Jan 17, 2002
    Messages:
    160
    Likes Received:
    0
    Trophy Points:
    16
    ok, Here's what is there. You should know that all of the accounts you seel below were transfered from another server.

    ./ coleiras_pchat1/ hostmidi_modelo/ novolar_novolar/
    ../ comproco_loja/ hostmidi_pchat1/ orbitec_lojavirtual/
    aez_aez/ connectw_loja/ imerco_lojavirtual/ paineis_paineis/
    aezcom_loja/ decorale_deco/ imerco_pchat1/ paintba_loja/
    aezcom_pchat1/ deisi2_loja/ infocliq_lojavirtual/ papelari_admin/
    agitoweb_cartoes/ demo_pchat3/ infocliq_pchat3/ papelari_loja/
    aidiint1_loja/ demo_test/ iremar_mouse/ patio_patio/
    aidiinte_loja/ diabete_loja/ jampa_loja/ pcflorip_loja/
    aidirojo_loja/ dibianch_lojavirtual/ jampa_pchat1/ portofel_nuke/
    aidisabo_pchat1/ digital_loja/ kama_kb/ potatus_xmb1/
    aidisabo_xmb2/ digital_pchat1/ kar0919_pchat1/ premierc_pchat1/
    alba_loja/ digitals_teste/ lazio_agbook1/ protec_loja/
    alba_pchat1/ dvdsolut_portal/ lazio_xmb1/ prsnet_cadastro/
    anime_lojavirtual/ editorar_loja/ lhpolito_politobd/ prsnet_loja/
    antonioa_agbook1/ egshard_lojavirtual/ livjur_loja/ quality_loja/
    antonioa_agbook2/ egshard_xmb2/ localhost.localdomain.err rangel_dbRangel/
    artesana_loja/ existo_loja/ localhost.localdomain.pid riber_loja/
    bembolad_loja/ existo_teste/ lojanatu_lojavirtual/ rickmarx_enquete/
    bocadafo_4p/ express_loja/ louvores_pchat1/ rickmarx_sqlsql/
    bocadafo_pchat1/ fuj_pchat1/ mail/ rogercom_rogercom/
    brabra10_brasilplanet/ fuj_xmb1/ mapanet_busca/ rogercom_xmb1/
    brabra10_xmb1/ gfw_geral/ mapanet_noticias/ rs1_loja/
    bras2_finance/ gnomo_loja/ medical_loja/ rsracing_loja/
    bras2_pchat1/ golemco_golem/ milanez_cdshop/ ruana_xmb1/
    buckup_loja/ golemco_nuke/ milanez_visio/ sbr_/
    buiasbr_agbook1/ guiaimob_guiaimob/ mjronlin_loja/ senior_loja/
    buiasbr_loja/ guiaimob_pchat1/ monea_lojacrm/ sobrie_pchat1/
    buiasbr_pchat2/ guilherm_lojavirtual/ monte_loja/ sobrie_pchat2/
    bycodeb_loja/ hardking_loja/ movequip_lojavirtual/ softvixc_vendas/
    camarabr_webos/ hardware_loja/ muzi_loja/ test/
    cdsmil_portal/ hibris_webos/ mysql/ tigrenet_portal/
    claudio_pchat1/ hospede_mouse/ mysql.sock= tios_agbook1/
    cofscom_teste/ hospede_site/ ncviagem_loja_nc/ vavre_contatos/
    root@localhost [/var/lib/mysql]#
     
  6. feanor

    feanor Well-Known Member

    Joined:
    Aug 13, 2001
    Messages:
    836
    Likes Received:
    0
    Trophy Points:
    16
    See the main point here though, is WHICH user and group owns /var/lib/mysql ?

    Do this in /var/lib
    ls -la | grep mysql

    What do you get?
     
  7. totalufo

    totalufo Well-Known Member

    Joined:
    Jan 17, 2002
    Messages:
    160
    Likes Received:
    0
    Trophy Points:
    16
    Here's what I get.

    drwxr-xr-x 129 mysql root 4096 Mar 7 20:31 mysql/

    is that 735?
    What next?

    By the way, Thank you so much for taking the time to help me out.
     
  8. bdraco

    bdraco Guest

    [quote:99a66925db][i:99a66925db]Originally posted by totalufo[/i:99a66925db]

    Here's what I get.

    drwxr-xr-x 129 mysql root 4096 Mar 7 20:31 mysql/

    is that 735?
    What next?

    By the way, Thank you so much for taking the time to help me out.[/quote:99a66925db]

    chmod -R mysql:mysql -R /var/lib/mysql
     
  9. totalufo

    totalufo Well-Known Member

    Joined:
    Jan 17, 2002
    Messages:
    160
    Likes Received:
    0
    Trophy Points:
    16
    I copied and pasted that in and got this message

    chmod: invalid mode string: `mysql:mysql'

    What am I missing?
     
  10. feanor

    feanor Well-Known Member

    Joined:
    Aug 13, 2001
    Messages:
    836
    Likes Received:
    0
    Trophy Points:
    16
    Try this instead ;)

    user period group .. i'm not sure where that colon spawned from.

    then restart mysql (/etc/rc.d/init.d/mysql stop, and then start)


    chown -R mysql.mysql -R /var/lib/mysql
     
  11. totalufo

    totalufo Well-Known Member

    Joined:
    Jan 17, 2002
    Messages:
    160
    Likes Received:
    0
    Trophy Points:
    16
    I get this message now

    chmod: invalid mode string: `mysql.mysql'

    what next?

    Thanks in advance
     
  12. awsol

    awsol cPanel Test Bitch

    Joined:
    Feb 8, 2002
    Messages:
    591
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Boston MA
    lol just do this

    chown mysql.mysql *

    Make sure you do it in the right folder though. If you do it in the wrong folder you can spen endless hours fixing stuff.
     
  13. totalufo

    totalufo Well-Known Member

    Joined:
    Jan 17, 2002
    Messages:
    160
    Likes Received:
    0
    Trophy Points:
    16
    just in case. What folder should I do it in then?
     
  14. awsol

    awsol cPanel Test Bitch

    Joined:
    Feb 8, 2002
    Messages:
    591
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Boston MA
    /var/lib/mysql
     
  15. totalufo

    totalufo Well-Known Member

    Joined:
    Jan 17, 2002
    Messages:
    160
    Likes Received:
    0
    Trophy Points:
    16
    Thanks, unfortunatly, that did not fix it. what next? I feel like I've tried everything but I'm sure that is not the case.
     
  16. bdraco

    bdraco Guest

    [quote:cd4667da22][i:cd4667da22]Originally posted by totalufo[/i:cd4667da22]

    Thanks, unfortunatly, that did not fix it. what next? I feel like I've tried everything but I'm sure that is not the case.[/quote:cd4667da22]

    chown mysql:mysql -R /var/lib/mysql
    /sbin/server mysql start
     
  17. totalufo

    totalufo Well-Known Member

    Joined:
    Jan 17, 2002
    Messages:
    160
    Likes Received:
    0
    Trophy Points:
    16
    No luck. I'm trying a server reboot.
     
  18. totalufo

    totalufo Well-Known Member

    Joined:
    Jan 17, 2002
    Messages:
    160
    Likes Received:
    0
    Trophy Points:
    16
    Still down. Did I mentioned that all of these accounts were transfered over from another server?
     
  19. feanor

    feanor Well-Known Member

    Joined:
    Aug 13, 2001
    Messages:
    836
    Likes Received:
    0
    Trophy Points:
    16
    Did you transfer the master mysql db from the previous server to? I'm assuming you took all of /var/lib/mysql (and absolutely everything within), from one server to the other.

    Right?

    And you have Mysql version 3.23.45 here, right?
    (/scripts/sysup)
     
  20. totalufo

    totalufo Well-Known Member

    Joined:
    Jan 17, 2002
    Messages:
    160
    Likes Received:
    0
    Trophy Points:
    16
    This is my clients server actually. I'm not sure what he did. I'm not sure which version of MySQL this is.
     
Loading...

Share This Page