Found invalid password for user

ougogo

• January 02, 2014 19:25

Hi all ! That's a part of my MySQL error log : 140103 1:58:34 [Warning] Found invalid password for user: 'user1_TMW@server.hostname'; Ignoring user 140103 1:58:34 [Warning] Found invalid password for user: 'user1_nodead@server.IP'; Ignoring user 140103 1:58:34 [Warning] Found invalid password for user: 'user1_nodead@localhost'; Ignoring user 140103 1:58:34 [Warning] Found invalid password for user: 'user2_tmw@localhost'; Ignoring user
That's increase CPU usage, sometimes up to 100% ! This involves only two user. But what I do not understand is that the accounts of the two users are suspended! How can I solve this ? Best regards, Hugo

• 

  cPanelMichael

  • January 03, 2014 13:41

  That warning message is normal if an account is suspended. It's by design that MySQL authentication fails for suspended accounts. Could you post the details regarding the CPU usage? Thank you.

  0
• 

  ougogo

  • January 03, 2014 13:57

  Hummm, how can I find it ? In fact, I saw the CPU usage increase due to this command line: [QUOTE]/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/hostname.err --open-files-limit=50000 --pid-file=/var/lib/mysql/hostname.pid
  I then look at the file in question, and that is where I saw the errors. Once errors stop being written, CPU usage decreased. Best regards,

  0
• 

  cPanelMichael

  • January 03, 2014 14:32

  Could you elaborate on how much CPU is utilized? For instance, is it increasing your server load or slowing your server down? The following thread may be of use to you: Troubleshooting High Load On Linux Systems Thank you.

  0
• 

  ougogo

  • January 03, 2014 14:57

  Here you can see how much CPU is used when users try to connect : 00:00:02 runq-sz plist-sz ldavg-1 ldavg-5 ldavg-15 00:20:01 10 171 12.66 8.22 17.36 00:30:18 24 360 57.36 41.08 27.96 00:40:01 21 572 76.87 68.94 49.27 00:50:01 4 177 6.50 30.90 42.11 01:00:01 9 176 3.56 7.61 24.00 01:10:05 14 384 56.71 31.68 25.68 01:20:01 22 403 47.11 53.17 41.10
  Now CPU usage is correct because no error of connection. But the same process still holds the largest share of CPU. This varies from 10 to 40% : .vB I often have to restart Mysql to stop increasing the CPU. Best regards,

  0
• 

  cPanelMichael

  • January 03, 2014 15:04

  It seems to be more of an issue with your MySQL configuration. You may want to consider optimizing/tuning MySQL on your server. The following thread is helpful if you want to make a post in our "Optimization" forum: mysqlmymonlite.sh server stats gathering tool for cPanel Server Thank you.

  0
• 

  ougogo

  • January 03, 2014 15:57

  Thanks you ! I post here the result of scan. Could you move my post to "Optimization" Forum please ? [url=http://pastebin.com/SBPfx6BB]Result of mysqlmymonlite.sh Best regards,

  0

Please sign in to leave a comment.