Opened 2 years ago
Last modified 2 years ago
#65764 assigned defect
mariadb 10.7.5, 10.8.4, and 10.10.x will not connect to remote databases
| Reported by: | 1rocketdude | Owned by: | michaelld (Michael Dickens) |
|---|---|---|---|
| Priority: | Normal | Milestone: | |
| Component: | ports | Version: | 2.7.2 |
| Keywords: | mariadb | Cc: | |
| Port: | mariadb-10.7, mariadb-10.8, mariadb-10.10 |
Description
after upgrading from 10.7.4 to 10.7.5 via upgrade, I could no longer connect to remote mysql/mariadb databases with the mysql executable. The specific error was benign:
ERROR 2002 (HY000): Can't connect to server on 'x.x.x.x' (60)
Connecting to localhost databases (via socket) was still functional. Many remote databases rejected connection requests as above.
I tried 10.8.4 and 10.10.1 versions of mariadb (mysql executable), with the same failed result.
I reinstalled 10.7.4 from the macports history, and remote connections were successful again.
All versions of mariadb 10.x running on a Ubuntu machine also successfully connected.
current hardware/OS: Macbook pro12.1, big-sur OS 11.6.8, xcode command line tools 13.2
Change History (4)
comment:1 Changed 2 years ago by 1rocketdude
comment:2 Changed 2 years ago by jmroot (Joshua Root)
| Owner: | set to michaelld |
|---|---|
| Status: | new → assigned |
comment:3 Changed 2 years ago by mascguy (Christopher Nielsen)
| Priority: | High → Normal |
|---|
comment:4 Changed 2 years ago by dylantack (Dylan Tack)
There's more info about a fix here: https://mariadb.com/kb/en/mariadb-connector-c-332-on-macos-doesnt-connect-to-remote-mariadb-sever/
confirmed that 10.8.3 version of mariadb/mysql successfully makes remote connections. 10.8.4 does not. There seems to be a common change that was made to all the 10.x databases in mid-June 2022.