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...
Changed in codership-mysql: | |
status: | Fix Committed → Fix Released |
> 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.