Skip to main content

phpMyAdmin Not Opening Properly

PCZero
A client contacted me today sayin phpMyAdmin was scrogged. I logged into cPanel and select phpMyAdmin. Instead of loading up, I was asked for the UID/PW again, entered it and got a massive amount of errors.
The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why. Or alternately go to 'Operations' tab of any database to set it up there. -------------------------------- Warning in ./libraries/plugins/auth/AuthenticationCpanel.php#627 mysqli_connect() expects parameter 5 to be long, string given Backtrace ./libraries/plugins/auth/AuthenticationCpanel.php#627: mysqli_connect( string ********, string ********, string ********, string ********, string ********, ) ./libraries/plugins/auth/AuthenticationCpanel.php#387: PMA\libraries\plugins\auth\AuthenticationCpanel::cp_mysql_auth_check( string 'xxxxxx', string 'xxxxxxxx', ) ./libraries/common.inc.php#752: PMA\libraries\plugins\auth\AuthenticationCpanel->authCheck() ./index.php#13: require_once(./libraries/common.inc.php) --------------------------- Notice in ./libraries/plugins/auth/AuthenticationCpanel.php#504 Undefined index: auth_type Backtrace ./libraries/common.inc.php#757: PMA\libraries\plugins\auth\AuthenticationCpanel->authSetUser() ./index.php#13: require_once(./libraries/common.inc.php) ---------------------------------- Your PHP MySQL library version 5.1.73 differs from your MySQL server version 5.6.35. This may cause unpredictable behavior. -------------------------------
Whiskey Tango Foxtrot, over!

Comments

11 comments

