Configuring MySql as secondary database

Hi there,

We have a self-managed environment, and we have Oracle as our primary database. Currently, we are trying to configure MySql as a secondary database and we follow the steps on this link: https://docs.appian.com/suite/help/20.4/Configuring_Relational_Databases.html#provide-data-source-connection-information.

Performed steps:

1. install mysql-connector-java-8.0.23-1.el7.noarch.rpm in the <REPO_HOME>/tomcat/apache-tomcat/lib/. for this we moved the rpm file and runed the rpm -ivh command  to install.

2. we updated the <REPO_HOME>/conf/tomcatResources.xml.<ENVIRONMENT> file just adding the configuration for MySql 

<Resource name="jdbc/AppianPrimary"
	factory="com.appiancorp.tomcat.datasource.EncodedPasswordDataSourceFactory"
	type="javax.sql.DataSource"
	driverClassName="oracle.jdbc.OracleDriver"
	url="jdbc:oracle:thin:@oracle_server.example.com:1521:ORACLE_FOR_APPIAN"
	username="your_plaintext_username"
	password="your_encoded_password"
	initialSize="5"
	maxActive="200"
	defaultTransactionIsolation="READ_COMMITTED"
	maxWait="30000"
	minIdle="5"
	minEvictableIdleTimeMillis="90000"
	timeBetweenEvictionRunsMillis="450000"
	validationQuery="select 1 from dual"
	testOnBorrow="true"
/>

<Resource name="jdbc/MySqlDataSource"
	factory="com.appiancorp.tomcat.datasource.EncodedPasswordDataSourceFactory"
	type="javax.sql.DataSource"
	driverClassName="com.mysql.jdbc.Driver"
	url="jdbc:mysql://such_as_server.example.com:3306/such_as_mySQL_for_appian?useOldAliasMetadataBehavior=true"
	username="your_plaintext_username"
	password="your_encoded_password"
	initialSize="5"
	maxActive="200"
	defaultTransactionIsolation="READ_COMMITTED"
	maxWait="30000"
	minIdle="5"
	minEvictableIdleTimeMillis="90000"
	timeBetweenEvictionRunsMillis="450000"
	validationQuery="SELECT 1"
	testOnBorrow="true"
/>

3. Tryed to cerate data source from the Administration Console but we got this error "Error creating datasource"

Can anyone help to identify if we missed something in the above steps?