Macbook Version
macOS Mojave
10.14.6 (18G87)
Work Directory
~/grafana_work
Install Grafana
Reference
Prepare work of database [ PostgreSQL 11.4 ]
create database grafana;
create user grafana password 'grafana';
create database grafana_moni;
Install grafana for Macbook
curl -O https://dl.grafana.com/oss/release/grafana-7.3.6.darwin-amd64.tar.gz
tar -zxvf grafana-7.3.6.darwin-amd64.tar.gz
Modify the default database to PostgreSQL
cd ~/grafana_work/grafana-7.3.6/conf/
cp defaults.ini custom.ini
## modify the parameter of chapter `[database]`
type = postgres
host = 127.0.0.1:5432
name = grafana
user = grafana
password = grafana
Start Grafana
cd /Users/fei/work/grafana_work/grafana-7.3.6/bin
➜ ./grafana-server
The flowchart of parse start sequence
flow.png
Display info
fei@feideMacBook-Pro: /Users/fei/work/grafana_work/grafana-7.3.6/bin
➜ ./grafana-server
INFO[12-19|22:23:45] Starting Grafana logger=server version=7.3.6 commit=ea06633c34 branch=HEAD compiled=2020-12-14T17:19:44+0800
INFO[12-19|22:23:45] Config loaded from logger=settings file=/Users/fei/work/grafana_work/grafana-7.3.6/conf/defaults.ini
INFO[12-19|23:08:23] Config loaded from logger=settings file=/Users/fei/work/grafana_work/grafana-7.3.6/conf/custom.ini
INFO[12-19|22:23:45] Path Home logger=settings path=/Users/fei/work/grafana_work/grafana-7.3.6
INFO[12-19|22:23:45] Path Data logger=settings path=/Users/fei/work/grafana_work/grafana-7.3.6/data
INFO[12-19|22:23:45] Path Logs logger=settings path=/Users/fei/work/grafana_work/grafana-7.3.6/data/log
INFO[12-19|22:23:45] Path Plugins logger=settings path=/Users/fei/work/grafana_work/grafana-7.3.6/data/plugins
INFO[12-19|22:23:45] Path Provisioning logger=settings path=/Users/fei/work/grafana_work/grafana-7.3.6/conf/provisioning
INFO[12-19|22:23:45] App mode production logger=settings
INFO[12-19|22:23:45] Connecting to DB logger=sqlstore dbtype=sqlite3
INFO[12-19|22:23:45] Creating SQLite database file logger=sqlstore path=/Users/fei/work/grafana_work/grafana-7.3.6/data/grafana.db
INFO[12-19|22:23:45] Starting DB migrations logger=migrator
INFO[12-19|22:23:45] Executing migration logger=migrator id="create migration_log table"
INFO[12-19|22:23:45] Executing migration logger=migrator id="create user table"
INFO[12-19|22:23:45] Executing migration logger=migrator id="add unique index user.login"
INFO[12-19|22:23:45] Executing migration logger=migrator id="add unique index user.email"
INFO[12-19|22:23:45] Executing migration logger=migrator id="drop index UQE_user_login - v1"
INFO[12-19|22:23:45] Executing migration logger=migrator id="drop index UQE_user_email - v1"
INFO[12-19|22:23:45] Executing migration logger=migrator id="Rename table user to user_v1 - v1"
INFO[12-19|22:23:45] Executing migration logger=migrator id="create user table v2"
INFO[12-19|22:23:45] Executing migration logger=migrator id="create index UQE_user_login - v2"
INFO[12-19|22:23:45] Executing migration logger=migrator id="create index UQE_user_email - v2"
INFO[12-19|22:23:45] Executing migration logger=migrator id="copy data_source v1 to v2"
INFO[12-19|22:23:45] Executing migration logger=migrator id="Drop old table user_v1"
INFO[12-19|22:23:45] Executing migration logger=migrator id="Add column help_flags1 to user table"
INFO[12-19|22:23:45] Executing migration logger=migrator id="Update user table charset"
INFO[12-19|22:23:45] Executing migration logger=migrator id="Add last_seen_at column to user"
INFO[12-19|22:23:45] Executing migration logger=migrator id="Add missing user data"
INFO[12-19|22:23:45] Executing migration logger=migrator id="Add is_disabled column to user"
INFO[12-19|22:23:45] Executing migration logger=migrator id="Add index user.login/user.email"
INFO[12-19|22:23:45] Executing migration logger=migrator id="create temp user table v1-7"
INFO[12-19|22:23:45] Executing migration logger=migrator id="create index IDX_temp_user_email - v1-7"
INFO[12-19|22:23:45] Executing migration logger=migrator id="create index IDX_temp_user_org_id - v1-7"
INFO[12-19|22:23:45] Executing migration logger=migrator id="create index IDX_temp_user_code - v1-7"
INFO[12-19|22:23:45] Executing migration logger=migrator id="create index IDX_temp_user_status - v1-7"
INFO[12-19|22:23:45] Executing migration logger=migrator id="Update temp_user table charset"
INFO[12-19|22:23:45] Executing migration logger=migrator id="drop index IDX_temp_user_email - v1"
INFO[12-19|22:23:45] Executing migration logger=migrator id="drop index IDX_temp_user_org_id - v1"
INFO[12-19|22:23:45] Executing migration logger=migrator id="drop index IDX_temp_user_code - v1"
INFO[12-19|22:23:45] Executing migration logger=migrator id="drop index IDX_temp_user_status - v1"
INFO[12-19|22:23:45] Executing migration logger=migrator id="Rename table temp_user to temp_user_tmp_qwerty - v1"
INFO[12-19|22:23:45] Executing migration logger=migrator id="create temp_user v2"
INFO[12-19|22:23:45] Executing migration logger=migrator id="create index IDX_temp_user_email - v2"
INFO[12-19|22:23:45] Executing migration logger=migrator id="create index IDX_temp_user_org_id - v2"
INFO[12-19|22:23:45] Executing migration logger=migrator id="create index IDX_temp_user_code - v2"
INFO[12-19|22:23:45] Executing migration logger=migrator id="create index IDX_temp_user_status - v2"
INFO[12-19|22:23:45] Executing migration logger=migrator id="copy temp_user v1 to v2"
INFO[12-19|22:23:45] Executing migration logger=migrator id="drop temp_user_tmp_qwerty"
INFO[12-19|22:23:45] Executing migration logger=migrator id="Set created for temp users that will otherwise prematurely expire"
INFO[12-19|22:23:45] Executing migration logger=migrator id="create star table"
INFO[12-19|22:23:45] Executing migration logger=migrator id="add unique index star.user_id_dashboard_id"
INFO[12-19|22:23:45] Executing migration logger=migrator id="create org table v1"
INFO[12-19|22:23:45] Executing migration logger=migrator id="create index UQE_org_name - v1"
INFO[12-19|22:23:45] Executing migration logger=migrator id="create org_user table v1"
INFO[12-19|22:23:45] Executing migration logger=migrator id="create index IDX_org_user_org_id - v1"
INFO[12-19|22:23:45] Executing migration logger=migrator id="create index UQE_org_user_org_id_user_id - v1"
INFO[12-19|22:23:45] Executing migration logger=migrator id="Update org table charset"
INFO[12-19|22:23:45] Executing migration logger=migrator id="Update org_user table charset"
INFO[12-19|22:23:45] Executing migration logger=migrator id="Migrate all Read Only Viewers to Viewers"
INFO[12-19|22:23:45] Executing migration logger=migrator id="create dashboard table"
INFO[12-19|22:23:45] Executing migration logger=migrator id="add index dashboard.account_id"
INFO[12-19|22:23:45] Executing migration logger=migrator id="add unique index dashboard_account_id_slug"
INFO[12-19|22:23:45] Executing migration logger=migrator id="create dashboard_tag table"
INFO[12-19|22:23:45] Executing migration logger=migrator id="add unique index dashboard_tag.dasboard_id_term"
INFO[12-19|22:23:45] Executing migration logger=migrator id="drop index UQE_dashboard_tag_dashboard_id_term - v1"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Rename table dashboard to dashboard_v1 - v1"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create dashboard v2"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create index IDX_dashboard_org_id - v2"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create index UQE_dashboard_org_id_slug - v2"
INFO[12-19|22:23:46] Executing migration logger=migrator id="copy dashboard v1 to v2"
INFO[12-19|22:23:46] Executing migration logger=migrator id="drop table dashboard_v1"
INFO[12-19|22:23:46] Executing migration logger=migrator id="alter dashboard.data to mediumtext v1"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add column updated_by in dashboard - v2"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add column created_by in dashboard - v2"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add column gnetId in dashboard"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add index for gnetId in dashboard"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add column plugin_id in dashboard"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add index for plugin_id in dashboard"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add index for dashboard_id in dashboard_tag"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Update dashboard table charset"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Update dashboard_tag table charset"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add column folder_id in dashboard"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add column isFolder in dashboard"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add column has_acl in dashboard"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add column uid in dashboard"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Update uid column values in dashboard"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add unique index dashboard_org_id_uid"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Remove unique index org_id_slug"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Update dashboard title length"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add unique index for dashboard_org_id_title_folder_id"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create dashboard_provisioning"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Rename table dashboard_provisioning to dashboard_provisioning_tmp_qwerty - v1"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create dashboard_provisioning v2"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create index IDX_dashboard_provisioning_dashboard_id - v2"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create index IDX_dashboard_provisioning_dashboard_id_name - v2"
INFO[12-19|22:23:46] Executing migration logger=migrator id="copy dashboard_provisioning v1 to v2"
INFO[12-19|22:23:46] Executing migration logger=migrator id="drop dashboard_provisioning_tmp_qwerty"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add check_sum column"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add index for dashboard_title"
INFO[12-19|22:23:46] Executing migration logger=migrator id="delete tags for deleted dashboards"
INFO[12-19|22:23:46] Executing migration logger=migrator id="delete stars for deleted dashboards"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create data_source table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add index data_source.account_id"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add unique index data_source.account_id_name"
INFO[12-19|22:23:46] Executing migration logger=migrator id="drop index IDX_data_source_account_id - v1"
INFO[12-19|22:23:46] Executing migration logger=migrator id="drop index UQE_data_source_account_id_name - v1"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Rename table data_source to data_source_v1 - v1"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create data_source table v2"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create index IDX_data_source_org_id - v2"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create index UQE_data_source_org_id_name - v2"
INFO[12-19|22:23:46] Executing migration logger=migrator id="copy data_source v1 to v2"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Drop old table data_source_v1 #2"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add column with_credentials"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add secure json data column"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Update data_source table charset"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Update initial version to 1"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add read_only data column"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Migrate logging ds to loki ds"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Update json_data with nulls"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add uid column"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Update uid value"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add unique index datasource_org_id_uid"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create api_key table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add index api_key.account_id"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add index api_key.key"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add index api_key.account_id_name"
INFO[12-19|22:23:46] Executing migration logger=migrator id="drop index IDX_api_key_account_id - v1"
INFO[12-19|22:23:46] Executing migration logger=migrator id="drop index UQE_api_key_key - v1"
INFO[12-19|22:23:46] Executing migration logger=migrator id="drop index UQE_api_key_account_id_name - v1"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Rename table api_key to api_key_v1 - v1"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create api_key table v2"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create index IDX_api_key_org_id - v2"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create index UQE_api_key_key - v2"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create index UQE_api_key_org_id_name - v2"
INFO[12-19|22:23:46] Executing migration logger=migrator id="copy api_key v1 to v2"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Drop old table api_key_v1"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Update api_key table charset"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add expires to api_key table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create dashboard_snapshot table v4"
INFO[12-19|22:23:46] Executing migration logger=migrator id="drop table dashboard_snapshot_v4 #1"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create dashboard_snapshot table v5 #2"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create index UQE_dashboard_snapshot_key - v5"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create index UQE_dashboard_snapshot_delete_key - v5"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create index IDX_dashboard_snapshot_user_id - v5"
INFO[12-19|22:23:46] Executing migration logger=migrator id="alter dashboard_snapshot to mediumtext v2"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Update dashboard_snapshot table charset"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add column external_delete_url to dashboard_snapshots table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add encrypted dashboard json column"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Change dashboard_encrypted column to MEDIUMBLOB"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create quota table v1"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create index UQE_quota_org_id_user_id_target - v1"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Update quota table charset"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create plugin_setting table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create index UQE_plugin_setting_org_id_plugin_id - v1"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add column plugin_version to plugin_settings"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Update plugin_setting table charset"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create session table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Drop old table playlist table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Drop old table playlist_item table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create playlist table v2"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create playlist item table v2"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Update playlist table charset"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Update playlist_item table charset"
INFO[12-19|22:23:46] Executing migration logger=migrator id="drop preferences table v2"
INFO[12-19|22:23:46] Executing migration logger=migrator id="drop preferences table v3"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create preferences table v3"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Update preferences table charset"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add column team_id in preferences"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Update team_id column values in preferences"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create alert table v1"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add index alert org_id & id "
INFO[12-19|22:23:46] Executing migration logger=migrator id="add index alert state"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add index alert dashboard_id"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Create alert_rule_tag table v1"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add unique index alert_rule_tag.alert_id_tag_id"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create alert_notification table v1"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add column is_default"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add column frequency"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add column send_reminder"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add column disable_resolve_message"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add index alert_notification org_id & name"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Update alert table charset"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Update alert_notification table charset"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create notification_journal table v1"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add index notification_journal org_id & alert_id & notifier_id"
INFO[12-19|22:23:46] Executing migration logger=migrator id="drop alert_notification_journal"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create alert_notification_state table v1"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add index alert_notification_state org_id & alert_id & notifier_id"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add for to alert table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add column uid in alert_notification"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Update uid column values in alert_notification"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add unique index alert_notification_org_id_uid"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Remove unique index org_id_name"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add column secure_settings in alert_notification"
INFO[12-19|22:23:46] Executing migration logger=migrator id="alter alert.settings to mediumtext"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add non-unique index alert_notification_state_alert_id"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add non-unique index alert_rule_tag_alert_id"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Drop old annotation table v4"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create annotation table v5"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add index annotation 0 v3"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add index annotation 1 v3"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add index annotation 2 v3"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add index annotation 3 v3"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add index annotation 4 v3"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Update annotation table charset"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add column region_id to annotation table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Drop category_id index"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add column tags to annotation table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Create annotation_tag table v2"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add unique index annotation_tag.annotation_id_tag_id"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Update alert annotations and set TEXT to empty"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add created time to annotation table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add updated time to annotation table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add index for created in annotation table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add index for updated in annotation table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Convert existing annotations from seconds to milliseconds"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add epoch_end column"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add index for epoch_end"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Make epoch_end the same as epoch"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Move region to single row"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Remove index org_id_epoch from annotation table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Remove index org_id_dashboard_id_panel_id_epoch from annotation table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add index for org_id_dashboard_id_epoch_end_epoch on annotation table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add index for org_id_epoch_end_epoch on annotation table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Remove index org_id_epoch_epoch_end from annotation table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add index for alert_id on annotation table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create test_data table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create dashboard_version table v1"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add index dashboard_version.dashboard_id"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add unique index dashboard_version.dashboard_id and dashboard_version.version"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Set dashboard version to 1 where 0"
INFO[12-19|22:23:46] Executing migration logger=migrator id="save existing dashboard data in dashboard_version table v1"
INFO[12-19|22:23:46] Executing migration logger=migrator id="alter dashboard_version.data to mediumtext v1"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create team table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add index team.org_id"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add unique index team_org_id_name"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create team member table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add index team_member.org_id"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add unique index team_member_org_id_team_id_user_id"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add index team_member.team_id"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add column email to team table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add column external to team_member table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add column permission to team_member table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create dashboard acl table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add index dashboard_acl_dashboard_id"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add unique index dashboard_acl_dashboard_id_user_id"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add unique index dashboard_acl_dashboard_id_team_id"
INFO[12-19|22:23:46] Executing migration logger=migrator id="save default acl rules in dashboard_acl table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="delete acl rules for deleted dashboards and folders"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create tag table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add index tag.key_value"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create login attempt table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add index login_attempt.username"
INFO[12-19|22:23:46] Executing migration logger=migrator id="drop index IDX_login_attempt_username - v1"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Rename table login_attempt to login_attempt_tmp_qwerty - v1"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create login_attempt v2"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create index IDX_login_attempt_username - v2"
INFO[12-19|22:23:46] Executing migration logger=migrator id="copy login_attempt v1 to v2"
INFO[12-19|22:23:46] Executing migration logger=migrator id="drop login_attempt_tmp_qwerty"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create user auth table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create index IDX_user_auth_auth_module_auth_id - v1"
INFO[12-19|22:23:46] Executing migration logger=migrator id="alter user_auth.auth_id to length 190"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add OAuth access token to user_auth"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add OAuth refresh token to user_auth"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add OAuth token type to user_auth"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add OAuth expiry to user_auth"
INFO[12-19|22:23:46] Executing migration logger=migrator id="Add index to user_id column in user_auth"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create server_lock table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add index server_lock.operation_uid"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create user auth token table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add unique index user_auth_token.auth_token"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add unique index user_auth_token.prev_auth_token"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add index user_auth_token.user_id"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create cache_data table"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add unique index cache_data.cache_key"
INFO[12-19|22:23:46] Executing migration logger=migrator id="create short_url table v1"
INFO[12-19|22:23:46] Executing migration logger=migrator id="add index short_url.org_id-uid"
INFO[12-19|22:23:46] Created default admin logger=sqlstore user=admin
INFO[12-19|22:23:46] Starting plugin search logger=plugins
INFO[12-19|22:23:46] Registering plugin logger=plugins id=input
INFO[12-19|22:23:46] External plugins directory created logger=plugins directory=/Users/fei/work/grafana_work/grafana-7.3.6/data/plugins
INFO[12-19|22:23:46] HTTP Server Listen logger=http.server address=[::]:3000 protocol=http subUrl= socket=
WEB login grafana
http://localhost:3000/
user: admin
pass: admin
Configure grafana
Add data sources for PostgreSQL
Configuration -> Data Sources
20201219_grf.png
Grafana Tutorials
Add User
20201220_grf_adduser_01.png
Add Teams
20201220_grf_02.png
Invite user
20201220_grf_03.png
Dashboards
Manage Dashboards
20201221_d.png
Dashboards Store
Demo
Prepare TimescaleDB for DASHBOARD [ PostgreSQL Infrastructure ]
PGDATABASE=collectd
PGUSER=monitoring
PGPASSWORD=password123
## stall collectd_timescaledb_bootstrap.sql into Database [ PostgreSQL ]
psql -d collectd -f collectd_timescaledb_bootstrap.sql
collectd_timescaledb_bootstrap.sql
Add data sources for PostgreSQL [ TimescaleDB ]
20201221_demo.png
Select Dashboards
the_dashboards_of_PostgreSQL Infrastructure
Import json of Dashboards [ postgresql-infrastructure_rev2.json ]
20201221_d.png
Select Database
20201221_demo02.png
