ifconfig does not detect wsrep_node_address correctly on german debian installation
| Affects | Status | Importance | Assigned to | Milestone | ||
|---|---|---|---|---|---|---|
| MySQL patches by Codership |
Fix Released
|
Medium
|
Alex Yurchenko | |||
| Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC | Status tracked in 5.6 | |||||
| 5.5 |
Fix Released
|
Undecided
|
Unassigned | |||
| 5.6 |
Fix Released
|
Undecided
|
Unassigned | |||
Bug Description
On German translated Debian 6 installation
/sbin/ifconfig | grep -E '^[[:space:]]+inet addr:'
does not give correct result because in translation it looks as follows:
eth0 Link encap:Ethernet Hardware Adresse 00:16:d3:b3:7e:d2
inet Adresse:
Workaround: set wsrep_node_address manually.
IMHO ifconfig is NOT a good way to determine the correct interface. It is old fashioned and should not be used any more I was told.
What about:
ip addr show | grep inet | grep -v::1| grep -v 127.0.0.1 | head -n 1
inet 127.0.0.1/8 scope host lo
inet6 ::1/128 scope host
inet 192.168.1.222/24 brd 192.168.1.255 scope global eth0
inet 192.168.1.88/24 brd 192.168.1.255 scope global secondary eth0:0
inet6 2001:4dd0:
inet6 fe80::216:
From the Galera Cluster Training at LinuxHotel
PS: This is also not working on IPv6 I would assume whereas ip addr show could work...
| Alex Yurchenko (ayurchen) wrote | #1 |
| Changed in codership-mysql: | |
| assignee: | nobody → Alex Yurchenko (ayurchen) |
| milestone: | none → 5.5.30-23.7.4 |
| status: | New → Confirmed |
| importance: | Undecided → Medium |
| Alex Yurchenko (ayurchen) wrote | #2 |
| Changed in codership-mysql: | |
| status: | Confirmed → Fix Committed |
| shinguz (oli-sennhauser) wrote | #3 |
| Changed in codership-mysql: | |
| status: | Fix Committed → Fix Released |
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #4 |
> Workaround: set wsrep_node_address manually.
This is not a workaround, it is the proper node configuration! User is not supposed to rely on autodetection of node address, since it is clearly impossible to do correctly in the general case (e.g. 2 or more non-local addresses).
However ip addr note taken.