Re: can't login the cmdbuild.

kevin.pan · July 5, 2013, 8:45am

Hi, Brots

I have built a "cmdbuild" server, but i can't login the cmdbuild system.

It need me to shoose default group when I have typed my account and password.

The textbox of the default group is null.

How to solve it?

Thanks!

The logs of "cmdbuild.log":

INFO 2013-07-05 13:52:53 [cmdbuild] Redirecting to index.jsp
INFO 2013-07-05 13:53:12 [jsonrpc ] Calling url /login/login
INFO 2013-07-05 13:53:12 [cmdbuild] Trying to login user admin with group null
ERROR 2013-07-05 13:53:12 [cmdbuild] The user does not have a default group and belongs to multiple groups
INFO 2013-07-05 16:40:28 [cmdbuild] loading configurations
INFO 2013-07-05 16:40:50 [cmdbuild] Initializing ParameterTransformers
INFO 2013-07-05 16:40:50 [cmdbuild] Transformer for org.apache.commons.fileupload.FileItem: org.cmdbuild.servlets.utils.transformer.FileItemTransformer
INFO 2013-07-05 16:40:50 [cmdbuild] Transformer for org.json.JSONObject: org.cmdbuild.servlets.utils.transformer.JSONObjectTransformer
INFO 2013-07-05 16:40:50 [cmdbuild] Transformer for org.json.JSONArray: org.cmdbuild.servlets.utils.transformer.JSONArrayTransformer
INFO 2013-07-05 16:40:50 [cmdbuild] Initializer custom ParameterBuilders
INFO 2013-07-05 16:40:50 [cmdbuild] Loading scheduled jobs

kevin.pan · July 5, 2013, 3:19pm

Previously kevin wrote:

Hi, Brots

I have built a "cmdbuild" server, but i can't login the cmdbuild system.

It need me to shoose default group when I have typed my account and password.

The textbox of the default group is null.

How to solve it?

Thanks!

The logs of "cmdbuild.log":

INFO 2013-07-05 13:52:53 [cmdbuild] Redirecting to index.jsp
INFO 2013-07-05 13:53:12 [jsonrpc ] Calling url /login/login
INFO 2013-07-05 13:53:12 [cmdbuild] Trying to login user admin with group null
ERROR 2013-07-05 13:53:12 [cmdbuild] The user does not have a default group and belongs to multiple groups
INFO 2013-07-05 16:40:28 [cmdbuild] loading configurations
INFO 2013-07-05 16:40:50 [cmdbuild] Initializing ParameterTransformers
INFO 2013-07-05 16:40:50 [cmdbuild] Transformer for org.apache.commons.fileupload.FileItem: org.cmdbuild.servlets.utils.transformer.FileItemTransformer
INFO 2013-07-05 16:40:50 [cmdbuild] Transformer for org.json.JSONObject: org.cmdbuild.servlets.utils.transformer.JSONObjectTransformer
INFO 2013-07-05 16:40:50 [cmdbuild] Transformer for org.json.JSONArray: org.cmdbuild.servlets.utils.transformer.JSONArrayTransformer
INFO 2013-07-05 16:40:50 [cmdbuild] Initializer custom ParameterBuilders
INFO 2013-07-05 16:40:50 [cmdbuild] Loading scheduled jobs

The version of "cmdbuild" is 2.1.3.1。

And the version of Ubuntu is Linux CMDBUILDSERVER 3.5.0-34-generic #55~precise1-Ubuntu SMP Fri Jun 7 16:25:50 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux

The version of tomcat is 6.0

tecnoteca · July 8, 2013, 7:14am

Hi,

assuming you have created your own user, and that you have not used the "admin" of the demo database, it's seems that your user has no group associated.

Which database are you using? Did you have created a user? When you installed CMDBuild or when CMDBuild was already installed?

kevin.pan · July 9, 2013, 2:10pm

Previously Tecnoteca wrote:

Hi,
assuming you have created your own user, and that you have not used the "admin" of the demo database, it's seems that your user has no group associated.

Which database are you using? Did you have created a user? When you installed CMDBuild or when CMDBuild was already installed?

I have downloaded "cmdbuild-2.1.3.1" and installed it into a ubuntu

server.

And i am using "base_schema" and manually install the database "cmdbuild" according to the "Technical Manual

", which downloaded in the URL:

http://www.cmdbuild.org/en/download.

I have found that there are some wrong in the "Technical Manual

" . Because the issue cased by the sql statement.

In the "Technical Manual", the sql statement for creating

a super user at below:

INSERT INTO "User" ("Status", "Username", "IdClass", "Password", "Description") VALUES ('A', 'admin',

'"User"', 'DQdKW32Mlms=', 'Administrator');

INSERT INTO "Role" ("Status", "IdClass", "Administrator", "Description") VALUES ('A', '"Role"', true,

'SuperUser');

INSERT INTO "Map_UserRole" ("Status", "IdClass2", "IdClass1", "IdObj2", "IdObj1", "IdDomain") VALUES ('A',

'"Role"'::regclass,'"User"'::regclass, currval('class_seq'), currval('class_seq')-1, '"Map_UserRole"'::regclass);

but i can't use the super user "admin"

created by me.

it prompted like "not associated default group" err in the cmdbuild.log.

Finally，i have used the sql statement at below to create the super user, now i can login into the server.

INSERT INTO "User" ("Status", "User","Username", "IdClass", "Password", "Description") VALUES ('A', 'system','admin',

'"User"', 'DQdKW32Mlms=', 'Administrator');

INSERT INTO "Role" ("Status","Code","User", "IdClass", "Administrator", "Description") VALUES ('A','SuperUser','system', '"Role"', true,

'SuperUser');

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);

Thank for your feedback.

kevin.pan · July 9, 2013, 2:29pm

Now i have created the “shark” server according to "Technical Manual

" , but i encountered some issue.

Please see the configuration and cmdbuild.log at below.

And can you give me the correct setup to build the "shark" server?

Thanks!

auth.conf:

auth.methods=DBAuthenticator

#serviceusers=portlet

serviceusers.privileged=workflow

#force.ws.password.digest=true

##

## HEADER

##

context.xml:

<?xml version="1.0" encoding="UTF-8"?>

<Resource

auth="Container"

name="UserTransaction"

type="javax.transaction.UserTransaction"

jotm.timeout="180"

factory="org.objectweb.jotm.UserTransactionFactory"/>

<Resource

name="sharkdb"

type="javax.sql.DataSource"

driverClassName="org.postgresql.Driver"

url="jdbc:postgresql://192.168.225.130/cmdbuild-2.1.3.1"

username="shark"

password="shark"

maxIdle="10"

maxActive="300"

maxWait="5000"

factory="org.enhydra.jndi.DataSourceFactory"/>

</Context>

Shark.conf

#=============================================================================

# CMDBuild Custom Components Settings

#-----------------------------------------------------------------------------

# you should change these settings

# CMDBuild connection settings

org.cmdbuild.ws.url=http://192.168.225.130:8080/cmdbuild-2.1.3.1/

org.cmdbuild.ws.username=workflow

org.cmdbuild.ws.password=workflow

cmdbuild.log:

WARN 2013-07-09 22:24:29 [cmdbuild] lookup type not found

...

ERROR 2013-07-09 22:24:48 [jsonrpc ] A org.cmdbuild.workflow.CMWorkflowException occurred calling method class org.cmdbuild.servlets.json.Workflow.xpdlVersions: (404)Not Found

tecnoteca · July 9, 2013, 3:26pm

Thanks,

in fact the code is mandatory. We are sorry for the wrong query, we will fix the manual in the next release.

About shark: could you post the shark.log and the catalina.out?

kevin.pan · July 10, 2013, 3:20pm

Sorry, there isn't shark.log in the server , only catalina.out.

Why there isn't shark.log in "/var/log/tomcat6/"

catalina.out:

....................

at java.io.FileOutputStream.open(Native Method)

at java.io.FileOutputStream.<init>(FileOutputStream.java:209)

at java.io.FileOutputStream.<init>(FileOutputStream.java:131)

at org.apache.log4j.FileAppender.setFile(FileAppender.java:294)

at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:165)

at org.apache.log4j.DailyRollingFileAppender.activateOptions(DailyRollingFileAppender.java:223)

at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:307)

at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:172)

at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:104)

at org.apache.log4j.PropertyConfigurator.parseAppender(PropertyConfigurator.java:809)

at org.apache.log4j.PropertyConfigurator.parseCategory(PropertyConfigurator.java:735)

at org.apache.log4j.PropertyConfigurator.configureRootCategory(PropertyConfigurator.java:615)

at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:502)

at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:547)

at org.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionConverter.java:483)

at org.apache.log4j.LogManager.<clinit>(LogManager.java:127)

at org.slf4j.impl.Log4jLoggerFactory.getLogger(Log4jLoggerFactory.java:64)

at org.slf4j.LoggerFactory.getLogger(LoggerFactory.java:253)

at org.cmdbuild.dao.logging.LoggingSupport.<clinit>(LoggingSupport.java:8)

at org.cmdbuild.logger.Log.<clinit>(Log.java:12)

at org.cmdbuild.plugins.ConfigurationListener.<clinit>(ConfigurationListener.java:15)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:532)

at java.lang.Class.newInstance0(Class.java:374)

at java.lang.Class.newInstance(Class.java:327)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4150)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)

at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)

at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)

at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)

at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)

at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)

at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)

at org.apache.catalina.core.StandardService.start(StandardService.java:525)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)

at org.apache.catalina.startup.Catalina.start(Catalina.java:595)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:616)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

log4j:ERROR Either File or DatePattern options are not set for appender [File].

log4j: Parsing for [root] with value=[WARN, R].

..................

cmdbuild.log:

................

INFO 2013-07-10 14:18:54 [jsonrpc ] Calling url /login/login

INFO 2013-07-10 14:18:54 [cmdbuild] Trying to login user admin with group null

INFO 2013-07-10 14:18:54 [jsonrpc ] Calling url /utils/gettranslationobject

INFO 2013-07-10 14:18:59 [jsonrpc ] Calling url /schema/modsecurity/getuiconfiguration

INFO 2013-07-10 14:18:59 [jsonrpc ] Calling url /schema/setup/getconfiguration

INFO 2013-07-10 14:18:59 [jsonrpc ] Calling url /gis/getgistreenavigation

INFO 2013-07-10 14:19:00 [jsonrpc ] Calling url /attachments/getattachmentscontext

INFO 2013-07-10 14:19:00 [jsonrpc ] Calling url /schema/modclass/getallclasses

INFO 2013-07-10 14:19:00 [jsonrpc ] Calling url /schema/setup/getconfiguration

INFO 2013-07-10 14:19:00 [jsonrpc ] Calling url /management/modreport/getreporttypestree

INFO 2013-07-10 14:19:00 [jsonrpc ] Calling url /schema/modclass/getalldomains

INFO 2013-07-10 14:19:00 [cmdbuild] creating new dms logic...

INFO 2013-07-10 14:19:00 [workflow] getting all active process classes

INFO 2013-07-10 14:19:00 [workflow] getting all process classes

ERROR 2013-07-10 14:19:00 [jsonrpc ] A org.alfresco.webservice.util.WebServiceException occurred calling method class org.cmdbuild.servlets.json.Attachments.getAttachmentsContext: Error starting session.

INFO 2013-07-10 14:19:00 [cmdbuild] creating new dms logic...

INFO 2013-07-10 14:19:00 [cmdbuild] getting lookup type for predicate

INFO 2013-07-10 14:19:00 [cmdbuild] getting all lookup types

WARN 2013-07-10 14:19:00 [cmdbuild] lookup type successfully found

INFO 2013-07-10 14:19:00 [cmdbuild] getting lookup type for predicate

INFO 2013-07-10 14:19:00 [cmdbuild] getting all lookup types

WARN 2013-07-10 14:19:00 [cmdbuild] lookup type not found

INFO 2013-07-10 14:19:00 [cmdbuild] creating new dms logic...

INFO 2013-07-10 14:19:00 [cmdbuild] getting lookup type for predicate

INFO 2013-07-10 14:19:00 [cmdbuild] getting all lookup types

WARN 2013-07-10 14:19:00 [cmdbuild] lookup type successfully found

INFO 2013-07-10 14:19:00 [cmdbuild] getting lookup type for predicate

INFO 2013-07-10 14:19:00 [cmdbuild] getting all lookup types

WARN 2013-07-10 14:19:00 [cmdbuild] lookup type not found

INFO 2013-07-10 14:19:00 [jsonrpc ] Calling url /dashboard/fulllist

INFO 2013-07-10 14:19:00 [cmdbuild] creating new dms logic...

INFO 2013-07-10 14:19:00 [jsonrpc ] Calling url /schema/modlookup/tree

INFO 2013-07-10 14:19:00 [cmdbuild] getting all lookup types

INFO 2013-07-10 14:19:00 [cmdbuild] creating new dms logic...

INFO 2013-07-10 14:19:00 [workflow] getting all process classes

INFO 2013-07-10 14:19:14 [cmdbuild] trying to login with no username or password

INFO 2013-07-10 14:19:15 [jsonrpc ] Calling url /utils/gettranslationobject

INFO 2013-07-10 14:19:23 [jsonrpc ] Calling url /schema/setup/getconfiguration

INFO 2013-07-10 14:19:23 [jsonrpc ] Calling url /utils/listavailabletranslations

INFO 2013-07-10 14:19:30 [jsonrpc ] Calling url /dashboard/getchartdata

INFO 2013-07-10 14:19:55 [jsonrpc ] Calling url /login/login

............