CMDBuild Forum

Cannot create an empty database

Old Versions
#1

I am unable to get the cmdbuild GUI installer to create en empty database. Every time I try, upon clicking "Finish" in the configuration screen, I get an error message saying:

An error has occurred
Show details

The details are:

Call: services/json/configure/apply
------------------------------------
Error: java.lang.IllegalArgumentException: invalid value 'nPfRJ3Amkqd6ZC4yAXF9yMKe5QZn40x6d/+Ruyr90Us='
    at org.cmdbuild.dao.entrytype.attributetype.AbstractAttributeType.illegalValue(AbstractAttributeType.java:23)
    at org.cmdbuild.dao.entrytype.attributetype.AbstractTextAttributeType.convertNotNullValue(AbstractTextAttributeType.java:17)
    at org.cmdbuild.dao.entrytype.attributetype.AbstractTextAttributeType.convertNotNullValue(AbstractTextAttributeType.java:5)
    at org.cmdbuild.dao.entrytype.attributetype.AbstractAttributeType.convertValue(AbstractAttributeType.java:17)
    at org.cmdbuild.dao.entry.DBEntry.toNative(DBEntry.java:136)
    at org.cmdbuild.dao.entry.DBEntry.setOnly(DBEntry.java:131)
    at org.cmdbuild.dao.entry.DBCard.set(DBCard.java:20)
    at org.cmdbuild.dao.entry.DBCard.set(DBCard.java:9)
    at org.cmdbuild.dao.entry.ForwardingCardDefinition.set(ForwardingCardDefinition.java:23)
    at org.cmdbuild.auth.DefaultAuthenticationService.createUser(DefaultAuthenticationService.java:283)
    at org.cmdbuild.logic.auth.DefaultAuthenticationLogic.createUser(DefaultAuthenticationLogic.java:349)
    at org.cmdbuild.logic.auth.ForwardingAuthenticationLogic.createUser(ForwardingAuthenticationLogic.java:73)
    at org.cmdbuild.logic.auth.ForwardingAuthenticationLogic.createUser(ForwardingAuthenticationLogic.java:73)
    at org.cmdbuild.servlets.json.Configure.apply(Configure.java:178)
    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:646)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
    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:220)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
    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)

I got the same results with the following software combinationsall with PostgreSQL:

  • cmdbuild 2.4.3 (zip from sf.net), tomcat 8.5.14-1~bpo8+1 (debian), OpenJDK 8u131-b11-1~bpo8+1 (debian package openjdk-8-jre-headless)
  • cmdbuild 2.4.3 (zip from sf.net), tomcat 8.0.14-1+deb8u10 (debian), OpenJDK 8u131-b11-1~bpo8+1 (debian package openjdk-8-jre-headless)
  • cmdbuild 2.4.3 (zip from sf.net), tomcat 8.0.14-1+deb8u10 (debian), Oracle Java JRE 8u144 (installed using debian java-package)
  • cmdbuild 2.4.3 (zip from sf.net), tomcat 8.0.46 (apache.org), Oracle Java JRE 8u144 (installed using debian java-package)
  • cmdbuild 2.4.3 (zip from sf.net), tomcat 7.0.56-3+deb8u11 (debian), Oracle Java JRE 8u144 (installed using debian java-package)
  • cmdbuild 2.4.2 (zip from sf.net), tomcat 8.0.14-1+deb8u10 (debian), Oracle Java JRE 8u144 (installed using debian java-package)
In all cases, the following was common:
  • Debian jessie 8.9
  • PostgreSQL 9.4.13-0+deb8u1
Creating a demo database worked (tested using the first configuration above only), but creating an empty database always results in the error above.
 
Configuration settings:
  • CMDBuild database type: Empty
  • CMDBuild database name: cmdbuild
  • Create a Shark schema: yes
  • Database connection (PostgreSQL 9.4.1207):
    • Host: localhost
    • Port: 5432
    • Superuser: cmdbuild_setup (custom superuser)
    • Password: ***
    • Test connection succeeds
  • User type: Super user (also tried restricted user - same results)
 
Please let me know if any additional information is required.
#2
Dear Ahmad,
It seems that there's something strange with the password that you try to use.
Could you try a shortest password?
Best regards
#3
Thank you! Using a shorter password did fix the problem!
 
What's the longest supported password length? and is that documented?
I wish CMDBuild would be able to support arbitrarily long passwords in the future.
 
Previously Tecnoteca wrote:
Dear Ahmad,
It seems that there's something strange with the password that you try to use.
Could you try a shortest password?
Best regards

 

#4

The maximum length is 40 characters after encryption.
CMDBuild Team