I made a system in CentOS5.5.
I used Tomcat6 and PostgreSQL.
But I couldn't enter my system. There are some error.
And I don't understand what kind of error this. And how to solve this problem.
JDBCExceptionReporter.logExceptions(100) | SQL Error: 0, SQLState: null
JDBCExceptionReporter.logExceptions(101) | Cannot create PoolableConnectionFactory (FATAL: Ident authentication failed for user "postgres")

"postgres" is username.

Is anybody knows anything about this error message, please post me. I will waiting for you.
Thank you

Have a wonderful day
Tsengel

Hi,

Make sure that you have the following in pg_hba.conf (located in /var/lib/pgsql/data)
Regards

Thank you,bathory.

I checked the file. And I found that.


#TYPE DATABASE USER CIDR-ADDRESS METHOD

#"local" is for Unix domain socket connections only
local all all ident sameuser

#IPv4 local connections:
host all all 127.0.0.1/32 ident sameuser

#IPv6 local connections:
host all all ::1/128 ident sameuser

Do I need to append "trust". Is Trust METHOD. If yes, do i change "ident sameuser" to "trust" ?

thank you again for your post.

Best regards, Tsengel

it's gone,bathory
Thank you so so much.
I am so happy.
I changed "ident sameuser" to "trust".

Thank you Thank you.

Best regards, Tsengel

In case the machine holds sensitive information of any kind trust
is not a good choice. You'd be better off to a) use the proper user
name (depending on how your tomcat interacts w/ postgres, or
password authentication via md5 [my personal preference]).



Cheers,
Tink