From aa2d7a53eabc4d519c19fc42845643dfc4e807c1 Mon Sep 17 00:00:00 2001 From: MajesticFalcon Date: Sun, 4 Sep 2016 13:58:28 -0700 Subject: UPDATE README.md Add MYSQL help --- README.md | 19 ++++++++++++++----- 1 file changed, 14 insertions(+), 5 deletions(-) diff --git a/README.md b/README.md index 10411f8..f7a6372 100644 --- a/README.md +++ b/README.md @@ -399,13 +399,23 @@ vars_map: ssh_proxy: 3 ... ``` - +### Source: SQL ### Source: MYSQL One row per device, filtered by hostname + require 'mysql' + sudo apt-get install libmysqlclient-dev +Make sure the user has permissions to login + +The keys inside the map hash are static + +The values correspond to your fields in the DB + +ip, model, etc are field names in the DB + ``` source: default: sql @@ -413,12 +423,11 @@ source: adapter: mysql database: oxidized table: nodes - username: root #Make sure the user has permissions to login + username: root 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 + name: ip model: model username: username password: password -- cgit v1.2.1