diff options
author | MajesticFalcon <Schylarutley@hotmail.com> | 2016-09-04 13:58:28 -0700 |
---|---|---|
committer | GitHub <noreply@github.com> | 2016-09-04 13:58:28 -0700 |
commit | aa2d7a53eabc4d519c19fc42845643dfc4e807c1 (patch) | |
tree | 21825844171d5acf74578f7a7cdc42a62a7799cc | |
parent | 5c16ce270b427da30e225897fcd6b4854856f1da (diff) |
UPDATE README.md
Add MYSQL help
-rw-r--r-- | README.md | 19 |
1 files changed, 14 insertions, 5 deletions
@@ -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 |