Re: Connection issue - Mailing list pgsql-general
From | Adrian Klaver |
---|---|
Subject | Re: Connection issue |
Date | |
Msg-id | cd4f9451-c195-2498-c20f-167217b261e1@aklaver.com Whole thread Raw |
In response to | Re: Connection issue (Maximilian Tyrtania <maximilian.tyrtania@gmail.com>) |
Responses |
RE: Connection issue
(Ricardo Martin Gomez <rimartingomez@hotmail.com>)
|
List | pgsql-general |
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 Parallelson 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 connectwith 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.dePort=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: Connectionreset 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 believethat 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: unknownprotocol. 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
pgsql-general by date: