Mattermost Peer-to-Peer Forum

Unable to activate plugin

#1

Summary

Unable to activate plugin.
Please tell me ths solution.

Steps to reproduce

1.upload plugins
2.Dice Roller
3.Matterpoll
4.Enables 2 plugins
5.Either one gets an error.(this case is matterpoll-error)

Env

Mattermost 5.10.0(port 80)
MySQL CE 8.0
Windows Server 2016
IIS

Expected behavior

  • 1 line of log.
{
"level":"error",
"ts":1557880693.8251514,
"caller":"mlog/log.go:172",
"msg":"Unable to activate plugin",
"plugin_id":"com.github.matterpoll.matterpoll",
"error":"unable to start plugin: com.github.matterpoll.matterpoll: SqlPluginStore.Get: プラグインのキーを取得できませんでした,
 plugin_id=com.github.matterpoll.matterpoll,
 key=version,
 err=Error 1054: Unknown column 'ExpireAt' in 'where clause'",
"errorVerbose":"SqlPluginStore.Get: プラグインのキーを取得できませんでした,
 plugin_id=com.github.matterpoll.matterpoll,
 key=version,
 err=Error 1054: Unknown column 'ExpireAt' in 'where clause'
unable to start plugin: com.github.matterpoll.matterpoll
github.com/mattermost/mattermost-server/plugin.(*Environment).Activate
	/go/src/github.com/mattermost/mattermost-server/plugin/environment.go:216
github.com/mattermost/mattermost-server/app.(*App).SyncPluginsActiveState
	/go/src/github.com/mattermost/mattermost-server/app/plugin.go:95
github.com/mattermost/mattermost-server/app.(*App).InitPlugins.func2
	/go/src/github.com/mattermost/mattermost-server/app/plugin.go:172
github.com/mattermost/mattermost-server/config.(*emitter).invokeConfigListeners.func1
	/go/src/github.com/mattermost/mattermost-server/config/emitter.go:35
sync.(*Map).Range
	/usr/local/go/src/sync/map.go:333
github.com/mattermost/mattermost-server/config.(*emitter).invokeConfigListeners
	/go/src/github.com/mattermost/mattermost-server/config/emitter.go:33
github.com/mattermost/mattermost-server/config.(*commonStore).set
	/go/src/github.com/mattermost/mattermost-server/config/common.go:80
github.com/mattermost/mattermost-server/config.(*FileStore).Set
	/go/src/github.com/mattermost/mattermost-server/config/file.go:97
github.com/mattermost/mattermost-server/app.(*Server).UpdateConfig
	/go/src/github.com/mattermost/mattermost-server/app/config.go:53
github.com/mattermost/mattermost-server/app.(*App).UpdateConfig
	/go/src/github.com/mattermost/mattermost-server/app/config.go:59
github.com/mattermost/mattermost-server/app.(*App).EnablePlugin
	/go/src/github.com/mattermost/mattermost-server/app/plugin.go:245
github.com/mattermost/mattermost-server/api4.enablePlugin
	/go/src/github.com/mattermost/mattermost-server/api4/plugin.go:187
github.com/mattermost/mattermost-server/web.Handler.ServeHTTP
	/go/src/github.com/mattermost/mattermost-server/web/handlers.go:167
github.com/mattermost/mattermost-server/vendor/github.com/gorilla/mux.(*Router).ServeHTTP
	/go/src/github.com/mattermost/mattermost-server/vendor/github.com/gorilla/mux/mux.go:162
github.com/mattermost/mattermost-server/app.(*RateLimiter).RateLimitHandler.func1
	/go/src/github.com/mattermost/mattermost-server/app/ratelimit.go:107
net/http.HandlerFunc.ServeHTTP
	/usr/local/go/src/net/http/server.go:1995
net/http.serverHandler.ServeHTTP
	/usr/local/go/src/net/http/server.go:2774
net/http.(*conn).serve
	/usr/local/go/src/net/http/server.go:1878
runtime.goexit
	/usr/local/go/src/runtime/asm_amd64.s:1337"
}
  • logs
{"level":"debug","ts":1557880892.7104774,"caller":"web/handlers.go:58","msg":"POST - /api/v4/users/status/ids"}
{"level":"debug","ts":1557880892.7105482,"caller":"mlog/log.go:160","msg":"CSRF Header check failed for request - Please upgrade your web application or custom app to set a CSRF Header"}
{"level":"debug","ts":1557880892.7717557,"caller":"plugin/hclog_adapter.go:32","msg":"using plugin","plugin_id":"com.github.matterpoll.matterpoll","wrapped_extras":"version1"}
{"level":"debug","ts":1557880892.7718081,"caller":"plugin/hclog_adapter.go:32","msg":"plugin address","plugin_id":"com.github.matterpoll.matterpoll","wrapped_extras":"address/tmp/plugin480970980networkunixtimestamp2019-05-15T00:41:32.771Z"}
{"level":"error","ts":1557880892.7796729,"caller":"app/plugin_key_value_store.go:54","msg":"Failed to query plugin key value","plugin_id":"com.github.matterpoll.matterpoll","key":"version","error":"SqlPluginStore.Get: プラグインのキーを取得できませんでした, plugin_id=com.github.matterpoll.matterpoll, key=version, err=Error 1054: Unknown column 'ExpireAt' in 'where clause'"}
{"level":"debug","ts":1557880892.781468,"caller":"plugin/hclog_adapter.go:32","msg":"plugin process exited","plugin_id":"com.github.matterpoll.matterpoll","wrapped_extras":"path/mattermost/plugins/com.github.matterpoll.matterpoll/server/dist/plugin-linux-amd64pid11693"}
{"level":"error","ts":1557880892.7815397,"caller":"mlog/log.go:172","msg":"Unable to activate plugin","plugin_id":"com.github.matterpoll.matterpoll","error":"unable to start plugin: com.github.matterpoll.matterpoll: SqlPluginStore.Get: プラグインのキーを取得できませんでした, plugin_id=com.github.matterpoll.matterpoll, key=version, err=Error 1054: Unknown column 'ExpireAt' in 'where clause'","errorVerbose":"SqlPluginStore.Get: プラグインのキーを取得できませんでした, plugin_id=com.github.matterpoll.matterpoll, key=version, err=Error 1054: Unknown column 'ExpireAt' in 'where clause'\nunable to start plugin: com.github.matterpoll.matterpoll\ngithub.com/mattermost/mattermost-server/plugin.(*Environment).Activate\n\t/go/src/github.com/mattermost/mattermost-server/plugin/environment.go:216\ngithub.com/mattermost/mattermost-server/app.(*App).SyncPluginsActiveState\n\t/go/src/github.com/mattermost/mattermost-server/app/plugin.go:95\ngithub.com/mattermost/mattermost-server/app.(*App).InitPlugins.func2\n\t/go/src/github.com/mattermost/mattermost-server/app/plugin.go:172\ngithub.com/mattermost/mattermost-server/config.(*emitter).invokeConfigListeners.func1\n\t/go/src/github.com/mattermost/mattermost-server/config/emitter.go:35\nsync.(*Map).Range\n\t/usr/local/go/src/sync/map.go:333\ngithub.com/mattermost/mattermost-server/config.(*emitter).invokeConfigListeners\n\t/go/src/github.com/mattermost/mattermost-server/config/emitter.go:33\ngithub.com/mattermost/mattermost-server/config.(*commonStore).set\n\t/go/src/github.com/mattermost/mattermost-server/config/common.go:80\ngithub.com/mattermost/mattermost-server/config.(*FileStore).Set\n\t/go/src/github.com/mattermost/mattermost-server/config/file.go:97\ngithub.com/mattermost/mattermost-server/app.(*Server).UpdateConfig\n\t/go/src/github.com/mattermost/mattermost-server/app/config.go:53\ngithub.com/mattermost/mattermost-server/app.(*App).UpdateConfig\n\t/go/src/github.com/mattermost/mattermost-server/app/config.go:59\ngithub.com/mattermost/mattermost-server/app.(*App).EnablePlugin\n\t/go/src/github.com/mattermost/mattermost-server/app/plugin.go:245\ngithub.com/mattermost/mattermost-server/api4.enablePlugin\n\t/go/src/github.com/mattermost/mattermost-server/api4/plugin.go:187\ngithub.com/mattermost/mattermost-server/web.Handler.ServeHTTP\n\t/go/src/github.com/mattermost/mattermost-server/web/handlers.go:167\ngithub.com/mattermost/mattermost-server/vendor/github.com/gorilla/mux.(*Router).ServeHTTP\n\t/go/src/github.com/mattermost/mattermost-server/vendor/github.com/gorilla/mux/mux.go:162\ngithub.com/mattermost/mattermost-server/app.(*RateLimiter).RateLimitHandler.func1\n\t/go/src/github.com/mattermost/mattermost-server/app/ratelimit.go:107\nnet/http.HandlerFunc.ServeHTTP\n\t/usr/local/go/src/net/http/server.go:1995\nnet/http.serverHandler.ServeHTTP\n\t/usr/local/go/src/net/http/server.go:2774\nnet/http.(*conn).serve\n\t/usr/local/go/src/net/http/server.go:1878\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1337"}
{"level":"debug","ts":1557880892.7993038,"caller":"jobs/schedulers.go:185","msg":"Schedulers received config change."}
{"level":"debug","ts":1557880892.801845,"caller":"jobs/schedulers.go:167","msg":"Next run time for scheduler MigrationsScheduler: <nil>"}
{"level":"debug","ts":1557880892.8042414,"caller":"jobs/schedulers.go:167","msg":"Next run time for scheduler PluginsScheduler: 2019-05-15 00:42:32.804232 +0000 UTC m=+44444.352444601"}
{"level":"debug","ts":1557880892.8042796,"caller":"jobs/workers.go:108","msg":"Workers received config change."}
{"level":"debug","ts":1557880892.8344994,"caller":"jobs/workers.go:108","msg":"Workers received config change."}
{"level":"debug","ts":1557880892.8345308,"caller":"jobs/schedulers.go:185","msg":"Schedulers received config change."}
{"level":"debug","ts":1557880892.8378177,"caller":"jobs/schedulers.go:167","msg":"Next run time for scheduler MigrationsScheduler: <nil>"}
{"level":"debug","ts":1557880892.8398943,"caller":"jobs/schedulers.go:167","msg":"Next run time for scheduler PluginsScheduler: 2019-05-15 00:42:32.8398851 +0000 UTC m=+44444.388097701"}
{"level":"debug","ts":1557880894.6465302,"caller":"web/handlers.go:58","msg":"POST - /api/v4/users/status/ids"}
{"level":"debug","ts":1557880894.646682,"caller":"mlog/log.go:160","msg":"CSRF Header check failed for request - Please upgrade your web application or custom app to set a CSRF Header"}
{"level":"debug","ts":1557880896.4069977,"caller":"web/handlers.go:58","msg":"GET - /api/v4/logs"}
{"level":"debug","ts":1557880897.4758525,"caller":"web/handlers.go:58","msg":"POST - /api/v4/users/status/ids"}
{"level":"debug","ts":1557880897.4760103,"caller":"mlog/log.go:160","msg":"CSRF Header check failed for request - Please upgrade your web application or custom app to set a CSRF Header"}
{"level":"debug","ts":1557880898.1915643,"caller":"web/handlers.go:58","msg":"POST - /api/v4/users/status/ids"}
{"level":"debug","ts":1557880898.1920583,"caller":"mlog/log.go:160","msg":"CSRF Header check failed for request - Please upgrade your web application or custom app to set a CSRF Header"}
{"level":"debug","ts":1557880900.96416,"caller":"web/handlers.go:58","msg":"POST - /api/v4/users/status/ids"}
{"level":"debug","ts":1557880900.9643154,"caller":"mlog/log.go:160","msg":"CSRF Header check failed for request - Please upgrade your web application or custom app to set a CSRF Header"}
{"level":"debug","ts":1557880902.1423597,"caller":"web/handlers.go:58","msg":"POST - /api/v4/users/status/ids"}
{"level":"debug","ts":1557880902.1425424,"caller":"mlog/log.go:160","msg":"CSRF Header check failed for request - Please upgrade your web application or custom app to set a CSRF Header"}
{"level":"debug","ts":1557880904.0742428,"caller":"web/handlers.go:58","msg":"POST - /api/v4/channels/members/me/view"}
{"level":"debug","ts":1557880904.0744326,"caller":"mlog/log.go:160","msg":"CSRF Header check failed for request - Please upgrade your web application or custom app to set a CSRF Header"}
{"level":"debug","ts":1557880904.136692,"caller":"web/handlers.go:58","msg":"GET - /api/v4/users/me/teams/a3cbsc7xp3883rz3snwja99bfh/channels"}
{"level":"debug","ts":1557880904.1375167,"caller":"web/handlers.go:58","msg":"GET - /api/v4/users/me/teams/a3cbsc7xp3883rz3snwja99bfh/channels/members"}
{"level":"debug","ts":1557880908.7468667,"caller":"web/handlers.go:58","msg":"GET - /"}
{"level":"debug","ts":1557880908.9178472,"caller":"wsapi/websocket_handler.go:26","msg":"websocket: user_typing"}
{"level":"debug","ts":1557880914.1557493,"caller":"wsapi/websocket_handler.go:26","msg":"websocket: user_typing"}
{"level":"debug","ts":1557880915.672305,"caller":"web/handlers.go:58","msg":"POST - /api/v4/posts"}
{"level":"debug","ts":1557880915.6723874,"caller":"mlog/log.go:160","msg":"CSRF Header check failed for request - Please upgrade your web application or custom app to set a CSRF Header"}
{"level":"debug","ts":1557880917.1122391,"caller":"web/handlers.go:58","msg":"POST - /api/v4/users/status/ids"}
{"level":"debug","ts":1557880917.1141057,"caller":"mlog/log.go:160","msg":"CSRF Header check failed for request - Please upgrade your web application or custom app to set a CSRF Header"}
{"level":"debug","ts":1557880918.5658572,"caller":"web/handlers.go:58","msg":"GET - /api/v4/channels/yzasxws3hjdk5fr5h3jien3zwh/members/me"}
{"level":"debug","ts":1557880918.6364174,"caller":"web/handlers.go:58","msg":"GET - /api/v4/channels/yzasxws3hjdk5fr5h3jien3zwh/posts"}
{"level":"debug","ts":1557880918.6571538,"caller":"web/handlers.go:58","msg":"GET - /api/v4/channels/yzasxws3hjdk5fr5h3jien3zwh/stats"}
{"level":"debug","ts":1557880918.6581662,"caller":"web/handlers.go:58","msg":"POST - /api/v4/channels/members/me/view"}
{"level":"debug","ts":1557880918.6583974,"caller":"mlog/log.go:160","msg":"CSRF Header check failed for request - Please upgrade your web application or custom app to set a CSRF Header"}
{"level":"debug","ts":1557880926.9913807,"caller":"web/handlers.go:58","msg":"GET - /api/v4/channels/73upp1q4bjnsbq89aybatfktoh/members/me"}
{"level":"debug","ts":1557880927.0224223,"caller":"web/handlers.go:58","msg":"GET - /api/v4/channels/73upp1q4bjnsbq89aybatfktoh/posts"}
{"level":"debug","ts":1557880927.0572467,"caller":"web/handlers.go:58","msg":"POST - /api/v4/channels/members/me/view"}
{"level":"debug","ts":1557880927.0573118,"caller":"mlog/log.go:160","msg":"CSRF Header check failed for request - Please upgrade your web application or custom app to set a CSRF Header"}
{"level":"debug","ts":1557880927.0723345,"caller":"web/handlers.go:58","msg":"GET - /api/v4/channels/73upp1q4bjnsbq89aybatfktoh/stats"}
{"level":"debug","ts":1557880927.5106926,"caller":"web/handlers.go:58","msg":"GET - /api/v4/users/rm66do1rd7raik45tyb7gc56pr/image"}
{"level":"debug","ts":1557880929.1044288,"caller":"web/handlers.go:58","msg":"POST - /api/v4/users/status/ids"}
{"level":"debug","ts":1557880929.1045926,"caller":"mlog/log.go:160","msg":"CSRF Header check failed for request - Please upgrade your web application or custom app to set a CSRF Header"}
{"level":"debug","ts":1557880930.8757663,"caller":"web/handlers.go:58","msg":"POST - /api/v4/users/status/ids"}
{"level":"debug","ts":1557880930.875867,"caller":"mlog/log.go:160","msg":"CSRF Header check failed for request - Please upgrade your web application or custom app to set a CSRF Header"}
{"level":"debug","ts":1557880938.980764,"caller":"web/handlers.go:58","msg":"GET - /"}
{"level":"debug","ts":1557880942.1368809,"caller":"web/handlers.go:58","msg":"GET - /"}
{"level":"debug","ts":1557880944.5835564,"caller":"web/handlers.go:58","msg":"GET - /api/v4/config/client"}
{"level":"debug","ts":1557880944.7121093,"caller":"web/handlers.go:58","msg":"GET - /api/v4/license/client"}
{"level":"debug","ts":1557880944.7306986,"caller":"web/handlers.go:58","msg":"GET - /api/v4/users/me"}
{"level":"debug","ts":1557880944.7436163,"caller":"web/handlers.go:58","msg":"GET - /api/v4/users/me/preferences"}
{"level":"debug","ts":1557880944.8330715,"caller":"web/handlers.go:58","msg":"GET - /api/v4/users/me/teams"}
{"level":"debug","ts":1557880944.8345165,"caller":"web/handlers.go:58","msg":"GET - /api/v4/users/me/teams/members"}
{"level":"debug","ts":1557880944.8348205,"caller":"web/handlers.go:58","msg":"GET - /api/v4/users/me/teams/unread"}
{"level":"debug","ts":1557880945.1387498,"caller":"web/handlers.go:58","msg":"GET - /api/v4/teams/name/zep2/channels/name/shidaren"}
{"level":"debug","ts":1557880945.2357802,"caller":"web/handlers.go:58","msg":"GET - /api/v4/plugins/webapp"}
{"level":"debug","ts":1557880945.3978062,"caller":"web/handlers.go:58","msg":"POST - /api/v4/users/status/ids"}
{"level":"debug","ts":1557880945.3979547,"caller":"mlog/log.go:160","msg":"CSRF Header check failed for request - Please upgrade your web application or custom app to set a CSRF Header"}
{"level":"debug","ts":1557880945.5273077,"caller":"web/handlers.go:58","msg":"GET - /api/v4/websocket"}
{"level":"debug","ts":1557880945.551377,"caller":"web/handlers.go:58","msg":"POST - /api/v4/roles/names"}
{"level":"debug","ts":1557880945.7979527,"caller":"web/handlers.go:58","msg":"GET - /api/v4/users/me/teams/unread"}
{"level":"debug","ts":1557880945.9570692,"caller":"web/handlers.go:58","msg":"GET - /api/v4/users/me/teams/a3cbsc7xp3883rz3snwja99bfh/channels"}
{"level":"debug","ts":1557880946.0258617,"caller":"web/handlers.go:58","msg":"GET - /api/v4/users/me/teams/a3cbsc7xp3883rz3snwja99bfh/channels/members"}
{"level":"debug","ts":1557880946.0769048,"caller":"web/handlers.go:58","msg":"POST - /api/v4/roles/names"}
{"level":"debug","ts":1557880946.2844827,"caller":"web/handlers.go:58","msg":"GET - /api/v4/channels/t37rbfkx77nxpk63unk6axpkda/members/me"}
{"level":"debug","ts":1557880946.3619938,"caller":"web/handlers.go:58","msg":"GET - /api/v4/teams"}
{"level":"debug","ts":1557880947.0418048,"caller":"web/handlers.go:58","msg":"POST - /api/v4/channels/members/me/view"}
{"level":"debug","ts":1557880947.0419965,"caller":"mlog/log.go:160","msg":"CSRF Header check failed for request - Please upgrade your web application or custom app to set a CSRF Header"}
#2

Hi @Hanzei You probably have an idea what the error might mean,

#3

The error report was incorrect because it was trial and error in both linux environment (5.9) and windows environment (5.10).
The problem was the file named plugin, which is the executable file of DiceRoller under Windows. Resolve if you rename plugin.exe.
Thank you.

1 Like