CMDBuild Forum

Cmdbuild 1.5 on Ubuntu 11.10

Im trying to setup Cmdbuild on Ubuntu 11.10 and the installation gets stuck.

If you check the cmdbuild.log it hangs on: INFO  2012-03-07 12:21:19 [cmdbuild] Creating shark tables

The installation stops when you click "finish" and the "please wait" box apears.. nothing happends after that.

Full log: 

 

INFO  2012-03-07 12:15:42 [cmdbuild] Loading scheduled jobs

WARN  2012-03-07 12:15:42 [cmdbuild] Could not load the scheduled jobs: first start or patch not yet applied?

INFO  2012-03-07 12:20:22 [jsonrpc ] Calling url /utils/gettranslationobject

INFO  2012-03-07 12:20:23 [jsonrpc ] Calling url /utils/listavailabletranslations

INFO  2012-03-07 12:21:04 [jsonrpc ] Calling url /configure/testconnection

INFO  2012-03-07 12:21:18 [jsonrpc ] Calling url /configure/apply

INFO  2012-03-07 12:21:18 [cmdbuild] Creating database

INFO  2012-03-07 12:21:18 [cmdbuild] Creating PL/SQL language

WARN  2012-03-07 12:21:18 [sql     ] Cannot create PL/SQL language. Present already?

INFO  2012-03-07 12:21:18 [cmdbuild] Creating CMDBuild structure

INFO  2012-03-07 12:21:19 [cmdbuild] Creating shark role

INFO  2012-03-07 12:21:19 [cmdbuild] Creating schema shark

INFO  2012-03-07 12:21:19 [cmdbuild] Granting schema privileges

INFO  2012-03-07 12:21:19 [cmdbuild] Creating shark tables

I am using the tomcat6 and postgresql 9.1 from the ubuntu repositories and postgresql-9.1-901.jdbc3.jar downloaded from the postgresql website.
 
If i reload the webpage i get:

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: Filter execution threw an exception
	org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31)
	org.cmdbuild.filters.TranslationFilter.doFilter(TranslationFilter.java:37)

 

root cause

java.lang.NoClassDefFoundError: org/apache/tomcat/dbcp/dbcp/BasicDataSource
	org.cmdbuild.services.DBService.configureDatasource(DBService.java:53)
	org.cmdbuild.services.DBService.<init>(DBService.java:30)
	org.cmdbuild.services.DBService.getInstance(DBService.java:38)
	org.cmdbuild.services.DBService.getConnection(DBService.java:63)
	org.cmdbuild.dao.backend.postgresql.PGCMBackend.loadTableMap(PGCMBackend.java:357)
	org.cmdbuild.dao.backend.SchemaCache.loadTables(SchemaCache.java:215)
	org.cmdbuild.dao.backend.SchemaCache.getTableMap(SchemaCache.java:199)
	org.cmdbuild.dao.backend.SchemaCache.getTable(SchemaCache.java:47)
	org.cmdbuild.dao.backend.postgresql.PGCMBackend.getTable(PGCMBackend.java:1435)
	org.cmdbuild.elements.TableFactoryImpl.get(TableFactoryImpl.java:41)
	org.cmdbuild.services.PatchManager.getPatchTable(PatchManager.java:81)
	org.cmdbuild.services.PatchManager.getLastAppliedPatch(PatchManager.java:67)
	org.cmdbuild.services.PatchManager.<init>(PatchManager.java:61)
	org.cmdbuild.services.PatchManager.getInstance(PatchManager.java:45)
	org.cmdbuild.filters.PatchManagerFilter.doFilter(PatchManagerFilter.java:25)
	org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31)
	org.cmdbuild.filters.TranslationFilter.doFilter(TranslationFilter.java:37)

CMDBuild works on vanilla Tomcat distributions. The Ubuntu package has been stripped-down and does not include tomcat-dbcp.jar (this is why: https://bugs.launchpad.net/ubuntu/+source/tomcat6/+bug/283852). You need to download that library from http://tomcat.apache.org/ and put in Tomcat’s classpath (e.g. $TOMCAT_HOME/lib).

 
Paolo

Eric ha scritto:

Im trying to setup Cmdbuild on Ubuntu 11.10 and the installation gets stuck.

If you check the cmdbuild.log it hangs on: INFO  2012-03-07 12:21:19 [cmdbuild] Creating shark tables

The installation stops when you click "finish" and the "please wait" box apears.. nothing happends after that.

Full log: 

 

INFO  2012-03-07 12:15:42 [cmdbuild] Loading scheduled jobs

WARN  2012-03-07 12:15:42 [cmdbuild] Could not load the scheduled jobs: first start or patch not yet applied?

INFO  2012-03-07 12:20:22 [jsonrpc ] Calling url /utils/gettranslationobject

INFO  2012-03-07 12:20:23 [jsonrpc ] Calling url /utils/listavailabletranslations

INFO  2012-03-07 12:21:04 [jsonrpc ] Calling url /configure/testconnection

INFO  2012-03-07 12:21:18 [jsonrpc ] Calling url /configure/apply

INFO  2012-03-07 12:21:18 [cmdbuild] Creating database

INFO  2012-03-07 12:21:18 [cmdbuild] Creating PL/SQL language

WARN  2012-03-07 12:21:18 [sql     ] Cannot create PL/SQL language. Present already?

INFO  2012-03-07 12:21:18 [cmdbuild] Creating CMDBuild structure

INFO  2012-03-07 12:21:19 [cmdbuild] Creating shark role

INFO  2012-03-07 12:21:19 [cmdbuild] Creating schema shark

INFO  2012-03-07 12:21:19 [cmdbuild] Granting schema privileges

INFO  2012-03-07 12:21:19 [cmdbuild] Creating shark tables

I am using the tomcat6 and postgresql 9.1 from the ubuntu repositories and postgresql-9.1-901.jdbc3.jar downloaded from the postgresql website.
 
If i reload the webpage i get:

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: Filter execution threw an exception
	org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31)
	org.cmdbuild.filters.TranslationFilter.doFilter(TranslationFilter.java:37)

 

