0

I'm trying to set up group replication using 3 x MySQL 8.0.16 databases, but when I start up the second Node it fails. The error log reports:

[GCS] Connection attempt from IP address ::ffff:10.12.1.2 refused. Address is not in the IP whitelist.

But if I add a whitelist:

group_replication_ip_whitelist="::ffff:10.12.1.2";

I get:

[GCS] Invalid IP or subnet mask in the whitelist: "::ffff:10.12.1.2";

Is this an issue with the server at my end, or an issue with Group Replication not understanding the IP Address?

My configuration is:

server_id=<different for each one>
gtid_mode=ON
enforce_gtid_consistency=ON
binlog_checksum=NONE
transaction_write_set_extraction=XXHASH64
group_replication_group_name="8112d18e-9e6e-11e9-a526-0e51be33883f"
group_replication_start_on_boot=off
group_replication_local_address= "10.12.1.1:33061" /*This is different for each one*/
group_replication_group_seeds= "10.12.1.1:33061,10.12.1.2:33061,10.12.1.3:33061"
group_replication_bootstrap_group=off

If I look on the first nodes error log I can see:

Connection attempt from IP address ::ffff:10.12.1.2 refused. Address is not in the IP whitelist.'

But again, adding it to a whitelist throws the above error about there being an invalid IP Address,

1

That output is done in the most generic possible way, using IPv4-mapped IPv6 address.

It should work if you simply add:

group_replication_ip_whitelist="10.12.1.2";
  • Alas, it makes no difference I'm afraid. – IGGt Jul 26 at 10:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.