influxdata-docker icon indicating copy to clipboard operation
influxdata-docker copied to clipboard

init-influxdb.sh broken?

Open RezzZ opened this issue 7 years ago • 3 comments

Hi, trying to Manually Initializing the Database and Users and passwords using this line:

docker run --rm influxdb influxd config > /opt/influxdb/influxdb.conf
docker run --rm \
  -e INFLUXDB_ADMIN_USER=admin -e INFLUXDB_ADMIN_PASSWORD='[MY_ADMIN_PW]' \
  -e INFLUXDB_USER=homeassistant -e INFLUXDB_USER_PASSWORD='[MY_USER_PW]' \
  -e INFLUXDB_DB=homeassistant \
  -v /opt/influxdb:/var/lib/influxdb \
  influxdb /init-influxdb.sh

somehow I only see my database created but the user is missing..:

influxdb init process in progress...
ts=2018-11-21T17:45:33.556964Z lvl=info msg="InfluxDB starting" log_id=0BuqslT0000 version=1.7.1 branch=1.7 commit=cb03c542a4054f0f4d3dc13919d31c456bdb5c39
ts=2018-11-21T17:45:33.557046Z lvl=info msg="Go runtime" log_id=0BuqslT0000 version=go1.11 maxprocs=4
ts=2018-11-21T17:45:33.672173Z lvl=info msg="Using data dir" log_id=0BuqslT0000 service=store path=/var/lib/influxdb/data
ts=2018-11-21T17:45:33.672485Z lvl=info msg="Compaction settings" log_id=0BuqslT0000 service=store max_concurrent_compactions=2 throughput_bytes_per_second=50331648 throughput_bytes_per_second_burst=50331648
ts=2018-11-21T17:45:33.672555Z lvl=info msg="Open store (start)" log_id=0BuqslT0000 service=store trace_id=0Buqslv0000 op_name=tsdb_open op_event=start
ts=2018-11-21T17:45:33.673263Z lvl=info msg="Open store (end)" log_id=0BuqslT0000 service=store trace_id=0Buqslv0000 op_name=tsdb_open op_event=end op_elapsed=0.711ms
ts=2018-11-21T17:45:33.673437Z lvl=info msg="Opened service" log_id=0BuqslT0000 service=subscriber
ts=2018-11-21T17:45:33.673474Z lvl=info msg="Starting monitor service" log_id=0BuqslT0000 service=monitor
ts=2018-11-21T17:45:33.673504Z lvl=info msg="Registered diagnostics client" log_id=0BuqslT0000 service=monitor name=build
ts=2018-11-21T17:45:33.673529Z lvl=info msg="Registered diagnostics client" log_id=0BuqslT0000 service=monitor name=runtime
ts=2018-11-21T17:45:33.673554Z lvl=info msg="Registered diagnostics client" log_id=0BuqslT0000 service=monitor name=network
ts=2018-11-21T17:45:33.673596Z lvl=info msg="Registered diagnostics client" log_id=0BuqslT0000 service=monitor name=system
ts=2018-11-21T17:45:33.673819Z lvl=info msg="Starting precreation service" log_id=0BuqslT0000 service=shard-precreation check_interval=10m advance_period=30m
ts=2018-11-21T17:45:33.673870Z lvl=info msg="Starting snapshot service" log_id=0BuqslT0000 service=snapshot
ts=2018-11-21T17:45:33.673901Z lvl=info msg="Starting continuous query service" log_id=0BuqslT0000 service=continuous_querier
ts=2018-11-21T17:45:33.674198Z lvl=info msg="Starting HTTP service" log_id=0BuqslT0000 service=httpd authentication=false
ts=2018-11-21T17:45:33.674260Z lvl=info msg="opened HTTP access log" log_id=0BuqslT0000 service=httpd path=stderr
ts=2018-11-21T17:45:33.674468Z lvl=info msg="Listening on HTTP" log_id=0BuqslT0000 service=httpd addr=127.0.0.1:8086 https=false
ts=2018-11-21T17:45:33.674563Z lvl=info msg="Starting retention policy enforcement service" log_id=0BuqslT0000 service=retention check_interval=30m
ts=2018-11-21T17:45:33.674799Z lvl=info msg="Storing statistics" log_id=0BuqslT0000 service=monitor db_instance=_internal db_rp=monitor interval=10s
ts=2018-11-21T17:45:33.675345Z lvl=info msg="Listening for signals" log_id=0BuqslT0000
ts=2018-11-21T17:45:33.676149Z lvl=info msg="Sending usage statistics to usage.influxdata.com" log_id=0BuqslT0000
[httpd] 127.0.0.1 - - [21/Nov/2018:17:45:35 +0000] "GET /ping HTTP/1.1" 204 0 "-" "InfluxDBShell/1.7.1" 404e9b38-edb5-11e8-8001-0242ac110002 407
ts=2018-11-21T17:45:35.858173Z lvl=info msg="Executing query" log_id=0BuqslT0000 service=query query="CREATE DATABASE homeassistant"
[httpd] 127.0.0.1 - - [21/Nov/2018:17:45:35 +0000] "POST /query?chunked=true&db=&epoch=ns&q=CREATE+DATABASE+homeassistant HTTP/1.1" 200 57 "-" "InfluxDBShell/1.7.1" 404ee6c7-edb5-11e8-8002-0242ac110002 24390
/init-influxdb.sh: ignoring /docker-entrypoint-initdb.d/*

ts=2018-11-21T17:45:35.886758Z lvl=info msg="Signal received, initializing clean shutdown..." log_id=0BuqslT0000
ts=2018-11-21T17:45:35.886957Z lvl=info msg="Waiting for clean shutdown..." log_id=0BuqslT0000
ts=2018-11-21T17:45:35.887392Z lvl=info msg="Shutting down monitor service" log_id=0BuqslT0000 service=monitor
ts=2018-11-21T17:45:35.887415Z lvl=info msg="Listener closed" log_id=0BuqslT0000 service=snapshot
ts=2018-11-21T17:45:35.887566Z lvl=info msg="Terminating precreation service" log_id=0BuqslT0000 service=shard-precreation
ts=2018-11-21T17:45:35.887791Z lvl=info msg="Terminating continuous query service" log_id=0BuqslT0000 service=continuous_querier
ts=2018-11-21T17:45:35.888168Z lvl=info msg="Closing retention policy enforcement service" log_id=0BuqslT0000 service=retention
ts=2018-11-21T17:45:35.888647Z lvl=info msg="Closed service" log_id=0BuqslT0000 service=subscriber
ts=2018-11-21T17:45:35.889230Z lvl=info msg="Server shutdown completed" log_id=0BuqslT0000

RezzZ avatar Nov 21 '18 18:11 RezzZ

Facing the same issue. Any updates on this?

globant-bhomik avatar Jan 04 '19 06:01 globant-bhomik

@RezzZ @globant-bhomik init-influxdb.sh won't do anything if the environment variable for HTTP auth isn't set. Try adding -e INFLUXDB_HTTP_AUTH_ENABLED=true to your list of variables; did the trick for me.

studentism avatar Feb 20 '19 04:02 studentism

Still facing this issue, setting INFLUXDB_HTTP_AUTH_ENABLED=true makes the "CREATE DATABASE" query fails with 403:

[httpd] 127.0.0.1 - - [17/Nov/2020:10:03:13 +0000] "POST /query?chunked=true&db=&epoch=ns&q=CREATE+DATABASE+test HTTP/1.1" 403 87 "-" "InfluxDBShell/1.8.2" 1a9eef2b-28bc-11eb-803c-0242ac110002 186

any clue?

babaMar avatar Nov 17 '20 10:11 babaMar