Make a quick vote 🗳 ️How do you refer to SuiteCRM extensions: add-ons or plug-ins? Click here to have your say 👈

Cannot connect to DB with Suitecrm Analytics data integration script

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