Whack rcynicng to produce an XML file which rcynic-html can parse:

needs further work, but produces somewhat-useful output now.

Start merging command line argument (argparse) and config file
(ConfigParser) support into a unified library module, in an attempt to
reduce the amount of code duplication and reign in some of the
configuration chaos.  Trigger for this is all of the RP programs now
needing SQL configuration.

Whack rpki.rcynicdb.models to work with PostgreSQL, which has length
restrictions on indexed columns.

svn path=/branches/tk705/; revision=6239

1 files changed, 15 insertions, 3 deletions

diff --git a/rpki/rcynicdb/models.py b/rpki/rcynicdb/models.py
index 09d513d5..185482b1 100644
--- a/rpki/rcynicdb/models.py
+++ b/rpki/rcynicdb/models.py
@@ -31,14 +31,26 @@ class RRDPSnapshot(models.Model):
 #
 # https://docs.djangoproject.com/en/1.9/ref/models/fields/#django.db.models.ForeignKey.on_delete
 #
-# Might also want to provide names for the reverse relationships, code uses blah_set for now.
+# Might also want to provide names for the reverse relationships, code
+# uses blah_set for now.
+
+# Setting unique = True on the der field breaks with PostgreSQL, see
+# https://code.djangoproject.com/ticket/14904
+#
+# In theory collisions on sha256 are possible, but in practice they're
+# not going to occur by accident.  Setting unique = True on the sha256
+# field risks deliberate collisions, defending against that would
+# require detecting the collision and figuring out which is the
+# attacking object (easy in theory, as it probably won't validate),
+# then figuring out what to do about it (possibly harder -- do we drop
+# an entire RRDP zone because of one evil object?).
 
 class RPKIObject(models.Model):
-    der           = models.BinaryField(unique = True)
+    der           = models.BinaryField() # unique = True
     uri           = models.TextField()
     aki           = models.SlugField(max_length = 40)  # hex SHA-1
     ski           = models.SlugField(max_length = 40)  # hex SHA-1
-    sha256        = models.SlugField(max_length = 64) # hex SHA-256
+    sha256        = models.SlugField(max_length = 64, unique = True) # hex SHA-256
     retrieved     = models.ForeignKey(Retrieval)
     authenticated = models.ManyToManyField(Authenticated)
     snapshot      = models.ManyToManyField(RRDPSnapshot)