MySQL Forums
Forum List  »  Router & Proxy

mysqlrouter connection error for 127.0.0.1
Posted by: Sam Tan
Date: October 12, 2021 09:13PM

Hi Experts,

Basic Info:
MySQL Router v2.1.4 on Linux (64-bit) (Commercial)
MySQL Ver 14.14 Distrib 5.7.20, for Linux (x86_64)

I am new to MySQL and MySQL Router,

Recently our MySQL Router is experiencing an unusual connection problem on our MySQL Router:

[root@pas202]#cat /var/log/mysqlrouter/mysqlrouter.log
2021-10-11 15:26:43 INFO [7f4c7bfa7700] [routing:prodCluster_default_rw] 29 connection errors for 127.0.0.1 (max 100)
2021-10-11 15:36:54 INFO [7f4c80fb1700] [routing:prodCluster_default_rw] 30 connection errors for 127.0.0.1 (max 100)
2021-10-12 10:09:48 INFO [7f4cd17fa700] [routing:prodCluster_default_rw] 31 connection errors for 127.0.0.1 (max 100)
2021-10-12 10:19:57 INFO [7f4c6d78a700] [routing:prodCluster_default_rw] 32 connection errors for 127.0.0.1 (max 100)
2021-10-12 10:29:33 INFO [7f4c72f95700] [routing:prodCluster_default_rw] 33 connection errors for 127.0.0.1 (max 100)
(timestamp above is UTC +8)


I understand that there is a connection error from localhost and I usually clear the error via mysqlrouter restart. But the question is the culprit that is attempting the connection. Upon checking from the MySQL Router logs and matching the timestamp it seems this is the culprit:

[root@pmse01]# cat /var/log/mysqld.log
2021-10-11T05:13:09.524728Z 15758097 [Note] Access denied for user 'ROUTER'@'pas202.presto.local' (using password: YES)
2021-10-11T05:23:45.483704Z 15759262 [Note] Access denied for user 'ROUTER'@'pas202.presto.local' (using password: YES)
2021-10-11T07:16:36.878786Z 15771528 [Note] Access denied for user 'ROUTER'@'pas202.presto.local' (using password: YES)
2021-10-11T07:26:41.565336Z 15772637 [Note] Access denied for user 'ROUTER'@'pas202.presto.local' (using password: YES)
2021-10-11T07:36:52.445713Z 15773751 [Note] Access denied for user 'ROUTER'@'pas202.presto.local' (using password: YES)
2021-10-12T02:09:46.579821Z 15894247 [Note] Access denied for user 'ROUTER'@'pas202.presto.local' (using password: YES)
2021-10-12T02:19:55.397823Z 15895335 [Note] Access denied for user 'ROUTER'@'pas202.presto.local' (using password: YES)
2021-10-12T02:29:31.611252Z 15896393 [Note] Access denied for user 'ROUTER'@'pas202.presto.local' (using password: YES)
(timestamp above is UTC)

I can confirm there is no user 'ROUTER' in the mysql.user.
The MySQL Router connecting to MySQL is using mysql_router9_kjc1lba6sqfb.

Has anyone encountered this phenomena before?

Regards,
Sam Tan

Options: ReplyQuote


Subject
Views
Written By
Posted
mysqlrouter connection error for 127.0.0.1
1004
October 12, 2021 09:13PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.