CMDBuild Forum

CDMBuild 3.0 installation on windows

Systems Engineering
#1
 
Bumping into database related error attempting to install CDMBuild 3.0 on Windows
 
20:42:12.318 [AWT-EventQueue-0] WARN  o.c.utils.gui.GuiCommandRunner - invalid config
java.lang.RuntimeException: unable to find working psql version for this postgres server
        at org.cmdbuild.utils.lang.CmExceptionUtils.runtime(CmExceptionUtils.java:44)
        at org.cmdbuild.utils.postgres.PostgresHelperImpl.runCommand(PostgresHelperImpl.java:302)
        at org.cmdbuild.utils.postgres.PostgresHelperImpl.executeQuery(PostgresHelperImpl.java:175)
        at org.cmdbuild.utils.postgres.PostgresHelperImpl.getServerVersion(PostgresHelperImpl.java:82)
        at org.cmdbuild.dao.config.inner.DatabaseCreatorConfigImpl.checkConfig(DatabaseCreatorConfigImpl.java:153)
        at org.cmdbuild.utils.gui.GuiCommandRunner$InstallHelper.prepareConfig(GuiCommandRunner.java:247)
        at org.cmdbuild.utils.gui.GuiCommandRunner$InstallHelper.testInstallConfig(GuiCommandRunner.java:274)
        at org.cmdbuild.utils.gui.GuiCommandRunner.lambda$buildInstallUi$6(GuiCommandRunner.java:202)
        at java.desktop/javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
        at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
        at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
        at java.desktop/javax.swing.DefaultButtonModel.setPressed(Unknown Source)
        at java.desktop/javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
        at java.desktop/java.awt.Component.processMouseEvent(Unknown Source)
        at java.desktop/javax.swing.JComponent.processMouseEvent(Unknown Source)
        at java.desktop/java.awt.Component.processEvent(Unknown Source)
        at java.desktop/java.awt.Container.processEvent(Unknown Source)
        at java.desktop/java.awt.Component.dispatchEventImpl(Unknown Source)
        at java.desktop/java.awt.Container.dispatchEventImpl(Unknown Source)
 
.....
 
Caused by: java.lang.UnsupportedOperationException: null
        at java.base/java.nio.file.Files.setPosixFilePermissions(Unknown Source)
        at org.cmdbuild.utils.postgres.PostgresHelperImpl$PostgresOperation.prepare(PostgresHelperImpl.java:343)
        at org.cmdbuild.utils.postgres.PostgresHelperImpl.runCommand(PostgresHelperImpl.java:309)
        at org.cmdbuild.utils.postgres.PostgresHelperImpl.executeQuery(PostgresHelperImpl.java:175)
        at org.cmdbuild.utils.postgres.PostgresHelperImpl.getServerVersion(PostgresHelperImpl.java:82)
        at org.cmdbuild.utils.postgres.PostgresHelperImpl.runCommand(PostgresHelperImpl.java:280)
        ... 42 common frames omitted
 
Looks like a runtime warning/error. 
Anyone managed to have a successful install on Windows ? Although it says invalid config, unable to figure out.
 
- MD Singh
 
#2

I have the same issue running PostGRE 9.6

#3

same thing with:

 
window 10 x64
JDK 1.8
Tomcat 9
 
but no problem with version 2.5.1
 
#4
Same here
Windows 2016, JDK 1.8, Tomcat 8.5.40, PostgreSQL 10
 
I had to edit the CMDBUILD.BAT file to be able to trigger the GUI, but I still got the same error
 
 
Previously Leon wrote:
same thing with:
 
window 10 x64
JDK 1.8
Tomcat 9
 
but no problem with version 2.5.1
 

 

#5

Previously MD wrote:

 
Bumping into database related error attempting to install CDMBuild 3.0 on Windows
 
20:42:12.318 [AWT-EventQueue-0] WARN  o.c.utils.gui.GuiCommandRunner - invalid config
java.lang.RuntimeException: unable to find working psql version for this postgres server
        at org.cmdbuild.utils.lang.CmExceptionUtils.runtime(CmExceptionUtils.java:44)
        at org.cmdbuild.utils.postgres.PostgresHelperImpl.runCommand(PostgresHelperImpl.java:302)
        at org.cmdbuild.utils.postgres.PostgresHelperImpl.executeQuery(PostgresHelperImpl.java:175)
        at org.cmdbuild.utils.postgres.PostgresHelperImpl.getServerVersion(PostgresHelperImpl.java:82)
        at org.cmdbuild.dao.config.inner.DatabaseCreatorConfigImpl.checkConfig(DatabaseCreatorConfigImpl.java:153)
        at org.cmdbuild.utils.gui.GuiCommandRunner$InstallHelper.prepareConfig(GuiCommandRunner.java:247)
        at org.cmdbuild.utils.gui.GuiCommandRunner$InstallHelper.testInstallConfig(GuiCommandRunner.java:274)
        at org.cmdbuild.utils.gui.GuiCommandRunner.lambda$buildInstallUi$6(GuiCommandRunner.java:202)
        at java.desktop/javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
        at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
        at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
        at java.desktop/javax.swing.DefaultButtonModel.setPressed(Unknown Source)
        at java.desktop/javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
        at java.desktop/java.awt.Component.processMouseEvent(Unknown Source)
        at java.desktop/javax.swing.JComponent.processMouseEvent(Unknown Source)
        at java.desktop/java.awt.Component.processEvent(Unknown Source)
        at java.desktop/java.awt.Container.processEvent(Unknown Source)
        at java.desktop/java.awt.Component.dispatchEventImpl(Unknown Source)
        at java.desktop/java.awt.Container.dispatchEventImpl(Unknown Source)
 
.....
 
Caused by: java.lang.UnsupportedOperationException: null
        at java.base/java.nio.file.Files.setPosixFilePermissions(Unknown Source)
        at org.cmdbuild.utils.postgres.PostgresHelperImpl$PostgresOperation.prepare(PostgresHelperImpl.java:343)
        at org.cmdbuild.utils.postgres.PostgresHelperImpl.runCommand(PostgresHelperImpl.java:309)
        at org.cmdbuild.utils.postgres.PostgresHelperImpl.executeQuery(PostgresHelperImpl.java:175)
        at org.cmdbuild.utils.postgres.PostgresHelperImpl.getServerVersion(PostgresHelperImpl.java:82)
        at org.cmdbuild.utils.postgres.PostgresHelperImpl.runCommand(PostgresHelperImpl.java:280)
        ... 42 common frames omitted
 
Looks like a runtime warning/error. 
Anyone managed to have a successful install on Windows ? Although it says invalid config, unable to figure out.
 
- MD Singh
 
Could you please provide us with the command you are running that generates the reported error?
Thanks,
CMDBuild Team
#6
This is from the BAT file, which I had to edit to be able to trigger the GUI
 
set WAR_DIR=%~dp0
set MY_CLASSPATH=%WAR_DIR%;%WAR_DIR%WEB-INF\lib\*
java -cp "%MY_CLASSPATH%" org.cmdbuild.webapp.cli.Main startedFromExploredWar "%WAR_DIR%" %*
 
Here's the GUI and the ensuing error.
https://imgur.com/Di5sfFU
 
Windows 2016, JDK 1.8, Tomcat 8.5.40, PostgreSQL 10
 
 
 
Previously Tecnoteca wrote:
Previously MD wrote:
 
Bumping into database related error attempting to install CDMBuild 3.0 on Windows
 
20:42:12.318 [AWT-EventQueue-0] WARN  o.c.utils.gui.GuiCommandRunner - invalid config
java.lang.RuntimeException: unable to find working psql version for this postgres server
        at org.cmdbuild.utils.lang.CmExceptionUtils.runtime(CmExceptionUtils.java:44)
        (... bunch of lines omitted)
 
Looks like a runtime warning/error. 
Anyone managed to have a successful install on Windows ? Although it says invalid config, unable to figure out.
 
- MD Singh
 
Could you please provide us with the command you are running that generates the reported error?
Thanks,
CMDBuild Team

 

#7

Previously A wrote:

This is from the BAT file, which I had to edit to be able to trigger the GUI
 
set WAR_DIR=%~dp0
set MY_CLASSPATH=%WAR_DIR%;%WAR_DIR%WEB-INF\lib\*
java -cp "%MY_CLASSPATH%" org.cmdbuild.webapp.cli.Main startedFromExploredWar "%WAR_DIR%" %*
 
