[Building Sakai] Problem when adding non-official participants

Curtis Van-Osch curtis.van-osch at hec.ca
Wed Jul 3 08:17:30 PDT 2013 

Indeed, the constraint should be removed from the hibernate mapping, but 
since we are doing an upgrade I'm not sure the table will be modified by 
this without deleting and allowing the table to be re-created by hibernate.

I'm adding a sql script to our upgrade procedure with these two lines:
alter table VALIDATIONACCOUNT_ITEM modify (FIRST_NAME null);
alter table VALIDATIONACCOUNT_ITEM modify (SURNAME null);

I've tested this approach on our acceptance server, and think that these 
could be added to an upgrade script for sakai.

<http://www.hec.ca>
	
Curtis Van Osch
Analyste-Programmeur
Direction des technologies de l'information
hec.ca <http://www.hec.ca>
Agréments 	
3000, chemin de la Côte-Sainte-Catherine, Montréal (Québec) H3T 2A7
Téléphone : 514 340-6000, poste 2029

	
recyclez 		
Pensons à l'environnement
avant d'imprimer


-------- Message original --------
Sujet: Re: [Building Sakai] Problem when adding non-official participants
De : Brian Baillargeon <bbailla2 at uwo.ca>
Pour : Curtis Van-Osch <curtis.van-osch at hec.ca>
Copie à : sakai-dev Developers <sakai-dev at collab.sakaiproject.org>
Date : 2013-07-03 11:03
> Oh, right this rings a bell! I'm running mysql locally which was fine, 
> but I had seen this issue when deploying to our dev server which is 
> running Oracle. I got it working by inserting a single space when null 
> was detected. Removing the constraint makes more sense to me though. 
> I've been submitting a few reset-pass/account-validator patches 
> lately, I think I'll test this out and submit it. You're essentially 
> doing this, right?
>
> Index: 
> account-validator-api/src/java/org/sakaiproject/accountvalidator/model/ValidationAccount.hbm.xml
> ===================================================================
> --- 
> account-validator-api/src/java/org/sakaiproject/accountvalidator/model/ValidationAccount.hbm.xml    
> (revision 125984)
> +++ 
> account-validator-api/src/java/org/sakaiproject/accountvalidator/model/ValidationAccount.hbm.xml    
> (working copy)
> @@ -21,8 +21,8 @@ &n bsp;&nbs ;
> <property name="validationReceived" column="VALIDATION_RECEIVED" 
> type="timestamp" />
> <property name="validationsSent" column="VALIDATIONS_SENT" 
> type="integer" />
> <property name="status" type="integer" column="STATUS" />
> - <property name="firstName" column="FIRST_NAME" type="string" 
> length="255" not-null="true" />
> - <property name="surname" column="SURNAME" type="string" length="255" 
> not-null="true" />
> + <property name="firstName" column="FIRST_NAME" type="string" 
> length="255" />
> + <property name="surname" column="SURNAME" type="string" length="255" />
> <property name="accountStatus" column="ACCOUNT_STATUS" type="integer"/>
> </class> &n bsp;&nbs ;
> </hibernate-mapping>
>
> On 13-07-03 10:13 AM, Curtis Van-Osch wrote:
>> Thanks Brian,
>>
>> We're not using either of those jobs, nor have we set any new 
>> properties for account validation.  I can't seem to find any 
>> documentation on them, and not much on the new properties (other than 
>> accountValidator.maxDays and accountValidator.maxResendAttempts)
>>
>> The tokens aren't inserted into the validationaccount_item table:
>> I'm getting constraint violations, the FIRST_NAME column cannot be 
>> null (though a user account created through the "add participants" 
>> screen cannot yet have a first or last name...)
>>
>> I'm getting the same behaviour on http://qa5-us.sakaiproject.org/
>>
>> If I disable the two constraints, everything seems to work fine.  I 
>> guess we will add that to our DB conversion scripts when we upgrade, 
>> unless someone can point out a good reason not to.
>>
>> <http://www.hec.ca>
>> 	
>> Curtis Van Osch
>> Analyste-Programmeur
>> Direction des technologies de l'information
>> hec.ca <http://www.hec.ca>
>> Agréments 	
>> 3000, chemin de la Côte-Sainte-Catherine, Montréal (Québec) H3T 2A7
>> Téléphone : 514 340-6000, poste 2029
>>
>> 	
>> recyclez 		
>> Pensons à l'environnement
>> avant d'imprimer
>>
>>
>> -------- Message original --------
>> Sujet: Re: [Building Sakai] Problem when adding non-official participants
>> De : Brian Baillargeon <bbailla2 at uwo.ca>
>> Pour : Curtis Van-Osch <curtis.van-osch at hec.ca>
>> Copie à : sakai-dev Developers <sakai-dev at collab.sakaiproject.org>, 
>> zonecours2 <zonecours2 at hec.ca>, tcollins at uwindsor.ca
>> Date : 2013-06-27 11:54
>>> We're on 2.9.1 and we don't have this issue (we have customizations, 
>>> but I don't recall ever experiencing this bug during development 
>>> either). I've been working with trunk as well and haven't 
>>> experienced this problem.
>>>
>>> Are you using the CheckAccountsJob or CheckValidations jobs?
>>> What are  your account-validation relevant sakai.properties?
>>> Can you see the tokens in the validationaccount_item table?
>>>
>>> On 13-06-26 02:33 PM, Curtis Van-Osch wrote:
>>>> Hi,
>>>> We're preparing to deploy our upgrade to Sakai 2.9.1, but are 
>>>> experiencing a bug with adding non-official participants where the 
>>>> validation code is never valid (the url in the email doesn't work - 
>>>> see SAK-23409 <https://jira.sakaiproject.org/browse/SAK-23409>).  
>>>> Just wondering if anyone has resolved this issue anywhere else, as 
>>>> this functionality is used quite a bit here so this is a potential 
>>>> blocker for us.
>>>>
>>>> -- 
>>>> <http://www.hec.ca>
>>>> 	
>>>> Curtis Van Osch
>>>> Analyste-Programmeur
>>>> Direction des technologies de l'information
>>>> hec.ca <http://www.hec.ca>
>>>> Agréments 	
>>>> 3000, chemin de la Côte-Sainte-Catherine, Montréal (Québec) H3T 2A7
>>>> Téléphone : 514 340-6000, poste 2029
>>>>
>>>> 	
>>>> recyclez 		
>>>> Pensons à l'environnement
>>>> avant d'imprimer
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> sakai-dev mailing list
>>>> sakai-dev at collab.sakaiproject.org
>>>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>>>
>>>> TO UNSUBSCRIBE: send email tosakai-dev-unsubscribe at collab.sakaiproject.org  with a subject of "unsubscribe"
>>>
>>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130703/99f29489/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: HEC_149px.png
Type: image/png
Size: 4883 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130703/99f29489/attachment.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: hecca.png
Type: image/png
Size: 345 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130703/99f29489/attachment-0001.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 3A-2008.png
Type: image/png
Size: 5127 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130703/99f29489/attachment-0002.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Feuille_25px.jpg
Type: image/jpeg
Size: 20493 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130703/99f29489/attachment.jpg 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 4883 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130703/99f29489/attachment-0003.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 345 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130703/99f29489/attachment-0004.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 5127 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130703/99f29489/attachment-0005.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 20493 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130703/99f29489/attachment.jpe 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 4883 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130703/99f29489/attachment-0006.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 345 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130703/99f29489/attachment-0007.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 5127 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130703/99f29489/attachment-0008.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 20493 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130703/99f29489/attachment-0001.jpe

More information about the sakai-dev mailing list