CMDBuild Forum

cmdbuild 2.4 new installation - authentication failure. jsonrpc A java.lang.NoClassDefFoundError

Old Versions
#1

Hi,

This is a new installation on centos 7. I completed a basic installation of postgres and tomcat, and used the GUI installation wizard.

The installation completes, however I cant authenticate to the demo cmdbuild instance from the browser.

/var/log/tomcat/cmdbuild.log

INFO  2016-05-19 11:04:58 [jsonrpc ] Calling url /login/login

INFO  2016-05-19 11:04:58 [cmdbuild] trying to login user admin with group null

ERROR 2016-05-19 11:04:58 [jsonrpc ] A java.lang.NoClassDefFoundError occurred calling method class org.cmdbuild.servlets.json.Login.login: org/postgresql/jdbc/PgArray

[root@cmdbuild lib]# pwd

/usr/share/tomcat/lib

 

[root@cmdbuild lib]# ls -alh

total 4.7M

drwxr-xr-x. 2 root root 4.0K May 19 09:19 .

drwxr-xr-x. 4 root root 4.0K May 19 09:03 ..

-rw-r--r--. 1 root root  18K May 13  2015 annotations-api.jar

-rw-r--r--. 1 root root  53K May 13  2015 catalina-ant.jar

-rw-r--r--. 1 root root 132K May 13  2015 catalina-ha.jar

-rw-r--r--. 1 root root 1.6M May 13  2015 catalina.jar

-rw-r--r--. 1 root root 254K May 13  2015 catalina-tribes.jar

lrwxrwxrwx. 1 root root   46 May 19 09:03 commons-collections.jar -> /usr/share/java/apache-commons-collections.jar

lrwxrwxrwx. 1 root root   39 May 19 09:03 commons-dbcp.jar -> /usr/share/java/apache-commons-dbcp.jar

lrwxrwxrwx. 1 root root   39 May 19 09:03 commons-pool.jar -> /usr/share/java/apache-commons-pool.jar

-rw-r--r--. 1 root root 123K May 13  2015 jasper-el.jar

-rw-r--r--. 1 root root 590K May 13  2015 jasper.jar

lrwxrwxrwx. 1 root root   23 May 19 09:03 jasper-jdt.jar -> /usr/share/java/ecj.jar

lrwxrwxrwx. 1 root root   25 May 19 09:03 log4j.jar -> /usr/share/java/log4j.jar

-rw-r--r--. 1 root root 628K May 19 09:19 postgresql-9.4-1200.jdbc41.jar

-rw-r--r--. 1 root root 177K May 13  2015 tomcat7-websocket.jar

-rw-r--r--. 1 root root 7.1K May 13  2015 tomcat-api.jar

-rw-r--r--. 1 root root 815K May 13  2015 tomcat-coyote.jar

lrwxrwxrwx. 1 root root   24 May 19 09:02 tomcat-el-2.2-api.jar -> ../tomcat-el-2.2-api.jar

-rw-r--r--. 1 root root  76K May 13  2015 tomcat-i18n-es.jar

-rw-r--r--. 1 root root  48K May 13  2015 tomcat-i18n-fr.jar

-rw-r--r--. 1 root root  50K May 13  2015 tomcat-i18n-ja.jar

-rw-r--r--. 1 root root 123K May 13  2015 tomcat-jdbc.jar

lrwxrwxrwx. 1 root root   25 May 19 09:03 tomcat-jsp-2.2-api.jar -> ../tomcat-jsp-2.2-api.jar

lrwxrwxrwx. 1 root root   37 May 19 09:03 tomcat-juli.jar -> /usr/share/tomcat/bin/tomcat-juli.jar

lrwxrwxrwx. 1 root root   29 May 19 09:03 tomcat-servlet-3.0-api.jar -> ../tomcat-servlet-3.0-api.jar

-rw-r--r--. 1 root root  31K May 13  2015 tomcat-util.jar

-rw-r--r--. 1 root root  36K May 13  2015 websocket-api.jar

 

 

[root@cmdbuild ~]# cat /var/lib/pgsql/9.4/data/postgresql.conf | grep -v "^$" | grep -v "#"

listen_addresses = '*'

log_timezone = 'Australia/ACT'

datestyle = 'iso, dmy'

timezone = 'Australia/ACT'

default_text_search_config = 'pg_catalog.english'

 

[root@cmdbuild ~]# cat /usr/share/tomcat/webapps/cmdbuild/WEB-INF/conf/database.conf

 

#Thu May 19 10:28:36 AEST 2016

db.password=Equat0r.

db.url=jdbc\:postgresql\://192.168.1.101\:5432/demo

