Re: [dspace-community] problem with Dspace

84 views
Skip to first unread message
Message has been deleted

Tim Donohue

unread,
Oct 18, 2022, 10:25:42 AM10/18/22
to Bryan Delgado, DSpace Community
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: dspace-c...@googlegroups.com <dspace-c...@googlegroups.com> on behalf of Bryan Delgado <brya...@gmail.com>
Sent: Monday, October 17, 2022 3:50 PM
To: DSpace Community <dspace-c...@googlegroups.com>
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 dspace-communi...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-community/589becd5-8852-4d50-a5d7-2e22ca6da3e7n%40googlegroups.com.
Message has been deleted

Tim Donohue

unread,
Oct 19, 2022, 10:59:05 AM10/19/22
to Bryan Delgado, DSpace Community
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.  


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
Sent: Wednesday, October 19, 2022 9:23 AM
To: DSpace Community <dspace-c...@googlegroups.com>
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 
Message has been deleted

Tim Donohue

unread,
Oct 24, 2022, 10:38:02 AM10/24/22
to Bryan Delgado, DSpace Community
Hi Bryan,

That error is listed in our "Common Installation Issues" with suggestions on how best to resolve it.  It likely is a configuration problem between your frontend & backend.


Tim
Sent: Friday, October 21, 2022 3:57 PM
To: DSpace Community <dspace-c...@googlegroups.com>

Subject: Re: [dspace-community] problem with Dspace
 
Hi Tim, thank for your answer, it was very helpful, finally I was editing a wrong file. 

Now I have another problem, maybe you can help me to solve. 

This is the info I can see in my browser 

Access to XMLHttpRequest at 'http://10.7.1.86:8080/server/api' from origin 'http://10.7.1.86:4000' has been blocked by CORS policy: Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-Origin' header is present on the requested resource.


Access to XMLHttpRequest at 'http://10.7.1.86:8080/server/api/authn/status' from origin 'http://10.7.1.86:4000' has been blocked by CORS policy: Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-Origin' header is present on the requested resource.


Access to XMLHttpRequest at 'http://10.7.1.86:8080/server/api' from origin 'http://10.7.1.86:4000' has been blocked by CORS policy: Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-Origin' header is present on the requested resource.

Error:  K {headers: f, status: 0, statusText: 'Unknown Error', url: 'http://10.7.1.86:8080/server/api', ok: false, …}


This is de info I see in my backend 

"dspaceUI": "http://10.7.1.86:4000", 
 "dspaceName": "DSpace false name", 
 "dspaceServer": "http://10.7.1.86:8080/server", 
 "dspaceVersion": "DSpace 7.3", 
 "type": "root", 
 "_links": { "actuator": { "href": "http://10.7.1.86:8080/server/actuator" }, 
 
"authn": { "href": "http://10.7.1.86:8080/server/api/authn" }, 
 "authorizations": { "href": "http://10.7.1.86:8080/server/api/authz/authorizations" }, 
 "bitstreamformats": { "href": "http://10.7.1.86:8080/server/api/core/bitstreamformats" }, 
 "bitstreams": { "href": "http://10.7.1.86:8080/server/api/core/bitstreams" }, 

and continue several more lines. 
Reply all
Reply to author
Forward
0 new messages