"Spospisil" 'in aktiviteleri

Ok, I was finally able to get this to work. My question now is how can I interrogate whether or not the user was successfully authenticated after the .base.OnPostAsync(action) result is returned. I don't see an obvious way to determine this.

// For example public override async Task<IActionResult> OnPostAsync(string action) { Console.WriteLine("OnPost - Before"); var result = await base.OnPostAsync(action); Console.WriteLine("OnPost - After");

        return result;
    }

Hi,

That resolved what I was trying to accomplish, but I'm still getting other errors. Do you have an working example of a public web site where I can completely override not only the UI aspect of the login page but also put additional logic in the OnPostAsync methed of the login page to do additional processing after the base Volo.Abp.Account.Public.Web.Pages.Account.LoginModel OnPostAsync method runs?

The Volo.EasyCrm real world application does not implement the login page in this same way.

Steve.

Keep in mind I'm trying to override the login page at the 'public' web application level, not Identity Server.

Hi,

I've tried what you suggest and still continue to get an error as shown below.

Just so others can reference should they have similar issues in the future here is the entire set of TablePrefix settings that need to be configured if you want to change the table name prefix for the standard ABP tables.

        builder.ConfigurePermissionManagement(options => { options.TablePrefix = ""; });
        builder.ConfigureSettingManagement(options => { options.TablePrefix = ""; });
        builder.ConfigureBackgroundJobs(options => { options.TablePrefix = ""; });
        builder.ConfigureAuditLogging(options => { options.TablePrefix = ""; });
        builder.ConfigureIdentity(options => { options.TablePrefix = ""; });
        builder.ConfigureIdentityPro(options => { options.TablePrefix = ""; });
        builder.ConfigureIdentityServer(options => { options.TablePrefix = ""; });
        builder.ConfigureFeatureManagement(options => { options.TablePrefix = ""; });
        builder.ConfigureLanguageManagement(options => { options.TablePrefix = ""; });
        builder.ConfigurePayment(options => { options.TablePrefix = ""; });
        builder.ConfigureSaas(options => { options.TablePrefix = ""; });
        builder.ConfigureTextTemplateManagement(options => { options.TablePrefix = ""; });
        builder.ConfigureBlobStoring(options => { options.TablePrefix = ""; });



        AbpPermissionManagementDbProperties.DbTablePrefix = string.Empty;
        AbpSettingManagementDbProperties.DbTablePrefix = string.Empty;
        BackgroundJobsDbProperties.DbTablePrefix = string.Empty;
        AbpAuditLoggingDbProperties.DbTablePrefix = string.Empty;
        BlobStoringDatabaseDbProperties.DbTablePrefix = string.Empty;
        AbpCommonDbProperties.DbTablePrefix = string.Empty;
        FeatureManagementDbProperties.DbTablePrefix = string.Empty;
        LanguageManagementDbProperties.DbTablePrefix = string.Empty;
        SaasDbProperties.DbTablePrefix = string.Empty;
        TextTemplateManagementDbProperties.DbTablePrefix = string.Empty;
        AbpIdentityDbProperties.DbTablePrefix = string.Empty;
        AbpIdentityServerDbProperties.DbTablePrefix = string.Empty;

• ABP Framework version: v4.4.0
• UI type: MVC
• DB provider: EF Core
• Tiered (MVC) or Identity Server Separated (Angular): yes
• Exception message and stack trace:

• Steps to reproduce the issue:"

I've generated a solution from ABP suite with the above mentioned options. I've chosen to remove all the abp generated prefixes to all the tables using the below code blocks, but when I click the 'Forgot password' link on the standard 'Login Page' and enter the email for the user I wish to send an email to, I get the above detailed error.

