Since Aegir default db server name localhost doesn't allow SSH tunneling for remote SQL access, it could be useful to maintain mirror GRANT also for 127.0.0.1, required by SSH tunneling. A patch for review attached.

CommentFileSizeAuthor
0001-Manage-extra-db-GRANT-for-127.0.0.1-to-allow-SSH-tun.patch2.25 KBmemtkmcc

Comments

memtkmcc created an issue. See original summary.

helmo’s picture

helmo commented

Does this relate to #2762479: Use ssh tunnel to connect remote MySQL server ?

Added to https://github.com/aegir-project/provision/pull/6 to help test .. (PS: Travis is not fully functional yet.)

memtkmcc’s picture

memtkmcc commented

It is a different issue (I think), but possibly related. The fix we have added is to allow remote access from typical desktop software, where "localhost" will always force it to attempt local connection and never the expected SSH tunnel. It just expects to be able to use 127.0.0.1 to make the tunnel work. It could help with server-to-server tunneling, too, perhaps.

  • helmo committed d2bcbcc on 7.x-3.x authored by memtkmcc 
    Issue #2798121 by memtkmcc: Manage extra db GRANT for 127.0.0.1 to allow...
helmo’s picture

helmo commented
Status: Needs review » Fixed

merged

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.