org.dspace.discovery.SearchServiceException: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "dspace-cris", database "dspace-cris", SSL off

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Dspace-CRIS Item view and Download count problem
    via by Yen-Tang Chen,
  • When loading xwiki with a remote solr instance, the server is full of errors below: 2015-06-26 14:53:01,730 [XWiki Solr index job thread] ERROR x.s.s.i.j.SolrDocumentIterator - Failed to query the Solr index. org.apache.solr.client.solrj.impl.HttpSolrServer$RemoteSolrException: Expected mime type application/octet-stream but got text/html. <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/> <title>Error 404 Not Found</title> </head> <body><h2>HTTP ERROR 404</h2> <p>Problem accessing /solr/select. Reason: <pre> Not Found</pre></p><hr><i><small>Powered by Jetty://</small></i><hr/> </body> </html> at org.apache.solr.client.solrj.impl.HttpSolrServer.executeMethod(HttpSolrServer.java:512) ~[solr-solrj-4.10.3.jar:4.10.3 1644336 - mark - 2014-12-10 00:35:46] at org.apache.solr.client.solrj.impl.HttpSolrServer.request(HttpSolrServer.java:210) ~[solr-solrj-4.10.3.jar:4.10.3 1644336 - mark - 2014-12-10 00:35:46] at org.apache.solr.client.solrj.impl.HttpSolrServer.request(HttpSolrServer.java:206) ~[solr-solrj-4.10.3.jar:4.10.3 1644336 - mark - 2014-12-10 00:35:46] at org.apache.solr.client.solrj.request.QueryRequest.process(QueryRequest.java:91) ~[solr-solrj-4.10.3.jar:4.10.3 1644336 - mark - 2014-12-10 00:35:46] at org.apache.solr.client.solrj.SolrServer.query(SolrServer.java:301) ~[solr-solrj-4.10.3.jar:4.10.3 1644336 - mark - 2014-12-10 00:35:46] at org.xwiki.search.solr.internal.AbstractSolrInstance.query(AbstractSolrInstance.java:117) ~[xwiki-platform-search-solr-api-6.4.4.jar:na] at org.xwiki.search.solr.internal.job.SolrDocumentIterator.getResults(SolrDocumentIterator.java:128) [xwiki-platform-search-solr-api-6.4.4.jar:na] at org.xwiki.search.solr.internal.job.SolrDocumentIterator.hasNext(SolrDocumentIterator.java:91) [xwiki-platform-search-solr-api-6.4.4.jar:na] at org.xwiki.search.solr.internal.job.DiffDocumentIterator.hasNext(DiffDocumentIterator.java:107) [xwiki-platform-search-solr-api-6.4.4.jar:na] at org.xwiki.search.solr.internal.job.IndexerJob.updateSolrIndex(IndexerJob.java:110) [xwiki-platform-search-solr-api-6.4.4.jar:na] at org.xwiki.search.solr.internal.job.IndexerJob.runInternal(IndexerJob.java:94) [xwiki-platform-search-solr-api-6.4.4.jar:na] at org.xwiki.job.internal.AbstractJob.runInContext(AbstractJob.java:209) [xwiki-commons-job-6.4.4.jar:na] at org.xwiki.job.internal.AbstractJob.run(AbstractJob.java:192) [xwiki-commons-job-6.4.4.jar:na] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_75] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_75] at java.lang.Thread.run(Thread.java:745) [na:1.7.0_75]
    via by Alain Najjar,
    • org.dspace.discovery.SearchServiceException: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "dspace-cris", database "dspace-cris", SSL off at org.dspace.discovery.SolrServiceImpl.search(SolrServiceImpl.java:2585) at org.dspace.app.cris.discovery.CrisSearchService.renewMetricsCache(CrisSearchService.java:1026) at org.dspace.app.cris.statistics.plugin.StatsPercentileIndicatorsPlugin.buildIndicator(StatsPercentileIndicatorsPlugin.java:95) at org.dspace.app.cris.batch.ScriptStatsMetrics.main(ScriptStatsMetrics.java:134) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:226) at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:78) Caused by: org.apache.solr.client.solrj.impl.HttpSolrServer$RemoteSolrException: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "dspace-cris", database "dspace-cris", SSL off at org.apache.solr.client.solrj.impl.HttpSolrServer.executeMethod(HttpSolrServer.java:552) at org.apache.solr.client.solrj.impl.HttpSolrServer.request(HttpSolrServer.java:210) at org.apache.solr.client.solrj.impl.HttpSolrServer.request(HttpSolrServer.java:206) at org.apache.solr.client.solrj.request.QueryRequest.process(QueryRequest.java:91) at org.apache.solr.client.solrj.SolrServer.query(SolrServer.java:301) at org.dspace.discovery.SolrServiceImpl.search(SolrServiceImpl.java:2580) ... 9 more

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    4 more bugmates