networking guide: does not show how to list ptr records and ptr zones in designate

[miaoyuliang]

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. | <email address hidden> | 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. | <email address hidden> | 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

[miaoyuliang (mylaliang)]

use the commnad "#openstack zone list --all" could list the ptr zone;
use the command "#designate record-list 0.168.192.in-addr.arpa. --all-tenant" could list the ptr record;

so, the designate doc should update the command line about ptr, the following url is one of the place should be update https://docs.openstack.org/ocata/networking-guide/config-dns-int.html

[Graham Hayes (grahamhayes)]

@miaoyuliang that is a neutron doc.

We should also not document any "designate *" commands - they will stop working in Queens.

``$ openstack zone list --all-projects`` will show the zone (if ran by an admin)
``$ openstack recordset list 0.168.192.in-addr.arpa. --all-projects`` will show the records (if ran by an admin)

[miaoyuliang (mylaliang)]

could designate doc add a link to the page of DNS Integration with neutron,or just like the "Configure the Compute service to use the Networking service" in neutron doc?
what we need is a combination of designate and neutron,or designate would be work lonely