mysql> CREATE DATABASE peeringdb2 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
Query OK, 1 row affected (0,00 sec)

mysql> exit
Bye
rcosta@carbono:~$ peeringdb sync
CREATE TABLE `django_migrations` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `app` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `applied` datetime(6) NOT NULL); (params None)
Operations to perform:
  Synchronize unmigrated apps: django_peeringdb
  Apply all migrations: admin, contenttypes, auth, sessions
Synchronizing apps without migrations:
  Creating tables...
    Creating table peeringdb_organization
CREATE TABLE `peeringdb_organization` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `status` varchar(255) NOT NULL, `created` datetime(6) NOT NULL, `updated` datetime(6) NOT NULL, `version` integer NOT NULL, `address1` varchar(255) NOT NULL, `address2` varchar(255) NOT NULL, `city` varchar(255) NOT NULL, `state` varchar(255) NOT NULL, `zipcode` varchar(48) NOT NULL, `country` varchar(2) NOT NULL, `name` varchar(255) NOT NULL UNIQUE, `website` varchar(255) NOT NULL, `notes` longtext NOT NULL); (params None)
    Creating table peeringdb_facility
CREATE TABLE `peeringdb_facility` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `status` varchar(255) NOT NULL, `created` datetime(6) NOT NULL, `updated` datetime(6) NOT NULL, `version` integer NOT NULL, `address1` varchar(255) NOT NULL, `address2` varchar(255) NOT NULL, `city` varchar(255) NOT NULL, `state` varchar(255) NOT NULL, `zipcode` varchar(48) NOT NULL, `country` varchar(2) NOT NULL, `name` varchar(255) NOT NULL UNIQUE, `website` varchar(255) NOT NULL, `clli` varchar(18) NOT NULL, `rencode` varchar(18) NOT NULL, `npanxx` varchar(21) NOT NULL, `notes` longtext NOT NULL, `org_id` integer NOT NULL); (params None)
    Creating table peeringdb_network
CREATE TABLE `peeringdb_network` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `status` varchar(255) NOT NULL, `created` datetime(6) NOT NULL, `updated` datetime(6) NOT NULL, `version` integer NOT NULL, `asn` integer UNSIGNED NOT NULL UNIQUE, `name` varchar(255) NOT NULL UNIQUE, `aka` varchar(255) NOT NULL, `irr_as_set` varchar(255) NOT NULL, `website` varchar(255) NOT NULL, `looking_glass` varchar(255) NOT NULL, `route_server` varchar(255) NOT NULL, `notes` longtext NOT NULL, `notes_private` longtext NOT NULL, `info_traffic` varchar(39) NOT NULL, `info_ratio` varchar(45) NOT NULL, `info_scope` varchar(39) NOT NULL, `info_type` varchar(60) NOT NULL, `info_prefixes4` integer UNSIGNED NULL, `info_prefixes6` integer UNSIGNED NULL, `info_unicast` bool NOT NULL, `info_multicast` bool NOT NULL, `info_ipv6` bool NOT NULL, `policy_url` varchar(255) NOT NULL, `policy_general` varchar(72) NOT NULL, `policy_locations` varchar(72) NOT NULL, `policy_ratio` bool NOT NULL, `policy_contracts` varchar(36) NOT NULL, `org_id` integer NOT NULL); (params None)
    Creating table peeringdb_ix
CREATE TABLE `peeringdb_ix` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `status` varchar(255) NOT NULL, `created` datetime(6) NOT NULL, `updated` datetime(6) NOT NULL, `version` integer NOT NULL, `name` varchar(64) NOT NULL UNIQUE, `name_long` varchar(254) NOT NULL, `city` varchar(192) NOT NULL, `country` varchar(2) NOT NULL, `notes` longtext NOT NULL, `region_continent` varchar(255) NOT NULL, `media` varchar(128) NOT NULL, `proto_unicast` bool NOT NULL, `proto_multicast` bool NOT NULL, `proto_ipv6` bool NOT NULL, `website` varchar(255) NOT NULL, `url_stats` varchar(255) NOT NULL, `tech_email` varchar(254) NOT NULL, `tech_phone` varchar(192) NOT NULL, `policy_email` varchar(254) NOT NULL, `policy_phone` varchar(192) NOT NULL, `org_id` integer NOT NULL); (params None)
    Creating table peeringdb_ix_facility
CREATE TABLE `peeringdb_ix_facility` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `status` varchar(255) NOT NULL, `created` datetime(6) NOT NULL, `updated` datetime(6) NOT NULL, `version` integer NOT NULL, `ix_id` integer NOT NULL, `fac_id` integer NOT NULL, UNIQUE (`ix_id`, `fac_id`)); (params None)
    Creating table peeringdb_ixlan
