influxdb安装及执行-ubuntu篇

在ubuntu的环境下安装使用influxdb

Step1 安装

Demo by ubuntu16.04 & influxDB1.5.4

下载安装并启动

wget https://dl.influxdata.com/influxdb/releases/influxdb_1.5.4_amd64.deb

sudo dpkg -i influxdb_1.5.4_amd64.deb

只有刚安装完要自行开启服务，以后开机就会自动带起服务了。

sudo service influxdb start

连线测试

influx

show databases

create database mydb

create database yourdb

show databases

移除influxDB

sudo apt-get remove influxdb

Start service sudo service influxdb start

stop service sudo service influxdb stop

restart service sudo service influxdb restart

Step2 设定
Influxdb 的设定档位置

#open with vim
sudo vim /etc/influxdb/influxdb.conf

#open with nano
sudo nano /etc/influxdb/influxdb.conf

资料库的储存路径

[meta]

  # Where the metadata/raft database is stored

  dir = "/var/lib/influxdb/meta"

[data]

  # The directory where the TSM storage engine stores TSM files.

  dir = "/var/lib/influxdb/data"

  # The directory where the TSM storage engine stores WAL files.

  wal-dir = "/var/lib/influxdb/wal"

安全性管理(option)

[http]

  # Determines whether HTTP endpoint is enabled.

  enabled = true

  # The bind address used by the HTTP service.

  bind-address = ":8086"

  # Determines whether user authentication is enabled over HTTP/HTTPS.

  auth-enabled = false

step3 安全性管理
3.1 建立帐号

3.1.1 建立管理者帐号

CREATE USER <username> WITH PASSWORD '<password>' WITH ALL PRIVILEGES

example
CREATE USER admin WITH PASSWORD 'admin' WITH ALL PRIVILEGES

3.1.2建立一般帐号

CREATE USER <username> WITH PASSWORD '<password>'

example:
CREATE USER usr WITH PASSWORD '1234'

3.1.3 帐号一览

SHOW USERS

3.1.4帐号权限设定

授权全部的资料库(等于管理者帐号)

GRANT ALL PRIVILEGES TO <username>

example:
GRANT ALL PRIVILEGES TO usr

全部除权

REVOKE ALL PRIVILEGES FROM <username>

example:
REVOKE ALL PRIVILEGES FROM usr

指定授权某资料库

GRANT [READ,WRITE,ALL] ON <database_name> TO <username>

example:
GRANT ALL ON mydb TO usr

指定除权某资料库

REVOKE [READ,WRITE,ALL] ON <database_name> TO <username>

example:
REVOKE ALL ON mydb TO usr

3.2 产生认证档( 自我认证)

sudo openssl req -x509 -nodes -newkey rsa:2048 -keyout /etc/ssl/influxdb-selfsigned.key -out /etc/ssl/influxdb-selfsigned.crt -days <NUMBER_OF_DAYS>

#example:(建立十年的有效期)
sudo openssl req -x509 -nodes -newkey rsa:2048 -keyout /etc/ssl/influxdb-selfsigned.key -out /etc/ssl/influxdb-selfsigned.crt -days 3650

#照程序接下來會要求寫一些基本資料
#懶得寫的話就一路ENTER到底吧

3.3 修改设定档

[http]

  # Determines whether HTTP endpoint is enabled.
  enabled = true

  # The bind address used by the HTTP service.
  bind-address = ":8086"


  # Determines whether user authentication is enabled over HTTP/HTTPS.
  auth-enabled = true

  # The SSL certificate to use when HTTPS is enabled.
  https-certificate = "/etc/ssl/influxdb-selfsigned.crt"

  # Use a separate private key location.
  https-private-key = "/etc/ssl/influxdb-selfsigned.key"

3.4 最后记得要重启服务

sudo service influxdb restart

Step4 连线测试
4.1 加密连线

#使用管理員權限登入(admin-擁有所有db的權限)
influx -host 'localhost' -port '8086' -ssl -unsafeSsl -username 'admin' -password 'admin'

#使用一般帳號登入(usr-只有mydb的權限)
influx -host 'localhost' -port '8086' -ssl -unsafeSsl -username 'usr' -password '1234'

4.2帐号权限测试使用这两个帐号测试以下指令看看

--有權限才能看到資料

show databases