Bug #72769 mysqlrplshow: Cannot connect to the slave server. Unclear connection message.

Submitted: 28 May 2014 7:31 Modified: 11 Jun 2014 4:24
Reporter: Shahriyar Rzayev Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Utilities Severity:S1 (Critical)
Version:1.4.3 OS:Linux (CentOS 6.5)
Assigned to: CPU Architecture:Any

[28 May 2014 7:31] Shahriyar Rzayev
Description:
Dear experts, 
While testing mysqlrplshow again encountered unclear connection message as was in:

http://bugs.mysql.com/bug.php?id=72706

on Master MySQL:

mysql> show slave hosts\G
*************************** 1. row ***************************
 Server_id: 2
      Host: 192.168.1.88
      Port: 3306
 Master_id: 1
Slave_UUID: 5a70670a-d99e-11e3-8dea-080027304b04
1 row in set (0,00 sec)

On Slave server:

mysql> select @@report_host;
+---------------+
| @@report_host |
+---------------+
| 192.168.1.88  |
+---------------+
1 row in set (0,00 sec)

mysql> select @@report_port;
+---------------+
| @@report_port |
+---------------+
|          3306 |
+---------------+
1 row in set (0,00 sec)

[root@linuxsrv4 ~]# ifconfig
eth0      Link encap:Ethernet  HWaddr 08:00:27:30:4B:04  
          inet addr:192.168.1.88  Bcast:192.168.1.255  Mask:255.255.255

mysql> show grants for remote2;
+-----------------------------------------------------------------------------------------------------------------+
| Grants for remote2@%                                                                                            |
+-----------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'remote2'@'%' IDENTIFIED BY PASSWORD '*A2D73F3748C78DE12A161011AADA385D608EF6D4' |
+-----------------------------------------------------------------------------------------------------------------+
1 row in set (0,00 sec)

mysqlrplshow usage:

[root@linuxsrv3 ~]# mysqlrplshow  --master=root:12345@localhost --discover-slaves-login='remote2':'Pass@123#' -vvv
# master on localhost: ... connected.
# Finding slaves for master: localhost:3306

WARNING: There are slaves that had connection errors.

# Replication Topology Graph
No slaves found.

Mistype password:

[root@linuxsrv3 ~]# mysqlrplshow  --master=root:12345@localhost --discover-slaves-login='remote2':'Pass@123' -vvv
# master on localhost: ... connected.
# Finding slaves for master: localhost:3306
Error connecting to a slave as remote2@192.168.1.88: Cannot connect to the slave server.
Error Access denied for user 'remote2'@'192.168.1.77' (using password: YES)

WARNING: There are slaves that had connection errors.

# Replication Topology Graph
No slaves found.

'remote2'@'192.168.1.77' --> in fact 192.168.1.77 is a master server and i have already provided --master connection setting. So it really unclear what kind of connection it is.

How to repeat:
All necessary steps provided in description.

Suggested fix:
No idea.
[28 May 2014 9:52] MySQL Verification Team
Hello Shahriyar,

Thank you for the bug report.
Verified as described.

Thanks,
Umesh
[29 May 2014 20:49] Chuck Bell
Duplicate of BUG#72707.

Also, the error message concerning wrong password is consistent with the mysql client and therefore not a defect.

$ mysql -uroot -pwrong 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[30 May 2014 6:22] Shahriyar Rzayev
Marked as Duplicate of http://bugs.mysql.com/bug.php?id=72707 ?

"mysqlrplsync does not detect stopped slave server " -> it is another topic and not related to this report at all.

Related to exact this report i must say:

As you see i have already provided --master option for master server.
--master=root:12345@localhost
And why it wants(must) to connect to master server again as user remote2?
(192.168.1.77)
[11 Jun 2014 4:24] MySQL Verification Team
As per dev's note: [29 May 20:49] Charles Bell
Duplicate of BUG#72707.

Marking this as duplicate of BUG#72707

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.041 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.