returner 将salt直接结果存入mysql问题

<1>按照官方资料在远程MySQL上创建salt数据库

详见官方returnner的MySQL配置:http://docs.saltstack.cn/ref/returners/all/salt.returners.mysql.html#module-salt.returners.mysql

<2>授权salt用户可以远程操作该salt数据库

grant all on salt.* to salt@'%' identified by 'salt@pw';    

<3>minion配置文件中安装MySQL-python模块 / 添加MySQL配置 / 重启

yum -y install MySQL-python

vim /etc/salt/minion
#return: mysql
mysql.host: '192.168.137.132'
mysql.user: 'salt'
mysql.pass: 'salt@pw'
mysql.db: 'salt'
mysql.port: 3306

systemctl restart salt-minion

<4>利用 --return mysql选项,将执行结果存入数据库

select * from salt_returns;