saltstack 執行結果傳回到mysql

系統：ubuntu 17.04

官方文檔https://docs.saltstack.com/en/latest/ref/returners/all/salt.returners.mysql.html

master

（salt-master ， mysql，python2.7-mysql）

syndic

（salt-master，mysql-client，salt-syndic，python2.7-mysql）

minion

（salt-minion，mysql-client，python2.7-mysql）

#cat /etc/salt/master|grep -v "#" |grep -v "^ *$"

ipv6: false

interface: 192.168.90.177

auto_accept: true

state_top: top.sls

order_masters: true

return: mysql

################################mysql##################################

create database <code>salt</code>

default character set utf8

default collate utf8_general_ci;

use <code>salt</code>;

drop table if exists <code>jids</code>;

create table <code>jids</code> (

<code>jid</code> varchar(255) not null,

<code>load</code> mediumtext not null,

unique key <code>jid</code> (<code>jid</code>)

) engine=innodb default charset=utf8;

drop table if exists <code>salt_returns</code>;

create table <code>salt_returns</code> (

<code>fun</code> varchar(50) not null,

<code>return</code> mediumtext not null,

<code>id</code> varchar(255) not null,

<code>success</code> varchar(10) not null,

<code>full_ret</code> mediumtext not null,

<code>alter_time</code> timestamp default current_timestamp,

key <code>id</code> (<code>id</code>),

key <code>jid</code> (<code>jid</code>),

key <code>fun</code> (<code>fun</code>)

drop table if exists <code>salt_events</code>;

create table <code>salt_events</code> (

<code>id</code> bigint not null auto_increment,

<code>tag</code> varchar(255) not null,

<code>data</code> varchar(1024) not null,

primary key (<code>id</code>),

key <code>tag</code> (<code>tag</code>)

mysql&gt; use salt

mysql&gt; show tables;

+----------------+

| tables_in_salt |

| jids |

| salt_events |

| salt_returns |

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

（此為ubuntu上的mysql）

root@jy-kvm1:~# cat /etc/mysql/mysql.conf.d/mysqld.cnf |grep bind

#bind-address = 127.0.0.1 #注釋掉，允許其他機器通路

#########################################################################

file_roots:

base:

/etc/salt/base

prod:

/etc/salt/prod

syndic_master: 192.168.90.177

#cat /etc/salt/minion|grep -v "#" |grep -v "^ *$"

master: 192.168.90.178

id: 192.168.90.179

mysql.host: '192.168.90.177'

mysql.user: 'salt'

mysql.pass: 'salt'

mysql.db: 'salt'

mysql.port: 3306

在master上執行

#salt '*' test.ping

檢視資料庫

6. row

fun: test.ping

jid: 20171204130021772990

return: true

success: 1

full_ret: {"fun_args": [], "jid": "20171204130021772990", "return": true, "retcode": 0, "success": true, "fun": "test.ping", "id": "192.168.90.179"}

alter_time: 2017-12-04 13:00:23

6 rows in set (0.01 sec)

error:

no query specified

mysql&gt;