Twisted DB-based auth

  # See twistedmatrix.com/documents/current/core/examples/dbcred.py for DBCredentialsChecker

  # SERVER SETUP
  root = Resource()

  myresource = MyResource()

  pool = adbapi.ConnectionPool('MySQLdb',config.get('database','host'),config.get('database','user'),config.get('database','password'),config.get('database','database'))

  #checker = PasswordChecker()
  checker = DBCredentialsChecker(pool.runQuery, query="SELECT username, password FROM user WHERE username = ?")
  realm = HttpPasswordRealm(myresource)
  p = Portal(realm)
  p.registerChecker(checker)

  credentialFactory = BasicCredentialFactory("Chainsaw Rabbit Games")
  protected_resource = HTTPAuthSessionWrapper(p, [credentialFactory])

  root.putChild('register', Registration())
  root.putChild('example', protected_resource)
  #root.putChild('login', Login())
  factory = Site(root)
  factory.protocol = HTTPChannel
  #reactor.listenTCP(PORT, factory)
  reactor.listenSSL(PORT, factory,
                    ssl.DefaultOpenSSLContextFactory(
                      'ssl/server.key', 'ssl/server.crt'))
  reactor.run()