2023-04-09 06:16:31.8683||DEBUG|Authentication.Program|init main function 2023-04-09 06:16:32.6007|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 06:16:32.7746|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-04-09 06:16:32.7928|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-04-09 06:16:32.7928|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-04-09 06:16:32.7928|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-04-09 06:16:32.7928|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2023-04-09 06:16:32.8168|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2023-04-09 06:16:32.8905|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2023-04-09 06:16:32.8905|59|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 2023-04-09 06:16:32.8905|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {9f90fe91-5edb-4ff3-80eb-f77883716f22} with creation date 2023-04-09 05:16:32Z, activation date 2023-04-09 05:16:32Z, and expiration date 2023-07-08 05:16:32Z. 2023-04-09 06:16:32.8905|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {9f90fe91-5edb-4ff3-80eb-f77883716f22} may be persisted to storage in unencrypted form. 2023-04-09 06:16:33.1783|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-04-09 06:16:33.2165|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-04-09 06:16:33.2165|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 06:16:33.2453|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllPermission", controller = "RolePermissionManager"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllPermissionAsync(System.String) on controller Authentication.Controllers.RolePermissionManagerController (Authentication). 2023-04-09 06:16:33.2453|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 06:16:33.2853|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 06:16:33.4174|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (6ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [p].[Id], [p].[Code], [p].[CreatedBy], [p].[DateCreated], [p].[DateModified], [p].[IsActive], [p].[IsDeleted], [p].[ModifiedBy], [p].[Name], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE ([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit)) 2023-04-09 06:16:33.4679|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.Response`1[[System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.PermissionModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 2023-04-09 06:16:33.5406|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 292.6181ms 2023-04-09 06:16:33.5406|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 06:16:33.5406|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 366.4655ms 200 application/json; charset=utf-8 2023-04-09 06:37:31.5946|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:25324/AUTHENTICATION/iisintegration 0 2023-04-09 06:37:31.5946|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.1175ms 202 2023-04-09 11:29:54.7833||DEBUG|Authentication.Program|init main function 2023-04-09 11:29:59.5560|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 11:30:00.0392|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-04-09 11:30:00.0576|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-04-09 11:30:00.0576|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-04-09 11:30:00.0576|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-04-09 11:30:00.0576|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2023-04-09 11:30:00.1398|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2023-04-09 11:30:00.3532|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2023-04-09 11:30:00.3532|59|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 2023-04-09 11:30:00.3600|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {d29689b6-7051-4c25-8d3f-ec2fa4c7e827} with creation date 2023-04-09 10:30:00Z, activation date 2023-04-09 10:30:00Z, and expiration date 2023-07-08 10:30:00Z. 2023-04-09 11:30:00.3600|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {d29689b6-7051-4c25-8d3f-ec2fa4c7e827} may be persisted to storage in unencrypted form. 2023-04-09 11:30:00.5952|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-04-09 11:30:00.6325|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-04-09 11:30:00.6325|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 11:30:00.6597|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllPermission", controller = "RolePermissionManager"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllPermissionAsync(System.String) on controller Authentication.Controllers.RolePermissionManagerController (Authentication). 2023-04-09 11:30:00.6597|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 11:30:00.6972|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 11:30:00.8283|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (6ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [p].[Id], [p].[Code], [p].[CreatedBy], [p].[DateCreated], [p].[DateModified], [p].[IsActive], [p].[IsDeleted], [p].[ModifiedBy], [p].[Name], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE ([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit)) 2023-04-09 11:30:00.8806|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.Response`1[[System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.PermissionModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 2023-04-09 11:30:00.9525|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 290.3663ms 2023-04-09 11:30:00.9525|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 11:30:00.9525|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 361.5848ms 200 application/json; charset=utf-8 2023-04-09 11:30:18.0928|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-04-09 11:30:18.0928|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-04-09 11:30:18.0928|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 11:30:18.0928|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllPermission", controller = "RolePermissionManager"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllPermissionAsync(System.String) on controller Authentication.Controllers.RolePermissionManagerController (Authentication). 2023-04-09 11:30:18.0928|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 11:30:18.0928|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 11:30:18.0928|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [p].[Id], [p].[Code], [p].[CreatedBy], [p].[DateCreated], [p].[DateModified], [p].[IsActive], [p].[IsDeleted], [p].[ModifiedBy], [p].[Name], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE ([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit)) 2023-04-09 11:30:18.0928|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.Response`1[[System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.PermissionModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 2023-04-09 11:30:18.1065|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 9.1005ms 2023-04-09 11:30:18.1065|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 11:30:18.1065|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 14.304ms 200 application/json; charset=utf-8 2023-04-09 11:50:53.6524|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:4920/AUTHENTICATION/iisintegration 0 2023-04-09 11:50:53.6524|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.1032ms 202 2023-04-09 13:16:01.5570||DEBUG|Authentication.Program|init main function 2023-04-09 13:16:02.2843|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 13:16:02.4570|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-04-09 13:16:02.4753|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-04-09 13:16:02.4753|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-04-09 13:16:02.4753|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-04-09 13:16:02.4857|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2023-04-09 13:16:02.4986|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2023-04-09 13:16:02.5728|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2023-04-09 13:16:02.5728|59|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 2023-04-09 13:16:02.5788|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {7abc9f38-3d5e-403d-b94a-a6832bf9cb18} with creation date 2023-04-09 12:16:02Z, activation date 2023-04-09 12:16:02Z, and expiration date 2023-07-08 12:16:02Z. 2023-04-09 13:16:02.5788|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {7abc9f38-3d5e-403d-b94a-a6832bf9cb18} may be persisted to storage in unencrypted form. 2023-04-09 13:16:02.8828|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-04-09 13:16:02.9191|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-04-09 13:16:02.9217|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 13:16:02.9459|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllPermission", controller = "RolePermissionManager"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllPermissionAsync(System.String) on controller Authentication.Controllers.RolePermissionManagerController (Authentication). 2023-04-09 13:16:02.9513|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 13:16:02.9828|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 13:16:03.1110|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (6ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [p].[Id], [p].[Code], [p].[CreatedBy], [p].[DateCreated], [p].[DateModified], [p].[IsActive], [p].[IsDeleted], [p].[ModifiedBy], [p].[Name], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE ([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit)) 2023-04-09 13:16:03.1594|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.Response`1[[System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.PermissionModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 2023-04-09 13:16:03.2292|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 280.9122ms 2023-04-09 13:16:03.2304|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 13:16:03.2304|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 350.4882ms 200 application/json; charset=utf-8 2023-04-09 13:16:56.5138|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-04-09 13:16:56.5175|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-04-09 13:16:56.5175|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 13:16:56.5175|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllPermission", controller = "RolePermissionManager"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllPermissionAsync(System.String) on controller Authentication.Controllers.RolePermissionManagerController (Authentication). 2023-04-09 13:16:56.5175|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 13:16:56.5175|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 13:16:56.5175|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [p].[Id], [p].[Code], [p].[CreatedBy], [p].[DateCreated], [p].[DateModified], [p].[IsActive], [p].[IsDeleted], [p].[ModifiedBy], [p].[Name], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE ([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit)) 2023-04-09 13:16:56.5175|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.Response`1[[System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.PermissionModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 2023-04-09 13:16:56.5175|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 9.3132ms 2023-04-09 13:16:56.5175|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 13:16:56.5175|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 14.6664ms 200 application/json; charset=utf-8 2023-04-09 13:17:02.1347|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-04-09 13:17:02.1382|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-04-09 13:17:02.1382|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 13:17:02.1382|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllPermission", controller = "RolePermissionManager"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllPermissionAsync(System.String) on controller Authentication.Controllers.RolePermissionManagerController (Authentication). 2023-04-09 13:17:02.1382|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 13:17:02.1382|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 13:17:02.1537|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [p].[Id], [p].[Code], [p].[CreatedBy], [p].[DateCreated], [p].[DateModified], [p].[IsActive], [p].[IsDeleted], [p].[ModifiedBy], [p].[Name], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE ([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit)) 2023-04-09 13:17:02.1537|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.Response`1[[System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.PermissionModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 2023-04-09 13:17:02.1537|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 16.4467ms 2023-04-09 13:17:02.1537|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 13:17:02.1537|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 21.9471ms 200 application/json; charset=utf-8 2023-04-09 13:25:08.2804|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-04-09 13:25:08.2804|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-04-09 13:25:08.2804|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 13:25:08.2804|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllPermission", controller = "RolePermissionManager"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllPermissionAsync(System.String) on controller Authentication.Controllers.RolePermissionManagerController (Authentication). 2023-04-09 13:25:08.2804|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 13:25:08.2804|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 13:25:08.2956|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [p].[Id], [p].[Code], [p].[CreatedBy], [p].[DateCreated], [p].[DateModified], [p].[IsActive], [p].[IsDeleted], [p].[ModifiedBy], [p].[Name], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE ([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit)) 2023-04-09 13:25:08.2956|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.Response`1[[System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.PermissionModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 2023-04-09 13:25:08.2956|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 13.8993ms 2023-04-09 13:25:08.2956|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 13:25:08.2956|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 18.1942ms 200 application/json; charset=utf-8 2023-04-09 13:30:03.2695|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-04-09 13:30:03.2695|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-04-09 13:30:03.2721|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 13:30:03.2721|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllPermission", controller = "RolePermissionManager"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllPermissionAsync(System.String) on controller Authentication.Controllers.RolePermissionManagerController (Authentication). 2023-04-09 13:30:03.2721|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 13:30:03.2721|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 13:30:03.2721|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [p].[Id], [p].[Code], [p].[CreatedBy], [p].[DateCreated], [p].[DateModified], [p].[IsActive], [p].[IsDeleted], [p].[ModifiedBy], [p].[Name], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE ([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit)) 2023-04-09 13:30:03.2721|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.Response`1[[System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.PermissionModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 2023-04-09 13:30:03.2721|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 12.6969ms 2023-04-09 13:30:03.2721|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 13:30:03.2721|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 17.3887ms 200 application/json; charset=utf-8 2023-04-09 13:31:32.6427|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/Student/Register 0 2023-04-09 13:31:32.6427|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-04-09 13:31:32.6427|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.9838ms 204 2023-04-09 13:31:32.9417|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://api.skilldorm.com/Authentication/api/Account/Student/Register application/json 174 2023-04-09 13:31:32.9417|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-04-09 13:31:33.2604|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.RegisterStudentAsync (Authentication)' 2023-04-09 13:31:33.2604|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "RegisterStudent", controller = "Account"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] RegisterStudentAsync(CommonBase.Model.StudentUser) on controller Authentication.Controllers.AccountController (Authentication). 2023-04-09 13:31:33.2604|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 13:31:34.0602|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[@__model_Country_0='?' (Size = 4000)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [c].[Id], [c].[Code1], [c].[Code2], [c].[CountryName] FROM [Countries] AS [c] WHERE [c].[Code1] = @__model_Country_0 2023-04-09 13:31:34.0718|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 13:31:34.0718|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@__email_0='?' (Size = 256), @__institutionId_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[InstitutionId], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType] FROM [AspNetUsers] AS [a] WHERE ([a].[Email] = @__email_0) AND ([a].[InstitutionId] = @__institutionId_1) 2023-04-09 13:31:34.0833|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [a].[Id], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[IsActive], [a].[Name], [a].[NormalizedName], [a].[RoleType], [a].[UpdatedBy] FROM [AspNetRoles] AS [a] WHERE [a].[Id] = @__id_0 2023-04-09 13:31:34.1176|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__normalizedUserName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[InstitutionId], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType] FROM [AspNetUsers] AS [a] WHERE [a].[NormalizedUserName] = @__normalizedUserName_0 2023-04-09 13:31:34.2247|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p0='?' (DbType = Int32), @p1='?' (Size = 4000), @p2='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p5='?' (DbType = Int64), @p6='?' (Size = 256), @p7='?' (DbType = Boolean), @p8='?' (Size = 4000), @p9='?' (DbType = Int64), @p10='?' (DbType = Boolean), @p11='?' (DbType = Boolean), @p12='?' (DbType = Boolean), @p13='?' (Size = 4000), @p14='?' (DbType = DateTime2), @p15='?' (DbType = Boolean), @p16='?' (DbType = DateTimeOffset), @p17='?' (Size = 4000), @p18='?' (Size = 256), @p19='?' (Size = 256), @p20='?' (Size = 4000), @p21='?' (Size = 4000), @p22='?' (DbType = Boolean), @p23='?' (Size = 4000), @p24='?' (DbType = Boolean), @p25='?' (DbType = Int64), @p26='?' (Size = 256), @p27='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [AspNetUsers] ([AccessFailedCount], [ConcurrencyStamp], [CreatedBy], [DateCreated], [DateUpdated], [DeletedBy], [Email], [EmailConfirmed], [FirstName], [InstitutionId], [IsActive], [IsDeleted], [IsFirstLogin], [LastName], [LastPasswordChangeDate], [LockoutEnabled], [LockoutEnd], [MiddleName], [NormalizedEmail], [NormalizedUserName], [PasswordHash], [PhoneNumber], [PhoneNumberConfirmed], [SecurityStamp], [TwoFactorEnabled], [UpdatedBy], [UserName], [UserType]) VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23, @p24, @p25, @p26, @p27); SELECT [Id], [RowVersion] FROM [AspNetUsers] WHERE @@ROWCOUNT = 1 AND [Id] = scope_identity(); 2023-04-09 13:31:34.2761|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__user_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a].[Id], [a].[ClaimType], [a].[ClaimValue], [a].[Discriminator], [a].[UserId] FROM [AspNetUserClaims] AS [a] WHERE [a].[Discriminator] IN (N'IdentityUserClaim', N'UserClaim') AND ([a].[UserId] = @__user_Id_0) 2023-04-09 13:31:34.2970|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a0].[Name] FROM [AspNetUserRoles] AS [a] INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id] WHERE [a].[Discriminator] IN (N'IdentityUserRole', N'UserRole') AND ([a].[UserId] = @__userId_0) 2023-04-09 13:31:34.3021|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.Application signed in. 2023-04-09 13:31:34.3021|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__normalizedRoleName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT TOP(2) [a].[Id], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[IsActive], [a].[Name], [a].[NormalizedName], [a].[RoleType], [a].[UpdatedBy] FROM [AspNetRoles] AS [a] WHERE [a].[NormalizedName] = @__normalizedRoleName_0 2023-04-09 13:31:34.3161|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int64), @__p_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [a].[UserId], [a].[RoleId], [a].[Discriminator] FROM [AspNetUserRoles] AS [a] WHERE [a].[Discriminator] IN (N'IdentityUserRole', N'UserRole') AND (([a].[UserId] = @__p_0) AND ([a].[RoleId] = @__p_1)) 2023-04-09 13:31:34.3161|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__normalizedRoleName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT TOP(2) [a].[Id], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[IsActive], [a].[Name], [a].[NormalizedName], [a].[RoleType], [a].[UpdatedBy] FROM [AspNetRoles] AS [a] WHERE [a].[NormalizedName] = @__normalizedRoleName_0 2023-04-09 13:31:34.3161|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__normalizedUserName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[InstitutionId], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType] FROM [AspNetUsers] AS [a] WHERE [a].[NormalizedUserName] = @__normalizedUserName_0 2023-04-09 13:31:34.3447|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p0='?' (DbType = Int64), @p1='?' (DbType = Int64), @p2='?' (Size = 4000)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [AspNetUserRoles] ([UserId], [RoleId], [Discriminator]) VALUES (@p0, @p1, @p2); 2023-04-09 13:31:34.3481|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p28='?' (DbType = Int64), @p0='?' (DbType = Int32), @p1='?' (Size = 4000), @p29='?' (Size = 4000), @p2='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p5='?' (DbType = Int64), @p6='?' (Size = 256), @p7='?' (DbType = Boolean), @p8='?' (Size = 4000), @p9='?' (DbType = Int64), @p10='?' (DbType = Boolean), @p11='?' (DbType = Boolean), @p12='?' (DbType = Boolean), @p13='?' (Size = 4000), @p14='?' (DbType = DateTime2), @p15='?' (DbType = Boolean), @p16='?' (DbType = DateTimeOffset), @p17='?' (Size = 4000), @p18='?' (Size = 256), @p19='?' (Size = 256), @p20='?' (Size = 4000), @p21='?' (Size = 4000), @p22='?' (DbType = Boolean), @p30='?' (Size = 8) (DbType = Binary), @p23='?' (Size = 4000), @p24='?' (DbType = Boolean), @p25='?' (DbType = Int64), @p26='?' (Size = 256), @p27='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; UPDATE [AspNetUsers] SET [AccessFailedCount] = @p0, [ConcurrencyStamp] = @p1, [CreatedBy] = @p2, [DateCreated] = @p3, [DateUpdated] = @p4, [DeletedBy] = @p5, [Email] = @p6, [EmailConfirmed] = @p7, [FirstName] = @p8, [InstitutionId] = @p9, [IsActive] = @p10, [IsDeleted] = @p11, [IsFirstLogin] = @p12, [LastName] = @p13, [LastPasswordChangeDate] = @p14, [LockoutEnabled] = @p15, [LockoutEnd] = @p16, [MiddleName] = @p17, [NormalizedEmail] = @p18, [NormalizedUserName] = @p19, [PasswordHash] = @p20, [PhoneNumber] = @p21, [PhoneNumberConfirmed] = @p22, [SecurityStamp] = @p23, [TwoFactorEnabled] = @p24, [UpdatedBy] = @p25, [UserName] = @p26, [UserType] = @p27 WHERE [Id] = @p28 AND [ConcurrencyStamp] = @p29 AND [RowVersion] = @p30; SELECT [RowVersion] FROM [AspNetUsers] WHERE @@ROWCOUNT = 1 AND [Id] = @p28; 2023-04-09 13:31:34.5873||WARN|Authentication.Controllers.AccountController|student created Oyindamola 2023-04-09 13:31:34.5873||DEBUG|Authentication.Controllers.AccountController|Login Url : 2023-04-09 13:31:34.6150|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p0='?' (Size = 4000), @p1='?' (Size = 4000), @p2='?' (Size = 4000), @p3='?' (Size = 4000), @p4='?' (Size = 4000), @p5='?' (DbType = Int64), @p6='?' (DbType = DateTime2), @p7='?' (DbType = DateTime2), @p8='?' (Size = 4000), @p9='?' (Size = 4000), @p10='?' (DbType = Boolean), @p11='?' (DbType = Boolean), @p12='?' (Size = 4000), @p13='?' (Size = 4000), @p14='?' (DbType = Int64), @p15='?' (Size = 4000), @p16='?' (Size = 4000), @p17='?' (Size = 4000), @p18='?' (DbType = Int64), @p19='?' (Size = 4000), @p20='?' (Size = 4000)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [Students] ([Address1], [Address2], [Age], [Biography], [Country], [CreatedBy], [DateCreated], [DateModified], [FaceBook], [Headline], [IsActive], [IsDeleted], [JobTitle], [LinkedIn], [ModifiedBy], [Organization], [ProfilePixUrl], [Twitter], [UserId], [Website], [YouTube]) VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20); SELECT [Id] FROM [Students] WHERE @@ROWCOUNT = 1 AND [Id] = scope_identity(); 2023-04-09 13:31:34.6150||WARN|Authentication.Core.Services.GoogleService|appendRequest= {"majorDimension":null,"range":null,"values":[["fowobioyinx@gmail.com","Oyindamola","Olufowobi"]],"ETag":null}, sheetID ="1oTZ1hfTRq_kX45J0_zA2vxVqddGZ166HHuYeO31LaPA", range ="newlyRegisteredUsers!A1:C" 2023-04-09 13:31:34.6150||WARN|Authentication.Core.Services.GoogleService|valueInputeOption= USERENTERED 2023-04-09 13:31:35.6103||WARN|Authentication.Core.Services.GoogleService|Googlesheet response= {"spreadsheetId":"1oTZ1hfTRq_kX45J0_zA2vxVqddGZ166HHuYeO31LaPA","tableRange":"newlyRegisteredUsers!A1:C312","updates":{"spreadsheetId":"1oTZ1hfTRq_kX45J0_zA2vxVqddGZ166HHuYeO31LaPA","updatedCells":3,"updatedColumns":3,"updatedData":null,"updatedRange":"newlyRegisteredUsers!A313:C313","updatedRows":1,"ETag":null},"ETag":null} 2023-04-09 13:31:35.6103||WARN|Authentication.Controllers.AccountController|About to send Email. 2023-04-09 13:31:35.6131||WARN|Authentication.Data.Utility.Email.EmailUtilityService|Url Token : {url} 2023-04-09 13:31:35.6131||WARN|Authentication.Data.Utility.Email.EmailUtilityService|Url: https://api.skilldorm.com/Notification/ 2023-04-09 13:31:35.6131||WARN|Authentication.Data.Utility.Email.EmailUtilityService|EndPoint: api/Email/Send 2023-04-09 13:31:35.8549||WARN|Authentication.Data.Utility.Email.EmailUtilityService|Response from Notification Service: {"data":null,"code":"00","success":true,"description":"Success"} 2023-04-09 13:31:35.8549||WARN|Authentication.Data.Utility.Email.EmailUtilityService|Response from Notification Service: OK--OK--(null) 2023-04-09 13:31:35.8605||WARN|Authentication.Controllers.AccountController|Done sending Email. 2023-04-09 13:31:35.8605|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2023-04-09 13:31:35.8605|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.RegisterStudentAsync (Authentication) in 2597.6129ms 2023-04-09 13:31:35.8605|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.RegisterStudentAsync (Authentication)' 2023-04-09 13:31:35.8605|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2922.147ms 200 application/json; charset=utf-8 2023-04-09 13:31:36.3593|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-04-09 13:31:36.3593|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-04-09 13:31:36.3593|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 13:31:36.3616|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllPermission", controller = "RolePermissionManager"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllPermissionAsync(System.String) on controller Authentication.Controllers.RolePermissionManagerController (Authentication). 2023-04-09 13:31:36.3616|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 13:31:36.3616|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 13:31:36.3616|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [p].[Id], [p].[Code], [p].[CreatedBy], [p].[DateCreated], [p].[DateModified], [p].[IsActive], [p].[IsDeleted], [p].[ModifiedBy], [p].[Name], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE ([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit)) 2023-04-09 13:31:36.3616|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.Response`1[[System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.PermissionModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 2023-04-09 13:31:36.3616|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 8.2686ms 2023-04-09 13:31:36.3616|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 13:31:36.3616|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 11.6735ms 200 application/json; charset=utf-8 2023-04-09 13:34:48.2027|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-04-09 13:34:48.2027|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-04-09 13:34:48.2027|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 13:34:48.2027|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllPermission", controller = "RolePermissionManager"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllPermissionAsync(System.String) on controller Authentication.Controllers.RolePermissionManagerController (Authentication). 2023-04-09 13:34:48.2057|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 13:34:48.2057|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 13:34:48.2057|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [p].[Id], [p].[Code], [p].[CreatedBy], [p].[DateCreated], [p].[DateModified], [p].[IsActive], [p].[IsDeleted], [p].[ModifiedBy], [p].[Name], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE ([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit)) 2023-04-09 13:34:48.2057|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.Response`1[[System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.PermissionModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 2023-04-09 13:34:48.2057|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 5.2379ms 2023-04-09 13:34:48.2057|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 13:34:48.2057|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 7.8465ms 200 application/json; charset=utf-8 2023-04-09 13:35:34.6876|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-04-09 13:35:34.6888|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-04-09 13:35:34.6888|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 13:35:34.6888|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllPermission", controller = "RolePermissionManager"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllPermissionAsync(System.String) on controller Authentication.Controllers.RolePermissionManagerController (Authentication). 2023-04-09 13:35:34.6888|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 13:35:34.6888|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 13:35:34.6888|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [p].[Id], [p].[Code], [p].[CreatedBy], [p].[DateCreated], [p].[DateModified], [p].[IsActive], [p].[IsDeleted], [p].[ModifiedBy], [p].[Name], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE ([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit)) 2023-04-09 13:35:34.6888|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.Response`1[[System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.PermissionModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 2023-04-09 13:35:34.6888|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 5.6698ms 2023-04-09 13:35:34.6888|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 13:35:34.6888|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 8.6971ms 200 application/json; charset=utf-8 2023-04-09 13:35:38.0578|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/Student/SignIn 0 2023-04-09 13:35:38.0578|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-04-09 13:35:38.0578|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.3571ms 204 2023-04-09 13:35:47.0029|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://api.skilldorm.com/Authentication/api/Account/Student/SignIn application/json 64 2023-04-09 13:35:47.0029|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-04-09 13:35:47.0029|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 2023-04-09 13:35:47.0029|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "StudentSignIn", controller = "Account"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] StudentSignIn(Authentication.Data.Models.Identity.AuthBindingModel) on controller Authentication.Controllers.AccountController (Authentication). 2023-04-09 13:35:47.0029|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 13:35:47.0281|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__ToLower_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[InstitutionId], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType] FROM [AspNetUsers] AS [a] WHERE LOWER([a].[UserName]) = @__ToLower_0 2023-04-09 13:35:47.0281|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 13:35:47.0305|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__normalizedUserName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[InstitutionId], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType] FROM [AspNetUsers] AS [a] WHERE [a].[NormalizedUserName] = @__normalizedUserName_0 2023-04-09 13:35:47.0305|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__user_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a].[Id], [a].[ClaimType], [a].[ClaimValue], [a].[Discriminator], [a].[UserId] FROM [AspNetUserClaims] AS [a] WHERE [a].[Discriminator] IN (N'IdentityUserClaim', N'UserClaim') AND ([a].[UserId] = @__user_Id_0) 2023-04-09 13:35:47.0305|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a0].[Name] FROM [AspNetUserRoles] AS [a] INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id] WHERE [a].[Discriminator] IN (N'IdentityUserRole', N'UserRole') AND ([a].[UserId] = @__userId_0) 2023-04-09 13:35:47.0305|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__normalizedName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [a].[Id], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[IsActive], [a].[Name], [a].[NormalizedName], [a].[RoleType], [a].[UpdatedBy] FROM [AspNetRoles] AS [a] WHERE [a].[NormalizedName] = @__normalizedName_0 2023-04-09 13:35:47.0482|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__role_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a].[ClaimType], [a].[ClaimValue] FROM [AspNetRoleClaims] AS [a] WHERE [a].[RoleId] = @__role_Id_0 2023-04-09 13:35:47.0482|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.Application signed in. 2023-04-09 13:35:47.0482|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userInfo_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [s].[Id], [s].[Address1], [s].[Address2], [s].[Age], [s].[Biography], [s].[Country], [s].[CreatedBy], [s].[DateCreated], [s].[DateModified], [s].[FaceBook], [s].[Headline], [s].[IsActive], [s].[IsDeleted], [s].[JobTitle], [s].[LinkedIn], [s].[ModifiedBy], [s].[Organization], [s].[ProfilePixUrl], [s].[Twitter], [s].[UserId], [s].[Website], [s].[YouTube] FROM [Students] AS [s] WHERE [s].[UserId] = @__userInfo_Id_0 2023-04-09 13:35:47.0482|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__userId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a0].[Name] FROM [AspNetUserRoles] AS [a] INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id] WHERE [a].[Discriminator] IN (N'IdentityUserRole', N'UserRole') AND ([a].[UserId] = @__userId_0) 2023-04-09 13:35:47.0482||WARN|Authentication.Controllers.AccountController|Role is STUDENT 2023-04-09 13:35:47.0482|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__get_Item_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT [p].[Code] FROM [RolePermissions] AS [r] INNER JOIN [AspNetRoles] AS [a] ON [r].[RoleId] = [a].[Id] INNER JOIN [Permissions] AS [p] ON [r].[PermissionId] = [p].[Id] WHERE [a].[Name] = @__get_Item_0 2023-04-09 13:35:47.2257|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p0='?' (DbType = DateTime2), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Size = 4000), @p4='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [UserToken] ([DateCreated], [ExpiryDate], [IsActive], [Token], [UserId]) VALUES (@p0, @p1, @p2, @p3, @p4); SELECT [Id] FROM [UserToken] WHERE @@ROWCOUNT = 1 AND [Id] = scope_identity(); 2023-04-09 13:35:47.2257|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a0].[Name] FROM [AspNetUserRoles] AS [a] INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id] WHERE [a].[Discriminator] IN (N'IdentityUserRole', N'UserRole') AND ([a].[UserId] = @__userId_0) 2023-04-09 13:35:47.2257||INFO|Authentication.Controllers.AccountController|user: fowobioyinx@gmail.com - Oyindamola Olufowobi role is gotten 2023-04-09 13:35:47.2257|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userInfo_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [s].[ProfilePixUrl] FROM [Students] AS [s] WHERE [s].[UserId] = @__userInfo_Id_0 2023-04-09 13:35:47.2675|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2023-04-09 13:35:47.2675|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.StudentSignIn (Authentication) in 260.935ms 2023-04-09 13:35:47.2675|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 2023-04-09 13:35:47.2675|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 269.3453ms 200 application/json; charset=utf-8 2023-04-09 13:52:41.0853|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-04-09 13:52:41.0853|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-04-09 13:52:41.0853|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 13:52:41.0853|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllPermission", controller = "RolePermissionManager"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllPermissionAsync(System.String) on controller Authentication.Controllers.RolePermissionManagerController (Authentication). 2023-04-09 13:52:41.0853|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 13:52:41.0853|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 13:52:41.0853|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [p].[Id], [p].[Code], [p].[CreatedBy], [p].[DateCreated], [p].[DateModified], [p].[IsActive], [p].[IsDeleted], [p].[ModifiedBy], [p].[Name], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE ([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit)) 2023-04-09 13:52:41.0853|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.Response`1[[System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.PermissionModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 2023-04-09 13:52:41.0853|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 8.8279ms 2023-04-09 13:52:41.0853|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 13:52:41.0853|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 11.3588ms 200 application/json; charset=utf-8 2023-04-09 13:53:57.6796|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-04-09 13:53:57.6796|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-04-09 13:53:57.6796|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 13:53:57.6796|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllPermission", controller = "RolePermissionManager"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllPermissionAsync(System.String) on controller Authentication.Controllers.RolePermissionManagerController (Authentication). 2023-04-09 13:53:57.6796|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 13:53:57.6796|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 13:53:57.6796|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [p].[Id], [p].[Code], [p].[CreatedBy], [p].[DateCreated], [p].[DateModified], [p].[IsActive], [p].[IsDeleted], [p].[ModifiedBy], [p].[Name], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE ([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit)) 2023-04-09 13:53:57.6796|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.Response`1[[System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.PermissionModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 2023-04-09 13:53:57.6796|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 4.6954ms 2023-04-09 13:53:57.6796|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 13:53:57.6796|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 6.9264ms 200 application/json; charset=utf-8 2023-04-09 13:53:59.5983|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/Student/SignIn 2023-04-09 13:53:59.5983|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-04-09 13:53:59.5983|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.1704ms 204 2023-04-09 13:54:00.0994|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://api.skilldorm.com/Authentication/api/Account/Student/SignIn application/json 64 2023-04-09 13:54:00.0994|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-04-09 13:54:00.0994|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 2023-04-09 13:54:00.0994|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "StudentSignIn", controller = "Account"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] StudentSignIn(Authentication.Data.Models.Identity.AuthBindingModel) on controller Authentication.Controllers.AccountController (Authentication). 2023-04-09 13:54:00.0994|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 13:54:00.0994|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__ToLower_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[InstitutionId], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType] FROM [AspNetUsers] AS [a] WHERE LOWER([a].[UserName]) = @__ToLower_0 2023-04-09 13:54:00.0994|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 13:54:00.0994|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__normalizedUserName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[InstitutionId], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType] FROM [AspNetUsers] AS [a] WHERE [a].[NormalizedUserName] = @__normalizedUserName_0 2023-04-09 13:54:00.1158|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__user_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a].[Id], [a].[ClaimType], [a].[ClaimValue], [a].[Discriminator], [a].[UserId] FROM [AspNetUserClaims] AS [a] WHERE [a].[Discriminator] IN (N'IdentityUserClaim', N'UserClaim') AND ([a].[UserId] = @__user_Id_0) 2023-04-09 13:54:00.1158|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__userId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a0].[Name] FROM [AspNetUserRoles] AS [a] INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id] WHERE [a].[Discriminator] IN (N'IdentityUserRole', N'UserRole') AND ([a].[UserId] = @__userId_0) 2023-04-09 13:54:00.1158|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__normalizedName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [a].[Id], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[IsActive], [a].[Name], [a].[NormalizedName], [a].[RoleType], [a].[UpdatedBy] FROM [AspNetRoles] AS [a] WHERE [a].[NormalizedName] = @__normalizedName_0 2023-04-09 13:54:00.1158|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__role_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a].[ClaimType], [a].[ClaimValue] FROM [AspNetRoleClaims] AS [a] WHERE [a].[RoleId] = @__role_Id_0 2023-04-09 13:54:00.1158|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.Application signed in. 2023-04-09 13:54:00.1158|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__userInfo_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [s].[Id], [s].[Address1], [s].[Address2], [s].[Age], [s].[Biography], [s].[Country], [s].[CreatedBy], [s].[DateCreated], [s].[DateModified], [s].[FaceBook], [s].[Headline], [s].[IsActive], [s].[IsDeleted], [s].[JobTitle], [s].[LinkedIn], [s].[ModifiedBy], [s].[Organization], [s].[ProfilePixUrl], [s].[Twitter], [s].[UserId], [s].[Website], [s].[YouTube] FROM [Students] AS [s] WHERE [s].[UserId] = @__userInfo_Id_0 2023-04-09 13:54:00.1158|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__userId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a0].[Name] FROM [AspNetUserRoles] AS [a] INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id] WHERE [a].[Discriminator] IN (N'IdentityUserRole', N'UserRole') AND ([a].[UserId] = @__userId_0) 2023-04-09 13:54:00.1158||WARN|Authentication.Controllers.AccountController|Role is STUDENT 2023-04-09 13:54:00.1158|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__get_Item_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT [p].[Code] FROM [RolePermissions] AS [r] INNER JOIN [AspNetRoles] AS [a] ON [r].[RoleId] = [a].[Id] INNER JOIN [Permissions] AS [p] ON [r].[PermissionId] = [p].[Id] WHERE [a].[Name] = @__get_Item_0 2023-04-09 13:54:00.1158|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@p0='?' (DbType = DateTime2), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Size = 4000), @p4='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [UserToken] ([DateCreated], [ExpiryDate], [IsActive], [Token], [UserId]) VALUES (@p0, @p1, @p2, @p3, @p4); SELECT [Id] FROM [UserToken] WHERE @@ROWCOUNT = 1 AND [Id] = scope_identity(); 2023-04-09 13:54:00.1158|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__userId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a0].[Name] FROM [AspNetUserRoles] AS [a] INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id] WHERE [a].[Discriminator] IN (N'IdentityUserRole', N'UserRole') AND ([a].[UserId] = @__userId_0) 2023-04-09 13:54:00.1158||INFO|Authentication.Controllers.AccountController|user: fowobioyinx@gmail.com - Oyindamola Olufowobi role is gotten 2023-04-09 13:54:00.1302|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__userInfo_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [s].[ProfilePixUrl] FROM [Students] AS [s] WHERE [s].[UserId] = @__userInfo_Id_0 2023-04-09 13:54:00.1577|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2023-04-09 13:54:00.1577|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.StudentSignIn (Authentication) in 56.8075ms 2023-04-09 13:54:00.1577|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 2023-04-09 13:54:00.1577|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 59.6805ms 200 application/json; charset=utf-8 2023-04-09 14:46:35.0689|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-04-09 14:46:35.0689|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-04-09 14:46:35.0689|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 14:46:35.0689|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllPermission", controller = "RolePermissionManager"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllPermissionAsync(System.String) on controller Authentication.Controllers.RolePermissionManagerController (Authentication). 2023-04-09 14:46:35.0689|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 14:46:35.0689|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 14:46:35.0772|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [p].[Id], [p].[Code], [p].[CreatedBy], [p].[DateCreated], [p].[DateModified], [p].[IsActive], [p].[IsDeleted], [p].[ModifiedBy], [p].[Name], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE ([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit)) 2023-04-09 14:46:35.0772|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.Response`1[[System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.PermissionModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 2023-04-09 14:46:35.0772|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 8.3659ms 2023-04-09 14:46:35.0772|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 14:46:35.0772|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 10.5403ms 200 application/json; charset=utf-8 2023-04-09 14:51:04.5407|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-04-09 14:51:04.5407|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-04-09 14:51:04.5407|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 14:51:04.5407|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllPermission", controller = "RolePermissionManager"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllPermissionAsync(System.String) on controller Authentication.Controllers.RolePermissionManagerController (Authentication). 2023-04-09 14:51:04.5407|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 14:51:04.5407|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 14:51:04.5407|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [p].[Id], [p].[Code], [p].[CreatedBy], [p].[DateCreated], [p].[DateModified], [p].[IsActive], [p].[IsDeleted], [p].[ModifiedBy], [p].[Name], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE ([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit)) 2023-04-09 14:51:04.5407|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.Response`1[[System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.PermissionModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 2023-04-09 14:51:04.5407|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 4.2461ms 2023-04-09 14:51:04.5407|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 14:51:04.5407|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 6.2644ms 200 application/json; charset=utf-8 2023-04-09 16:22:02.3401|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:46185/AUTHENTICATION/iisintegration 0 2023-04-09 16:22:02.3401|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.4242ms 202 2023-04-09 20:52:03.6729||DEBUG|Authentication.Program|init main function 2023-04-09 20:52:07.8466|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 20:52:08.3350|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-04-09 20:52:08.3532|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-04-09 20:52:08.3532|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-04-09 20:52:08.3532|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-04-09 20:52:08.3532|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2023-04-09 20:52:08.4361|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2023-04-09 20:52:08.6521|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2023-04-09 20:52:08.6521|59|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 2023-04-09 20:52:08.6615|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {a03dff15-4a52-44fc-bcf8-6f7ceecf6838} with creation date 2023-04-09 19:52:08Z, activation date 2023-04-09 19:52:08Z, and expiration date 2023-07-08 19:52:08Z. 2023-04-09 20:52:08.6615|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {a03dff15-4a52-44fc-bcf8-6f7ceecf6838} may be persisted to storage in unencrypted form. 2023-04-09 20:52:08.7421|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-04-09 20:52:08.7798|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-04-09 20:52:08.7798|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 20:52:08.8097|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllPermission", controller = "RolePermissionManager"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllPermissionAsync(System.String) on controller Authentication.Controllers.RolePermissionManagerController (Authentication). 2023-04-09 20:52:08.8097|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 20:52:08.8471|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 20:52:08.9766|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (6ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [p].[Id], [p].[Code], [p].[CreatedBy], [p].[DateCreated], [p].[DateModified], [p].[IsActive], [p].[IsDeleted], [p].[ModifiedBy], [p].[Name], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE ([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit)) 2023-04-09 20:52:09.0260|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.Response`1[[System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.PermissionModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 2023-04-09 20:52:09.0972|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 284.8175ms 2023-04-09 20:52:09.0972|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 20:52:09.1008|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 359.3366ms 200 application/json; charset=utf-8 2023-04-09 21:01:39.9122|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-04-09 21:01:39.9122|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-04-09 21:01:39.9122|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 21:01:39.9122|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllPermission", controller = "RolePermissionManager"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllPermissionAsync(System.String) on controller Authentication.Controllers.RolePermissionManagerController (Authentication). 2023-04-09 21:01:39.9122|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 21:01:39.9210|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 21:01:39.9210|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [p].[Id], [p].[Code], [p].[CreatedBy], [p].[DateCreated], [p].[DateModified], [p].[IsActive], [p].[IsDeleted], [p].[ModifiedBy], [p].[Name], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE ([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit)) 2023-04-09 21:01:39.9210|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.Response`1[[System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.PermissionModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 2023-04-09 21:01:39.9210|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 14.8414ms 2023-04-09 21:01:39.9210|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 21:01:39.9210|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 21.6125ms 200 application/json; charset=utf-8 2023-04-09 21:22:02.6467|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:41863/AUTHENTICATION/iisintegration 0 2023-04-09 21:22:02.6467|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.0074ms 202 2023-04-09 21:33:57.7810||DEBUG|Authentication.Program|init main function 2023-04-09 21:33:58.4961|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 21:33:58.6704|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-04-09 21:33:58.6887|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-04-09 21:33:58.6887|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-04-09 21:33:58.6887|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-04-09 21:33:58.6992|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2023-04-09 21:33:58.6992|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2023-04-09 21:33:58.7869|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2023-04-09 21:33:58.7869|59|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 2023-04-09 21:33:58.7930|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {9ab18709-1195-4431-bcad-f0ff21dc4ffc} with creation date 2023-04-09 20:33:58Z, activation date 2023-04-09 20:33:58Z, and expiration date 2023-07-08 20:33:58Z. 2023-04-09 21:33:58.7930|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {9ab18709-1195-4431-bcad-f0ff21dc4ffc} may be persisted to storage in unencrypted form. 2023-04-09 21:33:58.8566|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-04-09 21:33:58.8922|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-04-09 21:33:58.8922|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 21:33:58.9187|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllPermission", controller = "RolePermissionManager"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllPermissionAsync(System.String) on controller Authentication.Controllers.RolePermissionManagerController (Authentication). 2023-04-09 21:33:58.9187|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 21:33:58.9561|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 21:33:59.0853|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (6ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [p].[Id], [p].[Code], [p].[CreatedBy], [p].[DateCreated], [p].[DateModified], [p].[IsActive], [p].[IsDeleted], [p].[ModifiedBy], [p].[Name], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE ([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit)) 2023-04-09 21:33:59.1348|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.Response`1[[System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.PermissionModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 2023-04-09 21:33:59.2057|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 284.365ms 2023-04-09 21:33:59.2057|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 21:33:59.2093|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 353.1639ms 200 application/json; charset=utf-8 2023-04-09 21:54:55.8454|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:30019/AUTHENTICATION/iisintegration 0 2023-04-09 21:54:55.8454|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.0554ms 202 2023-04-09 22:47:42.5669||DEBUG|Authentication.Program|init main function 2023-04-09 22:47:43.2873|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 22:47:43.4616|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-04-09 22:47:43.4801|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-04-09 22:47:43.4801|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-04-09 22:47:43.4801|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-04-09 22:47:43.4906|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2023-04-09 22:47:43.5033|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2023-04-09 22:47:43.5776|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2023-04-09 22:47:43.5782|59|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 2023-04-09 22:47:43.5782|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {f5f4393e-2dd9-45fd-ab37-801cee3bef83} with creation date 2023-04-09 21:47:43Z, activation date 2023-04-09 21:47:43Z, and expiration date 2023-07-08 21:47:43Z. 2023-04-09 22:47:43.5782|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {f5f4393e-2dd9-45fd-ab37-801cee3bef83} may be persisted to storage in unencrypted form. 2023-04-09 22:47:43.8928|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-04-09 22:47:43.9295|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-04-09 22:47:43.9295|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 22:47:43.9565|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllPermission", controller = "RolePermissionManager"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllPermissionAsync(System.String) on controller Authentication.Controllers.RolePermissionManagerController (Authentication). 2023-04-09 22:47:43.9565|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 22:47:43.9940|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 22:47:44.1234|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (6ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [p].[Id], [p].[Code], [p].[CreatedBy], [p].[DateCreated], [p].[DateModified], [p].[IsActive], [p].[IsDeleted], [p].[ModifiedBy], [p].[Name], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE ([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit)) 2023-04-09 22:47:44.1733|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.Response`1[[System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.PermissionModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 2023-04-09 22:47:44.2444|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 285.4344ms 2023-04-09 22:47:44.2444|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 22:47:44.2444|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 355.7961ms 200 application/json; charset=utf-8 2023-04-09 23:08:40.6304|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:11076/AUTHENTICATION/iisintegration 0 2023-04-09 23:08:40.6304|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.0633ms 202 2023-04-09 23:13:28.4612||DEBUG|Authentication.Program|init main function 2023-04-09 23:13:29.2360|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 23:13:29.4357|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (14ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-04-09 23:13:29.4586|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (15ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-04-09 23:13:29.4586|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-04-09 23:13:29.4586|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-04-09 23:13:29.4712|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2023-04-09 23:13:29.4872|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2023-04-09 23:13:29.5651|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2023-04-09 23:13:29.5651|59|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 2023-04-09 23:13:29.5651|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {5a10f170-9106-40c1-9f2c-56281215e48c} with creation date 2023-04-09 22:13:29Z, activation date 2023-04-09 22:13:29Z, and expiration date 2023-07-08 22:13:29Z. 2023-04-09 23:13:29.5787|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {5a10f170-9106-40c1-9f2c-56281215e48c} may be persisted to storage in unencrypted form. 2023-04-09 23:13:29.7811|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-04-09 23:13:29.8190|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-04-09 23:13:29.8190|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 23:13:29.8582|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllPermission", controller = "RolePermissionManager"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllPermissionAsync(System.String) on controller Authentication.Controllers.RolePermissionManagerController (Authentication). 2023-04-09 23:13:29.8652|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 23:13:29.8980|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 23:13:30.0304|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (6ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [p].[Id], [p].[Code], [p].[CreatedBy], [p].[DateCreated], [p].[DateModified], [p].[IsActive], [p].[IsDeleted], [p].[ModifiedBy], [p].[Name], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE ([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit)) 2023-04-09 23:13:30.0809|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.Response`1[[System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.PermissionModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 2023-04-09 23:13:30.1570|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 296.049ms 2023-04-09 23:13:30.1570|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 23:13:30.1570|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 380.0398ms 200 application/json; charset=utf-8 2023-04-09 23:13:35.6350|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/Student/SignIn 2023-04-09 23:13:35.6375|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-04-09 23:13:35.6375|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 3.3063ms 204 2023-04-09 23:13:36.0117|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://api.skilldorm.com/Authentication/api/Account/Student/SignIn application/json 61 2023-04-09 23:13:36.0170|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-04-09 23:13:36.3397|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 2023-04-09 23:13:36.3447|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "StudentSignIn", controller = "Account"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] StudentSignIn(Authentication.Data.Models.Identity.AuthBindingModel) on controller Authentication.Controllers.AccountController (Authentication). 2023-04-09 23:13:36.3447|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 23:13:36.9682|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[@__ToLower_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[InstitutionId], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType] FROM [AspNetUsers] AS [a] WHERE LOWER([a].[UserName]) = @__ToLower_0 2023-04-09 23:13:37.0015|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 23:13:37.0015|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__normalizedUserName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[InstitutionId], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType] FROM [AspNetUsers] AS [a] WHERE [a].[NormalizedUserName] = @__normalizedUserName_0 2023-04-09 23:13:37.0353|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__user_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a].[Id], [a].[ClaimType], [a].[ClaimValue], [a].[Discriminator], [a].[UserId] FROM [AspNetUserClaims] AS [a] WHERE [a].[Discriminator] IN (N'IdentityUserClaim', N'UserClaim') AND ([a].[UserId] = @__user_Id_0) 2023-04-09 23:13:37.0579|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a0].[Name] FROM [AspNetUserRoles] AS [a] INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id] WHERE [a].[Discriminator] IN (N'IdentityUserRole', N'UserRole') AND ([a].[UserId] = @__userId_0) 2023-04-09 23:13:37.0636|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__normalizedName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [a].[Id], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[IsActive], [a].[Name], [a].[NormalizedName], [a].[RoleType], [a].[UpdatedBy] FROM [AspNetRoles] AS [a] WHERE [a].[NormalizedName] = @__normalizedName_0 2023-04-09 23:13:37.0636|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__role_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a].[ClaimType], [a].[ClaimValue] FROM [AspNetRoleClaims] AS [a] WHERE [a].[RoleId] = @__role_Id_0 2023-04-09 23:13:37.0807|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.Application signed in. 2023-04-09 23:13:37.0807|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userInfo_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [s].[Id], [s].[Address1], [s].[Address2], [s].[Age], [s].[Biography], [s].[Country], [s].[CreatedBy], [s].[DateCreated], [s].[DateModified], [s].[FaceBook], [s].[Headline], [s].[IsActive], [s].[IsDeleted], [s].[JobTitle], [s].[LinkedIn], [s].[ModifiedBy], [s].[Organization], [s].[ProfilePixUrl], [s].[Twitter], [s].[UserId], [s].[Website], [s].[YouTube] FROM [Students] AS [s] WHERE [s].[UserId] = @__userInfo_Id_0 2023-04-09 23:13:37.0994|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a0].[Name] FROM [AspNetUserRoles] AS [a] INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id] WHERE [a].[Discriminator] IN (N'IdentityUserRole', N'UserRole') AND ([a].[UserId] = @__userId_0) 2023-04-09 23:13:37.0994||WARN|Authentication.Controllers.AccountController|Role is STUDENT 2023-04-09 23:13:37.0994|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__get_Item_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT [p].[Code] FROM [RolePermissions] AS [r] INNER JOIN [AspNetRoles] AS [a] ON [r].[RoleId] = [a].[Id] INNER JOIN [Permissions] AS [p] ON [r].[PermissionId] = [p].[Id] WHERE [a].[Name] = @__get_Item_0 2023-04-09 23:13:37.3434|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p0='?' (DbType = DateTime2), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Size = 4000), @p4='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [UserToken] ([DateCreated], [ExpiryDate], [IsActive], [Token], [UserId]) VALUES (@p0, @p1, @p2, @p3, @p4); SELECT [Id] FROM [UserToken] WHERE @@ROWCOUNT = 1 AND [Id] = scope_identity(); 2023-04-09 23:13:37.3653|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a0].[Name] FROM [AspNetUserRoles] AS [a] INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id] WHERE [a].[Discriminator] IN (N'IdentityUserRole', N'UserRole') AND ([a].[UserId] = @__userId_0) 2023-04-09 23:13:37.3653||INFO|Authentication.Controllers.AccountController|user: bolajimikky@gmail.com - Bolaji Mikky role is gotten 2023-04-09 23:13:37.3653|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userInfo_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [s].[ProfilePixUrl] FROM [Students] AS [s] WHERE [s].[UserId] = @__userInfo_Id_0 2023-04-09 23:13:38.1981|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2023-04-09 23:13:38.2043|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.StudentSignIn (Authentication) in 1859.2946ms 2023-04-09 23:13:38.2043|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 2023-04-09 23:13:38.2043|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2193.4837ms 200 application/json; charset=utf-8 2023-04-09 23:13:45.8413|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-04-09 23:13:45.8452|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-04-09 23:13:45.8452|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 23:13:45.8452|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllPermission", controller = "RolePermissionManager"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllPermissionAsync(System.String) on controller Authentication.Controllers.RolePermissionManagerController (Authentication). 2023-04-09 23:13:45.8452|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 23:13:45.8622|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 23:13:45.8622|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [p].[Id], [p].[Code], [p].[CreatedBy], [p].[DateCreated], [p].[DateModified], [p].[IsActive], [p].[IsDeleted], [p].[ModifiedBy], [p].[Name], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE ([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit)) 2023-04-09 23:13:45.8622|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.Response`1[[System.Collections.Generic.List`1[[Authentication.Data.Models.Identity.PermissionModel, Authentication.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 2023-04-09 23:13:45.8622|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 19.9486ms 2023-04-09 23:13:45.8622|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-04-09 23:13:45.8622|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 26.714ms 200 application/json; charset=utf-8 2023-04-09 23:14:08.2832|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/Account/GoogleLogin 2023-04-09 23:14:08.2832|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.GoogleLogin (Authentication)' 2023-04-09 23:14:08.2832|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GoogleLogin", controller = "Account"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult GoogleLogin() on controller Authentication.Controllers.AccountController (Authentication). 2023-04-09 23:14:08.2832|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 23:14:08.3074|1|INFO|Microsoft.AspNetCore.Mvc.ChallengeResult|Executing ChallengeResult with authentication schemes (Google). 2023-04-09 23:14:08.3074|12|INFO|Microsoft.AspNetCore.Authentication.Google.GoogleHandler|AuthenticationScheme: Google was challenged. 2023-04-09 23:14:08.3074|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.GoogleLogin (Authentication) in 21.8745ms 2023-04-09 23:14:08.3074|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.GoogleLogin (Authentication)' 2023-04-09 23:14:08.3113|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 28.15ms 302 2023-04-09 23:14:13.7287|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/signin-google?state=CfDJ8HDxEFoGkcFAnyxWKBIV5Iwegz3ELF8wNYDX_JDDexnOwXB4ulyC3bAkqSQgFGhf-3Gj-HKRDPn1blM05z34sdgbX5Nn32jxXf1zgJEdkqf_NrCZ_FWVwQavJsQowpIrt0YMsBcS5C4rwRKC8go5piqeA25pNRepZ9pQmBvv_AEPqhpVumRT6ny8fApvfB7hwg_XJoORVSpYZi31N0GOCcQ3MomPfLY_6PqsjDot6AQgTcFi9knw-30wSMwr6wY33WDcbFMLoCwoyVw7RK6YNtjp6fV2dkRqU79yBM6xGwcz&code=4%2F0AVHEtk7d5NWC4ILVN6bWXUGr0KJ0lT1w05jH01s4El_h_CrsnzuvlE_Ik2HtYlFqUfabAQ&scope=email+profile+openid+https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fuserinfo.profile+https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fuserinfo.email&authuser=0&prompt=consent 2023-04-09 23:14:14.3769|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.External signed in. 2023-04-09 23:14:14.3769|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 649.1494ms 302 2023-04-09 23:14:14.7471|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/Account/GoogleResponse 2023-04-09 23:14:14.7495|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.GoogleResponse (Authentication)' 2023-04-09 23:14:14.7495|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GoogleResponse", controller = "Account"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GoogleResponse() on controller Authentication.Controllers.AccountController (Authentication). 2023-04-09 23:14:14.7495|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 23:14:14.7697||WARN|Authentication.Controllers.AccountController|external login info from googleresponse 2023-04-09 23:14:14.7697|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 23:14:14.7797|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__loginProvider_0='?' (Size = 450), @__providerKey_1='?' (Size = 450)], CommandType='Text', CommandTimeout='30'] SELECT TOP(2) [a].[LoginProvider], [a].[ProviderKey], [a].[Discriminator], [a].[ProviderDisplayName], [a].[UserId] FROM [AspNetUserLogins] AS [a] WHERE [a].[Discriminator] IN (N'IdentityUserLogin', N'UserLogin') AND (([a].[LoginProvider] = @__loginProvider_0) AND ([a].[ProviderKey] = @__providerKey_1)) 2023-04-09 23:14:14.7797||WARN|Authentication.Controllers.AccountController|external login result from googleresponse --> {"Succeeded":false,"IsLockedOut":false,"IsNotAllowed":false,"RequiresTwoFactor":false} 2023-04-09 23:14:14.7797||WARN|Authentication.Controllers.AccountController|elsesucceeded from googleresponse 2023-04-09 23:14:14.7797|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__ToLower_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[InstitutionId], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType] FROM [AspNetUsers] AS [a] WHERE LOWER([a].[UserName]) = @__ToLower_0 2023-04-09 23:14:14.7797||WARN|Authentication.Controllers.AccountController|Registering a new user 2023-04-09 23:14:14.7797|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__normalizedUserName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[InstitutionId], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType] FROM [AspNetUsers] AS [a] WHERE [a].[NormalizedUserName] = @__normalizedUserName_0 2023-04-09 23:14:14.8055|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p0='?' (DbType = Int32), @p1='?' (Size = 4000), @p2='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p5='?' (DbType = Int64), @p6='?' (Size = 256), @p7='?' (DbType = Boolean), @p8='?' (Size = 4000), @p9='?' (DbType = Int64), @p10='?' (DbType = Boolean), @p11='?' (DbType = Boolean), @p12='?' (DbType = Boolean), @p13='?' (Size = 4000), @p14='?' (DbType = DateTime2), @p15='?' (DbType = Boolean), @p16='?' (DbType = DateTimeOffset), @p17='?' (Size = 4000), @p18='?' (Size = 256), @p19='?' (Size = 256), @p20='?' (Size = 4000), @p21='?' (Size = 4000), @p22='?' (DbType = Boolean), @p23='?' (Size = 4000), @p24='?' (DbType = Boolean), @p25='?' (DbType = Int64), @p26='?' (Size = 256), @p27='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [AspNetUsers] ([AccessFailedCount], [ConcurrencyStamp], [CreatedBy], [DateCreated], [DateUpdated], [DeletedBy], [Email], [EmailConfirmed], [FirstName], [InstitutionId], [IsActive], [IsDeleted], [IsFirstLogin], [LastName], [LastPasswordChangeDate], [LockoutEnabled], [LockoutEnd], [MiddleName], [NormalizedEmail], [NormalizedUserName], [PasswordHash], [PhoneNumber], [PhoneNumberConfirmed], [SecurityStamp], [TwoFactorEnabled], [UpdatedBy], [UserName], [UserType]) VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23, @p24, @p25, @p26, @p27); SELECT [Id], [RowVersion] FROM [AspNetUsers] WHERE @@ROWCOUNT = 1 AND [Id] = scope_identity(); 2023-04-09 23:14:14.8220|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__roleId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [a].[Id], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[IsActive], [a].[Name], [a].[NormalizedName], [a].[RoleType], [a].[UpdatedBy] FROM [AspNetRoles] AS [a] WHERE [a].[Id] = @__roleId_0 2023-04-09 23:14:14.8220|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__normalizedRoleName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT TOP(2) [a].[Id], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[IsActive], [a].[Name], [a].[NormalizedName], [a].[RoleType], [a].[UpdatedBy] FROM [AspNetRoles] AS [a] WHERE [a].[NormalizedName] = @__normalizedRoleName_0 2023-04-09 23:14:14.8361|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int64), @__p_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [a].[UserId], [a].[RoleId], [a].[Discriminator] FROM [AspNetUserRoles] AS [a] WHERE [a].[Discriminator] IN (N'IdentityUserRole', N'UserRole') AND (([a].[UserId] = @__p_0) AND ([a].[RoleId] = @__p_1)) 2023-04-09 23:14:14.8361|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__normalizedRoleName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT TOP(2) [a].[Id], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[IsActive], [a].[Name], [a].[NormalizedName], [a].[RoleType], [a].[UpdatedBy] FROM [AspNetRoles] AS [a] WHERE [a].[NormalizedName] = @__normalizedRoleName_0 2023-04-09 23:14:14.8492|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__normalizedUserName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[InstitutionId], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType] FROM [AspNetUsers] AS [a] WHERE [a].[NormalizedUserName] = @__normalizedUserName_0 2023-04-09 23:14:14.8620|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p0='?' (DbType = Int64), @p1='?' (DbType = Int64), @p2='?' (Size = 4000)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [AspNetUserRoles] ([UserId], [RoleId], [Discriminator]) VALUES (@p0, @p1, @p2); 2023-04-09 23:14:14.8620|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p28='?' (DbType = Int64), @p0='?' (DbType = Int32), @p1='?' (Size = 4000), @p29='?' (Size = 4000), @p2='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p5='?' (DbType = Int64), @p6='?' (Size = 256), @p7='?' (DbType = Boolean), @p8='?' (Size = 4000), @p9='?' (DbType = Int64), @p10='?' (DbType = Boolean), @p11='?' (DbType = Boolean), @p12='?' (DbType = Boolean), @p13='?' (Size = 4000), @p14='?' (DbType = DateTime2), @p15='?' (DbType = Boolean), @p16='?' (DbType = DateTimeOffset), @p17='?' (Size = 4000), @p18='?' (Size = 256), @p19='?' (Size = 256), @p20='?' (Size = 4000), @p21='?' (Size = 4000), @p22='?' (DbType = Boolean), @p30='?' (Size = 8) (DbType = Binary), @p23='?' (Size = 4000), @p24='?' (DbType = Boolean), @p25='?' (DbType = Int64), @p26='?' (Size = 256), @p27='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; UPDATE [AspNetUsers] SET [AccessFailedCount] = @p0, [ConcurrencyStamp] = @p1, [CreatedBy] = @p2, [DateCreated] = @p3, [DateUpdated] = @p4, [DeletedBy] = @p5, [Email] = @p6, [EmailConfirmed] = @p7, [FirstName] = @p8, [InstitutionId] = @p9, [IsActive] = @p10, [IsDeleted] = @p11, [IsFirstLogin] = @p12, [LastName] = @p13, [LastPasswordChangeDate] = @p14, [LockoutEnabled] = @p15, [LockoutEnd] = @p16, [MiddleName] = @p17, [NormalizedEmail] = @p18, [NormalizedUserName] = @p19, [PasswordHash] = @p20, [PhoneNumber] = @p21, [PhoneNumberConfirmed] = @p22, [SecurityStamp] = @p23, [TwoFactorEnabled] = @p24, [UpdatedBy] = @p25, [UserName] = @p26, [UserType] = @p27 WHERE [Id] = @p28 AND [ConcurrencyStamp] = @p29 AND [RowVersion] = @p30; SELECT [RowVersion] FROM [AspNetUsers] WHERE @@ROWCOUNT = 1 AND [Id] = @p28; 2023-04-09 23:14:14.8755|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p0='?' (Size = 4000), @p1='?' (Size = 4000), @p2='?' (Size = 4000), @p3='?' (Size = 4000), @p4='?' (Size = 4000), @p5='?' (DbType = Int64), @p6='?' (DbType = DateTime2), @p7='?' (DbType = DateTime2), @p8='?' (Size = 4000), @p9='?' (Size = 4000), @p10='?' (DbType = Boolean), @p11='?' (DbType = Boolean), @p12='?' (Size = 4000), @p13='?' (Size = 4000), @p14='?' (DbType = Int64), @p15='?' (Size = 4000), @p16='?' (Size = 4000), @p17='?' (Size = 4000), @p18='?' (DbType = Int64), @p19='?' (Size = 4000), @p20='?' (Size = 4000)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [Students] ([Address1], [Address2], [Age], [Biography], [Country], [CreatedBy], [DateCreated], [DateModified], [FaceBook], [Headline], [IsActive], [IsDeleted], [JobTitle], [LinkedIn], [ModifiedBy], [Organization], [ProfilePixUrl], [Twitter], [UserId], [Website], [YouTube]) VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20); SELECT [Id] FROM [Students] WHERE @@ROWCOUNT = 1 AND [Id] = scope_identity(); 2023-04-09 23:14:14.8755||WARN|Authentication.Core.Services.GoogleService|appendRequest= {"majorDimension":null,"range":null,"values":[["oedeboh@gmail.com","Omotoyosi","Edeboh"]],"ETag":null}, sheetID ="1oTZ1hfTRq_kX45J0_zA2vxVqddGZ166HHuYeO31LaPA", range ="newlyRegisteredUsers!A1:C" 2023-04-09 23:14:14.8755||WARN|Authentication.Core.Services.GoogleService|valueInputeOption= USERENTERED 2023-04-09 23:14:15.5803||WARN|Authentication.Core.Services.GoogleService|Googlesheet response= {"spreadsheetId":"1oTZ1hfTRq_kX45J0_zA2vxVqddGZ166HHuYeO31LaPA","tableRange":"newlyRegisteredUsers!A1:C313","updates":{"spreadsheetId":"1oTZ1hfTRq_kX45J0_zA2vxVqddGZ166HHuYeO31LaPA","updatedCells":3,"updatedColumns":3,"updatedData":null,"updatedRange":"newlyRegisteredUsers!A314:C314","updatedRows":1,"ETag":null},"ETag":null} 2023-04-09 23:14:15.5803|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__loginProvider_0='?' (Size = 450), @__providerKey_1='?' (Size = 450)], CommandType='Text', CommandTimeout='30'] SELECT TOP(2) [a].[LoginProvider], [a].[ProviderKey], [a].[Discriminator], [a].[ProviderDisplayName], [a].[UserId] FROM [AspNetUserLogins] AS [a] WHERE [a].[Discriminator] IN (N'IdentityUserLogin', N'UserLogin') AND (([a].[LoginProvider] = @__loginProvider_0) AND ([a].[ProviderKey] = @__providerKey_1)) 2023-04-09 23:14:15.5803|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__normalizedUserName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[InstitutionId], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType] FROM [AspNetUsers] AS [a] WHERE [a].[NormalizedUserName] = @__normalizedUserName_0 2023-04-09 23:14:15.5803|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p0='?' (Size = 450), @p1='?' (Size = 450), @p2='?' (Size = 4000), @p3='?' (Size = 4000), @p4='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [AspNetUserLogins] ([LoginProvider], [ProviderKey], [Discriminator], [ProviderDisplayName], [UserId]) VALUES (@p0, @p1, @p2, @p3, @p4); 2023-04-09 23:14:15.5803|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p28='?' (DbType = Int64), @p0='?' (DbType = Int32), @p1='?' (Size = 4000), @p29='?' (Size = 4000), @p2='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p5='?' (DbType = Int64), @p6='?' (Size = 256), @p7='?' (DbType = Boolean), @p8='?' (Size = 4000), @p9='?' (DbType = Int64), @p10='?' (DbType = Boolean), @p11='?' (DbType = Boolean), @p12='?' (DbType = Boolean), @p13='?' (Size = 4000), @p14='?' (DbType = DateTime2), @p15='?' (DbType = Boolean), @p16='?' (DbType = DateTimeOffset), @p17='?' (Size = 4000), @p18='?' (Size = 256), @p19='?' (Size = 256), @p20='?' (Size = 4000), @p21='?' (Size = 4000), @p22='?' (DbType = Boolean), @p30='?' (Size = 8) (DbType = Binary), @p23='?' (Size = 4000), @p24='?' (DbType = Boolean), @p25='?' (DbType = Int64), @p26='?' (Size = 256), @p27='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; UPDATE [AspNetUsers] SET [AccessFailedCount] = @p0, [ConcurrencyStamp] = @p1, [CreatedBy] = @p2, [DateCreated] = @p3, [DateUpdated] = @p4, [DeletedBy] = @p5, [Email] = @p6, [EmailConfirmed] = @p7, [FirstName] = @p8, [InstitutionId] = @p9, [IsActive] = @p10, [IsDeleted] = @p11, [IsFirstLogin] = @p12, [LastName] = @p13, [LastPasswordChangeDate] = @p14, [LockoutEnabled] = @p15, [LockoutEnd] = @p16, [MiddleName] = @p17, [NormalizedEmail] = @p18, [NormalizedUserName] = @p19, [PasswordHash] = @p20, [PhoneNumber] = @p21, [PhoneNumberConfirmed] = @p22, [SecurityStamp] = @p23, [TwoFactorEnabled] = @p24, [UpdatedBy] = @p25, [UserName] = @p26, [UserType] = @p27 WHERE [Id] = @p28 AND [ConcurrencyStamp] = @p29 AND [RowVersion] = @p30; SELECT [RowVersion] FROM [AspNetUsers] WHERE @@ROWCOUNT = 1 AND [Id] = @p28; 2023-04-09 23:14:15.5979|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__user_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a].[Id], [a].[ClaimType], [a].[ClaimValue], [a].[Discriminator], [a].[UserId] FROM [AspNetUserClaims] AS [a] WHERE [a].[Discriminator] IN (N'IdentityUserClaim', N'UserClaim') AND ([a].[UserId] = @__user_Id_0) 2023-04-09 23:14:15.5979|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__userId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a0].[Name] FROM [AspNetUserRoles] AS [a] INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id] WHERE [a].[Discriminator] IN (N'IdentityUserRole', N'UserRole') AND ([a].[UserId] = @__userId_0) 2023-04-09 23:14:15.5979|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__normalizedName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [a].[Id], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[IsActive], [a].[Name], [a].[NormalizedName], [a].[RoleType], [a].[UpdatedBy] FROM [AspNetRoles] AS [a] WHERE [a].[NormalizedName] = @__normalizedName_0 2023-04-09 23:14:15.5979|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__role_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a].[ClaimType], [a].[ClaimValue] FROM [AspNetRoleClaims] AS [a] WHERE [a].[RoleId] = @__role_Id_0 2023-04-09 23:14:15.5979|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.Application signed in. 2023-04-09 23:14:15.5979||WARN|Authentication.Controllers.AccountController|About to send Email. 2023-04-09 23:14:15.5979||WARN|Authentication.Data.Utility.Email.EmailUtilityService|Url Token : {url} 2023-04-09 23:14:15.6125||WARN|Authentication.Data.Utility.Email.EmailUtilityService|Url: https://api.skilldorm.com/Notification/ 2023-04-09 23:14:15.6125||WARN|Authentication.Data.Utility.Email.EmailUtilityService|EndPoint: api/Email/Send 2023-04-09 23:14:15.7977||WARN|Authentication.Data.Utility.Email.EmailUtilityService|Response from Notification Service: {"data":null,"code":"00","success":true,"description":"Success"} 2023-04-09 23:14:15.7977||WARN|Authentication.Data.Utility.Email.EmailUtilityService|Response from Notification Service: OK--OK--(null) 2023-04-09 23:14:15.7977||WARN|Authentication.Controllers.AccountController|Done sending Email. 2023-04-09 23:14:15.8563||ERROR|Authentication.Controllers.AccountController|Error Sending Email. Details System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.PlatformNotSupportedException: This instance contains state that cannot be serialized and deserialized on this platform. at System.Security.Claims.ClaimsPrincipal.OnSerializingMethod(StreamingContext context) --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor, Boolean wrapExceptions) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters) at Newtonsoft.Json.Serialization.JsonContract.<>c__DisplayClass57_0.b__0(Object o, StreamingContext context) at Newtonsoft.Json.Serialization.JsonContract.InvokeOnSerializing(Object o, StreamingContext context) at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.OnSerializing(JsonWriter writer, JsonContract contract, Object value) at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeObject(JsonWriter writer, Object value, JsonObjectContract contract, JsonProperty member, JsonContainerContract collectionContract, JsonProperty containerProperty) at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeValue(JsonWriter writer, Object value, JsonContract valueContract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerProperty) at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeObject(JsonWriter writer, Object value, JsonObjectContract contract, JsonProperty member, JsonContainerContract collectionContract, JsonProperty containerProperty) at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeValue(JsonWriter writer, Object value, JsonContract valueContract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerProperty) at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.Serialize(JsonWriter jsonWriter, Object value, Type objectType) at Newtonsoft.Json.JsonSerializer.SerializeInternal(JsonWriter jsonWriter, Object value, Type objectType) at Newtonsoft.Json.JsonSerializer.Serialize(JsonWriter jsonWriter, Object value, Type objectType) at Newtonsoft.Json.JsonConvert.SerializeObjectInternal(Object value, Type type, JsonSerializer jsonSerializer) at Newtonsoft.Json.JsonConvert.SerializeObject(Object value, Type type, JsonSerializerSettings settings) at Newtonsoft.Json.JsonConvert.SerializeObject(Object value) at AuditTrailUtility.AuditTrails.CreateActivityLog(String description, String moduleName, String moduleAction, Int64 userid, Int64 institutionId, Object record, String agent, LogType logType) in C:\Program Files (x86)\Jenkins\workspace\SkillDorm-BE-V1\AuditTrailUtility\AuditTrail.cs:line 73 at Authentication.Controllers.AccountController.GoogleResponse() in C:\Program Files (x86)\Jenkins\workspace\SkillDorm-BE-V1\Authentication\Controllers\AccountController.cs:line 1562 2023-04-09 23:14:15.8569||WARN|Authentication.Controllers.AccountController|userUsername is oedeboh@gmail.com 2023-04-09 23:14:15.8569|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__ToLower_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[CreatedBy], [a].[DateCreated], [a].[DateUpdated], [a].[DeletedBy], [a].[Email], [a].[EmailConfirmed], [a].[FirstName], [a].[InstitutionId], [a].[IsActive], [a].[IsDeleted], [a].[IsFirstLogin], [a].[LastName], [a].[LastPasswordChangeDate], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[MiddleName], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[RowVersion], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UpdatedBy], [a].[UserName], [a].[UserType] FROM [AspNetUsers] AS [a] WHERE LOWER([a].[UserName]) = @__ToLower_0 2023-04-09 23:14:15.8569|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__checkUser_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [s].[Id], [s].[Address1], [s].[Address2], [s].[Age], [s].[Biography], [s].[Country], [s].[CreatedBy], [s].[DateCreated], [s].[DateModified], [s].[FaceBook], [s].[Headline], [s].[IsActive], [s].[IsDeleted], [s].[JobTitle], [s].[LinkedIn], [s].[ModifiedBy], [s].[Organization], [s].[ProfilePixUrl], [s].[Twitter], [s].[UserId], [s].[Website], [s].[YouTube] FROM [Students] AS [s] WHERE [s].[UserId] = @__checkUser_Id_0 2023-04-09 23:14:15.8751||WARN|Authentication.Controllers.AccountController|Newresult is {"FirstName":"Omotoyosi","MiddleName":null,"LastName":"Edeboh","IsFirstLogin":true,"FullName":"Omotoyosi Edeboh","RowVersion":"AAAAAAAETdI=","DateCreated":"2023-04-09T23:14:14.7834089","DateUpdated":null,"CreatedBy":0,"UpdatedBy":null,"DeletedBy":0,"IsDeleted":false,"IsActive":true,"InstitutionId":0,"UserType":1,"LastPasswordChangeDate":null,"Id":10607,"UserName":"oedeboh@gmail.com","NormalizedUserName":"OEDEBOH@GMAIL.COM","Email":"oedeboh@gmail.com","NormalizedEmail":"OEDEBOH@GMAIL.COM","EmailConfirmed":false,"PasswordHash":null,"SecurityStamp":"2HI32USK5HJRXWE6EVBUGUCPUW44ASES","ConcurrencyStamp":"7b8edd0b-cf6a-43e8-8def-b8deec82cbef","PhoneNumber":null,"PhoneNumberConfirmed":false,"TwoFactorEnabled":false,"LockoutEnd":null,"LockoutEnabled":true,"AccessFailedCount":0} 2023-04-09 23:14:15.8751|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a0].[Name] FROM [AspNetUserRoles] AS [a] INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id] WHERE [a].[Discriminator] IN (N'IdentityUserRole', N'UserRole') AND ([a].[UserId] = @__userId_0) 2023-04-09 23:14:15.8751||WARN|Authentication.Controllers.AccountController|Role is STUDENT 2023-04-09 23:14:15.8751|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__get_Item_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT [p].[Code] FROM [RolePermissions] AS [r] INNER JOIN [AspNetRoles] AS [a] ON [r].[RoleId] = [a].[Id] INNER JOIN [Permissions] AS [p] ON [r].[PermissionId] = [p].[Id] WHERE [a].[Name] = @__get_Item_0 2023-04-09 23:14:15.8751|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@p0='?' (DbType = DateTime2), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Size = 4000), @p4='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [UserToken] ([DateCreated], [ExpiryDate], [IsActive], [Token], [UserId]) VALUES (@p0, @p1, @p2, @p3, @p4); SELECT [Id] FROM [UserToken] WHERE @@ROWCOUNT = 1 AND [Id] = scope_identity(); 2023-04-09 23:14:15.8751|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__userId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a0].[Name] FROM [AspNetUserRoles] AS [a] INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id] WHERE [a].[Discriminator] IN (N'IdentityUserRole', N'UserRole') AND ([a].[UserId] = @__userId_0) 2023-04-09 23:14:15.8751||WARN|Authentication.Controllers.AccountController|user: oedeboh@gmail.com - Omotoyosi Edeboh role is gotten 2023-04-09 23:14:15.9151||WARN|Authentication.Controllers.AccountController|serializedata = {"access_token":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9uYW1lIjoiT21vdG95b3NpIiwiaHR0cDovL3NjaGVtYXMubWljcm9zb2Z0LmNvbS93cy8yMDA4LzA2L2lkZW50aXR5L2NsYWltcy9wcmltYXJ5c2lkIjoiMTA2MDciLCJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9naXZlbm5hbWUiOiJvZWRlYm9oQGdtYWlsLmNvbSIsImh0dHA6Ly9zY2hlbWFzLnhtbHNvYXAub3JnL3dzLzIwMDUvMDUvaWRlbnRpdHkvY2xhaW1zL2VtYWlsYWRkcmVzcyI6Im9lZGVib2hAZ21haWwuY29tIiwiaHR0cDovL3NjaGVtYXMueG1sc29hcC5vcmcvd3MvMjAwNS8wNS9pZGVudGl0eS9jbGFpbXMvbG9jYWxpdHkiOiIwIiwiaHR0cDovL3NjaGVtYXMubWljcm9zb2Z0LmNvbS93cy8yMDA4LzA2L2lkZW50aXR5L2NsYWltcy9yb2xlIjoiU1RVREVOVCIsImV4cCI6MTY4MTE2NDg1NSwiaXNzIjoic2tpbGxiZXRhX3JpdmV0X3N0dWRpbyIsImF1ZCI6IlNraWxsQmV0YVJpdmV0U3R1ZGlvIn0.Qssl6MZ0spbfgXHpEoAVevrWcj5cOZrX5B_la-EatPw","refreshToken":"SYcx/eQ2MlUOsk+OI6cclA+6XdfoWF3GaIraETu1i00=","accesstoken_Expires":"2023-04-10T22:14:15Z","refreshToken_Expires":"2023-04-10T00:14:15.8790536+01:00","isFirstLogin":true,"role":"STUDENT","UserId":10607,"StudentProfile":10408,"UserName":"oedeboh@gmail.com","InstitutionId":0,"FirstName":"Omotoyosi","LastName":"Edeboh"} 2023-04-09 23:14:15.9151|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.RedirectResultExecutor|Executing RedirectResult, redirecting to https://www.skilldorm.com/course/discovery?data={"access_token":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9uYW1lIjoiT21vdG95b3NpIiwiaHR0cDovL3NjaGVtYXMubWljcm9zb2Z0LmNvbS93cy8yMDA4LzA2L2lkZW50aXR5L2NsYWltcy9wcmltYXJ5c2lkIjoiMTA2MDciLCJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9naXZlbm5hbWUiOiJvZWRlYm9oQGdtYWlsLmNvbSIsImh0dHA6Ly9zY2hlbWFzLnhtbHNvYXAub3JnL3dzLzIwMDUvMDUvaWRlbnRpdHkvY2xhaW1zL2VtYWlsYWRkcmVzcyI6Im9lZGVib2hAZ21haWwuY29tIiwiaHR0cDovL3NjaGVtYXMueG1sc29hcC5vcmcvd3MvMjAwNS8wNS9pZGVudGl0eS9jbGFpbXMvbG9jYWxpdHkiOiIwIiwiaHR0cDovL3NjaGVtYXMubWljcm9zb2Z0LmNvbS93cy8yMDA4LzA2L2lkZW50aXR5L2NsYWltcy9yb2xlIjoiU1RVREVOVCIsImV4cCI6MTY4MTE2NDg1NSwiaXNzIjoic2tpbGxiZXRhX3JpdmV0X3N0dWRpbyIsImF1ZCI6IlNraWxsQmV0YVJpdmV0U3R1ZGlvIn0.Qssl6MZ0spbfgXHpEoAVevrWcj5cOZrX5B_la-EatPw","refreshToken":"SYcx/eQ2MlUOsk+OI6cclA+6XdfoWF3GaIraETu1i00=","accesstoken_Expires":"2023-04-10T22:14:15Z","refreshToken_Expires":"2023-04-10T00:14:15.8790536+01:00","isFirstLogin":true,"role":"STUDENT","UserId":10607,"StudentProfile":10408,"UserName":"oedeboh@gmail.com","InstitutionId":0,"FirstName":"Omotoyosi","LastName":"Edeboh"}. 2023-04-09 23:14:15.9151|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.GoogleResponse (Authentication) in 1159.7665ms 2023-04-09 23:14:15.9151|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.GoogleResponse (Authentication)' 2023-04-09 23:14:15.9151|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1170.2606ms 302 2023-04-09 23:14:17.2182|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/Account/GoogleResponse 2023-04-09 23:14:17.2182|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.GoogleResponse (Authentication)' 2023-04-09 23:14:17.2182|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GoogleResponse", controller = "Account"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GoogleResponse() on controller Authentication.Controllers.AccountController (Authentication). 2023-04-09 23:14:17.2182|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-04-09 23:14:17.2182|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2023-04-09 23:14:17.2182|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.GoogleResponse (Authentication) in 5.4988ms 2023-04-09 23:14:17.2182|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.GoogleResponse (Authentication)' 2023-04-09 23:14:17.2182|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 8.5262ms 200 application/json; charset=utf-8