CMDBuild Forum

Re: Installation CMDBuild 1.4 on RHEL 6 never end

Hi,

I try to install CMDBuild on a RHEL 6 server based on tomcat6 and postgresql 8.4.

When I finish "installation screen" process, a popup "Please wait" is launch but nothing else...

Can you please help me to resolve this installation problem ?

Regards

Hi,

in your tomcat home directory you should see a file called cmdbuild.log. There should be more information in that file. Can you paste here the relevant portion (at least the java stacktrace)?

Paolo

 

 

Surely,

 

log4j.conf is this one now:

 

log4j.debug=TRUE

log4j.rootLogger=WARN, R

 

log4j.logger.persist=DEBUG

log4j.logger.soap=WARN

log4j.logger.dms=WARN

log4j.logger.workflow=INFO

log4j.logger.sql=DEBUG

log4j.logger.jsonrpc=DEBUG

log4j.logger.rest=WARN

log4j.logger.email=INFO

log4j.logger.auth=WARN

log4j.logger.cmdbuild=DEBUG

 

log4j.appender.R=org.apache.log4j.RollingFileAppender

log4j.appender.R.File=/var/log/tomcat6/cmdbuild.log

log4j.appender.R.MaxFileSize=100MB

log4j.appender.R.MaxBackupIndex=10

 

log4j.appender.R.layout=org.apache.log4j.PatternLayout

log4j.appender.R.layout.ConversionPattern=%-5.5p %d{yyyy-MM-dd HH:mm:ss} [%-8c]           %m%n

 

and end of cmdbuild.log looks....

 

DEBUG 2011-10-14 09:36:29 [jsonrpc ]     parameter "ext-gen1026": admin

DEBUG 2011-10-14 09:36:29 [jsonrpc ]     parameter "port": 5432

DEBUG 2011-10-14 09:36:29 [jsonrpc ]     parameter "db_type": empty

DEBUG 2011-10-14 09:36:29 [jsonrpc ]     parameter "host": 127.0.0.1

DEBUG 2011-10-14 09:36:29 [jsonrpc ]     parameter "user_type": superuser

DEBUG 2011-10-14 09:36:29 [jsonrpc ]     parameter "admin_password": ***

DEBUG 2011-10-14 09:36:29 [jsonrpc ]     parameter "db_name": cmdbuild

DEBUG 2011-10-14 09:36:29 [jsonrpc ]     parameter "shark_schema": true

DEBUG 2011-10-14 09:36:29 [jsonrpc ]     parameter "password": ***

DEBUG 2011-10-14 09:36:29 [jsonrpc ]     parameter "admin_user": admin

DEBUG 2011-10-14 09:36:29 [jsonrpc ]     parameter "language": en

DEBUG 2011-10-14 09:36:29 [jsonrpc ]     parameter "user": postgres

DEBUG 2011-10-14 09:36:29 [jsonrpc ]     parameter "language_prompt": true

INFO  2011-10-14 09:36:29 [cmdbuild] Creating database

INFO  2011-10-14 09:36:30 [cmdbuild] Creating PL/SQL language

INFO  2011-10-14 09:36:30 [cmdbuild] Creating CMDBuild structure

INFO  2011-10-14 09:36:31 [cmdbuild] Creating shark role

INFO  2011-10-14 09:36:31 [cmdbuild] Creating schema shark

INFO  2011-10-14 09:36:31 [cmdbuild] Granting schema privileges

INFO  2011-10-14 09:36:31 [cmdbuild] Creating shark tables

INFO  2011-10-14 09:36:32 [persist ] Building table cache

 

Any idea ?

 

The log file looks all right. The database creation might have been timed out before it was completed. What happens if you reload the page? As I see from the logs, you should be redirected to the login prompt.

Paolo

 

 

And some line before...

DEBUG 2011-10-14 09:46:10 [cmdbuild] Commit never needed if the connection is not configured

 

 

HTTP Status 500 -


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)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.24 logs.

 

Previously Tecnoteca wrote:

The log file looks all right. The database creation might have been timed out before it was completed. What happens if you reload the page? As I see from the logs, you should be redirected to the login prompt.

