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

Hallo I did read those pages. I promise! Really! I mean it! Initially it didnt work with the original Mysql dialect. Probably because i did not yet solve the security trouble i had at that moment. i cleaned the database and changed from Mysql5 to the Mysql Dialect and OH see! it works! :-)

yet it amazes me: mysql did change a lot of things from version 4.1 to 5.0 (join syntax, sql strict). i was kinda expecting more detailed requirements on the database versions. i do a lot of work and installations on php based software. they all distinguish mysql 4.0, 4.1 and 5.0 versions. compared to mediawiki the setup takes ages. well 2 hours compared to 20 minutes. no disaster - yet space for improvement :)

ready for testing now. thanks a lot! regards ossi Vincent Massol schrieb: > 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:

Hallooooooo Well i kinda reached the point of another stupid question: after a click around-round on http://wikihost:8080/xwiki/bin/admin/XWiki/XWikiPreferences and turning eny authentication option to yes i dont know the default administration accont. is there some default admin account (beside that superadmin)? or should i have done that BEFORE clicking around?

When i compare all the .war packaged software to what i am used from php based things (wiki, forums, cms) the most foolproof procedure is this: - upload the files (*.php, .war) to appfolder - connect to the page (http://host/appfolder) - when nothing was installed yet, the installer starts - it asks for the database connection parameters - it asks for an admin account (username, emails, password) - it then installs (creates db, tables, admin account, default files) - in xwiki case even an option to import the default pages from that xar could be added - done. a link to the startpage - now one can login with the admin account and start configuration - if i dont configure the application at this point no damage can be done by anonmyous users. so the default settings are normally a bit strict. but well a wiki may be more open than a cms. the goal should be to not have to manually edit config files, security params whatsoever. in bamboo (or was it teamcity? both java.war based installations) the location of the log file is configured during the installtion steps. everything crucial to the application. the side effect is: no one ever reads instructions. cause its straight forward and alwys the same. no stupid questions either ;-D in my opnion we java people should learn from the comfort those php guys came up with. thanks for listening :) regards ossi Vincent Massol schrieb: _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

Not sure what it has to do with PHP but I definitely agree about the installation wizard.

Hi ossi, On Sep 21, 2007, at 10:59 AM, ossi petz wrote: Doesn't superadmin work for you? (it's meant for these kinds of situations). If you have imported the default XAR for XE then yes there's an Admin user created. User: Admin, Password: admin ok, I understand and I agree. We need an Installation Wizard. I agree. Not sure what it has to do with PHP but I definitely agree about the installation wizard. That said for now we have something even easier with the standalone installation (the one that bundles everything) but I agree it doesn't let you choose your container and your DB so we need that installation wizard. I have created this jira issue: http://jira.xwiki.org/jira/browse/XWIKI-1761 Thanks for this feedback! -Vincent _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users