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.e...@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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
