2023-05-10 01:57:09.6022||DEBUG|Authentication.Program|init main function 2023-05-10 01:57:10.3545|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 01:57:10.5294|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-05-10 01:57:10.5478|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-05-10 01:57:10.5478|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-05-10 01:57:10.5478|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-05-10 01:57:10.5595|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2023-05-10 01:57:10.5595|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2023-05-10 01:57:10.6471|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2023-05-10 01:57:10.6471|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-05-10 01:57:10.6548|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {697d3873-7b18-4d8c-9c2b-be3712eecd35} with creation date 2023-05-10 00:57:10Z, activation date 2023-05-10 00:57:10Z, and expiration date 2023-08-08 00:57:10Z. 2023-05-10 01:57:10.6548|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {697d3873-7b18-4d8c-9c2b-be3712eecd35} may be persisted to storage in unencrypted form. 2023-05-10 01:57:10.9398|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-05-10 01:57:10.9758|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 01:57:10.9793|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-05-10 01:57:11.0051|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-05-10 01:57:11.0106|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 01:57:11.0435|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 01:57:11.1768|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (10ms) [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-05-10 01:57:11.2288|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-05-10 01:57:11.2995|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 291.9074ms 2023-05-10 01:57:11.2995|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-05-10 01:57:11.2995|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 363.8484ms 200 application/json; charset=utf-8 2023-05-10 01:57:21.4579|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-05-10 01:57:21.4615|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 01:57:21.4615|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-05-10 01:57:21.4615|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-05-10 01:57:21.4615|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 01:57:21.4615|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 01:57:21.4615|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-05-10 01:57:21.4615|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-05-10 01:57:21.4615|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 8.9118ms 2023-05-10 01:57:21.4615|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-05-10 01:57:21.4615|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 14.2482ms 200 application/json; charset=utf-8 2023-05-10 01:59:36.2671|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-05-10 01:59:36.2671|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 01:59:36.2671|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-05-10 01:59:36.2671|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-05-10 01:59:36.2806|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 01:59:36.2806|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 01:59:36.2806|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-05-10 01:59:36.2806|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-05-10 01:59:36.2806|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 17.0838ms 2023-05-10 01:59:36.2806|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-05-10 01:59:36.2806|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 22.977ms 200 application/json; charset=utf-8 2023-05-10 01:59:37.1723|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/Admin/SignIn 2023-05-10 01:59:37.1723|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 01:59:37.1723|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.3942ms 204 2023-05-10 01:59:37.4534|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://api.skilldorm.com/Authentication/api/Account/Admin/SignIn application/json 43 2023-05-10 01:59:37.4534|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 01:59:37.4702|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.AdminSignIn (Authentication)' 2023-05-10 01:59:37.4702|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "AdminSignIn", controller = "Account"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] AdminSignIn(Authentication.Data.Models.Identity.AuthBindingModel) on controller Authentication.Controllers.AccountController (Authentication). 2023-05-10 01:59:37.4702|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 01:59:37.5858|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (22ms) [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-05-10 01:59:37.6154|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 01:59:37.6277|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (6ms) [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-05-10 01:59:37.6552|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [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-05-10 01:59:37.6878|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [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-05-10 01:59:37.6878|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [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-05-10 01:59:37.7080|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-05-10 01:59:37.7128|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.Application signed in. 2023-05-10 01:59:37.7128|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (7ms) [Parameters=[@__userInfo_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [s].[Id], [s].[Address1], [s].[Address2], [s].[Biography], [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 [Staffs] AS [s] WHERE [s].[UserId] = @__userInfo_Id_0 2023-05-10 01:59:37.8747|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-05-10 01:59:37.8747||WARN|Authentication.Controllers.AccountController|Role is SUPER ADMIN 2023-05-10 01:59:37.8913|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (8ms) [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-05-10 01:59:38.0556|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (23ms) [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-05-10 01:59:38.0781|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-05-10 01:59:38.0781||INFO|Authentication.Controllers.AccountController|user: RIVE66 - Maria Simeon-Godfrey role is gotten 2023-05-10 01:59:38.0781|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 [Staffs] AS [s] WHERE [s].[UserId] = @__userInfo_Id_0 2023-05-10 01:59:38.0875|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@__roleName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT [r].[Id], [r].[CreatedBy], [r].[DateCreated], [r].[DateUpdated], [r].[IsActive], [r].[IsDeleted], [r].[PermissionId], [r].[RoleId], [r].[RowVersion], [r].[UpdatedBy] FROM [RolePermissions] AS [r] INNER JOIN [AspNetRoles] AS [a] ON [r].[RoleId] = [a].[Id] WHERE ([a].[Name] = @__roleName_0) AND ([r].[IsActive] = CAST(1 AS bit)) 2023-05-10 01:59:38.0875|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 01:59:38.0875|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 01:59:38.0875|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 01:59:38.0875|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 01:59:38.0875|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 01:59:38.0875|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 01:59:38.0875|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 01:59:38.0875|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 01:59:38.1005|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 01:59:38.1005|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 01:59:38.1005|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 01:59:38.1005|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 01:59:38.1005|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 01:59:38.1005|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 01:59:38.1005|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 01:59:38.1005|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 01:59:38.1005|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 01:59:38.1005|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 01:59:38.1005|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 01:59:38.1005|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 01:59:38.1005|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 01:59:38.1005|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 01:59:38.1005|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 01:59:38.1005|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 01:59:38.1005|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 01:59:38.1005|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 01:59:38.1005|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 01:59:38.1854|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2023-05-10 01:59:38.1854|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.AdminSignIn (Authentication) in 716.0693ms 2023-05-10 01:59:38.1854|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.AdminSignIn (Authentication)' 2023-05-10 01:59:38.1854|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 738.6791ms 200 application/json; charset=utf-8 2023-05-10 02:06:49.1337|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-05-10 02:06:49.1337|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 02:06:49.1337|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-05-10 02:06:49.1337|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-05-10 02:06:49.1337|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 02:06:49.1337|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 02:06:49.1480|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-05-10 02:06:49.1480|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-05-10 02:06:49.1480|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 12.024ms 2023-05-10 02:06:49.1480|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-05-10 02:06:49.1480|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 17.0891ms 200 application/json; charset=utf-8 2023-05-10 02:06:53.2979|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/Student/SignIn 2023-05-10 02:06:53.2979|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 02:06:53.2979|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.1662ms 204 2023-05-10 02:06:53.5829|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://api.skilldorm.com/Authentication/api/Account/Student/SignIn application/json 65 2023-05-10 02:06:53.5829|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 02:06:53.5829|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 2023-05-10 02:06:53.5829|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-05-10 02:06:53.5829|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 02:06:53.6028|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-05-10 02:06:53.6028|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 02:06:53.6028|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-05-10 02:06:53.6028|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-05-10 02:06:53.6028|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-05-10 02:06:53.6028|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-05-10 02:06:53.6028|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-05-10 02:06:53.6126|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.Application signed in. 2023-05-10 02:06:53.6126|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (8ms) [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-05-10 02:06:53.6320|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-05-10 02:06:53.6320||WARN|Authentication.Controllers.AccountController|Role is STUDENT 2023-05-10 02:06:53.6320|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-05-10 02:06:53.6320|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-05-10 02:06:53.6441|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-05-10 02:06:53.6441||INFO|Authentication.Controllers.AccountController|user: godbless.onyebuchi@gmail.com - Chinemerem Jahblez role is gotten 2023-05-10 02:06:53.6441|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-05-10 02:06:53.6859|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2023-05-10 02:06:53.6859|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.StudentSignIn (Authentication) in 92.6197ms 2023-05-10 02:06:53.6859|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 2023-05-10 02:06:53.6859|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 104.6271ms 200 application/json; charset=utf-8 2023-05-10 02:30:10.4944|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:31463/AUTHENTICATION/iisintegration 0 2023-05-10 02:30:10.4944|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.8521ms 202 2023-05-10 03:44:14.5545||DEBUG|Authentication.Program|init main function 2023-05-10 03:44:15.2861|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 03:44:15.4692|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-05-10 03:44:15.4879|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-05-10 03:44:15.4879|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-05-10 03:44:15.4879|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-05-10 03:44:15.4985|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2023-05-10 03:44:15.5114|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2023-05-10 03:44:15.5869|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2023-05-10 03:44:15.5869|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-05-10 03:44:15.5869|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {562d304c-ee71-4816-b782-98e03b7fdf7b} with creation date 2023-05-10 02:44:15Z, activation date 2023-05-10 02:44:15Z, and expiration date 2023-08-08 02:44:15Z. 2023-05-10 03:44:15.5979|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {562d304c-ee71-4816-b782-98e03b7fdf7b} may be persisted to storage in unencrypted form. 2023-05-10 03:44:15.8726|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-05-10 03:44:15.9102|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 03:44:15.9102|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-05-10 03:44:15.9388|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-05-10 03:44:15.9447|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 03:44:15.9781|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 03:44:16.1104|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-05-10 03:44:16.1639|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-05-10 03:44:16.2356|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 294.261ms 2023-05-10 03:44:16.2356|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-05-10 03:44:16.2393|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 367.2627ms 200 application/json; charset=utf-8 2023-05-10 04:05:14.2903|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:41005/AUTHENTICATION/iisintegration 0 2023-05-10 04:05:14.2903|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.1006ms 202 2023-05-10 04:49:48.5729||DEBUG|Authentication.Program|init main function 2023-05-10 04:49:49.3094|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 04:49:49.4845|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-05-10 04:49:49.5027|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-05-10 04:49:49.5027|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-05-10 04:49:49.5027|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-05-10 04:49:49.5128|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2023-05-10 04:49:49.5255|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2023-05-10 04:49:49.6005|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2023-05-10 04:49:49.6005|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-05-10 04:49:49.6005|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {dd719821-e522-44b0-b1c2-d1e61ef2ced9} with creation date 2023-05-10 03:49:49Z, activation date 2023-05-10 03:49:49Z, and expiration date 2023-08-08 03:49:49Z. 2023-05-10 04:49:49.6005|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {dd719821-e522-44b0-b1c2-d1e61ef2ced9} may be persisted to storage in unencrypted form. 2023-05-10 04:49:49.8991|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-05-10 04:49:49.9355|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 04:49:49.9355|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-05-10 04:49:49.9626|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-05-10 04:49:49.9683|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 04:49:50.0010|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 04:49:50.1340|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-05-10 04:49:50.1837|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-05-10 04:49:50.2596|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 294.5517ms 2023-05-10 04:49:50.2596|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-05-10 04:49:50.2596|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 364.6748ms 200 application/json; charset=utf-8 2023-05-10 04:49:54.1185|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/Student/SignIn 2023-05-10 04:49:54.1185|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 04:49:54.1185|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 3.1802ms 204 2023-05-10 04:49:54.3974|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-05-10 04:49:54.3974|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 04:49:54.4153|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 2023-05-10 04:49:54.4153|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-05-10 04:49:54.4153|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 04:49:54.5205|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-05-10 04:49:54.5493|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 04:49:54.5493|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-05-10 04:49:54.5493|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 04:49:54.5493|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-05-10 04:49:54.5493|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-05-10 04:49:54.5601|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-05-10 04:49:54.5601|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 04:49:54.5601|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 04:49:54.5601|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-05-10 04:49:54.5601|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-05-10 04:49:54.5694|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 15.8254ms 2023-05-10 04:49:54.5694|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-05-10 04:49:54.5694|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 19.1634ms 200 application/json; charset=utf-8 2023-05-10 04:49:54.5850|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-05-10 04:49:54.6067|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-05-10 04:49:54.6067|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-05-10 04:49:54.6236|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-05-10 04:49:54.6236|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.Application signed in. 2023-05-10 04:49:54.6236|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-05-10 04:49:54.6452|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-05-10 04:49:54.6452||WARN|Authentication.Controllers.AccountController|Role is STUDENT 2023-05-10 04:49:54.6531|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-05-10 04:49:54.8025|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [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-05-10 04:49:54.8245|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-05-10 04:49:54.8245||INFO|Authentication.Controllers.AccountController|user: bolajimikky@gmail.com - Bolaji Mikky role is gotten 2023-05-10 04:49:54.8245|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-05-10 04:49:54.9850|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2023-05-10 04:49:54.9904|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.StudentSignIn (Authentication) in 570.1369ms 2023-05-10 04:49:54.9904|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.StudentSignIn (Authentication)' 2023-05-10 04:49:54.9904|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 593.7231ms 200 application/json; charset=utf-8 2023-05-10 05:35:46.9844|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:39036/AUTHENTICATION/iisintegration 0 2023-05-10 05:35:46.9844|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.0288ms 202 2023-05-10 10:57:21.7292||DEBUG|Authentication.Program|init main function 2023-05-10 10:57:26.3309|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 10:57:26.8198|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-05-10 10:57:26.8384|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-05-10 10:57:26.8413|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-05-10 10:57:26.8413|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-05-10 10:57:26.8413|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2023-05-10 10:57:26.9229|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2023-05-10 10:57:27.1429|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2023-05-10 10:57:27.1429|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-05-10 10:57:27.1429|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {3b7c465d-ecca-4271-91b4-da3d58ec7f22} with creation date 2023-05-10 09:57:27Z, activation date 2023-05-10 09:57:27Z, and expiration date 2023-08-08 09:57:27Z. 2023-05-10 10:57:27.1538|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {3b7c465d-ecca-4271-91b4-da3d58ec7f22} may be persisted to storage in unencrypted form. 2023-05-10 10:57:27.4024|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-05-10 10:57:27.4024|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/Admin/SignIn 2023-05-10 10:57:27.4401|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 10:57:27.4401|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 10:57:27.4401|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-05-10 10:57:27.4401|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 43.3786ms 204 2023-05-10 10:57:27.4701|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-05-10 10:57:27.4701|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 10:57:27.5070|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 10:57:27.6171|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://api.skilldorm.com/Authentication/api/Account/Admin/SignIn application/json 43 2023-05-10 10:57:27.6223|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 10:57:27.6377|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-05-10 10:57:27.6869|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-05-10 10:57:27.8758|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 403.3019ms 2023-05-10 10:57:27.8758|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-05-10 10:57:27.8758|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 476.1612ms 200 application/json; charset=utf-8 2023-05-10 10:57:27.9435|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.AdminSignIn (Authentication)' 2023-05-10 10:57:27.9435|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "AdminSignIn", controller = "Account"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] AdminSignIn(Authentication.Data.Models.Identity.AuthBindingModel) on controller Authentication.Controllers.AccountController (Authentication). 2023-05-10 10:57:27.9487|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 10:57:28.6792|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-05-10 10:57:28.7091|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 10:57:28.7171|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-05-10 10:57:28.7423|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-05-10 10:57:28.7643|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-05-10 10:57:28.7643|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-05-10 10:57:28.7813|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-05-10 10:57:28.7813|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.Application signed in. 2023-05-10 10:57:28.7813|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].[Biography], [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 [Staffs] AS [s] WHERE [s].[UserId] = @__userInfo_Id_0 2023-05-10 10:57:29.2658|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-05-10 10:57:29.2658||WARN|Authentication.Controllers.AccountController|Role is SUPER ADMIN 2023-05-10 10:57:29.2786|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-05-10 10:57:29.5213|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-05-10 10:57:29.5435|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-05-10 10:57:29.5435||INFO|Authentication.Controllers.AccountController|user: RIVE66 - Maria Simeon-Godfrey role is gotten 2023-05-10 10:57:29.5467|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 [Staffs] AS [s] WHERE [s].[UserId] = @__userInfo_Id_0 2023-05-10 10:57:29.5467|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__roleName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT [r].[Id], [r].[CreatedBy], [r].[DateCreated], [r].[DateUpdated], [r].[IsActive], [r].[IsDeleted], [r].[PermissionId], [r].[RoleId], [r].[RowVersion], [r].[UpdatedBy] FROM [RolePermissions] AS [r] INNER JOIN [AspNetRoles] AS [a] ON [r].[RoleId] = [a].[Id] WHERE ([a].[Name] = @__roleName_0) AND ([r].[IsActive] = CAST(1 AS bit)) 2023-05-10 10:57:29.5467|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 10:57:29.5467|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 10:57:29.5596|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 10:57:29.5596|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 10:57:29.5596|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 10:57:29.5596|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 10:57:29.5596|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 10:57:29.5596|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 10:57:29.5596|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 10:57:29.5596|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 10:57:29.5596|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 10:57:29.5596|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 10:57:29.5596|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 10:57:29.5596|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 10:57:29.5596|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 10:57:29.5596|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 10:57:29.5596|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 10:57:29.5596|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 10:57:29.5596|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 10:57:29.5596|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 10:57:29.5596|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 10:57:29.5596|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 10:57:29.5742|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 10:57:29.5742|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 10:57:29.5742|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 10:57:29.5742|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 10:57:29.5742|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 10:57:29.6385|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2023-05-10 10:57:29.6385|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.AdminSignIn (Authentication) in 1696.1809ms 2023-05-10 10:57:29.6385|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.AdminSignIn (Authentication)' 2023-05-10 10:57:29.6385|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2027.9789ms 200 application/json; charset=utf-8 2023-05-10 12:23:20.4781|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:24834/AUTHENTICATION/iisintegration 0 2023-05-10 12:23:20.4781|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.0757ms 202 2023-05-10 13:17:00.3867||DEBUG|Authentication.Program|init main function 2023-05-10 13:17:01.9451|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 13:17:02.4465|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-05-10 13:17:02.4648|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-05-10 13:17:02.4648|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-05-10 13:17:02.4648|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-05-10 13:17:02.4648|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2023-05-10 13:17:02.5496|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2023-05-10 13:17:02.7726|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2023-05-10 13:17:02.7726|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-05-10 13:17:02.7726|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {39b45a29-d1a6-44b4-8f93-c7415b480e4d} with creation date 2023-05-10 12:17:02Z, activation date 2023-05-10 12:17:02Z, and expiration date 2023-08-08 12:17:02Z. 2023-05-10 13:17:02.7726|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {39b45a29-d1a6-44b4-8f93-c7415b480e4d} may be persisted to storage in unencrypted form. 2023-05-10 13:17:02.9179|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/RefreshToken 2023-05-10 13:17:02.9179|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/RefreshToken 2023-05-10 13:17:02.9179|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/RefreshToken 2023-05-10 13:17:02.9179|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/RefreshToken 2023-05-10 13:17:02.9566|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 13:17:02.9566|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 13:17:02.9566|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 13:17:02.9566|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 13:17:02.9566|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 43.6243ms 204 2023-05-10 13:17:02.9566|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 43.6243ms 204 2023-05-10 13:17:02.9566|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 43.6245ms 204 2023-05-10 13:17:02.9566|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 43.6244ms 204 2023-05-10 13:17:03.3298|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://api.skilldorm.com/Authentication/api/Account/RefreshToken application/json 2 2023-05-10 13:17:03.3298|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://api.skilldorm.com/Authentication/api/Account/RefreshToken application/json 2 2023-05-10 13:17:03.3298|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://api.skilldorm.com/Authentication/api/Account/RefreshToken application/json 2 2023-05-10 13:17:03.3298|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://api.skilldorm.com/Authentication/api/Account/RefreshToken application/json 2 2023-05-10 13:17:03.3298|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 13:17:03.3298|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 13:17:03.3298|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 13:17:03.3298|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 13:17:03.6631|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.RefreshToken (Authentication)' 2023-05-10 13:17:03.6631|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.RefreshToken (Authentication)' 2023-05-10 13:17:03.6631|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.RefreshToken (Authentication)' 2023-05-10 13:17:03.6631|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.RefreshToken (Authentication)' 2023-05-10 13:17:03.6918|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "RefreshToken", controller = "Account"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] RefreshToken(System.String) on controller Authentication.Controllers.AccountController (Authentication). 2023-05-10 13:17:03.6918|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "RefreshToken", controller = "Account"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] RefreshToken(System.String) on controller Authentication.Controllers.AccountController (Authentication). 2023-05-10 13:17:03.6918|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "RefreshToken", controller = "Account"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] RefreshToken(System.String) on controller Authentication.Controllers.AccountController (Authentication). 2023-05-10 13:17:03.6918|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "RefreshToken", controller = "Account"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] RefreshToken(System.String) on controller Authentication.Controllers.AccountController (Authentication). 2023-05-10 13:17:03.6987|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 13:17:03.6987|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 13:17:03.6987|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 13:17:03.6987|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 13:17:04.0829|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (21ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [u].[Id], [u].[DateCreated], [u].[ExpiryDate], [u].[IsActive], [u].[Token], [u].[UserId] FROM [UserToken] AS [u] WHERE [u].[Token] IS NULL 2023-05-10 13:17:04.0829|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (16ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [u].[Id], [u].[DateCreated], [u].[ExpiryDate], [u].[IsActive], [u].[Token], [u].[UserId] FROM [UserToken] AS [u] WHERE [u].[Token] IS NULL 2023-05-10 13:17:04.0829|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (24ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [u].[Id], [u].[DateCreated], [u].[ExpiryDate], [u].[IsActive], [u].[Token], [u].[UserId] FROM [UserToken] AS [u] WHERE [u].[Token] IS NULL 2023-05-10 13:17:04.0829|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (18ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [u].[Id], [u].[DateCreated], [u].[ExpiryDate], [u].[IsActive], [u].[Token], [u].[UserId] FROM [UserToken] AS [u] WHERE [u].[Token] IS NULL 2023-05-10 13:17:04.0829|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.String'. 2023-05-10 13:17:04.0829|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.String'. 2023-05-10 13:17:04.0829|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.String'. 2023-05-10 13:17:04.0829|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.String'. 2023-05-10 13:17:04.0829|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.RefreshToken (Authentication) in 396.7738ms 2023-05-10 13:17:04.0829|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.RefreshToken (Authentication) in 396.3517ms 2023-05-10 13:17:04.0829|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.RefreshToken (Authentication) in 396.5838ms 2023-05-10 13:17:04.0829|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.RefreshToken (Authentication) in 396.8689ms 2023-05-10 13:17:04.0829|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.RefreshToken (Authentication)' 2023-05-10 13:17:04.0829|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.RefreshToken (Authentication)' 2023-05-10 13:17:04.0829|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.RefreshToken (Authentication)' 2023-05-10 13:17:04.0829|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.RefreshToken (Authentication)' 2023-05-10 13:17:04.0829|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 764.5679ms 401 text/plain; charset=utf-8 2023-05-10 13:17:04.0829|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 764.5601ms 401 text/plain; charset=utf-8 2023-05-10 13:17:04.0829|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 764.5618ms 401 text/plain; charset=utf-8 2023-05-10 13:17:04.0829|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 764.5717ms 401 text/plain; charset=utf-8 2023-05-10 13:17:06.3183|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-05-10 13:17:06.3183|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 13:17:06.3183|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-05-10 13:17:06.3183|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-05-10 13:17:06.3564|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 13:17:06.3564|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 13:17:06.3894|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-05-10 13:17:06.4363|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-05-10 13:17:06.4700|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 143.3919ms 2023-05-10 13:17:06.4700|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-05-10 13:17:06.4700|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 153.0532ms 200 application/json; charset=utf-8 2023-05-10 13:37:54.4262|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:21459/AUTHENTICATION/iisintegration 0 2023-05-10 13:37:54.4262|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.0217ms 202 2023-05-10 16:18:19.2088||DEBUG|Authentication.Program|init main function 2023-05-10 16:18:19.9511|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 16:18:20.1286|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-05-10 16:18:20.1470|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-05-10 16:18:20.1499|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-05-10 16:18:20.1499|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-05-10 16:18:20.1499|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2023-05-10 16:18:20.1704|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2023-05-10 16:18:20.2461|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2023-05-10 16:18:20.2461|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-05-10 16:18:20.2461|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {6dc7c17f-6dac-4e2f-a0a1-4bad58463caf} with creation date 2023-05-10 15:18:20Z, activation date 2023-05-10 15:18:20Z, and expiration date 2023-08-08 15:18:20Z. 2023-05-10 16:18:20.2461|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {6dc7c17f-6dac-4e2f-a0a1-4bad58463caf} may be persisted to storage in unencrypted form. 2023-05-10 16:18:20.5482|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-05-10 16:18:20.5874|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 16:18:20.5874|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-05-10 16:18:20.6155|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-05-10 16:18:20.6215|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 16:18:20.6543|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 16:18:20.7856|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-05-10 16:18:20.8358|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-05-10 16:18:20.9077|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 289.5942ms 2023-05-10 16:18:20.9077|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-05-10 16:18:20.9114|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 363.7101ms 200 application/json; charset=utf-8 2023-05-10 16:39:18.9690|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:45283/AUTHENTICATION/iisintegration 0 2023-05-10 16:39:18.9690|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.07ms 202 2023-05-10 18:50:59.5133||DEBUG|Authentication.Program|init main function 2023-05-10 18:51:01.3584|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 18:51:01.9039|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (14ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-05-10 18:51:01.9229|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-05-10 18:51:01.9229|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-05-10 18:51:01.9229|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-05-10 18:51:01.9338|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2023-05-10 18:51:02.0088|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2023-05-10 18:51:02.2641|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2023-05-10 18:51:02.2641|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-05-10 18:51:02.2720|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {1a154d43-b16c-4b60-b0a6-398da8df5c77} with creation date 2023-05-10 17:51:02Z, activation date 2023-05-10 17:51:02Z, and expiration date 2023-08-08 17:51:02Z. 2023-05-10 18:51:02.2720|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {1a154d43-b16c-4b60-b0a6-398da8df5c77} may be persisted to storage in unencrypted form. 2023-05-10 18:51:02.4763|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/Admin/SignIn 2023-05-10 18:51:02.4763|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-05-10 18:51:02.5271|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 18:51:02.5271|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 18:51:02.5271|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-05-10 18:51:02.5271|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 58.1129ms 204 2023-05-10 18:51:02.5582|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-05-10 18:51:02.5639|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 18:51:02.5974|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 18:51:02.7024|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://api.skilldorm.com/Authentication/api/Account/Admin/SignIn application/json 43 2023-05-10 18:51:02.7078|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 18:51:02.7326|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (7ms) [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-05-10 18:51:02.7837|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-05-10 18:51:02.9746|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 414.0028ms 2023-05-10 18:51:02.9752|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-05-10 18:51:02.9752|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 501.7215ms 200 application/json; charset=utf-8 2023-05-10 18:51:03.0379|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.AdminSignIn (Authentication)' 2023-05-10 18:51:03.0379|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "AdminSignIn", controller = "Account"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] AdminSignIn(Authentication.Data.Models.Identity.AuthBindingModel) on controller Authentication.Controllers.AccountController (Authentication). 2023-05-10 18:51:03.0379|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 18:51:03.2868|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (14ms) [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-05-10 18:51:03.3162|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 18:51:03.3162|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-05-10 18:51:03.3508|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-05-10 18:51:03.3729|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-05-10 18:51:03.3729|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-05-10 18:51:03.3904|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-05-10 18:51:03.3904|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.Application signed in. 2023-05-10 18:51:03.4003|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].[Biography], [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 [Staffs] AS [s] WHERE [s].[UserId] = @__userInfo_Id_0 2023-05-10 18:51:03.6400|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-05-10 18:51:03.6400||WARN|Authentication.Controllers.AccountController|Role is SUPER ADMIN 2023-05-10 18:51:03.6489|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-05-10 18:51:03.8947|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-05-10 18:51:03.9170|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-05-10 18:51:03.9170||INFO|Authentication.Controllers.AccountController|user: RIVE66 - Maria Simeon-Godfrey role is gotten 2023-05-10 18:51:03.9170|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 [Staffs] AS [s] WHERE [s].[UserId] = @__userInfo_Id_0 2023-05-10 18:51:03.9170|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__roleName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT [r].[Id], [r].[CreatedBy], [r].[DateCreated], [r].[DateUpdated], [r].[IsActive], [r].[IsDeleted], [r].[PermissionId], [r].[RoleId], [r].[RowVersion], [r].[UpdatedBy] FROM [RolePermissions] AS [r] INNER JOIN [AspNetRoles] AS [a] ON [r].[RoleId] = [a].[Id] WHERE ([a].[Name] = @__roleName_0) AND ([r].[IsActive] = CAST(1 AS bit)) 2023-05-10 18:51:03.9305|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 18:51:03.9305|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 18:51:03.9305|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 18:51:03.9305|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 18:51:03.9305|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 18:51:03.9305|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 18:51:03.9305|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 18:51:03.9305|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 18:51:03.9305|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 18:51:03.9305|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 18:51:03.9305|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 18:51:03.9305|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 18:51:03.9305|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 18:51:03.9305|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 18:51:03.9305|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 18:51:03.9305|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 18:51:03.9305|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 18:51:03.9431|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 18:51:03.9431|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 18:51:03.9431|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 18:51:03.9431|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 18:51:03.9431|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 18:51:03.9431|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 18:51:03.9431|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 18:51:03.9431|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 18:51:03.9431|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 18:51:03.9431|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 18:51:04.0145|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2023-05-10 18:51:04.0198|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.AdminSignIn (Authentication) in 977.5543ms 2023-05-10 18:51:04.0198|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.AdminSignIn (Authentication)' 2023-05-10 18:51:04.0198|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1318.1657ms 200 application/json; charset=utf-8 2023-05-10 19:20:58.3635|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:17943/AUTHENTICATION/iisintegration 0 2023-05-10 19:20:58.3635|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.0492ms 202 2023-05-10 21:49:03.0739||DEBUG|Authentication.Program|init main function 2023-05-10 21:49:03.7958|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 21:49:03.9721|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-05-10 21:49:03.9902|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-05-10 21:49:03.9902|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2023-05-10 21:49:03.9902|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2023-05-10 21:49:03.9902|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2023-05-10 21:49:04.0136|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2023-05-10 21:49:04.0870|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 2023-05-10 21:49:04.0870|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-05-10 21:49:04.0870|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {bb702aa2-e41e-47ef-a3cc-a9e079ff4e52} with creation date 2023-05-10 20:49:04Z, activation date 2023-05-10 20:49:04Z, and expiration date 2023-08-08 20:49:04Z. 2023-05-10 21:49:04.0975|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {bb702aa2-e41e-47ef-a3cc-a9e079ff4e52} may be persisted to storage in unencrypted form. 2023-05-10 21:49:04.3943|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Authentication/api/RolePermissionManager/GetAllPermissions 2023-05-10 21:49:04.4309|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 21:49:04.4309|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-05-10 21:49:04.4584|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-05-10 21:49:04.4584|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 21:49:04.4584|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Authentication/api/Account/Admin/SignIn 2023-05-10 21:49:04.4710|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 21:49:04.4710|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 4.2991ms 204 2023-05-10 21:49:04.4964|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 21:49:04.6257|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-05-10 21:49:04.6743|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-05-10 21:49:04.6743|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://api.skilldorm.com/Authentication/api/Account/Admin/SignIn application/json 43 2023-05-10 21:49:04.6743|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2023-05-10 21:49:04.6959|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'Authentication.Controllers.AccountController.AdminSignIn (Authentication)' 2023-05-10 21:49:04.6959|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "AdminSignIn", controller = "Account"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] AdminSignIn(Authentication.Data.Models.Identity.AuthBindingModel) on controller Authentication.Controllers.AccountController (Authentication). 2023-05-10 21:49:04.6959|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 21:49:04.7421|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication) in 281.2172ms 2023-05-10 21:49:04.7421|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.RolePermissionManagerController.GetAllPermissionAsync (Authentication)' 2023-05-10 21:49:04.7421|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 351.0012ms 200 application/json; charset=utf-8 2023-05-10 21:49:04.8058|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-05-10 21:49:04.8380|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2023-05-10 21:49:04.8453|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-05-10 21:49:04.8694|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-05-10 21:49:04.8914|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-05-10 21:49:04.8967|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-05-10 21:49:04.9090|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-05-10 21:49:04.9090|10|INFO|Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler|AuthenticationScheme: Identity.Application signed in. 2023-05-10 21:49:04.9090|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].[Biography], [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 [Staffs] AS [s] WHERE [s].[UserId] = @__userInfo_Id_0 2023-05-10 21:49:05.0644|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-05-10 21:49:05.0659||WARN|Authentication.Controllers.AccountController|Role is SUPER ADMIN 2023-05-10 21:49:05.0659|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-05-10 21:49:05.2152|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-05-10 21:49:05.2372|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-05-10 21:49:05.2372||INFO|Authentication.Controllers.AccountController|user: RIVE66 - Maria Simeon-Godfrey role is gotten 2023-05-10 21:49:05.2372|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 [Staffs] AS [s] WHERE [s].[UserId] = @__userInfo_Id_0 2023-05-10 21:49:05.2372|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__roleName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30'] SELECT [r].[Id], [r].[CreatedBy], [r].[DateCreated], [r].[DateUpdated], [r].[IsActive], [r].[IsDeleted], [r].[PermissionId], [r].[RoleId], [r].[RowVersion], [r].[UpdatedBy] FROM [RolePermissions] AS [r] INNER JOIN [AspNetRoles] AS [a] ON [r].[RoleId] = [a].[Id] WHERE ([a].[Name] = @__roleName_0) AND ([r].[IsActive] = CAST(1 AS bit)) 2023-05-10 21:49:05.2372|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 21:49:05.2517|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 21:49:05.2517|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 21:49:05.2517|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 21:49:05.2517|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 21:49:05.2517|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 21:49:05.2517|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 21:49:05.2517|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 21:49:05.2517|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 21:49:05.2517|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 21:49:05.2517|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 21:49:05.2517|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 21:49:05.2517|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 21:49:05.2517|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 21:49:05.2517|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 21:49:05.2517|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 21:49:05.2517|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 21:49:05.2517|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 21:49:05.2517|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 21:49:05.2517|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 21:49:05.2517|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 21:49:05.2517|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 21:49:05.2517|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 21:49:05.2517|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 21:49:05.2675|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 21:49:05.2675|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 21:49:05.2675|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[@__perm_PermissionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Code] FROM [Permissions] AS [p] WHERE [p].[Id] = @__perm_PermissionId_0 2023-05-10 21:49:05.3281|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 2023-05-10 21:49:05.3281|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action Authentication.Controllers.AccountController.AdminSignIn (Authentication) in 633.493ms 2023-05-10 21:49:05.3281|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'Authentication.Controllers.AccountController.AdminSignIn (Authentication)' 2023-05-10 21:49:05.3281|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 654.6842ms 200 application/json; charset=utf-8 2023-05-10 22:24:19.2306|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:22767/AUTHENTICATION/iisintegration 0 2023-05-10 22:24:19.2306|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1.0832ms 202