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
Post a Comment