CMDBuild Forum

CMDBuild configuration error

Configurations
#1

Hi,
I’ve installed CMDBuild as reported here: CentOS7 installation Cmdbuild

On the second step of configuration, when setting DB parameters, I set:
Type: Empty
Name: cmdbuild

Host: localhost
Port: 5432
Super user: cmdbadmin
Password: password

When clicking on Test connection, the error “Database connection error, try to reset the connection parameters” returns.

Clicking on Show details, I have:

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:104)
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.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:1115)
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:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)

I’m not expert in Tomcat and Postgres, can anybody help me please

#2

After this change the problem is fixed:
Set postgresql set pg_hba.conf
vim /var/lib/pgsql/9.6/data/pg_hba.conf

“local” is for Unix domain socket connections only

local all all md5

IPv4 local connections:

host all all 127.0.0.1/32 md5

But on the next step, when I try to set Username and Password I have the following error: Error occourred while loading/saving data

In show details I have this:
Call: services/json/configure/apply
------------------------------------
Error: org.cmdbuild.exception.ORMException: ORM_GENERIC_ERROR

  • at org.cmdbuild.exception.ORMException$ORMExceptionType.createException(ORMException.java:63)*
  • at org.cmdbuild.services.database.DatabaseConfigurator.configure(DatabaseConfigurator.java:169)*
  • at org.cmdbuild.services.database.DatabaseConfigurator.configureAndSaveSettings(DatabaseConfigurator.java:147)*
  • at org.cmdbuild.servlets.json.Configure.apply(Configure.java:164)*
  • 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:104)*
  • 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.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:1115)*
  • 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:1142)*
  • at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)*
  • at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)*
  • at java.lang.Thread.run(Thread.java:748)*

How to finish the configuration process???