mariadb - MariaDB Maxscale 抛出访问被拒绝，尽管用户 ID/密码是正确的

Question

数据库版本：10.2.14 Maxscale 版本：2.4.6

• 应用程序正在使用 jdbc 驱动程序连接到数据库
• userid1 & userid2 被允许从任何地方连接，即

• 如果我们直接从应用程序服务器连接到数据库，我们不会收到任何问题，并且连接建立成功，但是当我们通过 maxscale 连接到数据库时，我们会收到间歇性拒绝访问错误

  注意：用户名和密码是相同的，从第一天起就永远不会改变

情景的

userid1 : Connect to database via Maxscale with ID/Password throws Access Denied Error intermittently, sometimes connects successfully
Userid1 : Connect to database directly from application, works fine no issues
userid2 : Connect to database via Maxscale with ID/Password throws Access Denied Error intermittently, sometimes connects successfully
Userid2 : Connect to database directly from application, works fine no issues

Earlier Maxscale Version was 2.2.19 and we never faced issues.
From both (application & Maxscale) logs we can see only ACCESS DENIED errors for those id's.
What am unable to understand is 
1) Userid and Password never changed, so why we are receiving ACCESS DENIED when using Maxscale that too intermittently and no issue if we connect directly database.
2) IF Userid/Password passes wrongly then it should be always access denied, but in this case it's intermittently

标签： mariadbmaxscale

Answer 1

在 MariaDB Jira 中，类似的行为被报告为MXS-2891 。我建议在那个 Jira 问题上报告这些问题。