CMDBuild Forum

CMDBuild 3.1 installation on windows

Systems Engineering
#1

Windows 2016, JDK 1.8, Tomcat 8.5.43, PostgreSQL 10

My step:

1. Extract cmdbuild-3.1.war, then place it to <TOMCAT>\webapps\cmdbuild.

2. Copy <TOMCAT>\webapps\cmdbuild\WEB-INF\conf\database.conf_example to <TOMCAT>\conf\database.conf.

3. Configure database.conf.

4. Create demo DB using command shown below with error

    .\cmdbuild -v dbconfig create demo -configfile D:\CMDBuild\apache-tomcat\conf\cmdbuild\database.conf

    16:14:41.162 DEBUG org.cmdbuild.utils.cli.Main - running from war dir = D:\CMDBuild\apache-tomcat\webapps\cmdbuild

    16:14:41.182 DEBUG o.c.u.c.c.DbconfigCommandRunner - using config file = D:\CMDBuild\apache-tomcat\conf\cmdbuild\database.conf

    create database cmdbuild demo

    16:14:41.590 INFO  o.c.dao.config.inner.DatabaseCreator - create database = jdbc:postgresql://localhost:5432/cmdbuild from source = demo

    16:14:41.592 INFO  o.c.dao.config.inner.DatabaseCreator - checking database

    Exception in thread "main" java.lang.NoClassDefFoundError: org/postgresql/ds/PGSimpleDataSource

            at org.cmdbuild.dao.config.inner.DatabaseCreator.getCmdbuildDataSource(DatabaseCreator.java:125)

            at org.cmdbuild.dao.config.inner.DatabaseCreator.cmdbuildDatabaseExists(DatabaseCreator.java:146)

            at org.cmdbuild.dao.config.inner.DatabaseCreator.configureDatabase(DatabaseCreator.java:173)

            at org.cmdbuild.utils.cli.utils.DatabaseUtils.createDatabase(DatabaseUtils.java:59)

            at org.cmdbuild.utils.cli.commands.DbconfigCommandRunner.lambda$createDatabase$4(DbconfigCommandRunner.java:267)

            at org.cmdbuild.utils.cli.commands.DbconfigCommandRunner.doWithDbFile(DbconfigCommandRunner.java:296)

            at org.cmdbuild.utils.cli.commands.DbconfigCommandRunner.createDatabase(DbconfigCommandRunner.java:254)

            at org.cmdbuild.utils.cli.commands.DbconfigCommandRunner.createDatabase(DbconfigCommandRunner.java:226)

            at org.cmdbuild.utils.cli.commands.DbconfigCommandRunner.exec(DbconfigCommandRunner.java:111)

            at org.cmdbuild.utils.cli.commands.AbstractCommandRunner.exec(AbstractCommandRunner.java:62)

            at org.cmdbuild.utils.cli.Main.runMain(Main.java:110)

            at org.cmdbuild.utils.cli.Main.main(Main.java:53)

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

            at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

            at java.lang.reflect.Method.invoke(Unknown Source)

            at org.cmdbuild.webapp.cli.Main.runCli(Main.java:98)

            at org.cmdbuild.webapp.cli.Main.main(Main.java:76)

    Caused by: java.lang.ClassNotFoundException: org.postgresql.ds.PGSimpleDataSource

            at java.net.URLClassLoader.findClass(Unknown Source)

            at java.lang.ClassLoader.loadClass(Unknown Source)

            at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)

            at java.lang.ClassLoader.loadClass(Unknown Source)

            ... 18 more

Could you please help me to solve the problem?

Thanks, Neil Lyu.

 

#2
Hi,
 
-Check if the postgr
 
Sid
 
Previously DONGHUI wrote:

Windows 2016, JDK 1.8, Tomcat 8.5.43, PostgreSQL 10

My step:

1. Extract cmdbuild-3.1.war, then place it to <TOMCAT> webapps

2. Copy <TOMCAT> webapps cddbuild WEB-INF ap database.conf_example to <TOMCAT> conf

3. Configure database.conf.

4. Create demo DB using command shown below with error

    buildd -d dbconfig create demo -configfile D: CMDBuild apache-tomcat cdbuild database.conf

    16: 14: 41.162 DEBUG org.cmdbuild.utils.cli.Main - running from war dir = D: CMDBuild apache-tomcat apps app

    16: 14: 41.182 DEBUG ocuccDbconfigCommandRunner - using config file = D: CMDBuild apache-tomcat cdbuild database.conf

    create database cmdbuild demo

    16: 14: 41.590 INFO ocdao.config.inner.DatabaseCreator - create database = jdbc: postgresql: // localhost: 5432 / cmdbuild from source = demo

    16: 14: 41.592 INFO ocdao.config.inner.DatabaseCreator - checking database

    Exception in thread "main" java.lang.NoClassDefFoundError: org / postgresql / ds / PGSimpleDataSource

            at org.cmdbuild.dao.config.inner.DatabaseCreator.getCmdbuildDataSource (DatabaseCreator.java:125)

            at org.cmdbuild.dao.config.inner.DatabaseCreator.cmdbuildDatabaseExists (DatabaseCreator.java:146)

            at org.cmdbuild.dao.config.inner.DatabaseCreator.configureDatabase (DatabaseCreator.java:173)

            at org.cmdbuild.utils.cli.utils.DatabaseUtils.createDatabase (DatabaseUtils.java:59)

            at org.cmdbuild.utils.cli.commands.DbconfigCommandRunner.lambda $ createDatabase $ 4 (DbconfigCommandRunner.java:267)

            at org.cmdbuild.utils.cli.commands.DbconfigCommandRunner.doWithDbFile (DbconfigCommandRunner.java:296)

            at org.cmdbuild.utils.cli.commands.DbconfigCommandRunner.createDatabase (DbconfigCommandRunner.java:254)

            at org.cmdbuild.utils.cli.commands.DbconfigCommandRunner.createDatabase (DbconfigCommandRunner.java:226)

            at org.cmdbuild.utils.cli.commands.DbconfigCommandRunner.exec (DbconfigCommandRunner.java:111)

            at org.cmdbuild.utils.cli.commands.AbstractCommandRunner.exec (AbstractCommandRunner.java:62)

            at org.cmdbuild.utils.cli.Main.runMain (Main.java:110)

            at org.cmdbuild.utils.cli.Main.main (Main.java:53)

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

            at sun.reflect.NativeMethodAccessorImpl.invoke (Unknown Source)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke (Unknown Source)

            at java.lang.reflect.Method.invoke (Unknown Source)

            at org.cmdbuild.webapp.cli.Main.runCli (Main.java:98)

            at org.cmdbuild.webapp.cli.Main.main (Main.java:76)

    Caused by: java.lang.ClassNotFoundException: org.postgresql.ds.PGSimpleDataSource

            at java.net.URLClassLoader.findClass (Unknown Source)

            at java.lang.ClassLoader.loadClass (Unknown Source)

            at sun.misc.Launcher $ AppClassLoader.loadClass (Unknown Source)

            at java.lang.ClassLoader.loadClass (Unknown Source)

            ... 18 more

Could you please help me to solve the problem?

Thanks, Neil Lyu.

 

 

#3

The Postgresql JDBC jar in the WAR download (web-inf/lib folder) is disabled (.jar_disabled), and must be renamed to .jar, to move past this error.

1 Like