Sakai 2.5

etc.

/trunk
/tags
/branches
svn
svn co https://source.sakaiproject.org/svn/sakai/tags/sakai-2.5.5/ sakai-2.5.6

svn co https://source.sakaiproject.org/svn/sakai/branches/sakai_2-5-x/ sakai_2-5-x

sakai.properties
sakai.properties
/sakai
$CATALINA_HOME
sakai.properties
sakai.properties
sakai.properties
sakai-src/component/component-api/component/src/config/org/sakaiproject/config/sakai.properties

sakai.properties
sakai-src/reference/docs/sakai.properties

sakai.properties
sakai.properties
$ svn co http://source.sakaiproject.org/svn/reference/branches/sakai_2-5-x/docs/sakai.properties

sakai.properties
$CATALINA_HOME/sakai
$CATALINA_HOME/sakai
JAVA_OPTS
sakai.home
-Dsakai.home=/path/to/desired/sakai/home/

sakai.properties
sakai_properties.doc
/reference/docs/architecture/sakai_properties.doc
sakai.properties
smtp@org.sakaiproject.email.api.EmailService=some.smtp.org
# dns addresses used for incoming email
smtp.dns.1 = 255.255.255.1
smtp.dns.2 = 255.255.255.2

# SMTP port on which our SMTP server runs. Default is 25.
#Recommend running on 8025, and using a standard mailer on 25 to forward mail to Sakai.
smtp.port = 25

# flag to enable or disable our SMTP server for incoming email (true | false)
smtp.enabled = true

# email address used as the "from" address for any email sent by Worksite Setup tool or Site Info tool.  
# Recipients may not receive notifications if this address isn't valid.
#setup.request=address@somedomain

smtp.enabled=false
sakai.properties
smtp.enabled=false
smtp.port=8025
WARN:
sakai.properties
log.config.count=3
log.config.1 = ALL.org.sakaiproject.log.impl
log.config.2 = OFF.org.sakaiproject
log.config.3 = DEBUG.org.sakaiproject.db.impl

name.count
name.1
name.2
LEVEL.logger
OFF TRACE DEBUG INFO WARN ERROR FATAL ALL
sakai-src/kernel/log-configure/src/conf/log4j.properties
log4j.logger.org.sakaiproject=INFO

log4j.logger.org.sakaiproject=INFO
log4j.logger.org.sakaiproject.component.framework.sql.BasicSqlService=DEBUG

sakai.properties
enabled@org.sakaiproject.log.api.LogConfigurationManager = false

logs/catalina.out
bin/startup.sh; tail -f logs/catalina.out

catalina.out
InnoDB
sakaiger$ mysql --version
mysql  Ver 14.12 Distrib 5.0.45, for apple-darwin8.5.1 (i686) using readline 5.0

C:\opt\mysql\>
mysql -u root -p
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 51 to server version: 4.1.5-gamma-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database sakai default character set utf8;
Query OK, 1 row affected (0.00 sec)

mysql> grant all on sakai.* to sakaiuser@'localhost' identified by 'sakaipassword';
Query OK, 0 rows affected (0.00 sec

mysql> grant all on sakai.* to sakaiuser@'127.0.0.1' identified by 'sakaipassword';
Query OK, 0 rows affected (0.00 sec)

mysql> quit

autoDDL
sakai.properties
SQL> select value from nls_database_parameters where parameter = 'NLS_CHARACTERSET';

VALUE
--------------------------------------------------------------------------------
AL32UTF8

mysql> show create database sakai;
+----------+----------------------------------------------------------------+
| Database | Create Database                                                |
+----------+----------------------------------------------------------------+
| sakai    | CREATE DATABASE `sakai` /*!40100 DEFAULT CHARACTER SET utf8 */ | 
+----------+----------------------------------------------------------------+
1 row in set (0.00 sec)

mysql-connector-java-<version>-bin.jar
$CATALINA_HOME/common/lib
ojdbc14.jar
$CATALINA_HOME/common/lib
url@javax.sql.BaseDataSource
username@javax.sql.BaseDataSource
password@javax.sql.BaseDataSource
# DATABASE CONFIGURATION - make sure to modify details to match your particular setup

# The username and password.  The defaults are for the out-of-the-box HSQLDB.  Change to match your setup.
username@javax.sql.BaseDataSource=yourDbUserName
password@javax.sql.BaseDataSource=yourDbPassword

## HSQLDB settings - on by default
vendor@org.sakaiproject.db.api.SqlService=hsqldb
driverClassName@javax.sql.BaseDataSource=org.hsqldb.jdbcDriver
hibernate.dialect=org.hibernate.dialect.HSQLDialect
validationQuery@javax.sql.BaseDataSource=select 1 from INFORMATION_SCHEMA.SYSTEM_USERS
# two hsqldb storage options: first for in-memory (no persistence between runs), second for disk based
#url@javax.sql.BaseDataSource=jdbc:hsqldb:mem:sakai
url@javax.sql.BaseDataSource=jdbc:hsqldb:file:${sakai.home}db/sakai.db

# MySQL settings - make sure to alter as appropriate
vendor@org.sakaiproject.db.api.SqlService=mysql
driverClassName@javax.sql.BaseDataSource=com.mysql.jdbc.Driver
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
url@javax.sql.BaseDataSource=jdbc:mysql://127.0.0.1:3306/sakai?useUnicode=true&characterEncoding=UTF-8
validationQuery@javax.sql.BaseDataSource=select 1 from DUAL
defaultTransactionIsolationString@javax.sql.BaseDataSource=TRANSACTION_READ_COMMITTED

# To get accurate mysql query throughput statistics (for example for graphing) from the mysql command
# show status like 'Com_select'
# this alternate validation query should be used so as not to increment the query counter unnecessarily
# when validating the connection:
#validationQuery@javax.sql.BaseDataSource=show variables like 'version'

## Oracle settings - make sure to alter as appropriate
vendor@org.sakaiproject.db.api.SqlService=oracle
driverClassName@javax.sql.BaseDataSource=oracle.jdbc.driver.OracleDriver
hibernate.dialect=org.hibernate.dialect.Oracle9Dialect
url@javax.sql.BaseDataSource=jdbc:oracle:thin:@your.oracle.dns:1521:SID
validationQuery@javax.sql.BaseDataSource=select 1 from DUAL
defaultTransactionIsolationString@javax.sql.BaseDataSource=TRANSACTION_READ_COMMITTED

# For improved Oracle performance (from the University of Michigan)
validationQuery@javax.sql.BaseDataSource=
defaultTransactionIsolationString@javax.sql.BaseDataSource=
testOnBorrow@javax.sql.BaseDataSource=false

# establish auto.ddl - on by default
auto.ddl=true
#auto.ddl=false

auto.ddl=false
sampleboolean=true
samplestring=set to a string value with one or more spaces, ending in a new line
sampleproperty.count=3
sampleproperty.1=peas
sampleproperty.2=porridge
sampleproperty.3=hot
bodyPath@org.sakaiproject.content.api.ContentHostingService=/content/sakai
# Only uncomment the bodyVolumes property if you have multiple content volumes 
# (sub directories/ mount points relative to the location specified above)
bodyVolumes@org.sakaiproject.content.api.ContentHostingService=vol1,vol2,vol3
# uncomment the next line if you wish to set a site quota of 1Gb
# siteQuota@org.sakaiproject.content.api.ContentHostingService=1048576
convertToFile@org.sakaiproject.content.api.ContentHostingService=true
# Oracle settings - make sure to alter as appropriate
vendor@org.sakaiproject.db.api.SqlService=oracle
driverClassName@javax.sql.BaseDataSource=oracle.jdbc.driver.OracleDriver
hibernate.dialect=org.hibernate.dialect.Oracle9Dialect
url@javax.sql.BaseDataSource=jdbc:oracle:thin:@your.oracle.dns:1521:SID
validationQuery@javax.sql.BaseDataSource=select 1 from DUAL
defaultTransactionIsolationString@javax.sql.BaseDataSource=TRANSACTION_READ_COMMITTED
# MySQL settings - make sure to alter as appropriate
vendor@org.sakaiproject.db.api.SqlService=mysql
driverClassName@javax.sql.BaseDataSource=com.mysql.jdbc.Driver
hibernate.dialect=org.hibernate.dialect.MySQLDialect
url@javax.sql.BaseDataSource=jdbc:mysql://127.0.0.1:3306/sakai?useUnicode=true&characterEncoding=UTF-8
validationQuery@javax.sql.BaseDataSource=show variables like 'version'
defaultTransactionIsolationString@javax.sql.BaseDataSource=TRANSACTION_READ_COMMITTED
username@javax.sql.BaseDataSource=sakai
password@javax.sql.BaseDataSource=********
# For improved Oracle performance (from the University of Michigan)
validationQuery@javax.sql.BaseDataSource=
defaultTransactionIsolationString@javax.sql.BaseDataSource=
testOnBorrow@javax.sql.BaseDataSource=false

SQL> alter table SAM_MEDIA_T modify MEDIA BLOB;

Table altered.

SQL> select constraint_name from user_constraints where table_name='SAM_MEDIA_T'
and CONSTRAINT_TYPE='P';

CONSTRAINT_NAME
------------------------------
SYS_C0064435

SQL> alter table sam_media_t drop constraint SYS_C0064435;

Table altered.

SQL> alter table SAM_MEDIA_T add constraint SYS_C0064435 primary key (MEDIAID);

Table altered.

SQL> desc SAM_MEDIA_T;

[table with BLOB type]

SQL> select constraint_name from user_constraints where table_name='SAM_MEDIA_T'
and CONSTRAINT_TYPE='P';

CONSTRAINT_NAME
------------------------------
SYS_C0064435

SQL> commit;

Commit complete.

lower_case_table_names=1
url@javax.sql.BaseDataSource=jdbc:mysql://localhost:3306/sakai?useUnicode=true&characterEncoding=UTF-8
&useServerPrepStmts=false&cachePrepStmts=true&prepStmtCacheSize=4096&prepStmtCacheSqlLimit=4096

[mysqld]
query_cache_size = 128M

DROP TABLE SAKAI_PRESENCE;

CREATE TABLE `SAKAI_PRESENCE` (
`SESSION_ID` varchar(36) default NULL,
`LOCATION_ID` varchar(255) default NULL,
KEY `SAKAI_PRESENCE_SESSION_INDEX` (`SESSION_ID`),
KEY `SAKAI_PRESENCE_LOCATION_INDEX` (`LOCATION_ID`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8;

title Red Hat Enterprise Linux AS (2.4.21-32.0.1.ELhugemem)
root (hd0,0)
kernel /vmlinuz-2.4.21-32.0.1.ELhugemem ro root=/dev/sda2 elevator=deadline reboot=warm
initrd /initrd-2.4.21-32.0.1.ELhugemem.img

# enable James
smtp.enabled=true

# configuring the port on which James listens.  In this example, another component (NAT rules, Sendmail) forward from 25 to 8025
smtp.port=8025

# James will only accept messages for this hostname
serverName=service.my.edu

# You'll get more meaningful feedback if you have the node name configured
serverID=node.my.edu
telnet {the value you used for serverName} 8025 [or 25 if you've set it to that]
(James SMTP Server 2.1.3) ready {date and time}
telnet {your hostname, or localhost} 8025
EHLO {your service name, ala sakai.your.institution)
250 {serverID.domain} Hello {serverName} (localhost [127.0.0.1])
MAIL FROM:<{your.email@your.institution}>
250 Sender <{your.email@your.institution}> OK
RCPT TO:<{the email address you entered for the mailarchive tool in your site}>
250 Recipient <{email address for the mailarchive tool in your site} OK
DATA
Subject: test...
This is a message I am using to test James.
250 Message received
QUIT
export JAVA_OPTS="-server -XX:+UseParallelGC -Xmx768m -XX:MaxPermSize=160m -Djava.awt.headless=true"
set JAVA_OPTS=-server -XX:+UseParallelGC -Xmx768m -XX:MaxPermSize=160m -Djava.awt.headless=true
<html>
<head>
<title>Redirecting to /portal</title>
<meta http-equiv="Refresh" content="0:URL=/portal">
</head>
<body bgcolor="#ffffff" onLoad="javascript:window.location='/portal';">
<div style="margin:18px;width:288px;background-color:#cccc99;padding:18px;border:thin solid #666600;text-align:justify">
<p style="margin-top:0px">
You are being redirected to the Sakai portal.  If you are not automatically redirected, use the link below to continue:<br/>
<a href="/portal">Take me to the Sakai portal</a>
</p>
</body>
</html>
keytool -genrsa -alias tomcat -keyalg RSA
<Connector port="8443" maxHttpHeaderSize="8192"
           maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
           enableLookups="false" disableUploadTimeout="true"
           acceptCount="100" scheme="https" secure="true"
           clientAuth="false" sslProtocol="TLS" />

<security-constraint>
  <web-resource-collection>
    <web-resource-name>Automatic SLL Forwarding</web-resource-name>
    <url-pattern>/*</url-pattern>
  </web-resource-collection>
  <user-data-constraint>
    <transport-guarantee>CONFIDENTIAL</transport-guarantee>
  </user-data-constraint>
</security-constraint>

<security-constraint>
  <web-resource-collection>
    <web-resource-name>Automatic SLL Forwarding</web-resource-name>
    <url-pattern>/*</url-pattern>
  </web-resource-collection>
  <user-data-constraint>
    <transport-guarantee>CONFIDENTIAL</transport-guarantee>
  </user-data-constraint>
</security-constraint>
<security-constraint>
  <web-resource-collection>
    <web-resource-name>SSL Requirement Disabled</web-resource-name>
    <url-pattern>/*</url-pattern>
  </web-resource-collection>
  <user-data-constraint>
    <transport-guarantee>NONE</transport-guarantee>
  </user-data-constraint>
</security-constraint>
ProxyPass / http://localhost:8080/
ProxyPassReverse / http://localhost:8080/
<Connector port="8080" maxHttpHeaderSize="8192"
           maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
           enableLookups="false" redirectPort="443" acceptCount="100"
           connectionTimeout="20000" disableUploadTimeout="true"
           proxyName="{YOUR SERVICE NAME}"
           proxyPort="80"
/>

<Connector port="8443" maxHttpHeaderSize="8192"
           maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
           enableLookups="false" disableUploadTimeout="true"
           acceptCount="100" scheme="https" secure="true"
           clientAuth="false" sslProtocol="TLS"
           proxyName="{YOUR SERVICE NAME}"
           proxyPort="443"
/>
force.url.secure=443
<Connector enableLookups="false" port="8009" protocol="AJP/1.3" redirectPort="8443"/>
ProxyPass / balancer://sakaiCluster/ stickysession=JSESSIONID nofailover=On
<Proxy balancer://sakaiCluster>
BalancerMember ajp://localhost:8009
BalancerMember ajp://localhost:8019
BalancerMember ajp://localhost:8029
</Proxy>
# Set the location of the worker.properties file
JkWorkersFile   /etc/apache2/worker.properties

# mount the root and all subdirectories associated with our Sakai installation
JkMount /* sakaiWorker
# We only have one worker, so this is a short list.
worker.list=sakaiWorker

# The minimum properties for the sakaiWorker are set here
worker.sakaiWorker.type=ajp13
worker.sakaiWorker.host=localhost
worker.sakaiWorker.port=8009
# mod_deflate (compress output for browsers that support it)
AddOutputFilterByType DEFLATE text/html text/plain text/xml text/css application/x-javascript text/javascript text/x-js application/json application/xml application/javascript

# Some adjustments for IE browsers (c/f
http://www.robertswarthout.com/rswarthout/2007/05/ie-6-apache-mod_deflate-blank-pages/)

BrowserMatch ^Mozilla/4 gzip-only-text/html
BrowserMatch ^Mozilla/4\.0[678] no-gzip
BrowserMatch \bMSIE\s7 !no-gzip !gzip-only-text/html
BrowserMatch \bMSIE\s8 !no-gzip !gzip-only-text/html
force.url.secure=443
preference.pages
Notifications
Customize Tabs
Time Zone
Language
prefences.pages
preference.pages=prefs_tab_title, prefs_noti_title, prefs_timezone_title, prefs_lang_title

preference.pages
enable.privacy.status = true

preferences.pages
preference.pages=prefs_tab_title, prefs_noti_title, prefs_timezone_title, prefs_lang_title, prefs_privacy_title

maximumSize@org.sakaiproject.user.impl.AuthenticationCache
timeoutMs@org.sakaiproject.user.impl.AuthenticationCache
failureThrottleTimeoutMs@org.sakaiproject.user.impl.AuthenticationCache
maxElementsInMemory@org.sakaiproject.user.api.AuthenticationManager.cache
timeToLive@org.sakaiproject.user.api.AuthenticationManager.cache
invalidEmailInIdAccountString
invalidNonOfficialAccountString
noEmailInIdAccountName
officialAccountName
noEmailInIdAccountLabel
officialAccountLabel
emailInIdAccountName
nonOfficialAccountName
emailInIdAccountLabel
nonOfficialAccountLabel
emailInIdAccount.url
nonOfficialAccount.url
emailInIdAccountInstru
nonOfficialAccountInstru
noEmailInIdAccountValue
officialAccountValue
emailInIdAccountValue
nonOfficialAccountValue
osp.upgrade25=true
sakai.properties
osp.reports.useWarehouse
sakai.reports.useWarehouse
reference/docs/conversion
README.TXT
visibleTools@org.sakaiproject.tool.api.ActiveToolManager=sakai.mailtool,sakai.poll
hiddenTools@org.sakaiproject.tool.api.ActiveToolManager=sakai.announcements

java.awt.headless=true

mailtool.max.num.attachment=  # the default is unlimited
mailtool.upload.directory=  # for handling uploaded attachments.  The default is /tmp/

retrieveRoles.count=2
retrieveRoles.1=guest
retrieveRoles.2=staff

search.enable=true

driverClassName@org.sakaiproject.warehouse.service.DataWarehouseManager.dataSource=oracle.jdbc.driver.OracleDriver
url@org.sakaiproject.warehouse.service.DataWarehouseManager.dataSource=jdbc:oracle:thin:@mercury.phx.rsmart.com:1521:VMWARE
username@org.sakaiproject.warehouse.service.DataWarehouseManager.dataSource=jdetest
password@org.sakaiproject.warehouse.service.DataWarehouseManager.dataSource=jdetest
maxActive@org.sakaiproject.warehouse.service.DataWarehouseManager.dataSource=20
maxIdle@org.sakaiproject.warehouse.service.DataWarehouseManager.dataSource=2
validationQuery@org.sakaiproject.warehouse.service.DataWarehouseManager.dataSource=select 1 from DUAL

sakai.properties
portal.use.dhtml.more=true
sakai.properties
gradebook_enable_letter_grade=true
sakai.properties
ical.experimental=true
räksmörgås.txt

--- reference/trunk/docs/conversion/sakai_2_1_2-2_2_0_mysql_conversion.sql	2007/01/17 18:57:13	20392
+++ reference/trunk/docs/conversion/sakai_2_1_2-2_2_0_mysql_conversion.sql	2007/01/17 19:10:09	20393
@@ -2237,3 +2237,9 @@
 ----------------------------------------------------------------------------------------------------------------------------------------

 ALTER TABLE SAKAI_SESSION CHANGE SESSION_IP SESSION_IP VARCHAR (128);
+
+----------------------------------------------------------------------------------------------------------------------------------------
+-- Increase the field size for the NOTES field in the SAKAI_PERSON_T table
+----------------------------------------------------------------------------------------------------------------------------------------
+
+ALTER TABLE SAKAI_PERSON_T CHANGE NOTES NOTES varchar(4000);
--- reference/trunk/docs/conversion/sakai_2_1_2-2_2_0_oracle_conversion.sql	2007/01/17 18:57:13	20392
+++ reference/trunk/docs/conversion/sakai_2_1_2-2_2_0_oracle_conversion.sql	2007/01/17 19:10:09	20393
@@ -2243,3 +2243,9 @@
 ----------------------------------------------------------------------------------------------------------------------------------------

 ALTER TABLE SAKAI_SESSION MODIFY SESSION_IP VARCHAR2 (128);
+
+----------------------------------------------------------------------------------------------------------------------------------------
+-- Increase the field size for the NOTES field in the SAKAI_PERSON_T table
+----------------------------------------------------------------------------------------------------------------------------------------
+
+ALTER TABLE SAKAI_PERSON_T MODIFY (NOTES varchar2(4000));

Sakai	Repository location
Trunk	https://source.sakaiproject.org/svn/sakai/trunk/
Tags	https://source.sakaiproject.org/svn/sakai/tags/
Branches	https://source.sakaiproject.org/svn/sakai/branches/

MySQL	Oracle
MySQL 5.0.x	Oracle 10g
MySQL 4.1.12+	Oracle 9i

Db Version	Connector/J
MySQL 5.0.x	MySQL Connector/J 5.0.4+ http://dev.mysql.com/downloads/connector/j/5.0.html
MySQL 4.1.12+	MySQL Connector/J 3.1.12+ http://dev.mysql.com/downloads/connector/j/3.1.html

Setting	Description
ui.institution	The name of the organization associated with this Sakai installation (such as "My University").
ui.service	The local brand for Sakai within the institution. Among other things, this text is displayed at the root of the bread crumb bar that appears within Sakai.
serverId	A unique identifier for the particular server Sakai is running on. This is used to distinguish nodes in a clustered environment from one another.
serverUrl	The full service URL for this installation of Sakai
serverName	The server name for this installation of Sakai (this should match the value for serverUrl).
skin.repo	The location in which skins for this site are housed. This can be set to a relative or absolute URL. The default is /library/skin, which includes the default skins bundled with Sakai.
skin.default	The default skin to use for all sites. This should be the name of a skin directory that exists in the skin home directory.

Property	Description
expired@org.sakaiproject.cluster.api.ClusterService	The time in seconds after which an inactive server will be expired from the cluster.
ghostingPercent@org.sakaiproject.cluster.api.ClusterService	The percentage of maintenance passes to run the full de-ghosting / cleanup activities, including delisting stale server nodes.
refresh@org.sakaiproject.cluster.api.ClusterService	How often (in seconds) a server should register that it is still alive.

List	Description
WG: Production (Deploying Sakai)	The best place to exchange day-to-day production issues
DG: Development (aka sakai-dev) (Building Sakai)	Intended to be a development-centered list

Old Name (Sakai 2.4 and earlier)	New Name (Sakai 2.5.0 and later)
`invalidEmailInIdAccountString`	`invalidNonOfficialAccountString`
`noEmailInIdAccountName`	`officialAccountName`
`noEmailInIdAccountLabel`	`officialAccountLabel`
`emailInIdAccountName`	`nonOfficialAccountName`
`emailInIdAccountLabel`	`nonOfficialAccountLabel`
`emailInIdAccount.url`	`nonOfficialAccount.url`
`emailInIdAccountInstru`	`nonOfficialAccountInstru`
`noEmailInIdAccountValue`	`officialAccountValue`
`emailInIdAccountValue`	`nonOfficialAccountValue`

Upgrade Step	Conversion script prefix	MySQL	Oracle
1.5 to 2.0	sakai_1_5-2_0	sakai_1_5-2_0_mysql_conversion.sql	sakai_1_5-2_0_conversion.sql
2.0 to 2.1	sakai_2_0-2_1	sakai_2_0-2_1_mysql_conversion.sql	sakai_2_0-2_1_oracle_conversion.sql
2.1 to 2.1.1	sakai_2_1-2_1_1	sakai_2_1_0-2_1_1_mysql_conversion.sql	sakai_2_1_0-2_1_1_oracle_conversion.sql
2.1.1 to 2.1.2	sakai_2_1_1-2_1_2	sakai_2_1_1-2_1_2_mysql_conversion.sql	sakai_2_1_1-2_1_2_oracle_conversion.sql
2.1.2 to 2.2.0	sakai_2_1_2-2_2_0	sakai_2_1_2-2_2_0_mysql_conversion.sql	sakai_2_1_2-2_2_0_oracle_conversion.sql
2.2.0 to 2.2.1	sakai_2_2_0-2_2_1	sakai_2_2_0-2_2_1_mysql_conversion.sql	sakai_2_2_0-2_2_1_oracle_conversion.sql
2.2.1 to 2.3.2	sakai_2_2_1-2_3_1	sakai_2_2_1-2_3_1_mysql_conversion.sql	sakai_2_2_1-2_3_1_oracle_conversion.sql
2.3.0 to 2.3.2	sakai_2_3_0-2_3_1	sakai_2_3_0-2_3_1_mysql_conversion.sql	sakai_2_3_0-2_3_1_oracle_conversion.sql
2.3.1 to 2.3.2	no schema changes
2.3.2 to 2.4.1	sakai_2_3_1-2_4_0	sakai_2_3_1-2_4_0_mysql_conversion.sql	sakai_2_3_1-2_4_0_oracle_conversion.sql
2.4.0 to 2.4.1	no schema changes
2.4.1 to 2.5.0	sakai_2_4_0-2_5_0	sakai_2_4_0-2_5_0_mysql_conversion.sql	sakai_2_4_0-2_5_0_oracle_conversion.sql
2.5.0 to 2.5.1	sakai_2_5_0-2_5_1	sakai_2_5_0-2_5_1_mysql_conversion.sql	sakai_2_5_0-2_5_1_oracle_conversion.sql
2.5.0 to 2.5.2	sakai_2_5_0-2_5_2	sakai_2_5_0-2_5_2_mysql_conversion.sql	sakai_2_5_0-2_5_2_oracle_conversion.sql
2.5.1 to 2.5.2	no schema changes
2.5.2 to 2.5.3	sakai_2_5_2-2_5_3	sakai_2_5_2-2_5_3_mysql_conversion.sql	sakai_2_5_2-2_5_3_oracle_conversion.sql
2.5.3 to 2.5.4	sakai_2_5_3-2_5_4	sakai_2_5_3-2_5_4_mysql_conversion.sql	sakai_2_5_3-2_5_4_oracle_conversion.sql
2.5.4 to 2.5.5	no schema changes
2.5.5 to 2.5.6	sakai_2_5_5-2_5_6	sakai_2_5_5-2_5_6_mysql_conversion.sql	sakai_2_5_5-2_5_6_oracle_conversion.sql
2.6.0	sakai_2_6_0	sakai_2_6_0_mysql_conversion.sql	sakai_2_6_0_oracle_conversion.sql
2.6.0 to 2.6.1	sakai_2_6_0-2_6_1	sakai_2_6_0-2_6_1_mysql_conversion.sql	sakai_2_6_0-2_6_1_oracle_conversion.sql
2.6.0 to 2.6.x	sakai_2_6_0-2_6_x	sakai_2_6_0-2_6_x_mysql_conversion001_SAK-16668.sql	sakai_2_6_0-2_6_x_oracle_conversion001_SAK-16668.sql
2.6.0 to 2.6.x	sakai_2_6_0-2_6_x	sakai_2_6_0-2_6_x_mysql_conversion002_SAK-16548.sql	sakai_2_6_0-2_6_x_oracle_conversion002_SAK-16548.sql
2.6.0 to 2.6.x	sakai_2_6_0-2_6_x	sakai-2.6.2/docs/conversion/sakai_2_6_0-2_6_x_mysql_conversion003_SAK-16847.sql	sakai_2_6_0-2_6_x_oracle_conversion003_SAK-16847.sql
2.6.0 to 2.6.x	sakai_2_6_0-2_6_x	sakai_2_6_0-2_6_x_mysql_conversion004_SAK-10512.sql	sakai_2_6_0-2_6_x_oracle_conversion004_SAK-10512.sql

Tool ID	blogger
Confluence Space	Blog
Contact	Adrian Fish (Lancaster University)

Tool ID	sakai.rutgers.linktool
Confluence Space	Linktool
Contact	Charles Hedrick (Rutgers University)

Tool ID	sakai.mailtool
Confluence Space	Mailtool
Contact	SOO IL KIM (Boston University)

Tool ID	NA
Confluence Space	Page Order Helper
Contact	Joshua Ryan (Arizona State University)

Tool ID	sakai.podcasts
Confluence Space	[Podcast]
Contact	Lance Speelmon (Indiana University)

Tool ID	sakai.poll
Confluence Space	Polls
Contact	David Horwitz (University of Cape Town)

Tool ID	sakai.retrievepass
Confluence Space	Reset Password
Contact	Stephen Marquard (University of Cape Town)

Tool ID	sakai.site.roster
Confluence Space	None
Contact	Oliver Heyer (University of California Berkeley)

Tool ID	sakai.su
Confluence Space	None
Contact	Zach A. Thomas (Aeroplane Software)

Tool ID	sakai.usermembership
Confluence Space	User Membership
Contact	Nuno Fernandes (UFP)

Tool	Description
Agora	Agora is an easy to use, open source online meeting tool. All members of a Sakai worksite can create a meeting in just a few mouse clicks, and joining is as simple as clicking a link in the Sakai tool. Apart from a Java virtual machine there is no need for any explicit software installation on the user's PC, all required software is transparently loaded at startup.
Assignments2	A second generation of the assignments tool. Initial phase involves conversion to RSF, better gradebook integration, and a redesign for an improved user experience. Future phases involve JCR for content storage and customizable workflows.
BlogWow	An RSF-based blog tool.
Breeze Link	The Breeze Link allows a Sakai installation to seamlessly connect to a Breeze server and allows users to connect to Breeze meetings with a single click. No additional sign on is required and users will appear in the meeting with their display name from Sakai.
CANS	Context-aware Activity Notification System (CANS) is a notification system for online communities that is designed around the importance of a user's social context and personal notification preferences.
Checklist	The Checklist Contrib Project will be responsible for addressing or promoting the needs of graduate students through Sakai.
Clicker Registration	The Clicker Registration is for students to register their Clicker ID's in courses that use them.
Conditional Release	A Conditional Release architecture and design, which involve a "ConditionService" which will work in concert with other services and store rules against a tool or domain object.
Configuration Viewer and Editor	The Sakai Config Viewer is a tool to help administrators make sense of the configuration options that can be set in sakai.properties. It displays a list of available properties along with a host of value added data.
Content Viewer	The Resources Viewer is a simple tool which displays the contents of selected folders from the Resources tool in a simpler, more user-friendly manner. In particular, it fulfills the requirements of displaying a list of resources together with their descriptions and creating links to Resources content in the left-hand navigation (tool) menu.
Course Homepage	Home Page tool offers a substitute for the current Home view of a site.
Email Template Service	A service providing localizable and internationalizable email templates for Sakai Applications.
Evaluation System	Give formative evaluations to students in their courses and review the results.
Form Builder	Form Builder (formerly known as XSD Weaver) is a graphical user interface for creating XSD files for use in ePortfolios.
Goal Management	Enables the definition of program, course, and/or personal goals, the ability to tag activities (such as assignments, datapoints, OSP wizard pages and/or OSP matrix cells) with applicable goals, and the ability to rate user performance towards goals based on work submitted for the activities.
I10n-Stats	Tool for analyzing the status of the Sakai translations in the source repository.
Image Gallery	The Gallery Tool will allow a user to select a collection of images (a gallery) and view the images in a specified order. The tool is focused on selecting, sequencing, and viewing - not creation or editing.
ImageQuiz	A responder- or clicker- type tool designed for synchronous, though not necessarily co-located, classroom settings. In addition to the typical responder functionality, an image can be displayed with an accompanying question or note, each student can click on the image at a particular location to indicate their response, and the aggregated results of all student clicks can be viewed.
IMS Enterprise Services	IMS Enterprise Services
JForum	JForum Discussion & Private Messages is an easy-to-use, yet robust tool that offers industry-standard functionality to users. Instructors can set up unlimited categories and forums, moderate topics (move, edit, delete, lock, or unlock), read recent topics and mark them as read, watch and bookmark topics, and much more. JForum comes with built-in private messaging that allows site members to communicate privately while discussing issues or collaborating on projects. JForum has a familiar (popular phpBB) graphical user interface, and is liked by faculty and students, alike.
Learning Log	A derivation of the Blog tool aimed at pedagogies where reflective learning takes center stage.
MailArchive Wow!	MailArchive Wow! builds upon the ideas in the existing MailArchive, and leverages a number of new libraries/specs such as JSR-170 and RSF.
Melete - Modules	Melete allows instructors to publish learning sequences that can be created by using a rich text editor, uploading learning objects, or pointing to existing URL resources. Instructors can design content that supports instructor facilitated learning or system managed self-study. Lessons can be released automatically based on start and stop dates. Melete supports IMS Content Packaging and SCORM 2004 export. Future features include conditional release of lesson sequences to students based on completion of tasks. Melete stores its content in a private area of content hosting.
Mneme - Test Center	Mneme is an assessment system for Sakai. Mneme has a delivery module that is high performance, able to handle large loads, has an Assessments module to manage the publication of assessments, has a module for grading assessments, optionally integrated with Sakai's Gradebook, and has a module for authoring questions and managing pools.
My Sakai	"My Sakai" makes it possible to get your files and announcements, and keep track of what's going on in your Sakai sites, straight from your desktop. For example, a student engrossed in writing an essay, who suddenly realises they need to check something in a document in their course site, can open it straight from their desktop widget, without having to break off and navigate through Sakai to find it. "My Sakai" widgets show you recent activity on all of the worksites you're a member of. This means that the widget will tell you when a new announcement or a new resource has been added. The widgets also provide synoptic views of Resources and Announcements. We have created widgets for Mac DashBoard, Vista Sidebar, Facebook, iGoogle, Google Desktop, and RSS.
News Feeds	News Feeds is a feed aggregator tool developed for Sakai. The tool supports multiple feeds, user-provided feeds or selection from pre-configured institutional list, BASIC/DIGEST authentication and feed attachments (enclosures).
OCW	Support in Sakai for creating OpenCourseWare materials and sites. For information about the OpenCourseWare initiative, see http://www.ocwconsortium.org/about/index.shtml.
OODB	oodb is a Sakai Service for using the db4o oo-database for persistence.
OpenCast	A webcasting infrastructure application based on Apple's Podcast Producer with an administrative UI in Sakai.
OpenSyllabus	OpenSyllabus is an easy to use tool to create and publish model-based syllabi where faculty can finely control which resources (doc, ppt, xls, pdf, etc.) are accessible to registered students or to the general public. OpenSyllabus offers a unified interface with a standardized vocabulary for easy navigation. It also supports courses given to multiple sections.
QNA (Questions and Answers)	QNA (Questions and Answers) is a new tool being developed by UNISA and UCT. QNA enables students to ask questions anonymously, which can be answered by other students or lecturers or tutors (instructors/TAs). Questions are ranked by their popularity and can also be organized into categories. QNA builds on experiences from two existing tools: UNISA's FAQ tool and UCT's DFAQ tool.
Roleplay	Roleplay (aka "user alias") is a tool and service for Sakai 2.6.0 and later which allows users to be known as a name other than their default Sakai name within a site. It was originally developed at UCT for an international trade bargaining simulation game in which students were known by country names representing their teams (e.g. "Brazil 2A") rather than realm names.
Sakaibrary	Sakaibrary is a project to integrate licensed library resources with Sakai.
Sakai Groovy Shell	Sakai Groovy Shell
Sakai Maps	The SakaiMaps tool integrates Google Maps into Sakai and allows users to define and browse points of interest (POI) on the map. Each POI has a name, a short description, a type and optionally a url with more information.
SCORM Player	A Sakai tool able to launch and sequence a known conformant 'SCORM 2004 Conformant Sharable Content Object' (SCO), including data persistence of the full data model.
Sign-Up	A tool that allows users to organize office hours, review sessions, study groups and similar activities.
Simple Page Tool	The simple page tool allows users to create simple pages in worksites using the WYSIWYG editor, these pages can then link to things in resources if desired. It is defined as a multi tool so it can be added multiple times to the same site using the page order tool.
Sitestats	Site Stats is a tool for showing site statistics by user, event, or resource.
Skin Manager	The Skin manager tool allows site administrators to install and manage skins in a Sakai instance. Skins are uploaded in the portal as .zip archives that contain graphics and style sheets. The tool displays all the skins in use throughout the Sakai instance and indicates which sites use a particular skin. Skins may be revised by uploading a new archive and it is possible to revert to earlier versions of a skin. This strongly simplifies the skin installation process: no longer access to the file system of the sakai instance is needed.

Tool	Status Change
OSP Tools (Forms, Glossary, Matrices, Portfolio Layouts, Portfolio Templates, Portfolios, Styles, and Wizards)	Provisional to Core
Tests & Quizzes (Samigo)	Provisional to Core
Reset Password	Contrib to Provisional
Discussion	Retired from release to Contrib (More info...)
Assignments (Non-Graded Version)	Retired from release to Contrib

Sakai 2.5

Sakai 2.5

Current Release: Sakai 2.5.6 (released 28 Jan 2010)

Sakai 2.5 Distribution Packages

Demo

Binary

Source

Sakai 2.5 Source Code

Sakai 2-5-x Maintenance Branch

Migrating from a Previous Release

Security Issues and Older Releases

Comments, Feedback

Sakai 2.5 Installation Guides

Configuring Sakai 2.5

1.0 Create a sakai.properties File

2.0 Configure Email

3.0 Configure Logging

Changing the Log Configuration

4.0 Supported Database

4.1 Create Database

UTF-8 Character Set

4.2 Add Database Drivers

MySQL Connector/J Driver

Oracle OJDBC Driver

4.3 Configure Database Connection Settings

Set the Database Username and Password

Configure Database Settings

HSQLDB Sample Configuration

MySQL Sample Configuration

Oracle Sample Configuration

The auto.ddl Setting

Sakai 2.x Administrator's Guide

Introduction

The sakai.properties file

Configuring the sakai.properties file

The Configuration Viewer tool

Branding and Identity

sakai.properties settings

Skinning

Binary Content and Filesystem Settings

Storing binary content on the filesystem

Storing binary content in the database

Migrating from database storage to filesystem storage

Antivirus Scanning

Database Configuration and Tuning

Configuring for Performance

Oracle

Oracle and Tests & Quizzes

MySQL

Case Sensitivity

Query Caching

SAKAI_PRESENCE as an in-memory table

Disk I/O issues on Linux (Suse Linux Enterprise Server 9/Red Hat Enterprise Linux 4)

Email Configuration

Outgoing Mail

Testing Outgoing Mail Using a Notification

Incoming Mail

Testing Incoming (and outgoing) Mail Using James

Delivery Failure Notifications

Email Archive Tool Alias Naming Limitation

Configuring Sakai from within the Web Application

Adding Administrative Users

Manually Adding a Tool to a Sakai Site.

Displaying dynamic HTML within the gateway and other sites.

Permissions

JVM Tuning

Basic JVM Tuning

Advanced JVM Tuning

Load Balancing and Scaling

Introduction

Standalone Server

Thin client configuration

Load balanced thin client

Thicker client

Big Iron

Load Balancing Solutions

Software Solutions

Hardware Solutions

Sticky Sessions and Sakai

Cluster Options in the sakai.properties File

1.0 Create a `sakai.properties` File

New `preference.pages` property (SAK-6545)