Re: [xwiki-users] xwiki and mysql5 fails
Hi ossi, On Sep 21, 2007, at 12:48 AM, ossi petz wrote: 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! :-) Glad you got it working! 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 :) Well there are 2 options when installing: 1) User want to try quickly or is not too technical: He uses the standalone installation. (the zip, installer jar or exe). There's nothing to do, it's all setup; No container, no db to setup. 2) User wants control on his container + DB and is technical: He picks the WAR AND reads the documentation. For 1), setup takes under a minute. For 2), I would say setup should take about 10 minutes max if you follow the documentation. Still I'd like to understand why it took longer for you and how mediawiki's setup is simpler so that we can improve the setup. Thanks -Vincent 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: ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] xwiki and mysql5 fails
Hi, ossi petz wrote: Hallooo 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? If you have installed the deafault xwiki XAR, there is the administrator user. Username Admin / password admin. 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: Hi ossi, On Sep 21, 2007, at 12:48 AM, ossi petz wrote: 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! :-) Glad you got it working! 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 :) Well there are 2 options when installing: 1) User want to try quickly or is not too technical: He uses the standalone installation. (the zip, installer jar or exe). There's nothing to do, it's all setup; No container, no db to setup. 2) User wants control on his container + DB and is technical: He picks the WAR AND reads the documentation. For 1), setup takes under a minute. For 2), I would say setup should take about 10 minutes max if you follow the documentation. Still I'd like to understand why it took longer for you and how mediawiki's setup is simpler so that we can improve the setup. Thanks -Vincent 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: ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] xwiki and mysql5 fails
Hi ossi, On Sep 21, 2007, at 10:59 AM, ossi petz wrote: Hallooo 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? 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 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. ok, I understand and I agree. We need an Installation Wizard. the side effect is: no one ever reads instructions. cause its straight forward and alwys the same. no stupid questions either ;-D I agree. in my opnion we java people should learn from the comfort those php guys came up with. 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 Vincent Massol schrieb: Hi ossi, On Sep 21, 2007, at 12:48 AM, ossi petz wrote: 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! :-) Glad you got it working! 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 :) Well there are 2 options when installing: 1) User want to try quickly or is not too technical: He uses the standalone installation. (the zip, installer jar or exe). There's nothing to do, it's all setup; No container, no db to setup. 2) User wants control on his container + DB and is technical: He picks the WAR AND reads the documentation. For 1), setup takes under a minute. For 2), I would say setup should take about 10 minutes max if you follow the documentation. Still I'd like to understand why it took longer for you and how mediawiki's setup is simpler so that we can improve the setup. Thanks -Vincent 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: ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] xwiki and mysql5 fails
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.urljdbc:mysql://localhost/xwiki?
useServerPrepStmts=false/property
property name=connection.usernamexwiki/property
property name=connection.passwordPASSWORD/property
property
name=connection.driver_classcom.mysql.jdbc.Driver/property
property name=dialectorg.hibernate.dialect.MySQL5Dialect/
property
property
name=connection.provider_classcom.xpn.xwiki.store.DBCPConnectionPro
vider/property
property name=connection.pool_size2/property
property name=statement_cache.size2/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
