Access denied for user 'leechprotect'@'localhost' (using password: YES)

SSy

• February 21, 2017 20:45

Hi there - how do I set the correct password for this service? Thanks.

• 

  Jcats

  • February 22, 2017 02:09

  Try this:
  # LEECHPASS=$(/usr/local/cpanel/bin/leechprotectpass) ; /usr/bin/mysql -e "grant all privileges on leechprotect.* to leechprotect@'localhost' identified by '$LEECHPASS';" ; mysql -u leechprotect -p"$LEECHPASS"
  You should end up with MySQL prompt:
  mysql>
  

  0
• 

  cPanelMichael

  • February 22, 2017 13:11

  Hello, Could you verify where you are receiving this error message? Also, what version of cPanel is installed on this system? In cPanel 62, we updated the leechprotect service to use SQLite. This change eliminates the need for a MySQL database and database user to run the leechprotect service. Thank you.

  0
• 

  hbouma

  • May 21, 2017 10:20

  Lol, just a heads up Michael. You guys are being pretty sloppy with your conversions from using MySQL to SQLite because you're still leaving the users in the MySQL database. It then becomes very confusing then when we're trying to upgrade MySQL on older systems and we're being told that the passwords for cphulkd roundcube leechprotect and eximstats are still using the old password format and need to be updated prior to upgrading. However, if roundcube, leechprotect, and eximstats are now no longer using MySQL, then why are those users still there? Had your conversion scripts properly cleaned up after itself, it wouldn't look like we needed to fix their passwords prior to upgrading the databases. That would also save us a lot of time and frustration because resetting all these passwords (especially for cphulk) isn't very well documented. Like I came here looking to reset the leechprotect password, only to realize nearly all of these weren't necessary anymore. Hal

  0

Please sign in to leave a comment.