Paolo

 

 

 

Previously NOLLET wrote:

java.lang.NoClassDefFoundError: org/apache/tomcat/dbcp/dbcp/BasicDataSource
...
It looks like you are not using the full Apache Tomcat distribution but the stripped-down one that comes with RHEL 6. CMDBuild uses a few libraries (jar) included in the original Tomcat distribution, and that are probably provided separately by your Linux distribution.

 

Paolo

 

Full Log.... after a clean reinstall...

 

INFO  2011-10-14 10:29:10 [cmdbuild] Loading common configurations for CMDBuild

ERROR 2011-10-14 10:29:10 [cmdbuild] Unable to load configuration file for transformers

ERROR 2011-10-14 10:29:10 [cmdbuild] Unable to load configuration file for builders

INFO  2011-10-14 10:29:10 [cmdbuild] Initializing ParameterTransformers

INFO  2011-10-14 10:29:10 [cmdbuild] Transformer for org.apache.commons.fileupload.FileItem: org.cmdbuild.servlets.utils.transformer.FileItemTransformer

INFO  2011-10-14 10:29:10 [cmdbuild] Transformer for org.json.JSONObject: org.cmdbuild.servlets.utils.transformer.JSONObjectTransformer

INFO  2011-10-14 10:29:10 [cmdbuild] Transformer for org.json.JSONArray: org.cmdbuild.servlets.utils.transformer.JSONArrayTransformer

INFO  2011-10-14 10:29:10 [cmdbuild] Initializer custom ParameterBuilders

INFO  2011-10-14 10:29:10 [cmdbuild] Builder for org.cmdbuild.servlets.json.management.ActivityIdentifier: org.cmdbuild.servlets.utils.builder.ActivityIdentifierParameter

INFO  2011-10-14 10:29:10 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.ICard: org.cmdbuild.servlets.utils.builder.CardParameter

INFO  2011-10-14 10:29:10 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.IRelation: org.cmdbuild.servlets.utils.builder.RelationParameter

INFO  2011-10-14 10:29:10 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.ITable: org.cmdbuild.servlets.utils.builder.TableParameter

INFO  2011-10-14 10:29:10 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.BaseSchema: org.cmdbuild.servlets.utils.builder.BaseSchemaParameter

INFO  2011-10-14 10:29:10 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.ProcessType: org.cmdbuild.servlets.utils.builder.ProcessTypeParameter

INFO  2011-10-14 10:29:10 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.IDomain: org.cmdbuild.servlets.utils.builder.DomainParameter

INFO  2011-10-14 10:29:10 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.CardQuery: org.cmdbuild.servlets.utils.builder.CardQueryParameter

INFO  2011-10-14 10:29:10 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.ProcessQuery: org.cmdbuild.servlets.utils.builder.ProcessQueryParameter

INFO  2011-10-14 10:29:10 [cmdbuild] Builder for org.w3c.dom.Document: org.cmdbuild.servlets.utils.builder.XMLDocumentBuilder

INFO  2011-10-14 10:29:10 [cmdbuild] Builder for org.cmdbuild.services.auth.UserContext: org.cmdbuild.servlets.utils.builder.UserContextParameter

INFO  2011-10-14 10:29:10 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.ITableFactory: org.cmdbuild.servlets.utils.builder.factory.TableFactoryParameter

INFO  2011-10-14 10:29:10 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.DomainFactory: org.cmdbuild.servlets.utils.builder.factory.DomainFactoryParameter

INFO  2011-10-14 10:29:10 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.RelationFactory: org.cmdbuild.servlets.utils.builder.factory.RelationFactoryParameter

INFO  2011-10-14 10:29:10 [cmdbuild] Loading scheduled jobs

WARN  2011-10-14 10:29:10 [cmdbuild] Could not load the scheduled jobs: first start or patch not yet applied?

INFO  2011-10-14 10:31:07 [jsonrpc ] Calling url /utils/gettranslationobject

INFO  2011-10-14 10:31:09 [jsonrpc ] Calling url /utils/listavailabletranslations

INFO  2011-10-14 10:31:36 [jsonrpc ] Calling url /configure/testconnection

