grafana mysql安装_Grafana 安装配置

chkconfig

grafana-server on

service

grafana-server start

配置:

配置文件里分段给出了非常详细的说明，非常人性化

默认使用的是sqlite3,这里调整为mysql

1.创建数据库和用户

CREATE

DATABASE grafana DEFAULT CHARACTER SET utf8;

GRANT ALL ON grafana.* TO grafana@'localhost' IDENTIFIED BY

'grafanapassword' WITH GRANT OPTION;

FLUSH PRIVILEGES;

2.指定数据库及认证信息

cp

/etc/grafana/grafana.ini{,.default}

vim

/etc/grafana/grafana.ini

[database]

# Either

"mysql", "postgres" or "sqlite3", it's your choice

type

= mysql

host

= 127.0.0.1:3306

name

= grafana

user

=grafana

password

= grafanapassword

# For

"postgres" only, either "disable", "require" or

"verify-full"

ssl_mode

= true

ca_cert_path

= /opt/mariadb/mariadb-ca.pem

client_key_path

= /opt/mariadb/mariadb-client.key

client_cert_path

= /opt/mariadb/mariadb-client.pem

server_cert_name

= jlive.example.com

[session]

# Either

"memory", "file", "redis",

"mysql", "postgres", default is "file"

provider

= redis

provider_config

= addr=127.0.0.1:6379,pool_size=100,db=grafana

cookie_name

= grafana_sess

cookie_secure

= false

session_life_time

= 86400

3.重启grafana

service grafana-server restart

tail -f /var/log/grafana/grafana.log

2016/05/01 15:40:25

[I] Starting Grafana

2016/05/01 15:40:25

[I] Version: 3.0.0-beta6, Commit: v3.0.0-beta6, Build date:

2016-04-29 14:40:53 +0800 CST

2016/05/01 15:40:25

[I] Configuration Info

Config

files:

[0]: /usr/share/grafana/conf/defaults.ini

[1]: /etc/grafana/grafana.ini

Command

lines overrides:

[0]: default.paths.data=/var/lib/grafana

[1]: default.paths.logs=/var/log/grafana

[2]: default.paths.plugins=/var/lib/grafana/plugins

Paths:

home: /usr/share/grafana

data: /var/lib/grafana

logs: /var/log/grafana

plugins: /var/lib/grafana/plugins

2016/05/01 15:40:25

[I] Database: mysql

2016/05/01 15:40:25

[I] Migrator: Starting DB migration

2016/05/01 15:40:25

[I] Migrator: exec migration id: create migration_log

table

2016/05/01 15:40:25

[I] Migrator: exec migration id: create user table

2016/05/01 15:40:25