Grafana Web UI: Problem Loading Page

pingpong · February 6, 2018, 7:49am

Hello

My grafana was fine about 2 weeks ago, everything can be loaded. Can edit and create and do most of the normal things that grafana are able to do. I could also visualise my Zabbix server data.

However, the web ui was not able to be loaded when I try to access it today. It say Connection was reset.

Soo the first thing I did was to check on the port 3000, did anyone close it. It is open on both UDP n TCP.

Soo I check on the logs and here are the logs result

“cat /var/log/grafana/grafana.log”

t=2018-02-01T16:03:31+0800 lvl=crit msg="Failed to parse /etc/grafana/grafana.ini, open /etc/grafana/grafana.ini: no such file or directory%!(EXTRA []interface {}=[])"
t=2018-02-01T16:03:31+0800 lvl=crit msg="Failed to parse /etc/grafana/grafana.ini, open /etc/grafana/grafana.ini: no such file or directory%!(EXTRA []interface {}=[])"
t=2018-02-01T16:03:31+0800 lvl=crit msg="Failed to parse /etc/grafana/grafana.ini, open /etc/grafana/grafana.ini: no such file or directory%!(EXTRA []interface {}=[])"
t=2018-02-01T16:03:31+0800 lvl=crit msg="Failed to parse /etc/grafana/grafana.ini, open /etc/grafana/grafana.ini: no such file or directory%!(EXTRA []interface {}=[])"
t=2018-02-01T16:35:49+0800 lvl=crit msg="Failed to parse /etc/grafana/grafana.ini, open /etc/grafana/grafana.ini: no such file or directory%!(EXTRA []interface {}=[])"
t=2018-02-01T16:35:49+0800 lvl=crit msg="Failed to parse /etc/grafana/grafana.ini, open /etc/grafana/grafana.ini: no such file or directory%!(EXTRA []interface {}=[])"
t=2018-02-01T16:35:49+0800 lvl=crit msg="Failed to parse /etc/grafana/grafana.ini, open /etc/grafana/grafana.ini: no such file or directory%!(EXTRA []interface {}=[])"
t=2018-02-01T16:35:49+0800 lvl=crit msg="Failed to parse /etc/grafana/grafana.ini, open /etc/grafana/grafana.ini: no such file or directory%!(EXTRA []interface {}=[])"
t=2018-02-01T16:35:50+0800 lvl=crit msg="Failed to parse /etc/grafana/grafana.ini, open /etc/grafana/grafana.ini: no such file or directory%!(EXTRA []interface {}=[])"
t=2018-02-06T09:09:03+0800 lvl=crit msg="Failed to parse /etc/grafana/grafana.ini, open /etc/grafana/grafana.ini: no such file or directory%!(EXTRA []interface {}=[])"
t=2018-02-06T09:09:03+0800 lvl=crit msg="Failed to parse /etc/grafana/grafana.ini, open /etc/grafana/grafana.ini: no such file or directory%!(EXTRA []interface {}=[])"
t=2018-02-06T09:09:03+0800 lvl=crit msg="Failed to parse /etc/grafana/grafana.ini, open /etc/grafana/grafana.ini: no such file or directory%!(EXTRA []interface {}=[])"
t=2018-02-06T09:09:03+0800 lvl=crit msg="Failed to parse /etc/grafana/grafana.ini, open /etc/grafana/grafana.ini: no such file or directory%!(EXTRA []interface {}=[])"
t=2018-02-06T09:09:04+0800 lvl=crit msg="Failed to parse /etc/grafana/grafana.ini, open /etc/grafana/grafana.ini: no such file or directory%!(EXTRA []interface {}=[])"
t=2018-02-06T09:09:18+0800 lvl=crit msg="Failed to parse /etc/grafana/grafana.ini, open /etc/grafana/grafana.ini: no such file or directory%!(EXTRA []interface {}=[])"
t=2018-02-06T09:09:18+0800 lvl=crit msg="Failed to parse /etc/grafana/grafana.ini, open /etc/grafana/grafana.ini: no such file or directory%!(EXTRA []interface {}=[])"
t=2018-02-06T09:09:18+0800 lvl=crit msg="Failed to parse /etc/grafana/grafana.ini, open /etc/grafana/grafana.ini: no such file or directory%!(EXTRA []interface {}=[])"
t=2018-02-06T09:09:18+0800 lvl=crit msg="Failed to parse /etc/grafana/grafana.ini, open /etc/grafana/grafana.ini: no such file or directory%!(EXTRA []interface {}=[])"
t=2018-02-06T09:09:19+0800 lvl=crit msg=“Failed to parse /etc/grafana/grafana.ini, open /etc/grafana/grafana.ini: no such file or directory%!(EXTRA []interface {}=[])”

I would like to ask for your guys assistance on what might cause this issue. Is it the server issue? All I did was change the interface from black theme to white theme and update the grafana to the latest version.

Thanks

torkel · February 6, 2018, 8:38am

somehow your grafana ini config file got deleted / removed. AS you can see from the error logs it says it is no longer there.

copy this file to your /etc/grafana/grafana.ini and make you config changes again

github.com

grafana/grafana/blob/v4.6.3/conf/sample.ini

##################### Grafana Configuration Example #####################
#
# Everything has defaults so you only need to uncomment things you want to
# change

