Prerequisites What is your product version? - v10.3.0 What is your product type (Angular or MVC)? - Angular What is product framework type (.net framework or .net core)? - .NET 5.0 ABP Framework What is ABP Framework version? - 6.3.0
Import from excel user not working & Move tenant to another editions also not working. logs files INFO 2021-06-07 21:18:59,893 [25 ] Microsoft.AspNetCore.Hosting.Diagnostics - Request starting HTTP/2 OPTIONS https://localhost:44388/Users/ImportFromExcel - - INFO 2021-06-07 21:18:59,894 [25 ] pNetCore.Cors.Infrastructure.CorsService - CORS policy execution successful. INFO 2021-06-07 21:18:59,895 [25 ] Microsoft.AspNetCore.Hosting.Diagnostics - Request finished HTTP/2 OPTIONS https://localhost:44388/Users/ImportFromExcel - - - 204 - - 1.7668ms INFO 2021-06-07 21:18:59,900 [25 ] Microsoft.AspNetCore.Hosting.Diagnostics - Request starting HTTP/2 POST https://localhost:44388/Users/ImportFromExcel multipart/form-data;+boundary=----WebKitFormBoundaryWk4KQga0Hl9W2dIx 11315 INFO 2021-06-07 21:18:59,900 [25 ] pNetCore.Cors.Infrastructure.CorsService - CORS policy execution successful. INFO 2021-06-07 21:18:59,933 [25 ] uthentication.JwtBearer.JwtBearerHandler - Successfully validated the token. INFO 2021-06-07 21:18:59,933 [25 ] uthorization.DefaultAuthorizationService - Authorization was successful. INFO 2021-06-07 21:18:59,933 [25 ] ft.AspNetCore.Routing.EndpointMiddleware - Executing endpoint 'SmartSuite.Web.Controllers.UsersController.ImportFromExcel (SmartSuite.Web.Host)' INFO 2021-06-07 21:18:59,939 [25 ] c.Infrastructure.ControllerActionInvoker - Route matched with {action = "ImportFromExcel", controller = "Users", area = ""}. Executing controller action with signature System.Threading.Tasks.Task 1[Microsoft.AspNetCore.Mvc.JsonResult] ImportFromExcel() on controller SmartSuite.Web.Controllers.UsersController (SmartSuite.Web.Host). INFO 2021-06-07 21:18:59,972 [25 ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'SmartSuiteDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None INFO 2021-06-07 21:19:00,214 [27 ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (121ms) [Parameters=[@__ef_filter__p_0='?' (DbType = Boolean), @__ef_filter__p_1='?' (DbType = Boolean), @__p_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [a].[Id], [a].[AccessFailedCount], [a].[AuthenticationSource], [a].[ConcurrencyStamp], [a].[CreationTime], [a].[CreatorUserId], [a].[DefaultCost], [a].[DeleterUserId], [a].[DeletionTime], [a].[Designation], [a].[EmailAddress], [a].[EmailConfirmationCode], [a].[GoogleAuthenticatorKey], [a].[IsActive], [a].[IsDeleted], [a].[IsEmailConfirmed], [a].[IsLockoutEnabled], [a].[IsPhoneNumberConfirmed], [a].[IsProfile], [a].[IsTwoFactorEnabled], [a].[LastModificationTime], [a].[LastModifierUserId], [a].[LockoutEndDateUtc], [a].[Name], [a].[NormalizedEmailAddress], [a].[NormalizedUserName], [a].[Password], [a].[PasswordResetCode], [a].[PhoneNumber], [a].[ProfilePictureId], [a].[SecurityStamp], [a].[ShouldChangePasswordOnNextLogin], [a].[SignInToken], [a].[SignInTokenExpireTimeUtc], [a].[Surname], [a].[Tags], [a].[TenantId], [a].[Timezone], [a].[UserName] FROM [AbpUsers] AS [a]
INFO : we are enable Hangfire also our project.
Thanks In an advance
Hi Team , SignalR is not working with linked account, I have added same emeil in two different tenant and add it into the manges linked account but when I tried to login to my linked tenant, signalr is not working then. so I need to logout then login agian for singalR wokring. and also when I have debugged it , I got that in SetToken method in AuthConfigure.cs ** enc_auth_token** is getting undefined when we login through linked account
Thanks
Prerequisites What is your product version? - v10.3.0 What is your product type (Angular or MVC)? - Angular What is product framework type (.net framework or .net core)? - .NET 5.0 ABP Framework What is ABP Framework version? - 6.3.0
https://zapier.com/dashboard/auth/oauth/return/App132526CLIAPI/?code= 9504268F8F72595A584632DCC41BA714FD0E6F66ACAA1D98C5C7A624A506ACB2 &scope=openid%20profile&state=1619849405.892335418086&session_state= SUzwxewZNZuse1WmKJ0hAlAxXhtikOJYUiIN_w1BiJM.24CD3E5A944C9C60366BDE1C75B2052B
I am using code parameter,redirect_uri & session_state(code_verifier) from the link whis is navigate after successfull login.
Tryied also
INFO 2021-05-01 11:41:28,145 [72 ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'SmartSuiteDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None INFO 2021-05-01 11:41:28,395 [72 ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (120ms) [Parameters=[@__p_0='?' (Size = 200)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [a].[Id], [a].[ClientId], [a].[ConsumedTime], [a].[CreationTime], [a].[Data], [a].[Description], [a].[Expiration], [a].[SessionId], [a].[SubjectId], [a].[Type] FROM [AbpPersistedGrants] AS [a] WHERE [a].[Id] = @__p_0 WARN 2021-05-01 11:41:28,396 [72 ] EntityFrameworkCore.Database.Transaction - Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(RelationalEventId.SavepointsDisabledBecauseOfMARS))'. INFO 2021-05-01 11:41:28,512 [141 ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (116ms) [Parameters=[@p0='?' (Size = 200)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; DELETE FROM [AbpPersistedGrants] WHERE [Id] = @p0; SELECT @@ROWCOUNT; ERROR 2021-05-01 11:41:28,640 [141 ] Server4.Validation.TokenRequestValidator - Transformed code verifier does not match code challenge, { "ClientId": "demo_test", "ClientName": "MVC Client Demo", "GrantType": "authorization_code", "AuthorizationCode": "****ACB2", "RefreshToken": "********", "Raw": { "grant_type": "authorization_code", "redirect_uri": "https://zapier.com/dashboard/auth/oauth/return/App132526CLIAPI/", "code": "9504268F8F72595A584632DCC41BA714FD0E6F66ACAA1D98C5C7A624A506ACB2", "Client_id": "demo_test", "Client_Secret": "REDACTED", "scope": "read", "code_verifier": "SUzwxewZNZuse1WmKJ0hAlAxXhtikOJYUiIN_w1BiJM.24CD3E5A944C9C60366BDE1C75B2052B" } } INFO 2021-05-01 11:41:28,642 [141 ] Microsoft.AspNetCore.Hosting.Diagnostics - Request finished HTTP/1.1 POST https://localhost:44301/connect/token application/x-www-form-urlencoded 367 - 400 - application/json;+charset=UTF-8 878.6848ms
Thanks
Prerequisites What is your product version? - v10.3.0 What is your product type (Angular or MVC)? - Angular What is product framework type (.net framework or .net core)? - .NET 5.0 ABP Framework What is ABP Framework version? - 6.3.0
WHERE @@ROWCOUNT = 1 AND [Id] = scope_identity(); INFO 2021-04-29 11:59:33,933 [87 ] vc.Infrastructure.RedirectResultExecutor - Executing RedirectResult, redirecting to /connect/authorize/callback?client_id=demo&redirect_uri=https://zapier.com/dashboard/auth/oauth/return/App132013CLIAPI/&response_type=code&scope=openid&state=1619677695.115864560706. INFO 2021-04-29 11:59:33,933 [87 ] c.Infrastructure.ControllerActionInvoker - Executed action SmartSuite.Web.Controllers.UiController.Login (SmartSuite.Web.Host) in 20762.3117ms INFO 2021-04-29 11:59:33,934 [87 ] ft.AspNetCore.Routing.EndpointMiddleware - Executed endpoint 'SmartSuite.Web.Controllers.UiController.Login (SmartSuite.Web.Host)' INFO 2021-04-29 11:59:33,936 [65 ] Microsoft.AspNetCore.Hosting.Diagnostics - Request finished HTTP/2 POST https://localhost:44301/Ui/Login?client_id=demo&state=1619677695.115864560706&redirect_uri=https%3A%2F%2Fzapier.com%2Fdashboard%2Fauth%2Foauth%2Freturn%2FApp132013CLIAPI%2F&response_type=code&scope=openid application/x-www-form-urlencoded 321 - 302 - - 20785.1545ms INFO 2021-04-29 11:59:33,946 [65 ] Microsoft.AspNetCore.Hosting.Diagnostics - Request starting HTTP/2 GET https://localhost:44301/connect/authorize/callback?client_id=demo&redirect_uri=https://zapier.com/dashboard/auth/oauth/return/App132013CLIAPI/&response_type=code&scope=openid&state=1619677695.115864560706 - - INFO 2021-04-29 11:59:33,995 [65 ] Server4.Hosting.IdentityServerMiddleware - Invoking IdentityServer endpoint: IdentityServer4.Endpoints.AuthorizeCallbackEndpoint for /connect/authorize/callback ERROR 2021-04-29 11:59:34,046 [65 ] er4.Validation.AuthorizeRequestValidator - code_challenge is missing { "ClientId": "demo", "ClientName": "MVC Client Demo", "RedirectUri": "https://zapier.com/dashboard/auth/oauth/return/App132013CLIAPI/", "AllowedRedirectUris": [ "https://zapier.com/dashboard/auth/oauth/return/App132013CLIAPI/" ], "SubjectId": "2", "ResponseType": "code", "ResponseMode": "query", "GrantType": "authorization_code", "RequestedScopes": "", "State": "1619677695.115864560706", "PromptMode": "", "Raw": { "client_id": "demo", "redirect_uri": "https://zapier.com/dashboard/auth/oauth/return/App132013CLIAPI/", "response_type": "code", "scope": "openid", "state": "1619677695.115864560706" } } ERROR 2021-04-29 11:59:34,047 [65 ] ver4.Endpoints.AuthorizeCallbackEndpoint - Request validation failed INFO 2021-04-29 11:59:34,048 [65 ] ver4.Endpoints.AuthorizeCallbackEndpoint - { "ClientId": "demo", "ClientName": "MVC Client Demo", "RedirectUri": "https://zapier.com/dashboard/auth/oauth/return/App132013CLIAPI/", "AllowedRedirectUris": [ "https://zapier.com/dashboard/auth/oauth/return/App132013CLIAPI/" ], "SubjectId": "2", "ResponseType": "code", "ResponseMode": "query", "GrantType": "authorization_code", "RequestedScopes": "", "State": "1619677695.115864560706", "PromptMode": "", "Raw": { "client_id": "demo", "redirect_uri": "https://zapier.com/dashboard/auth/oauth/return/App132013CLIAPI/", "response_type": "code", "scope": "openid", "state": "1619677695.115864560706" } }
How we pass code_challenge?
Can we arrage a call we have some issue related OAuth and it is very hard to expain through messages.
Prerequisites What is your product version? - v10.3.0 What is your product type (Angular or MVC)? - Angular What is product framework type (.net framework or .net core)? - .NET 5.0 ABP Framework What is ABP Framework version? - 6.3.0
Access Token Request Enter the API endpoint URL where Zapier sends the approval code on user redirect, typically via POST, and receives access_token in the response.
Could you please tell what Url we need to use Access Token Request.
Thanks in an advance
I need to upgrade my application so i download latest project but i get error on custom repository for sp integration.
Context cant find i tryied with old version(v8.9.2) its working fine but in new downloaded project getting error in Context.Database.GetDbConnection();
could you please help.
Thanks in an advance.
What is your product version - v8.9.2** What is your product type (Angular or MVC) - Angular What is product framework type (.net framework or .net core) - net core 3.1
What is ABP Framework version - yes version 5.9.0
I have enable Identity Server 4 Integration & testing with client (ConsoleApiClient) working fine but getting error with MVC Client Testing with MVC Client
Added new client in appsettings.json
& download project aspnet-zero-samples(https://github.com/aspnetzero/aspnet-zero-samples ) -> IdentityServerClient project to test identity server with mvc client & update start up file.
but run both project & click secure tab
Getting the error could you please help to resolved this.
Testing with Client ASP.NET Zero solution has a sample console application (ConsoleApiClient) that can connects to the application, authenticates through IdentityServer4 and calls an API. working fine for me & getting valid result.
Thanks in an advance
What is your product version? V8.7 What is your product type (Angular or MVC)? ANGULAR What is product framework type (.net framework or .net core)? .NET CORE
Hi,
I have activated IdentityServer in my project & try to access with ConsoleApiClient I'm unable to authorize Zapier application to access my app API : the process is simple, Zapier calls my identityserver login endpoint with a returnurl. Then, the user can connect with its app credentials.
But i am trying this with zapier but facing issue on configuration could you please help.
In step 1. but in step 2 where we use the url in our app https://zapier.com/dashboard/auth/oauth/return/App132013CLIAPI/ step 3 - Authorization URL Specify where to send users to authenticate with your API. what url i need to be pass.
could you please provide sample of these or schedule a call for Configuration it will more helpfull for me.
Thanks in an advance
Hi , I am calling the API in swagger and it give me 400 (bad request) but when I have tried to execute the same API using POST man I am able to execute the API. So I investigate it furture and check the logs in azure app service , I got an expection when I am trying to do the post call from swagger.It gives me folling error : idateAntiforgeryTokenAuthorizationFilter - The provided antiforgery token was meant for a different claims-based user than the current user. Microsoft.AspNetCore.Antiforgery.AntiforgeryValidationException: The provided antiforgery token was meant for a different claims-based user than the current user.. It's strange as the same API is working correctly in Postman but not in swagger.
screen shot of postman using same api
Please provide a solution as soon as possible
Thanks
What is your product version - v8.9.2** What is your product type (Angular or MVC) - Angular What is product framework type (.net framework or .net core) - net core 3.1
What is ABP Framework version - yes version 5.9.0
Following these docs for Configuring IdentityServer4 in asp .net zero but we cant getting any error or output also. Could you please provide sample project or conduct call for the issue.
https://docs.aspnetzero.com/en/aspnet-core-angular/v8.9.0/Infrastructure-Core-Angular-Identity-Server4-Integration https://aspnetboilerplate.com/Pages/Zero/Identity-Server-vNext#testing
Thanks in advance