influxdata / influxdata/influxdata-docker

ERR: authorization failed for non-admin user

Open
#327 4 comments 3 reactions 0 assignees View on GitHub
influxdb question
Dominant language
Shell
Stars
364
Forks
255
Avg merge
3h 18m
Merged PRs (30d)
7

Description

I'm getting "ERR: authorization failed" when executing USE command from CLI

admin user

```
influx -host influx.example.com -username admin -password admin
Connected to http://influx.example.com:8086 version 1.5.4
InfluxDB shell version: v1.7.2
Enter an InfluxQL query
> show databases;
name: databases
name
----
telegraf
_internal
> SHOW USERS
user admin
---- -----
admin true
telegraf false
> SHOW GRANTS FOR telegraf
database privilege
-------- ---------
telegraf ALL PRIVILEGES
> GRANT ALL ON "telegraf" TO "telegraf"
> SHOW GRANTS FOR telegraf
database privilege
-------- ---------
telegraf ALL PRIVILEGES
> exit
```

non-admin user

```
influx -host influx.example.com -username telegraf -password telegraf
Connected to http://influx.example.com:8086 version 1.5.4
InfluxDB shell version: v1.7.2
Enter an InfluxQL query
> use telegraf
WARN: authorization failed
Using database telegraf
> SHOW MEASUREMENTS
ERR: authorization failed
```

Contributor guide

No contributing guide indexed for this repository

Research direction

Reproduce the reported CLI flow with the admin and non-admin users, starting with USE telegraf and SHOW MEASUREMENTS. Compare the displayed grants with the authorization failure and check the repository's CLI or authentication entry points. Done means a non-admin user with the shown database privileges can use the database and run SHOW MEASUREMENTS, or the limitation is documented.

Written by the indexing model from the issue text.

Assessment

Tech stack
shell
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.