• Go to Grafana UI: http://localhost:3000
• Login as "admin"/"admin" (you can change passwords later).
• Choose add data source, then Add PostgreSQL DB with those settings:
• Name "psql", Type "PostgreSQL", host "127.0.0.1:5432", database "projname", user "ro_user" (this is the select-only user for psql), password "your-psql-password", ssl-mode "disabled".
• Make sure to run ./devel/ro_user_grants.sh projname to add ro_user's select grants for all psql tables in projectname.
• If doing this for the first time also create ro_user via devel/create_ro_user.sh.
• Click Home, Import dashboard, Upload JSON file, choose dashboards saved as JSONs in grafana/dashboards/{{project}}dashboard_name.json, data source "PostgreSQL" and save.
• All dashboards are here: kubernetes, prometheus, opentracing.
• Do the same for all defined dashboards. Use specific project tag, for example kubernetes, prometheus or opentracing.
• Import main home for example kubernetes dahsboard.
• Set some dashboard(s) as "favorite" - star icon, you can choose home dashboard only from favorite ones.
• Choose Admin -> Preferences, name your organization (for example set it to XYZ), same with Admin -> profile.
• Set your home dashboard to just imported "Dashboards".
• You can also try to use current grafana.db to import everything at once, but be careful, because this is file is version specific.
• When finished, copy final settings file grafana.db: cp /var/lib/grafana.proj/grafana.db /var/www/html/grafana.proj.db, chmod go+r /var/www/html/grafana.proj.db to be visible from web server.
• Change Grafana admin/admin credentials to something secure!

To enable Grafana anonymous login, do the following:

• Edit Grafana config file: /etc/grafana/grafana.ini or /usr/local/share/grafana/conf/defaults.ini or /usr/local/etc/grafana/grafana.ini:
• Make sure you have options enabled (replace XYZ: with your organization name):

[auth.anonymous]
enabled = true
org_name = XYZ
org_role = Read Only Editor

To enable Google analytics (outdated - uses GA prior to v4 which is no longer supported):

google_analytics_ua_id = UA-XXXXXXXXX-Y

To enable GA4 (requires Grafana >= 9.X):

google_tag_manager_id = GTM-M5KXPQ53

• Restart grafana server.

To restrict using GRAFANA by server IP, for example 147.72.202.77:3000, you can set:

• http_addr = 127.0.0.1

This will only allow accessing Grafana from Apache proxy, please also see:

• APACHE.md

• SSL.md

• To run multiple Grafana instances follow MULTIPROJECT.md.

Manually importing dashboards

• Import grafana/dashboards/proj/dashboards.json dashboard on all remaining projects manually or use sqlitedb tool.
• For example to only import dashboards for the new project use: ONLY=newproject DASHBOARDS='dashboards.json' ./devel/put_all_charts.sh. Then eventually (on success): ./devel/put_all_charts_cleanup.sh.
• Import all new projects dashboards from grafana/dashboards/newproject/*.json, then finally: grafana/copy_grafana_dbs.sh.
• You can also run: ./grafana/restart_all_grafanas.sh.