KB Article #182115
Error while getting a database connection Public Key Retrieval is not allowed
Problem
--When you try to install B2Bi with MySQL DB you can receive the following error related with the connection to the DB
--022-04-12 00:15:41,604 - FATAL [Startup] (ClusterMaintenanceManager) - Fatal error while performing schema maintenance java.sql.SQLSyntaxErrorException: Table 'InstalledComponents' already exists
Resolution
* To solved the issue, you will need to add this variable -> "allowPublicKeyRetrieval=true" in datastoreconfig.xml (<B2Bi_install_directory>/Interchange/conf) :
*<ConnectionURL>jdbc:mysql://{Host}:{Port}/{DatabaseName} zeroDateTimeBehavior=convertToNull&connectTimeout=300000&socketTimeout=300000&allowPublicKeyRetrieval=true&useSSL=false</ConnectionURL>