2008年7月7日月曜日

intalio deploy error

sudo env JAVA_HOME=$JAVA_HOME /home/intalio/apache-tomcat-5.5.26/bin/catalina.sh run
Using CATALINA_BASE: /home/intalio/apache-tomcat-5.5.26
Using CATALINA_HOME: /home/intalio/apache-tomcat-5.5.26
Using CATALINA_TMPDIR: /home/intalio/apache-tomcat-5.5.26/temp
Using JRE_HOME: /usr/lib/jvm/java-1.5.0-sun-1.5.0.15
00:02:40,761 INFO [Catalina] Initialization processed in 6167 ms
00:02:51,448 WARN [TempoUsernamePasswordAuthenticationHandler] org.intalio.tempo.cas.TempoUsernamePasswordAuthenticationHandler is only to be used in a testing environment. NEVER enable this in a production environment.
00:02:57,277 INFO [AuthenticationViaFormAction] FormObjectClass not set. Using default class of org.jasig.cas.authentication.principal.UsernamePasswordCredentials with formObjectName credentials and validator org.jasig.cas.validation.UsernamePasswordCredentialsValidator.
00:03:12,871 INFO [DefaultTicketRegistryCleaner] Starting cleaning of expired tickets from ticket registry at [Mon Jul 07 00:03:12 GMT+09:00 2008]
00:03:12,917 INFO [DefaultTicketRegistryCleaner] 0 found to be removed. Removing now.
00:03:12,918 INFO [DefaultTicketRegistryCleaner] Finished cleaning of expired tickets from ticket registry at [Mon Jul 07 00:03:12 GMT+09:00 2008]
00:03:27,446 ERROR [SimpleScheduler] Error retrieving node list.
org.apache.ode.scheduler.simple.DatabaseException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'bpms.ODE_JOB' doesn't exist
at org.apache.ode.scheduler.simple.JdbcDelegate.getNodeIds(JdbcDelegate.java:118)
at org.apache.ode.scheduler.simple.SimpleScheduler$3.call(SimpleScheduler.java:283)
at org.apache.ode.scheduler.simple.SimpleScheduler$3.call(SimpleScheduler.java:282)
at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:174)
at org.apache.ode.scheduler.simple.SimpleScheduler.start(SimpleScheduler.java:280)
at org.apache.ode.bpel.engine.BpelServerImpl.start(BpelServerImpl.java:137)
at org.apache.ode.axis2.ODEServer.init(ODEServer.java:170)
at org.apache.ode.axis2.ODEServer.init(ODEServer.java:119)
at org.apache.ode.axis2.hooks.ODEAxisServlet.init(ODEAxisServlet.java:53)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1139)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:966)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3956)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4230)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:926)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:889)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'bpms.ODE_JOB' doesn't exist
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1026)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at org.apache.ode.scheduler.simple.JdbcDelegate.getNodeIds(JdbcDelegate.java:107)
... 34 more
00:03:27,471 ERROR [ODEServer] ODE BPEL Server failed to start.
org.apache.ode.bpel.iapi.ContextException: Error retrieving node list.
at org.apache.ode.scheduler.simple.SimpleScheduler.start(SimpleScheduler.java:290)
at org.apache.ode.bpel.engine.BpelServerImpl.start(BpelServerImpl.java:137)
at org.apache.ode.axis2.ODEServer.init(ODEServer.java:170)
at org.apache.ode.axis2.ODEServer.init(ODEServer.java:119)
at org.apache.ode.axis2.hooks.ODEAxisServlet.init(ODEAxisServlet.java:53)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1139)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:966)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3956)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4230)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:926)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:889)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
Caused by: org.apache.ode.scheduler.simple.DatabaseException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'bpms.ODE_JOB' doesn't exist
at org.apache.ode.scheduler.simple.JdbcDelegate.getNodeIds(JdbcDelegate.java:118)
at org.apache.ode.scheduler.simple.SimpleScheduler$3.call(SimpleScheduler.java:283)
at org.apache.ode.scheduler.simple.SimpleScheduler$3.call(SimpleScheduler.java:282)
at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:174)
at org.apache.ode.scheduler.simple.SimpleScheduler.start(SimpleScheduler.java:280)
... 30 more
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'bpms.ODE_JOB' doesn't exist
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1026)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at org.apache.ode.scheduler.simple.JdbcDelegate.getNodeIds(JdbcDelegate.java:107)
... 34 more
00:03:27,506 ERROR [[/ode]] サーブレット /ode がload()例外を投げました
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'bpms.ODE_JOB' doesn't exist
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1026)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at org.apache.ode.scheduler.simple.JdbcDelegate.getNodeIds(JdbcDelegate.java:107)
at org.apache.ode.scheduler.simple.SimpleScheduler$3.call(SimpleScheduler.java:283)
at org.apache.ode.scheduler.simple.SimpleScheduler$3.call(SimpleScheduler.java:282)
at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:174)
at org.apache.ode.scheduler.simple.SimpleScheduler.start(SimpleScheduler.java:280)
at org.apache.ode.bpel.engine.BpelServerImpl.start(BpelServerImpl.java:137)
at org.apache.ode.axis2.ODEServer.init(ODEServer.java:170)
at org.apache.ode.axis2.ODEServer.init(ODEServer.java:119)
at org.apache.ode.axis2.hooks.ODEAxisServlet.init(ODEAxisServlet.java:53)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1139)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:966)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3956)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4230)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:926)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:889)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
00:04:04,313 INFO [Catalina] Server startup in 83542 ms

---
以下を忘れていましたぁ
$ mysql -u root -p bpms < /home/tempo/rsc/scripts/../../rsc/tempo-sql/ode-mysql.sql

これはインストールの最後に表示される物
-- Now a mysql database named "bpms" with access to user and no password
-- Load the ode schema into mysql from the file
-- /home/tempo/rsc/scripts/../../rsc/tempo-sql/ode-mysql.sql
-- Once this is done, start tomcat with the following command:
-- ./catalina.sh run
-- Now you can browse http://localhost:8080/ui-fw/ and login with user and
-- password

機動して確認
sudo env JAVA_HOME=$JAVA_HOME /home/intalio/apache-tomcat-5.5.26/bin/catalina.sh run

ブラウザで接続してログイン

0 件のコメント: