Phpmyadmin and mysql trouble

lordnight666

• February 06, 2014 09:16

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 ?

• 

  cPanelMichael

  • February 06, 2014 15:26

  Hello :) Verify that MySQL is able to start successfully and is running without error: service mysql restart mysqladmin processlist tail -f /var/lib/mysql/$hostname.err
  You can also force an update of phpMyAdmin via: /usr/local/cpanel/bin/updatephpmyadmin --force
  Thank you.

  0
• 

  lordnight666

  • February 06, 2014 15:49

  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.

  0
• 

  cPanelMichael

  • February 06, 2014 16:01

  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.

  0
• 

  lordnight666

  • February 06, 2014 16:08

  Your Request id is: 4542565.

  0
• 

  cPanelMichael

  • February 10, 2014 17:08

  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.

  0
• 

  lordnight666

  • February 26, 2014 13:32

  Hey Micheal, can you check my ticket now ? I can't do backup from about 2 week ..

  0
• 

  cPanelMichael

  • February 26, 2014 15:04

  To update, here is a brief snippet from one of our support analysts: [QUOTE]I found an extra user with UID 0 which is the 'root' UID. It is not standard practice to have more than one user with the same UID, even for administration purposes. Other administration users should have a different UID and they should then use "sudo" or "su" to gain root privileges. If you continue to have problems with the backups, please try removing the "admin" user.
  Thank you.

  0

Please sign in to leave a comment.