Bug report #1039

PostGIS: unclear error message connecting to a wrong port

Added by Maciej Sieczka - over 16 years ago. Updated about 15 years ago.

Status:Closed
Priority:Low
Assignee:nobody -
Category:Data Provider
Affected QGIS version: Regression?:No
Operating System:All Easy fix?:No
Pull Request or Patch supplied: Resolution:wontfix
Crashes QGIS or corrupts data: Copied to github as #:11099

Description

When trying to connect to a port Postgres does not work on a cryptic "Extended error information" is given:

Connection failed - Check settings and try again.

Extended error information:
expected authentication request from server, but received S

History

#1 Updated by Jürgen Fischer over 16 years ago

  • Resolution set to wontfix
  • Status changed from Open to Closed

Does the error message get truncated like that? I get

could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "192.168.49.12" and accepting
        TCP/IP connections on port 5433?

which seems pretty clear. But I guess in your case there is something listing on the port you try to connect which even supports SSL as I get

received invalid response to SSL negotiation: 2

when connecting a SMTP port w/o SSL.

Anyway, those error messages are returned by the postgres client library and passed on to the user as that is all we known and therefore probably the best we can do.

#2 Updated by Maciej Sieczka - over 16 years ago

Replying to [comment:1 jef]:

Does the error message get truncated like that?

Exactly. All I get is:

Connection failed - Check settings and try again.

Extended error information:
expected authentication request from server, but received S

It was SSH port I tried to connect to by mistake.

I checked with PgAdmin. It displays same cryptic message. Not a QGIS issue it seems. Sorry for the fuss.

BTW - localised messages are garbled when they contain non-ASCII chars. Eg. in PL UTF8 locale I get:

Connection failed - Check settings and try again.

Extended error information:
could not connect to server: Przekroczony czas oczekiwania na połączenie
    Is the server running on host "127.0.0.1" and accepting
    TCP/IP connections on port 22?

instead of:

Connection failed - Check settings and try again.

Extended error information:
could not connect to server: Przekroczony czas oczekiwania na połączenie
    Is the server running on host "127.0.0.1" and accepting
    TCP/IP connections on port 22?

#3 Updated by Jürgen Fischer over 16 years ago

i18n fixed in fd84dcc0 (SVN r8348)

#4 Updated by Anonymous about 15 years ago

Milestone Version 0.9.2 deleted

Also available in: Atom PDF