Sakai 2.6

etc.

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

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

reference/docs/conversion
SAKAI_SITE_TOOL
Mercury
-- SAK-16668
-- Note: If you upgraded to sakai 2.6.0 PRIOR TO September 1st 2009 you'll need to run this column conversion.
-- You should probably check your columns as they should be converted from varchar to text
-- (Or just run them anyway as it is safe to rerun, which is why they are uncommented)
ALTER TABLE ASN_MA_ITEM_T CHANGE TEXT TEXT TEXT;
ALTER TABLE ASN_NOTE_ITEM_T CHANGE NOTE NOTE TEXT;

Sakai_Person_T

--- 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));
mailarchive-runconversion.sh
-- SAK-13584 Further Improve the Performance of the Email Archive and Message API. Note you have to run a bash conversion script on your old mail archive data for it to
-- appear in the new mail archive. The script is in the source as mailarchive-runconversion.sh. Please see the SAK for more information on this script or SAK-16554 for
-- updates to this script.
	  	 
	  	 CREATE INDEX IE_MAILARC_SUBJECT ON MAILARCHIVE_MESSAGE
 	  	 (
 	  	        SUBJECT                   ASC
 	  	 );
	  	 ALTER TABLE MAILARCHIVE_MESSAGE ADD COLUMN (
 	  	        SUBJECT           VARCHAR (255) NULL,
	  	        BODY              LONGTEXT NULL
 	  	 );

sakai.properties
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
README.TXT
sakai.properties
sakai.properties
/sakai
$CATALINA_HOME
sakai.properties
sakai.properties
default.sakai.properties
config
sakai-src/config/configuration/bundles/src/bundle/org/sakaiproject/config/bundle/default.sakai.properties

sample.sakai.properties
config
sakai-src/config/configuration/bundles/src/bundle/org/sakaiproject/config/bundle/sample.sakai.properties

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

sakai.properties
sakai_properties.doc
/reference/docs/architecture/sakai_properties.doc
wsetup.home.toolids.*
sakai.iframe.site
sakai.summary.calendar
sakai.synoptic.announcement
sakai.synoptic.chat
sakai.synoptic.messagecenter
wsetup.home.toolids.count=5
wsetup.home.toolids.1=sakai.privacy
wsetup.home.toolids.2=sakai.iframe
wsetup.home.toolids.3=sakai.synoptic.announcement
wsetup.home.toolids.4=sakai.synoptic.chat
wsetup.home.toolids.5=sakai.synoptic.messagecenter

sakai.properties
wsetup.group.helper.name = sakai-site-manage-group-helper 

loggedOutUrl
sakai.properties
timeoutDialogEnabled=true
timeoutDialogWarningSeconds=600

sakai.properties
smtp@org.sakaiproject.email.api.EmailService=some.smtp.org

# flag to enable or disable James for incoming email (true | false)
#Default=false.
smtp.enabled=true

# dns addresses used by James for incoming email.
smtp.dns.1=255.255.255.1
smtp.dns.2=255.255.255.2

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

# Email support address used in incoming email rejection messages.
mail.support=address@somedomain

# Email address to send errors caught by the portal, and user bug reports in response.
portal.error.email=address@somedomain

# Email address used as the "from" address for any email sent by Worksite Setup tool or Site Info tool.
setup.request=address@somedomain

# Send an email to the user when the user is added.
notifyNewUserEmail=true

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
kernel/kernel-common/src/main/config/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
autoDDL
sakai.properties
InnoDB
mysql-connector-java-<version>-bin.jar
$CATALINA_HOME/common/lib
ojdbc14.jar
$CATALINA_HOME/common/lib
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)

sakai.properties
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

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

auto.ddl=false
autoDDL
sakai.properties
mysql --version

mysql  Ver 14.12 Distrib 5.0.51a, for apple-darwin8.11.1 (i686) using readline 5.0

mysql -u root -pmysqlpassword

/usr/local/mysql-5.0.51a-osx10.4-i686
ln -s
export MYSQL_HOME=/usr/local/mysql

set MYSQL_HOME=C:\mysql-5.0.51a-osx10.4-i686

/bin
export PATH=$PATH:$CATALINA_HOME/bin:$JAVA_HOME/bin:$M2_HOME/bin:$MYSQL_HOME/bin:$PHP_HOME/bin:$SUBVERSION_HOME/bin:$USR_LOCAL/bin

;C:\mysql-5.0.51a-osx10.4-i686\bin

my.cnf/my.ini
my.cnf
/etc/my.cnf
/usr/local/mysql/data/my.cnf
/usr/local/var/my.cnf
~/my.cnf
/etc/my.cnf
[mysqld]
socket=/var/mysql/mysql.sock
default-storage-engine=InnoDB
innodb_data_home_dir = /usr/local/mysql/data
innodb_data_file_path=ibdata1:10M:autoextend
innodb_flush_log_at_trx_commit=1
[client]
socket=/var/mysql/mysql.sock

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> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> quit

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" />
<!-- redirect all traffic to the SSL port -->
<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>
<!-- redirect all traffic to the SSL port -->
<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
visibleTools@org.sakaiproject.tool.api.ActiveToolManager=sakai.mailtool,sakai.poll
hiddenTools@org.sakaiproject.tool.api.ActiveToolManager=sakai.announcements

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

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

räksmörgås.txt
-- Detect and repair indexes in an invalid state ORA-01502
-- Run this select, if there are any problems with the indexes, run the alter index statements that it generates.

select 'alter index '||index_name||' rebuild online;' from user_indexes where status = 'INVALID' or status = 'UNUSABLE';

-- After this you may need to re-gather table stats on the tables with an invalid index (likely just mailarchive)

analyze table /your_table_name/ compute statistics;
DBMS_STATS.gather_tables_stats();

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

2.6.x	MySQL	sakai_2_6_0-2_6_x_mysql_conversion005_SAK-14482.sql
2.6.x	Oracle	sakai_2_6_0-2_6_x_oracle_conversion005_SAK-14482.sql

2.6.x	MySQL	sakai_2_6_0-2_6_x_mysql_conversion002_SAK-16548.sql
2.6.x	Oracle	sakai_2_6_0-2_6_x_oracle_conversion002_SAK-16548.sql

2.6.x	MySQL	sakai_2_6_0_mysql
2.6.x	Oracle	sakai_2_6_0_oracle

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`

Db Version	Driver	URL
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
Oracle 10g/Oracle 9i	OJDBC	http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

Scope	Location	Override
global	`/etc/my.cnf`
server-specific	binary install: `/usr/local/mysql/data/my.cnf`; source install: `/usr/local/var/my.cnf`	global
user	`~/my.cnf`	global, server-specific

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

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

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

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.
Sparkline	Sparkline collects and displays continuous real-time feedback. It has an interface for users to continuously adjust a relative rating scale and a constantly updating sparkline of the average rating.
Taggable	Taggable API.
Textbook	A tool to facilitate the identification, buying and selling of textbooks.
TransformAble	TransformAble is useful for users who want to customize Sakai's appearance to improve the readability and accessibility.
Wicket	The goal of Wicket Contrib is to provide a component set to facilitate the development of Sakai tools using Apache Wicket (http://wicket.apache.org). If you're wondering what Wicket is all about, we've started compiling a list of hopefully useful links here. We are also compiling a list of projects that are using Wicket.
Wimba Integration	Integration of Wimba and Sakai.
Word-to-QTI Convertor	A Word-2-QTI Converter.

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

Sakai 2.6

Sakai 2.6

Current Release: Sakai 2.6.2 (released 29 January 2010)

Sakai 2.6 Distribution Packages

Demo

Binary

Source

Sakai 2.6 Source Code

Sakai 2-6-x Maintenance Branch

Migrating from a Previous Release

Security Issues and Older Releases

Comments, Feedback

Sakai 2.6 Installation Guides

1.0 Database Conversions

1.1 Database Conversion Script Corrections

1.1.1 Update SAKAI_SITE_TOOL table to change assignments tool in Mercury site

1.1.2 Sakai 2.6.0 to 2.6.1 conversion scripts update, 19 Oct 2009

1.1.3 Assignments conversion script column conversion change, 1 Sept 2009

1.1.4 Sakai 2.6.0 conversion script update, 22 July 2009

1.1.5 Sakai_Person_T notes field size change

1.2 Other Database Conversions

1.2.1 Email Archive performance improvements

1.2.2 Assignments Tool

1.2.3 Content Hosting

2.0 sakai.properties changes

2.1 New preference.pages property

2.2 WebDAV properties changes

2.3 Worksite Setup and Site Info properties changes

2.4 Portfolios (OSP) permission settings

2.5 Portfolios (OSP) reports property changes

3.0 Deprecated Discussion Tool

Configuring Sakai 2.6

1.0 Create a sakai.properties file

2.0 NEW Configure home page tool set per site

3.0 NEW Work site setup group helper

4.0 NEW Session timeout warning

Session timeout warning

5.0 Configure email

6.0 Configure logging

7.0 Database support in Sakai

7.1 Configure the database

7.2 Set the database username and password

7.3 Set the database connection

HSQLDB Sample Configuration

MySQL Sample Configuration

Oracle Sample Configuration

7.4 Set auto.ddl=true

8.0 Install MySQL 5.0+

8.1 Set MySQL environment variables

MYSQL_HOME

PATH

8.2 Create a my.cnf/my.ini configuration file

8.3 Create a "sakai" database and user account

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

1.1.1 Update `SAKAI_SITE_TOOL` table to change assignments tool in `Mercury` site

1.1.5 `Sakai_Person_T` notes field size change

2.0 `sakai.properties` changes

2.1 New `preference.pages` property

1.0 Create a `sakai.properties` file

7.4 Set `auto.ddl=true`

8.2 Create a `my.cnf/my.ini` configuration file