Fresh install, MySQL trouble

[LK14]

Hi

I am pretty excited about finding a networked mindmapping tool, you've
undertaken work for a great tool, I commend you.

Can you advise on the following, I have a fresh install made in Tomcat
5.5, but WoW is getting stuck at initializing my MySQL database.

17.05.2007 23:54:12 org.apache.catalina.core.StandardContext
listenerStart
SEVERE: Exception sending context initialized event to listener
instance of class av.wow.scener.http.ServletListener
java.lang.RuntimeException: av.tob.ObjectBaseCreationException:
av.tob.engine.SwapException: java.io.FileNotFoundException: tob-
scripts/updateMySQL-2007-05-17-23.54.12.sql (No such file or
directory)
at
av.wow.scener.http.ServletListener.contextInitialized(ServletListener.java:
27)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:
3764)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:
4216)
at
org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:
1176)
at
org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:
542)
at
org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:
105)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
803)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:
188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:
210)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:
174)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:
525)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:
127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:
117)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:
108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:
151)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:
870)
at org.apache.coyote.http11.Http11BaseProtocol
$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:
665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:
528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:
81)
at org.apache.tomcat.util.threads.ThreadPool
$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:595)
Caused by: av.tob.ObjectBaseCreationException:
av.tob.engine.SwapException: java.io.FileNotFoundException: tob-
scripts/updateMySQL-2007-05-17-23.54.12.sql (No such file or
directory)
at av.tob.TheObjectBase.create(TheObjectBase.java:140)
at av.wow.scener.WebScenerApp.<init>(WebScenerApp.java:163)
at
av.wow.scener.http.WebScenerServlet.getScenerApp(WebScenerServlet.java:
154)
at
av.wow.scener.http.ServletListener.contextInitialized(ServletListener.java:
19)
... 22 more
Caused by: av.tob.engine.SwapException: java.io.FileNotFoundException:
tob-scripts/updateMySQL-2007-05-17-23.54.12.sql (No such file or
directory)
at av.tob.rdb.engine.EngineRDB.startup(EngineRDB.java:850)
at av.tob.TheObjectBase.<init>(TheObjectBase.java:278)
at av.tob.TheObjectBase.create(TheObjectBase.java:120)
... 25 more
Caused by: java.io.FileNotFoundException: tob-scripts/
updateMySQL-2007-05-17-23.54.12.sql (No such file or directory)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.<init>(FileOutputStream.java:179)
at java.io.FileOutputStream.<init>(FileOutputStream.java:131)
at java.io.PrintWriter.<init>(PrintWriter.java:252)
at av.tob.rdb.engine.EngineRDB.startup(EngineRDB.java:763)
... 27 more

And Tomcat is right, there really is no tob-scripts directory, nor any
sql-scripts in it.

I'm working with wow6war-05171423.zip

[LK14]

ok looks like this is some permission problem, i redirected the tob-
scripts to /tmp and now i get the following:

18.05.2007 0:59:35 org.apache.catalina.core.StandardContext

listenerStart
SEVERE: Exception sending context initialized event to listener
instance of class av.wow.scener.http.ServletListener
java.lang.RuntimeException: av.tob.ObjectBaseCreationException:
av.tob.engine.SwapException:

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: BLOB/TEXT column
'class' can't have a default value

at
av.wow.scener.http.ServletListener.contextInitialized(ServletListener.java:
27)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:
3764)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:
4216)
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:
920)
at
org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:
883)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at
org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
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: av.tob.ObjectBaseCreationException:
av.tob.engine.SwapException:
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: BLOB/TEXT column
'class' can't have a default value

at av.tob.TheObjectBase.create(TheObjectBase.java:140)
at av.wow.scener.WebScenerApp.<init>(WebScenerApp.java:163)
at
av.wow.scener.http.WebScenerServlet.getScenerApp(WebScenerServlet.java:
154)
at
av.wow.scener.http.ServletListener.contextInitialized(ServletListener.java:
19)

... 24 more
Caused by: av.tob.engine.SwapException:
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: BLOB/TEXT column
'class' can't have a default value
at av.tob.rdb.engine.EngineRDB.startup(EngineRDB.java:846)

at av.tob.TheObjectBase.<init>(TheObjectBase.java:278)
at av.tob.TheObjectBase.create(TheObjectBase.java:120)

... 27 more
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: BLOB/
TEXT column 'class' can't have a default value
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:
936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3170)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1316)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1235)
at av.tob.rdb.engine.EngineRDB.startup(EngineRDB.java:800)
... 29 more

[Compl Yue Still]

Hello,

This seems due to difference between MySQL versions, I used to test
WoW on MySQL 4.1.16, and havn't tried 3.x or 5.x versions.

Sorry for the lack of test, this is just a young project and only
myself is working on it so far.

So please let me know your MySQL version and I'm going for a fix.

Regards,
Compl

> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppo­rt.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(DelegatingMethodAccessorImp­l.java:

[Compl Yue Still]

Hi,

The latest WoW 6 b05192321 has the bundled TOB 6 upgraded to b0519,
which has a new MySQL5 swap engine included. That'll work with MySQL 5
properly.

>From this version on, WoW will be tested mainly against MySQL 5.0

Please upgrade & check.

Cheers,
Compl

> > ... 29 more- Hide quoted text -
>
> - Show quoted text -