Job list not filtered by project

Bug #1711001 reported by Chaoyi Huang
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Tricircle
Fix Released
High
Dongfeng Huang

Bug Description

source openrc admin demo

using admin role for demo project, return result including admin project's job. The result should be only related to demo project.

openstack multiregion networking job list
+--------------------------------------+----------------------------------+---------+---------------------+-------------------+
| Id | Project id | Status | Timestamp | Type |
+--------------------------------------+----------------------------------+---------+---------------------+-------------------+
| fc1b9d2d-05e4-4205-8f1d-aff16a903f80 | d7b9bbf3116e4ce7885b1dd0d472d697 | NEW | 2017-08-15 20:49:03 | router_setup |
| e036052f-55e1-4ebc-aacd-812d3db153f3 | d7b9bbf3116e4ce7885b1dd0d472d697 | RUNNING | 2017-08-15 20:49:03 | router_setup |
| db43abaa-0a33-48ae-8063-9e5bbe14345b | d7b9bbf3116e4ce7885b1dd0d472d697 | FAIL | 2017-08-15 20:48:03 | router_setup |
| 0b1b9f67-cb47-4c70-9c8e-52a50791043b | d7b9bbf3116e4ce7885b1dd0d472d697 | NEW | 2017-08-15 20:48:03 | router_setup |
| 9cc5b081-53ad-4019-ab39-c90d54ad29a7 | d7b9bbf3116e4ce7885b1dd0d472d697 | SUCCESS | 2017-08-14 01:50:19 | shadow_port_setup |
| d0b6f38e-63ac-46b4-a21d-acc73750c81f | d7b9bbf3116e4ce7885b1dd0d472d697 | SUCCESS | 2017-08-14 01:50:18 | shadow_port_setup |
| c205cde6-e164-471a-837c-786ccfd8a641 | d7b9bbf3116e4ce7885b1dd0d472d697 | SUCCESS | 2017-08-14 01:50:14 | configure_route |
| 51231498-489f-49cb-874b-f14732320b11 | d7b9bbf3116e4ce7885b1dd0d472d697 | SUCCESS | 2017-08-14 01:49:57 | configure_route |
| 5bb7c18c-28e5-4a51-af12-256e2719f079 | d7b9bbf3116e4ce7885b1dd0d472d697 | SUCCESS | 2017-08-14 01:49:52 | router_setup |
| 881014d8-67de-4b13-b391-fde57f56d01e | d7b9bbf3116e4ce7885b1dd0d472d697 | SUCCESS | 2017-08-14 01:48:59 | configure_route |
| 4ed9b4e7-d8fb-46b6-b422-e8aacb32c9cc | d7b9bbf3116e4ce7885b1dd0d472d697 | SUCCESS | 2017-08-14 01:48:50 | shadow_port_setup |
| ea565f60-30e9-483c-9763-02726ef689f5 | d7b9bbf3116e4ce7885b1dd0d472d697 | SUCCESS | 2017-08-14 01:48:49 | router_setup |
| 68e15212-d978-4888-97a0-40502c6fb0a2 | d7b9bbf3116e4ce7885b1dd0d472d697 | SUCCESS | 2017-08-14 01:48:39 | configure_route |
| 14d15ccc-75d1-4e42-8029-821381c1fc2c | d7b9bbf3116e4ce7885b1dd0d472d697 | SUCCESS | 2017-08-14 01:48:36 | shadow_port_setup |
| fdb96272-6957-4859-89ca-d8dde2900f5b | d7b9bbf3116e4ce7885b1dd0d472d697 | SUCCESS | 2017-08-14 01:48:22 | router_setup |
| ea45c67f-deab-4b0a-8dc1-2bf404ac8465 | d7b9bbf3116e4ce7885b1dd0d472d697 | SUCCESS | 2017-08-14 01:48:15 | configure_route |
| 18ca8769-98d3-4c80-b4a7-1abca3a2d5f2 | d7b9bbf3116e4ce7885b1dd0d472d697 | SUCCESS | 2017-08-14 01:48:07 | shadow_port_setup |
| bceeb561-a00b-47da-87a8-e7ec994d4197 | d7b9bbf3116e4ce7885b1dd0d472d697 | SUCCESS | 2017-08-14 01:47:55 | router_setup |
| 7fd1c8c8-707f-41c8-896b-f0cb86c457f9 | d7b9bbf3116e4ce7885b1dd0d472d697 | SUCCESS | 2017-08-14 01:41:00 | shadow_port_setup |
| 2656c547-44df-4e96-9ec7-1ca8191b4b31 | d7b9bbf3116e4ce7885b1dd0d472d697 | SUCCESS | 2017-08-14 01:41:00 | seg_rule_setup |
| ab27545b-acb2-41dc-b427-ef7f843d8ee0 | d7b9bbf3116e4ce7885b1dd0d472d697 | SUCCESS | 2017-08-14 01:01:08 | shadow_port_setup |
| 479457b3-082b-46a3-8cda-eaafbcbde89a | d7b9bbf3116e4ce7885b1dd0d472d697 | SUCCESS | 2017-08-14 01:01:08 | seg_rule_setup |
+--------------------------------------+----------------------------------+---------+---------------------+-------------------+
tricircle@zhiyuan-3:~/devstack$ openstack project list
+----------------------------------+--------------------+
| ID | Name |
+----------------------------------+--------------------+
| 297f7165e805443a9c547a8de585e22c | alt_demo |
| 2e2d9123e2fd42108106f8839e50fe54 | demo |
| 2ebbeea0195d42c4aa1eb1c9bd85fac0 | invisible_to_admin |
| be7afdeac03f4a89b207b5ae28ccf487 | service |
| d7b9bbf3116e4ce7885b1dd0d472d697 | admin |
+----------------------------------+--------------------+

Chaoyi Huang (joehuang)
description: updated
Chaoyi Huang (joehuang)
Changed in tricircle:
status: New → Confirmed
importance: Undecided → High
Chaoyi Huang (joehuang)
Changed in tricircle:
assignee: nobody → Dongfeng Huang (southeast02)
milestone: none → pike-rc1
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to tricircle (master)

Fix proposed to branch: master
Review: https://review.openstack.org/494057

Changed in tricircle:
status: Confirmed → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to tricircle (master)

Reviewed: https://review.openstack.org/494057
Committed: https://git.openstack.org/cgit/openstack/tricircle/commit/?id=9939540c070423906ebd8aba0070713b845f868c
Submitter: Jenkins
Branch: master

commit 9939540c070423906ebd8aba0070713b845f868c
Author: Dongfeng Huang <email address hidden>
Date: Wed Aug 16 10:26:24 2017 +0800

    Fix bugs in tricircle Admin API

    1. What is the problem
    When we use admin role for demo project to retrieve jobs/routings
    through Admin API, return results include admin project's
    jobs/routings. The result should be only related to demo project.

    2. What is the solution for the problem
    Extract project ID from context and use it as filter. The project
    ID filter in URL query string will be ignored, and only the project ID
    in which the user is authorized will be used as the filter.

    3. What the features need to be implemented to the Tricircle to
    realize the solution
    Choose project ID as mandatory filter for jobs/routings list operation.

    Change-Id: I86778e0525c1fecf45bc473bd42e62909534778b
    Closes-Bug: #1711001
    Closes-Bug: #1711003

Changed in tricircle:
status: In Progress → Fix Released
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/tricircle 4.0.0

This issue was fixed in the openstack/tricircle 4.0.0 release.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers