构建企业级网络设备自动备份系统 -- Oxidized 安全加固（四）

source:
  default: csv
  csv:
    file: "/home/ubuntu/.config/oxidized/router.db"
    delimiter: !ruby/regexp /:/
    map:
      name: 0
      model: 1
      username: 2
      password: 3
      group: 4
    vars_map:
      ssh_port: 5

192.168.99.1:vrp:admin:password:group1:2222
192.168.99.254:vrp:admin:passwoord:group1

source:
  default: sql
  sql:
    adapter: mysql2
    database: oxidized
    table: net_dev
    user: oxidized
    password: oxidized
    host: 192.168.99.227
    map:
      name: name
      model: model 
      username: username
      password: password
      group: group
    vars_map:
      ssh_port: port

#创建 oxidized 数据库
create database oxidized character set utf8 collate utf8_bin;
#oxidized 库用户授权
grant all PRIVILEGES on oxidized.* to 'oxidized'@'%' IDENTIFIED BY 'oxidized';
#刷新权限
FLUSH PRIVILEGES;

CREATE TABLE `net_dev` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` text NOT NULL,
  `model` text NOT NULL,
  `username` text NOT NULL,
  `password` text NOT NULL,
  `group` text NOT NULL,
  `port` char(32)
) ;

use oxidized;

show  tables;

select * from net_dev;

INSERT INTO `net_dev`(`id`,`name`,`model`,`username`,`password`,`group`,`port`) VALUES ('1','192.168.99.1','vrp','admin','password','group1','2222');

INSERT INTO `net_dev`(`id`,`name`,`model`,`username`,`password`,`group`,`port`) VALUES ('5','192.168.99.254','comware','admin','password','group1');

delete from net_dev where id = 2;

update oxidized.net_dev set password='123456'  where id='1';