[OpenID Connect] - Http failure response api/abp/application-configuration #6911 | Support

trannguyenphucanh created 9 months ago

ABP Framework version: v8.0.4
UI Type: Angular
Database System: EF Core (MySQL)
Tiered (for MVC) or Auth Server Separated (for Angular): yes
Exception message and full stack trace:
Steps to reproduce the issue:

Hi Support Team,

I encountered this issue after brought the framework to develop environment, got my App client uris modified:

The error:

Access log from nginx server:

connect() failed (111: Connection refused) while connecting to upstream, client: 115.79.30.28, server: dev-api-bts.belfor.asia, request: "GET /api/abp/application-configuration HTTP/2.0", upstream: "http://172.16.220.21:44355/api/abp/application-configuration", host: "dev-api-bts.belfor.asia", referrer: "https://dev-bts.belfor.asia/

Could you guys take a look? I assume it is due to the migration from IdentityServer toOpenIdDict. I already overridden docker-compose.yml environment variables following the new appsettings.json in DbMigrator:

Am I missing a configuration or something?

12 Answer(s)

0

maliming created 9 months ago
Support Team Fullstack Developer

hi

Are there any logs on the upstream website(http://172.16.220.21:44355/api/abp/application-configuration")?
0

trannguyenphucanh created 9 months ago

It is the API IP and port number of our docker. Aside, I just traced back the migration progress in my local environment, I upgraded 3 time, from 5.3.3 => 6.0, from 6.0 => 7.0 and from 7.0 to 8.0.4, hence 3 migration files were created:

https://drive.google.com/file/d/19WcH-gXHVRtBrHXovyK7_l3RQMZ4PdZD/view?usp=sharing https://drive.google.com/file/d/1qTVN7Wkdl9eUUv7i5flq70fBWp0QEiSu/view?usp=sharing https://drive.google.com/file/d/1oMXbwUh1oA8pHK_dagqgiymiQK_2Qmnc/view?usp=sharing

There was migration error in the 2nd migration, here is the log: https://drive.google.com/file/d/1TgK1hf6HF2hyYeK9QodGGY0IYJrs8BxO/view?usp=sharing

I noticed it selected columns inside abppermissiongroups and abpfeaturegroups while the migration only contains creating tables & indexes, hence Table 'abppermissiongroups/abpfeaturegroups' doesn't exist exceptions were thrown:

Could you take a look? Are the migration files incorrect or insufficient some parts?
0

trannguyenphucanh created 9 months ago

Hi, any update?

Please investigate. It is urgent for me.
0

maliming created 9 months ago
Support Team Fullstack Developer

hi

Table 'timesheet_dev.abppermissiongroups' doesn't exist

Does the abppermissiongroups table exist on your database? Are you using the same version of abp for all of your websites?

Can you share a project to reproduce this error?

We must look at the code or the project to troubleshoot the problem.
0

trannguyenphucanh created 9 months ago

As I was upgrading from v6 to v7, both abppermissiongroups & abpfeaturegroups only appeared in the database after I ran database-update for the 2nd migration, as you can see in the log file, although there were errors, it completed database migration nonetheless, I ignored them and kept upgrading to v8. The consequence didn't ensue until I deployed all changes to develop environment just as the 1st post. Therefore I suspect it could be them being the culprit.

I am using ABP v8.0.4 in both Web & API sides. All compatible.

I am unable to share the project due to regulation, unfortunately. But would you mind upgrading a sample one from v6 to v7 and share the generated migration file, for comparison?

I am still baffled as to why did it tried to select a non-existing table in even before create it, the migration clearly doesn't have any similar statement...
0

maliming created 9 months ago
Support Team Fullstack Developer

hi

You can try to set the AddDataMigrationEnvironment option in DbMigratorHostedService
0

trannguyenphucanh created 9 months ago

Hi maliming,

Thanks, migration errors are gone. But unfortunately, it is not the root cause, the problem still persists on my develop environment.
0

maliming created 9 months ago
Support Team Fullstack Developer

hi

the problem still persists on my develop environment.

Which project still has the error? Please share the error logs.

Thanks.
0

trannguyenphucanh created 9 months ago

Hi, I decided to break each completed version for each deployment instead of bringing everything at once.

I just deployed v6, encountered this server only accepts https requests then resolved. However, the UI didn't show login page but instead this: Console log:
0

maliming created 9 months ago
Support Team Fullstack Developer

hi

Please check the issuer of your environment.ts

https://github.com/abpframework/abp/blob/dev/templates/app/angular/src/environments/environment.ts#L13

trannguyenphucanh created 8 months ago

Just replaced this inside OnApplicationInitialization, from

            app.Use(async (ctx, next) =>
            {
                await next();
            });

            app.Use((httpContext, next) =>
            {
                httpContext.Request.Scheme = "https";
                return next();
            });

Solved my problem.

0

maliming created 8 months ago
Support Team Fullstack Developer

Great!

Have an answer to this question? Log in and write your answer.