summaryrefslogtreecommitdiff
path: root/README.md
diff options
context:
space:
mode:
authorMajesticFalcon <Schylarutley@hotmail.com>2016-09-04 13:58:28 -0700
committerGitHub <noreply@github.com>2016-09-04 13:58:28 -0700
commitaa2d7a53eabc4d519c19fc42845643dfc4e807c1 (patch)
tree21825844171d5acf74578f7a7cdc42a62a7799cc /README.md
parent5c16ce270b427da30e225897fcd6b4854856f1da (diff)
UPDATE README.md
Add MYSQL help
Diffstat (limited to 'README.md')
-rw-r--r--README.md19
1 files 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