[xwiki-users] xwiki and mysql5 fails

20 Sep 2007

      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

[xwiki-users] xwiki and mysql5 fails

ossi petz