[influxdb] Cannot create a influxdb user with CLI influx -execute

[g***@gmail.com]

Hi,
I am quite new to InfluxDB, but I could not find any reference to my problem in the docs.

Some context first, I am setting up an ansible playbook to install influxdb with authentication and authorization.
As I understood it, this implies I need to create a user.


So in my playbook i have this:
- name: Create useer
command: influx -ssl -unsafeSsl -execute 'CREATE USER "test" WITH PASSWORD 'secret''

But that fails with this error:
"ERR: error parsing query: found secret, expected string at line 1, char 36", "Warning: It is possible this error is due to not setting a database.", "Please set a database with the command \"use <database>\"."

The same thing happens if I do it on the command line"
$ influx -execute 'CREATE USER "test2" WITH PASSWORD 'secret''
ERR: error parsing query: found secret, expected string at line 1, char 35
Warning: It is possible this error is due to not setting a database.
Please set a database with the command "use <database>".
error parsing query: found secret, expected string at line 1, char 35

But the same query succeeds if doit interactively:
$ influx
Visit https://enterprise.influxdata.com to register for updates, InfluxDB server management, and monitoring.
Connected to http://localhost:8086 version v1.0.2
InfluxDB shell version: v1.0.2

show users

user admin
test false
test1 false

CREATE USER "test3" WITH PASSWORD 'secret'
show users

user admin
test false
test1 false
test3 false


Am I doing something wrong?
Any help or pointer to solutions is much appreciated.

Thanks.



Giacomo