SaltStack实战之远程执行-Returners

た入场券 2022-06-14 04:30 162阅读 0赞

# SaltStack实战之远程执行-Returners #

@(学习)\[SaltStack\]

*  SaltStack实战之远程执行-Returners
    
     *  Returners列表
     *  介绍mysql returner的用法
     *  1 安装pip和MySQLdb
     *  2 配置mysql数据库
     *  2 配置salt-master
     *  3 测试

## 1. Returners列表 ##

[https://docs.saltstack.com/en/latest/ref/returners/all/index.html][https_docs.saltstack.com_en_latest_ref_returners_all_index.html]

<table> 
 <thead> 
  <tr> 
   <th>returners</th> 
   <th>description</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>carbon_return</td> 
   <td>Take data from salt and “return” it into a carbon receiver</td> 
  </tr> 
  <tr> 
   <td>cassandra_cql_return</td> 
   <td>Return data to a cassandra server</td> 
  </tr> 
  <tr> 
   <td>cassandra_return</td> 
   <td>Return data to a Cassandra ColumnFamily</td> 
  </tr> 
  <tr> 
   <td>couchbase_return</td> 
   <td>Simple returner for Couchbase.</td> 
  </tr> 
  <tr> 
   <td>couchdb_return</td> 
   <td>S imple returner for CouchDB.</td> 
  </tr> 
  <tr> 
   <td>django_return</td> 
   <td>A returner that will infor a Django system that returns are available using Django’s signal system.</td> 
  </tr> 
  <tr> 
   <td>elasticsearch_return</td> 
   <td>Return data to an elasticsearch server for indexing.</td> 
  </tr> 
  <tr> 
   <td>etcd_return</td> 
   <td>Return data to an etcd server or cluster</td> 
  </tr> 
  <tr> 
   <td>hipchat_return</td> 
   <td>Return salt data via hipchat.</td> 
  </tr> 
  <tr> 
   <td>influxdb_return</td> 
   <td>Return data to an influxdb server.</td> 
  </tr> 
  <tr> 
   <td>kafka_return</td> 
   <td>Return data to a Kafka topic</td> 
  </tr> 
  <tr> 
   <td>local</td> 
   <td>The local returner is used to test the returner interface, it just prints the</td> 
  </tr> 
  <tr> 
   <td>local_cache</td> 
   <td>Return data to local job cache</td> 
  </tr> 
  <tr> 
   <td>memcache_return</td> 
   <td>Return data to a memcache server</td> 
  </tr> 
  <tr> 
   <td>mongo_future_return</td> 
   <td>Return data to a mongodb server</td> 
  </tr> 
  <tr> 
   <td>mongo_return</td> 
   <td>Return data to a mongodb server</td> 
  </tr> 
  <tr> 
   <td>multi_returner</td> 
   <td>Read/Write multiple returners</td> 
  </tr> 
  <tr> 
   <td>mysql</td> 
   <td>Return data to a mysql server</td> 
  </tr> 
  <tr> 
   <td>nagios_return</td> 
   <td>Return salt data to Nagios</td> 
  </tr> 
  <tr> 
   <td>odbc</td> 
   <td>Return data to an ODBC compliant server.</td> 
  </tr> 
  <tr> 
   <td>pgjsonb</td> 
   <td>Return data to a PostgreSQL server with json data stored in Pg’s jsonb data type</td> 
  </tr> 
  <tr> 
   <td>postgres</td> 
   <td>Return data to a postgresql server</td> 
  </tr> 
  <tr> 
   <td>postgres_local_cache</td> 
   <td>Use a postgresql server for the master job cache.</td> 
  </tr> 
  <tr> 
   <td>pushover_returner</td> 
   <td>Return salt data via pushover (<a href="http://www.pushover.net" rel="nofollow">http://www.pushover.net</a>)</td> 
  </tr> 
  <tr> 
   <td>rawfile_json</td> 
   <td>Take data from salt and “return” it into a raw file containing the json, with one line per event.</td> 
  </tr> 
  <tr> 
   <td>redis_return</td> 
   <td>Return data to a redis server</td> 
  </tr> 
  <tr> 
   <td>sentry_return</td> 
   <td>Salt returner that reports execution results back to sentry.</td> 
  </tr> 
  <tr> 
   <td>slack_returner</td> 
   <td>Return salt data via slack</td> 
  </tr> 
  <tr> 
   <td>sms_return</td> 
   <td>Return data by SMS.</td> 
  </tr> 
  <tr> 
   <td>smtp_return</td> 
   <td>Return salt data via email</td> 
  </tr> 
  <tr> 
   <td>splunk</td> 
   <td>Send json response data to Splunk via the HTTP Event Collector</td> 
  </tr> 
  <tr> 
   <td>sqlite3_return</td> 
   <td>Insert minion return data into a sqlite3 database</td> 
  </tr> 
  <tr> 
   <td>syslog_return</td> 
   <td>Return data to the host operating system’s syslog facility</td> 
  </tr> 
  <tr> 
   <td>xmpp_return</td> 
   <td>Return salt data via xmpp</td> 
  </tr> 
  <tr> 
   <td>zabbix_return</td> 
   <td>Return salt data to Zabbix</td> 
  </tr> 
 </tbody> 
</table>

## 2. 介绍mysql returner的用法 ##

因mysql returner使用需要python MySQLdb模块，所以需要先安装MySQLdb模块。

## 2.1 安装pip和MySQLdb ##

在下列地址下载安装包。  
[https://pypi.python.org/pypi/setuptools][https_pypi.python.org_pypi_setuptools]  
[https://pypi.python.org/pypi/pip/][https_pypi.python.org_pypi_pip]

[root@salt-master111 tmp]# yum -y install python-devel mysql-devel
    [root@salt-master111 tmp]# unzip setuptools-36.0.1.zip
    [root@salt-master111 tmp]# cd setuptools-36.0.1
    [root@salt-master111 tmp]# python setup.py install
    [root@salt-master111 tmp]# cd ../
    [root@salt-master111 tmp]# tar -zxvf pip-9.0.1.tar.gz 
    [root@salt-master111 tmp]# cd pip-9.0.1
    [root@salt-master111 tmp]# python setup.py install
    [root@salt-master111 tmp]# pip install mysql
    [root@salt-master111 tmp]# python
    Python 2.7.5 (default, Nov  6 2016, 00:28:07) 
    [GCC 4.8.5 20150623 (Red Hat 4.8.5-11)] on linux2
    Type "help", "copyright", "credits" or "license" for more information.
    >>> import MySQLdb
    >>>

## 2.2 配置mysql数据库 ##

使用官方的数据表结构，并给minion服务器相关权限。

CREATE DATABASE `salt` DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
    
    USE `salt`;
    
    --
    -- Table structure for table `jids`
    --
    
    DROP TABLE IF EXISTS `jids`;
    CREATE TABLE `jids` ( `jid` varchar(255) NOT NULL, `load` mediumtext NOT NULL, UNIQUE KEY `jid` (`jid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    CREATE INDEX jid ON jids(jid) USING BTREE;
    
    --
    -- Table structure for table `salt_returns`
    --
    
    DROP TABLE IF EXISTS `salt_returns`;
    CREATE TABLE `salt_returns` ( `fun` varchar(50) NOT NULL, `jid` varchar(255) NOT NULL, `return` mediumtext NOT NULL, `id` varchar(255) NOT NULL, `success` varchar(10) NOT NULL, `full_ret` mediumtext NOT NULL, `alter_time` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, KEY `id` (`id`), KEY `jid` (`jid`), KEY `fun` (`fun`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    --
    -- Table structure for table `salt_events`
    --
    
    DROP TABLE IF EXISTS `salt_events`;
    CREATE TABLE `salt_events` ( `id` BIGINT NOT NULL AUTO_INCREMENT, `tag` varchar(255) NOT NULL, `data` mediumtext NOT NULL, `alter_time` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `master_id` varchar(255) NOT NULL, PRIMARY KEY (`id`), KEY `tag` (`tag`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    grant all on salt.* to salt@"10.1.0.%" identified by "saltpass";

## 2.2 配置salt-master ##

`/etc/salt/master`

return: mysql
    mysql.host: 'salt-host'
    mysql.user: 'salt'
    mysql.pass: 'saltpass'
    mysql.db: 'salt'

重启master和minion服务

systemctl restart salt-master
    systemctl restart salt-minion

## 2.3 测试 ##

master端执行命令。

[root@salt-master111 ~]# salt 'salt-master111' test.ping --return mysql
    salt-master111:
        True
    [root@salt-master111 ~]#

在数据库中查看，salt\_returns是否有数据进来。

mysql> select * from salt_returns;
    +-----------+----------------------+--------+----------------+---------+--------------------------------------------------------------------------------------------------------------------------------------------+---------------------+
    | fun       | jid                  | return | id             | success | full_ret                                                                                                                                   | alter_time          |
    +-----------+----------------------+--------+----------------+---------+--------------------------------------------------------------------------------------------------------------------------------------------+---------------------+
    | test.ping | 20170609172835506510 | true   | salt-master111 | 1       | {
       "fun_args": [], "jid": "20170609172835506510", "return": true, "retcode": 0, "success": true, "fun": "test.ping", "id": "salt-master111"} | 2017-06-09 17:28:35 |
    | test.ping | 20170609172841714924 | true   | salt-master111 | 1       | {
       "fun_args": [], "jid": "20170609172841714924", "return": true, "retcode": 0, "success": true, "fun": "test.ping", "id": "salt-master111"} | 2017-06-09 17:28:41 |
    | test.ping | 20170609173636297217 | true   | salt-master111 | 1       | {
       "fun_args": [], "jid": "20170609173636297217", "return": true, "retcode": 0, "success": true, "fun": "test.ping", "id": "salt-master111"} | 2017-06-09 17:36:36 |
    | test.ping | 20170609173653113715 | true   | salt-master111 | 1       | {
       "fun_args": [], "jid": "20170609173653113715", "return": true, "retcode": 0, "success": true, "fun": "test.ping", "id": "salt-master111"} | 2017-06-09 17:36:53 |
    +-----------+----------------------+--------+----------------+---------+--------------------------------------------------------------------------------------------------------------------------------------------+---------------------+
    4 rows in set (0.00 sec)

[https_docs.saltstack.com_en_latest_ref_returners_all_index.html]: https://docs.saltstack.com/en/latest/ref/returners/all/index.html
[https_pypi.python.org_pypi_setuptools]: https://pypi.python.org/pypi/setuptools
[https_pypi.python.org_pypi_pip]: https://pypi.python.org/pypi/pip/