Designate - Havana

#### INSTRUCTIONS ####

We depend on the Ubuntu Cloud Archive for Hanava, you MUST install that in addition to this PPA:

$ sudo apt-get update
$ sudo apt-get install --yes ubuntu-cloud-keyring
$ echo "deb http://ubuntu-cloud.archive.canonical.com/ubuntu precise-updates/havana main" | sudo tee /etc/apt/sources.list.d/cloud-archive-havana.list
$ sudo apt-get install --yes python-software-properties
$ sudo apt-add-repository --yes ppa:designate-ppa/havana
$ sudo apt-get update
$ sudo apt-get upgrade --yes
# When asked, set the mysql root password to "password" and
# DO NOT allow dbconfig to create the the powerdns database!
$ sudo apt-get install --yes rabbitmq-server pdns-server pdns-backend-mysql mysql-server
$ sudo apt-get install --yes designateclient designate-api designate-central

Update /etc/designate/designate.conf to include:

  [service:central]
  backend_driver = powerdns

  [storage:sqlalchemy]
  database_connection = mysql://root:password@127.0.0.1/designate

  [backend:powerdns]
  database_connection = mysql://root:password@127.0.0.1/powerdns

$ mysql -u root -p -e 'CREATE DATABASE designate; CREATE DATABASE powerdns;'

$ sudo designate-manage database-init
$ sudo designate-manage database-sync
$ sudo designate-manage powerdns database-init
$ sudo designate-manage powerdns database-sync

$ sudo restart designate-central

Finally, point PowerDNS at the correct database, Update /etc/powerdns/pdns.d/pdns.local.gmysql to include:

    launch=gmysql

    gmysql-host=localhost
    gmysql-port=
    gmysql-dbname=powerdns
    gmysql-user=root
    gmysql-password=password
    gmysql-dnssec=yes

$ sudo service pdns restart
$ designate --os-endpoint http://127.0.0.1:9001/v1 server-create --name ns1.provider.com.
$ designate --os-endpoint http://127.0.0.1:9001/v1 server-create --name ns2.provider.com.
$ designate --os-endpoint http://127.0.0.1:9001/v1 domain-create --name example.com. --email <email address hidden>

$ dig +short NS example.com @127.0.0.1
ns1.provider.com.
ns2.provider.com.