mingqing6364 commented on issue #9509: URL: https://github.com/apache/shardingsphere/issues/9509#issuecomment-786382762
I try a new configuration, like [https://github.com/apache/shardingsphere/issues/2972](url) it's can read masterSlaveRule and encryptRule configuration at the same time. But,encrypt can't work in mysql line. ``` [root@localhost apache-shardingsphere-4.1.0-sharding-proxy-bin]# cat conf/config-test.yaml schemaName: test_db dataSources: master_ds: url: jdbc:mysql://192.168.72.1:3308/test?serverTimezone=UTC&useSSL=false username: root password: root connectionTimeoutMilliseconds: 30000 idleTimeoutMilliseconds: 60000 maxLifetimeMilliseconds: 1800000 maxPoolSize: 50 slave_ds_0: url: jdbc:mysql://192.168.72.1:3308/test?serverTimezone=UTC&useSSL=false username: root password: root connectionTimeoutMilliseconds: 30000 idleTimeoutMilliseconds: 60000 maxLifetimeMilliseconds: 1800000 maxPoolSize: 50 shardingRule: masterSlaveRules: ms_ds: masterDataSourceName: master_ds slaveDataSourceNames: - slave_ds_0 encryptRule: encryptors: encryptor_aes: type: aes props: aes.key.value: 123456abc encryptor_md5: type: md5 tables: t_test: columns: user_id: plainColumn: user_plain cipherColumn: user_cipher encryptor: encryptor_aes order_id: cipherColumn: order_cipher encryptor: encryptor_md5 ``` ``` [INFO ] 10:51:13.034 [main] o.a.s.core.log.ConfigurationLogger - ShardingRuleConfiguration: encryptRule: encryptors: encryptor_aes: props: aes.key.value: 123456abc type: aes encryptor_md5: type: md5 tables: t_test: columns: user_id: cipherColumn: user_cipher encryptor: encryptor_aes plainColumn: user_plain order_id: cipherColumn: order_cipher encryptor: encryptor_md5 masterSlaveRules: ms_ds: masterDataSourceName: master_ds name: ms_ds slaveDataSourceNames: - slave_ds_0 [INFO ] 10:51:13.043 [main] o.a.s.core.log.ConfigurationLogger - Authentication: users: root: authorizedSchemas: '' password: root [INFO ] 10:51:13.043 [main] o.a.s.core.log.ConfigurationLogger - Properties: sql.show: true [INFO ] 10:51:13.195 [main] com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting... [INFO ] 10:51:13.472 [main] com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Start completed. [INFO ] 10:51:13.472 [main] com.zaxxer.hikari.HikariDataSource - HikariPool-2 - Starting... [INFO ] 10:51:13.483 [main] com.zaxxer.hikari.HikariDataSource - HikariPool-2 - Start completed. [INFO ] 10:51:13.534 [main] c.a.icatch.provider.imp.AssemblerImp - Loaded jar:file:/root/apache-shardingsphere-4.1.0-sharding-proxy-bin/lib/transactions-4.0.6.jar!/transactions-defaults.properties [INFO ] 10:51:13.535 [main] c.a.icatch.provider.imp.AssemblerImp - Loaded jar:file:/root/apache-shardingsphere-4.1.0-sharding-proxy-bin/lib/sharding-transaction-xa-atomikos-manager-4.1.0.jar!/transactions.properties [WARN ] 10:51:13.555 [main] c.a.icatch.provider.imp.AssemblerImp - Thanks for using Atomikos! Evaluate http://www.atomikos.com/Main/ExtremeTransactions for advanced features and professional support or register at http://www.atomikos.com/Main/RegisterYourDownload to disable this message and receive FREE tips & advice Thanks for using Atomikos! Evaluate http://www.atomikos.com/Main/ExtremeTransactions for advanced features and professional support or register at http://www.atomikos.com/Main/RegisterYourDownload to disable this message and receive FREE tips & advice [INFO ] 10:51:13.570 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.default_max_wait_time_on_shutdown = 9223372036854775807 [INFO ] 10:51:13.570 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.allow_subtransactions = true [INFO ] 10:51:13.570 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.recovery_delay = 300000 [INFO ] 10:51:13.570 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.automatic_resource_registration = false [INFO ] 10:51:13.570 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.oltp_max_retries = 5 [INFO ] 10:51:13.570 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.client_demarcation = false [INFO ] 10:51:13.570 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.threaded_2pc = false [INFO ] 10:51:13.570 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.serial_jta_transactions = false [INFO ] 10:51:13.570 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.log_base_dir = ./logs [INFO ] 10:51:13.570 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.rmi_export_class = none [INFO ] 10:51:13.570 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.max_actives = 10000 [INFO ] 10:51:13.570 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.checkpoint_interval = 50000 [INFO ] 10:51:13.570 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.enable_logging = true [INFO ] 10:51:13.570 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.log_base_name = xa_tx [INFO ] 10:51:13.570 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.max_timeout = 300000 [INFO ] 10:51:13.570 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.trust_client_tm = false [INFO ] 10:51:13.570 [main] c.a.icatch.provider.imp.AssemblerImp - USING: java.naming.factory.initial = com.sun.jndi.rmi.registry.RegistryContextFactory [INFO ] 10:51:13.570 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.tm_unique_name = 127.0.0.1.tm [INFO ] 10:51:13.570 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.forget_orphaned_log_entries_delay = 86400000 [INFO ] 10:51:13.570 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.oltp_retry_interval = 10000 [INFO ] 10:51:13.570 [main] c.a.icatch.provider.imp.AssemblerImp - USING: java.naming.provider.url = rmi://localhost:1099 [INFO ] 10:51:13.570 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.force_shutdown_on_vm_exit = false [INFO ] 10:51:13.570 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.default_jta_timeout = 300000 [INFO ] 10:51:13.571 [main] c.a.icatch.provider.imp.AssemblerImp - Using default (local) logging and recovery... [INFO ] 10:51:13.646 [main] c.a.d.xa.XATransactionalResource - resource-1-master_ds: refreshed XAResource [INFO ] 10:51:13.656 [main] c.a.d.xa.XATransactionalResource - resource-2-slave_ds_0: refreshed XAResource [INFO ] 10:51:13.682 [main] ShardingSphere-metadata - Loading 0 logic tables' meta data. [INFO ] 10:51:13.720 [main] ShardingSphere-metadata - Loading 31 tables' meta data. [INFO ] 10:51:14.662 [epollEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x6e4f82b3] REGISTERED [INFO ] 10:51:14.667 [epollEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x6e4f82b3] BIND: 0.0.0.0/0.0.0.0:3307 [INFO ] 10:51:14.668 [epollEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x6e4f82b3, L:/0.0.0.0:3307] ACTIVE [INFO ] 10:51:32.318 [epollEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x6e4f82b3, L:/0.0.0.0:3307] READ: [id: 0x6638401e, L:/192.168.72.148:3307 - R:/192.168.72.1:34958] [INFO ] 10:51:32.344 [epollEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x6e4f82b3, L:/0.0.0.0:3307] READ COMPLETE [INFO ] 10:51:33.054 [ShardingSphere-Command-0] ShardingSphere-SQL - Logic SQL: select * from t_test [INFO ] 10:51:33.054 [ShardingSphere-Command-0] ShardingSphere-SQL - SQLStatement: SelectStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.SelectStatement@5be043e9, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@2afbf6d4), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@2afbf6d4, projectionsContext=ProjectionsContext(startIndex=7, stopIndex=7, distinctRow=false, projections=[ShorthandProjection(owner=Optional.empty, actualColumns=[ColumnProjection(owner=null, name=id, alias=Optional.empty), ColumnProjection(owner=null, name=user_plain, alias=Optional.empty), ColumnProjection(owner=null, name=user_cipher, alias=Optional.empty), ColumnProjection(owner=null, name=order_cipher, alias=Optional.empty)])]), groupByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.groupby.GroupByContext@6efd3828, orderByContext=org.apache.sharding sphere.sql.parser.binder.segment.select.orderby.OrderByContext@59b7b00f, paginationContext=org.apache.shardingsphere.sql.parser.binder.segment.select.pagination.PaginationContext@114fdb, containsSubquery=false) [INFO ] 10:51:33.054 [ShardingSphere-Command-0] ShardingSphere-SQL - Actual SQL: slave_ds_0 ::: select id, user_plain, user_cipher, order_cipher from t_test ```  ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected]