db.username=postgres

[root@cmdbuild ~]#

 

[root@cmdbuild ~]# cat /var/lib/pgsql/9.4/data/pg_hba.conf | grep -v '^$\|^#'

local   all             all                                     trust

host    all             all             127.0.0.1/32            trust

host    all             all             192.0.0.0/8             trust

host    all             all             10.0.0.0/8              trust

host    all             all             ::1/128                trust

 

[root@cmdbuild log]# find / -name cmdbuild.log

INFO  2016-05-19 11:04:58 [jsonrpc ] Calling url /login/login

INFO  2016-05-19 11:04:58 [cmdbuild] trying to login user admin with group null

ERROR 2016-05-19 11:04:58 [jsonrpc ] A java.lang.NoClassDefFoundError occurred calling method class org.cmdbuild.servlets.json.Login.login: org/postgresql/jdbc/PgArray

 

 

 

 

#2
Dear Paul,
 
you need a new version of PostgreSQL JDBC library, compatible with Java 8 (e.g. "postgresql-9.4.1207.jar").
 
Best regards.
 
-- CMDBuild Team
 
Previously Paul wrote:

Hi,

This is a new installation on centos 7. I completed a basic installation of postgres and tomcat, and used the GUI installation wizard.

The installation completes, however I cant authenticate to the demo cmdbuild instance from the browser.

/var/log/tomcat/cmdbuild.log

 

 

INFO  2016-05-19 11:04:58 [jsonrpc ] Calling url /login/login

INFO  2016-05-19 11:04:58 [cmdbuild] trying to login user admin with group null

ERROR 2016-05-19 11:04:58 [jsonrpc ] A java.lang.NoClassDefFoundError occurred calling method class org.cmdbuild.servlets.json.Login.login: org/postgresql/jdbc/PgArray

 

 

[root@cmdbuild lib]# pwd

/usr/share/tomcat/lib

 

[root@cmdbuild lib]# ls -alh

total 4.7M

drwxr-xr-x. 2 root root 4.0K May 19 09:19 .

drwxr-xr-x. 4 root root 4.0K May 19 09:03 ..

-rw-r--r--. 1 root root  18K May 13  2015 annotations-api.jar

-rw-r--r--. 1 root root  53K May 13  2015 catalina-ant.jar

-rw-r--r--. 1 root root 132K May 13  2015 catalina-ha.jar

-rw-r--r--. 1 root root 1.6M May 13  2015 catalina.jar

-rw-r--r--. 1 root root 254K May 13  2015 catalina-tribes.jar

lrwxrwxrwx. 1 root root   46 May 19 09:03 commons-collections.jar -> /usr/share/java/apache-commons-collections.jar

lrwxrwxrwx. 1 root root   39 May 19 09:03 commons-dbcp.jar -> /usr/share/java/apache-commons-dbcp.jar

lrwxrwxrwx. 1 root root   39 May 19 09:03 commons-pool.jar -> /usr/share/java/apache-commons-pool.jar

-rw-r--r--. 1 root root 123K May 13  2015 jasper-el.jar

-rw-r--r--. 1 root root 590K May 13  2015 jasper.jar

lrwxrwxrwx. 1 root root   23 May 19 09:03 jasper-jdt.jar -> /usr/share/java/ecj.jar

lrwxrwxrwx. 1 root root   25 May 19 09:03 log4j.jar -> /usr/share/java/log4j.jar

-rw-r--r--. 1 root root 628K May 19 09:19 postgresql-9.4-1200.jdbc41.jar

-rw-r--r--. 1 root root 177K May 13  2015 tomcat7-websocket.jar

-rw-r--r--. 1 root root 7.1K May 13  2015 tomcat-api.jar

-rw-r--r--. 1 root root 815K May 13  2015 tomcat-coyote.jar

lrwxrwxrwx. 1 root root   24 May 19 09:02 tomcat-el-2.2-api.jar -> ../tomcat-el-2.2-api.jar

-rw-r--r--. 1 root root  76K May 13  2015 tomcat-i18n-es.jar

-rw-r--r--. 1 root root  48K May 13  2015 tomcat-i18n-fr.jar

-rw-r--r--. 1 root root  50K May 13  2015 tomcat-i18n-ja.jar

-rw-r--r--. 1 root root 123K May 13  2015 tomcat-jdbc.jar

lrwxrwxrwx. 1 root root   25 May 19 09:03 tomcat-jsp-2.2-api.jar -> ../tomcat-jsp-2.2-api.jar

lrwxrwxrwx. 1 root root   37 May 19 09:03 tomcat-juli.jar -> /usr/share/tomcat/bin/tomcat-juli.jar

