# Percona postgres unable to connect from mqtt pod

**URL:** <https://forums.percona.com/t/percona-postgres-unable-to-connect-from-mqtt-pod/23576>\
**Category:** Percona Distribution for PostgreSQL\
**Tags:** percona, postgres, closed-no-reply\
**Created:** [July 12, 2023, 5:43pm UTC](https://forums.percona.com/t/percona-postgres-unable-to-connect-from-mqtt-pod/23576 "2023-07-12T17:43:56Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![suneetha\_mandala](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/suneetha_mandala/32/11358_2.png) [@suneetha\_mandala](https://forums.percona.com/u/suneetha_mandala)\
**Post date:** [July 12, 2023, 5:43pm UTC](https://forums.percona.com/t/percona-postgres-unable-to-connect-from-mqtt-pod/23576/1 "2023-07-12T17:43:56Z")

</div>

I have other pods which is using same authentication as mqtt pod but those pods are able to connect to postgresdb but this mqtt pod getting below error

i tried to change pg\_hba.conf for allowing all host but that i have configured in patroni section which is also not applied

How can i get the default user(postgres user) credentails

[2023-07-12 17:13:05.694 INF] File API URL: [https://my-registry-test.ip.nip.io/file-api/filvol/](https://my-registry-test.ip.nip.io/file-api/filvol/)  
[2023-07-12 17:13:06.786 ERR] 28000: \*\*\*\*no pg\_hba.conf entry for host “10.42.0.44”, user “abcduser”, database “abcddb” **, no encryption** at Npgsql.NpgsqlConnector.\<\>c\_\_DisplayClass160\_0.\<g\_\_ReadMessageLong|0\>d.MoveNext()  
— End of stack trace from previous location —  
at Npgsql.NpgsqlConnector.\<\>c\_\_DisplayClass160\_0.\<g\_\_ReadMessageLong|0\>d.MoveNext()  
— End of stack trace from previous location —  
at Npgsql.NpgsqlConnector.Authenticate(String username, NpgsqlTimeout timeout, Boolean async)  
at Npgsql.NpgsqlConnector.Open(NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)  
at Npgsql.ConnectorPool.AllocateLong(NpgsqlConnection conn, NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)  
at Npgsql.NpgsqlConnection.\<\>c\_\_DisplayClass32\_0.\<g\_\_OpenLong|0\>d.MoveNext()  
— End of stack trace from previous location —  
at Npgsql.NpgsqlConnection.Open()  
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenDbConnection(Boolean errorsExpected)  
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected)  
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)  
at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.MoveNext()  
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)  
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)  
at Slb.abc.Dal.Utils.DeviceTagScaleUtility.LoadDeviceTagScale(ApplicationContext dbContext) in /src/Slb.abc.Dal/Utils/DeviceTagScaleUtility.cs:line 17  
at Slb.abc.Dal.DalWorker.Initialize() in /src/Slb.abc.Dal/DalWorker.cs:line 34  
at Slb.abc.Mqtt.Connector.MqttConnector.Start() in /src/Slb.abc.Mqtt.Connector/MqttConnector.cs:line 46