certtools / contactdb Goto Github PK

Hi! From the README it is unclear (to me) what the goal is? A standalone contact database? Or is there a public interface running somewhere?

Context: I am a security researcher and want to escalate to national CSIRTs occasionally. The current contacts at cert.org are outdated (many bounces) so a centralized list of incident report email addresses would be useful.

I've processed bounces and replies in a shared Google spreadsheet

and import intevation code

It seems recommended OS is Ubuntu 12.04. However

1. have to modify install_deps.sh to switch postgres to 9.1
2. when running it:
   ...
   Setting up python-dev (2.7.3-0ubuntu2.2) ...

• sudo sed -i 's/^(local[ ]_all[ ]_all.*)peer/\1trust/' /etc/postgresql/9.1/main/pg_hba.conf
  sed: can't read /etc/postgresql/9.1/main/pg_hba.conf: No such file or directory
  ...

• @aaronkaplan make sure the use cases for the automatisation are all covered
• @stelen sign off use cases with others
• Result: use-case document exists

ETA: 10.11.

1. Install instructions dont mention install_deps.sh
2. Fatal issue with Django: (ref jazzband/django-oauth-toolkit#204)
   ...
   Creating table contactdb_tld
   Running deferred SQL...
   Traceback (most recent call last):
   File "/root/contactdb/virtenv/bin/django-admin", line 9, in
   load_entry_point('Django==1.8.1', 'console_scripts', 'django-admin')()
   File "/root/contactdb/virtenv/local/lib/python2.7/site-packages/django/core/management/init.py", line 338, in execute_from_command_line
   utility.execute()
   File "/root/contactdb/virtenv/local/lib/python2.7/site-packages/django/core/management/init.py", line 330, in execute
   self.fetch_command(subcommand).run_from_argv(self.argv)
   File "/root/contactdb/virtenv/local/lib/python2.7/site-packages/django/core/management/base.py", line 390, in run_from_argv
   self.execute(_args, *_cmd_options)
   File "/root/contactdb/virtenv/local/lib/python2.7/site-packages/django/core/management/base.py", line 441, in execute
   output = self.handle(_args, *_options)
   File "/root/contactdb/virtenv/local/lib/python2.7/site-packages/django/core/management/commands/syncdb.py", line 25, in handle
   call_command("migrate", *_options)
   File "/root/contactdb/virtenv/local/lib/python2.7/site-packages/django/core/management/init.py", line 120, in call_command
   return command.execute(_args, *_defaults)
   File "/root/contactdb/virtenv/local/lib/python2.7/site-packages/django/core/management/base.py", line 441, in execute
   output = self.handle(_args, **options)
   File "/root/contactdb/virtenv/local/lib/python2.7/site-packages/django/core/management/commands/migrate.py", line 179, in handle
   created_models = self.sync_apps(connection, executor.loader.unmigrated_apps)
   File "/root/contactdb/virtenv/local/lib/python2.7/site-packages/django/core/management/commands/migrate.py", line 317, in sync_apps
   cursor.execute(statement)
   File "/root/contactdb/virtenv/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 79, in execute
   return super(CursorDebugWrapper, self).execute(sql, params)
   File "/root/contactdb/virtenv/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute
   return self.cursor.execute(sql, params)
   File "/root/contactdb/virtenv/local/lib/python2.7/site-packages/django/db/utils.py", line 97, in exit
   six.reraise(dj_exc_type, dj_exc_value, traceback)
   File "/root/contactdb/virtenv/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 62, in execute
   return self.cursor.execute(sql)
   django.db.utils.ProgrammingError: relation "auth_user" does not exist

Try to re-use code, UI, etc.

Implement the https://api.first.org/ syntax and semantics

We need to cover also the personal contacts ("qualitative contacts" as opposed to abuse_c role contacts)

Fill in test data and test out the use-cases

Depends on #9

• SOGo
• RIPE data

• check ftp://ftp.ripe.net/ripe/docs/ripe-658.pdf
• re-check the different fields of the DBs (is the comparison still current)
  • TI, FIRST, RIPE new demo DB
• decide on our fields in order to stay agile with DB import- / export