MyCAT 配置文件密码加密

MyCAT加密方法：

1、server.xml文件加密

# 1、生产密钥 标注黄色的部分是生成的加密的密码，
cd ~/mycat/
mycat]$ java -cp lib/Mycat-server-1.6.7.5-release.jar io.mycat.util.DecryptUtil 0:test:123456
其中 0:user:password是加密字符串,有两种格式

dataHost加密格式
1:hostM1:root:123456
1代表是dataHost加密
hostM1是<writeHost host="hostM1" 
root是user="root"
123456是 password=明文密码(123456)

对应writeHost配置
        <writeHost host="hostM1" url="localhost:3306" user="root"
                   password="BpkNIjF7LfzS1C76HT7B1bJgmGIDtPihqIvHBlC92L1IFqsMfoJEMk1EkxSzjasWB4GWoUcODYO4AaJstdAp5w==" usingDecrypt="1">
            <!-- can have multi read hosts -->
        </writeHost>

mycat用户登录密码加密格式
0:root:123456
0代表mycat用户登录密码加密
    <user name="root" defaultAccount="true">
        <property name="usingDecrypt">1</property>
        <property name="password">d6D+pOmkuUoY09p4/aivwMsScLa7zfjIwAxvkEhr3v7en06mEXoX9DTTjQNug5CfvGf7Wy9oLcthYI3yLMSjIg==</property>
        <property name="schemas">TESTDB</property>
F8VKn5UHlz5J3pPQSEL/xQiTh9HmKvgd94MOxfPGcvhv1gbrSB8Iw7Hh8eHfS5NlFB2K81UnxOLotNF9ATkYKA==

# 2、修改配置文件当中的配置  标注的地方是需要添加的配置
        <user name="test">
                <property name="usingDecrypt">1</property>
                <property name="password">F8VKn5UHlz5J3pPQSEL/xQiTh9HmKvgd94MOxfPGcvhv1gbrSB8Iw7Hh8eHfS5NlFB2K81UnxOLotNF9ATkYKA==</property>
                <property name="schemas">testr</property>
        </user>

 

 2、schema.xml 密码加密

# 1、密码就加密 标注的地方是需要修改和添加的配置
mycat]$ java -cp lib/Mycat-server-1.6.7.5-release.jar io.mycat.util.DecryptUtil 1:hostM1:root:123456
其中 0:user:password是加密字符串,有两种格式

dataHost加密格式
1:hostM1:root:123456
1代表是dataHost加密
hostM1是<writeHost host="hostM1" 
root是user="root"
123456是 password=明文密码(123456)

对应writeHost配置
        <writeHost host="hostM1" url="localhost:3306" user="root"
                   password="BpkNIjF7LfzS1C76HT7B1bJgmGIDtPihqIvHBlC92L1IFqsMfoJEMk1EkxSzjasWB4GWoUcODYO4AaJstdAp5w==" usingDecrypt="1">
            <!-- can have multi read hosts -->
        </writeHost>

mycat用户登录密码加密格式
0:root:123456
0代表mycat用户登录密码加密
    <user name="root" defaultAccount="true">
        <property name="usingDecrypt">1</property>
        <property name="password">d6D+pOmkuUoY09p4/aivwMsScLa7zfjIwAxvkEhr3v7en06mEXoX9DTTjQNug5CfvGf7Wy9oLcthYI3yLMSjIg==</property>
        <property name="schemas">TESTDB</property>
BpkNIjF7LfzS1C76HT7B1bJgmGIDtPihqIvHBlC92L1IFqsMfoJEMk1EkxSzjasWB4GWoUcODYO4AaJstdAp5w==

# 配置文件修改
<dataHost name="hs3" maxCon="1000" minCon="10" balance="0" writeType="0" dbType="mysql" dbDriver="native" switchType="-1"> 
    <heartbeat>select user()</heartbeat>  
    <writeHost host="hostM1" url="192.168.1.1:3306" user="root" password="BpkNIjF7LfzS1C76HT7B1bJgmGIDtPihqIvHBlC92L1IFqsMfoJEMk1EkxSzjasWB4GWoUcODYO4AaJstdAp5w==" usingDecrypt="1"></writeHost> 
</dataHost>

 3、备注

有些特殊字符，mycat 密码加密时会不识别，故遇到此问题时，需要修改相应的密码。