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.edri@gmail.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