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 and mysql trouble

Discussion in 'Database Discussions' started by lordnight666, Feb 6, 2014.

  1. lordnight666

    lordnight666 Registered

    Joined:
    Feb 6, 2014
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Mysql give me : The mysql server is offline. But I can connect on it and everythings is working.
    I think it's the mysql.sock but it's where he need to.

    Phpmyadmin : [2014-02-06 10:08:10 -0500] die [cpsrvd-ssl] Attempting to drop privileges to root. at /usr/local/cpanel/Cpanel/AccessIds/ReducedPrivileges.pm line 141
    Cpanel::AccessIds::ReducedPrivileges::_prevent_dropping_to_root(0, 0) called at /usr/local/cpanel/Cpanel/AccessIds/ReducedPrivileges.pm line 43
    Cpanel::AccessIds::ReducedPrivileges::new('Cpanel::AccessIds::ReducedPrivileges', 'admin') called at /usr/local/cpanel/Cpanel/MysqlUtils/MyCnf/Basic.pm line 98
    Cpanel::MysqlUtils::MyCnf::Basic::_getmydbparm('pass') called at /usr/local/cpanel/Cpanel/MysqlUtils/MyCnf/Basic.pm line 112
    Cpanel::MysqlUtils::MyCnf::Basic::getmydbpass() called at cpsrvd-ssl line 5916
    main::getuids_whostmgrd() called at cpsrvd-ssl line 1319
    main::handle_one_connection() called at cpsrvd-ssl line 995
    Internal Server Error: "GET /cpsess5919590757/3rdparty/phpMyAdmin/index.php HTTP/1.1" 500 exit level [die] [pid=69296] (Attempting to drop privileges to root.)

    Working for user but not for root .. Anyone can help me ?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Verify that MySQL is able to start successfully and is running without error:

    Code:
    service mysql restart
    mysqladmin processlist
    tail -f /var/lib/mysql/$hostname.err
    
    You can also force an update of phpMyAdmin via:

    Code:
    /usr/local/cpanel/bin/updatephpmyadmin --force
    Thank you.
     
  3. lordnight666

    lordnight666 Registered

    Joined:
    Feb 6, 2014
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi Michael, i've restarted mysql and no error found, i've try to update phpmyadmin too and I got the same error when i click on phpmyadmin in the whm panel.

    Internal Server Error

    500

    exit level [die] [pid=116451] (Attempting to drop privileges to root.)

    Mysql running great but i can't access phpmyadmin for root only.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Could you open a support ticket using the link in my signature so we can take a closer look? You can post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
  5. lordnight666

    lordnight666 Registered

    Joined:
    Feb 6, 2014
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Your Request id is: 4542565.
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    To update, we were unable to reproduce this issue due to a lack of authentication details. Feel free to respond to the ticket with those details if you want us to investigate further.

    Thank you.
     
  7. lordnight666

    lordnight666 Registered

    Joined:
    Feb 6, 2014
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hey Micheal, can you check my ticket now ? I can't do backup from about 2 week ..
     
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    To update, here is a brief snippet from one of our support analysts:

    Thank you.
     
Loading...

Share This Page