Create influxdb user using Ansible

Question

How can I create a user in Influxdb using ansible module ?

In influxdb ansible docs , I could not find that how to create a user.

I am trying to create it via influxdb API, but have not got success in that.

  - name: create user in influxdb
    uri:
      url: "http://localhost:8086/query"
      method: POST
      body: "--data-urlencode 'q=CREATE USER myuser WITH PASSWORD 'mypass' WITH ALL PRIVILEGES'"
      body_format: raw

The response is,

fatal: [192.168.122.62]: FAILED! => {"changed": false, "connection": "close", "content": "{\"error\":\"missing required parameter \\\"q\\\"\"}\n", "content_length": "45", "content_type": "application/json", "date": "Wed, 05 Jul 2017 12:08:26 GMT", "failed": true, "json": {"error": "missing required parameter \"q\""}, "msg": "Status code was not [200]: HTTP Error 400: Bad Request", "redirected": false, "request_id": "a6c36bfd-617a-11e7-800c-000000000000", "status": 400, "url": "http://localhost:8086/query", "x_influxdb_version": "1.2.2"}

The module is a preview and a community maintained. I am not familiar with this database, but maybe this is a help: https://stackoverflow.com/a/38663851/4503915 — ThoFin, Jul 05 '17 at 11:58
The HTTP seems to have a problem, do you really use the same configuration as in the mentioned answer? — ThoFin, Jul 05 '17 at 13:26
I think you can do it with `influxdb_user` resource with parameter `admin` https://docs.ansible.com/ansible/latest/collections/community/general/influxdb_user_module.html — forzagreen, Oct 27 '20 at 17:42

score 1 · Answer 1 · answered Sep 12 '17 at 13:35

I had a nightmare with quotes... BUT this one worked for me:

  - name: "[Centos7_InfluxDB] Create InfluxDB user"
    command: 'influx -database {{item.database}} -execute "CREATE USER {{item.user}} WITH PASSWORD
             {{item.pass}} WITH ALL PRIVILEGES"'
    with_items:
      - { database: "sample_database", user: "adminuser", pass: "'adminpass'" }

score 1 · Answer 2 · answered Feb 27 '18 at 08:17

1

This code should work as you expect :

- name: create user in influxdb
  uri:
    url: "http://localhost:8086/query"
    method: POST
    body: "q=CREATE USER myuser WITH PASSWORD 'mypass' WITH ALL PRIVILEGES"

answered Feb 27 '18 at 08:17

broferek

81
3

score 0 · Answer 3 · answered Sep 04 '17 at 03:11

You can easily create a user using the command module.

- name: Create InfluxDB user
  command: "influx -execute \"CREATE USER {{item.user}} WITH PASSWORD 
           '{{item.pass}}' WITH ALL PRIVILEGES\""
  with_items:
    - { user: 'admin', pass: 'admin' }

This should be a lot more efficient than using the REST api.

score 0 · Answer 4 · answered Jun 03 '19 at 10:23

0

If anyone's wondering about that as well - just keep in mind that there are community modules for Ansible that already do everything you want, without having to do it with raw/command modules

answered Jun 03 '19 at 10:23

Damian Fajfer

109
2
4

Create influxdb user using Ansible

4 Answers4