Flavio Copes ## Table of Contents |Preface| |---| |Introduction to Linux and shells| |man| |ls| |cd| |pwd| |mkdir| |rmdir| |mv| |cp| |open| |touch| |find| |ln| |gzip| |gunzip| |tar| |alias| |cat| |less| |tail| macOS, WSL, and anywhere you have a UNIX environment ## pwd Whenever you feel lost in the filesystem, call the pwd command to know where you are: pwd It will print the current folder path. ## mkdir You it's resolved at invocation time. Those 2 are different: alias lsthis="ls $PWD" alias lscurrent='ls $PWD' $PWD refers to the current folder the shell is into. If you now navigate away to

pwd: cipher: name: pwd encryptorName: aes_encryptor assistedQuery: name: assisted_query_pwd tion columnConfigTest = new EncryptColumnRuleConfiguration("pwd", new EncryptColumnItemRuleConfiguration("pwd", "pwd_encryptor")); columnConfigTest.setAssistedQuery(new EncryptColumnItemRuleConfiguration("assisted_query_pwd", "pwd_encryptor")); columnConfigTest.setLikeQuery(new EncryptColumnItemRuleConfiguration("like_pwd", "like_encryptor"));

Path: export PATH=$ {PWD} / ./bin:$PATH You also need to set the $ FABRIC\_CFG\_PATH $ to point to the core.yaml file in the fabric-samples repository: export FABRIC_CFG_PATH=$PWD/../config/ You can export CORE_PEER_TLS_ROOTCERT_FILE=$ {PWD} /organizations/peerOrganizations/org1.example.com/peers/peer0.org1.example.com/tls/ca.crt export CORE_PEER_MSPCONFIGPATH=$ {PWD} /organizations/peerOrganizations/org1 chaincode invoke -o localhost:7050 --ordererTLSHostnameOverride orderer.example.com --tls --cafile ${PWD}/organizations/ordererOrganizations/example.com/orderers/--orderer.example.com/msp/tlsccacerts/tlsca

CLI Path: export PATH=$ {PWD}/../bin:$PATH You also need to set the FABRIC_CFG_PATH to point to the core.yaml file in the fabric-samples repository: export FABRIC_CFG_PATH=$PWD/../config/ You can now set export CORE_PEER_TLS_ROOTCERT_FILE=$ {PWD}/organizations/peerOrganizations/org1.example.com/peers/peer0.org1.example.com/tls/ca.crt export CORE_PEER_MSPCONFIGPATH=$ {PWD}/organizations/peerOrganizations/org1 chaincode invoke -o localhost:7050 --ordererTLSHostnameOverride orderer.example.com --tls --cafile ${PWD}/organizations/ordererOrganizations/example.com/orderers/orderer.example.com/msp/tlscacerts/tlsca.example

encryptorName: name-encryptor pwd: cipherColumn: pwd assistedQueryColumn: assisted_query_pwd encryptorName: pwd_encryptor encryptors: name-encryptor: name-encryptor: type: AES props: aes-key-value: 123456abc pwd_encryptor: type: assistedTest Read the YAML configuration to create a data source according to the createDataSource on columnConfigTest = new EncryptColumnRuleConfiguration("pwd", "pwd", "assisted_query_pwd", "", "pwd_encryptor", null); EncryptTableRuleConfiguration encryptTableRuleConfig

name-encryptor pwd: cipherColumn: pwd assistedQueryColumn: assisted_query_pwd encryptorName: pwd_encryptor encryptors: name-encryptor: type: AES props: aes-key-value: 123456abc pwd_encryptor: on columnConfigTest = new EncryptColumnRuleConfiguration("pwd", "pwd", "assisted_query_pwd", "", "pwd_encryptor", null); EncryptTableRuleConfiguration encryptTableRuleConfig tor", new AlgorithmConfiguration("AES", props)); encryptAlgorithmConfigs.put("pwd_encryptor", new AlgorithmConfiguration("assistedTest", props)); EncryptRuleConfiguration

username encryptorName: name-encryptor pwd: cipherColumn: pwd assistedQueryColumn: assisted_query_pwd encryptorName: pwd_encryptor encryptors: name-encryptor: type: type: AES props: aes-key-value: 123456abc pwd_encryptor: type: assistedTest Read the YAML configuration to create a data source according to the createDataSource method of YamlSharding on columnConfigTest = new EncryptColumnRuleConfiguration("pwd", "pwd", "assisted_query_pwd", "", "pwd_encryptor", null); EncryptTableRuleConfiguration encryptTableRuleConfig

t_user，这张表里实际有两个字段 pwd_plain，用于存放明文数据、pwd_cipher，用于存放密文数据，同时定义 logicColumn 为 pwd。那么，用户在编写 SQL 时应该面向 logicColumn 进行编写，即 INSERT INTO t_user SET pwd = '123'。Apache ShardingSphere 接收到该 SQL，通过用户提供的加密配置，发现 pwd 是 l encryptors: aes_encryptor: type: AES props: aes-key-value: 123456abc tables: t_user: columns: pwd: cipherColumn: pwd encryptorName: aes_encryptor 使用这套配置，Apache ShardingSphere 只需将 logicColumn 和 cipherColumn 业务开发人员最希望的做法是：减少资金费用的承担、最好不要修改业务代码、能够安全平滑迁移系统。于是，ShardingSphere的加密功能模块便应运而生。可分为3步进行： ### 1. 系统迁移前 假设系统需要对 t_user 的 pwd 字段进行加密处理，业务方使用 Apache ShardingSphere 来代替标准化的 JDBC 接口，此举基本不需要额外改造（我们还提供了 Spring Boot Starter，Spring

on columnConfigTest = new EncryptColumnRuleConfiguration("pwd", "pwd", "assisted_query_pwd", "", "pwd_encryptor"); EncryptTableRuleConfiguration encryptTableRuleConfig ShardingSphereAlgorithmConfiguration("AES", encryptProperties)); encryptAlgorithmConfigs.put("pwd_encryptor", new ShardingSphereAlgorithmConfiguration("assistedTest", encryptProperties)); that uses the data sharding configuration. columns: pwd: plainColumn: plain_pwd cipherColumn: cipher_pwd encryptorName: encryptor_aes encryptors: encryptor_aes:

CLI Path: export PATH=${PWD}/../bin:${PWD}:$PATH You also need to set the FABRIC_CFG_PATH to point to the core.yaml file in the fabric-samples repository: export FABRIC_CFG_PATH=$PWD/../config/ You can now export CORE_PEER_TLS_ROOTCERT_FILE=${PWD}/organizations/peerOrganizations/org1. ˓→example.com/peers/peer0.org1.example.com/tls/ca.crt export CORE_PEER_MSPCONFIGPATH=${PWD}/organizations/peerOrganizations/org1 chaincode invoke -o localhost:7050 --ordererTLSHostnameOverride orderer.example. ˓→com --tls --cafile ${PWD}/organizations/ordererOrganizations/example.com/orderers/ ˓→orderer.example.com/msp/tlscacerts/tlsca