===== Templates repo =====

[[https://github.com/remontti/Zabbix-Templates]]

===== HT authentication through zabbix users from DB =====

<code>


chmod go-rxw /etc/zabbix/apache.conf
a2enmod authn_dbd
a2enmod authn_socache
systemctl restart apache2
apt install libaprutil1-dbd-mysql -y

nano /etc/apache2/mods-enabled/authn_dbd.conf

<IfModule mod_dbd.c>
	DBDriver mysql
	DBDParams host=localhost,dbname=zabbix,user=zabbix,pass=appaloosa
	DBDMin 1
	DBDKeep 8
	DBDMax 16
	DBDExptime 300
</IfModule>


<Directory "/zabbix/">
	AuthType Basic
	AuthName "Authentication"
	AuthBasicProvider socache dbd
	AuthnCacheProvideFor dbd
	AuthnCacheContext Authentication
	Require valid-user
	AuthDBDUserPWQuery "SELECT passwd FROM users WHERE username = %s"
</Directory>

<Location "/.well-known">
AuthType None
Require all granted
</Location>

</code>


===== Grafana =====

<code>
sudo apt-get install -y apt-transport-https software-properties-common wget
wget -q -O - https://packages.grafana.com/gpg.key | sudo apt-key add -
echo "deb https://packages.grafana.com/oss/deb stable main" | sudo tee -a /etc/apt/sources.list.d/grafana.list
sudo apt-get update
sudo apt-get install grafana -y
sudo systemctl daemon-reload
sudo systemctl start grafana-server
sudo systemctl enable grafana-server.service
grafana-cli plugins install alexanderzobnin-zabbix-app
sudo systemctl restart grafana-server

Set the URL to http://localhost/zabbix/api_jsonrpc.php (or your actual Zabbix server URL).



nano /etc/apache2/conf-available/grafana.conf

ProxyRequests On
#SSLProxyEngine on
ProxyPreserveHost On
ProxyPass /grafana http://localhost:3000/grafana
ProxyPassReverse /grafana http://localhost:3000/grafana


nano /etc/grafana/grafana.ini

http_addr = 127.0.0.1
root_url = %(protocol)s://%(domain)s:%(http_port)s/grafana
serve_from_sub_path = true

a2enmod proxy proxy_http rewrite headers proxy_wstunnel
a2enconf grafana
/etc/init.d/apache2 restart
/etc/init.d/grafana-server restart


</code>