This is an automated email from the ASF dual-hosted git repository.
zhangliang pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new 46c19c6857c Refactor container user (#19643)
46c19c6857c is described below
commit 46c19c6857cd7ad94783eb30a80e6e63704cbcce
Author: 孙念君 Nianjun Sun <[email protected]>
AuthorDate: Fri Jul 29 14:19:56 2022 +0800
Refactor container user (#19643)
* Refactor : update the default user for storage conainer(#19613)
* Refactor : replace all mysql root user with test_user #(19613)
* Refactor : replace all PG postgres user with test_user #(19613)
* Refactor : remove useRootUsername #(19613)
* Refactor : refactor parameter variable #(19613)
* Refactor : remove the corrupt parameter #(19613)
* Fix : fix the param issue during merge conflict
* Refactor : grant test user the corresponding role for test
* Refactor : refactor the action step name
* Merge Master branch
---
.github/workflows/it.yml | 2 +-
.../atomic/storage/DockerStorageContainer.java | 17 +----
.../atomic/storage/StorageContainerFactory.java | 9 ++-
.../atomic/storage/impl/MySQLContainer.java | 12 +---
.../atomic/storage/impl/OpenGaussContainer.java | 13 +---
.../atomic/storage/impl/PostgreSQLContainer.java | 10 +--
.../container/init-sql/mysql/00-init-authority.sql | 2 +-
.../init-sql/opengauss/00-init-authority.sql | 4 +-
.../init-sql/oracle/00-init-authority.sql | 2 +-
.../init-sql/postgresql/00-init-authority.sql | 4 +-
.../init-sql/sqlserver/00-init-authority.sql | 2 +-
.../cases/general/CreateTableSQLGeneratorIT.java | 2 +-
.../container/compose/DockerComposedContainer.java | 2 +-
.../compose/mode/ClusterComposedContainer.java | 2 +-
.../compose/mode/StandaloneComposedContainer.java | 2 +-
.../scenario/db/proxy/conf/mysql/config-db.yaml | 40 +++++------
.../db/proxy/conf/postgresql/config-db.yaml | 40 +++++------
.../config-dbtbl-with-readwrite-splitting.yaml | 80 ++++++++++-----------
.../config-dbtbl-with-readwrite-splitting.yaml | 80 ++++++++++-----------
...dbtbl-with-readwrite-splitting-and-encrypt.yaml | 80 ++++++++++-----------
...dbtbl-with-readwrite-splitting-and-encrypt.yaml | 80 ++++++++++-----------
.../proxy/conf/mysql/config-empty-rules.yaml | 84 +++++++++++-----------
.../proxy/conf/postgresql/config-empty-rules.yaml | 84 +++++++++++-----------
.../encrypt/proxy/conf/mysql/config-encrypt.yaml | 4 +-
.../proxy/conf/postgresql/config-encrypt.yaml | 4 +-
.../conf/mysql/config-readwrite-splitting.yaml | 12 ++--
.../postgresql/config-readwrite-splitting.yaml | 12 ++--
.../shadow/proxy/conf/mysql/config-shadow.yaml | 8 +--
.../proxy/conf/postgresql/config-shadow.yaml | 8 +--
.../scenario/tbl/proxy/conf/mysql/config-tbl.yaml | 4 +-
.../tbl/proxy/conf/postgresql/config-tbl.yaml | 4 +-
31 files changed, 338 insertions(+), 371 deletions(-)
diff --git a/.github/workflows/it.yml b/.github/workflows/it.yml
index 5f31ac0ad78..76823a511bc 100644
--- a/.github/workflows/it.yml
+++ b/.github/workflows/it.yml
@@ -272,7 +272,7 @@ jobs:
runs-on: ubuntu-latest
steps:
- uses: actions/checkout@v2
- - name: Maven resolve ranges
+ - name: Maven Resolve Ranges
run: ./mvnw versions:resolve-ranges -ntp
-Dincludes='org.springframework:*,org.springframework.boot:*'
- name: Cache Maven Repos
uses: actions/cache@v2
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/DockerStorageContainer.java
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/DockerStorageContainer.java
index 2dc74f341cf..91e95863a39 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/DockerStorageContainer.java
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/DockerStorageContainer.java
@@ -50,18 +50,14 @@ public abstract class DockerStorageContainer extends
DockerITContainer implement
@Getter(AccessLevel.NONE)
private final String scenario;
- @Getter(AccessLevel.NONE)
- private final boolean useRootUsername;
-
private final Map<String, DataSource> actualDataSourceMap;
private final Map<String, DataSource> expectedDataSourceMap;
- public DockerStorageContainer(final DatabaseType databaseType, final
String dockerImageName, final String scenario, final boolean useRootUsername) {
+ public DockerStorageContainer(final DatabaseType databaseType, final
String dockerImageName, final String scenario) {
super(databaseType.getType().toLowerCase(), dockerImageName);
this.databaseType = databaseType;
this.scenario = scenario;
- this.useRootUsername = useRootUsername;
actualDataSourceMap = new LinkedHashMap<>();
expectedDataSourceMap = new LinkedHashMap<>();
}
@@ -114,16 +110,9 @@ public abstract class DockerStorageContainer extends
DockerITContainer implement
* @return username
*/
public final String getUsername() {
- return useRootUsername ? getRootUsername() : getNormalUsername();
+ return getNormalUsername();
}
- /**
- * Get root username.
- *
- * @return root username
- */
- public abstract String getRootUsername();
-
protected final String getNormalUsername() {
return "test_user";
}
@@ -141,7 +130,7 @@ public abstract class DockerStorageContainer extends
DockerITContainer implement
* @return unified database access password
*/
public final String getUnifiedPassword() {
- return "Root@123";
+ return "Test@123";
}
protected abstract Optional<String> getDefaultDatabaseName();
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/StorageContainerFactory.java
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/StorageContainerFactory.java
index 14ee92e68a9..a132967c3a1 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/StorageContainerFactory.java
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/StorageContainerFactory.java
@@ -37,17 +37,16 @@ public final class StorageContainerFactory {
* @param databaseType database type
* @param dockerImageName docker image name
* @param scenario scenario
- * @param useRootUsername use root username
* @return created instance
*/
- public static StorageContainer newInstance(final DatabaseType
databaseType, final String dockerImageName, final String scenario, final
boolean useRootUsername) {
+ public static StorageContainer newInstance(final DatabaseType
databaseType, final String dockerImageName, final String scenario) {
switch (databaseType.getType()) {
case "MySQL":
- return new MySQLContainer(dockerImageName, scenario,
useRootUsername);
+ return new MySQLContainer(dockerImageName, scenario);
case "PostgreSQL":
- return new PostgreSQLContainer(dockerImageName, scenario,
useRootUsername);
+ return new PostgreSQLContainer(dockerImageName, scenario);
case "openGauss":
- return new OpenGaussContainer(dockerImageName, scenario,
useRootUsername);
+ return new OpenGaussContainer(dockerImageName, scenario);
case "H2":
return new H2Container(scenario);
default:
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/MySQLContainer.java
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/MySQLContainer.java
index 26c58caf76f..bf84a6daff0 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/MySQLContainer.java
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/MySQLContainer.java
@@ -29,8 +29,8 @@ import java.util.Optional;
*/
public final class MySQLContainer extends DockerStorageContainer {
- public MySQLContainer(final String dockerImageName, final String scenario,
final boolean useRootUsername, final String... commandParts) {
- super(DatabaseTypeFactory.getInstance("MySQL"),
Strings.isNullOrEmpty(dockerImageName) ? "mysql/mysql-server:5.7" :
dockerImageName, scenario, useRootUsername);
+ public MySQLContainer(final String dockerImageName, final String scenario)
{
+ super(DatabaseTypeFactory.getInstance("MySQL"),
Strings.isNullOrEmpty(dockerImageName) ? "mysql/mysql-server:5.7" :
dockerImageName, scenario);
}
@Override
@@ -38,17 +38,11 @@ public final class MySQLContainer extends
DockerStorageContainer {
// TODO need auto set server-id by generator, now always set server-id
to 1
setCommand("--server-id=1");
addEnv("LANG", "C.UTF-8");
- addEnv("MYSQL_ROOT_PASSWORD", getUnifiedPassword());
- addEnv("MYSQL_ROOT_HOST", "%");
+ addEnv("MYSQL_RANDOM_ROOT_PASSWORD", "yes");
withClasspathResourceMapping("/env/mysql/my.cnf", "/etc/mysql/my.cnf",
BindMode.READ_ONLY);
super.configure();
}
- @Override
- public String getRootUsername() {
- return "root";
- }
-
@Override
public int getPort() {
return 3306;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/OpenGaussContainer.java
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/OpenGaussContainer.java
index 6a5ae35e14f..5cce5d88323 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/OpenGaussContainer.java
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/OpenGaussContainer.java
@@ -22,8 +22,6 @@ import
org.apache.shardingsphere.infra.database.type.DatabaseTypeFactory;
import
org.apache.shardingsphere.test.integration.env.container.atomic.storage.DockerStorageContainer;
import org.testcontainers.containers.BindMode;
-import java.util.LinkedList;
-import java.util.List;
import java.util.Optional;
/**
@@ -31,14 +29,12 @@ import java.util.Optional;
*/
public final class OpenGaussContainer extends DockerStorageContainer {
- public OpenGaussContainer(final String dockerImageName, final String
scenario, final boolean useRootUsername, final String... commandParts) {
- super(DatabaseTypeFactory.getInstance("openGauss"),
Strings.isNullOrEmpty(dockerImageName) ? "enmotech/opengauss:3.0.0" :
dockerImageName, scenario, useRootUsername);
+ public OpenGaussContainer(final String dockerImageName, final String
scenario) {
+ super(DatabaseTypeFactory.getInstance("openGauss"),
Strings.isNullOrEmpty(dockerImageName) ? "enmotech/opengauss:3.0.0" :
dockerImageName, scenario);
}
@Override
protected void configure() {
- List<String> commandParts = new LinkedList<>();
- setCommand(commandParts.toArray(new String[0]));
addEnv("GS_PASSWORD", getUnifiedPassword());
withClasspathResourceMapping("/env/postgresql/postgresql.conf",
"/usr/local/opengauss/share/postgresql/postgresql.conf.sample",
BindMode.READ_ONLY);
withClasspathResourceMapping("/env/opengauss/pg_hba.conf",
"/usr/local/opengauss/share/postgresql/pg_hba.conf.sample", BindMode.READ_ONLY);
@@ -46,11 +42,6 @@ public final class OpenGaussContainer extends
DockerStorageContainer {
super.configure();
}
- @Override
- public String getRootUsername() {
- return "root";
- }
-
@Override
public int getPort() {
return 5432;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/PostgreSQLContainer.java
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/PostgreSQLContainer.java
index c8288ca757d..d32a67b9bf6 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/PostgreSQLContainer.java
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/PostgreSQLContainer.java
@@ -29,24 +29,18 @@ import java.util.Optional;
*/
public final class PostgreSQLContainer extends DockerStorageContainer {
- public PostgreSQLContainer(final String dockerImageName, final String
scenario, final boolean useRootUsername) {
- super(DatabaseTypeFactory.getInstance("PostgreSQL"),
Strings.isNullOrEmpty(dockerImageName) ? "postgres:12-alpine" :
dockerImageName, scenario, useRootUsername);
+ public PostgreSQLContainer(final String dockerImageName, final String
scenario) {
+ super(DatabaseTypeFactory.getInstance("PostgreSQL"),
Strings.isNullOrEmpty(dockerImageName) ? "postgres:12-alpine" :
dockerImageName, scenario);
}
@Override
protected void configure() {
- addEnv("POSTGRES_USER", getRootUsername());
addEnv("POSTGRES_PASSWORD", getUnifiedPassword());
withClasspathResourceMapping("/env/postgresql/postgresql.conf",
"/etc/postgresql/postgresql.conf", BindMode.READ_ONLY);
setCommand("-c config_file=/etc/postgresql/postgresql.conf");
super.configure();
}
- @Override
- public String getRootUsername() {
- return "root";
- }
-
@Override
public int getPort() {
return 5432;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/mysql/00-init-authority.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/mysql/00-init-authority.sql
index f54e95a7dc8..fa57a26c931 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/mysql/00-init-authority.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/mysql/00-init-authority.sql
@@ -15,5 +15,5 @@
-- limitations under the License.
--
-CREATE USER IF NOT EXISTS 'test_user'@'%' IDENTIFIED BY 'Root@123';
+CREATE USER IF NOT EXISTS 'test_user'@'%' IDENTIFIED BY 'Test@123';
GRANT ALL ON *.* TO 'test_user'@'%';
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/opengauss/00-init-authority.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/opengauss/00-init-authority.sql
index 7305a5e0f83..6aff8379dc4 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/opengauss/00-init-authority.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/opengauss/00-init-authority.sql
@@ -15,6 +15,6 @@
-- limitations under the License.
--
-CREATE USER test_user WITH ENCRYPTED PASSWORD 'Root@123';
-ALTER ROLE test_user CREATEDB REPLICATION;
+CREATE USER test_user WITH ENCRYPTED PASSWORD 'Test@123';
+ALTER ROLE test_user Superuser;
CREATE DATABASE test_user;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/oracle/00-init-authority.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/oracle/00-init-authority.sql
index 5e3cbcfce44..c7b115b40da 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/oracle/00-init-authority.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/oracle/00-init-authority.sql
@@ -15,5 +15,5 @@
-- limitations under the License.
--
-CREATE USER 'test_user'@'%' IDENTIFIED BY 'Root@123';
+CREATE USER 'test_user'@'%' IDENTIFIED BY 'Test@123';
GRANT ALL PRIVILEGES ON *.* TO 'test_user'@'%';
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/postgresql/00-init-authority.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/postgresql/00-init-authority.sql
index 7305a5e0f83..6aff8379dc4 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/postgresql/00-init-authority.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/postgresql/00-init-authority.sql
@@ -15,6 +15,6 @@
-- limitations under the License.
--
-CREATE USER test_user WITH ENCRYPTED PASSWORD 'Root@123';
-ALTER ROLE test_user CREATEDB REPLICATION;
+CREATE USER test_user WITH ENCRYPTED PASSWORD 'Test@123';
+ALTER ROLE test_user Superuser;
CREATE DATABASE test_user;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/sqlserver/00-init-authority.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/sqlserver/00-init-authority.sql
index f5402c90c4a..5f266e09748 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/sqlserver/00-init-authority.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/sqlserver/00-init-authority.sql
@@ -15,5 +15,5 @@
-- limitations under the License.
--
-CREATE USER 'test_user'@'%' IDENTIFIED BY 'Root@123';
+CREATE USER 'test_user'@'%' IDENTIFIED BY 'Test@123';
GRANT ALL ON *.* TO 'test_user'@'%';
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/java/org/apache/shardingsphere/integration/data/pipeline/cases/general/CreateTableSQLGeneratorIT.java
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/java/org/apache/shardingsphere/integration/data/pipeline/cases/general/CreateTableSQLGeneratorIT.java
index 20e2a04edaf..ce3f86cff4a 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/java/org/apache/shardingsphere/integration/data/pipeline/cases/general/CreateTableSQLGeneratorIT.java
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/java/org/apache/shardingsphere/integration/data/pipeline/cases/general/CreateTableSQLGeneratorIT.java
@@ -79,7 +79,7 @@ public final class CreateTableSQLGeneratorIT {
this.parameterized = parameterized;
rootEntity = JAXB.unmarshal(
Objects.requireNonNull(CreateTableSQLGeneratorIT.class.getClassLoader().getResource(parameterized.getScenario())),
CreateTableSQLGeneratorAssertionsRootEntity.class);
- storageContainer = (DockerStorageContainer)
StorageContainerFactory.newInstance(parameterized.getDatabaseType(),
parameterized.getDockerImageName(), "", false);
+ storageContainer = (DockerStorageContainer)
StorageContainerFactory.newInstance(parameterized.getDatabaseType(),
parameterized.getDockerImageName(), "");
storageContainer.start();
}
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/java/org/apache/shardingsphere/integration/data/pipeline/framework/container/compose/DockerComposedContainer.java
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/java/org/apache/shardingsphere/integration/data/pipeline/framework/container/compose/DockerComposedContainer.java
index 4fb2b3e0ec7..118e8d48e41 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/java/org/apache/shardingsphere/integration/data/pipeline/framework/container/compose/DockerComposedContainer.java
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/java/org/apache/shardingsphere/integration/data/pipeline/framework/container/compose/DockerComposedContainer.java
@@ -41,7 +41,7 @@ public final class DockerComposedContainer extends
BaseComposedContainer {
public DockerComposedContainer(final DatabaseType databaseType, final
String dockerImageName) {
this.databaseType = databaseType;
GovernanceContainer governanceContainer =
getContainers().registerContainer(new ZookeeperContainer());
- storageContainer =
getContainers().registerContainer((DockerStorageContainer)
StorageContainerFactory.newInstance(databaseType, dockerImageName, "", false));
+ storageContainer =
getContainers().registerContainer((DockerStorageContainer)
StorageContainerFactory.newInstance(databaseType, dockerImageName, ""));
ShardingSphereProxyDockerContainer proxyContainer = new
ShardingSphereProxyDockerContainer(databaseType, dockerImageName);
proxyContainer.dependsOn(governanceContainer, storageContainer);
ShardingSphereProxyDockerContainer anotherProxyContainer = new
ShardingSphereProxyDockerContainer(databaseType, dockerImageName);
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/container/compose/mode/ClusterComposedContainer.java
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/container/compose/mode/ClusterComposedContainer.java
index 75f510b0d4f..81bee1a9ad6 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/container/compose/mode/ClusterComposedContainer.java
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/container/compose/mode/ClusterComposedContainer.java
@@ -50,7 +50,7 @@ public final class ClusterComposedContainer implements
ComposedContainer {
// TODO support other types of governance
governanceContainer =
containers.registerContainer(GovernanceContainerFactory.newInstance("ZooKeeper"));
// TODO add more version of databases
- storageContainer =
containers.registerContainer(StorageContainerFactory.newInstance(parameterizedArray.getDatabaseType(),
"", scenario, true));
+ storageContainer =
containers.registerContainer(StorageContainerFactory.newInstance(parameterizedArray.getDatabaseType(),
"", scenario));
AdapterContainer adapterContainer =
AdapterContainerFactory.newInstance(
parameterizedArray.getMode(), parameterizedArray.getAdapter(),
parameterizedArray.getDatabaseType(), storageContainer, scenario);
if (adapterContainer instanceof DockerITContainer) {
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/container/compose/mode/StandaloneComposedContainer.java
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/container/compose/mode/StandaloneComposedContainer.java
index e6967e1da86..c379f6dcdcd 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/container/compose/mode/StandaloneComposedContainer.java
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/container/compose/mode/StandaloneComposedContainer.java
@@ -44,7 +44,7 @@ public final class StandaloneComposedContainer implements
ComposedContainer {
String scenario = parameterizedArray.getScenario();
containers = new ITContainers(scenario);
// TODO add more version of databases
- storageContainer =
containers.registerContainer(StorageContainerFactory.newInstance(parameterizedArray.getDatabaseType(),
"", scenario, true));
+ storageContainer =
containers.registerContainer(StorageContainerFactory.newInstance(parameterizedArray.getDatabaseType(),
"", scenario));
adapterContainer = containers.registerContainer(
AdapterContainerFactory.newInstance(parameterizedArray.getMode(),
parameterizedArray.getAdapter(), parameterizedArray.getDatabaseType(),
storageContainer, scenario));
if (adapterContainer instanceof DockerITContainer) {
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/proxy/conf/mysql/config-db.yaml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/proxy/conf/mysql/config-db.yaml
index b10b4e2d943..791d7ae2868 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/proxy/conf/mysql/config-db.yaml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/proxy/conf/mysql/config-db.yaml
@@ -20,8 +20,8 @@ databaseName: db
dataSources:
ds_0:
url:
jdbc:mysql://mysql.db.host:3306/db_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -29,8 +29,8 @@ dataSources:
minPoolSize: 2
ds_1:
url:
jdbc:mysql://mysql.db.host:3306/db_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -38,8 +38,8 @@ dataSources:
minPoolSize: 2
ds_2:
url:
jdbc:mysql://mysql.db.host:3306/db_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -47,8 +47,8 @@ dataSources:
minPoolSize: 2
ds_3:
url:
jdbc:mysql://mysql.db.host:3306/db_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -56,8 +56,8 @@ dataSources:
minPoolSize: 2
ds_4:
url:
jdbc:mysql://mysql.db.host:3306/db_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -65,8 +65,8 @@ dataSources:
minPoolSize: 2
ds_5:
url:
jdbc:mysql://mysql.db.host:3306/db_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -74,8 +74,8 @@ dataSources:
minPoolSize: 2
ds_6:
url:
jdbc:mysql://mysql.db.host:3306/db_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -83,8 +83,8 @@ dataSources:
minPoolSize: 2
ds_7:
url:
jdbc:mysql://mysql.db.host:3306/db_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -92,8 +92,8 @@ dataSources:
minPoolSize: 2
ds_8:
url:
jdbc:mysql://mysql.db.host:3306/db_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -101,8 +101,8 @@ dataSources:
minPoolSize: 2
ds_9:
url:
jdbc:mysql://mysql.db.host:3306/db_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/proxy/conf/postgresql/config-db.yaml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/proxy/conf/postgresql/config-db.yaml
index 9eac2c6aafb..ee6de2db9c3 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/proxy/conf/postgresql/config-db.yaml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/proxy/conf/postgresql/config-db.yaml
@@ -20,8 +20,8 @@ databaseName: db
dataSources:
ds_0:
url: jdbc:postgresql://postgresql.db.host:5432/db_0
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -29,8 +29,8 @@ dataSources:
minPoolSize: 2
ds_1:
url: jdbc:postgresql://postgresql.db.host:5432/db_1
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -38,8 +38,8 @@ dataSources:
minPoolSize: 2
ds_2:
url: jdbc:postgresql://postgresql.db.host:5432/db_2
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -47,8 +47,8 @@ dataSources:
minPoolSize: 2
ds_3:
url: jdbc:postgresql://postgresql.db.host:5432/db_3
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -56,8 +56,8 @@ dataSources:
minPoolSize: 2
ds_4:
url: jdbc:postgresql://postgresql.db.host:5432/db_4
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -65,8 +65,8 @@ dataSources:
minPoolSize: 2
ds_5:
url: jdbc:postgresql://postgresql.db.host:5432/db_5
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -74,8 +74,8 @@ dataSources:
minPoolSize: 2
ds_6:
url: jdbc:postgresql://postgresql.db.host:5432/db_6
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -83,8 +83,8 @@ dataSources:
minPoolSize: 2
ds_7:
url: jdbc:postgresql://postgresql.db.host:5432/db_7
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -92,8 +92,8 @@ dataSources:
minPoolSize: 2
ds_8:
url: jdbc:postgresql://postgresql.db.host:5432/db_8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -101,8 +101,8 @@ dataSources:
minPoolSize: 2
ds_9:
url: jdbc:postgresql://postgresql.db.host:5432/db_9
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/mysql/config-dbtbl-with-readwrite-splitting.yaml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/mysql/config-dbtbl-with-readwrite-splitting.yaml
index aeff3158260..d953eec20e6 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/mysql/config-dbtbl-with-readwrite-splitting.yaml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/mysql/config-dbtbl-with-readwrite-splitting.yaml
@@ -20,8 +20,8 @@ databaseName: dbtbl_with_readwrite_splitting
dataSources:
write_ds_0:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -29,8 +29,8 @@ dataSources:
minPoolSize: 2
write_ds_1:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -38,8 +38,8 @@ dataSources:
minPoolSize: 2
write_ds_2:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -47,8 +47,8 @@ dataSources:
minPoolSize: 2
write_ds_3:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -56,8 +56,8 @@ dataSources:
minPoolSize: 2
write_ds_4:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -65,8 +65,8 @@ dataSources:
minPoolSize: 2
write_ds_5:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -74,8 +74,8 @@ dataSources:
minPoolSize: 2
write_ds_6:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -83,8 +83,8 @@ dataSources:
minPoolSize: 2
write_ds_7:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -92,8 +92,8 @@ dataSources:
minPoolSize: 2
write_ds_8:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -101,8 +101,8 @@ dataSources:
minPoolSize: 2
write_ds_9:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -110,8 +110,8 @@ dataSources:
minPoolSize: 2
read_ds_0:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -119,8 +119,8 @@ dataSources:
minPoolSize: 2
read_ds_1:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -128,8 +128,8 @@ dataSources:
minPoolSize: 2
read_ds_2:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -137,8 +137,8 @@ dataSources:
minPoolSize: 2
read_ds_3:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -146,8 +146,8 @@ dataSources:
minPoolSize: 2
read_ds_4:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -155,8 +155,8 @@ dataSources:
minPoolSize: 2
read_ds_5:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -164,8 +164,8 @@ dataSources:
minPoolSize: 2
read_ds_6:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -173,8 +173,8 @@ dataSources:
minPoolSize: 2
read_ds_7:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -182,8 +182,8 @@ dataSources:
minPoolSize: 2
read_ds_8:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -191,8 +191,8 @@ dataSources:
minPoolSize: 2
read_ds_9:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/postgresql/config-dbtbl-with-readwrite-splitting.yaml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/postgresql/config-dbtbl-with-readwrite-splitting.yaml
index 0e71635189f..2d7b24606a6 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/postgresql/config-dbtbl-with-readwrite-splitting.yaml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/postgresql/config-dbtbl-with-readwrite-splitting.yaml
@@ -20,8 +20,8 @@ databaseName: dbtbl_with_readwrite_splitting
dataSources:
write_ds_0:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/write_ds_0
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -29,8 +29,8 @@ dataSources:
minPoolSize: 2
write_ds_1:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/write_ds_1
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -38,8 +38,8 @@ dataSources:
minPoolSize: 2
write_ds_2:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/write_ds_2
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -47,8 +47,8 @@ dataSources:
minPoolSize: 2
write_ds_3:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/write_ds_3
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -56,8 +56,8 @@ dataSources:
minPoolSize: 2
write_ds_4:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/write_ds_4
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -65,8 +65,8 @@ dataSources:
minPoolSize: 2
write_ds_5:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/write_ds_5
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -74,8 +74,8 @@ dataSources:
minPoolSize: 2
write_ds_6:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/write_ds_6
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -83,8 +83,8 @@ dataSources:
minPoolSize: 2
write_ds_7:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/write_ds_7
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -92,8 +92,8 @@ dataSources:
minPoolSize: 2
write_ds_8:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/write_ds_8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -101,8 +101,8 @@ dataSources:
minPoolSize: 2
write_ds_9:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/write_ds_9
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -110,8 +110,8 @@ dataSources:
minPoolSize: 2
read_ds_0:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/read_ds_0
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -119,8 +119,8 @@ dataSources:
minPoolSize: 2
read_ds_1:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/read_ds_1
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -128,8 +128,8 @@ dataSources:
minPoolSize: 2
read_ds_2:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/read_ds_2
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -137,8 +137,8 @@ dataSources:
minPoolSize: 2
read_ds_3:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/read_ds_3
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -146,8 +146,8 @@ dataSources:
minPoolSize: 2
read_ds_4:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/read_ds_4
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -155,8 +155,8 @@ dataSources:
minPoolSize: 2
read_ds_5:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/read_ds_5
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -164,8 +164,8 @@ dataSources:
minPoolSize: 2
read_ds_6:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/read_ds_6
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -173,8 +173,8 @@ dataSources:
minPoolSize: 2
read_ds_7:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/read_ds_7
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -182,8 +182,8 @@ dataSources:
minPoolSize: 2
read_ds_8:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/read_ds_8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -191,8 +191,8 @@ dataSources:
minPoolSize: 2
read_ds_9:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/read_ds_9
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/proxy/conf/mysql/config-dbtbl-with-readwrite-splitting-and-encrypt.yaml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/proxy/conf/mysql/config-dbtbl-with-readwrite-splitting-and-encrypt.yaml
index 18e88ee3546..33b53132bb3 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/proxy/conf/mysql/config-dbtbl-with-readwrite-splitting-and-encrypt.yaml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/proxy/conf/mysql/config-dbtbl-with-readwrite-splitting-and-encrypt.yaml
@@ -20,8 +20,8 @@ databaseName: dbtbl_with_readwrite_splitting_and_encrypt
dataSources:
encrypt_write_ds_0:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -29,8 +29,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_1:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -38,8 +38,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_2:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -47,8 +47,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_3:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -56,8 +56,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_4:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -65,8 +65,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_5:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -74,8 +74,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_6:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -83,8 +83,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_7:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -92,8 +92,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_8:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -101,8 +101,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_9:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -110,8 +110,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_0:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -119,8 +119,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_1:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -128,8 +128,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_2:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -137,8 +137,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_3:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -146,8 +146,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_4:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -155,8 +155,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_5:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -164,8 +164,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_6:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -173,8 +173,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_7:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -182,8 +182,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_8:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -191,8 +191,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_9:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/proxy/conf/postgresql/config-dbtbl-with-readwrite-splitting-and-encrypt.yaml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/proxy/conf/postgresql/config-dbtbl-with-readwrite-splitting-and-encrypt.yaml
index eade089381d..d915402d59e 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/proxy/conf/postgresql/config-dbtbl-with-readwrite-splitting-and-encrypt.yaml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/proxy/conf/postgresql/config-dbtbl-with-readwrite-splitting-and-encrypt.yaml
@@ -20,8 +20,8 @@ databaseName: dbtbl_with_readwrite_splitting_and_encrypt
dataSources:
encrypt_write_ds_0:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host:5432/encrypt_write_ds_0
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -29,8 +29,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_1:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host:5432/encrypt_write_ds_1
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -38,8 +38,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_2:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host:5432/encrypt_write_ds_2
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -47,8 +47,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_3:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host:5432/encrypt_write_ds_3
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -56,8 +56,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_4:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host:5432/encrypt_write_ds_4
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -65,8 +65,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_5:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host:5432/encrypt_write_ds_5
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -74,8 +74,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_6:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host:5432/encrypt_write_ds_6
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -83,8 +83,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_7:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host:5432/encrypt_write_ds_7
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -92,8 +92,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_8:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host:5432/encrypt_write_ds_8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -101,8 +101,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_9:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host:5432/encrypt_write_ds_9
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -110,8 +110,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_0:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host:5432/encrypt_read_ds_0
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -119,8 +119,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_1:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host:5432/encrypt_read_ds_1
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -128,8 +128,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_2:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host:5432/encrypt_read_ds_2
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -137,8 +137,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_3:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host:5432/encrypt_read_ds_3
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -146,8 +146,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_4:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host:5432/encrypt_read_ds_4
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -155,8 +155,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_5:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host:5432/encrypt_read_ds_5
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -164,8 +164,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_6:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host:5432/encrypt_read_ds_6
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -173,8 +173,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_7:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host:5432/encrypt_read_ds_7
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -182,8 +182,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_8:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host:5432/encrypt_read_ds_8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -191,8 +191,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_9:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting_and_encrypt.host:5432/encrypt_read_ds_9
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/proxy/conf/mysql/config-empty-rules.yaml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/proxy/conf/mysql/config-empty-rules.yaml
index 4add764f3c7..5e02f4e8ac8 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/proxy/conf/mysql/config-empty-rules.yaml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/proxy/conf/mysql/config-empty-rules.yaml
@@ -20,8 +20,8 @@ databaseName: empty_rules
dataSources:
encrypt_write_ds_0:
url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_write_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -29,8 +29,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_1:
url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_write_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -38,8 +38,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_2:
url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_write_ds_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -47,8 +47,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_3:
url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_write_ds_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -56,8 +56,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_4:
url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_write_ds_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -65,8 +65,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_5:
url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_write_ds_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -74,8 +74,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_6:
url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_write_ds_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -83,8 +83,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_7:
url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_write_ds_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -92,8 +92,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_8:
url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_write_ds_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -101,8 +101,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_9:
url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_write_ds_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -110,8 +110,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_0:
url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_read_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -119,8 +119,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_1:
url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_read_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -128,8 +128,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_2:
url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_read_ds_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -137,8 +137,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_3:
url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_read_ds_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -146,8 +146,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_4:
url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_read_ds_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -155,8 +155,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_5:
url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_read_ds_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -164,8 +164,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_6:
url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_read_ds_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -173,8 +173,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_7:
url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_read_ds_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -182,8 +182,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_8:
url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_read_ds_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -191,8 +191,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_9:
url:
jdbc:mysql://mysql.empty_rules.host:3306/encrypt_read_ds_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -200,8 +200,8 @@ dataSources:
minPoolSize: 2
rdl_test_0:
url:
jdbc:mysql://mysql.empty_rules.host:3306/rdl_test_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/proxy/conf/postgresql/config-empty-rules.yaml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/proxy/conf/postgresql/config-empty-rules.yaml
index 5b68201146d..2341513d9bf 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/proxy/conf/postgresql/config-empty-rules.yaml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/proxy/conf/postgresql/config-empty-rules.yaml
@@ -20,8 +20,8 @@ databaseName: empty_rules
dataSources:
encrypt_write_ds_0:
url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_write_ds_0
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -29,8 +29,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_1:
url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_write_ds_1
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -38,8 +38,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_2:
url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_write_ds_2
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -47,8 +47,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_3:
url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_write_ds_3
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -56,8 +56,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_4:
url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_write_ds_4
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -65,8 +65,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_5:
url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_write_ds_5
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -74,8 +74,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_6:
url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_write_ds_6
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -83,8 +83,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_7:
url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_write_ds_7
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -92,8 +92,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_8:
url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_write_ds_8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -101,8 +101,8 @@ dataSources:
minPoolSize: 2
encrypt_write_ds_9:
url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_write_ds_9
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -110,8 +110,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_0:
url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_read_ds_0
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -119,8 +119,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_1:
url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_read_ds_1
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -128,8 +128,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_2:
url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_read_ds_2
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -137,8 +137,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_3:
url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_read_ds_3
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -146,8 +146,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_4:
url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_read_ds_4
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -155,8 +155,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_5:
url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_read_ds_5
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -164,8 +164,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_6:
url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_read_ds_6
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -173,8 +173,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_7:
url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_read_ds_7
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -182,8 +182,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_8:
url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_read_ds_8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -191,8 +191,8 @@ dataSources:
minPoolSize: 2
encrypt_read_ds_9:
url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_read_ds_9
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -200,8 +200,8 @@ dataSources:
minPoolSize: 2
rdl_test_0:
url: jdbc:postgresql://postgresql.empty_rules.host:5432/rdl_test_0
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/proxy/conf/mysql/config-encrypt.yaml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/proxy/conf/mysql/config-encrypt.yaml
index 30b49fd8b6d..6944d712794 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/proxy/conf/mysql/config-encrypt.yaml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/proxy/conf/mysql/config-encrypt.yaml
@@ -20,8 +20,8 @@ databaseName: encrypt
dataSources:
encrypt:
url:
jdbc:mysql://mysql.encrypt.host:3306/encrypt?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/proxy/conf/postgresql/config-encrypt.yaml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/proxy/conf/postgresql/config-encrypt.yaml
index 66c144fa9fa..6e06e4efd52 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/proxy/conf/postgresql/config-encrypt.yaml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/proxy/conf/postgresql/config-encrypt.yaml
@@ -20,8 +20,8 @@ databaseName: encrypt
dataSources:
encrypt:
url: jdbc:postgresql://postgresql.encrypt.host:5432/encrypt
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/proxy/conf/mysql/config-readwrite-splitting.yaml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/proxy/conf/mysql/config-readwrite-splitting.yaml
index e50eef802f3..fe0d0042d68 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/proxy/conf/mysql/config-readwrite-splitting.yaml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/proxy/conf/mysql/config-readwrite-splitting.yaml
@@ -20,8 +20,8 @@ databaseName: readwrite_splitting
dataSources:
write_ds:
url:
jdbc:mysql://mysql.readwrite_splitting.host:3306/write_ds?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -29,8 +29,8 @@ dataSources:
minPoolSize: 2
read_0:
url:
jdbc:mysql://mysql.readwrite_splitting.host:3306/read_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -38,8 +38,8 @@ dataSources:
minPoolSize: 2
read_1:
url:
jdbc:mysql://mysql.readwrite_splitting.host:3306/read_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/proxy/conf/postgresql/config-readwrite-splitting.yaml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/proxy/conf/postgresql/config-readwrite-splitting.yaml
index 66539794637..3d1d2996259 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/proxy/conf/postgresql/config-readwrite-splitting.yaml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/proxy/conf/postgresql/config-readwrite-splitting.yaml
@@ -20,8 +20,8 @@ databaseName: readwrite_splitting
dataSources:
write_ds:
url: jdbc:postgresql://postgresql.readwrite_splitting.host:5432/write_ds
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -29,8 +29,8 @@ dataSources:
minPoolSize: 2
read_0:
url: jdbc:postgresql://postgresql.readwrite_splitting.host:5432/read_0
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -38,8 +38,8 @@ dataSources:
minPoolSize: 2
read_1:
url: jdbc:postgresql://postgresql.readwrite_splitting.host:5432/read_1
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/proxy/conf/mysql/config-shadow.yaml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/proxy/conf/mysql/config-shadow.yaml
index 009d454dd34..6d52d9ad703 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/proxy/conf/mysql/config-shadow.yaml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/proxy/conf/mysql/config-shadow.yaml
@@ -20,8 +20,8 @@ databaseName: shadow
dataSources:
db:
url:
jdbc:mysql://mysql.shadow.host:3306/db?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -29,8 +29,8 @@ dataSources:
minPoolSize: 2
shadow_db:
url:
jdbc:mysql://mysql.shadow.host:3306/shadow_db?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/proxy/conf/postgresql/config-shadow.yaml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/proxy/conf/postgresql/config-shadow.yaml
index fff9ad720f3..b0c1988ece6 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/proxy/conf/postgresql/config-shadow.yaml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/proxy/conf/postgresql/config-shadow.yaml
@@ -20,8 +20,8 @@ databaseName: shadow
dataSources:
db:
url: jdbc:postgresql://postgresql.shadow.host:5432/db
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
@@ -29,8 +29,8 @@ dataSources:
minPoolSize: 2
shadow_db:
url: jdbc:postgresql://postgresql.shadow.host:5432/shadow_db
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/proxy/conf/mysql/config-tbl.yaml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/proxy/conf/mysql/config-tbl.yaml
index 5eb5797643c..76d16abe9bf 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/proxy/conf/mysql/config-tbl.yaml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/proxy/conf/mysql/config-tbl.yaml
@@ -20,8 +20,8 @@ databaseName: tbl
dataSources:
tbl:
url:
jdbc:mysql://mysql.tbl.host:3306/tbl?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/proxy/conf/postgresql/config-tbl.yaml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/proxy/conf/postgresql/config-tbl.yaml
index 9f81d7e59a6..28e160b6ba7 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/proxy/conf/postgresql/config-tbl.yaml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/proxy/conf/postgresql/config-tbl.yaml
@@ -20,8 +20,8 @@ databaseName: tbl
dataSources:
tbl:
url: jdbc:postgresql://postgresql.tbl.host:5432/tbl
- username: root
- password: Root@123
+ username: test_user
+ password: Test@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
