Hello I am trying to install the CMDBuild Ready2Use via GUI on Linux (Ubuntu 20.04), I have all the require software listed: PostgreSQL10, Open JDK11, PGIS 2.5. When I click on the “Test Config” , its says “config is OK”.
But when I click “INSTALL”, after some seconds of “loading database demo.dump.xz”, I get : “installation error: org.cmdbuild.dao.DAOException: Error while configuring the database”.
Meanwhile, the terminal outputs these error messages:
#Mon Jan 25 16:32:36 EST 2021
db.admin.password=postgres
db.password=cmdbuild
db.username=cmdbuild
db.admin.username=postgres
db.url=jdbc:postgresql://localhost:5432/cmdbuild_7732
16:32:40.673 INFO o.c.u.tomcatmanager.TomcatBuilder - buildTomcat END
create database cmdbuild_7732 demo.dump.xz
16:32:43.847 INFO o.c.dao.config.inner.DatabaseCreator - create database = jdbc:postgresql://localhost:5432/cmdbuild_7732 from source = demo.dump.xz
16:32:43.848 INFO o.c.dao.config.inner.DatabaseCreator - checking database
16:32:48.919 INFO o.c.dao.config.inner.DatabaseCreator - database not found: org.postgresql.util.PSQLException: FATAL: password authentication failed for user “cmdbuild”
16:32:48.919 INFO o.c.dao.config.inner.DatabaseCreator - Creating database cmdbuild_7732
16:32:49.026 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:207)
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:834)
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is org.postgresql.util.PSQLException: FATAL: password authentication failed for user “postgres”
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:371)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:418)
at org.cmdbuild.dao.config.inner.DatabaseCreator.createDatabase(DatabaseCreator.java:321)
at org.cmdbuild.dao.config.inner.DatabaseCreator.configureDatabase(DatabaseCreator.java:176)
… 5 common frames omitted
Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user “postgres”
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:514)
at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:141)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:192)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.(PgConnection.java:195)
at org.postgresql.Driver.makeConnection(Driver.java:454)
at org.postgresql.Driver.connect(Driver.java:256)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:94)
at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:79)
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:158)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:116)
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)
… 9 common frames omitted
I was able to confirm that Tomcat 9.0.31 was installed successfully during the process. But I am not sure why this error occurs or how to fix it and finally complete the installation process.
Any help or direction would be greatly appreciated.
Thanks!