root cause

java.lang.NoClassDefFoundError: org/apache/tomcat/dbcp/dbcp/BasicDataSource
	org.cmdbuild.services.DBService.configureDatasource(DBService.java:53)
	org.cmdbuild.services.DBService.<init>(DBService.java:30)
	org.cmdbuild.services.DBService.getInstance(DBService.java:38)
	org.cmdbuild.services.DBService.getConnection(DBService.java:63)
	org.cmdbuild.dao.backend.postgresql.PGCMBackend.loadTableMap(PGCMBackend.java:357)
	org.cmdbuild.dao.backend.SchemaCache.loadTables(SchemaCache.java:215)
	org.cmdbuild.dao.backend.SchemaCache.getTableMap(SchemaCache.java:199)
	org.cmdbuild.dao.backend.SchemaCache.getTable(SchemaCache.java:47)
	org.cmdbuild.dao.backend.postgresql.PGCMBackend.getTable(PGCMBackend.java:1435)
	org.cmdbuild.elements.TableFactoryImpl.get(TableFactoryImpl.java:41)
	org.cmdbuild.services.PatchManager.getPatchTable(PatchManager.java:81)
	org.cmdbuild.services.PatchManager.getLastAppliedPatch(PatchManager.java:67)
	org.cmdbuild.services.PatchManager.<init>(PatchManager.java:61)
	org.cmdbuild.services.PatchManager.getInstance(PatchManager.java:45)
	org.cmdbuild.filters.PatchManagerFilter.doFilter(PatchManagerFilter.java:25)
	org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31)
	org.cmdbuild.filters.TranslationFilter.doFilter(TranslationFilter.java:37)

 

I have the very same configuration (ubuntu, postgres, tomcat6, jdbc library) and the same output. I have a postgres db server on a separate host, which I can connect to (the initial connection test goes ok) and where I find the DB and the limited user created

.

I also tryed the suggested manual configuration (patching the cmdbuild,conf and database.conf files) and noticed the following:

- with an empty database.conf file, the cmdbuild webapp runs smoothly and I can stop&start again it from the tomcat manager gui

 

- if I stop tomcat, patch the file database.conf with the DBserver IP and user/password name, then restart tomcat, this is what appears into catalina.log

:

--------------- LOG START HERE -----------------

Apr 7, 2012 12:51:13 PM org.apache.catalina.core.StandardContext start

SEVERE: Error listenerStart

Apr 7, 2012 12:51:13 PM org.apache.catalina.core.StandardContext start

SEVERE: Context [/cmdbuild] startup failed due to previous errors

Apr 7, 2012 12:51:13 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads

SEVERE: The web application [/cmdbuild] appears to have started a thread named [FileWatchdog] but has failed to stop it. This is very likely to create a memory leak.

Apr 7, 2012 12:51:13 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads

SEVERE: The web application [/cmdbuild] appears to have started a thread named [CMDBuildScheduler_Worker-1] but has failed to stop it. This is very likely to create a memory leak.

Apr 7, 2012 12:51:13 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads

SEVERE: The web application [/cmdbuild] appears to have started a thread named [CMDBuildScheduler_Worker-2] but has failed to stop it. This is very likely to create a memory leak.

Apr 7, 2012 12:51:13 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads

SEVERE: The web application [/cmdbuild] appears to have started a thread named [CMDBuildScheduler_Worker-3] but has failed to stop it. This is very likely to create a memory leak.

Apr 7, 2012 12:51:13 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads

SEVERE: The web application [/cmdbuild] appears to have started a thread named [CMDBuildScheduler_Worker-4] but has failed to stop it. This is very likely to create a memory leak.

Apr 7, 2012 12:51:13 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads

SEVERE: The web application [/cmdbuild] appears to have started a thread named [CMDBuildScheduler_Worker-5] but has failed to stop it. This is very likely to create a memory leak.

----------------- LOG FINISHES HERE ------------------

 

After this, tomcat shuts down the webapp.

 

I sow that there a message regarding a patch, into cmdbuild.log: what patch is about?

 

Thanks.

 

Niccolò

Tecnoteca ha scritto:

CMDBuild works on vanilla Tomcat distributions. The Ubuntu package has been stripped-down and does not include tomcat-dbcp.jar (this is why: https://bugs.launchpad.net/ubuntu/+source/tomcat6/+bug/283852). You need to download that library from http://tomcat.apache.org/ and put in Tomcat's classpath (e.g. $TOMCAT_HOME/lib).
 
Paolo
Thank you Paolo, yesterday I missed this hint. This solved also my issue

.

 

Niccolò