[xwiki-users] xwiki and mysql5 fails
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
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
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:
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:
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:
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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
Hi, 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?
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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Hi ossi, On Sep 21, 2007, at 10:59 AM, 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?
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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
hallo well i only read the 'optional' thing on the xar download ;p so no, i did not install it - i just 'closed' anonymous usage. i will give mr superadmin a start :) an installation wizard would be cool! :)
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.
i only compare the two worlds. xwiki is not the only 'messy' installation based on java.war. its some common standard to let everyone configure the same things. the standalone installers are great for evaluation! but once chosen, there will be some productive database, app server already. a standalone installation would mean more maintainance. actually a lot of php based software worked the same way. there was always a conig.php file one needed to edit. today the well known applications come with wizards. and it is an unbeatable comfort. well you plan to do one, so enough arguments where given :) thanks for listening! regards ossi Vincent Massol schrieb:
Hi ossi,
On Sep 21, 2007, at 10:59 AM, 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?
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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
participants (3)
-
ossi petz -
Vincent Massol -
Vitantonio Messa