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 after - tweek settings -

Discussion in 'General Discussion' started by kerm1t, May 6, 2005.

  1. kerm1t

    kerm1t Member

    Joined:
    May 6, 2005
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    151
    Hello,

    I am currently running FreeBSD 5.3 w/ Cpanel, recently I went into "Tweek Settings" and applied a small change, nothing related to mysql. The next thing I know Cpanel states I have changed the MySQL version and to wait 30 seconds before clicking.. I forget which link. In the end the system appeared to update itself and then MySQL failed to start. Once I went to restart services and attempted to restart MySQL I received the following error,

    /usr/local/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! mysql has failed, please contact the sysadmin (result was "mysql has failed").


    I am open to any suggestions!
    Cheers,
    Kerm1t
     
  2. Bluexnet2

    Bluexnet2 Active Member

    Joined:
    Dec 4, 2003
    Messages:
    28
    Likes Received:
    0
    Trophy Points:
    151
    Hi Kerm1t,

    Try the "Reset Local MySQL Root Password" option in your WHM.

    Cheers
    Carlos
     
  3. kerm1t

    kerm1t Member

    Joined:
    May 6, 2005
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    151
    tried suggestion

    Thank you for your suggestion, Cpanel reports:
    Waiting for mysql to restart.....Done
    Changing Password....Done
    Fixing Mysql Privilege Table....Unknown argument '--verbose'
    Done
    Reloading Mysqld...
    Done
    Waiting for mysql to terminate.....

    Restarting mysql....Done

    The Mysql Root Password has been changed


    However, I do not see a running process when I issue ps -aux and the Service Status still reports mysql as failed. Since my last post, I ran /scripts/fixmysqlbsd and this did not solve the issue.

    Suggestion #2?

    Cheers,
    Kerm1t
     
  4. kerm1t

    kerm1t Member

    Joined:
    May 6, 2005
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    151
    Additional Info

    I just received this e-mail,
    mysql failed @ Thu May 5 23:15:41 2005. A restart was attempted automagicly.

    -Kerm1t
     
  5. Bluexnet2

    Bluexnet2 Active Member

    Joined:
    Dec 4, 2003
    Messages:
    28
    Likes Received:
    0
    Trophy Points:
    151
    #5 Bluexnet2, May 6, 2005
    Last edited: May 6, 2005
  6. Radio_Head

    Radio_Head Well-Known Member

    Joined:
    Feb 15, 2002
    Messages:
    2,051
    Likes Received:
    1
    Trophy Points:
    343
    also those solution don't fix the mysql problem ...


    darkorbbbbbbb ????
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. cyrus

    cyrus Member

    Joined:
    Mar 1, 2005
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    151
    I had the same problem, here's what I did:

    First check if chown is working, if you are getting a GLIBC error, then you are using a linux ELF file. Move /bin/chown to /bin/chown.old and make a symlink of /usr/sbin/chown to /bin/chown.


    Then check the perms of /var/db/mysql, it should be mysql:wheel and delete /var/db/ibdata1

    Edit the file /scripts/quickfixmysqlbsd
    Change the lines:

    system("pkg_add -v ftp://ftp.freebsd.org/pub/FreeBSD/ports/packages/databases/mysql-client-4.0.13.tgz
    pkg_add -v ftp://ftp.freebsd.org/pub/FreeBSD/ports/packages/databases/mysql-server-4.0.13_1.tgz


    TO

    system("pkg_add -v ftp://ftp.freebsd.org/pub/FreeBSD/ports/packages/databases/mysql-client-4.0.24.tbz
    pkg_add -v ftp://ftp.freebsd.org/pub/FreeBSD/ports/packages/databases/mysql-server-4.0.24_1.tbz

    note the change in version and file extenstions

    Run /scripts/quickfixmysqlbsd

    Once the installation is over, run /etc/rc.d/init.d/mysql start.

    Hopefully you should be good to go, but you will have to reset your mysq-root password.

    Cheers :)
     
Loading...

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.
    Dismiss Notice