admin login problems 7.3-snapshot

[wolfgang t.]

admin login does only show import and export and not the other items.

Importend settings of the server

Added chainfile and file to the certificate section of apache2.

https://github.com/DSpace/DSpace/issues/8200

yarn test:rest showed no error.

solr/search/select seams to show the right answer

wget ...server/api also showed the right result.

After login

I see that inside the browser developer

Autofocus processing was blocked because a document already has a focused element.

After refresh I see at least the homepage with the two items, but not all items.

The only error in the browser developer is google analytics.key 404.

I made a reboot, and started the yarn run serve:ssr after reboot, so there was not an old node open which could block port 4000.

[Tim Donohue]

Hi,

If you are using Shibboleth, it's possible you are hitting this bug: https://github.com/DSpace/dspace-angular/issues/1515   It was just fixed in the codebase yesterday.  Since you sound like you are using the latest code, you can try and update your UI code to the latest version and see if the problem is gone.

If that's *not* the problem, then you should closely check the logs to see if any errors are appearing there.... or check again to see if your UI throws an error when you perform a login.  Here's the troubleshooting guide: https://wiki.lyrasis.org/display/DSPACE/Troubleshoot+an+error#Troubleshootanerror-DSpace7.x(orabove)  Unfortunately, without finding the error message, it can be very very difficult to track down the problem.  

Tim

[wolfgang t.]

Error Messages from dspace.log

497:2022-03-13 20:02:00,558 ERROR unknown unknown org.dspace.statistics.SolrLoggerServiceImpl @ The required 'dbfile' configuration is missing in solr-statistics.cfg!
666:2022-03-13 20:02:27,724 ERROR a9506a3d-fce4-4487-b5f2-bc6bb40db151 cdd98361-d9dc-456d-b823-dec47bbee347 org.dspace.app.rest.exception.DSpaceApiExceptionControllerAdvice @ An exception has occurred (status:500)

java.lang.NullPointerException: null

        at org.dspace.app.rest.converter.ConverterService.toRest(ConverterService.java:107) ~[classes/:7.3-SNAPSHOT]
        at org.dspace.app.rest.converter.ConverterService.toRestPage(ConverterService.java:203) ~[classes/:7.3-SNAPSHOT]
        at org.dspace.app.rest.repository.SiteRestRepository.findAll(SiteRestRepository.java:64) ~[classes/:7.3-SNAPSHOT]
        at org.dspace.app.rest.repository.SiteRestRepository$$FastClassBySpringCGLIB$$4fda3bbe.invoke(<generated>) ~[classes/:7.3-SNAPSHOT]
        at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.2.5.RELEASE.jar:5.2.5.RELEASE]
        at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:687) ~[spring-aop-5.2.5.RELEASE.jar:5.2.5.RELEASE]
        at org.dspace.app.rest.repository.SiteRestRepository$$EnhancerBySpringCGLIB$$41abe8be.findAll(<generated>) ~[classes/:7.3-SNAPSHOT]
        at org.dspace.app.rest.repository.DSpaceRestRepository.findAll(DSpaceRestRepository.java:238) ~[classes/:7.3-SNAPSHOT]
        at org.dspace.app.rest.repository.DSpaceRestRepository$$FastClassBySpringCGLIB$$615525f9.invoke(<generated>) ~[classes/:7.3-SNAPSHOT]
        at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.2.5.RELEASE.jar:5.2.5.RELEASE]
        at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:687) ~[spring-aop-5.2.5.RELEASE.jar:5.2.5.RELEASE]
        at org.dspace.app.rest.repository.SiteRestRepository$$EnhancerBySpringCGLIB$$41abe8be.findAll(<generated>) ~[classes/:7.3-SNAPSHOT]
        at org.dspace.app.rest.RestResourceController.findAll(RestResourceController.java:928) ~[classes/:7.3-SNAPSHOT]
        at jdk.internal.reflect.GeneratedMethodAccessor181.invoke(Unknown Source) ~[?:?]
        at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
        at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
        at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) ~[spring-web-5.2.5.RELEASE.jar:5.2.5.RELEASE]
        at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) ~[spring-web-5.2.5.RELEASE.jar:5.2.5.RELEASE]
        at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105) ~[spring-webmvc-5.2.5.REL
EASE.jar:5.2.5.RELEASE]

