Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Unresolved
-
1.0.5
-
None
-
Linux
Description
This is imported from bugzilla item: http://bugs.mariadb.com/show_bug.cgi?id=735
Description Vilho Raatikka 2015-02-19 08:46:18 UTC
[Read Connection Router]
|
type=service
|
router=readconnroute
|
servers=srv1
|
user=testuser
|
passwd=testpwd
|
router_options=master
|
|
|
|
|
[Read Connection Listener]
|
type=listener
|
service=Read Connection Router
|
protocol=MySQLClient
|
port=3456
|
socket=/tmp/readconn.sock
|
|
|
|
|
[srv1]
|
type=server
|
address=<ip addr>
|
port=<port#>
|
protocol=MySQLBackend
|
|
|
/skysql/maxscale/bin$ mysql --socket=/tmp/readconn.sock -u testuser -ptestpwd
ERROR 1045 (28000): Access denied for user 'testuser'@'localhost_from_socket' (using password: YES)
Error log includes this kind of entries:
2015-02-19 09:39:38 Error : user testuser@localhost_from_socket not found, try set 'localhost_match_wildcard_host=1' in service definition of the configuration file.
2015-02-19 09:39:38 Error : user testuser@localhost_from_socket not found, try set 'localhost_match_wildcard_host=1' in service definition of the configuration file.
This is comment history imported from buzilla
Comment 1 Vilho Raatikka 2015-02-19 08:47:10 UTC
localhost_from_socket is not MySQL but something else which my application doesn't understand and which I was not able to find from documentation.
Comment 2 Massimiliano 2015-02-19 09:00:36 UTC
The user that wants to connect with socket must have localhost host access.
In your example testuser should even fail when specifying 127.0.0.1
mysql -h 127.0.0.1 -P$port -ustestuser
The solution is to add testuser@locsalhost