demo_schema login does not work

lars.syfuß · October 12, 2013, 9:26am

Hey! When I setup the cmdbuild with the help of the manual (http://www.cmdbuild.org/file/manuali/technical-manual-in-english) page 12-14 the login works without problems. After running {CMDBUILD}/WEB-INF/sql/base_schema (page 15) and the user creation (page 16) the login does not work.

The log file says:

INFO 2013-10-12 11:11:48 [jsonrpc ] Calling url /login/login

INFO 2013-10-12 11:11:48 [cmdbuild] Trying to login user admin with group null

ERROR 2013-10-12 11:11:48 [cmdbuild] Login failed

ERROR 2013-10-12 11:11:48 [jsonrpc ] A org.cmdbuild.exception.AuthException occurred calling method class org.cmdbuild.servlets.json.Login.login: AUTH_LOGIN_WRONG

INFO 2013-10-12 11:11:54 [jsonrpc ] Calling url /login/login

INFO 2013-10-12 11:11:54 [cmdbuild] Trying to login user admin with group null

INFO 2013-10-12 11:11:54 [cmdbuild] trying to login with no username or password

INFO 2013-10-12 11:11:54 [cmdbuild] Redirecting to index.jsp

INFO 2013-10-12 11:11:54 [cmdbuild] trying to login with no username or password

INFO 2013-10-12 11:11:55 [jsonrpc ] Calling url /utils/gettranslationobject

INFO 2013-10-12 11:11:55 [jsonrpc ] Calling url /schema/setup/getconfiguration

INFO 2013-10-12 11:11:55 [jsonrpc ] Calling url /utils/listavailabletranslations

INFO 2013-10-12 11:12:16 [jsonrpc ] Calling url /login/login

INFO 2013-10-12 11:12:16 [cmdbuild] Trying to login user admin with group null

INFO 2013-10-12 11:12:16 [cmdbuild] trying to login with no username or password

INFO 2013-10-12 11:12:16 [cmdbuild] Redirecting to index.jsp

INFO 2013-10-12 11:12:16 [cmdbuild] trying to login with no username or password

INFO 2013-10-12 11:12:16 [jsonrpc ] Calling url /utils/gettranslationobject

INFO 2013-10-12 11:12:17 [jsonrpc ] Calling url /schema/setup/getconfiguration

INFO 2013-10-12 11:12:17 [jsonrpc ] Calling url /utils/listavailabletranslations

Any ideas?

Kind regards

tecnoteca · October 12, 2013, 9:46am

Hi, it seems there is an error in the Technical Manual.

Can you try to run these SQL commands, to create the CMDBuild user, instead of those specified in the manual ?

INSERT INTO "User" ("Status", "Username", "IdClass", "Password", "Description")

VALUES ('A', 'admin', '"User"', 'DQdKW32Mlms=', 'Administrator');

INSERT INTO "Role" ("Status", "IdClass", "Administrator", "Code", "Description")

VALUES ('A', '"Role"', true, 'SuperUser', 'SuperUser');

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

VALUES ('A', '"User"'::regclass,'"Role"'::regclass, currval('class_seq')-2, currval('class_seq'), '"Map_UserRole"'::regclass);

CMDBuild Team

lars.syfuß · October 15, 2013, 8:11am

The user admin exists and cannot created again. So I renamed it to admin1. The query executes but I can not login with that user. The error seems to be the same:

INFO 2013-10-14 12:45:08 [jsonrpc ] Calling url /login/login

INFO 2013-10-14 12:45:08 [cmdbuild] Trying to login user admin with group null

INFO 2013-10-14 12:45:08 [cmdbuild] trying to login with no username or password

INFO 2013-10-14 12:45:08 [cmdbuild] Redirecting to index.jsp

INFO 2013-10-14 12:45:08 [cmdbuild] trying to login with no username or password

INFO 2013-10-14 12:45:09 [jsonrpc ] Calling url /utils/gettranslationobject

INFO 2013-10-14 12:45:09 [jsonrpc ] Calling url /schema/setup/getconfiguration

INFO 2013-10-14 12:45:09 [jsonrpc ] Calling url /utils/listavailabletranslations

INFO 2013-10-14 12:45:12 [jsonrpc ] Calling url /login/login

INFO 2013-10-14 12:45:12 [cmdbuild] Trying to login user admin1 with group null

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

INFO 2013-10-14 12:45:12 [cmdbuild] Redirecting to index.jsp

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

INFO 2013-10-14 12:45:13 [jsonrpc ] Calling url /utils/gettranslationobject

INFO 2013-10-14 12:45:13 [jsonrpc ] Calling url /schema/setup/getconfiguration

INFO 2013-10-14 12:45:13 [jsonrpc ] Calling url /utils/listavailabletranslations

tecnoteca · October 15, 2013, 8:29pm

We suggest that you restart from a clean installation.
With queries that we have posted it should work.

CMDBuild Team

lars.syfuß · October 21, 2013, 3:03pm

Previously Tecnoteca wrote:

We suggest that you restart from a clean installation.
With queries that we have posted it should work.

CMDBuild Team

Previously Tecnoteca wrote:

We suggest that you restart from a clean installation.

With queries that we have posted it should work.

CMDBuild Team

I solved that issue by not creating an empty CMDBuild Database. I executed the demo_schema first and then connected to that existing database. Now when I log in I see a list of available patches (but cannot skip this):

2.1.4-01

2.1.4-02 and

2.1.4-03

Clicking "apply" does not work. The log says:

CREATE OR REPLACE FUNCTION patch_212_04() RETURNS VOID AS $$

BEGIN

RAISE INFO 'creating _EmailTemplate table';

PERFORM cm_create_class('_EmailTemplate', NULL, 'MODE: reserved|TYPE: class|DESCR: Email Templates|SUPERCLASS: false|STATUS: active');

PERFORM cm_create_class_attribute('_EmailTemplate', 'Owner', 'regclass', null, false, false, 'MODE: write|DESCR: Class owner|INDEX: 1|STATUS: active');

PERFORM cm_create_class_attribute('_EmailTemplate', 'From', 'text', null, false, false, 'MODE: write|DESCR: From|INDEX: 2|STATUS: active');

PERFORM cm_create_class_attribute('_EmailTemplate', 'To', 'text', null, false, false, 'MODE: write|DESCR: To|INDEX: 3|STATUS: active');

PERFORM cm_create_class_attribute('_EmailTemplate', 'CC', 'text', null, false, false, 'MODE: write|DESCR: CC|INDEX: 4|STATUS: active');

PERFORM cm_create_class_attribute('_EmailTemplate', 'BCC', 'text', null, false, false, 'MODE: write|DESCR: BCC|INDEX: 5|STATUS: active');

PERFORM cm_create_class_attribute('_EmailTemplate', 'Subject', 'text', null, false, false, 'MODE: write|DESCR: Subject|INDEX: 6|STATUS: active');

PERFORM cm_create_class_attribute('_EmailTemplate', 'Body', 'text', null, false, false, 'MODE: write|DESCR: Body|INDEX: 7|STATUS: active');

PERFORM _cm_attribute_set_uniqueness('"_EmailTemplate"'::regclass::oid, 'Code', TRUE);

END

$$ LANGUAGE PLPGSQL;

SELECT patch_212_04();

DROP FUNCTION patch_212_04();]; FEHLER: Anfrageargument von EXECUTE ist NULL