Date Votes
  • PCZero
    I opened a ticket about this several hours ago and it still has not been picked up. Can I get an ETA on when someone will actually start ion this please?
    0
  • Infopro
    Could you post the ticket ID here please?
    0
  • PCZero
    8385651
    0
  • Infopro
    This post sounds related to your issue: Phpmyadmin - PHP MySQL library version
    0
  • PCZero
    A bog thank you to all involved especially Aaron Horsley who fixed the glitch very rapidly once the ticket was assigned to him. A numebr of my clients have database dependent sites (bands with tour schedules, etc) so it was important that this got resolved. Thanks Aaron!
    0
  • PCZero
    Not sure what happened but this issue came back today and is still present. I am going to try to run the commands that Aaron outlined to see if this rectifies things or not. I will follow up. You guys a cPanel might want to be aware of whatever is causing this!
    0
  • PCZero
    It appears that something is going on that causes the cpanel-phpmyadmin rpm to get nuked. I have updates set to automatic and I am thinking that something in the nightly updates is causing the issue. It is (temporarily) resolved by these commands as root. rpm -e --justdb --nodeps cpanel-phpmyadmin-4.6.6-1.cp1164.noarch /scripts/check_cpanel_rpms A permanent resolution is still required!
    ======================================================= root@xxxxx [~]# rpm -e --justdb --nodeps cpanel-phpmyadmin-4.6.6-1.cp1164.noarch root@xxxxx [~]# /scripts/check_cpanel_rpms [2017-04-18 18:45:44 -0400] [2017-04-18 18:45:44 -0400] Problems were detected with cPanel-provided files which are RPM controlled. [2017-04-18 18:45:44 -0400] If you did not make these changes intentionally, you can correct them by running: [2017-04-18 18:45:44 -0400] [2017-04-18 18:45:44 -0400] > /usr/local/cpanel/scripts/check_cpanel_rpms --fix [2017-04-18 18:45:44 -0400] The following RPMs are missing from your system: [2017-04-18 18:45:44 -0400] cpanel-phpmyadmin-4.6.6-1.cp1164 Do you want to repair these RPMs?(y/n): y [2017-04-18 18:45:57 -0400] Removing 0 broken rpms: [2017-04-18 18:45:57 -0400] rpm: no packages given for erase [2017-04-18 18:45:58 -0400] Downloading http://httpupdate.cpanel.net/RPM/11.64/centos/6/x86_64/rpm.sha512 [2017-04-18 18:45:58 -0400] Successfully verified signature for cpanel (key types: release). [2017-04-18 18:45:58 -0400] Downloading http://httpupdate.cpanel.net/RPM/11.64/centos/6/x86_64/cpanel-phpmyadmin-4.6.6-1.cp1164.noarch.rpm [2017-04-18 18:45:59 -0400] Disabling service monitoring. [2017-04-18 18:46:01 -0400] Hooks system enabled. [2017-04-18 18:46:01 -0400] Checking for and running RPM::Versions 'pre' hooks for any RPMs about to be installed [2017-04-18 18:46:01 -0400] All required 'pre' hooks have been run [2017-04-18 18:46:01 -0400] No RPMS need to be uninstalled [2017-04-18 18:46:01 -0400] Installing new rpms: cpanel-phpmyadmin-4.6.6-1.cp1164.noarch.rpm [2017-04-18 18:46:01 -0400] Preparing packages for installation... [2017-04-18 18:46:01 -0400] cleaning up old phpmyadmin before installing new one. [2017-04-18 18:46:01 -0400] We only do this the first time we install the cpanel-phpmyadmin RPM [2017-04-18 18:46:01 -0400] cpanel-phpmyadmin-4.6.6-1.cp1164 [2017-04-18 18:46:02 -0400] Hooks system enabled. [2017-04-18 18:46:02 -0400] Checking for and running RPM::Versions 'post' hooks for any RPMs about to be installed [2017-04-18 18:46:02 -0400] All required 'post' hooks have been run [2017-04-18 18:46:02 -0400] Restoring service monitoring. root@xxxxx [~]# =======================================================
    0
  • Infopro
    Feel free to reopen your ticket or create a new one about this.
    0
  • PCZero
    Thanks Info... I have updated the ticket with Aaron and awaiting further feedback form him. Just wanted to provide everyone insight here so that if they have the issue they can resolve it as well.
    0
  • PCZero
    After tonight's update to 64.0.13 the eror came back even worse.
    ==================================================== phpMyAdmin - Error You should upgrade to MySQL 5.5.0 or later. Warning in ./libraries/plugins/auth/AuthenticationCpanel.php#627 mysqli_connect() expects parameter 5 to be long, string given Backtrace ./libraries/plugins/auth/AuthenticationCpanel.php#627: mysqli_connect( string ********, string ********, string ********, string ********, string ********, ) ./libraries/plugins/auth/AuthenticationCpanel.php#387: PMA\libraries\plugins\auth\AuthenticationCpanel::cp_mysql_auth_check( string 'xxxxx', string 'xxxxx', ) ./libraries/common.inc.php#752: PMA\libraries\plugins\auth\AuthenticationCpanel->authCheck() ./index.php#13: require_once(./libraries/common.inc.php) mysqli_real_connect(): (28000/1045): Access denied for user 'root'@'localhost' (using password: NO) mysqli_real_connect(): (28000/1045): Access denied for user 'root'@'localhost' (using password: NO) Notice in ./libraries/common.inc.php#916 Use of undefined constant PMA_MYSQL_INT_VERSION - assumed 'PMA_MYSQL_INT_VERSION' Backtrace ./index.php#13: require_once(./libraries/common.inc.php) Notice in ./libraries/DatabaseInterface.php#2192 Undefined offset: 1 Backtrace ./libraries/Menu.php#504: PMA\libraries\DatabaseInterface->isUserType(string 'grant') ./libraries/Menu.php#106: PMA\libraries\Menu->_getServerTabs() ./libraries/Menu.php#71: PMA\libraries\Menu->_getMenu() ./libraries/Header.php#444: PMA\libraries\Menu->getDisplay() ./libraries/Response.php#266: PMA\libraries\Header->getDisplay() ./libraries/Response.php#279: PMA\libraries\Response->_getDisplay() ./libraries/Response.php#443: PMA\libraries\Response->_htmlResponse() PMA\libraries\Response::response() Notice in ./libraries/DatabaseInterface.php#2187 Undefined offset: 1 Backtrace ./libraries/Menu.php#505: PMA\libraries\DatabaseInterface->isUserType(string 'create') ./libraries/Menu.php#106: PMA\libraries\Menu->_getServerTabs() ./libraries/Menu.php#71: PMA\libraries\Menu->_getMenu() ./libraries/Header.php#444: PMA\libraries\Menu->getDisplay() ./libraries/Response.php#266: PMA\libraries\Header->getDisplay() ./libraries/Response.php#279: PMA\libraries\Response->_getDisplay() ./libraries/Response.php#443: PMA\libraries\Response->_htmlResponse() PMA\libraries\Response::response() ====================================================
    This is entirely unacceptable. Ticket updated.
    0
  • cPanelMichael
    Hello, Internal case CPANEL-9751 is open to address an issue where version 5.1 of the MySQL client library results in a warning message upon accessing phpMyAdmin in cPanel 64. You can subscribe to the following thread to see when a resolution is published: Phpmyadmin - PHP MySQL library version Thank you. Update: cPanel 64 is now EOL, and thus no further updates to it are planned. The referenced case is fixed as of cPanel 66.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post