I've specified the below code in the program.cs class of the IdentityServer, HttpAPI.Host projects in addition to adding the block to the DbMigratorHostedService.cs class in the DbMirgrator project.

        AbpPermissionManagementDbProperties.DbTablePrefix = string.Empty;
        AbpSettingManagementDbProperties.DbTablePrefix = string.Empty;
        AbpCommonDbProperties.DbTablePrefix = string.Empty;
        SaasDbProperties.DbTablePrefix = string.Empty;
        AbpIdentityServerDbProperties.DbTablePrefix = string.Empty;
        

Additionally in the DBContextBase.cs class of the .EntityFrameworkCore project I've specified this block of code.

        builder.ConfigurePermissionManagement(options => { options.TablePrefix = ""; });
        builder.ConfigureSettingManagement(options => { options.TablePrefix = ""; });
        builder.ConfigureBackgroundJobs(options => { options.TablePrefix = ""; });
        builder.ConfigureAuditLogging(options => { options.TablePrefix = ""; });
        builder.ConfigureIdentityPro(options => { options.TablePrefix = ""; });
        builder.ConfigureIdentityServer(options => { options.TablePrefix = ""; });
        builder.ConfigureFeatureManagement(options => { options.TablePrefix = ""; });
        builder.ConfigureLanguageManagement(options => { options.TablePrefix = ""; });
        builder.ConfigureSaas(options => { options.TablePrefix = ""; });
        builder.ConfigureTextTemplateManagement(options => { options.TablePrefix = ""; });
        builder.ConfigureBlobStoring(options => { options.TablePrefix = ""; });

Applying the following code in the DbMigratorHostedService.cs seemed to have resolved all the errors I was getting.

        AbpPermissionManagementDbProperties.DbTablePrefix = string.Empty;
        AbpSettingManagementDbProperties.DbTablePrefix = string.Empty;
        AbpCommonDbProperties.DbTablePrefix = string.Empty;
        SaasDbProperties.DbTablePrefix = string.Empty;
        AbpIdentityServerDbProperties.DbTablePrefix = string.Empty;

That seems to have solved this particular issue.

now I get this error. I don't want any ABP framework table prefixes on any of the tables created whether it be the host or tenant tables.

SELECT EXISTS ( SELECT 1 FROM "SaasEditions" AS s WHERE (@__ef_filter__p_0 OR NOT (s."IsDeleted")) AND (s."DisplayName" = @__UtyMGa29B_0)) [10:22:17 ERR] An exception occurred while iterating over the results of a query for context type 'Volo.Saas.EntityFrameworkCore.SaasDbContext'. Npgsql.PostgresException (0x80004005): 42P01: relation "SaasEditions" does not exist at Npgsql.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable1.AsyncEnumerator.InitializeReaderAsync(DbContext _, Boolean result, CancellationToken cancellationToken) at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func4 operation, Func4 verifySucceeded, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable1.AsyncEnumerator.MoveNextAsync() Exception data: Severity: ERROR SqlState: 42P01 MessageText: relation "SaasEditions" does not exist Position: 41 File: parse_relation.c Line: 1373 Routine: parserOpenTable Npgsql.PostgresException (0x80004005): 42P01: relation "SaasEditions" does not exist at Npgsql.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable1.AsyncEnumerator.InitializeReaderAsync(DbContext _, Boolean result, CancellationToken cancellationToken) at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func4 operation, Func4 verifySucceeded, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken) Exception data: Severity: ERROR SqlState: 42P01 MessageText: relation "SaasEditions" does not exist Position: 41 File: parse_relation.c Line: 1373 Routine: parserOpenTable

• ABP Framework version: v4.4.0
• UI type: MVC
• DB provider: EF Core
• Tiered (MVC) or Identity Server Separated (Angular): Not Tiered/Seperate Schema

After generating a MVC/EF Core/PostgreSQL/Not Tiered/Seperate Schema solution with ABP suite, I run the two migrations and see the data, but when I run the web project I get the following error.

Tenant not found! There is no tenant with the tenant id or name: 39fe712f-a185-00ae-3daa-3b94ccc3ecaa