Difference: KnownIssues (2 vs. 3)

Revision 32012-04-04 - AndreaCeccanti

Line: 1 to 1
 

Known Issues

Line: 73 to 73
 CONCAT('https://cert-voms-01.cnaf.infn.it:8443/voms/emi.saml-test/user/load.action?userId=',userid) as user, email_address, end_time as expiration_date
Changed:
<
<
from usr where end_time > NOW() and end_time < (NOW() + INTERVAL 30 DAY);
>
>
from usr where end_time >= NOW() and end_time < (NOW() + INTERVAL 30 DAY);
  +-------------------------------------------------------------------------------------+------------------------------+---------------------+
user email_address expiration_date
Line: 89 to 89
 

How to extend membership for a large number of users that aren't yet expired or suspended

Changed:
<
<
The following command (with the date set according to the VO manager needs) can be used to extend membership for large number of users that are not yet expired or suspended:
>
>
The following command can be used to extend membership to Sept. 30th, 2012 for large number of users that are not yet expired or suspended:
 
Changed:
<
<
update usr set end_time = '2012-10-1' where suspended is False;
>
>
update usr set end_time = '2012-09-30' where suspended is False and end_time >= NOW() and end_time < '2012-09-30';
 
Added:
>
>
 

How to extend membership for a large number of users that have already expired

Changed:
<
<
The following command (with the date set according to the VO manager needs) can be used to extend membership and restore a large number of users that have expired and have been suspended
>
>
The following command can be used to extend membership to Sept. 30th, 2012 and restore a large number of users that have expired and have been suspended
 due to the membership expiration:

update usr 
set suspended=FALSE, 
Changed:
<
<
end_time = '2012-10-1',
>
>
end_time = '2012-09-30',
 suspension_reason = NULL, suspension_reason_code = NULL where
 
TWIKI.NET
This site is powered by the TWiki collaboration platformCopyright © 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback