When using proxy protocol, mysql needs to bind to an address instead of 0.0.0.0

Bug #1502408 reported by Frederic Descamps on 2015-10-03
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.1
Invalid
Undecided
Unassigned
5.5
Invalid
Undecided
Unassigned
5.6
New
Undecided
Unassigned
5.7
New
Undecided
Unassigned

Bug Description

When proxy_protocol_networks is set to something else than * (the proxy ip for example), you can't connect any more using the proxy, you need to bind_address= to the mysql server's ip in my.cnf

This is not documented and should be added

When we added debug output to analyse this case, we found that, without bind_address, proxy protocol networks still work, but in the IPv6 format: all incoming connections from IPv4 are processed in IPv6 form. Specifying bind_address usually has the effect of not listening on IPv6.

tags: added: proxy-protocol
wodesuck (wodesuck) wrote :

set proxy_protocol_networks to an IPv4-mapped address(::ffff:a.b.c.d) make it work properly without bind_address.

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-3313

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers