[WG: Sakai QA] [Deploying Sakai] Available site types in 2.8 (or later, maybe earlier too)

[Jean-Francois Leveque]

Hi Steve,

Thanks for the trick.

It would be even better to have a mean to make the portfolio site type 
unavailable when you're not building with OSP without doing this.

cheers,
J-F

On 27/05/2011 15:24, Steve Swinsburg wrote:
> Hi J-F,
>
> If you just want to turn off the site types that Worksite Setup shows,
> you can put this in sakai.properties:
>
> # what site types can be created
> site.types=project
>
> will only allow project sites. Comma separated list for other types.
>
> cheers,
> Steve
>
>
> On 27/05/2011, at 11:16 PM, Jean-Francois Leveque wrote:
>
>> Thanks, John.
>>
>> I wasn't careful about what the query was doing. So project is available
>> in getSiteTypes() because the default Citations Admin is a project but
>> course is not because it has no instances. I've now created a course
>> site and I can use Admin Site Perms for courses and projects.
>>
>> I still have to deal with the fact that WorkSite Setup offers portfolio
>> even if I have built without OSP. But this is less important.
>>
>> Maybe we need a dynamic site type registration system.
>>
>> J-F
>>
>> On 27/05/2011 13:48, John Leasia wrote:
>>> Have you setup any course sites yet? As I recall, a fresh install
>>> creates a few project sites, but I don't think any course sites. So
>>> until you create one, you won't see any sites with that type in the
>>> sakai_site table.
>>>
>>> John
>>>
>>> Jean-Francois Leveque wrote:
>>>> In a freshly created database with almost default Sakai 2.8.0 settings,
>>>> I only get the following:
>>>>
>>>> mysql> select distinct TYPE from SAKAI_SITE order by TYPE;
>>>> +---------+
>>>> | TYPE |
>>>> +---------+
>>>> | NULL |
>>>> | project |
>>>> +---------+
>>>> 2 rows in set (0.00 sec)
>>>>
>>>> It looks like I've found a serious issue unless the release notes say
>>>> something about this.
>>>>
>>>> J-F
>>>>
>>>> On 26/05/2011 18:17, Zhen Qian wrote:
>>>>> Look at the implementation of SiteService (DbSiteService.java), it is
>>>>> using
>>>>> the following sql statement to retrieve site types:
>>>>>
>>>>> "select distinct TYPE from SAKAI_SITE order by TYPE";
>>>>>
>>>>> So it all depends on the current content in the db.
>>>>>
>>>>> However, the site types used by WorkSite Setup tool depend on the
>>>>> configuration settings. So even there is no project site in db now,
>>>>> "project" is still shown as a valid site type option.
>>>>>
>>>>> Thanks,
>>>>>
>>>>> - Zhen
>>>>>
>>>>>
>>>>> On Thu, 26 May 2011 18:10:28 +0200, Jean-Francois Leveque
>>>>> <jean-francois.leveque at upmc.fr
>>>>> <mailto:jean-francois.leveque at upmc.fr>> wrote:
>>>>>> Hi all,
>>>>>>
>>>>>> It looks like org.sakaiproject.site.api.SiteService's
>>>>>> getSiteTypes() is
>>>>>> not always returning the same values as site-manage sets into
>>>>>> STATE_SITE_TYPES (SiteAction.java).
>>>>>>
>>>>>> Does anyone know the magic to be sure both lists of values are the
>>>>>> same?
>>>>>>
>>>>>> J-F