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 2020/02/28 14:26:19 UTC
[GitHub] [incubator-shardingsphere] ppourali commented on issue #4507:
"Select * From table" returns both plain and cipher columns in the
resultset in Sharding-Proxy
ppourali commented on issue #4507: "Select * From table" returns both plain and cipher columns in the resultset in Sharding-Proxy
URL: https://github.com/apache/incubator-shardingsphere/issues/4507#issuecomment-592536060
Hi @dongzl ,
Thanks for the reply.
**Here is my config-encrypt.yaml:**
`
schemaName: anonymized_db
dataSource:
url: jdbc:postgresql://127.0.0.1:5432/database?serverTimezone=UTC&useSSL=false
username: dbuser
password: database
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
encryptRule:
encryptors:
encryptor_aes:
type: aes
props:
aes.key.value: 123456abc
encryptor_md5:
type: md5
tables:
test:
columns:
data:
plainColumn: data
cipherColumn: data_anonymized
encryptor: encryptor_md5
`
**Here is the create script for my test table:**
`
create table public.test (
id INTEGER not null,
name character varying (20),
data text,
data_anonymized text
)
`
The data column is what we want to be encrypted. When we run "SELECT * FROM test", it returns both the data and the data_anonymized column. But we expect to only return the data_anonymized column. We use psql shell to run the queries and connect to port 3307.
Please advise.
Thanks,
Parsa
----------------------------------------------------------------
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