Jumpserver实践记录

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13

wget http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm
rpm -ivh mysql57-community-release-el7-7.noarch.rpm
yum install -y mysql-community-server
systemctl start mysqld.service
mysqladmin -uroot -p password "your_password"
pip uninstall pycrypto
rm -rf /usr/lib64/python2.6/site-packages/Crypto/
rm -rf  /usr/lib64/python2.6/site-packages/pycrypto-2.6.1-py2.6-linux-x86_64.egg
pip install pycrypto==2.4.1
wget https://www.python.org/ftp/python/3.6.0/Python-3.6.0.tar.xz
tar xvf Python-3.6.0.tar.xz;cd Python-3.6.0
./configure --prefix=/usr/local/python3
make && make install

1
2

#My path: vim /data/jumpserver_pkg/jumpserver-master/install/install.py
python install.py #直接执行即可

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17

---
#name:get_ec2_host_list.yml
- hosts: localhost
  connection: local
  gather_facts: True
  tasks:
    - name: ec2 instance facts
      ec2_remote_facts:
        region: cn-north-1
        filters:
          instance-state-name:  running
      register: ec2
    - set_fact: ec2_out={{ ec2 }}
    - shell: rm -rf running_ec2_list.txt
    - shell: echo "{{ item.0.private_ip_address }}"  "{{item.0.tags.Name}}" >> running_ec2_list.txt
      with_together:
        - "{{ ec2_out.instances }}"

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50

#!/usr/bin/python
# -*- coding:utf-8 -*-
###############################################################################
#Author: arvon
#Email: yafeng2011@126.com
#Blog: http://blog.arvon.top/
#Date: 2017-05-23
#Filename: write_jumpserver_host.py
#Revision: 1.0
#License: GPL
#Description: use ansible get host list then use xlrd module write excel
#Notes:
###############################################################################
import os
import openpyxl
#vars
port='22'
host_group='group_name'
aws_access_id='your_id'
aws_secret_id='your_id'
server_file_name='./running_ec2_list.txt'
dest_filename = 'asset_cn_dev.xlsx'
##functions
def create_server_file():
  os.environ['AWS_ACCESS_KEY_ID'] = aws_access_id
  os.environ['AWS_SECRET_ACCESS_KEY'] = aws_secret_id
  os.system('ansible-playbook get_ec2_host_list.yml')
def write_jumpserver_excel():
  wb = openpyxl.Workbook()
  ws1 = wb.active
  ws1.title = 'Assets'
  ws1.append(['IP地址','端口号','主机名','管理账号','用户名','密码','主机组'])
  with open (server_file_name, 'r') as f1:
      server_num = len(open(server_file_name,'rU').readlines())
      row = int(2)
      for eachline in f1:
          server_info=eachline.split()
          private_ip=server_info[0]
          tag_name=server_info[1]
          ws1.cell(column=1,row=row,value=private_ip)
          ws1.cell(column=2,row=row,value=port)
          ws1.cell(column=3,row=row,value=tag_name)
          ws1.cell(column=4,row=row,value='默认')
          ws1.cell(column=5,row=row,value='')
          ws1.cell(column=6, row=row, value='')
          ws1.cell(column=7, row=row, value=host_group)
          wb.save(filename=dest_filename)
          row=row+1
if __name__=='__main__':
  write_jumpserver_excel()