fix: add allowPublicKeyRetrieval to OMS datasource for MySQL 8.0 compat

slayerjain · slayerjain · commit fba5561b70e1 · 2026-03-20T21:39:03.000+05:30
MySQL 8.0 uses caching_sha2_password by default, which requires
allowPublicKeyRetrieval=true when useSSL=false. The handshake matching
test still works because the two pools differ in username and database.
diff --git a/mysql-dual-conn/src/main/resources/application.properties b/mysql-dual-conn/src/main/resources/application.properties
@@ -1,14 +1,14 @@
 server.port=8080
 
 # --- OMS DataSource (primary) ---
-datasource.oms.jdbc-url=jdbc:mysql://localhost:3306/myntra_oms?useSSL=false
+datasource.oms.jdbc-url=jdbc:mysql://localhost:3306/myntra_oms?useSSL=false&allowPublicKeyRetrieval=true
 datasource.oms.username=omsAppUser
 datasource.oms.password=omsPassword
 datasource.oms.driver-class-name=com.mysql.cj.jdbc.Driver
 
-# --- Camunda DataSource (secondary, different user & capability flags) ---
-# allowPublicKeyRetrieval=true causes different MySQL capability flags,
-# which is the key condition that triggers the multi-handshake matching bug.
+# --- Camunda DataSource (secondary, different user & database) ---
+# Different username + database is the key condition that triggers the
+# multi-handshake matching bug during Keploy replay.
 datasource.camunda.jdbc-url=jdbc:mysql://localhost:3306/camunda?useSSL=false&allowPublicKeyRetrieval=true
 datasource.camunda.username=stagebuster
 datasource.camunda.password=camundaPassword
