[Dspace-tech] Dspace installing-db ident authentication failed problem???!

[y...@iodp-mi-sapporo.org]

Dear all


I am quite new to the dspace. When I set up the dspace.
there is a ident authentication failed problem.
But, I am quite sure the password is same as in
dspace.cfg....Although I did some change in the
configuration files. I restart the apache and tomcat
everytime. Is there any service or computer I need to
restart also??
How to handle this problem ...Thanks very much..... Looking
forwart to reply....



[java] 2007-07-12 16:07:44,986 INFO
org.dspace.storage.rdbms.InitializeDatabase @ Initializing
Database
[java] 2007-07-12 16:07:45,067 INFO
org.dspace.core.ConfigurationManager @ DSpace logging
installed using log4j.properties
[java] 2007-07-12 16:07:45,358 FATAL
org.dspace.storage.rdbms.InitializeDatabase @ Caught
exception:
[java] org.postgresql.util.PSQLException: FATAL: Ident
authentication failed for user "dspace"
[java] at
org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:275)
[java] at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:94)
[java] at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
[java] at
org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:116)
[java] at
org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
[java] at
org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
[java] at
org.postgresql.Driver.makeConnection(Driver.java:369)
[java] at
org.postgresql.Driver.connect(Driver.java:245)
[java] at
java.sql.DriverManager.getConnection(DriverManager.java:512)
[java] at
java.sql.DriverManager.getConnection(DriverManager.java:171)
[java] at
org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:48)
[java] at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
[java] at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:840)
[java] at
org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:175)
[java] at
java.sql.DriverManager.getConnection(DriverManager.java:512)
[java] at
java.sql.DriverManager.getConnection(DriverManager.java:193)
[java] at
org.dspace.storage.rdbms.DatabaseManager.getConnection(DatabaseManager.java:717)
[java] at
org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:1062)
[java] at
org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:71)

[Mark H. Wood]

On Thu, Jul 12, 2007 at 04:31:17PM +0900, y...@iodp-mi-sapporo.org wrote:
> I am quite new to the dspace. When I set up the dspace.
> there is a ident authentication failed problem.
> But, I am quite sure the password is same as in
> dspace.cfg....Although I did some change in the
> configuration files. I restart the apache and tomcat
> everytime. Is there any service or computer I need to
> restart also??
> How to handle this problem ...Thanks very much..... Looking
> forwart to reply....
>
>
>
> [java] 2007-07-12 16:07:44,986 INFO org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database
> [java] 2007-07-12 16:07:45,067 INFO org.dspace.core.ConfigurationManager @ DSpace logging installed using log4j.properties
> [java] 2007-07-12 16:07:45,358 FATAL org.dspace.storage.rdbms.InitializeDatabase @ Caught exception:
> [java] org.postgresql.util.PSQLException: FATAL: Ident authentication failed for user "dspace"

Your PostgreSQL configuration is matching DSpace's connection attempt
to a line in pg_hba.conf specifying the 'ident' authentication method,
and the usermap specified in that line doesn't match the username
being returned by your host's ident server. So, for example, if you
have:

host dspace dspace 127.0.0.1/32 ident sameuser

then Tomcat must be running as a user named "dspace" or this will
fail, because the DBMS will ask the ident server who owns that
connection and require that it be 'dspace' (the same username for DBMS
and client process).

One other possibility is that you don't have an 'ident' service
running at all. It's not really very secure, and some sites don't
use it.

If you run Tomcat as user 'tomcat' (which many distributions set up
automatically), and you want to call the PostgreSQL user 'dspace'
(which makes a lot of sense), and you want to use 'ident'
authentication (but see the warnings in the PostgreSQL documentation),
then you'll need a mapping other than 'sameuser'. You could
configure:

host dspace dspace 127.0.0.1/32 ident dspace

and place in 'pg_ident.conf':

dspace tomcat dspace

HOWEVER, since you mention a password, you probably meant to use a
password-based authentication method such as 'md5', 'crypt',
'password', or 'pam'. Those methods should ignore Tomcat's username
and depend on the DBMS username and password that you configured in
'dspace.cfg'.

I run Tomcat under the username 'tomcat', install and configure DSpace
to use the username 'dspace' for the DBMS connection, configure
PostgreSQL for 'md5' authentication, and it works well.

--
Mark H. Wood, Lead System Programmer mw...@IUPUI.Edu
Typically when a software vendor says that a product is "intuitive" he
means the exact opposite.