From 52c8427e532be178d106d015b764213b1d345d10 Mon Sep 17 00:00:00 2001 From: Schylar Utley Date: Sun, 4 Sep 2016 13:52:34 -0700 Subject: Update README.md --- README.md | 25 +++++++++++++++++++++++++ 1 file changed, 25 insertions(+) diff --git a/README.md b/README.md index 342b518..03583e5 100644 --- a/README.md +++ b/README.md @@ -397,6 +397,31 @@ vars_map: ssh_proxy: 3 ... ``` +### Source: SQL->MYSQL + +One row per device, filtered by hostname +require 'mysql' +sudo apt-get install libmysqlclient-dev + +``` +source: + default: sql + sql: + adapter: mysql + database: oxidized + table: nodes + username: root #Make sure the user has permissions to login + password: rootpass + #The keys inside the map hash are static + #The values correspond to your fields in the DB + map: + name: ip #<-- IP is a field + model: model + username: username + password: password + vars_map: + enable: enable +``` ### Source: SQLite -- cgit v1.2.1