Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MySQL failed

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

Page 1 of 2
  1. totalufo

    totalufo Well-Known Member

    Joined:
    Jan 17, 2002
    Messages:
    160
    Likes Received:
    0
    Trophy Points:
    316
    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
     
    #1 totalufo, Mar 7, 2002
  2. feanor

    feanor Well-Known Member

    Joined:
    Aug 13, 2001
    Messages:
    836
    Likes Received:
    0
    Trophy Points:
    316
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 feanor, Mar 7, 2002
  3. totalufo

    totalufo Well-Known Member

    Joined:
    Jan 17, 2002
    Messages:
    160
    Likes Received:
    0
    Trophy Points:
    316
    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*
     
    #3 totalufo, Mar 7, 2002
  4. feanor

    feanor Well-Known Member

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

    come on and kick me....
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 feanor, Mar 7, 2002
  5. totalufo

    totalufo Well-Known Member

    Joined:
    Jan 17, 2002
    Messages:
    160
    Likes Received:
    0
    Trophy Points:
    316
    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]#
     
    #5 totalufo, Mar 7, 2002
  6. feanor

    feanor Well-Known Member

    Joined:
    Aug 13, 2001
    Messages:
    836
    Likes Received:
    0
    Trophy Points:
    316
    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?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 feanor, Mar 7, 2002
  7. totalufo

    totalufo Well-Known Member

    Joined:
    Jan 17, 2002
    Messages:
    160
    Likes Received:
    0
    Trophy Points:
    316
    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.
     
    #7 totalufo, Mar 7, 2002
  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
     
    #8 bdraco, Mar 7, 2002
  9. totalufo

    totalufo Well-Known Member

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

    chmod: invalid mode string: `mysql:mysql'

    What am I missing?
     
    #9 totalufo, Mar 7, 2002
  10. feanor

    feanor Well-Known Member

    Joined:
    Aug 13, 2001
    Messages:
    836
    Likes Received:
    0
    Trophy Points:
    316
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #10 feanor, Mar 7, 2002
  11. totalufo

    totalufo Well-Known Member

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

    chmod: invalid mode string: `mysql.mysql'

    what next?

    Thanks in advance
     
    #11 totalufo, Mar 8, 2002
  12. awsol

    awsol cPanel Test Bitch

    Joined:
    Feb 8, 2002
    Messages:
    591
    Likes Received:
    0
    Trophy Points:
    316
    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.
     
    #12 awsol, Mar 8, 2002
  13. totalufo

    totalufo Well-Known Member

    Joined:
    Jan 17, 2002
    Messages:
    160
    Likes Received:
    0
    Trophy Points:
    316
    just in case. What folder should I do it in then?
     
    #13 totalufo, Mar 8, 2002
  14. awsol

    awsol cPanel Test Bitch

    Joined:
    Feb 8, 2002
    Messages:
    591
    Likes Received:
    0
    Trophy Points:
    316
    Location:
    Boston MA
    /var/lib/mysql
     
    #14 awsol, Mar 8, 2002
  15. totalufo

    totalufo Well-Known Member

    Joined:
    Jan 17, 2002
    Messages:
    160
    Likes Received:
    0
    Trophy Points:
    316
    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.
     
    #15 totalufo, Mar 8, 2002
  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
     
    #16 bdraco, Mar 8, 2002
  17. totalufo

    totalufo Well-Known Member

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

    totalufo Well-Known Member

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

    feanor Well-Known Member

    Joined:
    Aug 13, 2001
    Messages:
    836
    Likes Received:
    0
    Trophy Points:
    316
    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)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #19 feanor, Mar 8, 2002
  20. totalufo

    totalufo Well-Known Member

    Joined:
    Jan 17, 2002
    Messages:
    160
    Likes Received:
    0
    Trophy Points:
    316
    This is my clients server actually. I'm not sure what he did. I'm not sure which version of MySQL this is.
     
    #20 totalufo, Mar 8, 2002
(You must log in or sign up to post here.)
Page 1 of 2
Loading...
Similar Threads - MySQL failed
  1. Jeff P.

    [CPANEL-23547] MySQL down after failed MariaDB upgrade

    Jeff P., Nov 7, 2018, in forum: Database Discussion
    Replies:
    12
    Views:
    115
    cPanelMichael
    Nov 8, 2018
  2. martin MHC

    MySQL 5.7 phpmyadmin failed access for root user only

    martin MHC, Nov 5, 2018, in forum: Database Discussion
    Replies:
    4
    Views:
    116
    martin MHC
    Nov 9, 2018
  3. steven_h

    The system failed to connect to the MySQL database issue

    steven_h, Sep 11, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    334
    steven_h
    Sep 18, 2018
  4. conductexam

    Connection refusedFailed to connect to MySQL

    conductexam, Aug 9, 2018, in forum: Database Discussion
    Replies:
    7
    Views:
    220
    cPanelLauren
    Aug 13, 2018
  5. udee

    The system failed to drop the MySQL user error

    udee, Jul 14, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    199
    cPanelMichael
    Jul 16, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice