Skip to content

Instantly share code, notes, and snippets.

@Mr-Kaos

Mr-Kaos/gist:ef2a01552cbbb0947b8edf1d29ab38c0 Secret

Last active November 1, 2023 21:48
Show Gist options
  • Save Mr-Kaos/ef2a01552cbbb0947b8edf1d29ab38c0 to your computer and use it in GitHub Desktop.
Save Mr-Kaos/ef2a01552cbbb0947b8edf1d29ab38c0 to your computer and use it in GitHub Desktop.
Download ZIP
Kanboard successful login, failed redirect log
Raw
gistfile1.txt
[2023-11-02 08:44:51] [debug] Kanboard\Core\Controller\Runner::executeMiddleware
[2023-11-02 08:44:51] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute
[2023-11-01 21:44:51] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\AuthenticationMiddleware
[2023-11-01 21:44:51] [debug] Kanboard\Core\Controller\Runner::executeController => \Kanboard\Controller\AuthController::check
[2023-11-01 21:44:52] [debug] Subscriber executed: Kanboard\Subscriber\AuthSubscriber::afterLogin
[2023-11-01 21:44:52] [debug] SQL: SELECT TOP (1) [sessions].[data] FROM [sessions] WHERE [id] = ?
[2023-11-01 21:44:52] [debug] SQL: param[1]: 'gr7vp5pe9vd0mav3d3aruhvp6a'
[2023-11-01 21:44:52] [debug] SQL: query_duration=0.0013809204101562
[2023-11-01 21:44:52] [debug] SQL: total_execution_time=0.0013809204101562
[2023-11-01 21:44:52] [debug] SQL: SELECT [settings].[option], [settings].[value] FROM [settings]
[2023-11-01 21:44:52] [debug] SQL: query_duration=0.0014231204986572
[2023-11-01 21:44:52] [debug] SQL: total_execution_time=0.0028040409088135
[2023-11-01 21:44:52] [debug] SQL: SELECT * FROM [actions]
[2023-11-01 21:44:52] [debug] SQL: query_duration=0.0012040138244629
[2023-11-01 21:44:52] [debug] SQL: total_execution_time=0.0040080547332764
[2023-11-01 21:44:52] [debug] SQL: SELECT * FROM [action_has_params]
[2023-11-01 21:44:52] [debug] SQL: query_duration=0.0012059211730957
[2023-11-01 21:44:52] [debug] SQL: total_execution_time=0.0052139759063721
[2023-11-01 21:44:52] [debug] SQL: SELECT 1 FROM [users] WHERE [username] = ? AND [lock_expiration_date] != ? AND [lock_expiration_date] >= ?
[2023-11-01 21:44:52] [debug] SQL: param[1]: 'admin'
[2023-11-01 21:44:52] [debug] SQL: param[2]: '0'
[2023-11-01 21:44:52] [debug] SQL: param[3]: '1698875091'
[2023-11-01 21:44:52] [debug] SQL: query_duration=0.0014090538024902
[2023-11-01 21:44:52] [debug] SQL: total_execution_time=0.0066230297088623
[2023-11-01 21:44:52] [debug] SQL: SELECT TOP (1) [users].[nb_failed_login] FROM [users] WHERE [username] = ?
[2023-11-01 21:44:52] [debug] SQL: param[1]: 'admin'
[2023-11-01 21:44:52] [debug] SQL: query_duration=0.0013778209686279
[2023-11-01 21:44:52] [debug] SQL: total_execution_time=0.0080008506774902
[2023-11-01 21:44:52] [debug] SQL: SELECT TOP (1) [users].[id], [users].[password] FROM [users] WHERE [username] = ? AND [disable_login_form] = ? AND [is_ldap_user] = ? AND [is_active] = ?
[2023-11-01 21:44:52] [debug] SQL: param[1]: 'admin'
[2023-11-01 21:44:52] [debug] SQL: param[2]: '0'
[2023-11-01 21:44:52] [debug] SQL: param[3]: '0'
[2023-11-01 21:44:52] [debug] SQL: param[4]: '1'
[2023-11-01 21:44:52] [debug] SQL: query_duration=0.0015020370483398
[2023-11-01 21:44:52] [debug] SQL: total_execution_time=0.0095028877258301
[2023-11-01 21:44:52] [debug] SQL: SELECT TOP (1) * FROM [users] WHERE [id] = ?
[2023-11-01 21:44:52] [debug] SQL: param[1]: '1'
[2023-11-01 21:44:52] [debug] SQL: query_duration=0.0013599395751953
[2023-11-01 21:44:52] [debug] SQL: total_execution_time=0.010862827301025
[2023-11-01 21:44:52] [debug] SQL: SELECT 1 FROM [sessions] WHERE [id] = ?
[2023-11-01 21:44:52] [debug] SQL: param[1]: 'gr7vp5pe9vd0mav3d3aruhvp6a'
[2023-11-01 21:44:52] [debug] SQL: query_duration=0.00094914436340332
[2023-11-01 21:44:52] [debug] SQL: total_execution_time=0.011811971664429
[2023-11-01 21:44:52] [debug] SQL: UPDATE [sessions] SET [expire_at]=?, [data]=? WHERE [id] = ?
[2023-11-01 21:44:52] [debug] SQL: param[1]: '1698918292'
[2023-11-01 21:44:52] [debug] SQL: param[2]: 'redirectAfterLogin|s:9:"/kanboard";csrf_key|s:64:"3534f931eae59a79c3e322d3c43d4c3a59631be2765f8841d3101a53b61ac4db";hasRememberMe|b:1;'
[2023-11-01 21:44:52] [debug] SQL: param[3]: 'gr7vp5pe9vd0mav3d3aruhvp6a'
[2023-11-01 21:44:52] [debug] SQL: query_duration=0.001086950302124
[2023-11-01 21:44:52] [debug] SQL: total_execution_time=0.012898921966553
[2023-11-01 21:44:52] [debug] SQL: SELECT TOP (1) [sessions].[data] FROM [sessions] WHERE [id] = ?
[2023-11-01 21:44:52] [debug] SQL: param[1]: 'rvdi6ehbdre3985l1bn7rks75s'
[2023-11-01 21:44:52] [debug] SQL: query_duration=0.0012531280517578
[2023-11-01 21:44:52] [debug] SQL: total_execution_time=0.014152050018311
[2023-11-01 21:44:52] [debug] SQL: UPDATE [users] SET [nb_failed_login]=?, [lock_expiration_date]=? WHERE [username] = ?
[2023-11-01 21:44:52] [debug] SQL: param[1]: '0'
[2023-11-01 21:44:52] [debug] SQL: param[2]: '0'
[2023-11-01 21:44:52] [debug] SQL: param[3]: 'admin'
[2023-11-01 21:44:52] [debug] SQL: query_duration=0.028337001800537
[2023-11-01 21:44:52] [debug] SQL: total_execution_time=0.042489051818848
[2023-11-01 21:44:52] [debug] SQL: SELECT [last_logins].[id] FROM [last_logins] WHERE [user_id] = ? ORDER BY [id] DESC
[2023-11-01 21:44:52] [debug] SQL: param[1]: '1'
[2023-11-01 21:44:52] [debug] SQL: query_duration=0.0013558864593506
[2023-11-01 21:44:52] [debug] SQL: total_execution_time=0.043844938278198
[2023-11-01 21:44:52] [debug] SQL: DELETE FROM [last_logins] WHERE [user_id] = ? AND [id] NOT IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2023-11-01 21:44:52] [debug] SQL: param[1]: '1'
[2023-11-01 21:44:52] [debug] SQL: param[2]: '21'
[2023-11-01 21:44:52] [debug] SQL: param[3]: '20'
[2023-11-01 21:44:52] [debug] SQL: param[4]: '19'
[2023-11-01 21:44:52] [debug] SQL: param[5]: '18'
[2023-11-01 21:44:52] [debug] SQL: param[6]: '17'
[2023-11-01 21:44:52] [debug] SQL: param[7]: '16'
[2023-11-01 21:44:52] [debug] SQL: param[8]: '14'
[2023-11-01 21:44:52] [debug] SQL: param[9]: '8'
[2023-11-01 21:44:52] [debug] SQL: param[10]: '7'
[2023-11-01 21:44:52] [debug] SQL: query_duration=0.041394948959351
[2023-11-01 21:44:52] [debug] SQL: total_execution_time=0.085239887237549
[2023-11-01 21:44:52] [debug] SQL: INSERT INTO [last_logins] ([auth_type], [user_id], [ip], [user_agent], [date_creation]) VALUES (:auth_type, :user_id, :ip, :user_agent, :date_creation)
[2023-11-01 21:44:52] [debug] SQL: param[auth_type]: 'Database'
[2023-11-01 21:44:52] [debug] SQL: param[user_id]: '1'
[2023-11-01 21:44:52] [debug] SQL: param[ip]: '192.168.0.27'
[2023-11-01 21:44:52] [debug] SQL: param[user_agent]: 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/118.0.0.0 Safari/537.36 Edg/118.0.2088.76'
[2023-11-01 21:44:52] [debug] SQL: param[date_creation]: '1698875092'
[2023-11-01 21:44:52] [debug] SQL: query_duration=0.1109459400177
[2023-11-01 21:44:52] [debug] SQL: total_execution_time=0.19618582725525
[2023-11-01 21:44:52] [debug] SQL: DELETE FROM [remember_me] WHERE [user_id] = ? AND [expiration] < ?
[2023-11-01 21:44:52] [debug] SQL: param[1]: '1'
[2023-11-01 21:44:52] [debug] SQL: param[2]: '1698875092'
[2023-11-01 21:44:52] [debug] SQL: query_duration=0.0013039112091064
[2023-11-01 21:44:52] [debug] SQL: total_execution_time=0.19748973846436
[2023-11-01 21:44:52] [debug] SQL: INSERT INTO [remember_me] ([user_id], [ip], [user_agent], [token], [sequence], [expiration], [date_creation]) VALUES (:user_id, :ip, :user_agent, :token, :sequence, :expiration, :date_creation)
[2023-11-01 21:44:52] [debug] SQL: param[user_id]: '1'
[2023-11-01 21:44:52] [debug] SQL: param[ip]: '192.168.0.27'
[2023-11-01 21:44:52] [debug] SQL: param[user_agent]: 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/118.0.0.0 Safari/537.36 Edg/118.0.2088.76'
[2023-11-01 21:44:52] [debug] SQL: param[token]: 'cdd9cd80f5ba5d52a7b56f56fda7c956d8fc2c39611d67b3e936140fc5532157'
[2023-11-01 21:44:52] [debug] SQL: param[sequence]: '5cf700830a86c5087eb57dd8228876c20b0995f6467b5fb9a02cebe79523'
[2023-11-01 21:44:52] [debug] SQL: param[expiration]: '1704059092'
[2023-11-01 21:44:52] [debug] SQL: param[date_creation]: '1698875092'
[2023-11-01 21:44:52] [debug] SQL: query_duration=0.032937049865723
[2023-11-01 21:44:52] [debug] SQL: total_execution_time=0.23042678833008
[2023-11-01 21:44:52] [debug] SQL: SELECT 1 FROM [sessions] WHERE [id] = ?
[2023-11-01 21:44:52] [debug] SQL: param[1]: 'rvdi6ehbdre3985l1bn7rks75s'
[2023-11-01 21:44:52] [debug] SQL: query_duration=0.003680944442749
[2023-11-01 21:44:52] [debug] SQL: total_execution_time=0.23410773277283
[2023-11-01 21:44:52] [debug] SQL: INSERT INTO [sessions] ([id], [expire_at], [data]) VALUES (:id, :expire_at, :data)
[2023-11-01 21:44:52] [debug] SQL: param[id]: 'rvdi6ehbdre3985l1bn7rks75s'
[2023-11-01 21:44:52] [debug] SQL: param[expire_at]: '1698918292'
[2023-11-01 21:44:52] [debug] SQL: param[data]: 'csrf_key|s:64:"3534f931eae59a79c3e322d3c43d4c3a59631be2765f8841d3101a53b61ac4db";hasRememberMe|b:1;user|a:24:{s:2:"id";i:1;s:8:"username";s:5:"admin";s:12:"is_ldap_user";b:0;s:4:"name";N;s:5:"email";N;s:9:"google_id";N;s:9:"github_id";N;s:21:"notifications_enabled";s:1:"0";s:8:"timezone";s:0:"";s:8:"language";s:0:"";s:18:"disable_login_form";s:1:"0";s:19:"twofactor_activated";b:0;s:16:"twofactor_secret";N;s:5:"token";s:0:"";s:20:"notifications_filter";s:1:"4";s:15:"nb_failed_login";s:1:"0";s:20:"lock_expiration_date";s:1:"0";s:9:"gitlab_id";N;s:4:"role";s:9:"app-admin";s:9:"is_active";s:1:"1";s:11:"avatar_path";N;s:16:"api_access_token";N;s:6:"filter";s:0:"";s:5:"theme";s:5:"light";}postAuthenticationValidated|b:0;'
[2023-11-01 21:44:52] [debug] SQL: query_duration=0.0028300285339355
[2023-11-01 21:44:52] [debug] SQL: total_execution_time=0.23693776130676
[2023-11-01 21:44:52] [debug] APP: nb_queries=19
[2023-11-01 21:44:52] [debug] APP: rendering_time=0.73156499862671
[2023-11-01 21:44:52] [debug] APP: memory_usage=5.11M
[2023-11-01 21:44:52] [debug] APP: uri=/Kanboard/?controller=AuthController&action=check
[2023-11-01 21:44:52] [debug] ###############################################
[2023-11-02 08:44:52] [debug] Kanboard\Core\Controller\Runner::executeMiddleware
[2023-11-02 08:44:52] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute
[2023-11-01 21:44:52] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\AuthenticationMiddleware
[2023-11-01 21:44:52] [debug] SQL: SELECT TOP (1) [sessions].[data] FROM [sessions] WHERE [id] = ?
[2023-11-01 21:44:52] [debug] SQL: param[1]: 'mahc5v02gai0pn9ih7084urb6b'
[2023-11-01 21:44:52] [debug] SQL: query_duration=0.009005069732666
[2023-11-01 21:44:52] [debug] SQL: total_execution_time=0.009005069732666
[2023-11-01 21:44:52] [debug] SQL: SELECT [settings].[option], [settings].[value] FROM [settings]
[2023-11-01 21:44:52] [debug] SQL: query_duration=0.0021979808807373
[2023-11-01 21:44:52] [debug] SQL: total_execution_time=0.011203050613403
[2023-11-01 21:44:52] [debug] SQL: SELECT * FROM [actions]
[2023-11-01 21:44:52] [debug] SQL: query_duration=0.0014588832855225
[2023-11-01 21:44:52] [debug] SQL: total_execution_time=0.012661933898926
[2023-11-01 21:44:52] [debug] SQL: SELECT * FROM [action_has_params]
[2023-11-01 21:44:52] [debug] SQL: query_duration=0.0023441314697266
[2023-11-01 21:44:52] [debug] SQL: total_execution_time=0.015006065368652
[2023-11-01 21:44:52] [debug] SQL: SELECT 1 FROM [sessions] WHERE [id] = ?
[2023-11-01 21:44:52] [debug] SQL: param[1]: 'mahc5v02gai0pn9ih7084urb6b'
[2023-11-01 21:44:52] [debug] SQL: query_duration=0.0082888603210449
[2023-11-01 21:44:52] [debug] SQL: total_execution_time=0.023294925689697
[2023-11-01 21:44:52] [debug] SQL: INSERT INTO [sessions] ([id], [expire_at], [data]) VALUES (:id, :expire_at, :data)
[2023-11-01 21:44:52] [debug] SQL: param[id]: 'mahc5v02gai0pn9ih7084urb6b'
[2023-11-01 21:44:52] [debug] SQL: param[expire_at]: '1698918292'
[2023-11-01 21:44:52] [debug] SQL: param[data]: 'redirectAfterLogin|s:9:"/kanboard";'
[2023-11-01 21:44:52] [debug] SQL: query_duration=0.0017871856689453
[2023-11-01 21:44:52] [debug] SQL: total_execution_time=0.025082111358643
[2023-11-01 21:44:52] [debug] APP: nb_queries=6
[2023-11-01 21:44:52] [debug] APP: rendering_time=0.33578205108643
[2023-11-01 21:44:52] [debug] APP: memory_usage=4.86M
[2023-11-01 21:44:52] [debug] APP: uri=/kanboard
[2023-11-01 21:44:52] [debug] ###############################################
[2023-11-02 08:44:53] [debug] Kanboard\Core\Controller\Runner::executeMiddleware
[2023-11-02 08:44:53] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute
[2023-11-01 21:44:53] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\AuthenticationMiddleware
[2023-11-01 21:44:53] [debug] Kanboard\Core\Controller\Runner::executeController => \Kanboard\Controller\AuthController::login
[2023-11-01 21:44:53] [debug] SQL: SELECT TOP (1) [sessions].[data] FROM [sessions] WHERE [id] = ?
[2023-11-01 21:44:53] [debug] SQL: param[1]: 'mahc5v02gai0pn9ih7084urb6b'
[2023-11-01 21:44:53] [debug] SQL: query_duration=0.0024678707122803
[2023-11-01 21:44:53] [debug] SQL: total_execution_time=0.0024678707122803
[2023-11-01 21:44:53] [debug] SQL: SELECT [settings].[option], [settings].[value] FROM [settings]
[2023-11-01 21:44:53] [debug] SQL: query_duration=0.0013258457183838
[2023-11-01 21:44:53] [debug] SQL: total_execution_time=0.0037937164306641
[2023-11-01 21:44:53] [debug] SQL: SELECT * FROM [actions]
[2023-11-01 21:44:53] [debug] SQL: query_duration=0.0015189647674561
[2023-11-01 21:44:53] [debug] SQL: total_execution_time=0.0053126811981201
[2023-11-01 21:44:53] [debug] SQL: SELECT * FROM [action_has_params]
[2023-11-01 21:44:53] [debug] SQL: query_duration=0.0010199546813965
[2023-11-01 21:44:53] [debug] SQL: total_execution_time=0.0063326358795166
[2023-11-01 21:44:53] [debug] SQL: SELECT 1 FROM [sessions] WHERE [id] = ?
[2023-11-01 21:44:53] [debug] SQL: param[1]: 'mahc5v02gai0pn9ih7084urb6b'
[2023-11-01 21:44:53] [debug] SQL: query_duration=0.0024690628051758
[2023-11-01 21:44:53] [debug] SQL: total_execution_time=0.0088016986846924
[2023-11-01 21:44:53] [debug] SQL: UPDATE [sessions] SET [expire_at]=?, [data]=? WHERE [id] = ?
[2023-11-01 21:44:53] [debug] SQL: param[1]: '1698918293'
[2023-11-01 21:44:53] [debug] SQL: param[2]: 'redirectAfterLogin|s:9:"/kanboard";csrf_key|s:64:"b6cd5ccd36e1e9bbba8aab99bcafaaf81f967732000cdb3effcb510f47342584";'
[2023-11-01 21:44:53] [debug] SQL: param[3]: 'mahc5v02gai0pn9ih7084urb6b'
[2023-11-01 21:44:53] [debug] SQL: query_duration=0.005033016204834
[2023-11-01 21:44:53] [debug] SQL: total_execution_time=0.013834714889526
[2023-11-01 21:44:53] [debug] APP: nb_queries=6
[2023-11-01 21:44:53] [debug] APP: rendering_time=0.2277250289917
[2023-11-01 21:44:53] [debug] APP: memory_usage=5.16M
[2023-11-01 21:44:53] [debug] APP: uri=/Kanboard/?controller=AuthController&action=login
[2023-11-01 21:44:53] [debug] ###############################################
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment