jukai5501 commented on issue #2866: encrypt not work in 4.0.0-RC2-SNAPSHOT 
version
URL: 
https://github.com/apache/incubator-shardingsphere/issues/2866#issuecomment-521489054
 
 
   Hi!
   
        Yes, I set party_id as key_generator. This is my configuration.
   
   ```
   spring:
     shardingsphere:
       props:
         sql:
           show: true
       datasource:
         names: ds
         ds:
           type: com.zaxxer.hikari.HikariDataSource
           driver-class-name: com.mysql.cj.jdbc.Driver
           jdbc-url: 
jdbc:mysql://${MYSQL_HOST:localhost}:${MYSQL_PORT:3306}/${MYSQL_DB:test}?serverTimezone=Asia/Shanghai
           username: ${MYSQL_USER:test}
           password: ${MYSQL_PASSWORD:test}
           hikari:
             minimum-idle: 60
             maximum-pool-size: 60
             idle-timeout: 30000
             max-lifetime: 1800000
             connection-timeout: 30000
             pool-name: ExampleHikariCP
             connection-test-query: SELECT 1
       encrypt:
         tables:
           user_auth:
             columns:
               credential:
                 encryptor: example_encrypt
                 cipherColumn: credential
                 assistedQueryColumn: credential
         encryptors:
           example_encrypt:
             type: aes
             props:
               'aes.key.value': 123456
       sharding:
         default-data-source-name: ds
         tables:
           party:
             actual-data-nodes: ds.party_$->{0..1}
             key-generator:
               column: party_id
               type: snowflake
             table-strategy:
               inline:
                 sharding-column: party_id
                 algorithm-expression: party_$->{party_id % 2}
   ```
   
   
   > 在 2019年8月15日,08:51,杨翊 Sion Yang <[email protected]> 写道:
   > 
   > Do you set party_id as key_generator?
   > It looks like configuration error for key-generator
   > 
   > —
   > You are receiving this because you were mentioned.
   > Reply to this email directly, view it on GitHub 
<https://github.com/apache/incubator-shardingsphere/issues/2866?email_source=notifications&email_token=AF4QKPC4GD5EJVDL367XGALQESSAPA5CNFSM4ILKET3KYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD4KQTOI#issuecomment-521472441>,
 or mute the thread 
<https://github.com/notifications/unsubscribe-auth/AF4QKPE2KR2J5NYVISMVVUTQESSAPANCNFSM4ILKET3A>.
   > 
   
   

----------------------------------------------------------------
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]


With regards,
Apache Git Services

Reply via email to