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 /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. Em ter., 22 de out. de 2024 às 08:47, Nguyễn Thị Bích Phượng < [email protected]> escreveu: > 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 > > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/dspace-community/7304582b-20c0-4e63-9a97-444326bbf5d6n%40googlegroups.com > <https://groups.google.com/d/msgid/dspace-community/7304582b-20c0-4e63-9a97-444326bbf5d6n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-community/CAFxLN1q%3D9C4YNWYSEJRBTZroX91q%3D-mxkQd1AM7iL7HTRf8YaQ%40mail.gmail.com.
