Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
22.08.4
-
None
-
debian 11/docker
mariadb on windows
-
MXS-SPRINT-185
Description
I have two servers and one schemarouter service binded (+ listener and monitors).
If I try a connection with the user "web_xxxxx" to database "www.xxxx.com", the connection fails. The target server (I turned off the second as a test) is named "f01-r55". MaxScale reports:
.....
|
info : <f01-r55, www.xxxx.srl, workflows>
|
info : <f01-r55, www.xxxx.com, workflowtypes>
|
info : <f01-r55, information_schema, >
|
info : <f01-r55, www.xxxx.com, >
|
info : Updated shard map for user 'web_xxxxf01-r55'
|
info : Connecting to a non-existent database 'www.xxxx.com'
|
error : Routing the query failed. Session will be closed.
|
So it performs shard map, can see that the requested DB exists, then it reports that database does not exist and refuse the connection
The settings seems working well, but it cannot process the request. Any idea?
thanks