INFO  2011-10-14 10:31:49 [jsonrpc ] Calling url /configure/apply

INFO  2011-10-14 10:31:49 [cmdbuild] Creating database

INFO  2011-10-14 10:31:50 [cmdbuild] Creating PL/SQL language

INFO  2011-10-14 10:31:50 [cmdbuild] Creating CMDBuild structure

INFO  2011-10-14 10:31:51 [cmdbuild] Creating shark role

INFO  2011-10-14 10:31:51 [cmdbuild] Creating schema shark

INFO  2011-10-14 10:31:51 [cmdbuild] Granting schema privileges

INFO  2011-10-14 10:31:51 [cmdbuild] Creating shark tables

 

catalina.out:

Oct 14, 2011 10:29:03 AM org.apache.catalina.core.AprLifecycleListener init

INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64/jre/lib/amd64/server:/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64/jre/lib/amd64:/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64/jre/../lib/amd64:/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib

Oct 14, 2011 10:29:03 AM org.apache.coyote.http11.Http11Protocol init

INFO: Initializing Coyote HTTP/1.1 on http-8080

Oct 14, 2011 10:29:03 AM org.apache.catalina.startup.Catalina load

INFO: Initialization processed in 788 ms

Oct 14, 2011 10:29:03 AM org.apache.catalina.core.StandardService start

INFO: Starting service Catalina

Oct 14, 2011 10:29:03 AM org.apache.catalina.core.StandardEngine start

INFO: Starting Servlet Engine: Apache Tomcat/6.0.24

Oct 14, 2011 10:29:03 AM org.apache.catalina.startup.HostConfig deployDescriptor

INFO: Deploying configuration descriptor cmdbuild.xml

Oct 14, 2011 10:29:04 AM org.apache.catalina.core.NamingContextListener addResource

WARNING: Failed to register in JMX: javax.naming.NamingException: Could not load resource factory class [Root exception is java.lang.ClassNotFoundException: org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory]

log4j:ERROR setFile(null,false) call failed.

java.io.FileNotFoundException: alfresco.log (Permission denied)

        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:290)

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

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

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

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

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

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

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

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

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

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

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

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

        at org.apache.log4j.Logger.getLogger(Logger.java:105)

        at org.apache.commons.logging.impl.Log4JLogger.getLogger(Log4JLogger.java:289)

        at org.apache.commons.logging.impl.Log4JLogger.<init>(Log4JLogger.java:109)

        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 org.apache.commons.logging.impl.LogFactoryImpl.createLogFromClass(LogFactoryImpl.java:1116)

        at org.apache.commons.logging.impl.LogFactoryImpl.discoverLogImplementation(LogFactoryImpl.java:914)

        at org.apache.commons.logging.impl.LogFactoryImpl.newInstance(LogFactoryImpl.java:604)

        at org.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:336)

        at org.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:310)

        at org.apache.commons.logging.LogFactory.getLog(LogFactory.java:685)

        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)

        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

        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].

log4j: Level token is [WARN].

log4j: Category root set to WARN

log4j: Parsing appender named "R".

log4j: Parsing layout options for "R".

log4j: Setting property [conversionPattern] to [%-5.5p %d{yyyy-MM-dd HH:mm:ss} [%-8c] %m%n].

log4j: End of parsing for "R".

log4j: Setting property [file] to [/var/log/tomcat/cmdbuild2.log].

log4j: Setting property [maxBackupIndex] to [10].

log4j: Setting property [maxFileSize] to [100MB].

log4j: setFile called: /var/log/tomcat/cmdbuild2.log, true

log4j: setFile ended

log4j: Parsed "R" options.

log4j: Parsing for [jsonrpc] with value=[INFO].

log4j: Level token is [INFO].

log4j: Category jsonrpc set to INFO

log4j: Handling log4j.additivity.jsonrpc=[null]

log4j: Parsing for [sql] with value=[WARN].

log4j: Level token is [WARN].

log4j: Category sql set to WARN

log4j: Handling log4j.additivity.sql=[null]

log4j: Parsing for [soap] with value=[WARN].

log4j: Level token is [WARN].

log4j: Category soap set to WARN

