I'm proposing CIMDBuild for my company. But first, I have to show it to my supervisor that I can install it. But so far no luck for me.
To make it less complicated, I use our test server(win7 x64) for iDempiere, already has PostgreSQL 9.3(x86) and JDK 1.6(x86) running (complete with the environment variable configuration). For Apache server, I use XAMPP v1.8.3 (includes Apache 2.4.7, PHP 5.5.6, Tomcat 7.0.42). I followed instruction from this manual.
I copied the following files:
- cmdbuild.war to C:\xampp\tomcat\webapps
- cmdbuild-shark-overlay-2.1.6 to C:\xampp\tomcat\webapps\cmdbuild-shark-overlay-2.1.6
- postgresql-9.1-901.jdbc4.jar to C:\xampp\tomcat\lib
PostgreSQL start as the service at localhost, with superuser account "postgres". I start Apache and Tomcat manually using XAMPP control panel after I copied all file above.
Accessing http://localhost:8080/cmdbuild/ giving me error page. I check http://localhost:8080/manager/html. It show me that application /cmdbuild-shark-overlay-2.1.6 running status is true while /cmdbuild status is false. I tried to start it from Tomcat manager, but the status still false.
I try again in the second computer, Linux Mint 16 (x86). PostgreSQL, Apache and Tomcat are installed using apt-get command from Linux Mint repository (sudo apt-get install postgresql libpq-dev pgadmin3 apache2 tomcat6 tomcat6-admin). JDK 1.6 is downloaded manually from oracle (jdk-6u43-linux-i586.bin). Again, I copied the files to /var/lib/tomcat/ folder and set it all with chmod tomcat6:tomcat6 chown 755. After that, I start all the services (postgresql, apache, and tomcat from /etc/init.d/). Again, Tomcat manager show me /cmdbuild running status is fail.
For win7 machine, should I also install JDK not at C:\Program Files (x86)\java?
For linux machine, should I uninstall other version JDK (1.7) or the problem is related with PostgreSQL ?
The cmdbuild.log from win7 machine is bellow:
INFO 2014-02-05 16:53:30 [cmdbuild] loading configurations
ERROR 2014-02-05 16:53:33 [org.springframework.web.context.ContextLoader] Context initialization failed
java.lang.NoClassDefFoundError: javax/xml/ws/EndpointReference
at java.lang.Class.getDeclaredMethods0(Native Method)
at java.lang.Class.privateGetDeclaredMethods(Class.java:2427)
at java.lang.Class.getDeclaredMethods(Class.java:1791)
at org.springframework.core.type.StandardAnnotationMetadata.hasAnnotatedMethods(StandardAnnotationMetadata.java:136)
...
at java.lang.Thread.run(Thread.java:619)
INFO 2014-02-05 16:53:33 [cmdbuild] Initializing ParameterTransformers
INFO 2014-02-05 16:53:33 [cmdbuild] Transformer for org.apache.commons.fileupload.FileItem: org.cmdbuild.servlets.utils.transformer.FileItemTransformer
INFO 2014-02-05 16:53:33 [cmdbuild] Transformer for org.json.JSONObject: org.cmdbuild.servlets.utils.transformer.JSONObjectTransformer
INFO 2014-02-05 16:53:33 [cmdbuild] Transformer for org.json.JSONArray: org.cmdbuild.servlets.utils.transformer.JSONArrayTransformer
INFO 2014-02-05 16:53:33 [cmdbuild] Initializer custom ParameterBuilders
The cmdbuild.log from linux machine is bellow:
INFO 2014-02-05 14:26:40 [cmdbuild] loading configurations
ERROR 2014-02-05 14:26:45 [org.springframework.web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'cachingService' defined in file [/var/lib/tomcat6/webapps/cmdbuild/WEB-INF/classes/org/cmdbuild/cache.xml]: Cannot create inner bean 'org.cmdbuild.services.cache.wrappers.DatabaseDriverWrapper#1c1b372' of type [org.cmdbuild.services.cache.wrappers.DatabaseDriverWrapper] while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.cmdbuild.services.cache.wrappers.DatabaseDriverWrapper#1c1b372' defined in file [/var/lib/tomcat6/webapps/cmdbuild/WEB-INF/classes/org/cmdbuild/cache.xml]: Cannot resolve reference to bean 'dbDriver' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dbDriver' defined in file [/var/lib/tomcat6/webapps/cmdbuild/WEB-INF/classes/org/cmdbuild/database.xml]: Cannot resolve reference to bean 'dataSource' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSourceFactory' defined in file [/var/lib/tomcat6/webapps/cmdbuild/WEB-INF/classes/org/cmdbuild/database.xml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: org/postgresql/Driver
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveInnerBean(BeanDefinitionValueResolver.java:281)
at
...
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
... 43 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSourceFactory' defined in file [/var/lib/tomcat6/webapps/cmdbuild/WEB-INF/classes/org/cmdbuild/database.xml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: org/postgresql/Driver
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:288)
...
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
... 55 more
Caused by: java.lang.NoClassDefFoundError: org/postgresql/Driver
at org.cmdbuild.services.DefaultDataSourceFactory.<clinit>(DefaultDataSourceFactory.java:21)
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:526)
at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:126)
at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:108)
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:280)
... 73 more
Caused by: java.lang.ClassNotFoundException: org.postgresql.Driver
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1680)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1526)
... 81 more