20 Sep
2007
20 Sep
'07
7:35 p.m.
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
20 Sep
20 Sep
9:43 p.m.
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
21 Sep
21 Sep
12:48 a.m.
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:
8:59 a.m.
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:
10:59 a.m.
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
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
11:24 a.m.
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:
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users 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(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
11:28 a.m.
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:
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users 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(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
22 Sep
22 Sep
12:32 a.m.
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! :)
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:
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. 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:
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
Hi ossi,
On Sep 21, 2007, at 12:48 AM, ossi petz wrote:
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users 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(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
6302
days inactive
6303
days old
7 comments
3 participants
participants (3)
-
ossi petz -
Vincent Massol -
Vitantonio Messa