Bug #44200 Agent logs critical message for Replication with SSL set-up
Submitted: 10 Apr 2009 0:12 Modified: 25 Jun 2009 13:36
Reporter: Donna Harmon Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Agent Severity:S3 (Non-critical)
Version:2.0.5.7153 OS:Any
Assigned to: Diego Medina CPU Architecture:Any

[10 Apr 2009 0:12] Donna Harmon
Description:
When Replication is configured to use SSL for encrypting the transfer of the binary log, even though replication works and the dashboard displays the replication group correctly, the agent still logs the following message (repeatedly):

2009-04-06 16:12:00: (critical) job_collect_mysql.c:698: [mysql] (master-uuid) mysql_real_connect(hostname:port replication:...) to the slave's master
failed: Access denied for user 'replication'@'hostname' (using password: YES) (1045)

How to repeat:
Set up replication with SSL enabled and view mysql-monitor-agent.log

Suggested fix:
When replication discovery uses the information from the master.info on slave to connect to master it needs to use SSL.
[30 Apr 2009 20:52] Sloan Childers
If this bug has been verified by our support team, please mark it accordingly.  Assigning to Jan pending verification.
[8 May 2009 15:36] Mark Leith
Verifying as described
[20 May 2009 20:46] Diego Medina
Pushed to trunk

------------------------------------------------------------
revno: 1340
revision-id: diego.medina@sun.com-20090520195617-de75jrsh2bapl3vw
parent: diego.medina@sun.com-20090520193553-h79jxyhp9fmvcngy
committer: Diego Medina <diego.medina@sun.com>
branch nick: local2-trunk
timestamp: Wed 2009-05-20 15:56:17 -0400
message:
  * Fix Bug#44200 
      If replication uses SSL, the agent gets the information from the master.info file,
      to get the master UUID
------------------------------------------------------------
revno: 1339
revision-id: diego.medina@sun.com-20090520193553-h79jxyhp9fmvcngy
parent: merlin@dl380-g5-a.mysql.com-20090520180552-4siymbb69pezd1ys
committer: Diego Medina <diego.medina@sun.com>
branch nick: local2-trunk
timestamp: Wed 2009-05-20 15:35:53 -0400
message:
  * Added support for reading SSL information from master.info files
  * Added support for writing master.info files
[21 May 2009 16:49] Keith Russell
Patch installed in versions => 2.1.0.1049.
[19 Jun 2009 17:32] Diego Medina
Verified fixed on 2.1.0.1067

On the logs you now see:

(message) job_collect_mysql.c:540: [mysql->127.0.0.1:22547] (master-uuid) mysql-query(SELECT value FROM mysql.inventory WHERE name='uuid')
(warning) job_collect_mysql.c:838: [mysql] master-uuid = 1a8ebf4e-850e-4e11-81fb-84fbec9abfcc
[25 Jun 2009 13:36] Tony Bedford
An entry was added to the 2.1.0 changelog:

When Replication was configured to use SSL for encrypting the transfer of the binary log, even though replication worked and the dashboard displayed the replication group correctly, the agent still logged the following message (repeatedly):

2009-04-06 16:12:00: (critical) job_collect_mysql.c:698: [mysql] (master-uuid)
mysql_real_connect(hostname:port replication:...) to the slave's master
failed: Access denied for user 'replication'@'hostname' (using password: YES) (1045)