[MXS-26] bugzillaId-735:Socket connection fails to unknown error ERROR 1045 (28000): Access denied for user 'testuser'@'localhost_from_socket' (using password: YES) Created: 2015-01-19  Updated: 2019-12-19

Status: Closed
Project: MariaDB MaxScale
Component/s: Core
Affects Version/s: 1.0.5
Fix Version/s: 1.1.1

Type: Bug Priority: Minor
Reporter: Timofey Turenko Assignee: Massimiliano Pinto (Inactive)
Resolution: Unresolved Votes: 0
Labels: None
Environment:

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.

 Comments   
Comment by Dipti Joshi (Inactive) [ 2015-03-10 ]

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

Comment by markus makela [ 2015-04-28 ]

Is this still reproducible?

Comment by Timofey Turenko [ 2015-04-29 ]

not reproducible, I can connect using socket

Generated at Thu Feb 08 03:56:13 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.