CMDBuild Forum

Installing cmdbuild

Hello,

I have tried to install cmdbuild 1.5.0 and 1.5.4 via the network but run into an error when doing the connection test.  I have tried to access the postgres database via psql from another server and this works fine.

admmngr9@pcdtn04957:~> psql -h 130.139.12.37 -p 5432 -U postgres -W
Password for user postgres:
psql (9.1.3)
Type "help" for help.

postgres=#
I found following in cmdbuild.log:

INFO  2012-06-07 13:40:34 [cmdbuild] Loading common configurations for CMDBuild
INFO  2012-06-07 13:40:34 [cmdbuild] Initializing ParameterTransformers
INFO  2012-06-07 13:40:34 [cmdbuild] Transformer for org.apache.commons.fileupload.FileItem: org.cmdbuild.servlets.utils.transformer.FileItemTransformer
INFO  2012-06-07 13:40:34 [cmdbuild] Transformer for org.json.JSONObject: org.cmdbuild.servlets.utils.transformer.JSONObjectTransformer
INFO  2012-06-07 13:40:34 [cmdbuild] Transformer for org.json.JSONArray: org.cmdbuild.servlets.utils.transformer.JSONArrayTransformer
INFO  2012-06-07 13:40:34 [cmdbuild] Initializer custom ParameterBuilders
INFO  2012-06-07 13:40:34 [cmdbuild] Builder for org.cmdbuild.servlets.json.management.ActivityIdentifier: org.cmdbuild.servlets.utils.builder.ActivityIdentifierParameter
INFO  2012-06-07 13:40:34 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.ICard: org.cmdbuild.servlets.utils.builder.CardParameter
INFO  2012-06-07 13:40:34 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.IRelation: org.cmdbuild.servlets.utils.builder.RelationParameter
INFO  2012-06-07 13:40:34 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.ITable: org.cmdbuild.servlets.utils.builder.TableParameter
INFO  2012-06-07 13:40:34 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.BaseSchema: org.cmdbuild.servlets.utils.builder.BaseSchemaParameter
INFO  2012-06-07 13:40:34 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.ProcessType: org.cmdbuild.servlets.utils.builder.ProcessTypeParameter
INFO  2012-06-07 13:40:34 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.IDomain: org.cmdbuild.servlets.utils.builder.DomainParameter
INFO  2012-06-07 13:40:34 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.CardQuery: org.cmdbuild.servlets.utils.builder.CardQueryParameter
INFO  2012-06-07 13:40:34 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.ProcessQuery: org.cmdbuild.servlets.utils.builder.ProcessQueryParameter
INFO  2012-06-07 13:40:34 [cmdbuild] Builder for org.w3c.dom.Document: org.cmdbuild.servlets.utils.builder.XMLDocumentBuilder
INFO  2012-06-07 13:40:34 [cmdbuild] Builder for org.cmdbuild.services.auth.UserContext: org.cmdbuild.servlets.utils.builder.UserContextParameter
INFO  2012-06-07 13:40:34 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.ITableFactory: org.cmdbuild.servlets.utils.builder.factory.TableFactoryParameter
INFO  2012-06-07 13:40:34 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.DomainFactory: org.cmdbuild.servlets.utils.builder.factory.DomainFactoryParameter
INFO  2012-06-07 13:40:34 [cmdbuild] Builder for org.cmdbuild.elements.interfaces.RelationFactory: org.cmdbuild.servlets.utils.builder.factory.RelationFactoryParameter
INFO  2012-06-07 13:40:34 [cmdbuild] Loading scheduled jobs
WARN  2012-06-07 13:40:34 [cmdbuild] Could not load the scheduled jobs: first start or patch not yet applied?
INFO  2012-06-07 13:41:26 [jsonrpc ] Calling url /utils/gettranslationobject
INFO  2012-06-07 13:41:28 [jsonrpc ] Calling url /utils/listavailabletranslations
INFO  2012-06-07 13:42:03 [jsonrpc ] Calling url /configure/testconnection
ERROR 2012-06-07 13:42:03 [jsonrpc ] A java.lang.NoClassDefFoundError occurred calling method class org.cmdbuild.servlets.json.Configure.testConnection: org/postgresql/ds/PGSimpleDataSource
INFO  2012-06-07 13:42:17 [jsonrpc ] Calling url /configure/testconnection
ERROR 2012-06-07 13:42:17 [jsonrpc ] A java.lang.NoClassDefFoundError occurred calling method class org.cmdbuild.servlets.json.Configure.testConnection: org/postgresql/ds/PGSimpleDataSource

 

Please advice

From the error log it seems that PostgreSQL's JDBC driver can't be found in Tomcat. If you haven't done it yet, you should download it and put it in the "lib" directory in Tomcat. This is the official download link: http://jdbc.postgresql.org/download/postgresql-9.1-902.jdbc4.jar
 
Paolo