[GitHub] [incubator-shardingsphere] shuohao commented on issue #2992: Data does not decrypt

[GitBox <gi...@apache.org>]

shuohao commented on issue #2992: Data does not decrypt
URL: https://github.com/apache/incubator-shardingsphere/issues/2992#issuecomment-528873946
 
 
   spring:
     profiles:
       active: test
     shardingsphere:
       datasource:
         names: master,slave
         master:
           type: com.zaxxer.hikari.HikariDataSource
           driverClassName: com.mysql.jdbc.Driver
           jdbcUrl: jdbc:mysql://${db.host}:${db.port}/my_task?zeroDateTimeBehavior=convertToNull&useUnicode=yes&characterEncoding=UTF8
           username: ${db.user}
           password: ${db.pwd}
           connectionTimeout: 5000
           maximumPoolSize: 200
           dataSource.prepStmtCacheSize: 250
           dataSource.prepStmtCacheSqlLimit: 2048
           dataSource.cachePrepStmts: true
           dataSource.useServerPrepStmts: true
         slave:
           type: com.zaxxer.hikari.HikariDataSource
           driverClassName: com.mysql.jdbc.Driver
           jdbcUrl: jdbc:mysql://${dbRead.host}:${dbRead.port}/my_task?zeroDateTimeBehavior=convertToNull&useUnicode=yes&characterEncoding=UTF8
           username: ${dbRead.user}
           password: ${dbRead.pwd}
           connectionTimeout: 5000
           maximumPoolSize: 200
           dataSource.prepStmtCacheSize: 250
           dataSource.prepStmtCacheSqlLimit: 2048
           dataSource.cachePrepStmts: true
           dataSource.useServerPrepStmts: true
       sharding:
         tables:
           task:
             actualDataNodes: ds.task,ds.task_clue
             tableStrategy:
               standard:
                 shardingColumn: project
                 preciseAlgorithmClassName: com.lianjia.sinan.task.dao.sharding.ManualShardingAlgorithm
           task_biz_field:
             actualDataNodes: ds.task_biz_field,ds.task_biz_field_clue
             tableStrategy:
               standard:
                 shardingColumn: project
                 preciseAlgorithmClassName: com.lianjia.sinan.task.dao.sharding.ManualShardingAlgorithm
         binding-tables:
           - task,task_biz_field
         master-slave-rules:
           ds.masterDataSourceName: master
           ds.slaveDataSourceNames: slave
         encrypt-rule:
           encryptors:
             aes_encryptor:
               type: AES
               props:
                 aes.key.value: zqAvW0yEdH
           tables:
             task:
               columns:
                 phone:
                   plainColumn: phone
                   cipherColumn: phone_cipher
                   encryptor: aes_encryptor
       props:
         sql.show: true
         query.with.cipher.column: true

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services