Page 1 of 2

Connection Hangs When Wrong Username/Password Provided

Posted: Thu 06 Jul 2006 08:59
by gabrielnasser
Hello,

I'm using CoreLab.PostgreSql v 2.50 with VS 2005. I have a C# project and when I try to open a connection synchronously using incorrect username/password then the method hangs indefinitely. The call works properly when the credentials are correct.

Here's my connection string.

"User Id=admin;Password=admin;Host=localhost;Database=tjsdb;Connection Timeout=5;Pooling=False;"

What could be the problem?

Gabriel

Posted: Thu 06 Jul 2006 10:42
by Alexey
What is the version of your PostgreSql server?

Posted: Thu 06 Jul 2006 13:08
by gabrielnasser
8.1.3 Running on Windows XP SP2.

Posted: Thu 06 Jul 2006 13:39
by Alexey
Please describe your configuration (local/remote server?, firewall?).
Could you provide us with a test account on your server, so we may try to connect to it.

Posted: Thu 06 Jul 2006 13:41
by gabrielnasser
The testing is done on the local machine - no firewall. I am unable to provide you with access to my machine.

Posted: Tue 11 Jul 2006 08:23
by Alexey
We tested this with PostgreSQL 8.1.4 and could not reproduce such behaviour. We get an error like "password authentication failed for user 'postgres'". We have default settings of PostgreSQL server.

Posted: Wed 12 Jul 2006 06:07
by gabrielnasser
But my environment is using 8.1.3? Have you tested with that?

Posted: Wed 12 Jul 2006 12:06
by Alexey
With PostgreSQL 8.1.3 same situation as with 8.1.4. I've just performed the test.

Posted: Wed 19 Jul 2006 09:41
by gabrielnasser
I have just exposed the machine temporarily.

Host: 195.229.241.183
Port: 5432

You can use any username/password combination to check that it is hanging.

Please let me know when you are done so that I can shutdown the port.

Thank you.

Posted: Wed 19 Jul 2006 10:44
by Alexey
Is your port still available? We are trying to connect right now with no success unfortunately.

Posted: Wed 19 Jul 2006 10:53
by gabrielnasser
Please try hostname: tjs2.no-ip.biz

Posted: Wed 19 Jul 2006 11:50
by Alexey
Getting the error
FATAL: password authentication failed for user "postgres"
It is not hanging.
What is the full version of your PostgreSQLDirect?

Posted: Wed 19 Jul 2006 11:58
by gabrielnasser
PostgreSqlDirect version 2.50.15.0 running in Release version on same local machine. Platform is Windows XP SP2 with .NET 2.0.

Posted: Wed 19 Jul 2006 12:24
by Alexey
Just tested. Same results.

Posted: Wed 19 Jul 2006 12:28
by gabrielnasser
We are experience the same problem with this version at 19 deployed sites - not just the test machine.

What do you suggest we do at the moment?