You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2019/12/27 03:36:57 UTC

[GitHub] [incubator-shardingsphere] haetao opened a new issue #3817: Sharding-Proxy starts up failed with Orchetrantion in scenario `sharding+encrypt+masterSlave`.

haetao opened a new issue #3817: Sharding-Proxy starts up failed with Orchetrantion in scenario `sharding+encrypt+masterSlave`.
URL: https://github.com/apache/incubator-shardingsphere/issues/3817
 
 
   ## Bug Report
   
   **For English only**, other languages will not accept.
   
   Before report a bug, make sure you have:
   
   - Searched open and closed [GitHub issues](https://github.com/apache/incubator-shardingsphere/issues).
   - Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview).
   
   Please pay attention on issues you submitted, because we maybe need more details. 
   If no response **more than 7 days** and we cannot reproduce it on current information, we will **close it**.
   
   Please answer these questions before submitting your issue. Thanks!
   
   ### Which version of ShardingSphere did you use?
   4.0.0-rc4
   ### Which project did you use? Sharding-JDBC or Sharding-Proxy?
   sharding-proxy
   ### Expected behavior
   proxy starts up well!
   ### Actual behavior
   proxy starts up failed!
   ### Reason analyze (If you can)
   Sharding-Proxy gets the configuration from Configuration Center when it is initlizating. It recognizes these RuleConfiguration by key words. But there is a problem, for example:
      
      The `sharding+encrypt` rule configuration in Configuration Center as follows, Proxy recognizes these RuleConfigurations by key words (`tables:\n`-->shardingRule, `encryptors:\n`-->encryptRule ).
      We can see that there is a key word 'tables:' exists in shardingRule and encryptRule at the same time. So, we can't identify shardingRule by using key word `tables:`, it can use `encryptRule` as `shardingRule`
      or use `shardingRule` as `encryptRule` in complex scenario.( for example `sharding+encrypt`,Proxy can use `shardingRule` as `encryptRule` )
   
   **sharding+encrypt rule configuration**
   ```
   encryptRule:
     encryptors:
       encryptor_aes:
         props:
           aes.key.value: 123456abc
         type: aes
     tables:
       t_user:
         columns:
           user_name:
             cipherColumn: assisted_query_pwd
             encryptor: encryptor_aes
             plainColumn: user_name_plain
   tables:
     t_user:
       actualDataNodes: ds_${0..1}.t_user_${0..1}
       databaseStrategy:
         inline:
           algorithmExpression: ds_${user_id % 2}
           shardingColumn: user_id
       keyGenerator:
         column: user_id
         type: SNOWFLAKE
       logicTable: t_user
       tableStrategy:
         inline:
           algorithmExpression: t_user_${user_id % 2}
           shardingColumn: user_id
   ```
   
   **method**  `getSchemaRule`
   
   ![image](https://user-images.githubusercontent.com/46469719/71499699-a6ff9b80-289c-11ea-824c-c634f8e812ea.png)
   
   **method**  `isShardingRule` , `isEncryptRule`
   
   ![image](https://user-images.githubusercontent.com/46469719/71499743-efb75480-289c-11ea-9b6e-337af0060359.png)
   
   

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

[GitHub] [incubator-shardingsphere] SteNicholas removed a comment on issue #3817: Sharding-Proxy starts up failed with Orchestration in scenario `sharding+encrypt+masterSlave`.

Posted by GitBox <gi...@apache.org>.
SteNicholas removed a comment on issue #3817: Sharding-Proxy starts up failed with Orchestration in scenario `sharding+encrypt+masterSlave`.
URL: https://github.com/apache/incubator-shardingsphere/issues/3817#issuecomment-569218202
 
 
   @haetao I don't understand the bug you said about. And Why the version sharding-proxy is RC4?

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

[GitHub] [incubator-shardingsphere] terrymanu closed issue #3817: Sharding-Proxy starts up failed with Orchestration in scenario `sharding+encrypt+masterSlave`.

Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #3817: Sharding-Proxy starts up failed with Orchestration in scenario `sharding+encrypt+masterSlave`.
URL: https://github.com/apache/incubator-shardingsphere/issues/3817
 
 
   

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

[GitHub] [incubator-shardingsphere] SteNicholas commented on issue #3817: Sharding-Proxy starts up failed with Orchestration in scenario `sharding+encrypt+masterSlave`.

Posted by GitBox <gi...@apache.org>.
SteNicholas commented on issue #3817: Sharding-Proxy starts up failed with Orchestration in scenario `sharding+encrypt+masterSlave`.
URL: https://github.com/apache/incubator-shardingsphere/issues/3817#issuecomment-569218202
 
 
   @haetao I don't understand the bug you said about. And Why the version sharding-proxy is RC4?

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