Re: Connecting to PostgreSQL server with Mono using ident authetication - Mailing list pgsql-general

From Andreas Tille
Subject Re: Connecting to PostgreSQL server with Mono using ident authetication
Date
Msg-id Pine.LNX.4.64.0709041447150.9929@wr-linux02
Whole thread Raw
In response to Connecting to PostgreSQL server with Mono using ident authetication  (Andreas Tille <tillea@rki.de>)
Responses Re: Connecting to PostgreSQL server with Mono using ident authetication
List pgsql-general
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

pgsql-general by date:

Previous
From: "Andrew Maclean"
Date:
Subject: Re: Documentation fix regarding atan2
Next
From: luca.ciciriello@email.it
Date:
Subject: PostgreSQL and Crystal Report