Hi,
I have having an issue installing Suitecrm Analytics. The error message suggests that there incorrect credentials in the install.properties file but I have repeatedly checked these.
Below I have pasted the message from the command line.
[root@185 suitecrm-data-integration-server]# ./setup-suitecrm-data-integration.sh
We are about to setup SuiteCRM Analytics Data Integration version 1.4
Make sure you have configured the install.properties correctly
*** IMPORTANT! *** Running this setup will discard any previous installations!
Have you configured install.properties? [y/N] y
Installing…
Checking database Connections…
We could not establish a connection to the SuiteCRM database!
Please check the JDBC connection properties and run setup again.
The Setup has FAILED! - Please check for any errors in the log files inside the logs directory!
BEGIN ERROR MESSAGE
2022/06/20 16:26:39 - Check Source DB - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : Cannot connect to database [SuiteCRM] (connection [SuiteCRM]). Exception : [org.pentaho.di.core.exception.KettleDatabaseException:
2022/06/20 16:26:39 - Check Source DB - Error occurred while trying to connect to the database
2022/06/20 16:26:39 - Check Source DB - Access denied for user ‘MY_DB_USERNAME’@‘localhost’ (using password: YES)
2022/06/20 16:26:39 - Check Source DB - ]
The entry from the log file is as follows: -
2022/06/20 16:26:39 - - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : ETL LOG START
2022/06/20 16:26:39 - Check Source DB - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : Cannot connect to database [SuiteCRM] (connection [SuiteCRM]). Exception : [org.pentaho.di.core.exception.KettleDatabaseException:
2022/06/20 16:26:39 - Check Source DB - Error occurred while trying to connect to the database
2022/06/20 16:26:39 - Check Source DB - Access denied for user ‘MY_DB_USERNAME’@‘localhost’ (using password: YES)
2022/06/20 16:26:39 - Check Source DB - ]
2022/06/20 16:26:39 - - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : ETL LOG END
2022/06/20 16:26:39 - Abort job - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : Aborting job.
2022/06/20 16:26:39 - Kitchen - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : Finished with errors
Please can someone advise on what I may be missing here to solve the issue?
Many thanks