From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Maximilian Tyrtania <maximilian.tyrtania@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Connection issue
Date: Tue, 5 Feb 2019 07:44:27 -0800
Message-ID: <cd4f9451-c195-2498-c20f-167217b261e1@aklaver.com> (raw)
In-Reply-To: <FCD3C193-D9E9-4B94-BBC0-A919AE8775DF@gmail.com>
References: <4558AEAB-975E-495D-9001-409CD5A9E84E@gmail.com>
<715197e9-84a1-d975-c29b-a3f054478c02@aklaver.com>
<FCD3C193-D9E9-4B94-BBC0-A919AE8775DF@gmail.com>
On 2/5/19 7:18 AM, Maximilian Tyrtania wrote:
> Hi,
>
>> On 5. Feb 2019, at 15:57, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>>
>> On 2/5/19 1:48 AM, Maximilian Tyrtania wrote:
>>> For some reason I can't connect to my PG 10.6.1 Server (running on Ubuntu) from my Windows installation (run via Parallels on my Mac), no matter what app I use (tried psql, PGAdmin and my own app).
>>
>> Has it ever connected?
>
> Yes, it connected without issues last week.
>
>> Have you recently updated any of the involved software?
>
> Well, sure, but after I saw I couldn't connect I downloaded the current version of PGAdmin and psql and couldn't connect with them either.
>
>> More below.
>>
>>> When trying to connect from PGAdmin 4 the server logs say:
>>> 2019-02-05 10:34:30.558 CET [31051] [unbekannt]@[unbekannt] LOG: 00000: Verbindung empfangen: Host=ip5b4054ce.dynamic.kabel-deutschland.de Port=50262
>>> 2019-02-05 10:34:30.558 CET [31051] [unbekannt]@[unbekannt] ORT: BackendInitialize, postmaster.c:4249
>>> 2019-02-05 10:34:30.648 CET [31051] [unbekannt]@[unbekannt] LOG: 08006: konnte Daten vom Client nicht empfangen: Connection reset by peer
>>> 2019-02-05 10:34:30.648 CET [31051] [unbekannt]@[unbekannt] ORT: pq_recvbuf, pqcomm.c:978
>>> ("konnte Daten vom Client nicht empfangen" means "couldn't receive data from client")
>>> PGAdmin says the usual " Unable to connect to server:..."
>>> No issue connecting from the Mac.
>>> I see in the logfile that other windows users did connect successfully from their windows boxes so I am ready to believe that maybe my Parallels somehow disconnects the connection quickly or something.
>>> Another strange thing is that if I try to connect from my Xojo app (which uses libpq internally) it says:SSL error: unknown protocol. I had no issue connecting last week from that installation so I am at my wits end...
>>
>> Where is the Xojo app running?
>>
>> Is the pg_hba.conf on the server set up to allow connections from the client machines?
>
> Yes. Also the errormessage wouldn't be "Connection reset by peer" if it was a pga_hba.conf issue, would it? And anyway, I can connect just fine from my Mac with the same credentials. I wonder if this is maybe some Parallels issue.
Well if you could connect from Parallels last week, you upgraded it and
now you cannot connect then I would suspect it. This assumes that the
Xojo app is also running in the Parallels instance. Given the SSL error
you might see if they changed anything in that area.
>
> Thanks,
> Max
>
--
Adrian Klaver
adrian.klaver@aklaver.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: adrian.klaver@aklaver.com, maximilian.tyrtania@gmail.com, pgsql-general@lists.postgresql.org
Subject: Re: Connection issue
In-Reply-To: <cd4f9451-c195-2498-c20f-167217b261e1@aklaver.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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