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 | 
