Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.0.9
-
None
-
Mac OS X Mavericks
Description
CONNECT table types that use PROXY do not work if the server is running with skip-networking or bind-address set to something other than the loopback interface.
With bind-address set (to something other than 127.0.0.1):
mysql 10.0.10-MariaDB (root) [test]> select * from fruit_pivot;
|
ERROR 1296 (HY000): Got error 174 '(2003) Can't connect to MySQL server on 'localhost' (61 "Connection refused")' from CONNECT
|
With skip-networking:
mysql 10.0.10-MariaDB (root) [test]> select * from fruit_pivot;
|
ERROR 1296 (HY000): Got error 174 '(2003) Can't connect to MySQL server on 'localhost' (49 "Can't assign requested address")' from CONNECT
|
It would be neat if the CONNECT engine tried by default to connect using the socket file. It would also be good if there was some way to specify an IP to use, I guess, in the case that the server is running with bind-address set.