# possible values : production, development
; app_mode = production

# instance name, defaults to HOSTNAME environment variable value or hostname if HOSTNAME var is empty
; instance_name = ${HOSTNAME}

#################################### Paths ####################################
[paths]
# Path to where grafana can store temp files, sessions, and the sqlite3 db (if that is used)
#
;data = /var/lib/grafana
#
# Directory where grafana can store logs
#
;logs = /var/log/grafana

This file has been truncated. show original

pingpong · February 6, 2018, 8:55am

Hello

Thanks a lot dude!!!

It works.

Just wondering what might cause the file to be removed tho?
Any ideas?

biswalswagat18 · April 11, 2020, 1:19pm

After installing grafana, not able to open grafan in browser , need help urgently
Logs
[root@Testing gitlab]# cat /var/log/grafana/grafana.log
t=2020-04-11T07:36:41+0000 lvl=info msg=“Starting Grafana” logger=server version=6.7.2 commit=423a25fc32 branch=HEAD compiled=2020-04-02T08:02:56+0000
t=2020-04-11T07:36:41+0000 lvl=info msg=“Config loaded from” logger=settings file=/usr/share/grafana/conf/defaults.ini
t=2020-04-11T07:36:41+0000 lvl=info msg=“Config loaded from” logger=settings file=/etc/grafana/grafana.ini
t=2020-04-11T07:36:41+0000 lvl=info msg=“Config overridden from command line” logger=settings arg=“default.paths.data=/var/lib/grafana”
t=2020-04-11T07:36:41+0000 lvl=info msg=“Config overridden from command line” logger=settings arg=“default.paths.logs=/var/log/grafana”
t=2020-04-11T07:36:41+0000 lvl=info msg=“Config overridden from command line” logger=settings arg=“default.paths.plugins=/var/lib/grafana/plugins”
t=2020-04-11T07:36:41+0000 lvl=info msg=“Config overridden from command line” logger=settings arg=“default.paths.provisioning=/etc/grafana/provisioning”
t=2020-04-11T07:36:41+0000 lvl=info msg=“Path Home” logger=settings path=/usr/share/grafana
t=2020-04-11T07:36:41+0000 lvl=info msg=“Path Data” logger=settings path=/var/lib/grafana
t=2020-04-11T07:36:41+0000 lvl=info msg=“Path Logs” logger=settings path=/var/log/grafana
t=2020-04-11T07:36:41+0000 lvl=info msg=“Path Plugins” logger=settings path=/var/lib/grafana/plugins
t=2020-04-11T07:36:41+0000 lvl=info msg=“Path Provisioning” logger=settings path=/etc/grafana/provisioning
t=2020-04-11T07:36:41+0000 lvl=info msg=“App mode production” logger=settings
t=2020-04-11T07:36:41+0000 lvl=info msg=“Writing PID file” logger=server path=/var/run/grafana/grafana-server.pid pid=2398
t=2020-04-11T07:36:41+0000 lvl=info msg=“Initializing SqlStore” logger=server
t=2020-04-11T07:36:41+0000 lvl=info msg=“Connecting to DB” logger=sqlstore dbtype=sqlite3
t=2020-04-11T07:36:41+0000 lvl=info msg=“Starting DB migration” logger=migrator
t=2020-04-11T07:36:41+0000 lvl=info msg=“Executing migration” logger=migrator id=“create migration_log table”
t=2020-04-11T07:36:41+0000 lvl=info msg=“Executing migration” logger=migrator id=“create user table”
t=2020-04-11T07:36:41+0000 lvl=info msg=“Executing migration” logger=migrator id=“add unique index user.login”
t=2020-04-11T07:36:41+0000 lvl=info msg=“Executing migration” logger=migrator id=“add unique index user.email”
t=2020-04-11T07:36:41+0000 lvl=info msg=“Executing migration” logger=migrator id=“drop index UQE_user_login - v1”
t=2020-04-11T07:36:41+0000 lvl=info msg=“Executing migration” logger=migrator id=“drop index UQE_user_email - v1”
t=2020-04-11T07:36:41+0000 lvl=info msg=“Executing migration” logger=migrator id=“Rename table user to user_v1 - v1”
t=2020-04-11T07:36:41+0000 lvl=info msg=“Executing migration” logger=migrator id=“create user table v2”
t=2020-04-11T07:36:41+0000 lvl=info msg=“Executing migration” logger=migrator id=“create index UQE_user_login - v2”
t=2020-04-11T07:36:41+0000 lvl=info msg=“Executing migration” logger=migrator id=“create index UQE_user_email - v2”
t=2020-04-11T07:36:41+0000 lvl=info msg=“Executing migration” logger=migrator id=“copy data_source v1 to v2”
t=2020-04-11T07:36:41+0000 lvl=info msg=“Executing migration” logger=migrator id=“Drop old table user_v1”
t=2020-04-11T07:36:41+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add column help_flags1 to user table”
t=2020-04-11T07:36:41+0000 lvl=info msg=“Executing migration” logger=migrator id=“Update user table charset”
t=2020-04-11T07:36:41+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add last_seen_at column to user”
t=2020-04-11T07:36:41+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add missing user data”
t=2020-04-11T07:36:41+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add is_disabled column to user”
t=2020-04-11T07:36:41+0000 lvl=info msg=“Executing migration” logger=migrator id=“create temp user table v1-7”
t=2020-04-11T07:36:42+0000 lvl=info msg=“Executing migration” logger=migrator id=“create index IDX_temp_user_email - v1-7”
t=2020-04-11T07:36:42+0000 lvl=info msg=“Executing migration” logger=migrator id=“create index IDX_temp_user_org_id - v1-7”
t=2020-04-11T07:36:42+0000 lvl=info msg=“Executing migration” logger=migrator id=“create index IDX_temp_user_code - v1-7”
t=2020-04-11T07:36:42+0000 lvl=info msg=“Executing migration” logger=migrator id=“create index IDX_temp_user_status - v1-7”
t=2020-04-11T07:36:42+0000 lvl=info msg=“Executing migration” logger=migrator id=“Update temp_user table charset”
t=2020-04-11T07:36:42+0000 lvl=info msg=“Executing migration” logger=migrator id=“create star table”
t=2020-04-11T07:36:42+0000 lvl=info msg=“Executing migration” logger=migrator id=“add unique index star.user_id_dashboard_id”
t=2020-04-11T07:36:42+0000 lvl=info msg=“Executing migration” logger=migrator id=“create org table v1”
t=2020-04-11T07:36:42+0000 lvl=info msg=“Executing migration” logger=migrator id=“create index UQE_org_name - v1”
t=2020-04-11T07:36:42+0000 lvl=info msg=“Executing migration” logger=migrator id=“create org_user table v1”
t=2020-04-11T07:36:42+0000 lvl=info msg=“Executing migration” logger=migrator id=“create index IDX_org_user_org_id - v1”
t=2020-04-11T07:36:42+0000 lvl=info msg=“Executing migration” logger=migrator id=“create index UQE_org_user_org_id_user_id - v1”
t=2020-04-11T07:36:42+0000 lvl=info msg=“Executing migration” logger=migrator id=“Update org table charset”
t=2020-04-11T07:36:42+0000 lvl=info msg=“Executing migration” logger=migrator id=“Update org_user table charset”
t=2020-04-11T07:36:42+0000 lvl=info msg=“Executing migration” logger=migrator id=“Migrate all Read Only Viewers to Viewers”
t=2020-04-11T07:36:42+0000 lvl=info msg=“Executing migration” logger=migrator id=“create dashboard table”
t=2020-04-11T07:36:42+0000 lvl=info msg=“Executing migration” logger=migrator id=“add index dashboard.account_id”
t=2020-04-11T07:36:42+0000 lvl=info msg=“Executing migration” logger=migrator id=“add unique index dashboard_account_id_slug”
t=2020-04-11T07:36:42+0000 lvl=info msg=“Executing migration” logger=migrator id=“create dashboard_tag table”
t=2020-04-11T07:36:42+0000 lvl=info msg=“Executing migration” logger=migrator id=“add unique index dashboard_tag.dasboard_id_term”
t=2020-04-11T07:36:42+0000 lvl=info msg=“Executing migration” logger=migrator id=“drop index UQE_dashboard_tag_dashboard_id_term - v1”
t=2020-04-11T07:36:42+0000 lvl=info msg=“Executing migration” logger=migrator id=“Rename table dashboard to dashboard_v1 - v1”
t=2020-04-11T07:36:42+0000 lvl=info msg=“Executing migration” logger=migrator id=“create dashboard v2”
t=2020-04-11T07:36:42+0000 lvl=info msg=“Executing migration” logger=migrator id=“create index IDX_dashboard_org_id - v2”
t=2020-04-11T07:36:42+0000 lvl=info msg=“Executing migration” logger=migrator id=“create index UQE_dashboard_org_id_slug - v2”
t=2020-04-11T07:36:42+0000 lvl=info msg=“Executing migration” logger=migrator id=“copy dashboard v1 to v2”
t=2020-04-11T07:36:42+0000 lvl=info msg=“Executing migration” logger=migrator id=“drop table dashboard_v1”
t=2020-04-11T07:36:43+0000 lvl=info msg=“Executing migration” logger=migrator id=“alter dashboard.data to mediumtext v1”
t=2020-04-11T07:36:43+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add column updated_by in dashboard - v2”
t=2020-04-11T07:36:43+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add column created_by in dashboard - v2”
t=2020-04-11T07:36:43+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add column gnetId in dashboard”
t=2020-04-11T07:36:43+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add index for gnetId in dashboard”
t=2020-04-11T07:36:43+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add column plugin_id in dashboard”
t=2020-04-11T07:36:43+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add index for plugin_id in dashboard”
t=2020-04-11T07:36:43+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add index for dashboard_id in dashboard_tag”
t=2020-04-11T07:36:43+0000 lvl=info msg=“Executing migration” logger=migrator id=“Update dashboard table charset”
t=2020-04-11T07:36:43+0000 lvl=info msg=“Executing migration” logger=migrator id=“Update dashboard_tag table charset”
t=2020-04-11T07:36:43+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add column folder_id in dashboard”
t=2020-04-11T07:36:43+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add column isFolder in dashboard”
t=2020-04-11T07:36:43+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add column has_acl in dashboard”
t=2020-04-11T07:36:43+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add column uid in dashboard”
t=2020-04-11T07:36:43+0000 lvl=info msg=“Executing migration” logger=migrator id=“Update uid column values in dashboard”
t=2020-04-11T07:36:43+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add unique index dashboard_org_id_uid”
t=2020-04-11T07:36:43+0000 lvl=info msg=“Executing migration” logger=migrator id=“Remove unique index org_id_slug”
t=2020-04-11T07:36:43+0000 lvl=info msg=“Executing migration” logger=migrator id=“Update dashboard title length”
t=2020-04-11T07:36:43+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add unique index for dashboard_org_id_title_folder_id”
t=2020-04-11T07:36:43+0000 lvl=info msg=“Executing migration” logger=migrator id=“create dashboard_provisioning”
t=2020-04-11T07:36:43+0000 lvl=info msg=“Executing migration” logger=migrator id=“Rename table dashboard_provisioning to dashboard_provisioning_tmp_qwerty - v1”
t=2020-04-11T07:36:43+0000 lvl=info msg=“Executing migration” logger=migrator id=“create dashboard_provisioning v2”
t=2020-04-11T07:36:43+0000 lvl=info msg=“Executing migration” logger=migrator id=“create index IDX_dashboard_provisioning_dashboard_id - v2”
t=2020-04-11T07:36:43+0000 lvl=info msg=“Executing migration” logger=migrator id=“create index IDX_dashboard_provisioning_dashboard_id_name - v2”
t=2020-04-11T07:36:43+0000 lvl=info msg=“Executing migration” logger=migrator id=“copy dashboard_provisioning v1 to v2”
t=2020-04-11T07:36:43+0000 lvl=info msg=“Executing migration” logger=migrator id=“drop dashboard_provisioning_tmp_qwerty”
t=2020-04-11T07:36:44+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add check_sum column”
t=2020-04-11T07:36:44+0000 lvl=info msg=“Executing migration” logger=migrator id=“create data_source table”
t=2020-04-11T07:36:44+0000 lvl=info msg=“Executing migration” logger=migrator id=“add index data_source.account_id”
t=2020-04-11T07:36:44+0000 lvl=info msg=“Executing migration” logger=migrator id=“add unique index data_source.account_id_name”
t=2020-04-11T07:36:44+0000 lvl=info msg=“Executing migration” logger=migrator id=“drop index IDX_data_source_account_id - v1”
t=2020-04-11T07:36:44+0000 lvl=info msg=“Executing migration” logger=migrator id=“drop index UQE_data_source_account_id_name - v1”
t=2020-04-11T07:36:44+0000 lvl=info msg=“Executing migration” logger=migrator id=“Rename table data_source to data_source_v1 - v1”
t=2020-04-11T07:36:44+0000 lvl=info msg=“Executing migration” logger=migrator id=“create data_source table v2”
t=2020-04-11T07:36:44+0000 lvl=info msg=“Executing migration” logger=migrator id=“create index IDX_data_source_org_id - v2”
t=2020-04-11T07:36:44+0000 lvl=info msg=“Executing migration” logger=migrator id=“create index UQE_data_source_org_id_name - v2”
t=2020-04-11T07:36:44+0000 lvl=info msg=“Executing migration” logger=migrator id=“copy data_source v1 to v2”
t=2020-04-11T07:36:44+0000 lvl=info msg=“Executing migration” logger=migrator id=“Drop old table data_source_v1 #2”
t=2020-04-11T07:36:44+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add column with_credentials”
t=2020-04-11T07:36:44+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add secure json data column”
t=2020-04-11T07:36:44+0000 lvl=info msg=“Executing migration” logger=migrator id=“Update data_source table charset”
t=2020-04-11T07:36:44+0000 lvl=info msg=“Executing migration” logger=migrator id=“Update initial version to 1”
t=2020-04-11T07:36:44+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add read_only data column”
t=2020-04-11T07:36:44+0000 lvl=info msg=“Executing migration” logger=migrator id=“Migrate logging ds to loki ds”
t=2020-04-11T07:36:44+0000 lvl=info msg=“Executing migration” logger=migrator id=“Update json_data with nulls”
t=2020-04-11T07:36:44+0000 lvl=info msg=“Executing migration” logger=migrator id=“create api_key table”
t=2020-04-11T07:36:44+0000 lvl=info msg=“Executing migration” logger=migrator id=“add index api_key.account_id”
t=2020-04-11T07:36:44+0000 lvl=info msg=“Executing migration” logger=migrator id=“add index api_key.key”
t=2020-04-11T07:36:44+0000 lvl=info msg=“Executing migration” logger=migrator id=“add index api_key.account_id_name”
t=2020-04-11T07:36:44+0000 lvl=info msg=“Executing migration” logger=migrator id=“drop index IDX_api_key_account_id - v1”
t=2020-04-11T07:36:44+0000 lvl=info msg=“Executing migration” logger=migrator id=“drop index UQE_api_key_key - v1”
t=2020-04-11T07:36:44+0000 lvl=info msg=“Executing migration” logger=migrator id=“drop index UQE_api_key_account_id_name - v1”
t=2020-04-11T07:36:44+0000 lvl=info msg=“Executing migration” logger=migrator id=“Rename table api_key to api_key_v1 - v1”
t=2020-04-11T07:36:45+0000 lvl=info msg=“Executing migration” logger=migrator id=“create api_key table v2”
t=2020-04-11T07:36:45+0000 lvl=info msg=“Executing migration” logger=migrator id=“create index IDX_api_key_org_id - v2”
t=2020-04-11T07:36:45+0000 lvl=info msg=“Executing migration” logger=migrator id=“create index UQE_api_key_key - v2”
t=2020-04-11T07:36:45+0000 lvl=info msg=“Executing migration” logger=migrator id=“create index UQE_api_key_org_id_name - v2”
t=2020-04-11T07:36:45+0000 lvl=info msg=“Executing migration” logger=migrator id=“copy api_key v1 to v2”
t=2020-04-11T07:36:45+0000 lvl=info msg=“Executing migration” logger=migrator id=“Drop old table api_key_v1”
t=2020-04-11T07:36:45+0000 lvl=info msg=“Executing migration” logger=migrator id=“Update api_key table charset”
t=2020-04-11T07:36:45+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add expires to api_key table”
t=2020-04-11T07:36:45+0000 lvl=info msg=“Executing migration” logger=migrator id=“create dashboard_snapshot table v4”
t=2020-04-11T07:36:45+0000 lvl=info msg=“Executing migration” logger=migrator id=“drop table dashboard_snapshot_v4 #1”
t=2020-04-11T07:36:45+0000 lvl=info msg=“Executing migration” logger=migrator id=“create dashboard_snapshot table v5 #2”
t=2020-04-11T07:36:45+0000 lvl=info msg=“Executing migration” logger=migrator id=“create index UQE_dashboard_snapshot_key - v5”
t=2020-04-11T07:36:45+0000 lvl=info msg=“Executing migration” logger=migrator id=“create index UQE_dashboard_snapshot_delete_key - v5”
t=2020-04-11T07:36:45+0000 lvl=info msg=“Executing migration” logger=migrator id=“create index IDX_dashboard_snapshot_user_id - v5”
t=2020-04-11T07:36:45+0000 lvl=info msg=“Executing migration” logger=migrator id=“alter dashboard_snapshot to mediumtext v2”
t=2020-04-11T07:36:45+0000 lvl=info msg=“Executing migration” logger=migrator id=“Update dashboard_snapshot table charset”
t=2020-04-11T07:36:45+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add column external_delete_url to dashboard_snapshots table”
t=2020-04-11T07:36:45+0000 lvl=info msg=“Executing migration” logger=migrator id=“create quota table v1”
t=2020-04-11T07:36:45+0000 lvl=info msg=“Executing migration” logger=migrator id=“create index UQE_quota_org_id_user_id_target - v1”
t=2020-04-11T07:36:45+0000 lvl=info msg=“Executing migration” logger=migrator id=“Update quota table charset”
t=2020-04-11T07:36:45+0000 lvl=info msg=“Executing migration” logger=migrator id=“create plugin_setting table”
t=2020-04-11T07:36:45+0000 lvl=info msg=“Executing migration” logger=migrator id=“create index UQE_plugin_setting_org_id_plugin_id - v1”
t=2020-04-11T07:36:45+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add column plugin_version to plugin_settings”
t=2020-04-11T07:36:45+0000 lvl=info msg=“Executing migration” logger=migrator id=“Update plugin_setting table charset”
t=2020-04-11T07:36:45+0000 lvl=info msg=“Executing migration” logger=migrator id=“create session table”
t=2020-04-11T07:36:45+0000 lvl=info msg=“Executing migration” logger=migrator id=“Drop old table playlist table”
t=2020-04-11T07:36:46+0000 lvl=info msg=“Executing migration” logger=migrator id=“Drop old table playlist_item table”
t=2020-04-11T07:36:46+0000 lvl=info msg=“Executing migration” logger=migrator id=“create playlist table v2”
t=2020-04-11T07:36:46+0000 lvl=info msg=“Executing migration” logger=migrator id=“create playlist item table v2”
t=2020-04-11T07:36:46+0000 lvl=info msg=“Executing migration” logger=migrator id=“Update playlist table charset”
t=2020-04-11T07:36:46+0000 lvl=info msg=“Executing migration” logger=migrator id=“Update playlist_item table charset”
t=2020-04-11T07:36:46+0000 lvl=info msg=“Executing migration” logger=migrator id=“drop preferences table v2”
t=2020-04-11T07:36:46+0000 lvl=info msg=“Executing migration” logger=migrator id=“drop preferences table v3”
t=2020-04-11T07:36:46+0000 lvl=info msg=“Executing migration” logger=migrator id=“create preferences table v3”
t=2020-04-11T07:36:46+0000 lvl=info msg=“Executing migration” logger=migrator id=“Update preferences table charset”
t=2020-04-11T07:36:46+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add column team_id in preferences”
t=2020-04-11T07:36:46+0000 lvl=info msg=“Executing migration” logger=migrator id=“Update team_id column values in preferences”
t=2020-04-11T07:36:46+0000 lvl=info msg=“Executing migration” logger=migrator id=“create alert table v1”
t=2020-04-11T07:36:46+0000 lvl=info msg=“Executing migration” logger=migrator id="add index alert org_id & id "
t=2020-04-11T07:36:46+0000 lvl=info msg=“Executing migration” logger=migrator id=“add index alert state”
t=2020-04-11T07:36:46+0000 lvl=info msg=“Executing migration” logger=migrator id=“add index alert dashboard_id”
t=2020-04-11T07:36:46+0000 lvl=info msg=“Executing migration” logger=migrator id=“Create alert_rule_tag table v1”
t=2020-04-11T07:36:46+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add unique index alert_rule_tag.alert_id_tag_id”
t=2020-04-11T07:36:46+0000 lvl=info msg=“Executing migration” logger=migrator id=“create alert_notification table v1”
t=2020-04-11T07:36:46+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add column is_default”
t=2020-04-11T07:36:46+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add column frequency”
t=2020-04-11T07:36:46+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add column send_reminder”
t=2020-04-11T07:36:46+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add column disable_resolve_message”
t=2020-04-11T07:36:46+0000 lvl=info msg=“Executing migration” logger=migrator id=“add index alert_notification org_id & name”
t=2020-04-11T07:36:46+0000 lvl=info msg=“Executing migration” logger=migrator id=“Update alert table charset”
t=2020-04-11T07:36:46+0000 lvl=info msg=“Executing migration” logger=migrator id=“Update alert_notification table charset”
t=2020-04-11T07:36:46+0000 lvl=info msg=“Executing migration” logger=migrator id=“create notification_journal table v1”
t=2020-04-11T07:36:46+0000 lvl=info msg=“Executing migration” logger=migrator id=“add index notification_journal org_id & alert_id & notifier_id”
t=2020-04-11T07:36:46+0000 lvl=info msg=“Executing migration” logger=migrator id=“drop alert_notification_journal”
t=2020-04-11T07:36:46+0000 lvl=info msg=“Executing migration” logger=migrator id=“create alert_notification_state table v1”
t=2020-04-11T07:36:46+0000 lvl=info msg=“Executing migration” logger=migrator id=“add index alert_notification_state org_id & alert_id & notifier_id”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add for to alert table”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add column uid in alert_notification”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“Update uid column values in alert_notification”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add unique index alert_notification_org_id_uid”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“Remove unique index org_id_name”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“Drop old annotation table v4”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“create annotation table v5”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“add index annotation 0 v3”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“add index annotation 1 v3”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“add index annotation 2 v3”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“add index annotation 3 v3”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“add index annotation 4 v3”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“Update annotation table charset”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add column region_id to annotation table”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“Drop category_id index”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add column tags to annotation table”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“Create annotation_tag table v2”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add unique index annotation_tag.annotation_id_tag_id”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“Update alert annotations and set TEXT to empty”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add created time to annotation table”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add updated time to annotation table”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add index for created in annotation table”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add index for updated in annotation table”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“Convert existing annotations from seconds to milliseconds”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add epoch_end column”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add index for epoch_end”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“Make epoch_end the same as epoch”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“Move region to single row”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“Remove index org_id_epoch from annotation table”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“Remove index org_id_dashboard_id_panel_id_epoch from annotation table”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add index for org_id_dashboard_id_epoch_end_epoch on annotation table”
t=2020-04-11T07:36:47+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add index for org_id_epoch_end_epoch on annotation table”
t=2020-04-11T07:36:48+0000 lvl=info msg=“Executing migration” logger=migrator id=“Remove index org_id_epoch_epoch_end from annotation table”
t=2020-04-11T07:36:48+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add index for alert_id on annotation table”
t=2020-04-11T07:36:48+0000 lvl=info msg=“Executing migration” logger=migrator id=“create test_data table”
t=2020-04-11T07:36:48+0000 lvl=info msg=“Executing migration” logger=migrator id=“create dashboard_version table v1”
t=2020-04-11T07:36:48+0000 lvl=info msg=“Executing migration” logger=migrator id=“add index dashboard_version.dashboard_id”
t=2020-04-11T07:36:48+0000 lvl=info msg=“Executing migration” logger=migrator id=“add unique index dashboard_version.dashboard_id and dashboard_version.version”
t=2020-04-11T07:36:48+0000 lvl=info msg=“Executing migration” logger=migrator id=“Set dashboard version to 1 where 0”
t=2020-04-11T07:36:48+0000 lvl=info msg=“Executing migration” logger=migrator id=“save existing dashboard data in dashboard_version table v1”
t=2020-04-11T07:36:48+0000 lvl=info msg=“Executing migration” logger=migrator id=“alter dashboard_version.data to mediumtext v1”
t=2020-04-11T07:36:48+0000 lvl=info msg=“Executing migration” logger=migrator id=“create team table”
t=2020-04-11T07:36:48+0000 lvl=info msg=“Executing migration” logger=migrator id=“add index team.org_id”
t=2020-04-11T07:36:48+0000 lvl=info msg=“Executing migration” logger=migrator id=“add unique index team_org_id_name”
t=2020-04-11T07:36:48+0000 lvl=info msg=“Executing migration” logger=migrator id=“create team member table”
t=2020-04-11T07:36:48+0000 lvl=info msg=“Executing migration” logger=migrator id=“add index team_member.org_id”
t=2020-04-11T07:36:48+0000 lvl=info msg=“Executing migration” logger=migrator id=“add unique index team_member_org_id_team_id_user_id”
t=2020-04-11T07:36:48+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add column email to team table”
t=2020-04-11T07:36:48+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add column external to team_member table”
t=2020-04-11T07:36:48+0000 lvl=info msg=“Executing migration” logger=migrator id=“Add column permission to team_member table”
t=2020-04-11T07:36:48+0000 lvl=info msg=“Executing migration” logger=migrator id=“create dashboard acl table”
t=2020-04-11T07:36:48+0000 lvl=info msg=“Executing migration” logger=migrator id=“add index dashboard_acl_dashboard_id”
t=2020-04-11T07:36:48+0000 lvl=info msg=“Executing migration” logger=migrator id=“add unique index dashboard_acl_dashboard_id_user_id”
t=2020-04-11T07:36:48+0000 lvl=info msg=“Executing migration” logger=migrator id=“add unique index dashboard_acl_dashboard_id_team_id”
t=2020-04-11T07:36:48+0000 lvl=info msg=“Executing migration” logger=migrator id=“save default acl rules in dashboard_acl table”
t=2020-04-11T07:36:48+0000 lvl=info msg=“Executing migration” logger=migrator id=“create tag table”
t=2020-04-11T07:36:48+0000 lvl=info msg=“Executing migration” logger=migrator id=“add index tag.key_value”
t=2020-04-11T07:36:48+0000 lvl=info msg=“Executing migration” logger=migrator id=“create login attempt table”
t=2020-04-11T07:36:48+0000 lvl=info msg=“Executing migration” logger=migrator id=“add index login_attempt.username”
t=2020-04-11T07:36:48+0000 lvl=info msg=“Executing migration” logger=migrator id=“drop index IDX_login_attempt_username - v1”
t=2020-04-11T07:36:48+0000 lvl=info msg=“Executing migration” logger=migrator id=“Rename table login_attempt to login_attempt_tmp_qwerty - v1”
t=2020-04-11T07:36:48+0000 lvl=info msg=“Executing migration” logger=migrator id=“create login_attempt v2”
t=2020-04-11T07:36:49+0000 lvl=info msg=“Executing migration” logger=migrator id=“create index IDX_login_attempt_username - v2”
t=2020-04-11T07:36:49+0000 lvl=info msg=“Executing migration” logger=migrator id=“copy login_attempt v1 to v2”
t=2020-04-11T07:36:49+0000 lvl=info msg=“Executing migration” logger=migrator id=“drop login_attempt_tmp_qwerty”
t=2020-04-11T07:36:49+0000 lvl=info msg=“Executing migration” logger=migrator id=“create user auth table”
t=2020-04-11T07:36:49+0000 lvl=info msg=“Executing migration” logger=migrator id=“create index IDX_user_auth_auth_module_auth_id - v1”
t=2020-04-11T07:36:49+0000 lvl=info msg=“Executing migration” logger=migrator id=“alter user_auth.auth_id to length 190”

