Bug #72572 | mysqluserclone does not give informative error message when MySQL is stopped | ||
---|---|---|---|
Submitted: | 8 May 2014 12:20 | Modified: | 12 Jun 2014 2:41 |
Reporter: | Shahriyar Rzayev | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Utilities | Severity: | S1 (Critical) |
Version: | 1.4.2 | OS: | Linux (CentOS 6.5) |
Assigned to: | CPU Architecture: | Any |
[8 May 2014 12:20]
Shahriyar Rzayev
[9 May 2014 8:36]
MySQL Verification Team
Hello Shahriyar, Thank you for the bug report. Verified as described. Thanks, Umesh
[15 May 2014 10:48]
Shahriyar Rzayev
Also related to remote host: When using mysqluserclone with following syntax, If on destination host iptables enabled: [root@linuxsrv3 ~]# mysqluserclone --source=root:12345@localhost --destination=remote:12345@192.168.1.88 'remote'@'%' ttt:12345@localhost --force # Source on localhost: ... connected. # Destination on 192.168.1.88: ... ERROR: Cannot connect to the Destination server. Error Can't connect to MySQL server on '192.168.1.88:3306' (113 No route to host) ##. (113 No route to host) Is on destination host iptables disabled and mysql stopped: [root@linuxsrv4 ~]# service iptables stop iptables: Setting chains to policy ACCEPT: filter [ OK ] iptables: Flushing firewall rules: [ OK ] iptables: Unloading modules: [ OK ] [root@linuxsrv4 ~]# service mysqld stop Stopping mysqld: [ OK ] [root@linuxsrv3 ~]# mysqluserclone --source=root:12345@localhost --destination=remote:12345@192.168.1.88 'remote'@'%' ttt:12345@localhost --force # Source on localhost: ... connected. # Destination on 192.168.1.88: ... ERROR: Cannot connect to the Destination server. Error Can't connect to MySQL server on '192.168.1.88:3306' (111 Connection refused) ## (111 Connection refused)
[12 Jun 2014 2:41]
Philip Olson
Fixed as of the upcoming MySQL Utilities 1.4.4 release, and here's the changelog entry: Error messages for the "mysqluserclone" utility were improved by making them more explicit in terms of what might be missing. Thank you for the bug report.