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.

/easyapache took down MySQL on the whole server?

Discussion in 'EasyApache' started by DWHS.net, Jun 19, 2003.

  1. DWHS.net

    DWHS.net Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,569
    Likes Received:
    6
    Trophy Points:
    38
    Location:
    LA, Costa RIca
    cPanel Access Level:
    Root Administrator
    Here is the error for every site, and every option when trying to work with MySQL:

    mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect

    It's like it's gone completely.:confused:

    I chose the advanced option but left all the default options and added GD, cross protect., and raised apache limit.

    Any thoughts?


    Another thought is a step by step on upgrading without easy/apache/ if this was a populated server the problem would be huge...

    Thanks,

    cPanel.net Support Ticket Number:
     
  2. tAzMaNiAc

    tAzMaNiAc Well-Known Member

    Joined:
    Feb 16, 2003
    Messages:
    559
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Sachse, TX
    I thought MySQL and Apache are two completely different entities.. Have you restarted MySQL from WHM?

    cPanel.net Support Ticket Number:
     
  3. ciphervendor

    ciphervendor Well-Known Member

    Joined:
    Aug 26, 2002
    Messages:
    1,052
    Likes Received:
    0
    Trophy Points:
    36
    ps -auxxx | grep mysql

    Does this show a bunch of MySQL processes with your grep process at the bottom?

    If so, then:

    ls -la /tmp/mysql.sock

    Does this return a result? Or do you get an error like: /bin/ls: /tmp/nothing: No such file or directory

    If you don't get an error, then:

    edit /etc/my.cnf
    insert under [mysqld]: socket=/var/lib/mysql/mysql.sock
    save & close.
    service mysql stop
    service mysql start

    If you do get an error, then: service mysql start

    cPanel.net Support Ticket Number:
     
  4. grey259

    grey259 Registered

    Joined:
    Apr 19, 2003
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    I have the same problem and followed those steps but it didn't work.

    ls -la /tmp/mysql.sock
    lrwxrwxrwx 1 root root 25 Apr 17 20:28 /tmp/mysql.sock -> /var/lib/mysql/mysql.sock

    I then edited the /etc/my.cnf file

    root@river [~]# service mysql stop
    No mysqld pid file found. Looked for /var/lib/mysql/river.tsnhost.com.pid.
    root@river [~]# service mysql start
    root@river [~]# Starting mysqld daemon with databases from /var/lib/mysql
    030619 22:31:26 mysqld ended

    cPanel.net Support Ticket Number:
     
  5. ciphervendor

    ciphervendor Well-Known Member

    Joined:
    Aug 26, 2002
    Messages:
    1,052
    Likes Received:
    0
    Trophy Points:
    36
    tail -f /var/lib/mysql/river.tsnhost.com.err what do you see?

    What are the permissions/ownership like on /var/lib/mysql and /var/lib/mysql/* ?

    cPanel.net Support Ticket Number:
     
  6. DWHS.net

    DWHS.net Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,569
    Likes Received:
    6
    Trophy Points:
    38
    Location:
    LA, Costa RIca
    cPanel Access Level:
    Root Administrator
    I did the reboot from my sql and got the error from above, but i rebooted the server and it kicked in.

    To be honest I am not sure what the heck this is and how a reboot can differ from the restart services.

    I also don't know why easy Apache would of effected this. I also did the upgrade 7, so it may of this been that some how.

    It's All fixed now from the reboot. I guess I should of rebooted before posting. :eek: Shoulda, woulda,



    Thanks for all the help,

    cPanel.net Support Ticket Number:
     
  7. nitromax

    nitromax Well-Known Member

    Joined:
    Feb 12, 2002
    Messages:
    189
    Likes Received:
    0
    Trophy Points:
    16
    I had been running MySQL 4 for over a month with no problems. Then I updated to WHM 7.1.0 cPanel 7.1.0-R20. Still no problems at this point. Then I updated /scripts/easyapache to the July 1st build. At that point MySQL gave me the following error:

    Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)


    Then after trying some of the suggestions the error changed to this:

    Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)


    I followed the directions in all of the related posts and nothing seemed to work for me. So here is what I did to finally make it work:

    I read a post at the RackShack forum that the following needed to be in the /etc/my.cnf file:

    [mysqld]
    set-variable = max_connections=500

    [client]
    port = 3306
    socket = /tmp/mysql.sock
    [mysqld]
    port = 3306
    socket = /tmp/mysql.sock


    I only had the first 2 lines, so I added the [client] and [mysqld] parts.


    Then I shut down mysql and chkservd with the following commands:

    service mysql stop
    /etc/rc.d/init.d/chkservd stop


    Then I removed the following files:

    rm -rf /tmp/mysql.sock
    rm -rf /var/lib/mysql/mysql.sock


    Now restart mysql and chkservd with the following commands and mysql will create the mysql.sock file in the /tmp directory as oulined in the updated my.cnf file:

    service mysql start
    /etc/rc.d/init.d/chkservd start


    Now create the softlink with this:

    ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock


    There were a couple of variations in that last last command to create the softlink. I guess it depends on where mysql creates the mysql.sock file when it starts. So if you are trouble shooting you might shut down mysql as shown above, then remove the mysql.sock files. Then restart mysql as shown above and see where it creates the mysql.sock file. If it creates it in the /tmp directory then you need the softlink command shown above. If it creates the mysql.sock file in the /var/lib/mysql directory then you problaby need to use the softlink command like this as shown in some of the other related posts:

    ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock


    That worked for me. Hope this helps someone down the line.

    cPanel.net Support Ticket Number:
     
  8. NocTurNalFX

    NocTurNalFX Active Member

    Joined:
    Jan 24, 2003
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    I am having the same error, I have tried all of the above and i still have the problem


    Any more suggestions?

    cPanel.net Support Ticket Number:
     
  9. DWHS.net

    DWHS.net Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,569
    Likes Received:
    6
    Trophy Points:
    38
    Location:
    LA, Costa RIca
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page