[Using Sakai] Emergency help needed when deploy sakai 2.7

Thu Jul 8 08:10:37 PDT 2010

Hello, I had two problems when I deploy the source 2.7.

1st problem:  Maven said build successful but nothing created in my 
tomcat home. I used the command:

mvn clean install sakai:deploy 
-Dmaven.tomcat.home=C:\Apps\ITSoftware\OpenSource\apache-tomcat-5.5.28

The system is windows 7. Java version is 1.6.0_03. I don't know how to 
resolve it. I followed the steps in the documents.

2nd problem: I asked for help some days ago but no replies. So I tried a 
binary version. But what a disappointment, when my tomcat start up, here 
are errors (I picked out some important):
=============================================
2010-07-08 11:19:42,500  INFO main 
org.sakaiproject.util.SakaiApplicationContext
  - Bean factory for application context 
[org.sakaiproject.util.SakaiApplicationC
ontext at 933bcb]: 
org.sakaiproject.util.NoisierDefaultListableBeanFactory at 5d3ac0
Could not resolve placeholder 'sakai.security' in 
[file:${sakai.security}securit
y.properties] as system property: neither system property nor 
environment variab
le found
2010-07-08 11:19:42,698  WARN main 
org.springframework.beans.factory.config.Prop
ertiesFactoryBean - Could not load properties from URL 
[file:C:/Apps/ITSoftware/
OpenSource/apache-tomcat-5.5.28/sakai/placeholder.properties]: 
C:\Apps\ITSoftwar
e\OpenSource\apache-tomcat-5.5.28\sakai\placeholder.properties
2010-07-08 11:19:42,701  WARN main 
org.springframework.beans.factory.config.Prop
ertiesFactoryBean - Could not load properties from URL 
[file:C:/Apps/ITSoftware/
OpenSource/apache-tomcat-5.5.28/sakai/local.properties]: 
C:\Apps\ITSoftware\Open
Source\apache-tomcat-5.5.28\sakai\local.properties
2010-07-08 11:19:42,703  WARN main 
org.springframework.beans.factory.config.Prop
ertiesFactoryBean - Could not load properties from URL 
[file:${sakai.security}se
curity.properties]: ${sakai.security}security.properties
2010-07-08 11:19:42,809  WARN main 
org.springframework.beans.factory.config.Prop
ertyPlaceholderConfigurer - Could not load properties from URL 
[file:C:/Apps/ITS
oftware/OpenSource/apache-tomcat-5.5.28/sakai//local.properties]: 
C:\Apps\ITSoft
ware\OpenSource\apache-tomcat-5.5.28\sakai\local.properties
.....
2010-07-08 11:19:43,539  WARN main 
org.sakaiproject.db.impl.BasicSqlService - Sq
l.ddl: missing resource: mysql5.1.48/sakai_locks.sql
2010-07-08 11:19:43,539  INFO main 
org.sakaiproject.db.impl.BasicSqlService - in
it(): vendor: mysql5.1.48 autoDDL: true deadlockRetries: 5
2010-07-08 11:19:43,541  WARN main 
org.sakaiproject.db.impl.BasicSqlService - Sq
l.ddl: missing resource: mysql5.1.48/sakai_site.sql
2010-07-08 11:19:43,542  WARN main 
org.sakaiproject.db.impl.BasicSqlService - Sq
l.ddl: missing resource: mysql5.1.48/sakai_site_group.sql
2010-07-08 11:19:43,544  WARN main 
org.sakaiproject.db.impl.BasicSqlService - Sq
l.ddl: missing resource: mysql5.1.48/sakai_site_2_1_0_003.sql
2010-07-08 11:19:43,545  WARN main 
org.sakaiproject.db.impl.BasicSqlService - Sq
l.ddl: missing resource: mysql5.1.48/sakai_site_2_4_0_001.sql
2010-07-08 11:19:43,547  WARN main 
org.sakaiproject.db.impl.BasicSqlService - Sq
l.ddl: missing resource: mysql5.1.48/sakai_site_2_5_3.sql
2010-07-08 11:19:43,649  WARN main 
org.sakaiproject.db.impl.BasicSqlService - Sq
l.ddl: missing resource: mysql5.1.48/sakai_event.sql
......
2010-07-08 11:19:43,800  WARN main 
org.sakaiproject.db.impl.BasicSqlService - Sq
l.ddl: missing resource: mysql5.1.48/sakai_realm.sql
2010-07-08 11:19:43,807  WARN main 
org.sakaiproject.db.impl.BasicSqlService - Sq
l.ddl: missing resource: mysql5.1.48/sakai_realm_2_4_0_001.sql
......
2010-07-08 11:19:52,296  INFO main 
org.sakaiproject.springframework.orm.hibernat
e.AddableSessionFactoryBean - Updating database schema for Hibernate 
SessionFact
ory          (this lasted for about half a minute then a lot of errors 
appeared)
.......
2010-07-08 11:20:00,866  WARN main 
org.sakaiproject.db.impl.BasicSqlService - Sq
l.dbRead: sql: select ROLE_NAME from SAKAI_REALM_ROLE
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 
'sakai.sakai_re
alm_role' doesn't exist
         at 
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
         at 
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
orAccessorImpl.java:39)
         at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
onstructorAccessorImpl.java:27)
         at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
         at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
         at com.mysql.jdbc.Util.getInstance(Util.java:384)
         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
         ......
2010-07-08 11:20:00,903  WARN main 
org.sakaiproject.db.impl.BasicSqlService - Sq
l.dbRead: sql: select FUNCTION_NAME from SAKAI_REALM_FUNCTION
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 
'sakai.sakai_re
alm_function' doesn't exist
         at 
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
         at 
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
orAccessorImpl.java:39)
         at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
onstructorAccessorImpl.java:27)
         at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
         at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
         at com.mysql.jdbc.Util.getInstance(Util.java:384)
         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
.......
2010-07-08 11:20:00,977  WARN main 
org.sakaiproject.db.impl.BasicSqlService - Sq
l.ddl: missing resource: mysql5.1.48/sakai_user.sql
2010-07-08 11:20:00,978  WARN main 
org.sakaiproject.db.impl.BasicSqlService - Sq
l.ddl: missing resource: mysql5.1.48/sakai_user_2_1_0_004.sql
2010-07-08 11:20:00,979  WARN main 
org.sakaiproject.db.impl.BasicSqlService - Sq
l.ddl: missing resource: mysql5.1.48/sakai_user_2_1_0.sql
2010-07-08 11:20:00,980  WARN main 
org.sakaiproject.db.impl.BasicSqlService - Sq
l.ddl: missing resource: mysql5.1.48/sakai_user_2_2_map.sql
......
2010-07-08 11:20:01,278  WARN main 
org.sakaiproject.db.impl.BasicSqlService - Sq
l.ddl: missing resource: mysql5.1.48/sakai_content_registry.sql
.......
2010-07-08 11:20:01,335  WARN main 
org.sakaiproject.db.impl.BasicSqlService - Sq
l.ddl: missing resource: mysql5.1.48/sakai_preferences.sql
2010-07-08 11:20:01,420  WARN main 
org.sakaiproject.db.impl.BasicSqlService - Sq
l.ddl: missing resource: mysql5.1.48/sakai_content.sql
2010-07-08 11:20:01,421  WARN main 
org.sakaiproject.db.impl.BasicSqlService - Sq
l.ddl: missing resource: mysql5.1.48/sakai_content_delete.sql
2010-07-08 11:20:01,422  WARN main 
org.sakaiproject.db.impl.BasicSqlService - Sq
l.ddl: missing resource: mysql5.1.48/sakai_content_2_1_0.sql
2010-07-08 11:20:01,429  WARN main 
org.sakaiproject.db.impl.BasicSqlService - Sq
l.dbRead: sql: show columns from CONTENT_RESOURCE like 'FILE_SIZE'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 
'sakai.content_
resource' doesn't exist
         at 
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
         at 
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
orAccessorImpl.java:39)
         at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
