Hi ossi, Why don't you check the Installation guide on xwiki.org? :) http://www.xwiki.org/xwiki/bin/view/AdminGuide/Installation You'll see that it has a section about MySQL: http://www.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMySQL The dialect there is different from the one you used. What's sure is that the issue is a Hibernate configuration issue. Hopefully, that should solve the trial and error issue :) Thanks -Vincent On Sep 20, 2007, at 7:35 PM, ossi petz wrote:
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.DBCPConnectionPro vider</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