此次部署的grafana使用postgres数据库来存放数据

安装postgresql

服务器

• 1、官网

https://www.postgresql.org/download/linux/redhat/

• 2、下载rpm源

yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

• 3、安装客户端

yum install -y postgresql12

• 4、安装服务端

yum install postgresql12-server

• 5、初始化并且开机自启动

/usr/pgsql-12/bin/postgresql-12-setup initdb
systemctl enable postgresql-12
systemctl start postgresql-12

• 6、创建账号密码

sudo su postgres  
psql postgres
ALTER USER postgres WITH PASSWORD 'test123'
执行结果
[root@test01 ~]# sudo su postgres  
bash-4.2$ psql postgres
could not change directory to "/root": Permission denied
psql (12.3)
Type "help" for help.

postgres=# ALTER USER postgres WITH PASSWORD 'test123';
ALTER ROLE

• 7、修改配置文件和登陆权限

echo >>/var/lib/pgsql/12/data/pg_hba.conf<<EOF
host    all             all             172.24.32.200/32        trust
EOF

sed -i "s| listen_addresses = 'localhost' |listen_addresses = '*'|g" /var/lib/pgsql/12/data/postgresql.conf

• 8、重启下数据库

systemctl start postgresql-12

安装grafana

服务器

安装

官网

https://grafana.com/docs/grafana/latest/installation/debian/

cd /usr/local/src
wget https://dl.grafana.com/oss/release/grafana-6.7.3-1.x86_64.rpm

yum install -y grafana-6.7.3-1.x86_64.rpm

修改配置文件

主要修改端口、数据库（sqlite改成postgresql）、告警邮箱

echo >>/etc/grafana/grafana.ini<<EOF
[paths]
[server]
http_port = 3001
[database]
type = postgres
host = 172.24.32.200:5432
name = grafana
user = postgres
password = test123
[remote_cache]
[dataproxy]
[analytics]
[security]
[snapshots]
[dashboards]
[users]
[auth]
[auth.anonymous]
[auth.github]
[auth.gitlab]
[auth.google]
[auth.grafana_com]
[auth.azuread]
[auth.generic_oauth]
[auth.saml] # Enterprise only
[auth.basic]
[auth.proxy]
[auth.ldap]
[smtp]
enabled = true
host = smtp.exmail.qq.com:465
user = lugo@test.com
password = test33
skip_verify = true
from_address = lugo@test.com
from_name = Grafana
[emails]
[log]
[log.console]
[log.file]
[log.syslog]
[quota]
[alerting]
[explore]
[metrics]
[metrics.graphite]
[grafana_com]
[tracing.jaeger]
[external_image_storage]
[external_image_storage.s3]
[external_image_storage.webdav]
[external_image_storage.gcs]
[external_image_storage.azure_blob]
[external_image_storage.local]
[rendering]
[panels]
[plugins]
[enterprise]
[feature_toggles]

EOF

启动和开机自启动

systemctl enable grafana-server
systemctl start grafana-server

登陆，初始密码admin、admin

http://172.24.32.200:3001/login

改密码 test123

添加饼图插件

grafana-cli plugins install grafana-piechart-panel

重启服务生效

service grafana-server restart