Wobei: PL/pgSQL-Funktion cm_create_class(text,oid,text) Zeile 28 bei EXECUTE-Anweisung

SQL-Anweisung „SELECT cm_create_class('_EmailTemplate', NULL, 'MODE: reserved|TYPE: class|DESCR: Email Templates|SUPERCLASS: false|STATUS: active')“

PL/pgSQL-Funktion patch_212_04() Zeile 6 bei PERFORM; nested exception is org.postgresql.util.PSQLException: FEHLER: Anfrageargument von EXECUTE ist NULL

Wobei: PL/pgSQL-Funktion cm_create_class(text,oid,text) Zeile 28 bei EXECUTE-Anweisung

SQL-Anweisung „SELECT cm_create_class('_EmailTemplate', NULL, 'MODE: reserved|TYPE: class|DESCR: Email Templates|SUPERCLASS: false|STATUS: active')“

PL/pgSQL-Funktion patch_212_04() Zeile 6 bei PERFORM

at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:427)

at org.cmdbuild.services.DefaultPatchManager$2.doInTransactionWithoutResult(DefaultPatchManager.java:255)

at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33)

at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)

at org.cmdbuild.services.DefaultPatchManager.applyPatch(DefaultPatchManager.java:250)

at org.cmdbuild.services.DefaultPatchManager.applyPatchList(DefaultPatchManager.java:239)

at org.cmdbuild.servlets.json.Configure.applyPatches(Configure.java:176)

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

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.cmdbuild.servlets.JSONDispatcher.dispatch(JSONDispatcher.java:94)

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

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

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

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