CMDBuild Forum

Installing CMDBuild v3 && creating default user

Systems Engineering
#1

Hi

 

I managed to install CMDBuild v3 on CentOS 7 using "java -jar cmdbuild.war install", but there is no default user created in the DB.

 

I found some SQL commands on this forum, but they're for earlier versions of CMDBuild and thus do not work.

 

What is the right way to do it ?

 

 

Thank you, Pierre Danel

#2

Ok, I managed to create the user, modifying an sql statement.

 
So I did this :
 
INSERT INTO "Role" ("Status","Code","User","IdClass","Type","Description") VALUES ('A','SuperUser','system','"Role"','admin','SuperUser');
 
INSERT INTO "User" ("Status", "User","Username", "IdClass", "Password", "Description") VALUES ('A', 'system','admin','"User"', 'DQdKW32Mlms=', 'Administrator');
 
 
INSERT INTO "Map_UserRole" ("Status","User","IdClass2","IdClass1","IdObj2","IdObj1","IdDomain") VALUES ('A','system','"Role"'::regclass,'"User"'::regclass,currval('class_seq'),currval('class_seq')-2,'"Map_UserRole"'::regclass);
 
 
Now when I type admin/admin as credentials, it seems to go forward, but only lets me choose to login (again) or change user.
 
In the logs, I have this : 
 
2019-04-16 14:55:23.423 [req:fz7wnv] WARN  o.c.w.RequestTrackingFilter$$EnhancerBySpringCGLIB$$dba62620 - processed request, returned error for requestId = fz
2019-04-16 14:55:25.561 [req:1b32a5] ERROR o.c.s.r.v.p.ExceptionHandlerService - ws processing error
java.lang.IllegalArgumentException: 'group' param cannot be null
        at com.google.common.base.Preconditions.checkArgument(Preconditions.java:135) ~[guava-23.0.jar:na]
        at org.cmdbuild.service.rest.v3.endpoint.SessionsWs.update(SessionsWs.java:212) ~[cmdbuild-services-rest-v3-3.0-SNAPSHOT.jar:na]
        at org.cmdbuild.service.rest.v3.endpoint.SessionsWs$$FastClassBySpringCGLIB$$300ff872.invoke(<generated>) ~[cmdbuild-services-rest-v3-3.0-SNAPSHOT.jar
        at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) ~[spring-core-4.3.4.RELEASE.jar:4.3.4.RELEASE]
        at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:651) ~[spring-aop-4.3.4.RELEASE.jar:4.3.4.RE
[....................]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_191]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_191]
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.5.34]
        at java.lang.Thread.run(Thread.java:748) [na:1.8.0_191]
2019-04-16 14:55:25.563 [req:1b32a5] WARN  o.c.w.RequestTrackingFilter$$EnhancerBySpringCGLIB$$dba62620 - processed request, returned error for requestId = 1bsqri1mhj
 
Why is this happening and how can I fix it ? 
#3
Take a closer look at the INSERT INTO "Map_UserRole", you inverted the values of idObj1 and idObj2
 
CMDBuild Team
 
 
Previously Pierre wrote:
Ok, I managed to create the user, modifying an sql statement.
 
So I did this :
 
INSERT INTO "Role" ("Status","Code","User","IdClass","Type","Description") VALUES ('A','SuperUser','system','"Role"','admin','SuperUser');
 
INSERT INTO "User" ("Status", "User","Username", "IdClass", "Password", "Description") VALUES ('A', 'system','admin','"User"', 'DQdKW32Mlms=', 'Administrator');
 
 
INSERT INTO "Map_UserRole" ("Status","User","IdClass2","IdClass1","IdObj2","IdObj1","IdDomain") VALUES ('A','system','"Role"'::regclass,'"User"'::regclass,currval('class_seq'),currval('class_seq')-2,'"Map_UserRole"'::regclass);
 
 
Now when I type admin/admin as credentials, it seems to go forward, but only lets me choose to login (again) or change user.
 
In the logs, I have this : 
 
2019-04-16 14:55:23.423 [req:fz7wnv] WARN  o.c.w.RequestTrackingFilter$$EnhancerBySpringCGLIB$$dba62620 - processed request, returned error for requestId = fz
2019-04-16 14:55:25.561 [req:1b32a5] ERROR o.c.s.r.v.p.ExceptionHandlerService - ws processing error
java.lang.IllegalArgumentException: 'group' param cannot be null
        at com.google.common.base.Preconditions.checkArgument(Preconditions.java:135) ~[guava-23.0.jar:na]
        at org.cmdbuild.service.rest.v3.endpoint.SessionsWs.update(SessionsWs.java:212) ~[cmdbuild-services-rest-v3-3.0-SNAPSHOT.jar:na]
        at org.cmdbuild.service.rest.v3.endpoint.SessionsWs$$FastClassBySpringCGLIB$$300ff872.invoke(<generated>) ~[cmdbuild-services-rest-v3-3.0-SNAPSHOT.jar
        at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) ~[spring-core-4.3.4.RELEASE.jar:4.3.4.RELEASE]
        at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:651) ~[spring-aop-4.3.4.RELEASE.jar:4.3.4.RE
[....................]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_191]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_191]
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.5.34]
        at java.lang.Thread.run(Thread.java:748) [na:1.8.0_191]
2019-04-16 14:55:25.563 [req:1b32a5] WARN  o.c.w.RequestTrackingFilter$$EnhancerBySpringCGLIB$$dba62620 - processed request, returned error for requestId = 1bsqri1mhj
 
Why is this happening and how can I fix it ? 

 

#4
Nice catch, that fixed it, thanks !
 
Previously Tecnoteca wrote:
Take a closer look at the INSERT INTO "Map_UserRole", you inverted the values of idObj1 and idObj2
 
CMDBuild Team
 
#5

I suggest you take a look here: http://www.cmdbuild.org/en/documentazione/manuali/technical-manual

The manual is still incomplete but there are indications for installation.
CMDBuild Team
#6

HI,pierre 

I have installed cmdb3.0 by cmdbuild3.0.sh but it's not work,and http 404 appeared. then i installed by war also is not work, can you give me a installation of cmdb3.0.
thanks