Re: using jboss with ident auth

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(dot)edri(at)gmail(dot)com
> [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