OS 10.1 27575 connecting to Postrgesql 13

[Graeme Harris]

Thank you Andy and Doug,

I tried both your suggestion with no success. Andy switch hostname to IP address just changed the wording on the error message to the IP Address.

Doug I changed the trust to scram-sha-256 in pg-hba.conf but still getting error message from omnis, pgadmin etc. are able to connect. I tried changing scram-sha-256 turn it on or off in postrges.conf but didn't seem to make a difference. Maybe other setting need adjusting in postgres.conf I'm not sure.

Graeme


On 10/23/21 6:00 pm, Doug Easterbrook wrote:

you might want to change the line

host    all                all                192.168.0.0/24         trust

to

host    all                all                192.168.0.0/24         scram-sha-256

or, at the very least

host    all                all                192.168.0.0/24         MD5


that way postgres will at least use some sort of authentication when logging people in who are on workstations other that the localhost.


if you use ’trust’ everywhere, then there is no login authentication at all.


Doug Easterbrook
Arts Management Systems Ltd.
mailto:doug at artsman.com
http://www.artsman.com
Phone (403) 650-1978


On 10/23/21 6:11 pm, Andy Hilton wrote:
> Graeme
>
> So part 2 to check here is what data you are passing to the DAM to open your connection ? Are you passing a hostname or an IP address as the ‘hostname’ - if using a name as the hostname, try using the IP address (which would kind of force IP4 !)
>
>
> Andy Hilton
> Totally Brilliant Software Inc
> Phone (US) : (863) 409 4870
> Phone (UK) : 0207 193 8582
> Web : www.totallybrilliant.com <http://www.totallybrilliant.com/>
> Helpdesk : http://totallybrilliant.kayako.com
> Email : andyh at totallybrilliant.com
>