Обсуждение: FATAL error in logs: no pb_hba.conf entry
Hello,
I have a postgres version 9.6 server running on and old Windows Server 2008 R2 server.
I noticed this message in the logs:
FATAL: no pg_hba.conf entry for host "::1", user "APPSERVER$", database "postgres", SSL off
It's true that I don't have a row for the the "APPSERVER$" user but I'm not really sure where that user is coming from. It's the server name and it's only trying to log in via IPv6 ?
If someone could give me some more details about why is causing that log line that would be great. I have other servers configured without that line in pg_hba.conf and they don't have that FATAL message.
My pg_hba.conf looks like this:
host all postgres 127.0.0.1/32 md5
host anotherDB anotherUser 127.0.0.1/32 md5
host all postgres ::1/128 md5
host anotherDB anotherUser ::1/128 md5
thank you,
james
BTW, I'm new to this mailing list, if I have the wrong one please update me.
On 4/29/21 8:39 PM, james terris wrote:
An EOL Windows Server... Don't feel too bad: I've got to manage SQL Server 2005 on Win 2008 R2; earlier this year, we just migrated SQL Server 2000 to 2016.
It means exactly what it says: some process is trying to log in as user APPSERVER$ from the IPv6 loopback device. This is a security concern. Look in the Windows Event logs for that user, ask the Windows sysadmins, and the end users who care about this.
Hello,I have a postgres version 9.6 server running on and old Windows Server 2008 R2 server.
An EOL Windows Server... Don't feel too bad: I've got to manage SQL Server 2005 on Win 2008 R2; earlier this year, we just migrated SQL Server 2000 to 2016.
I noticed this message in the logs:FATAL: no pg_hba.conf entry for host "::1", user "APPSERVER$", database "postgres", SSL offIt's true that I don't have a row for the the "APPSERVER$" user but I'm not really sure where that user is coming from. It's the server name and it's only trying to log in via IPv6 ?If someone could give me some more details about why is causing that log line that would be great. I have other servers configured without that line in pg_hba.conf and they don't have that FATAL message.
It means exactly what it says: some process is trying to log in as user APPSERVER$ from the IPv6 loopback device. This is a security concern. Look in the Windows Event logs for that user, ask the Windows sysadmins, and the end users who care about this.
My pg_hba.conf looks like this:host all postgres 127.0.0.1/32 md5host anotherDB anotherUser 127.0.0.1/32 md5host all postgres ::1/128 md5host anotherDB anotherUser ::1/128 md5
--
Angular momentum makes the world go 'round.
Angular momentum makes the world go 'round.