Bug #72339 MYSQLFABRIC PARAMETERS NEED TO BE PASSED TO CMDS WHEN AUTHENTICATION IS ENABLED

• Submitted: 14 Apr 2014 11:21
• Modified: 13 Jan 2015 7:53
• Reporter: Alfranio Tavares Correia Junior
• Status: Duplicate
• Category: MySQL Fabric
• Severity: S3 (Non-critical)
• Version: 1.4.2
• OS: Any
• Assigned to: Assigned Account
• CPU Architecture: Any

[14 Apr 2014 11:21] Alfranio Tavares Correia Junior

Description:
Parameters need to be passed before commands to execute fabric commands

How to repeat:
Enable authentication and try to execute fabric commands
[protocol.xmlrpc]
disable_authentication = no
ssl_cert =
realm = MySQL Fabric
ssl_key =
ssl_ca =
threads = 10
user = admin
address = localhost:32274
password = password
when the password is read from config file we are able to execute commands
without prompting for a passowrd, although we need to pass storage address
and user parameter prior to command

-bash-4.1$ mysqlfabric --param=storage.address=tyr44:16002
--param=storage.user=root group health my_group1
Command :
{ success     = True
  return      = {'d46614fc-b9e7-43b2-93d0-a281e8a8d4d4': {'status':
'PRIMARY', 'is_alive': True, 'threads': {}},
'fd71eefd-b29c-4f6f-b8eb-cc1324424bdf': {'status': 'SECONDARY', 'is_alive':
True, 'threads': {}}, '262bce2b-96bc-4d45-940f-8a977e1114e6': {'status':
'SECONDARY', 'is_alive': True, 'threads': {}}}
  activities  =
}

However if we run the commands from same server removing this 2 parameters it
will hangs like this

-bash-4.1$ mysqlfabric group health my_group1
^C
Bye.
need to press ctrl-c to get out of hang state

When no password is supplied in config file, it will prompts for password but
will also hangs in second case
-bash-4.1$ mysqlfabric --param=storage.address=tyr44:16002
--param=storage.user=root group health my_group1
Password for admin:
Command :
{ success     = True
  return      = {'d46614fc-b9e7-43b2-93d0-a281e8a8d4d4': {'status':
'PRIMARY', 'is_alive': True, 'threads': {}},
'fd71eefd-b29c-4f6f-b8eb-cc1324424bdf': {'status': 'SECONDARY', 'is_alive':
True, 'threads': {}}, '262bce2b-96bc-4d45-940f-8a977e1114e6': {'status':
'SECONDARY', 'is_alive': True, 'threads': {}}}
  activities  =
}
-bash-4.1$ mysqlfabric group health my_group1
Password for admin:
^C
Bye.

Suggested fix:
Commands should read parameters from configuration file