onstructorAccessorImpl.java:27)
         at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
         at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
         at com.mysql.jdbc.Util.getInstance(Util.java:384)
         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
         ......
2010-07-08 11:20:01,474  WARN main 
org.sakaiproject.db.impl.BasicSqlService - Sq
l.dbWrite(): error code: 1146 sql: alter table CONTENT_RESOURCE add 
FILE_SIZE BI
GINT default null binds:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 
'sakai.content_
resource' doesn't exist
......
2010-07-08 11:20:01,501  WARN main 
org.sakaiproject.content.impl.DbContentServic
e - init():
java.lang.RuntimeException: SqlService.dbWrite failure
......
2010-07-08 11:20:01,598  WARN main 
org.sakaiproject.db.impl.BasicSqlService - Sq
l.ddl: missing resource: mysql5.1.48/quartz.sql
org.quartz.SchedulerConfigException: Failure occured during job 
recovery. [See n
ested exception: org.quartz.JobPersistenceException: Couldn't clean 
volatile dat
a: Table 'sakai.qrtz_triggers' doesn't exist [See nested exception: 
com.mysql.jd
bc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 
'sakai.qrtz_triggers' doesn
't exist]]
         at 
org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSuppo
rt.java:606)
         at 
org.quartz.impl.jdbcjobstore.JobStoreTX.initialize(JobStoreTX.java:59
)
         at 
org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.j
ava:1231)
         at 
org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.
java:1394)
         at 
org.sakaiproject.component.app.scheduler.SchedulerManagerImpl.init(Sc
hedulerManagerImpl.java:157)
         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
.......
Caused by: org.quartz.JobPersistenceException: Couldn't clean volatile 
data: Tab
le 'sakai.qrtz_triggers' doesn't exist [See nested exception: 
com.mysql.jdbc.exc
eptions.jdbc4.MySQLSyntaxErrorException: Table 'sakai.qrtz_triggers' 
doesn't exi
st]
......
2010-07-08 11:20:02,037 ERROR main 
org.sakaiproject.util.NoisierDefaultListableB
eanFactory - Failed to preinstantiate the singleton named 
org.sakaiproject.conte
nt.providers.BaseEventDelayHandler. Destroying all Spring beans.
org.springframework.beans.factory.BeanCreationException: Error creating 
bean wit
h name 'org.sakaiproject.content.providers.BaseEventDelayHandler' 
defined in fil
e 
[C:\Apps\ITSoftware\OpenSource\apache-tomcat-5.5.28\components\content-provide
rs-pack\WEB-INF\components.xml]: Cannot resolve reference to bean 
'org.sakaiproj
ect.api.app.scheduler.ScheduledInvocationManager' while setting bean 
property 's
chedInvocMgr'; nested exception is 
org.springframework.beans.factory.BeanCreatio
nException: Error creating bean with name 
'org.sakaiproject.api.app.scheduler.Sc 
<http://org.sakaiproject.api.app.scheduler.Sc>
heduledInvocationManager' defined in file 
[C:\Apps\ITSoftware\OpenSource\apache-
tomcat-5.5.28\components\scheduler-component\WEB-INF\components.xml]: 
Cannot res
olve reference to bean 
'org.sakaiproject.api.app.scheduler.SchedulerManager' whi
le setting bean property 'schedulerManager'; nested exception is 
org.springframe
work.beans.factory.BeanCreationException: Error creating bean with name 
'org.sak
aiproject.api.app.scheduler.SchedulerManager' defined in file 
[C:\Apps\ITSoftwar
e\OpenSource\apache-tomcat-5.5.28\components\scheduler-component\WEB-INF\compone
nts.xml]: Invocation of init method failed; nested exception is 
java.lang.Error:
  Scheduler cannot start!
......
===============================
My database is MySQL5.1.48. And in my database many tables of sakai had 
been created. Maybe some sql scripts was missing? Please help me and I 
really need to start up sakai for my class.
Thank you!

Regards,

Ricky
-- 

祝好！

宋瑞光 (Ruiguang Song)

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20100708/60cd027a/attachment-0001.html 