OS 10.1 27575 connecting to Postrgesql 13

[Bastiaan Olij]

Hey Graeme,

I agree with Doug about not using trust. That's just a security hole, 
but it's also not your problem.

Andy is on the right track, you're connecting over IPv6 but your pg_hba 
file is not setup for it.

 > host    all             all             127.0.0.1/32 trust
Gives access to local host over IPv4

 > host    all                all                192.168.0.0/24         
trust
Gives access to 192.168.0.n over IPv4

 > host    all             all             ::1/128 trust
Gives access to local host over IPv6

But there are no other relevant entries so fe80::c37:89b4:cc6d:2bb2 is 
blocked.

You can add:

host all all fe80::c37:89b4:cc6d:2bb2/128 md5
And that should give access to just that computer to log on over IPv6.

I haven't had to setup many IPv6 entries so I'm a bit rusty on valid 
subnets so you'll have to read up on that and how you alter the mask to 
give access to any computer on your network.

Cheers,

Bas


On 24/10/2021 8:42 am, Graeme Harris wrote:
> Thanks Andy for the quick reply.
>
> I checked pg_hba.conf it was set to it's default. I compared to the 
> one that is working in the Postgres 11 which is working fine and 
> changed it to match but no joy still get same response.
>
> As  a reference here is the configuration of my pg_hba.conf file.
>
> # TYPE  DATABASE        USER ADDRESS                 METHOD
>
> # "local" is for Unix domain socket connections only
> local   all             all trust
> # IPv4 local connections:
> host    all             all             127.0.0.1/32 trust
> host    all                all                192.168.0.0/24     trust
> host    all                all                samenet trust
> # IPv6 local connections:
> host    all             all             ::1/128 trust
> # Allow replication connections from localhost, by a user with the
> # replication privilege.
> #local   replication     all trust
> #host    replication     all             127.0.0.1/32 trust
> #host    replication     all             ::1/128 trust
>
> Graeme
>
> On 10/23/21 9:10 am, Andy Hilton wrote:
>> Graeme
>>
>> The error message indicates Postgres is trying to be called on an IP6 
>> address…..
>>
>> Most likely all the other connections you mentioned are IP4
>>
>> Are you sure that the pg_hba.conf file is set to allow IP6 connections ?
>>
>> What are the parameters you are giving to the DAM to connect under ??
>>
>> 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
>>
>>> On Oct 23, 2021, at 3:03 PM, Graeme Harris 
>>> <gfhwalkabout at fastmail.fm> wrote:
>>>
>>> Looking for some help connecting to Postgresql 13 on a local server 
>>> with Omnis Studio 10.1 27575.
>>>
>>> I have created Postgres 13 on my server and add several databases 
>>> that I have copied over from a functioning postgres 11 server which 
>>> is functioning fine, was hoping to upgrade my server. I am accessing 
>>> all servers from my laptop over WiFi using an SSL tunnel and I am 
>>> able to connect servers with pgadmin, DBeaver, Valentina Studio.
>>>
>>> Omnis Studio 10.1 connects to the Postgres 11 server and has for the 
>>> last few years but gets an error when connecting to the Postgres 13 
>>> server. "LOGON FAILED - The SQL Browser was unable to log on : could 
>>> not connect to server: Connection refused  Is the server running on 
>>> host "gfhserver.local" (fe80::c37:89b4:cc6d:2bb2) and accepting 
>>> TCP?IP connections on port 5432? could not connect to server: 
>>> Connection ref ". I thinking the problem may be in the Postgres DAM.
>>>
>>> Any help will be appreciated,
>>>
>>> Graeme
>>>
>>> _____________________________________________________________
>>> Manage your list subscriptions at http://lists.omnis-dev.com
>>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
>
>
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 

-- 
Kindest Regards,

Bastiaan Olij
bastiaan at muxworks.com.au
+61-432144833