No other relevant errors. Inside the browser developer tools, there is no error, except for google analytics.

When I visit the page, I get the running points, the homepage_news text is not shown.

When i log in I only get import/export items, not more.

No errors in apache2, tomcat9, pm2

[wolfgang t.]

Hal login works, just saw today that only the second login works, but thereafter it works again, perhaps, this is just a issue when I was logged in and wanted to login after some tim again, meanin lost login.

[wolfgang t.]

I just did see that the following cookies which are present in the demo site, are not present when i open my site:

XSRF-TOKEN

klaro-anonymous

[Mohammad S. AlMutairi]

Try this also see a version of it in a text format attached in case of copying of this thread will develop hidden characters :

1) Settings in dspace.cfg or local.cfg:
dspace.server.url = https://dspace.umiz.at/server
dspace.ui.url = https://dspace.umiz.at
solr.server = http://localhost:8983/solr

2) Settings in config.prod.yml:
ui:
  ssl: false  
  host: localhost
  port: 4000
  nameSpace: /

rest:
  ssl: true
  host: dspace.umiz.at
  port: 443
  nameSpace: /server

3) a2enmod proxy_http proxy_html ssl headers
4) a2dissite 000-default default-ssl
5) vi /etc/apache2/sites-available/dspace.conf
<VirtualHost *:80>
     ServerName dspace.umiz.at
     Redirect / https://dspace.umiz.at
</VirtualHost>

<VirtualHost *:443>
     ServerName dspace.umiz.at
     LogLevel warn
     ErrorLog ${APACHE_LOG_DIR}/dspace.umiz.at.error.log
     CustomLog ${APACHE_LOG_DIR}/dspace.umiz.at.access.log combined
     ProxyRequests on
     SSLEngine on
     SSLProxyEngine on
     SSLCertificateFile /etc/letsencrypt/live/dspace.umiz.at/fullchain.pem
     SSLCertificateKeyFile /etc/letsencrypt/live/dspace.umiz.at/privkey.pem
     SSLCompression off
     SSLProtocol             all -SSLv3 -TLSv1 -TLSv1.1
     SSLCipherSuite          ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-CHACHA20-POLY1305:ECDHE-RSA-CHACHA20-POLY1305:DHE-RSA-AES128-GCM-SHA256:DHE-RSA-AES256-GCM-SHA384
     SSLHonorCipherOrder     off
     SSLSessionTickets       off
     ProxyPreserveHost on
     RequestHeader set X-Forwarded-Proto https
     #ProxyPass /location-to-be-excluded !

   <Proxy *>
       AddDefaultCharset Off
       Require all granted
   </Proxy>

     ProxyPass /server http://localhost:8080/server
     ProxyPassReverse /server http://localhost:8080/server
     #Solr settings is here for testing only. You shouldn't permanantly enable solr to be accessed from the outside. If you do cores can be removed/modified/addedd because dspace doesn't support protected solr.
     #ProxyPass /solr http://localhost:8983/
     #ProxyPassReverse /solr http://localhost:8983/
     ProxyPass / http://localhost:4000/
     ProxyPassReverse / http://localhost:4000/

</VirtualHost>

6) a2ensite dspace.conf
7) ufw allow 'OpenSSH'
8) ufw allow 'Apache Full'
9) ufw enable
10) ufw status
11) systemctl restart apache2

[Tim Donohue]

Hi Wolfgang,

This error looks to be the same one that another user encountered in this dspace-tech thread: https://groups.google.com/g/dspace-tech/c/F6qtImSF5Yo/m/8UzFbk9_BgAJ

In that situation, that person had said the issue on their end was that they had to use the "Alternative method: How to enable pgcrypto via a separate database schema" (in the Install Documentation, Step 5) in order to get pgcrypto installed correctly & ensure the database setup worked properly: https://wiki.lyrasis.org/display/DSDOC7x/Installing+DSpace#InstallingDSpace-BackendInstallation

I've not been able to reproduce this locally yet, but it sounds like you have the same issue... your database doesn't sound like it's been setup properly because you are missing the "Site" object (in the "site" table). That object should be created automatically by the database setup scripts.  See that earlier thread for more details.

Tim

[wolfgang t.]

THANK YOU, that was it!!!

[Mohammad S. AlMutairi]

Your configuration you posted here https://github.com/DSpace/DSpace/issues/8200 is a total mess. Maybe you should clean it too.