lrwxrwxrwx. 1 root root   29 May 19 09:03 tomcat-servlet-3.0-api.jar -> ../tomcat-servlet-3.0-api.jar

-rw-r--r--. 1 root root  31K May 13  2015 tomcat-util.jar

-rw-r--r--. 1 root root  36K May 13  2015 websocket-api.jar

 

 

 

[root@cmdbuild ~]# cat /var/lib/pgsql/9.4/data/postgresql.conf | grep -v "^$" | grep -v "#"

listen_addresses = '*'

log_timezone = 'Australia/ACT'

datestyle = 'iso, dmy'

timezone = 'Australia/ACT'

default_text_search_config = 'pg_catalog.english'

 

[root@cmdbuild ~]# cat /usr/share/tomcat/webapps/cmdbuild/WEB-INF/conf/database.conf

 

#Thu May 19 10:28:36 AEST 2016

db.password=Equat0r.

db.url=jdbc\:postgresql\://192.168.1.101\:5432/demo

db.username=postgres

[root@cmdbuild ~]#

 

[root@cmdbuild ~]# cat /var/lib/pgsql/9.4/data/pg_hba.conf | grep -v '^$\|^#'

local   all             all                                     trust

host    all             all             127.0.0.1/32            trust

host    all             all             192.0.0.0/8             trust

host    all             all             10.0.0.0/8              trust

host    all             all             ::1/128                trust

 

[root@cmdbuild log]# find / -name cmdbuild.log

INFO  2016-05-19 11:04:58 [jsonrpc ] Calling url /login/login

INFO  2016-05-19 11:04:58 [cmdbuild] trying to login user admin with group null

ERROR 2016-05-19 11:04:58 [jsonrpc ] A java.lang.NoClassDefFoundError occurred calling method class org.cmdbuild.servlets.json.Login.login: org/postgresql/jdbc/PgArray

 

 

 

 

 

#3

I am also getting the same error while login to the system. If I put wrong credentials, it will show ‘Wrong username or password’, where as if we feed correct credentials, it is showing the following error.



Call: services/json/login/login

Error: java.lang.NoClassDefFoundError: org/postgresql/jdbc/PgArray
at org.cmdbuild.dao.driver.postgres.SqlType$14.sqlToJavaValue(SqlType.java:219)
at org.cmdbuild.dao.driver.postgres.EntryQueryCommand$ResultFiller.addUserAttributes(EntryQueryCommand.java:238)
at org.cmdbuild.dao.driver.postgres.EntryQueryCommand$ResultFiller.createBasicCards(EntryQueryCommand.java:152)
at org.cmdbuild.dao.driver.postgres.EntryQueryCommand$ResultFiller.processRow(EntryQueryCommand.java:101)
at org.springframework.jdbc.core.JdbcTemplate$RowCallbackHandlerResultSetExtractor.extractData(JdbcTemplate.java:1566)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:693)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:629)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:680)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:712)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:737)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:747)
at org.cmdbuild.dao.driver.postgres.EntryQueryCommand.run(EntryQueryCommand.java:72)
at org.cmdbuild.dao.driver.postgres.PostgresDriver.query(PostgresDriver.java:194)
at org.cmdbuild.dao.view.DBDataView.executeQuery(DBDataView.java:416)
at org.cmdbuild.dao.query.QuerySpecsBuilderImpl.run(QuerySpecsBuilderImpl.java:559)
at org.cmdbuild.auth.DBUserFetcher.addGroupDescription(DBUserFetcher.java:154)
at org.cmdbuild.auth.DBUserFetcher.buildUserFromCard(DBUserFetcher.java:133)
at org.cmdbuild.auth.DBUserFetcher.fetchUser(DBUserFetcher.java:63)
at org.cmdbuild.auth.DefaultAuthenticationService.fetchUser(DefaultAuthenticationService.java:223)
at org.cmdbuild.auth.DefaultAuthenticationService.fetchAuthenticatedUser(DefaultAuthenticationService.java:212)
at org.cmdbuild.auth.DefaultAuthenticationService.authenticate(DefaultAuthenticationService.java:142)
at org.cmdbuild.logic.auth.DefaultAuthenticationLogic.login(DefaultAuthenticationLogic.java:132)
at org.cmdbuild.servlets.json.Login.login(Login.java:42)
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:107)
at org.cmdbuild.servlets.JSONDispatcher.doPost(JSONDispatcher.java:67)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.cmdbuild.filters.AuthFilter.doFilter(AuthFilter.java:158)
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:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
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:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
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:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
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:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:879)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:610)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1777)
at java.lang.Thread.run(Thread.java:745)