Re: Connecting to PostgreSQL server with Mono using ident authetication

On Mon, 4 Sep 2007, Albe Laurenz wrote:

> The best list for this kind of thing is certainly the Npgsql
> mailing list:
> http://gborg.postgresql.org/mailman/listinfo/npgsql-general

Just subscribed.

> What error messages do you get when you try to connect?

When I use the connection string

string connStr = "Server=127.0.0.1;Port=5432;User=tillea;Database=InfluenzaWeb;";

I get

Npgsql.NpgsqlException:
Passwort-Authentifizierung für Benutzer 'tillea' fehlgeschlagen
--> Translation: Password authentication for user 'tillea' failed
Severity: FATAL
Code: 28000
at Npgsql.NpgsqlConnector.CheckErrors () [0x00000]
at Npgsql.NpgsqlConnector.Open () [0x00000]
at Npgsql.NpgsqlConnectorPool.GetPooledConnector (Npgsql.NpgsqlConnection Connection) [0x00000]

So npgsql is obviousely trying password authentication and I have no idea
how to ask for ident authetication. I also tried
Server=localhost

If I leave out the Server parameter at all I get

System.ArgumentException: Connection string argument missing!
Parameter name: SERVER

(which is different to other psql connectors I know from Python or Perl).

Kind regards

Andreas.

PS: I've seen a another private answer to my mail in my incoming box but due to
a problem here it was deleted. :(
Could the kind poster please repost his mail because I don't see it in
the archive?

Many thanks, Andreas.

--
http://fam-tille.de