xaoseric / djdns Goto Github PK

The following needs to be added to class Supermaster in powerdns/models.py:

    ip         = models.CharField(max_length=25)

What steps will reproduce the problem?
1. Try to open Supermasters in the admin interface

There is no id column in the Supermasters table, see: 
http://doc.powerdns.com/generic-mypgsql-backends.html

However djdns tries to use it:

Traceback:
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/core/handl
ers/base.py" in get_response
  100.                     response = callback(request, *callback_args, **callback_kwargs)
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/contrib/ad
min/sites.py" in root
  512.                 return self.model_page(request, *url.split('/', 2))
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/views/deco
rators/cache.py" in _wrapped_view_func
  69.         response = view_func(request, *args, **kwargs)
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/contrib/ad
min/sites.py" in model_page
  531.         return admin_obj(request, rest_of_url)
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/contrib/ad
min/options.py" in __call__
  1188.             return self.changelist_view(request)
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/utils/deco
rators.py" in _wrapper
  21.             return decorator(bound_func)(*args, **kwargs)
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/utils/deco
rators.py" in _wrapped_view
  76.                     response = view_func(request, *args, **kwargs)
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/utils/deco
rators.py" in bound_func
  17.                 return func(self, *args2, **kwargs2)
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/contrib/ad
min/options.py" in changelist_view
  1071.             'selection_note': _('0 of %(cnt)s selected') % {'cnt': len(cl.result_list)},
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/db/models/
query.py" in __len__
  81.                 self._result_cache = list(self.iterator())
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/db/models/
query.py" in iterator
  269.         for row in compiler.results_iter():
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/db/models/
sql/compiler.py" in results_iter
  672.         for rows in self.execute_sql(MULTI):
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/db/models/
sql/compiler.py" in execute_sql
  727.         cursor.execute(sql, params)
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/db/backend
s/util.py" in execute
  15.             return self.cursor.execute(sql, params)
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/db/backend
s/postgresql_psycopg2/base.py" in execute
  44.             return self.cursor.execute(query, args)

Exception Type: DatabaseError at /admin/djdns/supermaster/
Exception Value: column supermasters.id does not exist
LINE 1: SELECT "supermasters"."id", "supermasters"."ip", "supermaste...
               ^

What steps will reproduce the problem?
1. Clicking on Powerdns -> Imported zone files
2. See nasty error :(
3.

Traceback:
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/core/handl
ers/base.py" in get_response
  100.                     response = callback(request, *callback_args, **callback_kwargs)
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/contrib/ad
min/sites.py" in root
  512.                 return self.model_page(request, *url.split('/', 2))
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/views/deco
rators/cache.py" in _wrapped_view_func
  69.         response = view_func(request, *args, **kwargs)
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/contrib/ad
min/sites.py" in model_page
  531.         return admin_obj(request, rest_of_url)
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/contrib/ad
min/options.py" in __call__
  1188.             return self.changelist_view(request)
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/utils/deco
rators.py" in _wrapper
  21.             return decorator(bound_func)(*args, **kwargs)
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/utils/deco
rators.py" in _wrapped_view
  76.                     response = view_func(request, *args, **kwargs)
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/utils/deco
rators.py" in bound_func
  17.                 return func(self, *args2, **kwargs2)
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/contrib/ad
min/options.py" in changelist_view
  968.                 self.date_hierarchy, self.search_fields, self.list_select_related, self.list_per_page, self.list_editable, self)
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/contrib/ad
min/views/main.py" in __init__
  64.         self.get_results(request)
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/contrib/ad
min/views/main.py" in get_results
  98.         result_count = paginator.count
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/core/pagin
ator.py" in _get_count
  48.                 self._count = self.object_list.count()
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/db/models/
query.py" in count
  326.         return self.query.get_count(using=self.db)
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/db/models/
sql/query.py" in get_count
  394.         number = obj.get_aggregation(using=using)[None]
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/db/models/
sql/query.py" in get_aggregation
  366.         result = query.get_compiler(using).execute_sql(SINGLE)
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/db/models/
sql/compiler.py" in execute_sql
  727.         cursor.execute(sql, params)
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/db/backend
s/util.py" in execute
  15.             return self.cursor.execute(sql, params)
File 
"/usr/local/lib/python2.6/dist-packages/Django-1.2.1-py2.6.egg/django/db/backend
s/postgresql_psycopg2/base.py" in execute
  44.             return self.cursor.execute(query, args)

Exception Type: DatabaseError at /admin/powerdns/importedzonefile/
Exception Value: relation "powerdns_importedzonefile" does not exist
LINE 1: SELECT COUNT(*) FROM "powerdns_importedzonefile"