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

_______________________________________________
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Reply via email to