pooh · April 11, 2020, 1:35pm

Firstly, please do not hijack a thread about something completely different -
start a new topic for your question.

Secondly, please tell us:

Which version of Grafana have you installed?
Which operating system and version have you installed it on?
What method did you use to install it? (If the answer is “from a package”,
which repository did you get the package from?)
Once Grafana is started, what URL are you entering in your browser to try
to connect to it?
What error message does your browser give you?
Does Grafana appear to be still running on the machine you installed it on,
after you get the error?
Is Grafana installed on the same machine as your browser, are they both on
machines on the asme local network, or do you have at least one router and
possibly a firewall between the two machines?

Regards,

Antony.

biswalswagat18 · April 11, 2020, 1:56pm

1- [root@Testing bin]# grafana-cli --version
Grafana CLI version 6.7.2
2-[root@Testing bin]# cat /etc/os-release
NAME=“Red Hat Enterprise Linux Server”
VERSION=“7.8 (Maipo)”
ID=“rhel”
ID_LIKE=“fedora”
VARIANT=“Server”
VARIANT_ID=“server”
VERSION_ID=“7.8”
PRETTY_NAME=“Red Hat Enterprise Linux”
ANSI_COLOR=“0;31”
3-vim /etc/yum.repos.d/grafana.repo
Add the following contents to file:

[grafana]
name=grafana
baseurl=https://packages.grafana.com/oss/rpm
repo_gpgcheck=1
enabled=1
gpgcheck=1
gpgkey=https://packages.grafana.com/gpg.key
sslverify=1
sslcacert=/etc/pki/tls/certs/ca-bundle.crt
Step 3 – Install Grafana
Enter the following command:

-sudo yum install grafana
4- http://localhost:3030/
5- This site can’t be reached

localhost refused to connect.
6- Yes grafana is in Running state only:
[root@Testing bin]# sudo /bin/systemctl status grafana-server.service
● grafana-server.service - Grafana instance
Loaded: loaded (/usr/lib/systemd/system/grafana-server.service; enabled; vendor preset: disabled)
Active: active (running) since Sat 2020-04-11 11:21:56 UTC; 2h 33min ago
Docs: http://docs.grafana.org
Main PID: 30172 (grafana-server)
CGroup: /system.slice/grafana-server.service
└─30172 /usr/sbin/grafana-server --config=/etc/grafana/grafana.ini --pidfile=/var/run/grafana/grafana-server.pid --packaging=rpm cfg:default.paths.logs=/v…

Apr 11 11:21:56 Testing grafana-server[30172]: t=2020-04-11T11:21:56+0000 lvl=info msg=“Initializing CleanUpService” logger=server
Apr 11 11:21:56 Testing grafana-server[30172]: t=2020-04-11T11:21:56+0000 lvl=info msg=“Initializing NotificationService” logger=server
Apr 11 11:21:56 Testing grafana-server[30172]: t=2020-04-11T11:21:56+0000 lvl=info msg=“Initializing provisioningServiceImpl” logger=server
Apr 11 11:21:56 Testing grafana-server[30172]: t=2020-04-11T11:21:56+0000 lvl=info msg=“Backend rendering via phantomJS” logger=rendering renderer=phantomJS
Apr 11 11:21:56 Testing grafana-server[30172]: t=2020-04-11T11:21:56+0000 lvl=warn msg="phantomJS is deprecated and will be removed in a future release. You should c…
Apr 11 11:21:56 Testing systemd[1]: Started Grafana instance.
Apr 11 11:21:56 Testing grafana-server[30172]: t=2020-04-11T11:21:56+0000 lvl=info msg=“Initializing Stream Manager”
Apr 11 11:21:56 Testing grafana-server[30172]: t=2020-04-11T11:21:56+0000 lvl=info msg=“HTTP Server Listen” logger=http.server address=[::]:3000 protocol=h…l= socket=
Apr 11 12:32:01 Testing grafana-server[30172]: t=2020-04-11T12:32:01+0000 lvl=eror msg=“Failed to get system stats” logger=metrics error=“database is locked”
Apr 11 12:32:02 Testing grafana-server[30172]: t=2020-04-11T12:32:02+0000 lvl=eror msg=“Could not load alerts” logger=alerting.ruleReader error=“database is locked”
Hint: Some lines were ellipsized, use -l to show in full.
7-yes both are in same network…