log4j: Handling log4j.additivity.soap=[null]

log4j: Parsing for [dms] with value=[WARN].

log4j: Level token is [WARN].

log4j: Category dms set to WARN

log4j: Handling log4j.additivity.dms=[null]

log4j: Parsing for [email] with value=[INFO].

log4j: Level token is [INFO].

log4j: Category email set to INFO

log4j: Handling log4j.additivity.email=[null]

log4j: Parsing for [auth] with value=[WARN].

log4j: Level token is [WARN].

log4j: Category auth set to WARN

log4j: Handling log4j.additivity.auth=[null]

log4j: Parsing for [persist] with value=[WARN].

log4j: Level token is [WARN].

log4j: Category persist set to WARN

log4j: Handling log4j.additivity.persist=[null]

log4j: Parsing for [rest] with value=[WARN].

log4j: Level token is [WARN].

log4j: Category rest set to WARN

log4j: Handling log4j.additivity.rest=[null]

log4j: Parsing for [workflow] with value=[INFO].

log4j: Level token is [INFO].

log4j: Category workflow set to INFO

log4j: Handling log4j.additivity.workflow=[null]

log4j: Parsing for [cmdbuild] with value=[INFO].

log4j: Level token is [INFO].

log4j: Category cmdbuild set to INFO

log4j: Handling log4j.additivity.cmdbuild=[null]

log4j: Finished configuring.

Oct 14, 2011 10:29:11 AM org.apache.coyote.http11.Http11Protocol start

INFO: Starting Coyote HTTP/1.1 on http-8080

Oct 14, 2011 10:29:11 AM org.apache.jk.common.ChannelSocket init

INFO: JK: ajp13 listening on /0.0.0.0:8009

Oct 14, 2011 10:29:11 AM org.apache.jk.server.JkMain start

INFO: Jk running ID=0 time=0/18  config=null

Oct 14, 2011 10:29:11 AM org.apache.catalina.startup.Catalina start

INFO: Server startup in 7635 ms

 

if I refresh the page, Error 500...

 

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)

Regards.

 

OK resolve by copying /home/admin/cmdbuild/extras/tomcat-libs/5.5/tomcat-dbcp.jar to /usr/share/tomcat6/lib/

Thanks

 

Rémy

 

Previously Tecnoteca wrote:

Previously NOLLET wrote:

java.lang.NoClassDefFoundError: org/apache/tomcat/dbcp/dbcp/BasicDataSource
...
It looks like you are not using the full Apache Tomcat distribution but the stripped-down one that comes with RHEL 6. CMDBuild uses a few libraries (jar) included in the original Tomcat distribution, and that are probably provided separately by your Linux distribution.

 

Paolo

 

 

 

Previously NOLLET wrote:

OK resolve by copying /home/admin/cmdbuild/extras/tomcat-libs/5.5/tomcat-dbcp.jar to /usr/share/tomcat6/lib/

Thanks

 

Rémy

 

Previously Tecnoteca wrote:

Previously NOLLET wrote:

java.lang.NoClassDefFoundError: org/apache/tomcat/dbcp/dbcp/BasicDataSource
...
It looks like you are not using the full Apache Tomcat distribution but the stripped-down one that comes with RHEL 6. CMDBuild uses a few libraries (jar) included in the original Tomcat distribution, and that are probably provided separately by your Linux distribution.

 

Paolo

 

 

Hi ALL,

 

I have same problem with similar error. When I try to create my first DB (cmdbuild) the process's never finished. I see this in my logs:

less /var/log/tomcat6/cmdbuild.log

