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!!Â
