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!

Phpmyadmin error #2002

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

  1. Naatan

    Naatan Member

    Joined:
    Jun 6, 2008
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    51
    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:
    51
    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:
    66
    Location:
    California, US
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. Naatan

    Naatan Member

    Joined:
    Jun 6, 2008
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    51
    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:
    51
    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:
    51
    Hallelujah, downgraded to STABLE and everything is fine again.
     
  7. hostproof

    hostproof Member

    Joined:
    Mar 9, 2003
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    151
    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:
    151
    Location:
    Europe
  9. thobarn

    thobarn Well-Known Member

    Joined:
    Apr 25, 2008
    Messages:
    152
    Likes Received:
    1
    Trophy Points:
    68
    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:
    156
    Location:
    Texas
    ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
     
  11. thobarn

    thobarn Well-Known Member

    Joined:
    Apr 25, 2008
    Messages:
    152
    Likes Received:
    1
    Trophy Points:
    68
    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:
    152
    Likes Received:
    1
    Trophy Points:
    68
    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:
    51
    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:
    151
    Location:
    Europe
  15. xyber13

    xyber13 Well-Known Member

    Joined:
    May 30, 2006
    Messages:
    63
    Likes Received:
    0
    Trophy Points:
    156
    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:
    151
    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

  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