linux-traipu team mailing list archive

[Daniel Nichter <daniel@xxxxxxxxxxx>]

** Description changed:

  The slave and simple_user_policy plugins do not work together because
  the slave plugin does not use a user, therefore the following error is
  logged:
  
  (SQLSTATE 00000) Access denied for user '<no user>' to schema 'sys_replication'
  Failure while executing:
  COMMIT
  CREATE SCHEMA IF NOT EXISTS `sys_replication` REPLICATE=FALSE
  
  Could not start slave services: (SQLSTATE 00000) Access denied for user
  '<no user>' to schema 'sys_replication'
  
  Since the slave plugin can't create its sys_replicaiton table, it can't
  work.
  
  Possible solution: --slave.user and --slave.password options so the
  slave plugin can operate as the specified user.
+ 
+ Workaround: use regex_policy and ".+ schema=sys_replication ACCEPT".

-- 
You received this bug notification because you are a member of UBUNTU -
AL - BR, which is subscribed to Drizzle.
https://bugs.launchpad.net/bugs/955555

Title:
  slave and simple_user_policy plugins don't work together

Status in A Lightweight SQL Database for Cloud Infrastructure and Web Applications:
  Confirmed

Bug description:
  The slave and simple_user_policy plugins do not work together because
  the slave plugin does not use a user, therefore the following error is
  logged:

  (SQLSTATE 00000) Access denied for user '<no user>' to schema 'sys_replication'
  Failure while executing:
  COMMIT
  CREATE SCHEMA IF NOT EXISTS `sys_replication` REPLICATE=FALSE

  Could not start slave services: (SQLSTATE 00000) Access denied for
  user '<no user>' to schema 'sys_replication'

  Since the slave plugin can't create its sys_replicaiton table, it
  can't work.

  Possible solution: --slave.user and --slave.password options so the
  slave plugin can operate as the specified user.

  Workaround: use regex_policy and ".+ schema=sys_replication ACCEPT".

To manage notifications about this bug go to:
https://bugs.launchpad.net/drizzle/+bug/955555/+subscriptions