[Using Sakai] Emergency help needed when deploy sakai 2.7
rigo8686 at gmail.com
rigo8686 at gmail.com
Fri Jul 9 22:43:22 PDT 2010
I have checked my Tomcat directory and I'm sure lots of sakai related
directories and jars are in there. I attached the full log here and
please help me. Thanks a lot.
Regards,
Ricky
于 2010/7/9 8:00, Steve Swinsburg 写道:
> Hi,
>
> Can you check your Tomcat directory and ensure you have a components
> directory with a number of sakai related directories inside, and also
> shared/lib with a number of jars in there also.
>
> Also, can you send the full log from a recent startup, not a truncated
> one. There might be things that are missing that will point to the
> problem.
>
> thanks,
> Steve
>
>
> This seems to be a common problem lately.
>
>
> On 09/07/2010, at 1:10 AM, rigo8686 at gmail.com
> <mailto:rigo8686 at gmail.com> wrote:
>
>> 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)
>>
>> _______________________________________________
>> sakai-user mailing list
>> sakai-user at collab.sakaiproject.org
>> <mailto:sakai-user at collab.sakaiproject.org>
>> http://collab.sakaiproject.org/mailman/listinfo/sakai-user
>>
>> TO UNSUBSCRIBE: send email to
>> sakai-user-unsubscribe at collab.sakaiproject.org with a subject of
>> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20100710/49547a5d/attachment-0001.html
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: tomcat.log
Url: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20100710/49547a5d/attachment-0001.pl
More information about the sakai-user
mailing list