Bug #59477 mysqlreplicate fails when the 2 servers have the same port number
Submitted: 13 Jan 2011 18:15 Modified: 9 Jul 2012 19:09
Reporter: Andrew Morgan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Utilities Severity:S3 (Non-critical)
Version:WB 5.2.31 OS:Windows (Windows 7)
Assigned to: Assigned Account CPU Architecture:Any

[13 Jan 2011 18:15] Andrew Morgan
Description:
When I try this operation, I get this error....

C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\utilities>mysqlreplicate --master=root@192.168.1.8:3306 --slave=root@192.168.1.9:3306
ERROR: You must specify two different servers for the operation.

It appears to be comparing just the port numbers to decide if the same server is being specified twice.

How to repeat:
mysqlreplicate --master=root@192.168.1.8:3306 --slave=root@192.168.1.9:3306

Suggested fix:
Compare both the server IP address/hostname and the port number - only raise error if both attributes match
[14 Jan 2011 15:18] Chuck Bell
Easily fixed...
[14 Jan 2011 15:58] Chuck Bell
Latest patch for review

Attachment: 59477.bundle (application/octet-stream, text), 6.12 KiB.

[9 Jul 2012 19:09] Chuck Bell
Fixed in 1.0.1dev1.