Grafana

February 16, 2024

Grafana is a multi-platform open source analytics and interactive visualization web application. It provides charts, graphs, and alerts for the web when connected to supported data sources.

Prerequisites #

hetzner - vServer - CPX21
- 3 VCPU
- 4 GB RAM
- 80 GB DISK LOKAL
OS - Fedora 39
packages
- zsh
- oh-my-zsh
- sh -c "$(curl -fsSL https://raw.githubusercontent.com/ohmyzsh/ohmyzsh/master/tools/install.sh)"
- tmux
- neovim - LazyVim
- fail2ban
- sendmail
- ufw
- nginx
- letsencrypt - steps to do
- certbot, python3-certbot-nginx
- postgres-server
- grafana

Configuration #

postgres
- Installation and Configuration
- User Creation and Database Creation
- IMPORTANT - Prevent Login Issue
- and edit host all all 127.0.0.1/32 ident to host all all 127.0.0.1/32 md5 <– IMPORTANT This should allow most applications to connect with username/password. pg_hba.conf for reference
- Database user permissions (Important!) - Link to Docs
```
  CREATE USER grafanareader WITH PASSWORD 'password';
  GRANT USAGE ON SCHEMA schema TO grafanareader;
  GRANT SELECT ON schema.table TO grafanareader;
```
-> Also works for GRANT SELECT ON TABLE permissions

Screenshots #

Screenshot