From 7a0085714fb909e27834968cb89973e9df70b06d Mon Sep 17 00:00:00 2001 From: MajesticFalcon Date: Sun, 4 Sep 2016 14:05:38 -0700 Subject: UPDATE README.md Add MYSQL docs --- README.md | 86 ++++++++++++++++++++++++++++++++------------------------------- 1 file changed, 44 insertions(+), 42 deletions(-) diff --git a/README.md b/README.md index 0ef212d..d822b21 100644 --- a/README.md +++ b/README.md @@ -400,48 +400,50 @@ vars_map: ... ``` ### Source: SQL - ### Source: MYSQL - ```sudo apt-get install libmysqlclient-dev``` - - The values correspond to your fields in the DB such that ip, model, etc are field names in the DB - - ``` - source: - default: sql - sql: - adapter: mysql - database: oxidized - table: nodes - username: root - password: rootpass - map: - name: ip - model: model - username: username - password: password - vars_map: - enable: enable - ``` - - ### Source: SQLite - - One row per device, filtered by hostname. - - ``` - source: - default: sql - sql: - adapter: sqlite - database: "/var/lib/oxidized/devices.db" - table: devices - map: - name: fqdn - model: model - username: username - password: password - vars_map: - enable: enable - ``` + Oxidized uses the `sequel` ruby gem. You can use a variety of databases that aren't explicitly listed. For more information visit https://github.com/jeremyevans/sequel Make sure you have the correct adapter! +### Source: MYSQL + +```sudo apt-get install libmysqlclient-dev``` + +The values correspond to your fields in the DB such that ip, model, etc are field names in the DB + +``` +source: + default: sql + sql: + adapter: mysql + database: oxidized + table: nodes + username: root + password: rootpass + map: + name: ip + model: model + username: username + password: password + vars_map: + enable: enable +``` + +### Source: SQLite + +One row per device, filtered by hostname. + +``` +source: + default: sql + sql: + adapter: sqlite + database: "/var/lib/oxidized/devices.db" + table: devices + map: + name: fqdn + model: model + username: username + password: password + vars_map: + enable: enable +``` ### Source: HTTP -- cgit v1.2.1