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" <tu...@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@lists.openstack.org
> Unsubscribe :
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
>
_______________________________________________
Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
Post to : openstack@lists.openstack.org
Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
