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 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:
    1
    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:
    1
    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:
    1
    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:
    1
    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:
    1
    #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:
    38
    also those solution don't fix the mysql problem ...


    darkorbbbbbbb ????
     
  7. cyrus

    cyrus Member

    Joined:
    Mar 1, 2005
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    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