背景:机器websql拥有所有RDS白名单,rundeck需要访问RDS,rundeck无RDS访问白名单
解决方案:现在rundeck上配置不同节点,在websql上做端口映射
1、#rundeck机器配置节点
#cd /home/sc/rundeck/projects/database_select/etc #database_select为rundeck上你的工程
# vim resources.xml
<node name="item_service" node-executor="jdbc-command" db-type="MYSQL" jdbc-connect="jdbc:mysql://10.47.49.77:33306/item?useUnicode=true&characterEncoding=UTF-8"
jdbc-username="wsql_r" jdbc-password="xxxxx" description="item_service" tags="" hostname="10.47.49.77" osArch="amd64" osFamily="unix" osName="Linux" osVersion="4.4.0-117-generic" username="souche"/>
#其中10.47.49.77为websql ip
2、mysql机器端口映射
# su root
# vim /etc/rinetd.conf
# bindadress bindport connectaddress connectport
10.47.49.77 33306 rm-xxxxxx.mysql.rds.aliyuncs.com 3306
# service rinetd reload
3、这样就可以了