Activity log for bug #1746187

Date Who What changed Old value New value Message
2018-01-30 08:04:16 miaoyuliang bug added bug
2018-01-30 08:11:33 miaoyuliang summary designate record-list can't list ptr records and ptr designate can't list ptr records and ptr zone
2018-01-30 08:38:55 miaoyuliang description follow the use case1:https://docs.openstack.org/ocata/networking-guide/config-dns-int.html , all by admin user. follow the use case2:https://docs.openstack.org/ocata/networking-guide/config-dns-int.html , run the command #designate record-list test.com., the output is the same as the use case2, but the command #designate record-list 0.168.192.in-addr.arpa.shows: "/usr/lib/python2.7/site-packages/designateclient/cli/base.py:38: DeprecationWarning: The "designate" CLI is being deprecated in favour of the "openstack" CLI plugin. All designate API v2 commands are implemented there. When the v1 API is removed this CLI will stop functioning DeprecationWarning) ERROR: Could not find resource with name "0.168.192.in-addr.arpa." the command #openstack zone list can not show the ptr zone,the following is the out put: +--------------------------------------+-----------+---------+------------+--------+--------+ | id | name | type | serial | status | action | +--------------------------------------+-----------+---------+------------+--------+--------+ | cc47ecdb-3658-4ac9-a4e7-6cf31c4e2b2b | test.com. | PRIMARY | 1516996184 | ACTIVE | NONE | +--------------------------------------+-----------+---------+------------+--------+--------+ but in the database,it has the ptr zone and ptr records below: MariaDB [designate]> select * from zones; +----------------------------------+---------------------+---------------------+---------+----------------------------------+-------------------------+------------------+------+---------+-------+--------+---------+----------------+------------+----------------------------------+---------------------+--------------------------------------------------------------+---------+--------+----------------------------------+-------------------------+---------+----------------+-------+----------------+ | id | created_at | updated_at | version | tenant_id | name | email | ttl | refresh | retry | expire | minimum | parent_zone_id | serial | deleted | deleted_at | description | status | action | pool_id | reverse_name | type | transferred_at | shard | delayed_notify | +----------------------------------+---------------------+---------------------+---------+----------------------------------+-------------------------+------------------+------+---------+-------+--------+---------+----------------+------------+----------------------------------+---------------------+--------------------------------------------------------------+---------+--------+----------------------------------+-------------------------+---------+----------------+-------+----------------+ | cc47ecdb36584ac9a4e76cf31c4e2b2b | 2018-01-26 19:37:55 | 2018-01-26 19:49:49 | 4 | 348df301bd2a4bb9b643d410bfaf1884 | test.com. | admin@test.com | 3600 | 3587 | 600 | 86400 | 3600 | NULL | 1516996184 | 0 | NULL | NULL | ACTIVE | NONE | 794ccc2cd75144feb57f8894c9f5c842 | .moc.tset | PRIMARY | NULL | 3268 | 0 | | cefd439a4e7d4567813d12035ac7f108 | 2018-01-26 19:49:46 | 2018-01-26 19:49:51 | 4 | 5bdf8e34a3f746fa99729428f9cbf49d | 0.168.192.in-addr.arpa. | admin@test.com | 3600 | 3537 | 600 | 86400 | 3600 | NULL | 1516996187 | 0 | NULL | An in-addr.arpa. zone for reverse lookups set up by Neutron. | ACTIVE | NONE | 794ccc2cd75144feb57f8894c9f5c842 | .apra.rdda-ni.291.861.0 | PRIMARY | NULL | 3311 | 0 | +----------------------------------+---------------------+---------------------+---------+----------------------------------+-------------------------+------------------+------+---------+-------+--------+---------+----------------+------------+----------------------------------+---------------------+--------------------------------------------------------------+---------+--------+----------------------------------+-------------------------+---------+----------------+-------+----------------+ MariaDB [designate]> select * from records; +----------------------------------+---------------------+---------------------+---------+---------------------------------------------------------------------+----------------------------------+---------+-----------------------+---------------------+---------------------+---------------------+----------------------------------+-------------+--------+----------------------------------+----------------------------------+-------------------+-------------------------+---------------+--------+------------+------------+ | id | created_at | updated_at | version | data | zone_id | managed | managed_resource_type | managed_resource_id | managed_plugin_type | managed_plugin_name | hash | description | status | tenant_id | recordset_id | managed_tenant_id | managed_resource_region | managed_extra | action | serial | zone_shard | +----------------------------------+---------------------+---------------------+---------+---------------------------------------------------------------------+----------------------------------+---------+-----------------------+---------------------+---------------------+---------------------+----------------------------------+-------------+--------+----------------------------------+----------------------------------+-------------------+-------------------------+---------------+--------+------------+------------+ | 314461b3d2964f2793698acdb76165ac | 2018-01-25 03:07:10 | 2018-01-25 03:07:15 | 2 | ns1-1.example.org. dnstest.test.com. 1516849630 3591 600 86400 3600 | 24012057e77346319567eb57283858f7 | 1 | NULL | NULL | NULL | NULL | ac3df0af522a085057a48b22a275d7cc | NULL | ACTIVE | 348df301bd2a4bb9b643d410bfaf1884 | 6ccaef4c05324e978160164fd70a33a8 | NULL | NULL | NULL | NONE | 1516849630 | 576 | | 361b5c563d4342f49a2d948f9ee561f4 | 2018-01-26 19:49:46 | 2018-01-26 19:49:51 | 2 | ns1-1.example.org. | cefd439a4e7d4567813d12035ac7f108 | 1 | NULL | NULL | NULL | NULL | abf4b548097eb82e52692bfc4ab23fcf | NULL | ACTIVE | 5bdf8e34a3f746fa99729428f9cbf49d | a0ddb5202bda46358d0f87aa965728c0 | NULL | NULL | NULL | NONE | 1516996186 | 3311 | | 51b3a2ae95cc44e6be95f73238c7c105 | 2018-01-26 19:49:46 | 2018-01-26 19:49:51 | 2 | myaliang-vm01.test.com. | cefd439a4e7d4567813d12035ac7f108 | 0 | NULL | NULL | NULL | NULL | b55f16e5ebd9ac491072a86d7562256b | NULL | ACTIVE | 5bdf8e34a3f746fa99729428f9cbf49d | bed271ed520948fc80df2e31b8f89c97 | NULL | NULL | NULL | NONE | 1516996187 | 3311 | | 6603afbbc6184294ba4c259e043cb5bd | 2018-01-26 19:49:46 | 2018-01-26 19:49:51 | 3 | ns1-1.example.org. admin.test.com. 1516996187 3537 600 86400 3600 | cefd439a4e7d4567813d12035ac7f108 | 1 | NULL | NULL | NULL | NULL | a12821284af44d22c545bbc0f20134be | NULL | ACTIVE | 5bdf8e34a3f746fa99729428f9cbf49d | c3cc67e6aec34aaba889df9c975c0cee | NULL | NULL | NULL | NONE | 1516996187 | 3311 | | 797492af92b84213a9d83bed03b30dd3 | 2018-01-26 19:49:44 | 2018-01-26 19:49:49 | 2 | 192.168.0.111 | cc47ecdb36584ac9a4e76cf31c4e2b2b | 0 | NULL | NULL | NULL | NULL | c318976beafe033492252edba82e0a58 | NULL | ACTIVE | 348df301bd2a4bb9b643d410bfaf1884 | eea4ebe98eae4faf9d7ec0eae35482ba | NULL | NULL | NULL | NONE | 1516996184 | 3268 | | a1c87a53c5194989b337d683bb7eae76 | 2018-01-26 19:37:55 | 2018-01-26 19:49:49 | 4 | ns1-1.example.org. admin.test.com. 1516996184 3587 600 86400 3600 | cc47ecdb36584ac9a4e76cf31c4e2b2b | 1 | NULL | NULL | NULL | NULL | 5171d564e5d1765507177e909dbc28b6 | NULL | ACTIVE | 348df301bd2a4bb9b643d410bfaf1884 | bd6fd4b58e8c4aaa98ecbbdf3e2d8349 | NULL | NULL | NULL | NONE | 1516996184 | 3268 | | a51fc6d9dab649459342d5d357f384a9 | 2018-01-26 19:37:55 | 2018-01-26 19:38:00 | 2 | ns1-1.example.org. | cc47ecdb36584ac9a4e76cf31c4e2b2b | 1 | NULL | NULL | NULL | NULL | 6ae6441c7a1711abe2abd1f5e448265b | NULL | ACTIVE | 348df301bd2a4bb9b643d410bfaf1884 | 9320db33a6564a75821101817fefd1c9 | NULL | NULL | NULL | NONE | 1516995475 | 3268 | | afff59cf036d4a91ab64bace1b517d18 | 2018-01-25 03:07:10 | 2018-01-25 03:07:15 | 2 | ns1-1.example.org. | 24012057e77346319567eb57283858f7 | 1 | NULL | NULL | NULL | NULL | a8d49935785f14bb13dd8e808b3a1541 | NULL | ACTIVE | 348df301bd2a4bb9b643d410bfaf1884 | b0f1dc17ae444fb58fd46670f3ca4eb5 | NULL | NULL | NULL | NONE | 1516849630 | 576 | +----------------------------------+---------------------+---------------------+---------+---------------------------------------------------------------------+----------------------------------+---------+-----------------------+---------------------+---------------------+---------------------+----------------------------------+-------------+--------+----------------------------------+----------------------------------+-------------------+-------------------------+---------------+--------+------------+------------+ 8 rows in set (0.00 sec) MariaDB [designate]> select * from recordsets; +----------------------------------+---------+---------------------+---------------------+------------+----------------------------------+----------------------------------+-----------------------------+------+------+-------------+-----------------------------+ | id | version | created_at | updated_at | zone_shard | tenant_id | zone_id | name | type | ttl | description | reverse_name | +----------------------------------+---------+---------------------+---------------------+------------+----------------------------------+----------------------------------+-----------------------------+------+------+-------------+-----------------------------+ | 6ccaef4c05324e978160164fd70a33a8 | 1 | 2018-01-25 03:07:10 | NULL | 576 | 348df301bd2a4bb9b643d410bfaf1884 | 24012057e77346319567eb57283858f7 | test.com. | SOA | NULL | NULL | .moc.tset | | 9320db33a6564a75821101817fefd1c9 | 1 | 2018-01-26 19:37:55 | NULL | 3268 | 348df301bd2a4bb9b643d410bfaf1884 | cc47ecdb36584ac9a4e76cf31c4e2b2b | test.com. | NS | NULL | NULL | .moc.tset | | a0ddb5202bda46358d0f87aa965728c0 | 1 | 2018-01-26 19:49:46 | NULL | 3311 | 5bdf8e34a3f746fa99729428f9cbf49d | cefd439a4e7d4567813d12035ac7f108 | 0.168.192.in-addr.arpa. | NS | NULL | NULL | .apra.rdda-ni.291.861.0 | | b0f1dc17ae444fb58fd46670f3ca4eb5 | 1 | 2018-01-25 03:07:10 | NULL | 576 | 348df301bd2a4bb9b643d410bfaf1884 | 24012057e77346319567eb57283858f7 | test.com. | NS | NULL | NULL | .moc.tset | | bd6fd4b58e8c4aaa98ecbbdf3e2d8349 | 2 | 2018-01-26 19:37:55 | 2018-01-26 19:49:44 | 3268 | 348df301bd2a4bb9b643d410bfaf1884 | cc47ecdb36584ac9a4e76cf31c4e2b2b | test.com. | SOA | NULL | NULL | .moc.tset | | bed271ed520948fc80df2e31b8f89c97 | 1 | 2018-01-26 19:49:46 | NULL | 3311 | 5bdf8e34a3f746fa99729428f9cbf49d | cefd439a4e7d4567813d12035ac7f108 | 111.0.168.192.in-addr.arpa. | PTR | NULL | NULL | .apra.rdda-ni.291.861.0.111 | | c3cc67e6aec34aaba889df9c975c0cee | 2 | 2018-01-26 19:49:46 | 2018-01-26 19:49:46 | 3311 | 5bdf8e34a3f746fa99729428f9cbf49d | cefd439a4e7d4567813d12035ac7f108 | 0.168.192.in-addr.arpa. | SOA | NULL | NULL | .apra.rdda-ni.291.861.0 | | eea4ebe98eae4faf9d7ec0eae35482ba | 1 | 2018-01-26 19:49:44 | NULL | 3268 | 348df301bd2a4bb9b643d410bfaf1884 | cc47ecdb36584ac9a4e76cf31c4e2b2b | myaliang-vm01.test.com. | A | NULL | NULL | .moc.tset.10mv-gnailaym | +----------------------------------+---------+---------------------+---------------------+------------+----------------------------------+----------------------------------+-----------------------------+------+------+-------------+-----------------------------+ 8 rows in set (0.00 sec) in the normal case, the admin user should list all the records,but the designate can not list the ptr zone and ptr records now. and this is the mdns log, it can fetch the ptr zone ,but can show it: 2018-01-30 15:28:13.738 68877 DEBUG designate.service [req-13d47918-7578-485e-b775-e38ec96df2e3 - - - - -] Handling UDP Request from: 127.0.0.1:62816 _dns_handle_udp /usr/lib/python2.7/site-packages/designate/service.py:435 2018-01-30 15:28:13.757 68877 DEBUG designate.storage.impl_sqlalchemy [req-46e8ca41-54d4-46b3-a382-0c1df9f5c7bb - - - - -] Fetched zone <Zone id:'cc47ecdb-3658-4ac9-a4e7-6cf31c4e2b2b' type:'PRIMARY' name:'test.com.' pool_id:'794ccc2c-d751-44fe-b57f-8894c9f5c842' serial:'1516996184' action:'NONE' status:'ACTIVE'> _find_zones /usr/lib/python2.7/site-packages/designate/storage/impl_sqlalchemy/__init__.py:262 2018-01-30 16:23:09.231 68877 DEBUG designate.service [req-5fd8467b-fa95-498c-b5e1-af691043e299 - - - - -] Handling UDP Request from: 127.0.0.1:26347 _dns_handle_udp /usr/lib/python2.7/site-packages/designate/service.py:435 2018-01-30 16:23:09.255 68877 DEBUG designate.storage.impl_sqlalchemy [req-790756b9-ee42-45b4-af0b-8bc16f212316 - - - - -] Fetched zone <Zone id:'cefd439a-4e7d-4567-813d-12035ac7f108' type:'PRIMARY' name:'0.168.192.in-addr.arpa.' pool_id:'794ccc2c-d751-44fe-b57f-8894c9f5c842' serial:'1516996187' action:'NONE' status:'ACTIVE'> _find_zones /usr/lib/python2.7/site-packages/designate/storage/impl_sqlalchemy/__init__.py:262
2018-01-31 14:52:25 Graham Hayes bug task added neutron
2018-01-31 14:52:46 Graham Hayes tags doc
2018-01-31 14:53:00 Graham Hayes designate: status New Invalid
2018-01-31 14:53:49 Graham Hayes summary designate can't list ptr records and ptr zone networking guide: does not show how to list ptr records and ptr zones in designate
2018-01-31 14:54:22 Graham Hayes tags doc dns doc docs