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