How to restart MySQL Fabric with authentication enabled? -


i working on mysql fabric installation, , had been working disable_authentication set yes:

... [protocol.xmlrpc] address = 0.0.0.0:32274 threads = 5 user = admin password = hunter2 disable_authentication = yes realm = mysql fabric ssl_ca = ssl_cert = ssl_key = ... 

i set 'no', , ran mysqlfabric manage stop mysqlfabric manage start --daemonize. client app broke, set disable_authentication 'yes' , ran mysqlfabric stop again restart it, got:

permission denied. 

i looked through documentation, both locally , @ online, , haven't seen way pass username , password mysqlfabric utility. tried -u -p in mysql , --user , --password, no avail. latter gives

mysqlfabric: error: no such option: --password 

which seems suggest --user valid option, tried --pass , -p no success.

i kill process, i'd know how cleanly restart server when authentication enabled.

after plumbing around in code mysqlfabric, noticed looked mysqlfabric utility re-reading newly-modified config file, seeing disable_authentication set 'yes', , clearing out credentials, if specified them on command line.

as far can tell, running mysqlfabric instance still had credentials enabled, when presented cleared-out credentials, denied permission.

the solution change config file disable_authentication = no, stop server, then edit config file disable authentication, , start up.

takeway lesson:
don't modify fabric configuration file while it's running, make sure stop server, edit config, , start up.

while @ it, seems if need specify username/password, command indeed:

mysqlfabric manage stop --user=<username> 

it prompt password.


Comments