Announcement Announcement Module
Collapse
No announcement yet.
MySQL connection problems due to "Unauthenticated user" Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL connection problems due to "Unauthenticated user"

    Hi,

    We had been facing some issues with MySQL and we were getting the Mysql connection errors. When we run mysqladmin proc or when we review the MySQL Server process list a user marked with: unauthenticated user trying to connect.

    =====================
    +--------+----------------------+----------------------+-----------+----------------+------+------------+-----------+
    | Id | User | Host | db | Command | Time | State | Info |
    +--------+----------------------+----------------------+-----------+----------------+------+------------+------------+
    | 143766 | DELAYED | localhost | eximstats | Delayed insert | 343 | Waiting for INSERT | |
    | 143828 | unauthenticated user | X.X.X.X:1048 | | Connect | | login | |
    | 143829 | unauthenticated user | X.X.X.X:1246 | | Connect | | login | |
    | 143830 | unauthenticated user | X.X.X.X:4603 | | Connect | | login | |
    | 143831 | unauthenticated user | X.X.X.X.:1027 | | Connect | | login | |
    | 143832 | unauthenticated user | X.X.X.X:1391 | | Connect | | login | |
    | 143833 | unauthenticated user | X.X.X.X:3658 | | Connect | | login | |
    | 143834 | unauthenticated user | X.X.X.X:2395 | | Connect | | login | |
    | 143836 | unauthenticated user | X.X.X.X:3238 | | Connect | | login | |
    | 143837 | unauthenticated user | X.X.X.X:4760 | | Connect | | login | |
    | 143838 | unauthenticated user | X.X.X.X:3166 | | Connect | | login | |
    | 143841 | unauthenticated user | X.X.X.X:1829 | | Connect | | login | |
    | 143842 | unauthenticated user | X.X.X.X:37259 | | Connect | | login | |
    | 143843 | unauthenticated user | X.X.X.X:3599 | | Connect | | login | |
    | 143844 | unauthenticated user | X.X.X.X:4553 | | Connect | | login | |
    | 143845 | root | localhost | | Query | 0 | | show processlist |
    +--------+----------------------+----------------------+-----------+----------------+------+-----------+--------------+
    ======================

    This problem is caused by the first name server in /etc/resolv.conf being down, causing the DNS request to time-out. Hence, every connection to MySQL sits for a minute waiting for the timeout to occur. Within a few seconds, no client will be able to connect.

    You can add the line "--skip-name-resolve" to /etc/resolve.conf file and restart MySQL to resolve the issue. This prevents MySQL trying to resolve the host name for each thread, bypassing the name server problem.
Tag Cloud Tag Cloud Module
Collapse
Working...
X