diff options
-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 |