INFO  2013-03-21 09:48:40 [cmdbuild] Initializing ParameterTransformers
INFO  2013-03-21 09:48:40 [cmdbuild] Transformer for org.apache.commons.fileupload.FileItem: org.cmdbuild.servlets.utils.transformer.FileItemTransformer
INFO  2013-03-21 09:48:40 [cmdbuild] Transformer for org.json.JSONObject: org.cmdbuild.servlets.utils.transformer.JSONObjectTransformer
INFO  2013-03-21 09:48:40 [cmdbuild] Transformer for org.json.JSONArray: org.cmdbuild.servlets.utils.transformer.JSONArrayTransformer
INFO  2013-03-21 09:48:40 [cmdbuild] Initializer custom ParameterBuilders
INFO  2013-03-21 09:48:40 [cmdbuild] Builder for org.cmdbuild.servlets.json.management.ActivityIdentifier: org.cmdbuild.servlets.utils.builder.ActivityIdentifierParameter
INFO  2013-03-21 09:48:40 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.ICard: org.cmdbuild.servlets.utils.builder.CardParameter
INFO  2013-03-21 09:48:40 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.IRelation: org.cmdbuild.servlets.utils.builder.RelationParameter
INFO  2013-03-21 09:48:40 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.ITable: org.cmdbuild.servlets.utils.builder.TableParameter
INFO  2013-03-21 09:48:40 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.BaseSchema: org.cmdbuild.servlets.utils.builder.BaseSchemaParameter
INFO  2013-03-21 09:48:40 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.ProcessType: org.cmdbuild.servlets.utils.builder.ProcessTypeParameter
INFO  2013-03-21 09:48:40 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.IDomain: org.cmdbuild.servlets.utils.builder.DomainParameter
INFO  2013-03-21 09:48:40 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.CardQuery: org.cmdbuild.servlets.utils.builder.CardQueryParameter
INFO  2013-03-21 09:48:40 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.ProcessQuery: org.cmdbuild.servlets.utils.builder.ProcessQueryParameter
INFO  2013-03-21 09:48:40 [cmdbuild] Builder for org.w3c.dom.Document: org.cmdbuild.servlets.utils.builder.XMLDocumentBuilder
INFO  2013-03-21 09:48:40 [cmdbuild] Builder for org.cmdbuild.services.auth.UserContext: org.cmdbuild.servlets.utils.builder.UserContextParameter
INFO  2013-03-21 09:48:40 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.ITableFactory: org.cmdbuild.servlets.utils.builder.factory.TableFactoryParameter
INFO  2013-03-21 09:48:40 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.DomainFactory: org.cmdbuild.servlets.utils.builder.factory.DomainFactoryParameter
INFO  2013-03-21 09:48:40 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.RelationFactory: org.cmdbuild.servlets.utils.builder.factory.RelationFactoryParameter
INFO  2013-03-21 09:48:40 [cmdbuild] Loading scheduled jobs
WARN  2013-03-21 09:48:40 [cmdbuild] Could not load the scheduled jobs: first start or patch not yet applied?
INFO  2013-03-21 09:59:26 [jsonrpc ] Calling url /utils/gettranslationobject
WARN  2013-03-21 09:59:28 [jsonrpc ] /widget/callwidget already mapped
INFO  2013-03-21 09:59:29 [jsonrpc ] Calling url /utils/listavailabletranslations
INFO  2013-03-21 10:00:06 [jsonrpc ] Calling url /configure/testconnection
INFO  2013-03-21 10:00:26 [jsonrpc ] Calling url /configure/apply
INFO  2013-03-21 10:00:26 [cmdbuild] Creating database
INFO  2013-03-21 10:00:31 [cmdbuild] Creating PL/SQL language
INFO  2013-03-21 10:00:31 [cmdbuild] Creating CMDBuild structure
INFO  2013-03-21 10:00:34 [cmdbuild] Creating shark role
INFO  2013-03-21 10:00:34 [cmdbuild] Creating schema shark
INFO  2013-03-21 10:00:34 [cmdbuild] Granting schema privileges
INFO  2013-03-21 10:00:34 [cmdbuild] Creating shark tables

 

I have next rpms in my server:

[root@test webapps]# rpm -qa | egrep 'java|tomcat'
jboss-javaee-poms-5.0.2-2.ep5.el6.noarch
java-1.6.0-sun-devel-1.6.0.39-1jpp.1.el6_3.x86_64
tomcat6-6.0.24-48.el6_3.noarch
tomcat6-servlet-2.5-api-6.0.24-48.el6_3.noarch
tomcat6-jsp-2.1-api-6.0.24-48.el6_3.noarch
java_cup-0.10k-5.el6.x86_64
tomcat6-el-2.1-api-6.0.24-48.el6_3.noarch
tomcat6-lib-6.0.24-48.el6_3.noarch
tomcat6-webapps-6.0.24-48.el6_3.noarch
java-1.6.0-sun-1.6.0.39-1jpp.1.el6_3.x86_64
glassfish-javamail-1.4.2-2.ep5.el6.noarch
java-1.5.0-gcj-1.5.0.0-29.1.el6.x86_64
tomcat6-admin-webapps-6.0.24-48.el6_3.noarch
[root@test webapps]#

