Open Stack

It looks like you are setting quotas for the name instead of the id. Change
your list command to output the 'id' column instead.

On Jul 22, 2016 16:32, "Turbo Fredriksson" <turbo at bayour.com> wrote:

> I'm running
>
> ----- s n i p -----
> for proj in default $(openstack project list --column Name --format csv \
>     --quote none | grep -v ^Name)
> do
>     openstack quota set --key-pairs 5 --fixed-ips 20 --floating-ips 50 \
>         --volumes 50 --snapshots 10 --ram 10240 --injected-files 10 \
>         --gigabytes 100 --secgroups 50 --secgroup-rules 50 --instances 30 \
>         "${proj}"
>
>     neutron quota-update --tenant-id "${proj}" --network 5 --subnet 10 \
>         --port 50 --router 2 --floatingip 200 --security-group 50 \
>         --security-group-rule 50 --vip 50 --health-monitor 50
> done
> ----- s n i p -----
>
> Looking in the databases:
>
> ----- s n i p -----
> bladeA01:~# mysql -uroot -psecret -hlocalhost nova -e 'select * from
> quotas where resource="security_groups" or resource="instances" order by
> project_id,resource'
> Warning: Using a password on the command line interface can be insecure.
>
> +-----+---------------------+---------------------+------------+----------------------------------+-----------------+------------+---------+
> | id  | created_at          | updated_at          | deleted_at |
> project_id                       | resource        | hard_limit | deleted |
>
> +-----+---------------------+---------------------+------------+----------------------------------+-----------------+------------+---------+
> |  85 | 2016-07-22 22:25:12 | 2016-07-22 22:38:16 | NULL       |
> 04ee0e71babe4fd7aa16c3f64a8fca89 | instances       |         30 |       0
> ||  89 | 2016-07-22 22:25:12 | 2016-07-22 22:28:00 | NULL       |
> 04ee0e71babe4fd7aa16c3f64a8fca89 | security_groups |         50 |       0
> || 117 | 2016-07-22 22:28:08 | NULL                | NULL       |
> 55de35baa6aa48ac83825a3ac2e3100e | instances       |         30 |       0 |
> | 121 | 2016-07-22 22:28:08 | NULL                | NULL       |
> 55de35baa6aa48ac83825a3ac2e3100e | security_groups |         50 |       0
> || 125 | 2016-07-22 22:28:15 | NULL                | NULL       |
> 733bfa1cf26844778a7499a113f1ba54 | instances       |         30 |       0
> || 129 | 2016-07-22 22:28:16 | NULL                | NULL       |
> 733bfa1cf26844778a7499a113f1ba54 | security_groups |         50 |       0 |
> |  45 | 2016-07-22 21:44:00 | 2016-07-22 22:27:52 | NULL       | default
>                         | instances       |         30 |       0 ||  41 |
> 2016-07-22 21:35:45 | 2016-07-22 22:27:52 | NULL       | default
>               | security_groups |         50 |       0
> |+-----+---------------------+---------------------+------------+----------------------------------+-----------------+------------+---------+
> bladeA01:~# mysql -uroot -psecret -hlocalhost neutron -e 'select * from
> quotas where resource="security_group" order by tenant_id'
> Warning: Using a password on the command line interface can be insecure.
>
> +--------------------------------------+-----------+----------------+-------+
> | id                                   | tenant_id | resource       |
> limit |
>
> +--------------------------------------+-----------+----------------+-------+
> | 17bb8ea8-cde0-462d-a9ff-aad6e45dad9b | admin     | security_group |
> 50 |
> | c145176c-ba76-4759-af51-e9b748700a36 | compute   | security_group |
> 50 |
> | d657b56f-3bc5-49a8-b48c-8cc40295a88e | default   | security_group |
> 50 |
> | edfc5513-44aa-49ce-b3ae-914215769112 | service   | security_group |
> 50 |
>
> +--------------------------------------+-----------+----------------+-------+
> ----- s n i p -----
>
> And yet, in Horizon, "instances" is set to "10". And I can't
> update it from there..
> --
> If something's hard to do, then it's not worth doing.
> - Homer Simpson
>
>
> _______________________________________________
> Mailing list:
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
> Post to     : openstack at lists.openstack.org
> Unsubscribe :
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20160723/fb054bea/attachment.html>