GitHub user ustcweizhou opened a pull request:

    https://github.com/apache/cloudstack/pull/1085

    [4.6] Cannot list vlanipranges by keyword

    Before change:
    
    cloudmonkey> list vlanipranges  keyword=118
    : Caught: com.mysql.jdbc.JDBC4PreparedStatement@18f36b6e: SELECT vlan.id, 
vlan.vlan_id, vlan.vlan_gateway, vlan.vlan_netmask, vlan.ip6_gateway, 
vlan.ip6_cidr, vlan.data_center_id, vlan.description, vlan.ip6_range, 
vlan.network_id, vlan.physical_network_id, vlan.vlan_type, vlan.uuid, 
vlan.removed, vlan.created FROM vlan WHERE  ( OR vlan.description LIKE ** NOT 
SPECIFIED ** )  AND vlan.removed IS NULL  ORDER BY vlan.id ASC  LIMIT 0, 500
    
    After change:
    
    cloudmonkey> list vlanipranges  keyword='118'
    count = 1
    vlaniprange:
    id = 0d80fd9c-cd6b-4f99-96c6-261420e75f58
    account = system
    domain = ROOT
    domainid = 2044762d-c4a5-11e3-8379-005056ac4490
    ......

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/ustcweizhou/cloudstack 
list-vlanipranges-by-keyword

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/cloudstack/pull/1085.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #1085
    
----
commit d6232cb3d18fd6e1da51ba317903076a490bd4c1
Author: Wei Zhou <w.z...@tech.leaseweb.com>
Date:   2015-08-05T07:51:42Z

    Cannot list vlanipranges by keyword
    
    Before change:
    
    cloudmonkey> list vlanipranges  keyword=118
    : Caught: com.mysql.jdbc.JDBC4PreparedStatement@18f36b6e: SELECT vlan.id, 
vlan.vlan_id, vlan.vlan_gateway, vlan.vlan_netmask, vlan.ip6_gateway, 
vlan.ip6_cidr, vlan.data_center_id, vlan.description, vlan.ip6_range, 
vlan.network_id, vlan.physical_network_id, vlan.vlan_type, vlan.uuid, 
vlan.removed, vlan.created FROM vlan WHERE  ( OR vlan.description LIKE ** NOT 
SPECIFIED ** )  AND vlan.removed IS NULL  ORDER BY vlan.id ASC  LIMIT 0, 500
    
    After change:
    
    cloudmonkey> list vlanipranges  keyword='118'
    count = 1
    vlaniprange:
    id = 0d80fd9c-cd6b-4f99-96c6-261420e75f58
    account = system
    domain = ROOT
    domainid = 2044762d-c4a5-11e3-8379-005056ac4490
    ......

----


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

Reply via email to