This is an automated email from the ASF dual-hosted git repository.
yasith pushed a commit to branch change-mysql-connector
in repository https://gitbox.apache.org/repos/asf/airavata.git
commit 6f1b0b1f8c66926a4033df65c20cf58687e34174
Author: yasithdev <yasit...@icloud.com>
AuthorDate: Wed Jul 2 15:14:07 2025 -0500
update from mysql-connector-java:5 (vulnerable) to mysql-connector-j:9
---
dev-tools/ansible/inventories/scigap/develop/group_vars/all/vars.yml | 2 +-
dev-tools/ansible/inventories/standalone/group_vars/all/vars.yml | 2 +-
dev-tools/ansible/inventories/template/group_vars/all/vars.yml | 2 +-
dev-tools/ansible/roles/keycloak/defaults/main.yml | 2 +-
pom.xml | 4 ++--
5 files changed, 6 insertions(+), 6 deletions(-)
diff --git
a/dev-tools/ansible/inventories/scigap/develop/group_vars/all/vars.yml
b/dev-tools/ansible/inventories/scigap/develop/group_vars/all/vars.yml
index c5a85fa76b..bd011ad76c 100644
--- a/dev-tools/ansible/inventories/scigap/develop/group_vars/all/vars.yml
+++ b/dev-tools/ansible/inventories/scigap/develop/group_vars/all/vars.yml
@@ -53,7 +53,7 @@ profile_service: "profile_service"
django_db_username: "django"
django_db_password: "{{ vault_db_password }}"
-mysql_connector_jar: "mysql-connector-java-5.1.37-bin.jar"
+mysql_connector_jar: "mysql-connector-j-9.3.0-bin.jar"
# Rabbitmq related vareables
rabbitmq_server: "{{ groups['rabbitmq'][0] }}"
diff --git a/dev-tools/ansible/inventories/standalone/group_vars/all/vars.yml
b/dev-tools/ansible/inventories/standalone/group_vars/all/vars.yml
index d1645bb21f..3c7bb56a57 100644
--- a/dev-tools/ansible/inventories/standalone/group_vars/all/vars.yml
+++ b/dev-tools/ansible/inventories/standalone/group_vars/all/vars.yml
@@ -54,7 +54,7 @@ workflow_catalog: "workflow_catalog"
credential_store: "credential_store"
profile_service: "profile_service"
-mysql_connector_jar: "mysql-connector-java-5.1.37-bin.jar"
+mysql_connector_jar: "mysql-connector-j-9.3.0-bin.jar"
# Rabbitmq related vareables
rabbitmq_server: "{{ groups['rabbitmq'][0] }}"
diff --git a/dev-tools/ansible/inventories/template/group_vars/all/vars.yml
b/dev-tools/ansible/inventories/template/group_vars/all/vars.yml
index 240f2056d6..9b26e525c4 100644
--- a/dev-tools/ansible/inventories/template/group_vars/all/vars.yml
+++ b/dev-tools/ansible/inventories/template/group_vars/all/vars.yml
@@ -54,7 +54,7 @@ workflow_catalog: "workflow_catalog"
credential_store: "credential_store"
profile_service: "profile_service"
-mysql_connector_jar: "mysql-connector-java-5.1.37-bin.jar"
+mysql_connector_jar: "mysql-connector-j-9.3.0-bin.jar"
# Rabbitmq related vareables
rabbitmq_server: "{{ groups['rabbitmq'][0] }}"
diff --git a/dev-tools/ansible/roles/keycloak/defaults/main.yml
b/dev-tools/ansible/roles/keycloak/defaults/main.yml
index 42cb80903f..e8d8d2bf83 100644
--- a/dev-tools/ansible/roles/keycloak/defaults/main.yml
+++ b/dev-tools/ansible/roles/keycloak/defaults/main.yml
@@ -22,7 +22,7 @@
keycloak_version: "2.5.4.Final"
keycloak_downlaod_url:
"https://downloads.jboss.org/keycloak/{{keycloak_version}}/keycloak-{{keycloak_version}}.tar.gz";
keycloak_install_dir: "keycloak-{{keycloak_version}}"
-keycloak_db_connector_name: "mysql-connector-java-5.1.41"
+keycloak_db_connector_name: "mysql-connector-j-9.3.0-bin.jar"
# keycloak_ssl_keystore_file: "airavata.jks"
# keycloak_ssl_keystore_file_name: "airavata.jks"
# keycloak_ssl_keystore_password: "Airavata"
diff --git a/pom.xml b/pom.xml
index 03953a17d5..8cfa03d10d 100644
--- a/pom.xml
+++ b/pom.xml
@@ -322,8 +322,8 @@ under the License.
<!-- Database -->
<dependency>
<groupId>mysql</groupId>
- <artifactId>mysql-connector-java</artifactId>
- <version>8.0.31</version>
+ <artifactId>mysql-connector-j</artifactId>
+ <version>9.3.0</version>
</dependency>
<dependency>
<groupId>org.mariadb.jdbc</groupId>
