pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
FATAL error in logs: no pb_hba.conf entry 2+ messages / 2 participants [nested] [flat]
* FATAL error in logs: no pb_hba.conf entry @ 2021-04-30 01:39 james terris <james_terris@yahoo.com> 2021-04-30 03:21 ` Re: FATAL error in logs: no pb_hba.conf entry Ron <ronljohnsonjr@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: james terris @ 2021-04-30 01:39 UTC (permalink / raw) To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org> 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 md5host 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. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: FATAL error in logs: no pb_hba.conf entry 2021-04-30 01:39 FATAL error in logs: no pb_hba.conf entry james terris <james_terris@yahoo.com> @ 2021-04-30 03:21 ` Ron <ronljohnsonjr@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Ron @ 2021-04-30 03:21 UTC (permalink / raw) To: pgsql-admin@lists.postgresql.org On 4/29/21 8:39 PM, james terris wrote: > 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 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. 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 md5 > host anotherDB anotherUser 127.0.0.1/32 md5 > host all postgres ::1/128 md5 > host anotherDB anotherUser ::1/128 md5 -- Angular momentum makes the world go 'round. ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2021-04-30 03:21 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2021-04-30 01:39 FATAL error in logs: no pb_hba.conf entry james terris <james_terris@yahoo.com> 2021-04-30 03:21 ` Ron <ronljohnsonjr@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox