Exception while connecting ошибка

Hi guys. This error falls from my service, has anyone encountered this ?!

The issue

System.InvalidOperationException: An exception has been raised that is likely due to a transient failure.
—> Npgsql.NpgsqlException (0x80004005): Exception while connecting —>
System.Net.Sockets.SocketException (113): No route to host
at System.Net.Sockets.Socket.AwaitableSocketAsyncEventArgs.ThrowException
(SocketError error, CancellationToken cancellationToken) at System.Net.Sockets.Socket.AwaitableSocketAsyncEventArgs.System.Threading.
Tasks.Sources.IValueTaskSource.GetResult(Int16 token) at System.Net.Sockets.Socket.g__WaitForConnectWithCancellation|
283_0(AwaitableSocketAsyncEventArgs saea, ValueTask connectTask, CancellationToken cancellationToken) at Npgsql.NpgsqlConnector.Con
nectAsync(NpgsqlTimeout timeout, CancellationToken cancellationToken) at Npgsql.NpgsqlConnector.ConnectAsync(NpgsqlTimeout timeout
, CancellationToken cancellationToken) at Npgsql.NpgsqlConnector.RawOpen(NpgsqlTimeout timeout, Boolean async, CancellationTok
en cancellationToken) at Npgsql.NpgsqlConnector.Open(NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
at Npgsql.ConnectorPool.OpenNewConnector(NpgsqlConnection conn, NpgsqlTimeout timeout, Boolean async, CancellationToken cance
llationToken) at Npgsql.ConnectorPool.<>c__DisplayClass38_0.<g__RentAsync|0>d.MoveNext() — End of stack trace from pre
vious location — at Npgsql.NpgsqlConnection.<>c__DisplayClass41_0.<g__OpenAsync|0>d.MoveNext() — End of
stack trace from previous location — at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAs
ync(Boolean errorsExpected, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.Relationa
lConnection.OpenInternalAsync(Boolean errorsExpected, CancellationToken cancellationToken) at Microsoft.EntityFrame
workCore.Storage.RelationalConnection.OpenAsync(CancellationToken cancellationToken, Boolean errorsExpected) at Mic
rosoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterO
bject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable
1.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) --- End of inner exception stack trac e --- at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult]( TState state, Func4 operation, Func4 verifySucceeded, CancellationToken cancellationToken) at Microsoft.EntityFrame workCore.Query.Internal.SingleQueryingEnumerable1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.
Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable1 asyncEnumerable, Cancel lationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOr DefaultAsync[TSource](IAsyncEnumerable1 asyncEnumerable, CancellationToken cancellationToken) at WebService.Infrast
ructure.Repositories.TemplateRepo.GetAsyncByCode(String code)
in /src/WebService/WebService.Infrastructure/Repositories/TemplateRepo.cs:line
31 at WebService.Api.Commands.CreateDocComHandl.Handle(CreateDocumentCommand requ
est, CancellationToken cancellationToken) in /src/WebService/WebService.Api/Commands/CreateDocum
entCommand.cs:line 90 at MediatR.Pipeline.RequestExceptionProcessorBehavior2.Handle(TRequest re quest, CancellationToken cancellationToken, RequestHandlerDelegate1 next) at MediatR.Pipeline.Re
questExceptionProcessorBehavior2.Handle(TRequest request, CancellationToken cancellationToken, Re questHandlerDelegate1 next) at MediatR.Pipeline.RequestExceptionActionProcessorBehavior2.Handle (TRequest request, CancellationToken cancellationToken, RequestHandlerDelegate1 next) at MediatR.
Pipeline.RequestExceptionActionProcessorBehavior2.Handle(TRequest request, CancellationToken cance llationToken, RequestHandlerDelegate1 next) at MediatR.Pipeline.RequestPostProcessorBehavior2.Handle (TRequest request, CancellationToken cancellationToken, RequestHandlerDelegate1 next) at
MediatR.Pipeline.RequestPreProcessorBehavior2.Handle(TRequest request, CancellationToken cancellationToken, RequestHandlerDelegate1 next) at WebService.Api.Controllers.WebServiceController.
CreateDocument(CreateDocumentCommand request)
in /src/WebService/WebService.Api/Controllers/WebServiceController.cs:line 36
at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.Execut
e(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] argume
nts) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__
Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask) at Microsoft.AspNetCore
.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|10_0(ControllerActio
nInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at
Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state
, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state,
Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awa
ited|19_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at
Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|17_0(ResourceInvoker invoker, Task
task, IDisposable scope) at Microsoft.AspNetCore.Routing.EndpointMiddleware.g__AwaitRequestTask|6_0(Endpoint endpoint, Tas
k requestTask, ILogger logger) at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context) at Core.AspNetCore.Builder.HttpEx
ceptionHandlerMiddleware.Invoke(HttpContext context)

