diff options
| -rw-r--r-- | README.md | 25 | 
1 files changed, 25 insertions, 0 deletions
| @@ -397,6 +397,31 @@ vars_map:    ssh_proxy: 3  ...  ``` +### Source: SQL->MYSQL + +One row per device, filtered by hostname +require 'mysql' +sudo apt-get install libmysqlclient-dev + +``` +source: +  default: sql +  sql: +    adapter: mysql +    database: oxidized +    table: nodes +    username: root #Make sure the user has permissions to login  +    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 +      model: model +      username: username +      password: password +    vars_map: +      enable: enable +```  ### Source: SQLite | 
