Hello All,
Please, anyone to help about the problem below?
Thanks in advance.
Best regards, Regivaldo Costa
Doe Sangue. Doe Vida.
----- Mensagem encaminhada -----
De: Regivaldo Gomes Costa <[email protected]>
Para: "[email protected]" <[email protected]>
Enviadas: Sábado, 12 de Novembro de 2016 22:32
Assunto: Help with peeringdb app
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
[email protected]
http://lists.peeringdb.com/cgi-bin/mailman/listinfo/pdb-tech
