SEO

Hi,

it is my first shot using Mono and I failed to get the example from

http://www.mono-project.de/wiki/keyword/PostgreSQL/

working. The reason is obviousely that whatever I tried NpgsqlConnection
tries to use password authentication but I have configured my system
that ident authentication is used by default.

I'm using Debian GNU/Linux testing running postgresql 8.2 and mono 1.2.
Could anybody enlight me how to connect to a database where users have
no password set because always ident authentication is used on local host.

I hope this is the right list for this kind of questions. Any hint for
a better place to ask is welcome as well.

Kind regards

Andreas.

PS: It would be welcome if you keep me in CC because I'm not subscribed
to the list, but I can read the archive as well.

--
http://fam-tille.de

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/

> it is my first shot using Mono and I failed to get the example from
>
> http://www.mono-project.de/wiki/keyword/PostgreSQL/
>
> working. The reason is obviousely that whatever I tried
> NpgsqlConnection
> tries to use password authentication but I have configured my system
> that ident authentication is used by default.
>
> I'm using Debian GNU/Linux testing running postgresql 8.2 and
> mono 1.2.
> Could anybody enlight me how to connect to a database where users have
> no password set because always ident authentication is used
> on local host.

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

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

Yours,
Laurenz Albe

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

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/...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=I nfluenzaWeb;";

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match