Bug #74988 incomplete configuration documentation.
Submitted: 24 Nov 2014 22:07 Modified: 15 Mar 2016 2:56
Reporter: Juan Rene Ramirez Monarrez Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Fabric: Documentation Severity:S3 (Non-critical)
Version:1.5 OS:Any
Assigned to: Philip Olson CPU Architecture:Any

[24 Nov 2014 22:07] Juan Rene Ramirez Monarrez
Description:
Authentication Configuration
----------------------------
We have been refactoring the integration of Fabric into the Workbench to make them communicate through the mysql protocol and I had troubles making the authentication to work.

After some talk with Geert, He gave me details that made clear how the authentication works, i.e. 

The documentation should include a section where it explains the cases in which the configured users (on the cfg file) are created automatically on the instance setup process.

Should also explain that if the users were not present at the setup time, they should be added, also what's the purpose of the different user types.

Valid Commands using the MySQL Protocol
---------------------------------------

Another issue I faced was the lack of documentation about the valid fabric commands over the mysql protocol as well as how to call them, I ended finding out by looking at the source code, would be nice to have a full reference about them.

How to repeat:
Procedure is obvious but in my case I had a fabric 1.4 instance and then I upgraded to Fabric 1.5.

I configured the protocol.mysql section but did not know I had to add the user on the fabric instance and there's nothing mentioned on the docs about it.

Also: try to play with the mysql protocol: I found the valid commands by looking at the source code.
[25 Nov 2014 10:20] Umesh Shastry
Hello Juan,

Thank you for the report.
I agree with you and more information is needed.
Also, see http://dev.mysql.com/doc/mysql-utilities/1.5/en/fabric-cfgref.html there is relevant section for each options.

Thanks,
Umesh