But when I try to reopen the page I've got only:

HTTP Status 500 -


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:62)
	org.cmdbuild.services.DBService.<init>(DBService.java:34)
	org.cmdbuild.services.DBService.getInstance(DBService.java:44)
	org.cmdbuild.services.DBService.getConnection(DBService.java:72)
	org.cmdbuild.dao.backend.postgresql.PGCMBackend.loadTableMap(PGCMBackend.java:358)
	org.cmdbuild.dao.backend.SchemaCache.loadTables(SchemaCache.java:229)
	org.cmdbuild.dao.backend.SchemaCache.getTableMap(SchemaCache.java:213)
	org.cmdbuild.dao.backend.SchemaCache.getTable(SchemaCache.java:47)
	org.cmdbuild.dao.backend.postgresql.PGCMBackend.getTable(PGCMBackend.java:1436)
	org.cmdbuild.elements.TableFactoryImpl.get(TableFactoryImpl.java:41)
	org.cmdbuild.services.PatchManager.getPatchTable(PatchManager.java:82)
	org.cmdbuild.services.PatchManager.getLastAppliedPatch(PatchManager.java:68)
	org.cmdbuild.services.PatchManager.<init>(PatchManager.java:62)
	org.cmdbuild.services.PatchManager.getInstance(PatchManager.java:46)
	org.cmdbuild.filters.PatchManagerFilter.doFilter(PatchManagerFilter.java:25)
	org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31)
	org.cmdbuild.filters.TranslationFilter.doFilter(TranslationFilter.java:37)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.24 logs.

 

Do you have any idea?

 

I assume you are using CMDBuild 2.0, not CMDBuild 1.4.
Btw, the problem is exactly the same above. Your tomcat doesn't have that class. 
So: have you tried copying /cmdbuild-2.0.4/extras/tomcat-libs/5.5/dbcp-6.0.29.jar(inside cmdbuild-2.0.4.zip) to your /tomcat6/lib/ ?
 
Previously Ivan wrote:

root cause

java.lang.NoClassDefFoundError: org/apache/tomcat/dbcp/dbcp/BasicDataSource
	org.cmdbuild.services.DBService.configureDatasource(DBService.java:62)
	org.cmdbuild.services.DBService.<init>(DBService.java:34)
	org.cmdbuild.services.DBService.getInstance(DBService.java:44)
	org.cmdbuild.services.DBService.getConnection(DBService.java:72)
	org.cmdbuild.dao.backend.postgresql.PGCMBackend.loadTableMap(PGCMBackend.java:358)
	org.cmdbuild.dao.backend.SchemaCache.loadTables(SchemaCache.java:229)
	org.cmdbuild.dao.backend.SchemaCache.getTableMap(SchemaCache.java:213)
	org.cmdbuild.dao.backend.SchemaCache.getTable(SchemaCache.java:47)
	org.cmdbuild.dao.backend.postgresql.PGCMBackend.getTable(PGCMBackend.java:1436)
	org.cmdbuild.elements.TableFactoryImpl.get(TableFactoryImpl.java:41)
	org.cmdbuild.services.PatchManager.getPatchTable(PatchManager.java:82)
	org.cmdbuild.services.PatchManager.getLastAppliedPatch(PatchManager.java:68)
	org.cmdbuild.services.PatchManager.<init>(PatchManager.java:62)
	org.cmdbuild.services.PatchManager.getInstance(PatchManager.java:46)
	org.cmdbuild.filters.PatchManagerFilter.doFilter(PatchManagerFilter.java:25)
	org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31)
	org.cmdbuild.filters.TranslationFilter.doFilter(TranslationFilter.java:37)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.24 logs.

 

