[Building Sakai] Problem with SAKAI_SITE_TOOL_PROPERTY query

[Jean-Francois Leveque]

Hi Ciellie,

You can check the release notes for CLE 2.8 at 
https://confluence.sakaiproject.org/display/DOC/Sakai+CLE+2.8+Release+Notes

Under "Database support", you can read:
> Irrespective of whether you utilize MySQL, Oracle or DB2 be sure you have configured your database to use the UTF-8 character set. Failure to do so will result in range of issues when attempting to use Unicode characters in Sakai. Consult your Db documentation or a local DBA for instructions on how to set your database up properly.
>
> If you are uncertain as to how your database is currently configured, you can check with a query. Here is a sample query for checking an Oracle instance:
>
> SQL> select value from nls_database_parameters where parameter = 'NLS_CHARACTERSET';
>
> VALUE
> --------------------------------------------------------------------------------
> AL32UTF8
>
> For MySQL, the command to see what encoding your database is currently set to is "show create database sakai", assuming, of course, that your database is named "sakai". e.g.:
>
> mysql> show create database sakai;
> +----------+----------------------------------------------------------------+
> | Database | Create Database |
> +----------+----------------------------------------------------------------+
> | sakai | CREATE DATABASE `sakai` /*!40100 DEFAULT CHARACTER SET utf8 */ |
> +----------+----------------------------------------------------------------+
> 1 row in set (0.00 sec)
>
> Converting a database from one character set to another is a non-trivial operation, particularly if it is a large production database. We recommend strongly that you verify this aspect of the database creation and configuration process before deploying Sakai.

Hope this helps.

I don't think this is the cause of your error. But unless you're sure 
no-one is gonna use characters outside ASCII-7 in your CLE instance for 
ever, you should fix this ASAP.


Have you tried to log on your DB server from your application server 
using command-line mysql client or any other way not using your Sakai 
binaries?


Which "out of memory errors" are you getting?

Are they in the catalina.out?

Could you give us the exact error from the logs?


Cheers

J-F

On 31/01/2012 08:25, Ciellie wrote:
> Hallo
>
> Thanx for the reply. I had a look at the connector jar it is 5.0.8 and Mysql
>
> version is 5.0.77 it seems fine but in sakai.properties we define the url as
>
> jdbc:mysql://sakai-db-lnx1.nwu.ac.za:3306/sakai?useUnicode=true&
>
> characterEncoding=UTF-8
>
> but the db's characterset is latin1 will this cause the problem? and possible
>
> out of memory errors later ?
>
> Thanx
>
> Ciellie