Here's the GUI and the ensuing error.
https://imgur.com/Di5sfFU
 
Windows 2016, JDK 1.8, Tomcat 8.5.40, PostgreSQL 10
 
 
 
Previously Tecnoteca wrote:
Previously MD wrote:
 
Bumping into database related error attempting to install CDMBuild 3.0 on Windows
 
20:42:12.318 [AWT-EventQueue-0] WARN  o.c.utils.gui.GuiCommandRunner - invalid config
java.lang.RuntimeException: unable to find working psql version for this postgres server
        at org.cmdbuild.utils.lang.CmExceptionUtils.runtime(CmExceptionUtils.java:44)
        (... bunch of lines omitted)
 
Looks like a runtime warning/error. 
Anyone managed to have a successful install on Windows ? Although it says invalid config, unable to figure out.
 
- MD Singh
 
Could you please provide us with the command you are running that generates the reported error?
Thanks,
CMDBuild Team

 

Could you please try with Postgres version 9.5 and check if the error still appears?
Thanks, CMDBuild Team.
#8
Same error.  I believe that it is not able to find PSQL or connect to PostgreSQL as I don't see any connections attempts on Postgres logs.  I added PSQL path to Windows Environment Variables (Path).  I also edited the database.conf file.  Nada.  Is there any other variable like POSTGRES_HOME that needs to be set?  
 
 
Previously Tecnoteca wrote:
Previously A wrote:
This is from the BAT file, which I had to edit to be able to trigger the GUI
 
set WAR_DIR=%~dp0
set MY_CLASSPATH=%WAR_DIR%;%WAR_DIR%WEB-INF\lib\*
java -cp "%MY_CLASSPATH%" org.cmdbuild.webapp.cli.Main startedFromExploredWar "%WAR_DIR%" %*
 
Here's the GUI and the ensuing error.
 
Windows 2016, JDK 1.8, Tomcat 8.5.40, PostgreSQL 10
 
 
 
Previously Tecnoteca wrote:
Previously MD wrote:
 
Bumping into database related error attempting to install CDMBuild 3.0 on Windows
 
20:42:12.318 [AWT-EventQueue-0] WARN  o.c.utils.gui.GuiCommandRunner - invalid config
java.lang.RuntimeException: unable to find working psql version for this postgres server
        at org.cmdbuild.utils.lang.CmExceptionUtils.runtime(CmExceptionUtils.java:44)
        (... bunch of lines omitted)
 
Looks like a runtime warning/error. 
Anyone managed to have a successful install on Windows ? Although it says invalid config, unable to figure out.
 
- MD Singh
 
Could you please provide us with the command you are running that generates the reported error?
Thanks,
CMDBuild Team

 

Could you please try with Postgres version 9.5 and check if the error still appears?
Thanks, CMDBuild Team.

 

#9

i managed to install cmdbuild 3.0 on ubuntu 19.04 and windows 10 x64:

 
1. Ubuntu 19.04 plus pg11 plus openjdk8 plus maven installed properly
2. now you can run cmdbuild.sh and dump db
3. restart tomcat with proper configs (shark and database)
4. rock and roll...
 
a. backup the earlier dumped db to be restored on windows 10 x64 plus pg10 plus jdk1.8
b. modify the configs (database and shark)
c. restart tomcat
d. rock and roll...
 
C:\<tomcat9dir>\webapps\cmdbuild\WEB-INF\conf\database.conf
C:\<tomcat9dir>\webapps\shark\conf\shark.conf
 
hope this helps...
#10

Previously A wrote:

Same error.  I believe that it is not able to find PSQL or connect to PostgreSQL as I don't see any connections attempts on Postgres logs.  I added PSQL path to Windows Environment Variables (Path).  I also edited the database.conf file.  Nada.  Is there any other variable like POSTGRES_HOME that needs to be set?  
 
 
Previously Tecnoteca wrote:
Previously A wrote:
This is from the BAT file, which I had to edit to be able to trigger the GUI
 
set WAR_DIR=%~dp0
set MY_CLASSPATH=%WAR_DIR%;%WAR_DIR%WEB-INF\lib\*
java -cp "%MY_CLASSPATH%" org.cmdbuild.webapp.cli.Main startedFromExploredWar "%WAR_DIR%" %*
 
Here's the GUI and the ensuing error.
 
Windows 2016, JDK 1.8, Tomcat 8.5.40, PostgreSQL 10
 
 
 
Previously Tecnoteca wrote:
Previously MD wrote:
 
Bumping into database related error attempting to install CDMBuild 3.0 on Windows
 
20:42:12.318 [AWT-EventQueue-0] WARN  o.c.utils.gui.GuiCommandRunner - invalid config
java.lang.RuntimeException: unable to find working psql version for this postgres server
        at org.cmdbuild.utils.lang.CmExceptionUtils.runtime(CmExceptionUtils.java:44)
        (... bunch of lines omitted)
 
Looks like a runtime warning/error. 
Anyone managed to have a successful install on Windows ? Although it says invalid config, unable to figure out.
 
- MD Singh
 
Could you please provide us with the command you are running that generates the reported error?
Thanks,
CMDBuild Team

 

Could you please try with Postgres version 9.5 and check if the error still appears?
Thanks, CMDBuild Team.

 

Looking closely at the screenshot you have sent i've realized that there is a little bit of misunderstanding. You already extracted the .war file in a folder under tomcat webapps, technically that is the "installation" process required to setup CMDBuild. After doing that there is no need of launching the GUI because CMDBuild is already ready as a webapp, if you also configured the database.conf file to point at the postgres database you just need to restore or create a cmdbuild database via pg admin or any tool you like and you can startup tomcat to use the application.
CMDBuild Team.
#11

Previously Tecnoteca wrote:

 

Looking closely at the screenshot you have sent i've realized that there is a little bit of misunderstanding. You already extracted the .war file in a folder under tomcat webapps, technically that is the "installation" process required to setup CMDBuild. After doing that there is no need of launching the GUI because CMDBuild is already ready as a webapp, if you also configured the database.conf file to point at the postgres database you just need to restore or create a cmdbuild database via pg admin or any tool you like and you can startup tomcat to use the application.
CMDBuild Team.

 

 
Thanks to all those who posted more details. Had given up ....
With the additional details on this thread and some other managed to install cmdbuild successfully
 
For those downloading the war and extracting the same under say <TOMCAT>\webapps\cmdbuild
a) Configure database.conf under <TOMCAT>\conf\cmdbuild per the README under <TOMCAT>\webapps\cmdbuild\conf
b) Create demo DB using command shown below with expected output.
           C:\tomcat8.5.27\webapps\cmdbuild>.\cmdbuild.bat dbconfig create demo -configfile    C:\tomcat8.5.27\conf\cmdbuild\database.conf
           create database cmdb demo
           apply patches
           done
Give above some time to complete
 
Startup tomcat & login to ... CMDBuild!
 
- MD Singh
#12
Previously MD wrote:
Previously Tecnoteca wrote:

 

Looking closely at the screenshot you have sent i've realized that there is a little bit of misunderstanding. You already extracted the .war file in a folder under tomcat webapps, technically that is the "installation" process required to setup CMDBuild. After doing that there is no need of launching the GUI because CMDBuild is already ready as a webapp, if you also configured the database.conf file to point at the postgres database you just need to restore or create a cmdbuild database via pg admin or any tool you like and you can startup tomcat to use the application.
CMDBuild Team.

 

 
Thanks to all those who posted more details. Had given up ....
With the additional details on this thread and some other managed to install cmdbuild successfully
 
For those downloading the war and extracting the same under say <TOMCAT>\webapps\cmdbuild
a) Configure database.conf under <TOMCAT>\conf\cmdbuild per the README under <TOMCAT>\webapps\cmdbuild\conf
b) Create demo DB using command shown below with expected output.
           C:\tomcat8.5.27\webapps\cmdbuild>.\cmdbuild.bat dbconfig create demo -configfile    C:\tomcat8.5.27\conf\cmdbuild\database.conf
           create database cmdb demo
           apply patches
           done
Give above some time to complete
 
Startup tomcat & login to ... CMDBuild!
 
- MD Singh
 
 
Thanks MD, this worked for me
#13

Hi Leon,

Could you provide step by step deployment of CMDBuild? I am not really clear on dumping database, modifying configurations. Maybe some example would help.