[Building Sakai] [Deploying Sakai] Crazy function names in SAKAI_REALM_FUNCTION in MySQL, maybe Oracle too

[Jean-Francois Leveque]

Thanks Will,

I started to use Sakai with 2.4.x, so this explains why I have the issue.

I doesn't seem to have been fixed in a migration script.

Because I've never used OSP, I think I can safely remove those from 
SAKAI_REALM_RL_FN and SAKAI_REALM_FUNCTION.

Cheers,

J-F

On 13/07/2012 15:14, Will Humphries wrote:
> Hello Jean-Francois,
>
> Those function names come from an OSP bug, they were removed from osp
> source and authz .sql around 2.5
> https://jira.sakaiproject.org/browse/SAK-11846 . I don't have them in
> any database, but other MySQL schools with installations that are
> several years old might. It seems like they shouldn't be needed, but you
> might confirm by grepping for them in your /osp .
>
> -Will
>
> On 7/13/12 5:52 AM, Jean-Francois Leveque wrote:
>> Hi,
>>
>> I don't know when this happened, but I think there's something wrong in
>> my database.
>>
>> > select FUNCTION_NAME from SAKAI_REALM_FUNCTION where FUNCTION_NAME
>> like 'annc.%';
>> +--------------------------------+
>> | FUNCTION_NAME |
>> +--------------------------------+
>> | annc.all.groups |
>> | annc.delete.any |
>> | annc.delete.own |
>> | annc.new |
>> | annc.read |
>> | annc.read.drafts |
>> | annc.revise.any |
>> | annc.revise.anyannc.revise.own |
>> | annc.revise.anyasn.delete |
>> | annc.revise.anyasn.grade |
>> | annc.revise.anyasn.new |
>> | annc.revise.anyasn.read |
>> | annc.revise.anyasn.revise |
>> | annc.revise.anyasn.submit |
>> | annc.revise.own |
>> +--------------------------------+
>> 15 rows in set (0.00 sec)
>>
>> Am I the only one?
>>
>> I think the 7 that begin with annc.revise.anya have nothing to do here.
>> Could someone else confirm?
>>
>> Cheers,
>>
>> J-F