Skip to main content

User Level phpmyadmin not loading

whipworks
Hello Lauren, Just wondering if you've encountered any issues about phpmyadmin not loading properly? We tried accessing it through CPanel on an Admin level. But User level (customers) can't seem to access it properly. It just hangs on "loading". This is different from the original post, but since it's still a php issue, I thought it might be a good idea to ask. Thank you :)

Comments

17 comments

Date Votes
  • cPanelLauren
    Hello, @whipworks The only instance in which I've seen this behavior is when the passwords aren't synced. Is there ever an error or does it just continuously spin?
    0
  • whipworks
    Hello, @whipworks The only instance in which I've seen this behavior is when the passwords aren't synced. Is there ever an error or does it just continuously spin?

    Hi Lauren, Thanks for the quick reply. Password is fine. We know this for a fact because what the user does is access the CPanel and go to phpmyadmin. User gets to the menu table and when you try to do something on it, like expand the options on the left side panel or even on any option on the top (Database, SQL, Status, Epoxt, etc.) it starts loading and hangs on loading.
    0
  • cPanelLauren
    Hi @whipworks The issue with passwords is they can access their cPanel but it's not synced with MySQL but that typically gives an actual error output to the phpmyadmin UI. Can you confirm whether or not you're running PHP-FPM for cPanel Daemons? You can find this at WHM>>Service Configuration>>Service Manager and if it is running whether or not disabling it has any effect on the behavior you're seeing within phpmyadmin? Thanks!
    0
  • whipworks
    Hi Lauren, I'll be giving you the details once this issue with our license renewal gets resolved. We got the license renewed 2-3 days ago, but it seems to have not been activated properly. Can you point out the right department to contact in terms of this issue please? Thanks :)
    0
  • cPanelLauren
    Hi @whipworks That would need to go through customer service you can email them at cs@cpanel.net
    0
  • whipworks
    Hi Lauren, Resolved that licensing issue. I've checked and PHP-FPM is not enabled. Do I turn it on and try?
    0
  • cPanelLauren
    Hi @whipworks To confirm you're looking at php-fpm for cPanel daemons right? If that's not enabled there's no need to enable it now. Do you see anything in /usr/local/cpanel/logs/error_log when attempting to access phpmyadmin as the user?
    0
  • whipworks
    Hi Lauren, This is the error that we get even after changing the password to access phpmyadmin via customers account [2018-05-17 11:48:34 -0400] warn [cpmysql] Error from MySQL query: (XID rdqseg) DBD::mysql::db do failed: The password hash doesn't have the expected format. Check if the correct password algorithm is being used with the PASSWORD() function. at /usr/local/cpanel/Cpanel/Mysql.pm line 1533. Cpanel::Mysql::_has_error_handler(Cpanel::Mysql=HASH(0x2504158), Cpanel::Exception::Database::Error=HASH(0x253f780)) called at /usr/local/cpanel/Cpanel/Mysql.pm line 650 Cpanel::Mysql::_dbowner_to_all_without_ownership_checks(Cpanel::Mysql=HASH(0x2504158), "method", "GRANT", "users", HASH(0xe4ac68), "database", undef) called at /usr/local/cpanel/Cpanel/Mysql.pm line 598 Cpanel::Mysql::_dbowner_to_all_with_ownership_checks(Cpanel::Mysql=HASH(0x2504158), "method", "GRANT", "users", HASH(0xe4ac68)) called at /usr/local/cpanel/Cpanel/Mysql.pm line 762 Cpanel::Mysql::updateprivs(Cpanel::Mysql=HASH(0x2504158)) called at bin/admin/Cpanel/cpmysql.pl line 181 set password for 'user_user'@'localhost' = password('password'); Hope this is helpful
    0
  • cPanelLauren
    Hi @whipworks Can you run the following for me and let me know what the output is? It sounds like the account may be using Old style MySQL passwords: mysql -e "SHOW VARIABLES LIKE 'mysql_old_password';"
    or alternatively: mysql -e "use mysql; select * from user;" | grep $username | grep old
    Thanks!
    0
  • mathx
    Im the tech working on this: SHOW VARIABLES LIKE 'mysql_old_password'; Empty set (0.00 sec)
    localhost user 23c2b0e968652116 N N N N N N N N N N N N N N N N N N N N N N N N N N N N N 0 0 0 0 mysql_old_password NULL N company.net user 23c2b0e968652116 N N N N N N N N N N N N N N N N N N N N N N N N N N N N N 0 0 0 0 mysql_old_password NULL N 10.5.6.7 user 23c2b0e968652116 N N N N N N N N N N N N N N N N N N N N N N N N N N N N N 0 0 0 0 mysql_old_password NULL N
    0
  • cPanelLauren
    Hi @mathx That last one shows the user is using Old style MySQL passwords in order to resolve this you're going to need to update them to use the newer password has MySQL uses. Something like the following might work: UPDATE mysql.user SET plugin = 'mysql_native_password', Password = PASSWORD('XXXXXXX') WHERE (User, Host) = ('$username', 'localhost'); UPDATE mysql.user SET plugin = 'mysql_native_password', Password = PASSWORD('XXXXXXX') WHERE (User, Host) = ('$username', 'IPAddresshere'); UPDATE mysql.user SET plugin = 'mysql_native_password', Password = PASSWORD('XXXXXXX') WHERE (User, Host) = ('$username', 'host.tld');
    0
  • mathx
    Got this: [2018-05-18 11:04:34 -0400] warn [cpmysql] Error from MySQL query: (XID dh7xp8) DBD::mysql::db do failed: The password hash doesn't have the expected format. Check if the correct password algorithm is being used with the PASSWORD() function. at /usr/local/cpanel/Cpanel/Mysql.pm line 1533. Cpanel::Mysql::_has_error_handler(Cpanel::Mysql=HASH(0x26871a8), Cpanel::Exception::Database::Error=HASH(0x26c5078)) called at /usr/local/cpanel/Cpanel/Mysql.pm line 650 Cpanel::Mysql::_dbowner_to_all_without_ownership_checks(Cpanel::Mysql=HASH(0x26871a8), "method", "GRANT", "users", HASH(0xe4ac68), "database", undef) called at /usr/local/cpanel/Cpanel/Mysql.pm line 598 Cpanel::Mysql::_dbowner_to_all_with_ownership_checks(Cpanel::Mysql=HASH(0x26871a8), "method", "GRANT", "users", HASH(0xe4ac68)) called at /usr/local/cpanel/Cpanel/Mysql.pm line 762 Cpanel::Mysql::updateprivs(Cpanel::Mysql=HASH(0x26871a8)) called at bin/admin/Cpanel/cpmysql.pl line 181 [2018-05-18 11:04:34 -0400] warn [cpmysql] The system could not perform "GRANT" statements for the user "username" due to errors: (XID wrtf2u) DBD::mysql::db do failed: The password hash doesn't have the expected format. Check if the correct password algorithm is being used with the PASSWORD() function.
    0
  • cPanelLauren
    Hello @mathx Where are you running that? Can you be sure to run it through the MySQL CLI? Thanks!
    0
  • mathx
    That's in the error log after trying to login to phpmyadmin as the user again after resetting their password per your instructions. It just spins on the web interface when any of the databases in the dropdown in phpmyadmin are clicked and that error is added to the logfile. Logging into mysql from the cli manually as the user with their password works just fine. Just phpmyadmin doenst work.
    0
  • cPanelLauren
    Hi @mathx Can you please open a ticket using the link in my signature? Once open please reply with the Ticket ID here so that we can update this thread with the resolution once the ticket is resolved. Thanks!
    0
  • whipworks
    Hi Lauren, Ticket has been created. Please keep us posted. Thank you!
    0
  • cPanelLauren
    Hi @whipworks Can you confirm this is the correct ticket ID? 9629237 If so I will definitely update you as to the status of this as soon as I have more information
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post