Hello All, I need help regarding peeringdb application.
I'm using Ubuntu 14.04, and after have been installed the peeringdb application using pip, I made the configuration in according my database. However, when I used the sync command, the application created the tables, but in "migration" phase, occurs an error. In the attached file is the execution trail until the error occur. In the last lines I ran some command to debug as can be seen. I'll grateful for any help. Thanks a lot. Best regards, Regivaldo Costa Doe Sangue. Doe Vida.
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:~$
_______________________________________________ Pdb-tech mailing list Pdb-tech@lists.peeringdb.com http://lists.peeringdb.com/cgi-bin/mailman/listinfo/pdb-tech