Hi Bryan, If you are sure that those "db.username" and "db.password" settings are correct in your local.cfg, then I'd highly recommend closely reviewing all the "db.*" settings in your local.cfg file.
https://github.com/DSpace/DSpace/blob/main/dspace/config/local.cfg.EXAMPLE#L73-L101 The error message you received from DSpace is basically saying that DSpace is unable to connect to or login to your database. That means that either your local.cfg settings require updating, or maybe there's a firewall or something else blocking your DSpace from connecting to the database. Hopefully that helps give you some more hints at what to look at. Tim ________________________________ From: [email protected] <[email protected]> on behalf of Bryan Delgado <[email protected]> Sent: Wednesday, October 19, 2022 9:23 AM To: DSpace Community <[email protected]> Subject: Re: [dspace-community] problem with Dspace Hello Tim, thanks for your repply. Following the steps of point 6 I see that everything is configured correctly. I did a test connecting remotely with the sqlectron tool to postgreSQL with dspace credentials and I was able to connect fine, I was even able to create and delete a test base El martes, 18 de octubre de 2022 a la(s) 11:25:42 UTC-3, Tim Donohue escribió: Hi Bryan, That error appears to be saying that your database user password is incorrect. See this message: Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "dspace" This likely means that either your "db.username" or "db.password" (or both) are not correctly configured in your local.cfg. See step 6 of the Installation process: https://wiki.lyrasis.org/display/DSDOC7x/Installing+DSpace#InstallingDSpace-BackendInstallation Tim ________________________________ From: [email protected] <[email protected]> on behalf of Bryan Delgado <[email protected]> Sent: Monday, October 17, 2022 3:50 PM To: DSpace Community <[email protected]> Subject: [dspace-community] problem with Dspace Hello everyone, i've been install Dspace 7.3 en my enviroment and all was fine until I ran ant fresh_install and get the next error. Could someone helpme please? root@dspace:/home/build/DSpace-dspace-7.3/dspace/target/dspace-installer# ant fresh_install Buildfile: /home/build/DSpace-dspace-7.3/dspace/target/dspace-installer/build.xml init_installation: prepare_configs: [mkdir] Created dir: /home/build/DSpace-dspace-7.3/dspace/target/dspace-installer/config-temp [copy] Copying 215 files to /home/build/DSpace-dspace-7.3/dspace/target/dspace-installer/config-temp [copy] Copying 1 file to /home/build/DSpace-dspace-7.3/dspace/target/dspace-installer/config-temp [copy] Copying 14 files to /home/build/DSpace-dspace-7.3/dspace/target/dspace-installer/config-temp init_configs: [copy] Copying 1 file to /dspace/config [delete] Deleting directory /home/build/DSpace-dspace-7.3/dspace/target/dspace-installer/config-temp test_database: [java] 2022-10-17 17:30:25,432 WARN org.dspace.servicemanager.DSpaceServiceManager @ Unable to locate bean by name or id=database. Will try to look up bean by type next. [java] org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'database' available [java] at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:872) ~[spring-beans-5.3.20.jar:5.3.20] [java] at org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBeanDefinition(AbstractBeanFactory.java:1344) ~[spring-beans-5.3.20.jar:5.3.20] [java] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:309) ~[spring-beans-5.3.20.jar:5.3.20] [java] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:213) ~[spring-beans-5.3.20.jar:5.3.20] [java] at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1160) ~[spring-context-5.3.20.jar:5.3.20] [java] at org.dspace.servicemanager.DSpaceServiceManager.getServiceByName(DSpaceServiceManager.java:426) [dspace-services-7.3.jar:7.3] [java] at org.dspace.scripts.ScriptServiceImpl.getScriptConfiguration(ScriptServiceImpl.java:33) [dspace-api-7.3.jar:7.3] [java] at org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:125) [dspace-api-7.3.jar:7.3] [java] at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:98) [dspace-api-7.3.jar:7.3] [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:656) [java] at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:534) [java] at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:734) [java] 2022-10-17 17:30:25,617 ERROR org.dspace.storage.rdbms.DatabaseUtils @ Unable to setup Flyway against DSpace database at org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:112) [java] java.sql.SQLException: Cannot create PoolableConnectionFactory (FATAL: password authentication failed for user "dspace") [java] [java] at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:656) ~[commons-dbcp2-2.8.0.jar:2.8.0] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [java] [java] at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:534) ~[commons-dbcp2-2.8.0.jar:2.8.0] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [java] [java] at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:734) ~[commons-dbcp2-2.8.0.jar:2.8.0] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [java] [java] at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.dspace.storage.rdbms.DatabaseUtils.setupFlyway(DatabaseUtils.java:537) [dspace-api-7.3.jar:7.3] [java] [java] at org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:277) at org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:107) [dspace-api-7.3.jar:7.3] [java] at org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:133) [java] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?] [java] [java] at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:98) at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?] [java] [java] Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "dspace" at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?] [java] at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:646) [java] [java] at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?] [java] at org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:277) [dspace-api-7.3.jar:7.3] [java] at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:180) at org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:133) [dspace-api-7.3.jar:7.3] [java] [java] at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:235) at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:98) [dspace-api-7.3.jar:7.3] [java] [java] at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) [java] at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:223)Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "dspace" [java] [java] at org.postgresql.Driver.makeConnection(Driver.java:400) [java] at org.postgresql.Driver.connect(Driver.java:259) at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:646) ~[postgresql-42.3.3.jar:42.3.3] [java] [java] at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:52) at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:180) ~[postgresql-42.3.3.jar:42.3.3] [java] [java] at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:235) ~[postgresql-42.3.3.jar:42.3.3] [java] at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) ~[postgresql-42.3.3.jar:42.3.3] at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:357) [java] at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:223) ~[postgresql-42.3.3.jar:42.3.3] [java] at org.postgresql.Driver.makeConnection(Driver.java:400) ~[postgresql-42.3.3.jar:42.3.3] [java] at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:103) [java] at org.postgresql.Driver.connect(Driver.java:259) ~[postgresql-42.3.3.jar:42.3.3] [java] [java] at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:52) ~[commons-dbcp2-2.8.0.jar:2.8.0] at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:652) [java] at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:357) ~[commons-dbcp2-2.8.0.jar:2.8.0] [java] at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:103) ~[commons-dbcp2-2.8.0.jar:2.8.0] [java] [java] ... 10 more at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:652) ~[commons-dbcp2-2.8.0.jar:2.8.0] [java] [java] ... 11 more BUILD FAILED /home/build/DSpace-dspace-7.3/dspace/target/dspace-installer/build.xml:770: 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/589becd5-8852-4d50-a5d7-2e22ca6da3e7n%40googlegroups.com<https://groups.google.com/d/msgid/dspace-community/589becd5-8852-4d50-a5d7-2e22ca6da3e7n%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]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-community/e0ecb21d-b4d7-4378-b242-2382156d817en%40googlegroups.com<https://groups.google.com/d/msgid/dspace-community/e0ecb21d-b4d7-4378-b242-2382156d817en%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/PH0PR22MB32743F0496EADA09CBE73A6AED2B9%40PH0PR22MB3274.namprd22.prod.outlook.com.
