sliver->approved does not update in the database

[chaos@bbn.com]

I have a sliver:

urn:publicid:IDN+pgeni.gpolab.bbn.com+slice+ecgtest10:87aad770-02c2-4bd3-a5fe-b42d17aed498

for which i was erroneously submitting approved=1. Now i'm correctly submitting:

                <sliver approved="0" created="1349229787" creator="urn:publicid:IDN+pgeni.gpolab.bbn.com+user+chaos" expires="1349308542" local_name="urn:publicid:IDN+pgeni.gpolab.bbn.com+slice+ecgtest10:87aad770-02c2-4bd3-a5fe-b42d17aed498" slice_urn="urn:publicid:IDN+pgeni.gpolab.bbn.com+slice+ecgtest10" slice_uuid="None" state="Down" uuid="87aad770-02c2-4bd3-a5fe-b42d17aed498"/>

but the sliver details page (​https://gmoc-db2.grnoc.iu.edu/protected-openid/index.pl?method=sliver_details;sliver=urn%3Apublicid%3AIDN%2Bpgeni.gpolab.bbn.com%2Bslice%2Becgtest10%3A87aad770-02c2-4bd3-a5fe-b42d17aed498) still shows "Approved: 1".

[chaos@bbn.com]

I don't know whether the update is failing in the database or in the web UI, but am guessing it's the database.

[chaos@bbn.com]

Just checking: i did renewsliver on this sliver, and submitted:

                <sliver approved="0" created="1349229787" creator="urn:publicid:IDN+pgeni.gpolab.bbn.com+user+chaos" expires="1349323200" local_name="urn:publicid:IDN+pgeni.gpolab.bbn.com+slice+ecgtest10:87aad770-02c2-4bd3-a5fe-b42d17aed498" slice_urn="urn:publicid:IDN+pgeni.gpolab.bbn.com+slice+ecgtest10" slice_uuid="None" state="Down" uuid="87aad770-02c2-4bd3-a5fe-b42d17aed498"/>

The web UI does show the changed expiration time. So this is only affecting approved, as far as i know.

[chaos@bbn.com]

I believe this is fixed now:

• ​https://gmoc-db2.grnoc.iu.edu/protected-openid/index.pl?method=sliver_details;sliver=urn%3Apublicid%3AIDN%2Bpgeni.gpolab.bbn.com%2Bslice%2Bchaos-montreve-macaddr%3Ab72b0a06-beb9-4be2-94ba-cfbd8654ad82 is a sliver which is approved, and "Approved: 1" shows in the web UI
• ​https://gmoc-db2.grnoc.iu.edu/protected-openid/index.pl?method=sliver_details;sliver=urn%3Apublicid%3AIDN%2Bpgeni.gpolab.bbn.com%2Bslice%2Becgtest10%3A87aad770-02c2-4bd3-a5fe-b42d17aed498 is the aforementioned non-approved sliver, and "Approved: 0" shows in the web UI

[chaos@bbn.com]

Noting for completeness that client v0.8.0 is needed for this fix.