I’m attempting to install CMDBuild and have gone through the steps from the technical manual but am running into an error where the autodetect isn’t finding Postgres libs, this is on Windows 10.
java.lang.RuntimeException: java.io.IOException: Cannot run program “psql.exe”: CreateProcess error=2, The system cannot find the file specified
at org.cmdbuild.utils.lang.CmExceptionUtils.toRuntimeException(CmExceptionUtils.java:102)
at org.cmdbuild.utils.lang.CmExceptionUtils.runtime(CmExceptionUtils.java:60)
at org.cmdbuild.utils.exec.CmProcessUtils.executeProcess(CmProcessUtils.java:84)
at org.cmdbuild.utils.exec.CmProcessUtils.executeProcess(CmProcessUtils.java:44)
at org.cmdbuild.utils.postgres.PgLibsUtils.getLibVersion(PgLibsUtils.java:86)
at org.cmdbuild.utils.postgres.PgLibsUtils.getPgLibs(PgLibsUtils.java:73)
at org.cmdbuild.utils.postgres.PostgresHelperImpl.(PostgresHelperImpl.java:82)
at org.cmdbuild.utils.postgres.PostgresHelperConfigImpl$PostgresHelperBuilder.buildHelper(PostgresHelperConfigImpl.java:222)
at org.cmdbuild.utils.postgres.PostgresUtils.dumpContainsSchema(PostgresUtils.java:55)
at org.cmdbuild.dao.config.inner.DatabaseCreator.restoreDump(DatabaseCreator.java:337)
at org.cmdbuild.dao.config.inner.DatabaseCreator.configureDatabase(DatabaseCreator.java:174)
at org.cmdbuild.utils.cli.utils.DatabaseUtils.createDatabase(DatabaseUtils.java:42)
at org.cmdbuild.utils.cli.utils.DatabaseUtils.createDatabase(DatabaseUtils.java:36)
at org.cmdbuild.utils.cli.utils.DatabaseUtils.createDatabase(DatabaseUtils.java:32)
at org.cmdbuild.utils.gui.GuiCommandRunner$InstallHelper.lambda$install$10(GuiCommandRunner.java:319)
at java.base/java.lang.Thread.run(Thread.java:1589)
Caused by: java.io.IOException: Cannot run program “psql.exe”: CreateProcess error=2, The system cannot find the file specified
at java.base/java.lang.ProcessBuilder.start(ProcessBuilder.java:1143)
at java.base/java.lang.ProcessBuilder.start(ProcessBuilder.java:1073)
at org.cmdbuild.utils.exec.CmProcessUtils.executeProcess(CmProcessUtils.java:58)
… 13 common frames omitted
Caused by: java.io.IOException: CreateProcess error=2, The system cannot find the file specified
at java.base/java.lang.ProcessImpl.create(Native Method)
at java.base/java.lang.ProcessImpl.(ProcessImpl.java:500)
at java.base/java.lang.ProcessImpl.start(ProcessImpl.java:159)
at java.base/java.lang.ProcessBuilder.start(ProcessBuilder.java:1110)
… 15 common frames omitted
07:38:03.662 ERROR o.c.utils.gui.GuiCommandRunner - error executing install
org.cmdbuild.dao.DaoException: Error while configuring the database
at org.cmdbuild.dao.config.inner.DatabaseCreator.configureDatabase(DatabaseCreator.java:190)
at org.cmdbuild.utils.cli.utils.DatabaseUtils.createDatabase(DatabaseUtils.java:42)
at org.cmdbuild.utils.cli.utils.DatabaseUtils.createDatabase(DatabaseUtils.java:36)
at org.cmdbuild.utils.cli.utils.DatabaseUtils.createDatabase(DatabaseUtils.java:32)
at org.cmdbuild.utils.gui.GuiCommandRunner$InstallHelper.lambda$install$10(GuiCommandRunner.java:319)
at java.base/java.lang.Thread.run(Thread.java:1589)
Caused by: org.cmdbuild.dao.DaoException: java.lang.IllegalArgumentException: CM: autodetect failed to find postgres libs on this system
at org.cmdbuild.dao.config.inner.DatabaseCreator.restoreDump(DatabaseCreator.java:394)
at org.cmdbuild.dao.config.inner.DatabaseCreator.configureDatabase(DatabaseCreator.java:174)
… 5 common frames omitted
Caused by: java.lang.IllegalArgumentException: CM: autodetect failed to find postgres libs on this system
at com.google.common.base.Preconditions.checkArgument(Preconditions.java:135)
at org.cmdbuild.utils.postgres.PgLibsUtils.getPgLibs(PgLibsUtils.java:77)
at org.cmdbuild.utils.postgres.PostgresHelperImpl.(PostgresHelperImpl.java:82)
at org.cmdbuild.utils.postgres.PostgresHelperConfigImpl$PostgresHelperBuilder.buildHelper(PostgresHelperConfigImpl.java:222)
at org.cmdbuild.utils.postgres.PostgresUtils.dumpContainsSchema(PostgresUtils.java:55)
at org.cmdbuild.dao.config.inner.DatabaseCreator.restoreDump(DatabaseCreator.java:337)
… 6 common frames omitted
I’ve installed Tomcat, Postgres 12 and the Java Runtime environment before this, but wondering if there are additional configuration steps I’ve missed somewhere before this. I’m wondering as well how it relates to the failure to find psql.exe and if there’s some simple thing I’m missing in regards to where it’s actually looking for these files.
Any help is greatly appreciated, thank you.