pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedConnection issue
18+ messages / 4 participants
[nested] [flat]
* Connection issue
@ 2019-02-05 09:48 Maximilian Tyrtania <maximilian.tyrtania@gmail.com>
0 siblings, 1 reply; 18+ messages in thread
From: Maximilian Tyrtania @ 2019-02-05 09:48 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
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).
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...
Tia,
Max
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Connection issue
@ 2019-02-05 14:57 Adrian Klaver <adrian.klaver@aklaver.com>
parent: Maximilian Tyrtania <maximilian.tyrtania@gmail.com>
0 siblings, 2 replies; 18+ messages in thread
From: Adrian Klaver @ 2019-02-05 14:57 UTC (permalink / raw)
To: Maximilian Tyrtania <maximilian.tyrtania@gmail.com>; pgsql-general@lists.postgresql.org
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?
Have you recently updated any of the involved software?
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?
>
> Tia,
>
> Max
>
--
Adrian Klaver
adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Connection issue
@ 2019-02-05 15:18 Maximilian Tyrtania <maximilian.tyrtania@gmail.com>
parent: Adrian Klaver <adrian.klaver@aklaver.com>
1 sibling, 1 reply; 18+ messages in thread
From: Maximilian Tyrtania @ 2019-02-05 15:18 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@aklaver.com>; +Cc: pgsql-general@lists.postgresql.org
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.
Thanks,
Max
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Connection issue
@ 2019-02-05 15:44 Adrian Klaver <adrian.klaver@aklaver.com>
parent: Maximilian Tyrtania <maximilian.tyrtania@gmail.com>
0 siblings, 1 reply; 18+ messages in thread
From: Adrian Klaver @ 2019-02-05 15:44 UTC (permalink / raw)
To: Maximilian Tyrtania <maximilian.tyrtania@gmail.com>; +Cc: pgsql-general@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 18+ messages in thread
* RE: Connection issue
@ 2019-02-05 23:19 Ricardo Martin Gomez <rimartingomez@hotmail.com>
parent: Adrian Klaver <adrian.klaver@aklaver.com>
0 siblings, 0 replies; 18+ messages in thread
From: Ricardo Martin Gomez @ 2019-02-05 23:19 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@aklaver.com>; Maximilian Tyrtania <maximilian.tyrtania@gmail.com>; +Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Hi, Can you do some tests in both (Mac and Windows ) ?
* telnet {IP_Server} {5432}
* ping {IP_Server}
* tracert {IP_Server}
Regards
______________________
Saludos
Ing. Ricardo Martín Gomez
DBA - SysAdmin
________________________________
De: Adrian Klaver <adrian.klaver@aklaver.com>
Enviado: martes, 5 de febrero de 2019 12:44
Para: Maximilian Tyrtania
Cc: pgsql-general@lists.postgresql.org
Asunto: Re: Connection issue
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
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Connection issue
@ 2019-02-06 15:18 Maximilian Tyrtania <maximilian.tyrtania@gmail.com>
parent: Adrian Klaver <adrian.klaver@aklaver.com>
1 sibling, 1 reply; 18+ messages in thread
From: Maximilian Tyrtania @ 2019-02-06 15:18 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@aklaver.com>; Ricardo Martin Gomez <rimartingomez@hotmail.com>; +Cc: pgsql-general@lists.postgresql.org
Well, the problem being a Parallels issue is just a wild theory of mine, it could well be something else. Honstly I don't recall updating anything in that area. As Mr. Gomez suggested I tried to
ping - worked
telnet - did not work (infact I couldn't telnet anywhere)
tracert - worked
from my windows 10 box (didn't bother to check on my Mac as I have noc issues there). Still curious as to why the server would say "Connection reset by peer".
Thanks, Max
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Connection issue
@ 2019-02-06 16:19 Adrian Klaver <adrian.klaver@aklaver.com>
parent: Maximilian Tyrtania <maximilian.tyrtania@gmail.com>
0 siblings, 2 replies; 18+ messages in thread
From: Adrian Klaver @ 2019-02-06 16:19 UTC (permalink / raw)
To: Maximilian Tyrtania <maximilian.tyrtania@gmail.com>; Ricardo Martin Gomez <rimartingomez@hotmail.com>; +Cc: pgsql-general@lists.postgresql.org
On 2/6/19 7:18 AM, Maximilian Tyrtania wrote:
> Well, the problem being a Parallels issue is just a wild theory of mine, it could well be something else. Honstly I don't recall updating anything in that area. As Mr. Gomez suggested I tried to
So from a previous post:
> Have you recently updated any of the involved software?
Well, sure, but after I saw I couldn't connect ...
So what happened in the interval between the time you could connect and
the time you could not?
>
> ping - worked
> telnet - did not work (infact I couldn't telnet anywhere)
In my experience telnet is generally disabled these days.
> tracert - worked
>
> from my windows 10 box (didn't bother to check on my Mac as I have noc issues there). Still curious as to why the server would say "Connection reset by peer".
Well if you are running Windows --> Parallels --> OS X(Mac) --> Serve,
you are effectively testing the Mac also.
As to 'Connection reset by peer':
A grep of the Postgres source find this:
interfaces/libpq/win32.c
* Contains table and functions for looking up win32 socket error
* descriptions. But will/may contain other win32 helper functions
* for libpq.
WSAECONNRESET, "Connection reset by peer"
Looking up WSAECONNRESET finds this:
https://docs.microsoft.com/en-us/windows/desktop/WinSock/windows-sockets-error-codes-2
WSAECONNRESET
10054
Connection reset by peer.
An existing connection was forcibly closed by the remote host. This
normally results if the peer application on the remote host is suddenly
stopped, the host is rebooted, the host or remote network interface is
disabled, or the remote host uses a hard close (see setsockopt for more
information on the SO_LINGER option on the remote socket). This error
may also result if a connection was broken due to keep-alive activity
detecting a failure while one or more operations are in progress.
Operations that were in progress fail with WSAENETRESET. Subsequent
operations fail with WSAECONNRESET.
>
> Thanks, Max
>
--
Adrian Klaver
adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Connection issue
@ 2019-02-06 16:30 Maximilian Tyrtania <maximilian.tyrtania@gmail.com>
parent: Adrian Klaver <adrian.klaver@aklaver.com>
1 sibling, 1 reply; 18+ messages in thread
From: Maximilian Tyrtania @ 2019-02-06 16:30 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@aklaver.com>; +Cc: Ricardo Martin Gomez <rimartingomez@hotmail.com>; pgsql-general@lists.postgresql.org
Hi again,
> On 6. Feb 2019, at 17:19, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>
> On 2/6/19 7:18 AM, Maximilian Tyrtania wrote:
>> Well, the problem being a Parallels issue is just a wild theory of mine, it could well be something else. Honstly I don't recall updating anything in that area. As Mr. Gomez suggested I tried to
>
> So from a previous post:
>
> > Have you recently updated any of the involved software?
>
> Well, sure, but after I saw I couldn't connect ...
>
> So what happened in the interval between the time you could connect and the time you could not?
I did update parts of my app (including the plugin which in turn encapsulates libpq). I did not update my parallels installation, as far as I remember. Sorry if I was unclear about that.
>> ping - worked
>> telnet - did not work (infact I couldn't telnet anywhere)
>
> In my experience telnet is generally disabled these days.
I had to enable it on my Windows box, if that's what you mean. The "telnet" command works by itself, but I didnt receive anything when trying to telnet to some other machine.
>> tracert - worked
>> from my windows 10 box (didn't bother to check on my Mac as I have noc issues there). Still curious as to why the server would say "Connection reset by peer".
>
> Well if you are running Windows --> Parallels --> OS X(Mac) --> Serve, you are effectively testing the Mac also.
>
> As to 'Connection reset by peer':
>
> A grep of the Postgres source find this:
>
> interfaces/libpq/win32.c
>
> * Contains table and functions for looking up win32 socket error
> * descriptions. But will/may contain other win32 helper functions
> * for libpq.
>
>
> WSAECONNRESET, "Connection reset by peer"
>
> Looking up WSAECONNRESET finds this:
>
> https://docs.microsoft.com/en-us/windows/desktop/WinSock/windows-sockets-error-codes-2
>
>
> WSAECONNRESET
> 10054
>
> Connection reset by peer.
> An existing connection was forcibly closed by the remote host. This normally results if the peer application on the remote host is suddenly stopped, the host is rebooted, the host or remote network interface is disabled, or the remote host uses a hard close (see setsockopt for more information on the SO_LINGER option on the remote socket). This error may also result if a connection was broken due to keep-alive activity detecting a failure while one or more operations are in progress. Operations that were in progress fail with WSAENETRESET. Subsequent operations fail with WSAECONNRESET.
Ah, thanks for digging that up. Hmm, sounds as if something is definetly wrong on my windows box.
I'll try contacting the Parallels support guys.
Thanks again,
Max
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Connection issue
@ 2019-02-06 16:43 Adrian Klaver <adrian.klaver@aklaver.com>
parent: Maximilian Tyrtania <maximilian.tyrtania@gmail.com>
0 siblings, 1 reply; 18+ messages in thread
From: Adrian Klaver @ 2019-02-06 16:43 UTC (permalink / raw)
To: Maximilian Tyrtania <maximilian.tyrtania@gmail.com>; +Cc: Ricardo Martin Gomez <rimartingomez@hotmail.com>; pgsql-general@lists.postgresql.org
On 2/6/19 8:30 AM, Maximilian Tyrtania wrote:
> Hi again,
>
>
>> On 6. Feb 2019, at 17:19, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>>
>> On 2/6/19 7:18 AM, Maximilian Tyrtania wrote:
>>> Well, the problem being a Parallels issue is just a wild theory of mine, it could well be something else. Honstly I don't recall updating anything in that area. As Mr. Gomez suggested I tried to
>>
>> So from a previous post:
>>
>>> Have you recently updated any of the involved software?
>>
>> Well, sure, but after I saw I couldn't connect ...
>>
>> So what happened in the interval between the time you could connect and the time you could not?
>
> I did update parts of my app (including the plugin which in turn encapsulates libpq). I did not update my parallels installation, as far as I remember. Sorry if I was unclear about that.
What is the plugin?
Can you roll back the plugin upgrade to see if that is the problem?
>
>>> ping - worked
>>> telnet - did not work (infact I couldn't telnet anywhere)
>>
>> In my experience telnet is generally disabled these days.
>
> I had to enable it on my Windows box, if that's what you mean. The "telnet" command works by itself, but I didnt receive anything when trying to telnet to some other machine.
>
Probably because Telnet is not enabled on the server as it is not a
secure protocol:
https://en.wikipedia.org/wiki/Telnet
>
> Ah, thanks for digging that up. Hmm, sounds as if something is definetly wrong on my windows box.
>
> I'll try contacting the Parallels support guys.
>
> Thanks again,
>
> Max
>
--
Adrian Klaver
adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Connection issue
@ 2019-02-07 02:12 Ricardo Martin Gomez <rimartingomez@hotmail.com>
parent: Adrian Klaver <adrian.klaver@aklaver.com>
0 siblings, 0 replies; 18+ messages in thread
From: Ricardo Martin Gomez @ 2019-02-07 02:12 UTC (permalink / raw)
To: Maximilian Tyrtania <maximilian.tyrtania@gmail.com>; Adrian Klaver <adrian.klaver@aklaver.com>; +Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Hi,
Can you read the event viewer?
Obtener Outlook para Android<https://aka.ms/ghei36;
________________________________
From: Adrian Klaver <adrian.klaver@aklaver.com>
Sent: Wednesday, February 6, 2019 1:43:24 PM
To: Maximilian Tyrtania
Cc: Ricardo Martin Gomez; pgsql-general@lists.postgresql.org
Subject: Re: Connection issue
On 2/6/19 8:30 AM, Maximilian Tyrtania wrote:
> Hi again,
>
>
>> On 6. Feb 2019, at 17:19, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>>
>> On 2/6/19 7:18 AM, Maximilian Tyrtania wrote:
>>> Well, the problem being a Parallels issue is just a wild theory of mine, it could well be something else. Honstly I don't recall updating anything in that area. As Mr. Gomez suggested I tried to
>>
>> So from a previous post:
>>
>>> Have you recently updated any of the involved software?
>>
>> Well, sure, but after I saw I couldn't connect ...
>>
>> So what happened in the interval between the time you could connect and the time you could not?
>
> I did update parts of my app (including the plugin which in turn encapsulates libpq). I did not update my parallels installation, as far as I remember. Sorry if I was unclear about that.
What is the plugin?
Can you roll back the plugin upgrade to see if that is the problem?
>
>>> ping - worked
>>> telnet - did not work (infact I couldn't telnet anywhere)
>>
>> In my experience telnet is generally disabled these days.
>
> I had to enable it on my Windows box, if that's what you mean. The "telnet" command works by itself, but I didnt receive anything when trying to telnet to some other machine.
>
Probably because Telnet is not enabled on the server as it is not a
secure protocol:
https://en.wikipedia.org/wiki/Telnet
>
> Ah, thanks for digging that up. Hmm, sounds as if something is definetly wrong on my windows box.
>
> I'll try contacting the Parallels support guys.
>
> Thanks again,
>
> Max
>
--
Adrian Klaver
adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Connection issue
@ 2019-02-07 10:25 Maximilian Tyrtania <maximilian.tyrtania@gmail.com>
parent: Adrian Klaver <adrian.klaver@aklaver.com>
1 sibling, 0 replies; 18+ messages in thread
From: Maximilian Tyrtania @ 2019-02-07 10:25 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@aklaver.com>; +Cc: Ricardo Martin Gomez <rimartingomez@hotmail.com>; pgsql-general@lists.postgresql.org
Just for the record, updating to Mac OS 10.14.3 resolved the issue.
Thanks, Max
^ permalink raw reply [nested|flat] 18+ messages in thread
* Connection Issue
@ 2024-08-02 14:56 Andy Hartman <hartman60home@gmail.com>
0 siblings, 1 reply; 18+ messages in thread
From: Andy Hartman @ 2024-08-02 14:56 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
I'm using a Powershell script to connect to a remote 16.3(windows) version
of the DB.
Add-type -path 'C:\Program Files
(x86)\PostgreSQL\Npgsql\bin\net451\Npgsql.dll'
# Define connection strings for MS SQL and PostgreSQL
$pgsqlConnectionString =
"Host=xxxxxx;Port=5432;Username=xxx;Password=xx;Database=xxx;"
# Create connection to PostgreSQL
$pgsqlConn = New-Object Npgsql.NpgsqlConnection
$pgsqlConn.ConnectionString = $pgsqlConnectionString
$pgsqlConn.Open()
When this statement hits I get an error:
Exception calling "Open" with "0" argument(s): "Authentication method not
supported (Received: 10)"
Any ideas?
Thanks.
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Connection Issue
@ 2024-08-02 15:05 Adrian Klaver <adrian.klaver@aklaver.com>
parent: Andy Hartman <hartman60home@gmail.com>
0 siblings, 1 reply; 18+ messages in thread
From: Adrian Klaver @ 2024-08-02 15:05 UTC (permalink / raw)
To: Andy Hartman <hartman60home@gmail.com>; pgsql-general@lists.postgresql.org
On 8/2/24 07:56, Andy Hartman wrote:
> I'm using a Powershell script to connect to a remote 16.3(windows)
> version of the DB.
>
> Add-type -path 'C:\Program Files
> (x86)\PostgreSQL\Npgsql\bin\net451\Npgsql.dll'
>
> # Define connection strings for MS SQL and PostgreSQL
> $pgsqlConnectionString =
> "Host=xxxxxx;Port=5432;Username=xxx;Password=xx;Database=xxx;"
>
> # Create connection to PostgreSQL
> $pgsqlConn = New-Object Npgsql.NpgsqlConnection
> $pgsqlConn.ConnectionString = $pgsqlConnectionString
> $pgsqlConn.Open()
>
>
> When this statement hits I get an error:
>
> Exception calling "Open" with "0" argument(s): "Authentication method
> not supported (Received: 10)"
Best bet old library that does not understand scram-sha-256 authentication.
>
> Any ideas?
>
> Thanks.
--
Adrian Klaver
adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Connection Issue
@ 2024-08-02 16:18 Adrian Klaver <adrian.klaver@aklaver.com>
parent: Adrian Klaver <adrian.klaver@aklaver.com>
0 siblings, 1 reply; 18+ messages in thread
From: Adrian Klaver @ 2024-08-02 16:18 UTC (permalink / raw)
To: Andy Hartman <hartman60home@gmail.com>; +Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
On 8/2/24 9:00 AM, Andy Hartman wrote:
Reply to list also.
Ccing list.
> I changed to md5 and I can connect via HeideSQL interface no problem
Changed what to md5?
The issue is with Npgsql(?) though.
What is the Npgsql version?
>
> On Fri, Aug 2, 2024 at 11:05 AM Adrian Klaver <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>> wrote:
>
> On 8/2/24 07:56, Andy Hartman wrote:
> > I'm using a Powershell script to connect to a remote 16.3(windows)
> > version of the DB.
> >
> > Add-type -path 'C:\Program Files
> > (x86)\PostgreSQL\Npgsql\bin\net451\Npgsql.dll'
> >
> > # Define connection strings for MS SQL and PostgreSQL
> > $pgsqlConnectionString =
> > "Host=xxxxxx;Port=5432;Username=xxx;Password=xx;Database=xxx;"
> >
> > # Create connection to PostgreSQL
> > $pgsqlConn = New-Object Npgsql.NpgsqlConnection
> > $pgsqlConn.ConnectionString = $pgsqlConnectionString
> > $pgsqlConn.Open()
> >
> >
> > When this statement hits I get an error:
> >
> > Exception calling "Open" with "0" argument(s): "Authentication
> method
> > not supported (Received: 10)"
>
> Best bet old library that does not understand scram-sha-256
> authentication.
>
>
> >
> > Any ideas?
> >
> > Thanks.
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Connection Issue
@ 2024-08-02 16:32 Andy Hartman <hartman60home@gmail.com>
parent: Adrian Klaver <adrian.klaver@aklaver.com>
0 siblings, 1 reply; 18+ messages in thread
From: Andy Hartman @ 2024-08-02 16:32 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@aklaver.com>; +Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
How can I tell that?
Thanks.
On Fri, Aug 2, 2024 at 12:18 PM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:
>
>
> On 8/2/24 9:00 AM, Andy Hartman wrote:
> Reply to list also.
> Ccing list.
> > I changed to md5 and I can connect via HeideSQL interface no problem
>
> Changed what to md5?
>
> The issue is with Npgsql(?) though.
>
> What is the Npgsql version?
>
> >
> > On Fri, Aug 2, 2024 at 11:05 AM Adrian Klaver <adrian.klaver@aklaver.com
> > <mailto:adrian.klaver@aklaver.com>> wrote:
> >
> > On 8/2/24 07:56, Andy Hartman wrote:
> > > I'm using a Powershell script to connect to a remote 16.3(windows)
> > > version of the DB.
> > >
> > > Add-type -path 'C:\Program Files
> > > (x86)\PostgreSQL\Npgsql\bin\net451\Npgsql.dll'
> > >
> > > # Define connection strings for MS SQL and PostgreSQL
> > > $pgsqlConnectionString =
> > > "Host=xxxxxx;Port=5432;Username=xxx;Password=xx;Database=xxx;"
> > >
> > > # Create connection to PostgreSQL
> > > $pgsqlConn = New-Object Npgsql.NpgsqlConnection
> > > $pgsqlConn.ConnectionString = $pgsqlConnectionString
> > > $pgsqlConn.Open()
> > >
> > >
> > > When this statement hits I get an error:
> > >
> > > Exception calling "Open" with "0" argument(s): "Authentication
> > method
> > > not supported (Received: 10)"
> >
> > Best bet old library that does not understand scram-sha-256
> > authentication.
> >
> >
> > >
> > > Any ideas?
> > >
> > > Thanks.
> >
> > --
> > Adrian Klaver
> > adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> >
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Connection Issue
@ 2024-08-02 16:44 Adrian Klaver <adrian.klaver@aklaver.com>
parent: Andy Hartman <hartman60home@gmail.com>
0 siblings, 1 reply; 18+ messages in thread
From: Adrian Klaver @ 2024-08-02 16:44 UTC (permalink / raw)
To: Andy Hartman <hartman60home@gmail.com>; +Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
On 8/2/24 9:32 AM, Andy Hartman wrote:
> How can I tell that?
I don't use NET or npgsql so I getting out of my depth here.
The first thing I would do is look at the package/installer you used to
load npgsql for version info.
Second look at Installed Software and see if the version is reported there.
>
> Thanks.
>
> On Fri, Aug 2, 2024 at 12:18 PM Adrian Klaver <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>> wrote:
>
>
>
> On 8/2/24 9:00 AM, Andy Hartman wrote:
> Reply to list also.
> Ccing list.
> > I changed to md5 and I can connect via HeideSQL interface no problem
>
> Changed what to md5?
>
> The issue is with Npgsql(?) though.
>
> What is the Npgsql version?
>
> >
> > On Fri, Aug 2, 2024 at 11:05 AM Adrian Klaver
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> > <mailto:adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>>> wrote:
> >
> > On 8/2/24 07:56, Andy Hartman wrote:
> > > I'm using a Powershell script to connect to a remote
> 16.3(windows)
> > > version of the DB.
> > >
> > > Add-type -path 'C:\Program Files
> > > (x86)\PostgreSQL\Npgsql\bin\net451\Npgsql.dll'
> > >
> > > # Define connection strings for MS SQL and PostgreSQL
> > > $pgsqlConnectionString =
> > > "Host=xxxxxx;Port=5432;Username=xxx;Password=xx;Database=xxx;"
> > >
> > > # Create connection to PostgreSQL
> > > $pgsqlConn = New-Object Npgsql.NpgsqlConnection
> > > $pgsqlConn.ConnectionString = $pgsqlConnectionString
> > > $pgsqlConn.Open()
> > >
> > >
> > > When this statement hits I get an error:
> > >
> > > Exception calling "Open" with "0" argument(s): "Authentication
> > method
> > > not supported (Received: 10)"
> >
> > Best bet old library that does not understand scram-sha-256
> > authentication.
> >
> >
> > >
> > > Any ideas?
> > >
> > > Thanks.
> >
> > --
> > Adrian Klaver
> > adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> <mailto:adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>>
> >
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Connection Issue
@ 2024-08-02 16:52 Adrian Klaver <adrian.klaver@aklaver.com>
parent: Adrian Klaver <adrian.klaver@aklaver.com>
0 siblings, 1 reply; 18+ messages in thread
From: Adrian Klaver @ 2024-08-02 16:52 UTC (permalink / raw)
To: Andy Hartman <hartman60home@gmail.com>; +Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
On 8/2/24 9:47 AM, Andy Hartman wrote:
Please don't top post. Use inline or bottom posting.
> Looks like 4.5
From here:
https://www.npgsql.org/doc/performance.html
Release notes
I see 4.1 and 5.0, no 4.5
My bet 4.5 is the NET version you are working with.
--
Adrian Klaver
adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Connection Issue
@ 2024-08-02 17:08 Adrian Klaver <adrian.klaver@aklaver.com>
parent: Adrian Klaver <adrian.klaver@aklaver.com>
0 siblings, 0 replies; 18+ messages in thread
From: Adrian Klaver @ 2024-08-02 17:08 UTC (permalink / raw)
To: Andy Hartman <hartman60home@gmail.com>; +Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
On 8/2/24 9:55 AM, Andy Hartman wrote:
> How do I get latest and greatest?
Go to the previously shown link and read the Installation section.
>
> On Fri, Aug 2, 2024 at 12:52 PM Adrian Klaver <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>> wrote:
>
>
>
> On 8/2/24 9:47 AM, Andy Hartman wrote:
> Please don't top post. Use inline or bottom posting.
>
> > Looks like 4.5
>
> From here:
>
> https://www.npgsql.org/doc/performance.html
> <https://www.npgsql.org/doc/performance.html;
>
> Release notes
>
> I see 4.1 and 5.0, no 4.5
>
> My bet 4.5 is the NET version you are working with.
>
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 18+ messages in thread
end of thread, other threads:[~2024-08-02 17:08 UTC | newest]
Thread overview: 18+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-02-05 09:48 Connection issue Maximilian Tyrtania <maximilian.tyrtania@gmail.com>
2019-02-05 14:57 ` Adrian Klaver <adrian.klaver@aklaver.com>
2019-02-05 15:18 ` Maximilian Tyrtania <maximilian.tyrtania@gmail.com>
2019-02-05 15:44 ` Adrian Klaver <adrian.klaver@aklaver.com>
2019-02-05 23:19 ` Ricardo Martin Gomez <rimartingomez@hotmail.com>
2019-02-06 15:18 ` Maximilian Tyrtania <maximilian.tyrtania@gmail.com>
2019-02-06 16:19 ` Adrian Klaver <adrian.klaver@aklaver.com>
2019-02-06 16:30 ` Maximilian Tyrtania <maximilian.tyrtania@gmail.com>
2019-02-06 16:43 ` Adrian Klaver <adrian.klaver@aklaver.com>
2019-02-07 02:12 ` Ricardo Martin Gomez <rimartingomez@hotmail.com>
2019-02-07 10:25 ` Maximilian Tyrtania <maximilian.tyrtania@gmail.com>
2024-08-02 14:56 Connection Issue Andy Hartman <hartman60home@gmail.com>
2024-08-02 15:05 ` Re: Connection Issue Adrian Klaver <adrian.klaver@aklaver.com>
2024-08-02 16:18 ` Re: Connection Issue Adrian Klaver <adrian.klaver@aklaver.com>
2024-08-02 16:32 ` Re: Connection Issue Andy Hartman <hartman60home@gmail.com>
2024-08-02 16:44 ` Re: Connection Issue Adrian Klaver <adrian.klaver@aklaver.com>
2024-08-02 16:52 ` Re: Connection Issue Adrian Klaver <adrian.klaver@aklaver.com>
2024-08-02 17:08 ` Re: Connection Issue Adrian Klaver <adrian.klaver@aklaver.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