[Building Sakai] Problem when adding non-official participants

Brian Baillargeon bbailla2 at uwo.ca
Wed Jul 3 08:03:52 PDT 2013


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 @@
                 <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>
  </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/1352f9c2/attachment.html 
-------------- 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/1352f9c2/attachment.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/1352f9c2/attachment-0001.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/1352f9c2/attachment-0002.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/1352f9c2/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/1352f9c2/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/1352f9c2/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/1352f9c2/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/1352f9c2/attachment-0001.jpe 


More information about the sakai-dev mailing list