Do you have any idea?

 

 

It doesn't work anywhere...

 

See below:

[root@test ~]# ls -l /usr/share/tomcat6/lib/dbcp-6.0.29.jar

-rw-rw-r--. 1 ipavlenko ipavlenko 249650 Sep 13  2012 /usr/share/tomcat6/lib/dbcp-6.0.29.jar

[root@test ~]#

 

So, I put this file to tomact6 libs folder. Also, is it important what version of tomcat I use? Cos I see next:

 

[root@test ~]# cd ~ipavlenko/

[root@test ipavlenko]# ls -l ./cmdbuild-2.0.4/extras/tomcat-libs/

total 8

drwxrwxr-x. 2 ipavlenko ipavlenko 4096 Feb  7 15:11 5.5

drwxrwxr-x. 2 ipavlenko ipavlenko 4096 Feb  7 15:11 6.0

[root@test ipavlenko]#

[root@test ipavlenko]# ls -l ./cmdbuild-2.0.4/extras/tomcat-libs/6.0/

total 532

-rw-rw-r--. 1 ipavlenko ipavlenko    233 Feb  7 15:11 INSTALL.txt

-rw-rw-r--. 1 ipavlenko ipavlenko 539705 Sep 13  2012 postgresql-9.1-901.jdbc4.jar

[root@test ipavlenko]# ls -l ./cmdbuild-2.0.4/extras/tomcat-libs/5.5/

total 776

-rw-rw-r--. 1 ipavlenko ipavlenko 249650 Sep 13  2012 dbcp-6.0.29.jar

-rw-rw-r--. 1 ipavlenko ipavlenko    373 Feb  7 15:11 INSTALL.txt

-rw-rw-r--. 1 ipavlenko ipavlenko 539705 Sep 13  2012 postgresql-9.1-901.jdbc4.jar

[root@test ipavlenko]#

 

For version of tomcat 6.0 I have no dbcp-jar file

...

 

 

 

 

Previously Tecnoteca wrote:
I assume you are using CMDBuild 2.0, not CMDBuild 1.4.
Btw, the problem is exactly the same above. Your tomcat doesn't have that class. 
So: have you tried copying /cmdbuild-2.0.4/extras/tomcat-libs/5.5/dbcp-6.0.29.jar(inside cmdbuild-2.0.4.zip) to your /tomcat6/lib/ ?
 
Previously Ivan wrote:

root cause

java.lang.NoClassDefFoundError: org/apache/tomcat/dbcp/dbcp/BasicDataSource
	org.cmdbuild.services.DBService.configureDatasource(DBService.java:62)
	org.cmdbuild.services.DBService.<init>(DBService.java:34)
	org.cmdbuild.services.DBService.getInstance(DBService.java:44)
	org.cmdbuild.services.DBService.getConnection(DBService.java:72)
	org.cmdbuild.dao.backend.postgresql.PGCMBackend.loadTableMap(PGCMBackend.java:358)
	org.cmdbuild.dao.backend.SchemaCache.loadTables(SchemaCache.java:229)
	org.cmdbuild.dao.backend.SchemaCache.getTableMap(SchemaCache.java:213)
	org.cmdbuild.dao.backend.SchemaCache.getTable(SchemaCache.java:47)
	org.cmdbuild.dao.backend.postgresql.PGCMBackend.getTable(PGCMBackend.java:1436)
	org.cmdbuild.elements.TableFactoryImpl.get(TableFactoryImpl.java:41)
	org.cmdbuild.services.PatchManager.getPatchTable(PatchManager.java:82)
	org.cmdbuild.services.PatchManager.getLastAppliedPatch(PatchManager.java:68)
	org.cmdbuild.services.PatchManager.<init>(PatchManager.java:62)
	org.cmdbuild.services.PatchManager.getInstance(PatchManager.java:46)
	org.cmdbuild.filters.PatchManagerFilter.doFilter(PatchManagerFilter.java:25)
	org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31)
	org.cmdbuild.filters.TranslationFilter.doFilter(TranslationFilter.java:37)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.24 logs.

 

Do you have any idea?