summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorytti <saku@ytti.fi>2016-09-05 12:15:18 +0300
committerGitHub <noreply@github.com>2016-09-05 12:15:18 +0300
commit8894fe10cbe4beff9aa84d96bd17979847cffb1b (patch)
tree73936a9aa4254632186bd0b1bdbc71827bb2a4a2
parent9ff62fecd46d3be7b3eb8906f728498970914679 (diff)
parentff35d151afa5251fc7a5a131db9bf99c23085925 (diff)
Merge pull request #555 from MajesticFalcon/master
Update README.md SQL
-rw-r--r--README.md29
1 files changed, 28 insertions, 1 deletions
diff --git a/README.md b/README.md
index 342b518..339d9b2 100644
--- a/README.md
+++ b/README.md
@@ -27,7 +27,9 @@ Oxidized is a network device configuration backup tool. It's a RANCID replacemen
* [Privileged mode](#privileged-mode)
* [Disabling SSH exec channels](#disabling-ssh-exec-channels)
* [Source: CSV](#source-csv)
- * [Source: SQLite](#source-sqlite)
+ * [Source: SQL](#source-sql)
+ * [Source: SQLite](#source-sqlite)
+ * [Source: Mysql](#source-mysql)
* [Source: HTTP](#source-http)
* [Output: GIT](#output-git)
* [Output: HTTP](#output-http)
@@ -397,6 +399,31 @@ vars_map:
ssh_proxy: 3
...
```
+### Source: SQL
+ 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: mysql2
+ database: oxidized
+ table: nodes
+ username: root
+ password: rootpass
+ map:
+ name: ip
+ model: model
+ username: username
+ password: password
+ vars_map:
+ enable: enable
+```
### Source: SQLite