CREATE TABLE `peeringdb_ixlan` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `status` varchar(255) NOT NULL, `created` datetime(6) NOT NULL, `updated` datetime(6) NOT NULL, `version` integer NOT NULL, `name` varchar(255) NOT NULL, `descr` longtext NOT NULL, `mtu` integer UNSIGNED NULL, `vlan` integer UNSIGNED NULL, `dot1q_support` bool NOT NULL, `rs_asn` integer UNSIGNED NULL, `arp_sponge` varchar(17) NULL UNIQUE, `ix_id` integer NOT NULL); (params None)
    Creating table peeringdb_ixlan_prefix
CREATE TABLE `peeringdb_ixlan_prefix` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `status` varchar(255) NOT NULL, `created` datetime(6) NOT NULL, `updated` datetime(6) NOT NULL, `version` integer NOT NULL, `notes` varchar(255) NOT NULL, `protocol` varchar(64) NOT NULL, `prefix` varchar(43) NOT NULL UNIQUE, `ixlan_id` integer NOT NULL); (params None)
    Creating table peeringdb_network_contact
CREATE TABLE `peeringdb_network_contact` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `status` varchar(255) NOT NULL, `created` datetime(6) NOT NULL, `updated` datetime(6) NOT NULL, `version` integer NOT NULL, `role` varchar(27) NOT NULL, `visible` varchar(64) NOT NULL, `name` varchar(254) NOT NULL, `phone` varchar(100) NOT NULL, `email` varchar(254) NOT NULL, `url` varchar(255) NOT NULL, `net_id` integer NOT NULL); (params None)
    Creating table peeringdb_network_facility
CREATE TABLE `peeringdb_network_facility` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `status` varchar(255) NOT NULL, `created` datetime(6) NOT NULL, `updated` datetime(6) NOT NULL, `version` integer NOT NULL, `local_asn` integer UNSIGNED NULL, `avail_sonet` bool NOT NULL, `avail_ethernet` bool NOT NULL, `avail_atm` bool NOT NULL, `net_id` integer NOT NULL, `fac_id` integer NOT NULL, UNIQUE (`net_id`, `fac_id`, `local_asn`)); (params None)
    Creating table peeringdb_network_ixlan
CREATE TABLE `peeringdb_network_ixlan` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `status` varchar(255) NOT NULL, `created` datetime(6) NOT NULL, `updated` datetime(6) NOT NULL, `version` integer NOT NULL, `asn` integer UNSIGNED NOT NULL, `ipaddr4` varchar(39) NULL, `ipaddr6` varchar(39) NULL, `is_rs_peer` bool NOT NULL, `notes` varchar(255) NOT NULL, `speed` integer UNSIGNED NOT NULL, `net_id` integer NOT NULL, `ixlan_id` integer NOT NULL); (params None)
    Running deferred SQL...
  Installing custom SQL...
Running migrations:
  Rendering model states... DONE
  Applying contenttypes.0001_initial...CREATE TABLE `django_content_type` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `name` varchar(100) NOT NULL, `app_label` varchar(100) NOT NULL, `model` varchar(100) NOT NULL); (params None)
ALTER TABLE `django_content_type` ADD CONSTRAINT `django_content_type_app_label_45f3b1d93ec8c61c_uniq` UNIQUE (`app_label`, `model`); (params [])
 OK
  Applying auth.0001_initial...CREATE TABLE `auth_permission` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `name` varchar(50) NOT NULL, `content_type_id` integer NOT NULL, `codename` varchar(100) NOT NULL, UNIQUE (`content_type_id`, `codename`)); (params None)
