On Jun 2, 2011 4:16 PM, "eyal edri" <eyal.edri@gmail.com> wrote:
>
> Hi,
>
> I'm trying to use postgres with ident auth and jboss.
>
> here's 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 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
>
> i've set the postres password to 'postgres' and updated the postres-ds.xml file under jboss:
>
> <datasources>
> <local-tx-datasource>
> <jndi-name>DataSource</jndi-name>
> <connection-url>jdbc:postgresql://localhost:5432/dbname</connection-url>
> <driver-class>org.postgresql.Driver</driver-class>
> <user-name>postgres</user-name>
> <password>postgres</password>
> <max-pool-size>100</max-pool-size>
> <check-valid-connection-sql>select 1</check-valid-connection-sql>
> </local-tx-datasource>
> </datasources>
>
> 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