Admin User for Grafana instance with SAML

I have integrated a grafana instance with SAML and have made a user with admin role making the admin flag true. But the user with admin role is not able to create team, user, datasource etc. Is there any configuration I am missing, please let me know.

How did you integrate SAML? (SAML is not supported by Grafana out of the box)

I have integrated grafana with Apache as a webserver with SAML plugin

That’s very generic answer and nobody is able to replicate your issue from the answer :-).

My guess Apache with mod_shib as a reverse proxy on the front of Grafana in the AuthProxy mode? Your auth headers provided by Apache and Grafana config will be very helpful.

I have configured Apache with mod_auth_mellon module as SAML plugin. The apache header configuration is

RequestHeader set X-WEBAUTH-USER %{MELLON_user}e env=MELLON_user
RequestHeader set X-WEBAUTH-USER %{MELLON_email}e env=MELLON_email
RequestHeader set X-WEBAUTH-USER %{MELLON_username}e env=MELLON_username

and the grafana auth proxy configuration is

[auth.proxy]
enabled = true
header_name = X-WEBAUTH-USER
header_property = username
header_email_name = X-WEBAUTH-EMAIL
header_email_property = email
header_full_name = X-WEBAUTH-NAME
header_full_property = fullname
auto_sign_up = true

Hope it clears the configuration.

It doesn’t look right. You are forwarding only X-WEBAUTH-USER header + your auth.proxy also doesn’t look right (unless you have implemented own Grafana functionality).

For example header_full_property is not implemented.

Start with: http://docs.grafana.org/tutorials/authproxy/

I have corrected the configuration. I am passing only one header from Apache

RequestHeader set X-WEBAUTH-USER %{MELLON_email}e env=MELLON_email

and grafana is having only one header in configuration

header_name = X-WEBAUTH-USER
header_property = username

It does not solve the admin issue however.

Then it is a good time to check logs. Of course, use debug log level.

I have enabled debug logs. The admin issue is occurring in a new grafana instance also (without SAML). Here are the debug logs

t=2018-07-26T13:01:04-0400 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=0
t=2018-07-26T13:01:07-0400 lvl=info msg=“Request Completed” logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=54.149.171.249 time_ms=0 size=29 referer=
t=2018-07-26T13:01:07-0400 lvl=info msg=“Request Completed” logger=context userId=0 orgId=0 uname= method=GET path=/login status=302 remote_addr=54.149.171.249 time_ms=4 size=24 referer=
t=2018-07-26T13:01:08-0400 lvl=dbug msg=“Updating last user_seen_at” logger=context userId=2 orgId=1 uname=gbanerjee2@dxc.com user_id=2
t=2018-07-26T13:01:09-0400 lvl=dbug msg=“avatar.fetch(fetch new avatar): http://secure.gravatar.com/avatar/e6259fdf8cb226d6a80c3757d7637821?d=retro&r=pg&size=200
t=2018-07-26T13:01:14-0400 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=0

Q: why did you use mod_auth_mellon and why not mod_shib?

Missing debug information:

  • full Grafana configuration
  • full Grafana logs (debug log level and yes full - startup logs contain useful information)
  • Grafana version

It looks like misconfigured Grafana or X-WEBAUTH-USER request header is missing, because you are still redirected to login.

I am not redirected to login. I am able to successfully login without any issue. I dont think there is any issue with SAML plugin. The issue is I have updated the user to be admin user but admin permissions are not reflected in the UI.
Grafana Version 5.1.4

Grafana Log:
t=2018-07-26T13:00:23-0400 lvl=info msg=“Starting Grafana” logger=server version=5.1.4 commit=a5fe24fcc compiled=2018-06-19T06:54:57-0400
t=2018-07-26T13:00:23-0400 lvl=info msg=“Config loaded from” logger=settings file=/usr/share/grafana/conf/defaults.ini
t=2018-07-26T13:00:23-0400 lvl=info msg=“Config loaded from” logger=settings file=/etc/grafana/grafana.ini
t=2018-07-26T13:00:23-0400 lvl=info msg=“Config overridden from command line” logger=settings arg=“default.paths.data=/var/lib/grafana”
t=2018-07-26T13:00:23-0400 lvl=info msg=“Config overridden from command line” logger=settings arg=“default.paths.logs=/var/log/grafana”
t=2018-07-26T13:00:23-0400 lvl=info msg=“Config overridden from command line” logger=settings arg=“default.paths.plugins=/var/lib/grafana/plugins”
t=2018-07-26T13:00:23-0400 lvl=info msg=“Config overridden from command line” logger=settings arg=“default.paths.provisioning=/etc/grafana/provisioning”
t=2018-07-26T13:00:23-0400 lvl=info msg=“Path Home” logger=settings path=/usr/share/grafana
t=2018-07-26T13:00:23-0400 lvl=info msg=“Path Data” logger=settings path=/var/lib/grafana
t=2018-07-26T13:00:23-0400 lvl=info msg=“Path Logs” logger=settings path=/var/log/grafana
t=2018-07-26T13:00:23-0400 lvl=info msg=“Path Plugins” logger=settings path=/var/lib/grafana/plugins
t=2018-07-26T13:00:23-0400 lvl=info msg=“Path Provisioning” logger=settings path=/etc/grafana/provisioning
t=2018-07-26T13:00:23-0400 lvl=info msg=“App mode production” logger=settings
t=2018-07-26T13:00:23-0400 lvl=info msg=“Writing PID file” logger=server path=/var/run/grafana/grafana-server.pid pid=5995
t=2018-07-26T13:00:23-0400 lvl=info msg=“Initializing DB” logger=sqlstore dbtype=sqlite3
t=2018-07-26T13:00:23-0400 lvl=info msg=“Starting DB migration” logger=migrator
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create migration_log table”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create user table”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“add unique index user.login”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“add unique index user.email”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“drop index UQE_user_login - v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“drop index UQE_user_email - v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Rename table user to user_v1 - v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create user table v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create index UQE_user_login - v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create index UQE_user_email - v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“copy data_source v1 to v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Drop old table user_v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Add column help_flags1 to user table”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Update user table charset”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Add last_seen_at column to user”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create temp user table v1-7”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create index IDX_temp_user_email - v1-7”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create index IDX_temp_user_org_id - v1-7”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create index IDX_temp_user_code - v1-7”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create index IDX_temp_user_status - v1-7”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Update temp_user table charset”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create star table”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“add unique index star.user_id_dashboard_id”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create org table v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create index UQE_org_name - v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create org_user table v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create index IDX_org_user_org_id - v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create index UQE_org_user_org_id_user_id - v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=Executing logger=migrator sql="INSERT INTO org (updated\n, id\n, version\n, name\n, created) SELECT updated\n, id\n, version\n, name\n, created FROM account"
t=2018-07-26T13:00:23-0400 lvl=info msg=“Executing migration” logger=migrator id=“copy data account to org”
t=2018-07-26T13:00:23-0400 lvl=info msg=“Skipping migration condition not fulfilled” logger=migrator id=“copy data account to org”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=Executing logger=migrator sql="INSERT INTO org_user (role\n, created\n, updated\n, id\n, org_id\n, user_id) SELECT role\n, created\n, updated\n, id\n, account_id\n, user_id FROM account_user"
t=2018-07-26T13:00:23-0400 lvl=info msg=“Executing migration” logger=migrator id=“copy data account_user to org_user”
t=2018-07-26T13:00:23-0400 lvl=info msg=“Skipping migration condition not fulfilled” logger=migrator id=“copy data account_user to org_user”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Drop old table account”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Drop old table account_user”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Update org table charset”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Update org_user table charset”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Migrate all Read Only Viewers to Viewers”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create dashboard table”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“add index dashboard.account_id”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“add unique index dashboard_account_id_slug”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create dashboard_tag table”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“add unique index dashboard_tag.dasboard_id_term”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“drop index UQE_dashboard_tag_dashboard_id_term - v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Rename table dashboard to dashboard_v1 - v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create dashboard v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create index IDX_dashboard_org_id - v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create index UQE_dashboard_org_id_slug - v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“copy dashboard v1 to v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“drop table dashboard_v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“alter dashboard.data to mediumtext v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Add column updated_by in dashboard - v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Add column created_by in dashboard - v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Add column gnetId in dashboard”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Add index for gnetId in dashboard”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Add column plugin_id in dashboard”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Add index for plugin_id in dashboard”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Add index for dashboard_id in dashboard_tag”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Update dashboard table charset”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Update dashboard_tag table charset”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Add column folder_id in dashboard”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Add column isFolder in dashboard”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Add column has_acl in dashboard”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Add column uid in dashboard”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Update uid column values in dashboard”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Add unique index dashboard_org_id_uid”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Remove unique index org_id_slug”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Update dashboard title length”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Add unique index for dashboard_org_id_title_folder_id”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create dashboard_provisioning”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Rename table dashboard_provisioning to dashboard_provisioning_tmp_qwerty - v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create dashboard_provisioning v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create index IDX_dashboard_provisioning_dashboard_id - v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create index IDX_dashboard_provisioning_dashboard_id_name - v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“copy dashboard_provisioning v1 to v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“drop dashboard_provisioning_tmp_qwerty”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create data_source table”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“add index data_source.account_id”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“add unique index data_source.account_id_name”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“drop index IDX_data_source_account_id - v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“drop index UQE_data_source_account_id_name - v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Rename table data_source to data_source_v1 - v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create data_source table v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create index IDX_data_source_org_id - v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create index UQE_data_source_org_id_name - v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“copy data_source v1 to v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Drop old table data_source_v1 #2
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Add column with_credentials”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Add secure json data column”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Update data_source table charset”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Update initial version to 1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Add read_only data column”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create api_key table”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“add index api_key.account_id”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“add index api_key.key”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“add index api_key.account_id_name”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“drop index IDX_api_key_account_id - v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“drop index UQE_api_key_key - v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“drop index UQE_api_key_account_id_name - v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Rename table api_key to api_key_v1 - v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create api_key table v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create index IDX_api_key_org_id - v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create index UQE_api_key_key - v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create index UQE_api_key_org_id_name - v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“copy api_key v1 to v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Drop old table api_key_v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Update api_key table charset”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create dashboard_snapshot table v4”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“drop table dashboard_snapshot_v4 #1
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create dashboard_snapshot table v5 #2
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create index UQE_dashboard_snapshot_key - v5”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create index UQE_dashboard_snapshot_delete_key - v5”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create index IDX_dashboard_snapshot_user_id - v5”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“alter dashboard_snapshot to mediumtext v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Update dashboard_snapshot table charset”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create quota table v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create index UQE_quota_org_id_user_id_target - v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Update quota table charset”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create plugin_setting table”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create index UQE_plugin_setting_org_id_plugin_id - v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Add column plugin_version to plugin_settings”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Update plugin_setting table charset”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create session table”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Drop old table playlist table”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Drop old table playlist_item table”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create playlist table v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create playlist item table v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Update playlist table charset”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Update playlist_item table charset”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“drop preferences table v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“drop preferences table v3”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create preferences table v3”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Update preferences table charset”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create alert table v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id="add index alert org_id & id "
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“add index alert state”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“add index alert dashboard_id”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create alert_notification table v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Add column is_default”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“add index alert_notification org_id & name”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Update alert table charset”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Update alert_notification table charset”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Drop old annotation table v4”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create annotation table v5”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“add index annotation 0 v3”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“add index annotation 1 v3”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“add index annotation 2 v3”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“add index annotation 3 v3”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“add index annotation 4 v3”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Update annotation table charset”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Add column region_id to annotation table”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Drop category_id index”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Add column tags to annotation table”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Create annotation_tag table v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Add unique index annotation_tag.annotation_id_tag_id”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Update alert annotations and set TEXT to empty”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create test_data table”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create dashboard_version table v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“add index dashboard_version.dashboard_id”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“add unique index dashboard_version.dashboard_id and dashboard_version.version”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Set dashboard version to 1 where 0”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“save existing dashboard data in dashboard_version table v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“alter dashboard_version.data to mediumtext v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create team table”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“add index team.org_id”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“add unique index team_org_id_name”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create team member table”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“add index team_member.org_id”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“add unique index team_member_org_id_team_id_user_id”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Add column email to team table”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create dashboard acl table”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“add index dashboard_acl_dashboard_id”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“add unique index dashboard_acl_dashboard_id_user_id”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“add unique index dashboard_acl_dashboard_id_team_id”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“save default acl rules in dashboard_acl table”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create tag table”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“add index tag.key_value”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create login attempt table”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“add index login_attempt.username”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“drop index IDX_login_attempt_username - v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“Rename table login_attempt to login_attempt_tmp_qwerty - v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create login_attempt v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create index IDX_login_attempt_username - v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“copy login_attempt v1 to v2”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“drop login_attempt_tmp_qwerty”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create user auth table”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“create index IDX_user_auth_auth_module_auth_id - v1”
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Skipping migration: Already executed” logger=migrator id=“alter user_auth.auth_id to length 190”
t=2018-07-26T13:00:23-0400 lvl=info msg=“Starting plugin search” logger=plugins
t=2018-07-26T13:00:23-0400 lvl=dbug msg=“Checking for updates”
t=2018-07-26T13:00:23-0400 lvl=info msg=“Initializing Alerting” logger=alerting.engine
t=2018-07-26T13:00:23-0400 lvl=info msg=“Initializing CleanUpService” logger=cleanup
t=2018-07-26T13:00:23-0400 lvl=info msg=“Initializing Stream Manager”
t=2018-07-26T13:00:23-0400 lvl=info msg=“Initializing HTTP Server” logger=http.server address=0.0.0.0:3000 protocol=http subUrl= socket=
t=2018-07-26T13:00:24-0400 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=0
t=2018-07-26T13:00:28-0400 lvl=dbug msg=“Looking for App Dashboard Updates” logger=plugins
t=2018-07-26T13:00:34-0400 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=0
t=2018-07-26T13:00:44-0400 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=0
t=2018-07-26T13:00:54-0400 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=0
t=2018-07-26T13:01:04-0400 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=0
t=2018-07-26T13:01:07-0400 lvl=info msg=“Request Completed” logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=54.149.171.249 time_ms=0 size=29 referer=
t=2018-07-26T13:01:07-0400 lvl=info msg=“Request Completed” logger=context userId=0 orgId=0 uname= method=GET path=/login status=302 remote_addr=54.149.171.249 time_ms=4 size=24 referer=
t=2018-07-26T13:01:08-0400 lvl=dbug msg=“Updating last user_seen_at” logger=context userId=2 orgId=1 uname=gbanerjee2@dxc.com user_id=2
t=2018-07-26T13:01:09-0400 lvl=dbug msg=“avatar.fetch(fetch new avatar): http://secure.gravatar.com/avatar/e6259fdf8cb226d6a80c3757d7637821?d=retro&r=pg&size=200
t=2018-07-26T13:01:14-0400 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=0
t=2018-07-26T13:01:24-0400 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=0