CMDBuild Forum

Database connectivity issue during install with error ORM_DATABASE_CONNECTION_ERROR

Old Versions
#1

Good afternoon,

I can't install CMDBUILD 2.5.1 because connectivity with database doesn't seem to work properly. I encounter an error message when trying to test database connection with graphical installation on step 2:

"Database connection error, try to reset the connection parameters"

Error details:

Call: services/json/configure/testconnection

---------------------------------------------

Error: org.cmdbuild.exception.ORMException: ORM_DATABASE_CONNECTION_ERROR

at org.cmdbuild.exception.ORMException$ORMExceptionType.createException(ORMException.java:63)

at org.cmdbuild.servlets.json.Configure.testDatabaseConnection(Configure.java:74)

at org.cmdbuild.servlets.json.Configure.testConnection(Configure.java:58)

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.cmdbuild.servlets.JSONDispatcher.dispatch(JSONDispatcher.java:106)

at org.cmdbuild.servlets.JSONDispatcher.doPost(JSONDispatcher.java:64)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)    

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.cmdbuild.filters.AuthFilter.doFilter(AuthFilter.java:183)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.cmdbuild.filters.PatchManagerFilter.doFilter(PatchManagerFilter.java:48)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.cmdbuild.filters.TranslationFilter.doFilter(TranslationFilter.java:52)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.cmdbuild.filters.LocalizationFilter.doFilter(LocalizationFilter.java:127)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.cmdbuild.filters.RequestLogFilter.doFilterInternal(RequestLogFilter.java:74)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1087)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:748)

Current configuration details

  • Operating System: CentOS Linux release 7.5.1804 (64-bit)
  • Kernel: 3.10.0-862.2.3.el7.x86_64 
  • PostgreSQL: 10.4
  • postgresql-10 systemd service is up and running
  • postgres Linux user is configured
  • Tomcat: 7.0.76
  • tomcat systemd service is up and running
  • JVM: 1.8.0_172-b11
  • CMDBUILD: 2.5.1

Installation sources

  • postgresql-9.4.1207.jar has been copied to /usr/share/tomcat/lib/
  • cmdbuild-2.5.1.war has been copied to /var/lib/tomcat/webapps/
  • postgresql-9.4.1207.jar has been copied to /usr/share/tomcat/lib/
  • cmdbuild-shark-server-2.5.1.war has been copied to /var/lib/tomcat/webapps/
  • All *jar files for additional-report-libs-1.5 have been copied to /usr/share/tomcat/lib/
Thanks in advance for your help
#2

CMDBuild is certified with Postgres 9.x but we did some tests with Postgres 10 and we did not find any problems.
Could you send us (tecnoteca@tecnoteca.com) the complete Tomcat logs?

Are the authentication data correct? Have you tried to log in with the same account from the pgAdmin client?
CMDBuild Team
#3

Hi,

 
I've received your logs, and I've found this line:
 
> INFO  2018-05-22 12:59:35 [cmdbuild] Test connection failed: FATAL: authentification Ident échouée pour l'utilisateur « postgres »
 
which seems to indicate an authentication problem (likely the password is incorrect, or password authentication is not enabled for your database). You could verify this by using a pg client such as PgAdmin and try to authenticate to the same db with username and password.
 
Regards,
CMDBuild Team
#4
Hi,
 
 I've reconfigured authentication method for PostgreSQL, editing configuration file :
 
/var/lib/pgsql/10/data/pg_hba.conf
 
# TYPE  DATABASE        USER            ADDRESS                 METHOD
host      all                    all                127.0.0.1/32            md5 # Method value was previously: ident
host      all                    all                 ::1/128                    md5 # Method value was previously: ident
 
Then restarted PostgreSQL service:
 
systemctl restart postgresql-10
 
Now installation Wizard seem to work properly with cmdbuild 2.5.1.
 
Thanks for this.
 
Previously Tecnoteca wrote:
Hi,
 
I've received your logs, and I've found this line:
 
> INFO  2018-05-22 12:59:35 [cmdbuild] Test connection failed: FATAL: authentification Ident échouée pour l'utilisateur « postgres »
 
which seems to indicate an authentication problem (likely the password is incorrect, or password authentication is not enabled for your database). You could verify this by using a pg client such as PgAdmin and try to authenticate to the same db with username and password.
 
Regards,
CMDBuild Team