[Building Sakai] Latest 2.7.x throw UTF-8 DB Error

[Stephen Marquard]

>From a mysql prompt:

drop database sakai;
create database sakai default character set utf8;
 
Regards
Stephen

>>> Warwick Chapman <warwickchapman at gmail.com> 6/4/2010 9:25 AM >>> 
Hey Steve

I created the DB with:

mysqladmin -p create sakai

The MySQL config in sakai.properties follows:

vendor at org.sakaiproject.db.api.SqlService=mysql
driverClassName at javax.sql.BaseDataSource=com.mysql.jdbc.Driver
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
url at javax.sql.BaseDataSource
=jdbc:mysql://dbserver:3306/sakai?useUnicode=true&characterEncoding=UTF-8
validationQuery at javax.sql.BaseDataSource=select 1 from DUAL
defaultTransactionIsolationString at javax.sql.BaseDataSource
=TRANSACTION_READ_COMMITTED

-- Warwick Bruce Chapman | +27 83 7797 094 | http://warwickchapman.com


On Fri, Jun 4, 2010 at 8:54 AM, Steve Swinsburg
<steve.swinsburg at gmail.com>wrote:

> Hi Warwick,
>
> When you created your database, did you create it with the utf8 character
> set? Also, does your Tomcat connector have the URIEncoding="UTF-8" parameter
> added?
>
> cheers,
> Steve
>
>
> On 04/06/2010, at 4:48 PM, Warwick Chapman wrote:
>
> Hi All
>
> I'm back on the horse now and trying to install the latest 2.7.x branch
> (78257) but am getting the following in the catalina.out file:
>
> <log>
> FATAL main org.sakaiproject.content.impl.DbContentService - Check on
> Database Failed
> java.sql.SQLException: Incorrect string value:
> '\xC2\x80\xC2\x81\xC2\x82...' for column 'XML' at row 1
>
> ...
>
> FATAL main org.sakaiproject.content.impl.DbContentService - WARNING
>   The connection from this instance of Sakai to the database
>   has been tested and found to corrupt UTF-8 Data.
>   In order for Sakai to operate correctly you must ensure that your
>   database setup is correct for UTF-8 data. This includes both the
>   JDBC connection to the database and the underlying storage in the
>   database.
>   The test that was performed on your database create a table
>   wrote some data to that table and read it back again. On reading
>   that data back it found some form of corruption, reported above.
>
>  More information on database setup for sakai can be found at
>
> http://bugs.sakaiproject.org/confluence/display/DOC/Install+Guide+-+DB+(2.4)
>
>  Sakai Startup will continue but you might want to address this issue ASAP.
> </log>
>
> MySQL is using the InnoDB engine as recommended by Anthony Whyte and I can
> confirm that the DB was successfully populated upon initial startup.
>
> -- Warwick Bruce Chapman | +27 83 7797 094 | http://warwickchapman.com
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
>
>



 

###
UNIVERSITY OF CAPE TOWN 

This e-mail is subject to the UCT ICT policies and e-mail disclaimer published on our website at http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from +27 21 650 4500. This e-mail is intended only for the person(s) to whom it is addressed. If the e-mail has reached you in error, please notify the author. If you are not the intended recipient of the e-mail you may not use, disclose, copy, redirect or print the content. If this e-mail is not related to the business of UCT it is sent by the sender in the sender's individual capacity.

###