Bug #82621 Checking permissions for backing store
Submitted: 18 Aug 2016 3:59
Reporter: Tsubasa Tanaka (OCA) Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Fabric Severity:S3 (Non-critical)
Version:1.5.6 OS:Any
Assigned to: CPU Architecture:Any

[18 Aug 2016 3:59] Tsubasa Tanaka
Description:
Currently, MySQL Fabric doesn't check permissions when mysqlfabric daemon starts.
(Just decide connection to database which is specified in fabric.cfg or not)

How to repeat:
After mysqlfabric manage setup.

On backing-store,

mysql> CREATE DATABASE fabric;
mysql> CREATE USER fabric@localhost;
mysql> GRANT SELECT ON fabric.* TO fabric@localhost;

On fabric.cfg,

[storage]
user= fabric
password= 
database= fabric

Start mysqlfabric, its start seems successfully and `mysqlfabric manage ping` succeed, but `mysqlfabric group create myfabric` fails.

Suggested fix:
STORE_PRIVILEGES has been defined but not used.

https://github.com/mysql/mysql-fabric/blob/release/1.5.6/lib/mysql/fabric/persistence.py#L...

I patched this like https://github.com/gmo-media/mikasafabric/commit/7bb63e2d2c44598d7d4a4ec64b79f0b2c92a2a44
[6 Jul 2017 19:20] Bugs System
Status updated to 'Won't fix' (Fabric is now covered under Oracle Lifetime Sustaining Support)