[Building Sakai] Problem when adding non-official participants
Brian Baillargeon
bbailla2 at uwo.ca
Wed Jul 3 09:39:56 PDT 2013
Created https://jira.sakaiproject.org/browse/RES-61
On 13-07-03 11:17 AM, Curtis Van-Osch wrote:
> 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/ba9911e0/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/ba9911e0/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/ba9911e0/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/ba9911e0/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/ba9911e0/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/ba9911e0/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/ba9911e0/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/ba9911e0/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/ba9911e0/attachment-0001.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/ba9911e0/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/ba9911e0/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/ba9911e0/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/ba9911e0/attachment-0002.jpe
More information about the sakai-dev
mailing list