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!

SOLVED phpMyAdmin AuthenticationCpanel.php Error

Discussion in 'Database Discussion' started by psytanium, Jan 17, 2018.

Tags:
Page 1 of 2
  1. psytanium

    psytanium Well-Known Member

    Joined:
    Jun 6, 2014
    Messages:
    158
    Likes Received:
    6
    Trophy Points:
    18
    Location:
    Lebanon
    cPanel Access Level:
    Root Administrator
    Hello,

    This error appear on every mouse click I do:

    Some errors have been detected on the server!
    Please look at the bottom of this window.

    and a lonf error message appear at the bottom of the page:

    Code:
    Warning in ./libraries/plugins/auth/AuthenticationCpanel.php#629
mysqli_connect(): (28000/1045): Access denied for user 'dynoatm'@'localhost' (using password: YES)

Backtrace

./libraries/plugins/auth/AuthenticationCpanel.php#629: mysqli_connect(
string ********,
string ********,
string ********,
string ********,
string ********,
)
./libraries/plugins/auth/AuthenticationCpanel.php#389: PMA\libraries\plugins\auth\AuthenticationCpanel::cp_mysql_auth_check(
string 'dynoatm',
string 'Arcache10-10-10',
)
./libraries/common.inc.php#667: PMA\libraries\plugins\auth\AuthenticationCpanel->authCheck()
./sql.php#18: require_once(./libraries/common.inc.php)
    Thanks for your support
     
    #1 psytanium, Jan 17, 2018
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,305
    Likes Received:
    2,155
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    It's possible the cPanel and MySQL password for that account is out of sync. You can try resetting the cPanel password to see if that solves the issue:

    "WHM >> Password Modification"

    Otherwise, check to see if a /home/$username/.my.cnf file exists under this account. If so, remove it, or update the password in this file to match the cPanel account password (or vice-versa).

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 cPanelMichael, Jan 18, 2018
    Metro2 likes this.
  3. DennisMidjord

    DennisMidjord Well-Known Member

    Joined:
    Sep 27, 2016
    Messages:
    210
    Likes Received:
    19
    Trophy Points:
    18
    Location:
    Denmark
    cPanel Access Level:
    Root Administrator
    We had that exact error yesterday for just 1 account. Changing the password like @cPanelMichael suggests fixed the issue straight away.
     
    #3 DennisMidjord, Jan 18, 2018
    Metro2 likes this.
  4. psytanium

    psytanium Well-Known Member

    Joined:
    Jun 6, 2014
    Messages:
    158
    Likes Received:
    6
    Trophy Points:
    18
    Location:
    Lebanon
    cPanel Access Level:
    Root Administrator
    Thanks, solved :)
     
    #4 psytanium, Jan 19, 2018
  5. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,305
    Likes Received:
    2,155
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    I'm glad to see that helped. Thank you for sharing the outcome.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #5 cPanelMichael, Jan 19, 2018
  6. Yassine Bouzaka

    Yassine Bouzaka Registered

    Joined:
    Jan 19, 2018
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Morocco
    cPanel Access Level:
    Root Administrator
    Not working with me , i changed mysql password (WHM)

    HTML:
    Warning in ./libraries/plugins/auth/AuthenticationCpanel.php#629
 mysqli_connect(): (28000/1045): Access denied for user 'cpses_'@'localhost' (using password: YES)

Backtrace

./libraries/plugins/auth/AuthenticationCpanel.php#629: mysqli_connect(
string ********,
string ********,
string ********,
string ********,
string ********,
)
./libraries/plugins/auth/AuthenticationCpanel.php#389: PMA\libraries\plugins\auth\AuthenticationCpanel::cp_mysql_auth_check(
string 'cpses_tn8uz7uz1g',
string 'L2zxcxBPDoBNSQof2DHe3kcPdBF7yH47',
)
./libraries/common.inc.php#667: PMA\libraries\plugins\auth\AuthenticationCpanel->authCheck()
./index.php#20: require_once(./libraries/common.inc.php)
Notice in ./libraries/plugins/auth/AuthenticationCpanel.php#81
 Undefined index: auth_type

Backtrace

./libraries/common.inc.php#670: PMA\libraries\plugins\auth\AuthenticationCpanel->auth()
./index.php#20: require_once(./libraries/common.inc.php)
Notice in ./libraries/plugins/auth/AuthenticationCpanel.php#99
 Undefined index: charset

Backtrace

./libraries/common.inc.php#670: PMA\libraries\plugins\auth\AuthenticationCpanel->auth()
./index.php#20: require_once(./libraries/common.inc.php)
 Cookies required
     
    #6 Yassine Bouzaka, Jan 19, 2018
  7. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,305
    Likes Received:
    2,155
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Are you accessing phpMyAdmin through Web Host Mnaager, or through cPanel? If it's through cPanel, the password to change is the account password via "WHM >> Password Modification".

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #7 cPanelMichael, Jan 19, 2018
  8. Metro2

    Metro2 Well-Known Member

    Joined:
    May 24, 2006
    Messages:
    444
    Likes Received:
    38
    Trophy Points:
    178
    Location:
    USA
    cPanel Access Level:
    Root Administrator
    This works like a charm for me. Had a couple user accounts with the same issue in the OP, and simply doing WHM > Password Modification without even giving them a different cPanel password works. Just did one a few minutes ago, same password the user had before, and it immediately fixed the phpMyAdmin display for them.

    As far as why this happens (and only rarely and only with one or two accounts) - my guess is it's possibly due to so many server migrations (in my case) where the client has been with me to 12 years and during that time we've phased out old servers / migrated to new ones at least 6 times. I'm guessing that occasionally during the Transfer Account process after so many times something is bound to go out of sync, but that's just my speculation.

    Thank you @cPanelMichael!
     
    #8 Metro2, Feb 3, 2018
  9. Aeon_Sydney

    Aeon_Sydney Registered

    Joined:
    Feb 11, 2018
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    NYC Area
    cPanel Access Level:
    Root Administrator
    I have the same problem and it works for a little bit. However the next day it is broken again until I reset the root MySQL password again and it will work again until the next day.
     
    #9 Aeon_Sydney, Feb 11, 2018
  10. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,305
    Likes Received:
    2,155
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Does a /home/$username/.my.cnf file exist for the affected account?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #10 cPanelMichael, Feb 12, 2018
  11. Aeon_Sydney

    Aeon_Sydney Registered

    Joined:
    Feb 11, 2018
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    NYC Area
    cPanel Access Level:
    Root Administrator
    Yes, the file exists and is correct. I have to keep resetting the root MySQL password every day otherwise when accessing phpMyAdmin from WHM I get prompted for the username and password and below it says:

    mysqli_connect() expects parameter 5 to be long, string given
    Undefined index: auth_type    ​
     
    #11 Aeon_Sydney, Apr 24, 2018
  12. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,305
    Likes Received:
    2,155
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    Can you open a support ticket so we can take a closer look? Feel free to post the ticket number here once it's opened and we will update this thread with the outcome:

    How to Open a Technical Support Ticket - cPanel Knowledge Base - cPanel Documentation

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #12 cPanelMichael, Apr 24, 2018
  13. kalexan

    kalexan Member PartnerNOC

    Joined:
    Jul 28, 2005
    Messages:
    9
    Likes Received:
    1
    Trophy Points:
    153
    Hello
    At a CENTOS 6.10 standard server with cPanel v 74.0.6, I tried to use PhpMyAdmin at one of my accounts through cpanel, however phpmyadmin refuses with errors:

    mysqli_connect(): (28000/1045): Access denied for user 'accountusername'@'localhost' (using password: YES)
    Undefined index: auth_type
    Undefined index: charset

    I changed the account 's password from WHM, I got the result message that MySQL password was updated, however, I still cannot log in using cpanel (still the same error appears). I do not have specific .my.cnf at that account. I have no problem logging in to phpMyAdmin from WHM (root user), however I thing that PhpMyAdmin and cPanel/WHM are somewhat "out of sync", so if I will change root password, I will not be able to login at any database using PhpMyAdmin.

    Any thoughts?
     
    #13 kalexan, Sep 3, 2018
  14. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,305
    Likes Received:
    2,155
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @kalexan,

    I've seen this happen on systems where the MySQL version was manually downgraded using an unsupported method. Can you check and see if that's the case on the affected server? Here's a command you can use to check this:

    Code:
    egrep -B1 '^Version' /var/lib/mysql/`hostname`.err
    Does the output show a version downgrade at any point in time?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #14 cPanelMichael, Sep 3, 2018
  15. kalexan

    kalexan Member PartnerNOC

    Joined:
    Jul 28, 2005
    Messages:
    9
    Likes Received:
    1
    Trophy Points:
    153
    Hi @cPanelMichael

    No, all versions are in ascending order:
    Line 1: Version: '5.1.73-cll
    Line 5: Version: '5.1.73-cll
    Line 8: Version: '5.1.73-cll
    Line 11: Version: '5.1.73-cll
    Line 14: Version: '5.1.73-cll
    Line 17: Version: '5.1.73-cll
    Line 20: Version: '5.5.42-cll
    Line 23: Version: '5.5.42-cll
    Line 26: Version: '5.5.42-cll
    Line 29: Version: '5.5.42-cll
    Line 32: Version: '5.5.42-cll
    Line 35: Version: '5.5.42-cll
    Line 38: Version: '5.5.42-cll
    Line 41: Version: '5.5.45-cll
    Line 44: Version: '5.5.45-cll
    Line 47: Version: '5.5.46-cll
    Line 50: Version: '5.5.46-cll
    Line 53: Version: '5.5.47-cll
    Line 56: Version: '5.5.47-cll
    Line 59: Version: '5.5.48-cll
    Line 62: Version: '5.5.48-cll
    Line 65: Version: '5.5.49-cll
    Line 68: Version: '5.5.49-cll
    Line 71: Version: '5.5.50-cll
    Line 74: Version: '5.5.50-cll
    Line 77: Version: '5.5.50-cll
    Line 80: Version: '5.5.50-cll
    Line 83: Version: '5.5.50-cll
    Line 86: Version: '5.5.52-cll
    Line 89: Version: '5.5.52-cll
    Line 92: Version: '5.5.52-cll
    Line 95: Version: '5.5.52-cll
    Line 98: Version: '5.5.54-cll
    Line 101: Version: '5.5.54-cll
    Line 104: Version: '5.5.54-cll
    Line 107: Version: '5.5.54-cll
    Line 110: Version: '5.5.55-cll
    Line 113: Version: '5.5.55-cll
    Line 116: Version: '5.5.57-cll
    Line 119: Version: '5.5.57-cll
    Line 122: Version: '5.5.57-cll
    Line 125: Version: '5.5.58-cll
    Line 128: Version: '5.5.58-cll
    Line 131: Version: '5.5.58-cll
    Line 134: Version: '5.5.58-cll
    Line 137: Version: '5.5.58-cll
    Line 140: Version: '5.5.58-cll
    Line 143: Version: '5.5.59-cll
    Line 146: Version: '5.5.59-cll
    Line 149: Version: '5.5.59-cll
    Line 152: Version: '5.5.59-cll
    Line 155: Version: '5.5.59-cll
    Line 158: Version: '5.5.59-cll
    Line 161: Version: '5.5.60-cll
    Line 164: Version: '5.5.60-cll
    Line 167: Version: '5.5.60-cll​
     
    #15 kalexan, Sep 4, 2018
  16. kalexan

    kalexan Member PartnerNOC

    Joined:
    Jul 28, 2005
    Messages:
    9
    Likes Received:
    1
    Trophy Points:
    153
    Just an update: I changed the account password from an other account at the same server, and I did not have problem logging in through cPanel and then PhpMyAdmin
     
    #16 kalexan, Sep 4, 2018
  17. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,305
    Likes Received:
    2,155
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @kalexan,

    Can you confirm that allowed phpMyAdmin to be accessed on the original account affected by the issue? If not, can you let us know of any specific output in /usr/local/cpanel/logs/error_log or /var/lib/mysql/$hostname.err when the access attempt fails?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #17 cPanelMichael, Sep 4, 2018
  18. kalexan

    kalexan Member PartnerNOC

    Joined:
    Jul 28, 2005
    Messages:
    9
    Likes Received:
    1
    Trophy Points:
    153
    Sorry I was not clear enough: I changed the account password FOR an other account at the same server, and I did not have any problems logging in through cPanel and then PhpMyAdmin for this account. The original account that had the problem is still affected

    I checked
    /usr/local/cpanel/logs/error_log
    and
    /var/lib/mysql/$hostname.err
    for entries around the time of login, nothing was logged :(
     
    #18 kalexan, Sep 4, 2018
  19. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,305
    Likes Received:
    2,155
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hi @kalexan,

    Can you open a support ticket so we can take a closer look at the affected system to see what's happening? You can post the ticket number here and I'll link this thread to the ticket.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #19 cPanelMichael, Sep 4, 2018
  20. kalexan

    kalexan Member PartnerNOC

    Joined:
    Jul 28, 2005
    Messages:
    9
    Likes Received:
    1
    Trophy Points:
    153
    Ticket created:# 10239551

    Btw, pretty awesome support workflow!
     
    #20 kalexan, Sep 4, 2018
    cPanelMichael likes this.
(You must log in or sign up to post here.)
Page 1 of 2
Loading...
Similar Threads - phpMyAdmin AuthenticationCpanel Error
  1. tomdchi

    PHPMyAdmin 500 Error

    tomdchi, Jun 15, 2019 at 9:30 PM, in forum: Database Discussion
    Replies:
    1
    Views:
    101
    cPanelLauren
    Jun 18, 2019 at 4:09 PM
  2. ca2236

    PHPMyadmin upload Limit

    ca2236, Jun 11, 2019, in forum: General Discussion
    Replies:
    2
    Views:
    173
    ca2236
    Jun 11, 2019
  3. morrow95

    Pending Publication [CPANEL-25776] phpMyAdmin login issue since WHM 80 update

    morrow95, Jun 4, 2019, in forum: Database Discussion
    Replies:
    8
    Views:
    271
    morrow95
    Jun 8, 2019
  4. asdcxz@1239

    SOLVED phpMyAdmin redirect loop

    asdcxz@1239, May 17, 2019, in forum: Database Discussion
    Replies:
    2
    Views:
    239
    asdcxz@1239
    May 18, 2019
  5. cPanelResources

    Tutorial How to increase the maximum upload limit in PHPMyAdmin

    cPanelResources, May 7, 2019, in forum: Database Discussion
    Replies:
    0
    Views:
    260
    cPanelResources
    May 7, 2019

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.
    Accept Learn More...
    Dismiss Notice