pooh · April 11, 2020, 2:25pm

Okay, so you’re running Grafana 6.7.2 on RHEL 7.8, and the browser is on the
same machine.

Why are you trying to connect to port 3030? Grafana’s default port is 3000.

I am also a bit bothered by your comment “both are in same network”.

You can only connect to “localhost” if Grafana is running on the same machine
as your browser. If these are on different machines, you need to tell the
browser to connect to the hostname (assuming DNS resolution works), or the IP
address, of the machine running Grafana.

What does (as root) “netstat -lptn” on the machine running Grafana tell you?
Is anything listening on TCP ports 3000 or 3030?

Just to be clear, what is the IP address of the machine where Grafana is
installed, and what is the IP address of the machine you are running the
browser on?

Antony.

biswalswagat18 · April 11, 2020, 6:52pm

I have created a VM through Azure ,having public IP 13.79.149.31, using putty I logged in to this machine and installed grafana in this machine.
This Azure portal is working under, AWS VM of IP 35.77.252.47 . In this VM I using chrome browser , on that browser trying to open Grafana, but unable to do that.
-No I am trying to access the Grafana browser through 3000 only.
-[root@Testing bin]# netstat -lptn
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 35657/sshd
tcp6 0 0 :::22 :::* LISTEN 35657/sshd
tcp6 0 0 :::3000 :::* LISTEN 30172/grafana-serve
Ip address of the machine where Grafana is installed : 10.0.0.7

