[GENERAL] using jboss with ident auth

[eyal edri]

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?

thanks!!