More cleanup and setup for TK with our openstack setup

- Converge the attributes at the top since they should stay the same for each
  suite.
- Properly add the ops-database cookbooks to setup the mysql instance locallyl
  for TK testing
- Add tests for managed roles
- Add recipes for controller and compute which includes firewall rules