[root@Testing bin]# ifconfig
eth0: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 10.0.0.7 netmask 255.255.255.0 broadcast 10.0.0.255
inet6 fe80::20d:3aff:feb7:2772 prefixlen 64 scopeid 0x20
ether 00:0d:3a:b7:27:72 txqueuelen 1000 (Ethernet)
RX packets 799138 bytes 803438105 (766.2 MiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 560363 bytes 101742839 (97.0 MiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

lo: flags=73<UP,LOOPBACK,RUNNING> mtu 65536
inet 127.0.0.1 netmask 255.0.0.0
inet6 ::1 prefixlen 128 scopeid 0x10
loop txqueuelen 1 (Local Loopback)
RX packets 150 bytes 11464 (11.1 KiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 150 bytes 11464 (11.1 KiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

biswalswagat18 · April 12, 2020, 7:39am

I didnt get any response from last 13 hours, can anyone please help me on this ?

anupam9164 · September 7, 2020, 7:18am

Hi ,

Best is to add firewall rule then try opening the GUI .

firewall-cmd --zone=public --add-port=3000/tcp --permanent
firewall-cmd --reload
iptables-save | grep 3000

Hope this works !!!

Regards
Anupam Thakur

Topic		Replies	Views
Can't access Grafana web interface trought port 3000? Configuration	9	53503	December 18, 2019
Grafana Web-UI not starting after update from 10.0.3 to 10.1.0 Installation	2	919	August 25, 2023
Grafana gui not accessible Configuration	1	2124	January 3, 2018
Grafana has failed to load its application files - Playlist Grafana	1	5905	April 12, 2019
Failed to load it's application files - Grafana Cloud Down? Grafana Cloud	1	841	March 10, 2021

Grafana Web UI: Problem Loading Page

Related topics