CREATE TABLE `auth_group` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `name` varchar(80) NOT NULL UNIQUE); (params None)
CREATE TABLE `auth_group_permissions` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `group_id` integer NOT NULL, `permission_id` integer NOT NULL, UNIQUE (`group_id`, `permission_id`)); (params None)
CREATE TABLE `auth_user` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `password` varchar(128) NOT NULL, `last_login` datetime(6) NOT NULL, `is_superuser` bool NOT NULL, `username` varchar(30) NOT NULL UNIQUE, `first_name` varchar(30) NOT NULL, `last_name` varchar(30) NOT NULL, `email` varchar(75) NOT NULL, `is_staff` bool NOT NULL, `is_active` bool NOT NULL, `date_joined` datetime(6) NOT NULL); (params None)
CREATE TABLE `auth_user_groups` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `user_id` integer NOT NULL, `group_id` integer NOT NULL, UNIQUE (`user_id`, `group_id`)); (params None)
CREATE TABLE `auth_user_user_permissions` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `user_id` integer NOT NULL, `permission_id` integer NOT NULL, UNIQUE (`user_id`, `permission_id`)); (params None)
ALTER TABLE `auth_permission` ADD CONSTRAINT `auth__content_type_id_508cf46651277a81_fk_django_content_type_id` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`); (params [])
ALTER TABLE `auth_group_permissions` ADD CONSTRAINT `auth_group_permission_group_id_689710a9a73b7457_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`); (params [])
ALTER TABLE `auth_group_permissions` ADD CONSTRAINT `auth_group__permission_id_1f49ccbbdc69d2fc_fk_auth_permission_id` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`); (params [])
ALTER TABLE `auth_user_groups` ADD CONSTRAINT `auth_user_groups_user_id_4b5ed4ffdb8fd9b0_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`); (params [])
ALTER TABLE `auth_user_groups` ADD CONSTRAINT `auth_user_groups_group_id_33ac548dcf5f8e37_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`); (params [])
ALTER TABLE `auth_user_user_permissions` ADD CONSTRAINT `auth_user_user_permissi_user_id_7f0938558328534a_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`); (params [])
ALTER TABLE `auth_user_user_permissions` ADD CONSTRAINT `auth_user_u_permission_id_384b62483d7071f0_fk_auth_permission_id` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`); (params [])
 OK
  Applying admin.0001_initial...CREATE TABLE `django_admin_log` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `action_time` datetime(6) NOT NULL, `object_id` longtext NULL, `object_repr` varchar(200) NOT NULL, `action_flag` smallint UNSIGNED NOT NULL, `change_message` longtext NOT NULL, `content_type_id` integer NULL, `user_id` integer NOT NULL); (params None)
ALTER TABLE `django_admin_log` ADD CONSTRAINT `djang_content_type_id_697914295151027a_fk_django_content_type_id` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`); (params [])
ALTER TABLE `django_admin_log` ADD CONSTRAINT `django_admin_log_user_id_52fdd58701c5f563_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`); (params [])
 OK
  Applying contenttypes.0002_remove_content_type_name...ALTER TABLE `django_content_type` MODIFY `name` varchar(100) NULL; (params [])
ALTER TABLE `django_content_type` DROP COLUMN `name` CASCADE; (params [])
 OK
  Applying auth.0002_alter_permission_name_max_length...ALTER TABLE `auth_permission` MODIFY `name` varchar(255) NOT NULL; (params [])
 OK
  Applying auth.0003_alter_user_email_max_length...ALTER TABLE `auth_user` MODIFY `email` varchar(254) NOT NULL; (params [])
 OK
  Applying auth.0004_alter_user_username_opts... OK
  Applying auth.0005_alter_user_last_login_null...ALTER TABLE `auth_user` MODIFY `last_login` datetime(6) NULL; (params [])
 OK
  Applying auth.0006_require_contenttypes_0002... OK
  Applying sessions.0001_initial...CREATE TABLE `django_session` (`session_key` varchar(40) NOT NULL PRIMARY KEY, `session_data` longtext NOT NULL, `expire_date` datetime(6) NOT NULL); (params None)
CREATE INDEX `django_session_de54fa62` ON `django_session` (`expire_date`); (params [])
 OK
Starting new HTTPS connection (1): beta.peeringdb.com
Traceback (most recent call last):
  File "/usr/local/bin/peeringdb", line 9, in <module>
    load_entry_point('peeringdb==0.4.3', '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 125, in sync
    db.sync()
  File "/usr/local/lib/python2.7/dist-packages/peeringdb/localdb.py", line 97, 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 115, in get_objs
    data = self.rpc.all(cls._handleref.tag, since=since, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/twentyc/rpc/client.py", line 111, in all
    return self._load(self._request(typ, params=kwargs))
  File "/usr/local/lib/python2.7/dist-packages/twentyc/rpc/client.py", line 60, in _request
    return requests.request(method, url, params=params, data=data, auth=auth, headers=headers)
  File "/usr/lib/python2.7/dist-packages/requests/api.py", line 44, in request
    return session.request(method=method, url=url, **kwargs)
  File "/usr/lib/python2.7/dist-packages/requests/sessions.py", line 455, in request
    resp = self.send(prep, **send_kwargs)
  File "/usr/lib/python2.7/dist-packages/requests/sessions.py", line 558, in send
    r = adapter.send(request, **kwargs)
  File "/usr/lib/python2.7/dist-packages/requests/adapters.py", line 378, in send
    raise ConnectionError(e)
requests.exceptions.ConnectionError: HTTPSConnectionPool(host='beta.peeringdb.com', port=443): Max retries exceeded with url: /api/org?since=0 (Caused by <class 'socket.error'>: [Errno 113] No route to host)
rcosta@carbono:~$ telnet beta.peeringdb.com 443
Trying 204.130.133.155...
Trying 2607:fae0:f200:144c::155...
telnet: Unable to connect to remote host: No route to host
rcosta@carbono:~$ telnet 204.130.133.155 443
Trying 204.130.133.155...
telnet: Unable to connect to remote host: Connection refused
rcosta@carbono:~$ peeringdb --version
peeringdb, version 0.4.3
rcosta@carbono:~$