[Deploying Sakai] Reg : Mysql Issue while starting Sakai 2.9.0

[Beth Kirschner]

We were getting a different error with Tomcat 7.0.35 (https://jira.sakaiproject.org/browse/STAT-339) - so you might consider dropping down to tomcat 7.0.32 until that's been resolved. This problem looks like you might not have created your database with the unicode character set:
	create database sakai default character set utf8; 

- Beth

On Jan 24, 2013, at 11:18 AM, prabhu wrote:

> Hi,
> 
> I am using sakai 2.9.0 with Mysql DB. Installation went fine.. But when I start the tomcat I get the following errors. How to overcome this.
> 
> Using : mysql  Ver 14.14 Distrib 5.1.61
> 
> 2013-01-24 06:07:51,475  WARN localhost-startStop-1 org.hibernate.util.JDBCExceptionReporter - SQL Error: 1366, SQLState: HY000
> 2013-01-24 06:07:51,476 ERROR localhost-startStop-1 org.hibernate.util.JDBCExceptionReporter - Incorrect string value: '\xE4\xBB\x8E${l...' for column 'SUBJECT' at row 1
> 2013-01-24 06:07:51,563  WARN localhost-startStop-1 org.sakaiproject.component.impl.SpringCompMgr - get(org.sakaiproject.profile2.legacy.ProfileManager):
> org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.sakaiproject.profile2.legacy.ProfileManager' defined in file [/opt/apache-tomcat-7.0.35/components/profile2-pack/WEB-INF/components.xml]: Cannot resolve reference to bean 'org.sakaiproject.profile2.logic.ProfileLogic' while setting bean property 'profileLogic'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.sakaiproject.profile2.logic.ProfileLogic' defined in file [/opt/apache-tomcat-7.0.35/components/profile2-pack/WEB-INF/components.xml]: Cannot resolve reference to bean 'org.sakaiproject.profile2.logic.SakaiProxy' while setting bean property 'sakaiProxy'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.sakaiproject.profile2.logic.SakaiProxy' defined in file [/opt/apache-tomcat-7.0.35/components/profile2-pack/WEB-INF/components.xml]: Invocation of init method failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [org.sakaiproject.emailtemplateservice.model.EmailTemplate]; uncategorized SQLException for SQL [insert into EMAIL_TEMPLATE_ITEM (LAST_MODIFIED, OWNER, SUBJECT, emailfrom, MESSAGE, HTMLMESSAGE, TEMPLATE_KEY, TEMPLATE_LOCALE, defaultType, VERSION) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [HY000]; error code [1366]; Incorrect string value: '\xE4\xBB\x8E${l...' for column 'SUBJECT' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xE4\xBB\x8E${l...' for column 'SUBJECT' at row 1
>         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275)
>         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1245)
>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010)
> 
> 
> -- 
> -----------------------------------------------------------------------------------------------------------------------------------------------
> 
> Regards:
> 
> Prabhu Janakaraj,
> Consultant Linux and Networking - Training and Deployment, 
> Skype: prabhu.j4
> Handphone: 091 9790 382 999
> _______________________________________________
> production mailing list
> production at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/production
> 
> TO UNSUBSCRIBE: send email to production-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"