Error occourred while loading/saving data (cont)

beo.tse · September 10, 2014, 1:03am

I am facing an issue about Installing CMDBuild using graphical interface

Configuration as below

Linux version
======================
# cat /proc/version

Linux version 2.6.32-220.el6.x86_65 (mockbuild@c6b18n3.bsys.dev.centos.org) version 4.4.6 20110731 (Red Hat 4.4.6-3) (GCC) # SMP Tue Dec 6 19:48:22 2011

JDK version – installed by rpm
======================
# java –version

Java version “1.6.0_22”

OpenJDK Runtime Environment (IcedTea6 1.10.4) (rhel-1.41.1.10.4.el6-x86_64)

OpenJDK 64-Bit Server VM (build 20.0-b11, mixed mode)

tomcat version – installed by tar
======================
Apache Tomcat/6.0.41

tar –zxvf apache-tomcat-6.0.41.tar.gz

postgresql-server version – installed by yum

# yum info postgresql-server

Name : postgresql-server

Arch : x86_64

Version : 8.4.20

Release : 1.el6_5

Size : 15 M

Repo : installed

From repo : updates

postgresql version – installed by yum

# yum info postgresql

Name : postgresql

Arch : i686

Version : 8.4.20

Release : 1.el6_5

Size : 2.6 M

Repo : updates

cmdbuild version – installed by tomcat manager

cmdbuild-2.2.1

There are some questions during installation according to the Technical Manual

1. In section System configuration->Software requirements->2) Database.

A. It mentioned I should check plpgsql is active or not and whether the database is set with UTF-8 encoding. However, it doesn’t mention how to check it, please advise.

B. It was supposed that the file tomcat-dbcp.jar should be pasted in /usr/tomcat6/lib/ from cmdbuild-2.2.1.zip\ extras\tomcat-libs\5.5\. However, only dbcp-6.0.29.jar is found.

C. It mentioned execute command $ psql … cmdbuild, but psql: FATAL: database “…” cmdbuild was returned.

2. In section Installing CMDBuild using graphical interface->CMDBuild installation.

A. It mentioned to copy the CMDBuild-2.2.1.war into /usr/tomcat6/webapps and rename to cmdbuild.war. After the war has been extracted, a folder with files named cmdbuild are created. However, it cannot be browsed through chrome http://<server ip>:8080/cmdbuild, but surely the http://<server ip>:8080 is able to access. Anyway, I used the tomcat manager to deploy and access the cmdbuild portal successfully.

B. It mentioned to copy the CMDBuild-shark to /usr/tomcat6/webapps. However, cmdbuild-distribution-old-shark-overlay-2.2.1 and cmdbuild-distribution-shark-overlay-2.2.1 are found. Anyway, I placed the cmdbuild-shark-overlay-2.2.1 in webapps.

C. It mentioned to copy lib from extras/tomcat-libs to /usr/tomcat6/lib. However, according to postgreSQL official site. http://jdbc.postgresql.org/download.html The right jdbc driver should be postgresql-8.4-703.jdbc3.jar. Which version of jdbc driver I should use? 5.5/postgresql-9.1-901.jdbc4.jar or 6.0/postgresql-9.1-901.jdbc4.jar or postgresql-8.4-703.jdbc3.jar I should use?

3. In CMDBuild configuration section

A. [1) Language configuration section] It mentioned checking the “Show language choice in the login window”, but only “Show language selection in login box” checkbox is on the screen. Does it mean check this checkbox or there is another checkbox is hiding?

B. [Database configuration section] Due to I am a new user, I have no existing database. I choose the Empty option and fill the cmdbuild as database name. I was supposed a new database named cmdbuild will be created. Another question is; do I need to check the “Create a Shark schema”. Anyway I checked it, according to the figure on manual. I press the Test connection button with success.

Note: Host: <server ip>, Port: 5432, Super user: postgres, password: <password>

C. In metioned Selecting the checkbox “Create database user with limited privileges”. However, only Create a limited user I can find in the User type: dropdown menu in Created restricted database user section. I guess I should create a new user account “cmdbuild” for cmdbuild database. I filled out all textbox, and press Next.

4. After entering user admin name and password. I pressed the Finish button. An Error prompted with information “Error occourred while loading/saving data. After the show details were pressed. Details as below

Call: services/json/configure/apply

------------------------------------

Error: org.cmdbuild.exception.ORMException: ORM_GENERIC_ERROR

at org.cmdbuild.exception.ORMException$ORMExceptionType.createException(ORMException.java:59)

at org.cmdbuild.services.database.DatabaseConfigurator.configure(DatabaseConfigurator.java:169)

at org.cmdbuild.services.database.DatabaseConfigurator.configureAndSaveSettings(DatabaseConfigurator.java:147)

at org.cmdbuild.servlets.json.Configure.apply(Configure.java:164)

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

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

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

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

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)