Hello.
mariadb 11.8.1
I want to use haproxy with check option.
Using in haproxy `option mysql-check` works but maridb logs:
[Warning] Aborted connection 24971 to db: 'unconnected' user:
'unauthenticated' host: '10.0.1.165' (This connection closed normally
without authentication)
This is confusing as I don't know that this is regular check from
haproxy, or someone tried to connect.
So I want to use in haproxy `option mysql-check user haproxy-check post-41`.
But this fails with error: [Warning] Access denied for user
'haproxy-check'@'10.0.1.164' (using password: NO)
and haproxy shows the mariadb server as DOWN.
Because in haproxy there is no way to specify a password for the user to
connect to the instance of mariadb, I tried to allow passwordless access
for the haproxy-check user from the specified network and minimum
grants. But this does not help to allow access without password. Tried
also to allow access for this user from any host and givin full access
and also authentication fails.
Is there an option in mariadb that does not allow paswordless
authentication?
_______________________________________________
discuss mailing list -- [email protected]
To unsubscribe send an email to [email protected]
