[xwiki-users] xwiki and mysql5 fails

Hallo i kinda stumbled over xwiki on wikimatrix.org and tried to test it :) my target env: - linux debian 4.0 - tomcat 5.5 - sun java 1.5 - mysql 5.0 i copied to .war file into webapps, added to TOMCAT/conf/catalina.policy the lines: // These permissions apply to xwiki grant codeBase "file:${catalina.home}/webapps/xwiki/-" { permission java.security.AllPermission; }; and started tomcat with: startup.sh -security after some try and error i figured out the mysql connection settings: <property name="connection.url">jdbc:mysql://localhost/xwiki?useServerPrepStmts=false</property> <property name="connection.username">xwiki</property> <property name="connection.password">PASSWORD</property> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="dialect">org.hibernate.dialect.MySQL5Dialect</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="connection.pool_size">2</property> <property name="statement_cache.size">2</property> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> i am using org.hibernate.dialect.MySQL5Dialect to access the database. when i open xwiki some tables are created: feeds_aggregatorgroup feeds_aggregatorurl feeds_aggregatorurlgroups feeds_feedentry feeds_feedentrytags feeds_keyword xwikiattachment xwikiattachment_archive xwikiattachment_content xwikibooleanclasses but thats it. a stacktrace then welcome me. the xwiki.log shows the lines below (the sql syntax or table content seems wrong?). is there some known issue with mysql5 i missed? (Server Version: 5.0.32-Debian_7etch1-log) Or can this be fixed somewhere? Or do i use the wrong dialect? Thanks for any hints :) regards ossi xwiki.log: ========== 19:24:15,997 [http-8080-Processor25] ERROR store.XWikiHibernateBaseStore - Failed updating schema: Column length too big for column 'XWO_CUSTOM_MAPPING' (max = 21845); use BLOB or TEXT instead 19:24:16,034 [http-8080-Processor25] WARN util.JDBCExceptionReporter - SQL Error: 1146, SQLState: 42S02 19:24:16,036 [http-8080-Processor25] ERROR util.JDBCExceptionReporter - Table 'xwiki.xwikidoc' doesn't exist 19:24:16,041 [http-8080-Processor25] WARN util.JDBCExceptionReporter - SQL Error: 1146, SQLState: 42S02 19:24:16,042 [http-8080-Processor25] ERROR util.JDBCExceptionReporter - Table 'xwiki.xwikidoc' doesn't exist 19:24:16,046 [http-8080-Processor25] WARN util.JDBCExceptionReporter - SQL Error: 1146, SQLState: 42S02 19:24:16,048 [http-8080-Processor25] ERROR util.JDBCExceptionReporter - Table 'xwiki.xwikidoc' doesn't exist 19:24:16,052 [http-8080-Processor25] WARN util.JDBCExceptionReporter - SQL Error: 1146, SQLState: 42S02 19:24:16,054 [http-8080-Processor25] ERROR util.JDBCExceptionReporter - Table 'xwiki.xwikidoc' doesn't exist 19:24:16,080 [http-8080-Processor25] WARN util.JDBCExceptionReporter - SQL Error: 1146, SQLState: 42S02 19:24:16,082 [http-8080-Processor25] ERROR util.JDBCExceptionReporter - Table 'xwiki.xwikidoc' doesn't exist 19:24:16,108 [http-8080-Processor25] WARN util.JDBCExceptionReporter - SQL Error: 1146, SQLState: 42S02 19:24:16,110 [http-8080-Processor25] ERROR util.JDBCExceptionReporter - Table 'xwiki.xwikidoc' doesn't exist 19:24:17,116 [http-8080-Processor25] ERROR store.XWikiHibernateBaseStore - Failed updating schema: Column length too big for column 'XWO_CUSTOM_MAPPING' (max = 2 1845); use BLOB or TEXT instead 19:24:17,119 [http-8080-Processor25] WARN util.JDBCExceptionReporter - SQL Error: 1146, SQLState: 42S02 19:24:17,120 [http-8080-Processor25] ERROR util.JDBCExceptionReporter - Table 'xwiki.xwikidoc' doesn't exist 19:24:17,153 [http-8080-Processor25] WARN util.JDBCExceptionReporter - SQL Error: 1146, SQLState: 42S02 19:24:17,155 [http-8080-Processor25] ERROR util.JDBCExceptionReporter - Table 'xwiki.xwikidoc' doesn't exist 19:24:17,158 [http-8080-Processor25] WARN util.JDBCExceptionReporter - SQL Error: 1146, SQLState: 42S02 19:24:17,160 [http-8080-Processor25] ERROR util.JDBCExceptionReporter - Table 'xwiki.xwikidoc' doesn't exist 19:24:17,166 [http-8080-Processor25] WARN util.JDBCExceptionReporter - SQL Error: 1146, SQLState: 42S02 19:24:17,168 [http-8080-Processor25] ERROR util.JDBCExceptionReporter - Table 'xwiki.xwikidoc' doesn't exist 19:24:17,171 [http-8080-Processor25] WARN util.JDBCExceptionReporter - SQL Error: 1146, SQLState: 42S02 19:24:17,172 [http-8080-Processor25] ERROR util.JDBCExceptionReporter - Table 'xwiki.xwikidoc' doesn't exist 19:24:17,392 [http-8080-Processor25] WARN util.JDBCExceptionReporter - SQL Error: 1146, SQLState: 42S02 19:24:17,394 [http-8080-Processor25] ERROR util.JDBCExceptionReporter - Table 'xwiki.xwikidoc' doesn't exist 19:24:17,407 [http-8080-Processor25] WARN action.RequestProcessor - Unhandled Exception thrown: class com.xpn.xwiki.XWikiException 19:24:17,412 [http-8080-Processor25] ERROR [/xwiki].[action] - Servlet.service() for servlet action threw exception com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3202 in 3: Exception while reading document XWiki.XWikiPreferences