diff options
| author | Jacob Mathew <jacob.mathew@mariadb.com> | 2018-05-01 14:14:06 -0700 |
|---|---|---|
| committer | Jacob Mathew <jacob.mathew@mariadb.com> | 2018-05-01 14:14:06 -0700 |
| commit | 72f0efac67c21df6639f3dd01dfc74f0896172ec (patch) | |
| tree | a6a337ddfe67750dbb0781d162f9a3d3f8449016 /storage/spider/spd_param.h | |
| parent | 99fa7c6c2f9c8d705481bec35f7c4af48848cf70 (diff) | |
| download | mariadb-git-72f0efac67c21df6639f3dd01dfc74f0896172ec.tar.gz | |
MDEV-15697: Remote user used by Spider needs SUPER privilegebb-10.3-MDEV-15697
The remote users need the SUPER privilege because by default Spider sends a
'SET SQL_LOG_OFF' statement to the data nodes. This is controlled by the
spider_internal_sql_log_off configuration setting on the Spider node, which
can only be set to 0 or 1, with a default value of 1.
I have fixed the problem by changing this configuration setting so that if it
is NOT SET, which is the most likely case, the Spider node DOES NOT SEND the
'SET SQL_LOG_OFF' statement to the data nodes. However if the
spider_internal_sql_log_off setting IS EXPLICITLY SET to either 0 or 1, then
the Spider node DOES SEND the 'SET SQL_LOG_OFF' statement, requiring a remote
user with the SUPER privilege. The Spider documentation will be updated to
reflect this change.
Author:
Jacob Mathew.
Reviewer:
Kentoku Shiba.
Diffstat (limited to 'storage/spider/spd_param.h')
| -rw-r--r-- | storage/spider/spd_param.h | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/storage/spider/spd_param.h b/storage/spider/spd_param.h index d4af48a75ea..9a358c54be5 100644 --- a/storage/spider/spd_param.h +++ b/storage/spider/spd_param.h @@ -113,7 +113,7 @@ bool spider_param_sync_time_zone( bool spider_param_use_default_database( THD *thd ); -bool spider_param_internal_sql_log_off( +int spider_param_internal_sql_log_off( THD *thd ); int spider_param_bulk_size( |