[Using Sakai] Emergency help needed when deploy sakai 2.7
Steve Swinsburg
steve.swinsburg at gmail.com
Thu Jul 8 17:00:19 PDT 2010
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 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
> 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
> 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/20100709/7dd02f52/attachment-0001.html
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 3689 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20100709/7dd02f52/attachment-0001.bin
More information about the sakai-user
mailing list