DSpace 8.0 Ant Fresh Installation Error

[Nguyễn Thị Bích Phượng]

JDK - 17

Apache Ant(TM) version 1.10.12

Apache Maven 3.9.9

PostgreSQL - 17

I'm using Ubuntu 22.04

Buildfile: /build/DSpace-dspace-8.0/dspace/target/dspace-installer/build.xml

init_installation:

prepare_configs:
    [mkdir] Created dir: /build/DSpace-dspace-8.0/dspace/target/dspace-installer/config-temp
     [copy] Copying 254 files to /build/DSpace-dspace-8.0/dspace/target/dspace-installer/config-temp
     [copy] Copying 1 file to /build/DSpace-dspace-8.0/dspace/target/dspace-installer/config-temp
     [copy] Copying 15 files to /build/DSpace-dspace-8.0/dspace/target/dspace-installer/config-temp

init_configs:
     [copy] Copying 1 file to /dspace/config
   [delete] Deleting directory /build/DSpace-dspace-8.0/dspace/target/dspace-installer/config-temp

test_database:
     [java] 2024-10-22 18:26:30,461 ERROR org.dspace.storage.rdbms.DatabaseUtils @ Unable to setup Flyway against DSpace database
     [java] java.sql.SQLException: Cannot create PoolableConnectionFactory (FATAL: password authentication failed for user "dspace")
     [java] at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:633) ~[commons-dbcp2-2.11.0.jar:2.11.0]
     [java] at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:535) ~[commons-dbcp2-2.11.0.jar:2.11.0]
     [java] at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:711) ~[commons-dbcp2-2.11.0.jar:2.11.0]
     [java] at org.dspace.storage.rdbms.DatabaseUtils.setupFlyway(DatabaseUtils.java:594) [dspace-api-8.0.jar:8.0]
     [java] at org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:108) [dspace-api-8.0.jar:8.0]
     [java] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
     [java] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[?:?]
     [java] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
     [java] at java.base/java.lang.reflect.Method.invoke(Method.java:569) ~[?:?]
     [java] at org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:283) [dspace-api-8.0.jar:8.0]
     [java] at org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:134) [dspace-api-8.0.jar:8.0]
     [java] at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:99) [dspace-api-8.0.jar:8.0]
     [java] Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "dspace"
     [java] at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:698) ~[postgresql-42.7.3.jar:42.7.3]
     [java] at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:207) ~[postgresql-42.7.3.jar:42.7.3]
     [java] at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:262) ~[postgresql-42.7.3.jar:42.7.3]
     [java] at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:54) ~[postgresql-42.7.3.jar:42.7.3]
     [java] at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:273) ~[postgresql-42.7.3.jar:42.7.3]
     [java] at org.postgresql.Driver.makeConnection(Driver.java:446) ~[postgresql-42.7.3.jar:42.7.3]
     [java] at org.postgresql.Driver.connect(Driver.java:298) ~[postgresql-42.7.3.jar:42.7.3]
     [java] at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:52) ~[commons-dbcp2-2.11.0.jar:2.11.0]
     [java] at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:414) ~[commons-dbcp2-2.11.0.jar:2.11.0]
     [java] at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:113) ~[commons-dbcp2-2.11.0.jar:2.11.0]
     [java] at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:629) ~[commons-dbcp2-2.11.0.jar:2.11.0]
     [java] ... 11 more
     [java] Caught exception:
     [java] java.sql.SQLException: Cannot create PoolableConnectionFactory (FATAL: password authentication failed for user "dspace")
     [java] at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:633)
     [java] at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:535)
     [java] at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:711)
     [java] at org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:113)
     [java] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [java] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
     [java] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     [java] at java.base/java.lang.reflect.Method.invoke(Method.java:569)
     [java] at org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:283)
     [java] at org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:134)
     [java] at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:99)
     [java] Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "dspace"
     [java] at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:698)
     [java] at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:207)
     [java] at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:262)
     [java] at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:54)
     [java] at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:273)
     [java] at org.postgresql.Driver.makeConnection(Driver.java:446)
     [java] at org.postgresql.Driver.connect(Driver.java:298)
     [java] at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:52)
     [java] at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:414)
     [java] at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:113)
     [java] at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:629)
     [java] ... 10 more

BUILD FAILED
/build/DSpace-dspace-8.0/dspace/target/dspace-installer/build.xml:783: Java returned: 1

[Job Diogenes Ribeiro Borges]

This seems to be a Postgress access problem. Near version of prostgresql need more adjustment.

I solve this by using  a dspace-init.sql script, which I use before installation.

"CREATE DATABASE dspace;

SET password_encryption = 'md5';

CREATE USER dspace with encrypted password 'dspace';

GRANT ALL PRIVILEGES ON DATABASE dspace TO dspace;

ALTER DATABASE dspace OWNER TO dspace;

\c dspace

CREATE EXTENSION pgcrypto;

create a "dspace-init.sql" put it in some folder as /dspace, with the above content and than

as root run; 'su postgres -c "psql -f /dspace/dspace-init.sql"

or just as postgres user, run psql and copy e past the above SQL statements

Hope, these  could solve this problem for you.

[Nguyễn Tuấn Vũ]

You should check the database password. Have you created a database dspace ? If you created it then change the password in file local.cfg with your database password .

Regard,

--
All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx
---
You received this message because you are subscribed to the Google Groups "DSpace Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dspace-communi...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-community/7304582b-20c0-4e63-9a97-444326bbf5d6n%40googlegroups.com.

--

Nguyễn Tuấn Vũ

Sofware Team Leader - Library Solution

HO: Floor 5, B Building, 22 Thanh Cong, Ba Dinh district, Hanoi

RO: Unit 10, Floor 12A, Vincom Center B, 45A Ly Tu Trong, Ben Nghe Ward, District 1, HCMC

Website: dlcorp.com.vn | pamair.org | pamhome.org | limaeducation.com

Email: tuanvu...@dlcorp.com.vn | Mobile: (+84) 944 340 890

Follow our Company on : Facebook | LinkedIn