DbDat – Db Database Assessment Tool
check_at the begining of the file name. Each file contains a class with a
do_checkmethod. This method is the primary logic for checks. The quick way to get started is to copy an existing check file and modify it. However, see the Developing Plugins section below for more details.
- Be sure you have the necessary dependencies installed for Python scripts to connect to your target database. See dependencies section below.
- Add a connection profile entry in the
etc/dbdat.conffile for each database you want to assess.
python dbdat.py -p <profile name>
- View the report. To view the report
cdto reports directory and run
python -m SimpleHTTPServer 9000(or choose a port number you prefer). Then open your browser and navigate to
To see a list of additional command line arguments run
python dbdat.py -h
The report organizes results by levels, which are RED, YELLOW, ORANGE, GRAY, and GREEN.
- RED – items needing immediate attention.
- YELLOW – items needing review.
- ORANGE – checks that failed to execute properly.
- GRAY – items that may not be applicable to the version of the database being assessed.
- GREEN – items that passed
So far DbDat has been tested on Debian Linux, CentOS Linux, and Windows 7 with Python 2.7
pip install MySQL-python
Or on Debian, run:
apt-get install python-mysqldb
pip install psycopg2
pip install cx_Oracle
Note: you will need to install Oracle client libraries for this to work.
MS SQL support
pip install pymssql
pip install ibm_db or
Note: you will need to ensure the user running DbDat has access to execute DB2 CLP commands (e.g. db2 and db2level).
pip install mongodb
To support MongoDB YAML config files run:
pip install pyyaml
pip install couchdb