← Back to team overview

linux-traipu team mailing list archive

[Bug 955555] [NEW] slave and simple_user_policy plugins don't work together

 

Public bug reported:

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.

** Affects: drizzle
     Importance: Undecided
         Status: Confirmed


** Tags: simple-user-policy-plugin slave-plugin

-- 
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.

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


Follow ups

References