Logs PostgrSql

2021-12-20 20: 38: 35.737 MSK [715] MESSAGE: Failed to receive data from client: Connection dropped by other side
2021-12-20 20: 38: 35.737 MSK [716] MESSAGE: Failed to receive data from client: Connection dropped by other side
2021-12-20 20: 38: 35.737 MSK [717] MESSAGE: Failed to receive data from client: Connection dropped by other side
2021-12-20 20: 38: 35.742 MSK [713] MESSAGE: Failed to receive data from client: Connection dropped by other side
2021-12-20 20: 38: 35.774 MSK [14866] MESSAGE: Failed to send data to the client: Channel break
2021-12-20 20: 38: 35.774 MSK [14866] IMPORTANT: connection to the client is lost
2021-12-20 20: 38: 35.790 MSK [9887] MESSAGE: Failed to send data to the client: Channel break
2021-12-20 20: 38: 35.790 MSK [9887] IMPORTANT: connection to the client is lost

Further technical details

Microsoft.EntityFrameworkCore.Design Version=»5.0.6″
Npgsql.EntityFrameworkCore.PostgreSQL» Version=»5.0.6″

Пытаюсь подключится к бд находящуюся на удаленной машине, под управлением ubuntu server. При попытке подключения
вылетает ошибка

SocketException: No connection could be made because the target machine actively refused it.

При попытке подключится через Package Manager Console вылетает следующие:

PM> Scaffold-DbContext "Host=<MyWhiteIP>;Port=5432;Database=name;Username=name;Password=password"
cmdlet Scaffold-DbContext at command pipeline position 1
Supply values for the following parameters:
Provider: Npgsql.EntityFrameworkCore.PostgreSQL
Build started...
Build succeeded.
To protect potentially sensitive information in your connection string, you should move it out of source code. You can avoid scaffolding the connection string by using the Name= syntax to read it from configuration - see https://go.microsoft.com/fwlink/?linkid=2131148. For more guidance on storing connection strings, see http://go.microsoft.com/fwlink/?LinkId=723263.
Npgsql.NpgsqlException (0x80004005): Exception while connecting
 ---> System.Net.Sockets.SocketException (10061): No connection could be made because the target machine actively refused it.
   at Npgsql.NpgsqlConnector.Connect(NpgsqlTimeout timeout)
   at Npgsql.NpgsqlConnector.Connect(NpgsqlTimeout timeout)
   at Npgsql.NpgsqlConnector.RawOpen(NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlConnector.Open(NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
   at Npgsql.ConnectorPool.OpenNewConnector(NpgsqlConnection conn, NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
   at Npgsql.ConnectorPool.<>c__DisplayClass38_0.<<Rent>g__RentAsync|0>d.MoveNext()
--- End of stack trace from previous location ---
   at Npgsql.NpgsqlConnection.<>c__DisplayClass41_0.<<Open>g__OpenAsync|0>d.MoveNext()
--- End of stack trace from previous location ---
   at Npgsql.NpgsqlConnection.Open()
   at Npgsql.EntityFrameworkCore.PostgreSQL.Scaffolding.Internal.NpgsqlDatabaseModelFactory.Create(DbConnection dbConnection, DatabaseModelFactoryOptions options)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Scaffolding.Internal.NpgsqlDatabaseModelFactory.Create(String connectionString, DatabaseModelFactoryOptions options)
   at Microsoft.EntityFrameworkCore.Scaffolding.Internal.ReverseEngineerScaffolder.ScaffoldModel(String connectionString, DatabaseModelFactoryOptions databaseOptions, ModelReverseEngineerOptions modelOptions, ModelCodeGenerationOptions codeOptions)
   at Microsoft.EntityFrameworkCore.Design.Internal.DatabaseOperations.ScaffoldContext(String provider, String connectionString, String outputDir, String outputContextDir, String dbContextClassName, IEnumerable`1 schemas, IEnumerable`1 tables, String modelNamespace, String contextNamespace, Boolean useDataAnnotations, Boolean overwriteFiles, Boolean useDatabaseNames, Boolean suppressOnConfiguring, Boolean noPluralize)
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.ScaffoldContextImpl(String provider, String connectionString, String outputDir, String outputDbContextDir, String dbContextClassName, IEnumerable`1 schemaFilters, IEnumerable`1 tableFilters, String modelNamespace, String contextNamespace, Boolean useDataAnnotations, Boolean overwriteFiles, Boolean useDatabaseNames, Boolean suppressOnConfiguring, Boolean noPluarlize)
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.ScaffoldContext.<>c__DisplayClass0_0.<.ctor>b__0()
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.<>c__DisplayClass3_0`1.<Execute>b__0()
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action)
Exception while connecting

tcpdump на стороне сервера прослушивая порт 5432 ловит пачку пакетов во время попытки подключения, но установить соединение так и не удается. Пробовал пробросить порт и отключить брандмауэр, но не помогло.

I have a docker compose file, I have a postgres instance being brough up, and a web api project also, however I am getting the following error:

api_1       |       Application startup exception
api_1       | Npgsql.NpgsqlException (0x80004005): Exception while connecting
api_1       |  ---> System.TimeoutException: Timeout during connection attempt
api_1       |    at Npgsql.NpgsqlConnector.Connect(NpgsqlTimeout timeout)
api_1       |    at Npgsql.NpgsqlConnector.Connect(NpgsqlTimeout timeout)
api_1       |    at Npgsql.NpgsqlConnector.RawOpen(NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
api_1       |    at Npgsql.NpgsqlConnector.Open(NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
api_1       |    at Npgsql.NpgsqlConnection.<>c__DisplayClass32_0.<<Open>g__OpenLong|0>d.MoveNext()
api_1       | --- End of stack trace from previous location where exception was thrown ---
api_1       |    at Npgsql.NpgsqlConnection.Open()
api_1       |    at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlDatabaseCreator.Exists()
api_1       |    at Microsoft.EntityFrameworkCore.Migrations.HistoryRepository.Exists()
api_1       |    at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration)
api_1       |    at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.Migrate(DatabaseFacade databaseFacade)
api_1       |    at my.Claims.Engine.Api.Startup.Configure(IApplicationBuilder app, IWebHostEnvironment env, myDbContext ctx) in /src/my.Claims.Engine.Api/Startup.cs:line 56
api_1       |    at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor, Boolean wrapExceptions)
api_1       |    at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
api_1       |    at Microsoft.AspNetCore.Hosting.ConfigureBuilder.Invoke(Object instance, IApplicationBuilder builder)
api_1       |    at Microsoft.AspNetCore.Hosting.ConfigureBuilder.<>c__DisplayClass4_0.<Build>b__0(IApplicationBuilder builder)
api_1       |    at Microsoft.AspNetCore.Hosting.GenericWebHostBuilder.<>c__DisplayClass13_0.<UseStartup>b__2(IApplicationBuilder app)
api_1       |    at Microsoft.AspNetCore.Mvc.Filters.MiddlewareFilterBuilderStartupFilter.<>c__DisplayClass0_0.<Configure>g__MiddlewareFilterBuilder|0(IApplicationBuilder builder)
api_1       |    at Microsoft.AspNetCore.HostFilteringStartupFilter.<>c__DisplayClass0_0.<Configure>b__0(IApplicationBuilder app)
api_1       |    at Microsoft.AspNetCore.Hosting.GenericWebHostService.StartAsync(CancellationToken cancellationToken)
api_1       | Unhandled exception. Npgsql.NpgsqlException (0x80004005): Exception while connecting
api_1       |  ---> System.TimeoutException: Timeout during connection attempt
api_1       |    at Npgsql.NpgsqlConnector.Connect(NpgsqlTimeout timeout)
api_1       |    at Npgsql.NpgsqlConnector.Connect(NpgsqlTimeout timeout)
api_1       |    at Npgsql.NpgsqlConnector.RawOpen(NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
api_1       |    at Npgsql.NpgsqlConnector.Open(NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
api_1       |    at Npgsql.NpgsqlConnection.<>c__DisplayClass32_0.<<Open>g__OpenLong|0>d.MoveNext()
api_1       | --- End of stack trace from previous location where exception was thrown ---
api_1       |    at Npgsql.NpgsqlConnection.Open()
api_1       |    at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlDatabaseCreator.Exists()
api_1       |    at Microsoft.EntityFrameworkCore.Migrations.HistoryRepository.Exists()
api_1       |    at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration)
api_1       |    at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.Migrate(DatabaseFacade databaseFacade)
api_1       |    at my.Claims.Engine.Api.Startup.Configure(IApplicationBuilder app, IWebHostEnvironment env, myDbContext ctx) in /src/my.Claims.Engine.Api/Startup.cs:line 56
api_1       |    at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor, Boolean wrapExceptions)
api_1       |    at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
api_1       |    at Microsoft.AspNetCore.Hosting.ConfigureBuilder.Invoke(Object instance, IApplicationBuilder builder)
api_1       |    at Microsoft.AspNetCore.Hosting.ConfigureBuilder.<>c__DisplayClass4_0.<Build>b__0(IApplicationBuilder builder)
api_1       |    at Microsoft.AspNetCore.Hosting.GenericWebHostBuilder.<>c__DisplayClass13_0.<UseStartup>b__2(IApplicationBuilder app)
api_1       |    at Microsoft.AspNetCore.Mvc.Filters.MiddlewareFilterBuilderStartupFilter.<>c__DisplayClass0_0.<Configure>g__MiddlewareFilterBuilder|0(IApplicationBuilder builder)
api_1       |    at Microsoft.AspNetCore.HostFilteringStartupFilter.<>c__DisplayClass0_0.<Configure>b__0(IApplicationBuilder app)
api_1       |    at Microsoft.AspNetCore.Hosting.GenericWebHostService.StartAsync(CancellationToken cancellationToken)
api_1       |    at Microsoft.Extensions.Hosting.Internal.Host.StartAsync(CancellationToken cancellationToken)
api_1       |    at Microsoft.Extensions.Hosting.HostingAbstractionsHostExtensions.RunAsync(IHost host, CancellationToken token)
api_1       |    at Microsoft.Extensions.Hosting.HostingAbstractionsHostExtensions.RunAsync(IHost host, CancellationToken token)
api_1       |    at Microsoft.Extensions.Hosting.HostingAbstractionsHostExtensions.Run(IHost host)
api_1       |    at my.Claims.Engine.Api.Program.Main(String[] args) in /src/my.Claims.Engine.Api/Program.cs:line 17
my-claims_api_1 exited with code 139

Here is my docker-compose:

services: 
    db:
        image: postgres
        restart: always
        ports:
            - '5432:5432'
        environment:
            POSTGRES_USER: root
            POSTGRES_PASSWORD: password
    eventbus:
        image: 'rabbitmq'
        ports:
            - '5672:5672'
            - '15672:15672'
    portal:
        image: ${DOCKER_REGISTRY-}portal
        build:
            context: ./portal
            dockerfile: Docker/Dockerfile
        ports: 
            - "3000:80"
    api:
        image: ${DOCKER_REGISTRY-}my_claims_engine_api
        build:
            context: ./my.Claims.Engine
            dockerfile: my.Claims.Engine.Api/Dockerfile
        ports: 
            - "4000:80"    

Here is my connection string:

"myDbContext": "Server=localhost;Port=5432;Database=mydatabase;User Id=root;Password=password;"

If I run the postgres as it’s own image, and connect via it’s local address I am able to connect, my migrations run, no problems whatsoever.

The only time I get the error is via the docker-compose.

Additionally, I am unable to connect to the rabbitmq instance via localhost:15672, any suggestions on that would be great too…

Any ideas where the problem is?

Go to docker

.net-core -> Postgres connection

api_1       |       Application startup exception
api_1       | Npgsql.NpgsqlException (0x80004005): Exception while connecting
api_1       |  ---> System.TimeoutException: Timeout during connection attempt
api_1       |    at Npgsql.NpgsqlConnector.Connect(NpgsqlTimeout timeout)
api_1       |    at Npgsql.NpgsqlConnector.Connect(NpgsqlTimeout timeout)
api_1       |    at Npgsql.NpgsqlConnector.RawOpen(NpgsqlTimeout timeout, Boolean async, CancellationToken     cancellationToken)
api_1       |    at Npgsql.NpgsqlConnector.Open(NpgsqlTimeout timeout, Boolean async, CancellationToken     cancellationToken)
api_1       |    at Npgsql.NpgsqlConnection.<>c__DisplayClass32_0.<<Open>g__OpenLong|0>d.MoveNext()
api_1       | --- End of stack trace from previous location where exception was thrown ---
api_1       |    at Npgsql.NpgsqlConnection.Open()
api_1       |    at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlDatabaseCreator.Exists()
api_1       |    at Microsoft.EntityFrameworkCore.Migrations.HistoryRepository.Exists()
api_1       |    at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration)
api_1       |    at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.Migrate(DatabaseFacade     databaseFacade)
api_1       |    at my.Claims.Engine.Api.Startup.Configure(IApplicationBuilder app, IWebHostEnvironment env, myDbContext ctx) in /src/my.Claims.Engine.Api/Startup.cs:line 56
api_1       |    at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor, Boolean wrapExceptions)
api_1       |    at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
api_1       |    at Microsoft.AspNetCore.Hosting.ConfigureBuilder.Invoke(Object instance, IApplicationBuilder builder)
api_1       |    at Microsoft.AspNetCore.Hosting.ConfigureBuilder.<>c__DisplayClass4_0.<Build>b__0(IApplicationBuilder builder)
api_1       |    at Microsoft.AspNetCore.Hosting.GenericWebHostBuilder.<>c__DisplayClass13_0.<UseStartup>b__2(IApplicationBuilder app)
api_1       |    at Microsoft.AspNetCore.Mvc.Filters.MiddlewareFilterBuilderStartupFilter.<>c__DisplayClass0_0.<Configure>g__MiddlewareFilterBuilder|0(IApplicationBuilder builder)
api_1       |    at Microsoft.AspNetCore.HostFilteringStartupFilter.<>c__DisplayClass0_0.<Configure>b__0(IApplicationBuilder app)
api_1       |    at Microsoft.AspNetCore.Hosting.GenericWebHostService.StartAsync(CancellationToken cancellationToken)
api_1       | Unhandled exception. Npgsql.NpgsqlException (0x80004005): Exception while connecting
api_1       |  ---> System.TimeoutException: Timeout during connection attempt
api_1       |    at Npgsql.NpgsqlConnector.Connect(NpgsqlTimeout timeout)
api_1       |    at Npgsql.NpgsqlConnector.Connect(NpgsqlTimeout timeout)
api_1       |    at Npgsql.NpgsqlConnector.RawOpen(NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
api_1       |    at Npgsql.NpgsqlConnector.Open(NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
api_1       |    at Npgsql.NpgsqlConnection.<>c__DisplayClass32_0.<<Open>g__OpenLong|0>d.MoveNext()
api_1       | --- End of stack trace from previous location where exception was thrown ---
api_1       |    at Npgsql.NpgsqlConnection.Open()
api_1       |    at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlDatabaseCreator.Exists()
api_1       |    at Microsoft.EntityFrameworkCore.Migrations.HistoryRepository.Exists()
api_1       |    at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration)
api_1       |    at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.Migrate(DatabaseFacade databaseFacade)
api_1       |    at my.Claims.Engine.Api.Startup.Configure(IApplicationBuilder app, IWebHostEnvironment env, myDbContext ctx) in /src/my.Claims.Engine.Api/Startup.cs:line 56
api_1       |    at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor, Boolean wrapExceptions)
api_1       |    at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
api_1       |    at Microsoft.AspNetCore.Hosting.ConfigureBuilder.Invoke(Object instance, IApplicationBuilder builder)
api_1       |    at Microsoft.AspNetCore.Hosting.ConfigureBuilder.<>c__DisplayClass4_0.<Build>b__0(IApplicationBuilder builder)
api_1       |    at Microsoft.AspNetCore.Hosting.GenericWebHostBuilder.<>c__DisplayClass13_0.<UseStartup>b__2(IApplicationBuilder app)
api_1       |    at Microsoft.AspNetCore.Mvc.Filters.MiddlewareFilterBuilderStartupFilter.<>c__DisplayClass0_0.<Configure>g__MiddlewareFilterBuilder|0(IApplicationBuilder builder)
api_1       |    at Microsoft.AspNetCore.HostFilteringStartupFilter.<>c__DisplayClass0_0.<Configure>b__0(IApplicationBuilder app)
api_1       |    at Microsoft.AspNetCore.Hosting.GenericWebHostService.StartAsync(CancellationToken cancellationToken)
api_1       |    at Microsoft.Extensions.Hosting.Internal.Host.StartAsync(CancellationToken cancellationToken)
api_1       |    at Microsoft.Extensions.Hosting.HostingAbstractionsHostExtensions.RunAsync(IHost host, CancellationToken token)
api_1       |    at Microsoft.Extensions.Hosting.HostingAbstractionsHostExtensions.RunAsync(IHost host, CancellationToken token)
api_1       |    at Microsoft.Extensions.Hosting.HostingAbstractionsHostExtensions.Run(IHost host)
api_1       |    at my.Claims.Engine.Api.Program.Main(String[] args) in /src/my.Claims.Engine.Api/Program.cs:line 17
my-claims_api_1 exited with code 139

version: '3.4'

services: 
db:
    image: postgres
    restart: always
    ports:
        - '5432:5432'
    environment:
        POSTGRES_USER: root
        POSTGRES_PASSWORD: password
        POSTGRES_DB: fnzclaims
eventbus:
    image: 'rabbitmq:3-management'
    ports:
        - '5672:5672'
        - '15672:15672'
portal:
    image: ${DOCKER_REGISTRY-}portal
    build:
        context: ./portal
        dockerfile: Docker/Dockerfile
    ports: 
        - "3000:80"

api:
    image: ${DOCKER_REGISTRY-}my_claims_engine_api
    build:
        context: ./my.Claims.Engine
        dockerfile: my.Claims.Engine.Api/Dockerfile
    ports: 
        - "4000:80"
    links:
        - db

"myDbContext": "Server=localhost;Port=5432;Database=mydatabase;User Id=root;Password=password;"

Java: SSLHandshake Exception while connecting to a service in Spring Boot With Solution

We’ll attempt to use programming in this lesson to solve the Java: SSLHandshake Exception while connecting to a service in Spring Boot With Solution puzzle. This is demonstrated in the code below.

try(CloseableHttpClient httpClient = HttpClients.custom().setSSLSocketFactory(yourLoadSSLFunction()).build()){
}

The solution to the previously mentioned problem, Java: SSLHandshake Exception while connecting to a service in Spring Boot With Solution, can also be found in a different method, which will be discussed further down with some illustrative code.

CloseableHttpClient httpClient = HttpClients.custom().setSSLSocketFactory(yourLoadSSLFunction()).build()
RestTemplate restTemplate = new RestTemplate();
HttpComponentsClientHttpRequestFactory requestFactory = new HttpComponentsClientHttpRequestFactory(httpClient);
restTemplate.setRequestFactory(requestFactory);

We learned how to solve the Java: SSLHandshake Exception while connecting to a service in Spring Boot With Solution by looking at a range of different cases.

How do I fix the SSL handshake exception in Java?

How to Fix SSL Handshake Failed

• Correct the time and date on the client device.
• Try another browser.
• Add website to allowlist.
• Update browser to use the latest SSL protocol.
• Check browser and server support for Cipher Suites.
• Verify your SSL certificate is accurate and valid.

How do I enable SSL in spring boot?

React + Spring Boot Microservices and Spring

• Obtain the SSL certificate – Create a self-signed certificate or get one from a Certificate Authority.
• Enable HTTPS and 443 port.

How do I resolve SSLHandshakeException?

This issue can happen because the JDK does not use the operating systems’s truststore, into which your IT would have added the self-signed certificate. The solution would be to import the proxy’s self-signed certificate into your JDK’s truststore (i.e. the cacerts file).17-Apr-2014

What causes SSLHandshakeException?

The SSLHandshakeException indicates that a self-signed certificate was returned by the client that is not trusted as it cannot be found in the truststore or keystore . This SSLException is seen on the client side of the connection. sun. security.

How do I enable TLS 1.2 in Java?

If your application runs on Java 1.7 or Java 1.6 (update 111 or later), you can set the https. protocols system property when starting the JVM to enable additional protocols for connections made using the HttpsURLConnection class – for example, by setting -Dhttps. protocols=TLSv1. 2 .27-Jun-2018

What is SSL handshake in Java?

The SSL protocol uses a combination of public-key and symmetric key encryption. Symmetric key encryption is much faster than public-key encryption, but public-key encryption provides better authentication techniques. An SSL session always begins with an exchange of messages called the SSL handshake.

How do I enable an SSL certificate?

How to activate your certificate:

• Go to the Websites & Domains tab of the Plesk admin control panel.
• In the section for the domain name you want to use, click Hosting Settings.
• In the Security section, select SSL support.
• Select the Certificate you created, and then click OK.

How do I enable SSL security?

To do this, follow these steps:

• Select the Directory Security tab. In the Secure Communication section, Edit is now available. Select Edit.
• Select Require Secure Channel (SSL). Note.

How do I enable SSL URL?

Enabling HTTPS on Your Servers

• TL;DR.
• Generating keys and certificate signing requests. Generate a public/private key pair. Generate a certificate signing request.
• Enable HTTPS on your servers.
• Make intrasite URLs relative.
• Redirect HTTP to HTTPS.
• Turn on Strict Transport Security and secure cookies. Search ranking. Performance.

What is Ssl_error_handshake_unexpected_alert?

Error code: SSL_ERROR_HANDSHAKE_UNEXPECTED_ALERT. The page you are trying to view cannot be shown because the authenticity of the received data could not be verified. Please contact the website owners to inform them of this problem.22-Jan-2022