Something's not going right here:
$ /usr/local/bin/peeringdb sync
Operations to perform:
Synchronize unmigrated apps: django_peeringdb
Apply all migrations: admin, contenttypes, auth, sessions
Synchronizing apps without migrations:
Creating tables...
Running deferred SQL...
Installing custom SQL...
Running migrations:
No migrations to apply.
Starting new HTTPS connection (1): www.peeringdb.com
"GET /api/org?since=1470142503 HTTP/1.1" 200 None
org last update 1470142503 0 changed
data to be processed 0
Starting new HTTPS connection (1): www.peeringdb.com
"GET /api/fac?since=1470088505 HTTP/1.1" 200 None
fac last update 1470088505 0 changed
data to be processed 0
Starting new HTTPS connection (1): www.peeringdb.com
"GET /api/net?since=1469642106 HTTP/1.1" 200 None
net last update 1469642106 110 changed
data to be processed 110
Traceback (most recent call last):
File "/usr/local/bin/peeringdb", line 9, in <module>
load_entry_point('peeringdb==0.4.3.2', 'console_scripts', 'peeringdb')()
File "/usr/local/lib/python2.7/dist-packages/click/core.py", line 716,
in __call__
return self.main(*args, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/click/core.py", line 696,
in main
rv = self.invoke(ctx)
File "/usr/local/lib/python2.7/dist-packages/click/core.py", line
1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/usr/local/lib/python2.7/dist-packages/click/core.py", line 889,
in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/usr/local/lib/python2.7/dist-packages/click/core.py", line 534,
in invoke
return callback(*args, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/peeringdb/cli.py", line
169, in sync
db.sync()
File "/usr/local/lib/python2.7/dist-packages/peeringdb/localdb.py",
line 140, in sync
call_command('pdb_sync', interactive=False)
File
"/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py",
line 120, in call_command
return command.execute(*args, **defaults)
File
"/usr/local/lib/python2.7/dist-packages/django/core/management/base.py",
line 445, in execute
output = self.handle(*args, **options)
File
"/usr/local/lib/python2.7/dist-packages/django_peeringdb/management/commands/pdb_sync.py",
line 85, in handle
self.sync(tables)
File
"/usr/local/lib/python2.7/dist-packages/django_peeringdb/management/commands/pdb_sync.py",
line 92, in sync
self.update_db(cls, self.get_objs(cls))
File
"/usr/local/lib/python2.7/dist-packages/django_peeringdb/management/commands/pdb_sync.py",
line 127, in update_db
sync.sync_obj(cls, row)
File
"/usr/local/lib/python2.7/dist-packages/django_peeringdb/sync.py", line
25, in sync_obj
obj.full_clean()
File
"/usr/local/lib/python2.7/dist-packages/django/db/models/base.py", line
1171, in full_clean
raise ValidationError(errors)
django.core.exceptions.ValidationError: {'org': [u'organization instance
with id 14675 does not exist.']}
~paul
Didn’t see an obvious thread already, but in case of the Django MySQL module being missing:
(pdbvenv)Martys-MacBook-Air:.peeringdb Marty$ peeringdb sync
Traceback (most recent call last):
File "/Users/Marty/pdbvenv/bin/peeringdb", line 9, in <module>
load_entry_point('peeringdb==0.4.4', 'console_scripts', 'peeringdb')()
File "/Users/Marty/pdbvenv/lib/python2.7/site-packages/click/core.py", line 716, in __call__
return self.main(*args, **kwargs)
File "/Users/Marty/pdbvenv/lib/python2.7/site-packages/click/core.py", line 696, in main
rv = self.invoke(ctx)
File "/Users/Marty/pdbvenv/lib/python2.7/site-packages/click/core.py", line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/Users/Marty/pdbvenv/lib/python2.7/site-packages/click/core.py", line 889, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/Users/Marty/pdbvenv/lib/python2.7/site-packages/click/core.py", line 534, in invoke
return callback(*args, **kwargs)
File "/Users/Marty/pdbvenv/lib/python2.7/site-packages/peeringdb/cli.py", line 166, in sync
db = LocalDB(cfg)
File "/Users/Marty/pdbvenv/lib/python2.7/site-packages/peeringdb/localdb.py", line 105, in __init__
django.setup()
File "/Users/Marty/pdbvenv/lib/python2.7/site-packages/django/__init__.py", line 18, in setup
apps.populate(settings.INSTALLED_APPS)
File "/Users/Marty/pdbvenv/lib/python2.7/site-packages/django/apps/registry.py", line 108, in populate
app_config.import_models(all_models)
File "/Users/Marty/pdbvenv/lib/python2.7/site-packages/django/apps/config.py", line 198, in import_models
self.models_module = import_module(models_module_name)
File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/importlib/__init__.py", line 37, in import_module
__import__(name)
File "/Users/Marty/pdbvenv/lib/python2.7/site-packages/django/contrib/auth/models.py", line 41, in <module>
class Permission(models.Model):
File "/Users/Marty/pdbvenv/lib/python2.7/site-packages/django/db/models/base.py", line 139, in __new__
new_class.add_to_class('_meta', Options(meta, **kwargs))
File "/Users/Marty/pdbvenv/lib/python2.7/site-packages/django/db/models/base.py", line 324, in add_to_class
value.contribute_to_class(cls, name)
File "/Users/Marty/pdbvenv/lib/python2.7/site-packages/django/db/models/options.py", line 250, in contribute_to_class
self.db_table = truncate_name(self.db_table, connection.ops.max_name_length())
File "/Users/Marty/pdbvenv/lib/python2.7/site-packages/django/db/__init__.py", line 36, in __getattr__
return getattr(connections[DEFAULT_DB_ALIAS], item)
File "/Users/Marty/pdbvenv/lib/python2.7/site-packages/django/db/utils.py", line 241, in __getitem__
backend = load_backend(db['ENGINE'])
File "/Users/Marty/pdbvenv/lib/python2.7/site-packages/django/db/utils.py", line 112, in load_backend
return import_module('%s.base' % backend_name)
File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/importlib/__init__.py", line 37, in import_module
__import__(name)
File "/Users/Marty/pdbvenv/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 27, in <module>
raise ImproperlyConfigured("Error loading MySQLdb module: %s" % e)
django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb
pip install MySQL-python seems to fix the error
Regards,
Marty Strong
--------------------------------------
CloudFlare - AS13335
Network Engineer
marty(a)cloudflare.com
+44 7584 906 055
smartflare (Skype)
https://www.peeringdb.com/asn/13335
Since I'm using PeeringDB as a base to administer all of our peering
sessions, and we need to be able to contact every peering partner in
case of any issues, I'd like to have at least one e-mail address listed
for each network / org.
Currently this is not the case, for example:
https://peeringdb.com/net/10532
This is a problem for a script that I just wrote that wants to contact
peers with broken sessions.
Would it be possible to make contact information (in particular e-mail)
a requirement for every network / org?
~paul
