On Mon, 6 Jun 2011 11:55:47 +0200, Magnus Hagander wrote:
On Jun 2, 2011 4:16 PM, "eyal edri" wrote: > > Hi, > > Im trying to use postgres with ident auth and jboss. > > heres my postgres files: > > pg_hba.conf: > > # TYPE ÂDATABASE  ÂUSER    ÂCIDR-ADDRESS     ÂMETHOD > > # "local" is for Unix domain socket connections only > local  all     all                   Âident map=vmap > # IPv4 local connections: > host  Âall     all     127.0.0.1/32 [2]     Âident map=vmap > # IPv6 local connections: > host  Âall     all     ::1/128          ident map=vmap > > > pg_ident.conf: > > # MAPNAME   SYSTEM-USERNAME  ÂPG-USERNAME > vmap postgres Âpostgres > vmap root  Âpostgres > > ive set the postres password to postgres and updated the postres-ds.xml file under jboss: > > >     >         DataSource >         jdbc:postgresql://localhost:5432/dbname >         org.postgresql.Driver >         postgres >         postgres >         100 >         select 1 >     > > > when i try to run any command that uses the xml file for auth, it failes with: > > FATAL: Ident authentication failed for user "postgres" > > when i use password or md5 it works. > > > btw, i would have used password or md5 if there was a away to run psql commands with passwordÂunattended (without password prompt..). > > any ideas? Is there something in the PostgreSQL server logs when this happens? The client side error message will intentionally not contain al details of authentication problems. Also, do you get anything in the logs of your Ident sever? /Magnus Links: ------ [1] mailto:eyal.edri@xxxxxxxxx [2] http://127.0.0.1/32
I had similar problem about ident auth (but I think with smtp/imap). If I remember well You should have running ident server (port 113) on your Linux box.
Check it with netstat. Regards, Radek -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
