Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
N/A
-
None
Description
Please change:
#title# Enable use of non root connections
|
|
When using the General Query Log, non-root users may encounter issues when querying Spider tables.
|
Explicitly setting the spider_internal_sql_log_off system variable causes the Spider node to execute
|
SET sql_log_off statements on the data nodes to enable or disable the General Query Log.
|
When this is done, queries issued by users without the SUPER privilege raise an error.
|
|
To avoid this, don't explicitly set the spider_internal_sql_log_off system variable.
|
To:
#title# Setting the SUPER privilege for the Spider user on data nodes or alternatives to avoid privilege issues
|
|
When explicitly setting the [spider_internal_sql_log_off|https://mariadb.com/kb/en/spider-system-variables/#spider_internal_sql_log_off]
|
system variable, please note that Spider will execute matching [SET SQL_LOG_OFF|https://mariadb.com/docs/server/ref/mdb/system-variables/sql_log_off/]
|
statements on each of the data nodes. It will attempt to do this on the data nodes using the SUPER privilege,
|
which thus requires one to grant this privilege to the Spider user on the data nodes.
|
|
If the Spider user on the data note is not configured with the SUPER privilege, you may encounter issues
|
when working with Spider tables like ERROR 1227 (42000): Access denied for the missing SUPER privilege.
|
To avoid this, don't explicitly set spider_internal_sql_log_off, or set it to -1, or grant the SUPER privilege
|
to the Spider user on the data node.
|
Here: https://mariadb.com/kb/en/spider-use-cases/#enable-use-of-non-root-connections
Thank you
Attachments
Issue Links
- relates to
-
MDEV-29659 Got error 1227 when reading table and ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation on SELECT or HANDLER READ when using spider_internal_sql_log_off=0
- Closed
-
MDEV-33043 Possible performance optimization when using spider_internal_sql_log_off=0/1
- Open