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.

Phpmyadmin error #2002

Discussion in 'Database Discussions' started by Naatan, Jun 8, 2008.

  1. Naatan

    Naatan Member

    Joined:
    Jun 6, 2008
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    Hi, I am currently getting the following error when trying to start phpmyadmin

    phpMyAdmin - Error

    #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

    I googled the error and fount the following info, which did not work for me

    http://www.keithdmitchell.com/archives/23

    The socket variable wasn't set by default so I added it, but as said, without prevail.

    It worked yesterday, but after the update I performed it stopped working (I updated to the latest release, no development build or anything).

    After the update I did have a problem with MySQL, it wouldn't start, said it couldn't close some pid, I googled that problem as well and noticed a lot of people with the same problem but no clear solution, however after rebooting my server MySQL came up fine, but it looks like cPanel missed out on a few steps in between.

    Does anyone know how to resolve this?

    Thank you.
     
  2. Naatan

    Naatan Member

    Joined:
    Jun 6, 2008
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    I've forced an update of cpanel, this time it completed without any errors, but phpmyadmin still won't work.
     
  3. UBERHOST

    UBERHOST Well-Known Member

    Joined:
    Jan 13, 2008
    Messages:
    102
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    California, US
  4. Naatan

    Naatan Member

    Joined:
    Jun 6, 2008
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    I've just tried it, the reinstall went fine, but phpmyadmin still doesn't work.. still the exact same error :(
     
  5. Naatan

    Naatan Member

    Joined:
    Jun 6, 2008
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    Nevermind that, I was simply refreshing, and the error page was in the uri :p so I was getting the error regardless.. stupid me.

    I have a followup problem though, now when I try to access phpmyadmin I get;


    Warning: session_start() [function.session-start]: SQLite: failed to open/create session database `/var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb' - malformed database schema - unable to open a temporary database file for storing temporary tables in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/session.inc.php on line 86

    Fatal error: session_start() [<a href='function.session-start'>function.session-start</a>]: Failed to initialize storage module: sqlite (path: /var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/session.inc.php on line 86

    sqlite??? wtf?
     
  6. Naatan

    Naatan Member

    Joined:
    Jun 6, 2008
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    Hallelujah, downgraded to STABLE and everything is fine again.
     
  7. hostproof

    hostproof Member

    Joined:
    Mar 9, 2003
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Europe
    I have the same problem but I'm on stable?
     
  8. hostproof

    hostproof Member

    Joined:
    Mar 9, 2003
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Europe
  9. thobarn

    thobarn Well-Known Member

    Joined:
    Apr 25, 2008
    Messages:
    153
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    sanctum sanctorum
    I am receiving the same error and none of the suggestions in this thread helped so far.

    WHM 11.23.2 cPanel 11.23.3-C26039
    CENTOS Enterprise 5.2 i686 on virtuozzo - WHM X v3.1.0
     
  10. xidica

    xidica Well-Known Member

    Joined:
    Apr 21, 2005
    Messages:
    63
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Texas
    ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
     
  11. thobarn

    thobarn Well-Known Member

    Joined:
    Apr 25, 2008
    Messages:
    153
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    sanctum sanctorum
    Thanks but I already tried this as was suggested in the thread referred to by hostproof above. I will try the EDGE to see if it will resolve.
     
  12. thobarn

    thobarn Well-Known Member

    Joined:
    Apr 25, 2008
    Messages:
    153
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    sanctum sanctorum
    after upgrading to 11.23.3-E26041 this issue is resolved; phpmyadmin is accessible again, though not ideal to be running EDGE to get a DB UI running :(
     
  13. dflteche

    dflteche Member

    Joined:
    Dec 30, 2007
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    Hi,
    I might be late in this post, but a simple solution to this problem is:

    check with the permissions on /tmp
    it should be:
    1777

    chmod 1777 /tmp

    Once this is setup, simply run this script:

    /scripts/cleanphpsessions

    Thats it, you are done, check with phpmyadmin now
     
  14. hostproof

    hostproof Member

    Joined:
    Mar 9, 2003
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Europe
  15. xyber13

    xyber13 Well-Known Member

    Joined:
    May 30, 2006
    Messages:
    63
    Likes Received:
    0
    Trophy Points:
    6
    MYSQL Root Password

    Hi Guys,

    Was just wondering if its because any of you guys actually added a MYSQL root password containing special characters...

    Rgrds,
    -Xyber.
     
  16. Bakadesu

    Bakadesu Member

    Joined:
    Feb 11, 2005
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    Just a heads up for the people that couldn't get

    /scripts/restartsrv_mysql --check

    to work:

    Try closing the phpMyAdmin window and open phpMyAdmin again through cpanel after you have run /scripts/restartsrv_mysql --check The page is an error page and will always show that error even though it's fixed.
     
Loading...

Share This Page