2 Aug
2011
2 Aug
'11
7:53 p.m.
I've been battling with partial documentations of
different install configurations on different versions
of systems and trying to collate them. I have probably
done all sorts of wrong things, but perhaps some one
here can set me straight with a few words.
I am remotely installing to a Natty server (a KVM VM)
via an ssh connection.
I installed a bunch of packages,among which are:
apache2, tomcat6, tomcat6-examples, tomcat6-user,
mysql-server, mysql-client
tomcat6 is working and I can get to it by the wiki.myhost.mydomain
DNS name.
I download the current xwiki.war using wget to
/var/lib/tomcat6/webapps/xwiki.war and tomcat6 seemed to have
automatically unpacked it.
The version was xwiki-enterprise-installer-generic-3.1-standard.jar
I downloaded the latest version of the mysql connector.
The version was mysql-connector-java-5.1.17.jar.
What I then discovered was that there was a META-INF directory
but no WEB-INF as described in the various install instructions
I read.
For the hell of it I then installed the openjdk-6-jdk package
which of course loaded a *lot* of other packages. I then tried
jar xf mysql-connector-java-5.1.17.jar
in the /var/lib/tomcat6/webapps/xwiki directory and that gave me
a META-INF and a couple other directories.
There is no hibernate.cfg.xml, described in all the install
info I have read, anywhere to be found.
I am certain I have at some point gone off the narrow twisty
path to success but have no idea where.
Advice would be much appreciated.
Dale Amon
2 Aug
2 Aug
8:05 p.m.
Hello Dale,
About your installation, it's easier to tell you how to install it properly,
than trying to understand what's in wrong here.
What you have to do, after cleaning your xwiki installation, is:
1. Unzip the war package in tomcat webapps, you will have
tomcat6/webapps/xwiki/<content_of_.war>
2. Move mysql connector in tomcat6/webapps/xwiki/WEB-INF/lib/
3. Configure hibernate.cfg.xml, which is in WEB-INF directory.
Then use the tomcat stratup script in tomcat6/bin to start the wiki (could
be tomcat.sh). You should access it with
http://wiki.myhost.mydomain:8080/xwiki
Maybe tomcat will not found your java path, then you can modify the tomcat
startup script to add JAVA_HOME variable, pointing to you jdk directory (a
lot of how to show how to do this).
I hope you will be able to run it properly.
Regards,
Guillaume Fenollar
2011/8/2 Dale Amon <amon(a)vnl.com>
I've been battling with partial documentations of
different install configurations on different versions
of systems and trying to collate them. I have probably
done all sorts of wrong things, but perhaps some one
here can set me straight with a few words.
I am remotely installing to a Natty server (a KVM VM)
via an ssh connection.
I installed a bunch of packages,among which are:
apache2, tomcat6, tomcat6-examples, tomcat6-user,
mysql-server, mysql-client
tomcat6 is working and I can get to it by the wiki.myhost.mydomain
DNS name.
I download the current xwiki.war using wget to
/var/lib/tomcat6/webapps/xwiki.war and tomcat6 seemed to have
automatically unpacked it.
The version was xwiki-enterprise-installer-generic-3.1-standard.jar
I downloaded the latest version of the mysql connector.
The version was mysql-connector-java-5.1.17.jar.
What I then discovered was that there was a META-INF directory
but no WEB-INF as described in the various install instructions
I read.
For the hell of it I then installed the openjdk-6-jdk package
which of course loaded a *lot* of other packages. I then tried
jar xf mysql-connector-java-5.1.17.jar
in the /var/lib/tomcat6/webapps/xwiki directory and that gave me
a META-INF and a couple other directories.
There is no hibernate.cfg.xml, described in all the install
info I have read, anywhere to be found.
I am certain I have at some point gone off the narrow twisty
path to success but have no idea where.
Advice would be much appreciated.
Dale Amon
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
--
Guillaume Fenollar
XWiki SysAdmin
8:10 p.m.
Hello Dale,
You are trying to install xwiki in a servlet container, I believe you should
be downloading xwiki-enterprise-web-3.1.war[1] rather than the installer
jar. The installation instructions for a war are at
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation#HInstallin…
Regards,
Bindul
[1] http://forge.ow2.org/project/download.php?group_id=170&file_id=16846
On Tue, Aug 2, 2011 at 11:53, Dale Amon <amon(a)vnl.com> wrote:
I've been battling with partial documentations of
different install configurations on different versions
of systems and trying to collate them. I have probably
done all sorts of wrong things, but perhaps some one
here can set me straight with a few words.
I am remotely installing to a Natty server (a KVM VM)
via an ssh connection.
I installed a bunch of packages,among which are:
apache2, tomcat6, tomcat6-examples, tomcat6-user,
mysql-server, mysql-client
tomcat6 is working and I can get to it by the wiki.myhost.mydomain
DNS name.
I download the current xwiki.war using wget to
/var/lib/tomcat6/webapps/xwiki.war and tomcat6 seemed to have
automatically unpacked it.
The version was xwiki-enterprise-installer-generic-3.1-standard.jar
I downloaded the latest version of the mysql connector.
The version was mysql-connector-java-5.1.17.jar.
What I then discovered was that there was a META-INF directory
but no WEB-INF as described in the various install instructions
I read.
For the hell of it I then installed the openjdk-6-jdk package
which of course loaded a *lot* of other packages. I then tried
jar xf mysql-connector-java-5.1.17.jar
in the /var/lib/tomcat6/webapps/xwiki directory and that gave me
a META-INF and a couple other directories.
There is no hibernate.cfg.xml, described in all the install
info I have read, anywhere to be found.
I am certain I have at some point gone off the narrow twisty
path to success but have no idea where.
Advice would be much appreciated.
Dale Amon
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
9:51 p.m.
On Tue, Aug 02, 2011 at 08:05:28PM +0200, Guillaume Fenollar wrote:
Hello Dale,
About your installation, it's easier to tell you how to install it properly,
than trying to understand what's in wrong here.
What you have to do, after cleaning your xwiki installation, is:
1. Unzip the war package in tomcat webapps, you will have
tomcat6/webapps/xwiki/<content_of_.war>
2. Move mysql connector in tomcat6/webapps/xwiki/WEB-INF/lib/
3. Configure hibernate.cfg.xml, which is in WEB-INF directory.
Then use the tomcat stratup script in tomcat6/bin to start the wiki (could
be tomcat.sh). You should access it with
http://wiki.myhost.mydomain:8080/xwiki
Maybe tomcat will not found your java path, then you can modify the tomcat
startup script to add JAVA_HOME variable, pointing to you jdk directory (a
lot of how to show how to do this).
I hope you will be able to run it properly.
I think I am getting close. The various instructions I had
found just sent me on a merry chase and following your
instructions solved most of the problems.
Before I go the next step... For the other set up instructions
I had set up mysql DB. I notice there is a built in set up
mentioned in the hibernate.cfg.xml file. Is there any good
reason to *not* use the default? Would I gain or lose anything
by using the default vs going with mysql (Other than that I
am fairly familiar with msyql).
10:22 p.m.
If you are talking about the default database, then it's HSQLDB. You can
compare the two methods (hsqldb vs mysql) to make your own opinion, but I
advise you to use mysql for production environment.
If you choose to use mysql, don't forget to download the mysql-java
connector and to move it into WEB-INF/lib directory in xwiki.
Guillaume
2011/8/2 Dale Amon <amon(a)vnl.com>
On Tue, Aug 02, 2011 at 08:05:28PM +0200, Guillaume
Fenollar wrote:
--
Guillaume Fenollar
XWiki SysAdmin
Hello Dale,
About your installation, it's easier to tell you how to install it
properly,
than trying to understand what's in wrong
here.
What you have to do, after cleaning your xwiki installation, is:
1. Unzip the war package in tomcat webapps, you will have
tomcat6/webapps/xwiki/<content_of_.war>
2. Move mysql connector in tomcat6/webapps/xwiki/WEB-INF/lib/
3. Configure hibernate.cfg.xml, which is in WEB-INF directory.
Then use the tomcat stratup script in tomcat6/bin to start the wiki
(could
be tomcat.sh). You should access it with
http://wiki.myhost.mydomain:8080/xwiki
Maybe tomcat will not found your java path, then you can modify the
tomcat
startup script to add JAVA_HOME variable,
pointing to you jdk directory
(a
lot of how to show how to do this).
I hope you will be able to run it properly.
I think I am getting close. The various instructions I had
found just sent me on a merry chase and following your
instructions solved most of the problems.
Before I go the next step... For the other set up instructions
I had set up mysql DB. I notice there is a built in set up
mentioned in the hibernate.cfg.xml file. Is there any good
reason to *not* use the default? Would I gain or lose anything
by using the default vs going with mysql (Other than that I
am fairly familiar with msyql).
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
10:36 p.m.
On Tue, Aug 02, 2011 at 10:22:10PM +0200, Guillaume Fenollar wrote:
If you are talking about the default database, then
it's HSQLDB. You can
compare the two methods (hsqldb vs mysql) to make your own opinion, but I
advise you to use mysql for production environment.
If you choose to use mysql, don't forget to download the mysql-java
connector and to move it into WEB-INF/lib directory in xwiki.
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling
this request.
exception
javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error number 3 in 0: Could
not initialize main XWiki context
Wrapped Exception: Error number 3001 in 3: Cannot load class
com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from param
xwiki.store.migration.manager.class
Wrapped Exception: Error number 0 in 3: Exception while hibernate execute
Wrapped Exception: Could not create a DBCP pool. There is an error in the hibernate
configuration file, please review it.
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:129)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:152)
com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68)
org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:218)
org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)
root cause
com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki
context
Wrapped Exception: Error number 3001 in 3: Cannot load class
com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from param
xwiki.store.migration.manager.class
Wrapped Exception: Error number 0 in 3: Exception while hibernate execute
Wrapped Exception: Could not create a DBCP pool. There is an error in the hibernate
configuration file, please review it.
com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:424)
com.xpn.xwiki.XWiki.getXWiki(XWiki.java:493)
com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:135)
com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:115)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:129)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:152)
com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68)
org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:218)
org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.28
logs.
Apache Tomcat/6.0.28
I must be making progress... I did not get any of these
before, so at least something is running now!
I suspect that if I knew what the "Main XWiki context" was
I could go even further!
10:38 p.m.
On Aug 2, 2011, at 10:36 PM, Dale Amon wrote:
On Tue, Aug 02, 2011 at 10:22:10PM +0200, Guillaume
Fenollar wrote:
[snip]
If you are talking about the default database,
then it's HSQLDB. You can
compare the two methods (hsqldb vs mysql) to make your own opinion, but I
advise you to use mysql for production environment.
If you choose to use mysql, don't forget to download the mysql-java
connector and to move it into WEB-INF/lib directory in xwiki.
type Exception report Wrapped Exception: Could not create a DBCP pool. There
is an error in the hibernate configuration file, please review it.
This means your hibernate.cfg.xml file is not correctly configured.
[snip]
Thanks
-Vincent
11:49 p.m.
On Tue, Aug 02, 2011 at 10:38:37PM +0200, Vincent Massol wrote:
On Aug 2, 2011, at 10:36 PM, Dale Amon wrote:
I've got the default file with minor changes:
* I commented out the default db set up
* I enabled the mysql section
* I played with various user names and at the
moment am using mysql root.
<!-- Configuration for the default database.
Comment out this section and uncomment other sections below if you want to use
another database.
Note that the database tables will be created automatically if they don't
already exist.
<property
name="connection.url">jdbc:hsqldb:file:database/xwiki_db;shutdown=true</property>
<property name="connection.username">sa</property>
<property name="connection.password"></property>
<property
name="connection.driver_class">org.hsqldb.jdbcDriver</property>
<property
name="dialect">org.hibernate.dialect.HSQLDialect</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"/>
<mapping resource="activitystream.hbm.xml"/>
-->
<!-- MySQL configuration.
Uncomment if you want to use MySQL and comment out other database
configurations.
We need to set the sql_mode to a less strict value, see XWIKI-1945
-->
<property
name="connection.url">jdbc:mysql://localhost/xwiki?useServerPrepStmts=false&useUnicode=true&characterEncoding=UTF-8&sessionVariables=sql_mode='$
<property name="connection.username">root</property>
<property name="connection.password">XXXXXXX</property>
<property
name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property
name="dialect">org.hibernate.dialect.MySQLDialect</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"/>
<mapping resource="activitystream.hbm.xml"/>
Is this tomcat log line telling me there is a bad path somewhere in
the default set up?
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
On Tue, Aug 02, 2011 at 10:22:10PM +0200,
Guillaume Fenollar wrote:
[snip]
If you are talking about the default database,
then it's HSQLDB. You can
compare the two methods (hsqldb vs mysql) to make your own opinion, but I
advise you to use mysql for production environment.
If you choose to use mysql, don't forget to download the mysql-java
connector and to move it into WEB-INF/lib directory in xwiki.
type Exception report Wrapped Exception: Could not create a DBCP pool.
There is an error in the hibernate configuration file, please review it.
This means your hibernate.cfg.xml file is not correctly configured.
3 Aug
3 Aug
12:34 a.m.
I think the error is due to mysql-java connector jar file.
Please make sure that a recent version of this connector is in WEB-INF/lib
directory of XWiki, and restart tomcat . You don't talk about this .jar file
in previous mails but it's a crucial element.
Guillaume
2011/8/2 Dale Amon <amon(a)vnl.com>
On Tue, Aug 02, 2011 at 10:38:37PM +0200, Vincent
Massol wrote:
[snip]
> Wrapped Exception: Could not create a DBCP pool. There is an error in the
hibernate configuration file, please review it.
--
Guillaume Fenollar
XWiki SysAdmin
On Aug 2, 2011, at 10:36 PM, Dale Amon wrote:
> On Tue, Aug 02, 2011 at 10:22:10PM +0200, Guillaume Fenollar wrote:
>> If you are talking about the default database, then it's HSQLDB. You
can
>> compare the two methods (hsqldb vs
mysql) to make your own opinion,
but I
advise you to use mysql for production environment.
If you choose to use mysql, don't forget to download the mysql-java
connector and to move it into WEB-INF/lib directory in xwiki.
type Exception report
This means your hibernate.cfg.xml file is not correctly configured.
I've got the default file with minor changes:
* I commented out the default db set up
* I enabled the mysql section
* I played with various user names and at the
moment am using mysql root.
<!-- Configuration for the default database.
Comment out this section and uncomment other sections below if you
want to use another database.
Note that the database tables will be created automatically if they
don't already exist.
<property
name="connection.url">jdbc:hsqldb:file:database/xwiki_db;shutdown=true</property>
<property name="connection.username">sa</property>
<property name="connection.password"></property>
<property
name="connection.driver_class">org.hsqldb.jdbcDriver</property>
<property
name="dialect">org.hibernate.dialect.HSQLDialect</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"/>
<mapping resource="activitystream.hbm.xml"/>
-->
<!-- MySQL configuration.
Uncomment if you want to use MySQL and comment out other database
configurations.
We need to set the sql_mode to a less strict value, see XWIKI-1945
-->
<property
name="connection.url">jdbc:mysql://localhost/xwiki?useServerPrepStmts=false&useUnicode=true&characterEncoding=UTF-8&sessionVariables=sql_mode='$
<property name="connection.username">root</property>
<property name="connection.password">XXXXXXX</property>
<property
name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property
name="dialect">org.hibernate.dialect.MySQLDialect</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"/>
<mapping resource="activitystream.hbm.xml"/>
Is this tomcat log line telling me there is a bad path somewhere in
the default set up?
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
1:03 a.m.
On Wed, Aug 03, 2011 at 12:34:17AM +0200, Guillaume Fenollar wrote:
I think the error is due to mysql-java connector jar
file.
Please make sure that a recent version of this connector is in WEB-INF/lib
directory of XWiki, and restart tomcat . You don't talk about this .jar file
in previous mails but it's a crucial element.
Guillaume
# ls -l WEB-INF/lib/mysql-connector-java-5.1.17.jar
-rw-r--r-- 1 root root 446158 2011-07-30 12:02
WEB-INF/lib/mysql-connector-java-5.1.17.jar
This is what I've got. Is it the correct version?
10:05 a.m.
On 08/02/2011 05:49 PM, Dale Amon wrote:
On Tue, Aug 02, 2011 at 10:38:37PM +0200, Vincent
Massol wrote:
Can you try to use this line instead?
<property
name="connection.url">jdbc:mysql://localhost/xwiki?useServerPrepStmts=false&useUnicode=true&characterEncoding=UTF-8</property>
(the same as yours, but without the sessionVariables parameter, which
isn't compatible with the latest version of the connector jar (a bug in
the connector).
On Aug 2, 2011, at 10:36 PM, Dale Amon wrote:
I've got the default file with minor changes:
* I commented out the default db set up
* I enabled the mysql section
* I played with various user names and at the
moment am using mysql root.
<!-- Configuration for the default database.
Comment out this section and uncomment other sections below if you want to use
another database.
Note that the database tables will be created automatically if they don't
already exist.
<property
name="connection.url">jdbc:hsqldb:file:database/xwiki_db;shutdown=true</property>
<property name="connection.username">sa</property>
<property name="connection.password"></property>
<property
name="connection.driver_class">org.hsqldb.jdbcDriver</property>
<property
name="dialect">org.hibernate.dialect.HSQLDialect</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"/>
<mapping resource="activitystream.hbm.xml"/>
-->
<!-- MySQL configuration.
Uncomment if you want to use MySQL and comment out other database
configurations.
We need to set the sql_mode to a less strict value, see XWIKI-1945
-->
<property
name="connection.url">jdbc:mysql://localhost/xwiki?useServerPrepStmts=false&useUnicode=true&characterEncoding=UTF-8&sessionVariables=sql_mode='$
On Tue, Aug 02, 2011 at 10:22:10PM +0200,
Guillaume Fenollar wrote:
[snip]
If you are talking about the default database,
then it's HSQLDB. You can
compare the two methods (hsqldb vs mysql) to make your own opinion, but I
advise you to use mysql for production environment.
If you choose to use mysql, don't forget to download the mysql-java
connector and to move it into WEB-INF/lib directory in xwiki.
type Exception report Wrapped Exception: Could not create a DBCP pool.
There is an error in the hibernate configuration file, please review it.
This means your hibernate.cfg.xml file is not correctly configured. <property
name="connection.username">root</property>
<property name="connection.password">XXXXXXX</property>
<property
name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property
name="dialect">org.hibernate.dialect.MySQLDialect</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"/>
<mapping resource="activitystream.hbm.xml"/>
Is this tomcat log line telling me there is a bad path somewhere in
the default set up?
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
--
Sergiu Dumitriu
http://purl.org/net/sergiu/
3:26 p.m.
On Wed, Aug 03, 2011 at 04:05:26AM -0400, Sergiu Dumitriu wrote:
Can you try to use this line instead?
<property
name="connection.url">jdbc:mysql://localhost/xwiki?useServerPrepStmts=false&useUnicode=true&characterEncoding=UTF-8</property>
(the same as yours, but without the sessionVariables parameter, which
isn't compatible with the latest version of the connector jar (a bug in
the connector).
It did change the error... but still says something is invalid in the
hibernate config:
----------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling
this request.
exception
javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error number 3 in 0: Could
not initialize main XWiki context
Wrapped Exception: Error number 3001 in 3: Cannot load class
com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from param
xwiki.store.migration.manager.class
Wrapped Exception: Error number 0 in 3: Exception while hibernate execute
Wrapped Exception: invalid configuration
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:129)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:152)
com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68)
org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:218)
org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)
root cause
com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki
context
Wrapped Exception: Error number 3001 in 3: Cannot load class
com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from param
xwiki.store.migration.manager.class
Wrapped Exception: Error number 0 in 3: Exception while hibernate execute
Wrapped Exception: invalid configuration
com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:424)
com.xpn.xwiki.XWiki.getXWiki(XWiki.java:493)
com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:135)
com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:115)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:129)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:152)
com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68)
org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:218)
org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.28
logs.
-------------------------------------------------------------------------
I find this in the logs:
-------------------------------------------------------------------------
Wrapped Exception:
org.xml.sax.SAXParseException; lineNumber: 130; columnNumber: 21; The content of element
type "session-factory" must match
"(property*,mapping*,(class-cache|collection-cache)*,event*,listener*)".
-------------------------------------------------------------------------
3:34 p.m.
On Aug 3, 2011, at 3:26 PM, Dale Amon wrote:
On Wed, Aug 03, 2011 at 04:05:26AM -0400, Sergiu
Dumitriu wrote:
This means the order of the xml elements is wrong in the file. You can check its DTD or
its schema.
Thanks
-Vincent
Can you try to use this line instead?
<property
name="connection.url">jdbc:mysql://localhost/xwiki?useServerPrepStmts=false&useUnicode=true&characterEncoding=UTF-8</property>
(the same as yours, but without the sessionVariables parameter, which
isn't compatible with the latest version of the connector jar (a bug in
the connector).
It did change the error... but still says something is invalid in the
hibernate config:
----------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling
this request.
exception
javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error number 3 in 0: Could
not initialize main XWiki context
Wrapped Exception: Error number 3001 in 3: Cannot load class
com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from param
xwiki.store.migration.manager.class
Wrapped Exception: Error number 0 in 3: Exception while hibernate execute
Wrapped Exception: invalid configuration
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:129)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:152)
com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68)
org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:218)
org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)
root cause
com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki
context
Wrapped Exception: Error number 3001 in 3: Cannot load class
com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from param
xwiki.store.migration.manager.class
Wrapped Exception: Error number 0 in 3: Exception while hibernate execute
Wrapped Exception: invalid configuration
com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:424)
com.xpn.xwiki.XWiki.getXWiki(XWiki.java:493)
com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:135)
com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:115)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:129)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:152)
com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68)
org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:218)
org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.28
logs.
-------------------------------------------------------------------------
I find this in the logs:
-------------------------------------------------------------------------
Wrapped Exception:
org.xml.sax.SAXParseException; lineNumber: 130; columnNumber: 21; The content of element
type "session-factory" must match
"(property*,mapping*,(class-cache|collection-cache)*,event*,listener*)".
4:28 p.m.
On Wed, Aug 03, 2011 at 03:34:36PM +0200, Vincent Massol wrote:
This means the order of the xml elements is wrong in
the file. You can check its DTD or its schema.
Thanks
-Vincent
Sigh. That was my error as it turns out. I put in a
comment in the wrong format when I made the change
Dimitriu suggested. Fixed that and now I am back to
the error I had before. So it looks like his change
did not affect this problem, although perhaps it
will avoid other issues.
Just so everyone knows what I am working from, I have
stripped all of the commented sections out of the
default file so it will fit on a page. The changes from
default are:
* I switched to mysql and set the user to mysql root
* I included Dmitriu's suggested line change
---------------------------------------------------------
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration
DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="show_sql">false</property>
<property name="use_outer_join">true</property>
<property name="dbcp.defaultAutoCommit">false</property>
<property name="dbcp.maxActive">50</property>
<property name="dbcp.maxIdle">5</property>
<property name="dbcp.maxWait">30000</property>
<property name="dbcp.whenExhaustedAction">1</property>
<property name="dbcp.ps.whenExhaustedAction">1</property>
<property name="dbcp.ps.maxActive">20</property>
<property name="dbcp.ps.maxWait">120000</property>
<property name="dbcp.ps.maxIdle">20</property>
<property name="jdbc.use_scrollable_resultset">false</property>
<property
name="connection.url">jdbc:mysql://localhost/xwiki?useServerPrepStmts=false&useUnicode=true&characterEncoding=UTF-8</property>
<property name="connection.username">root</property>
<property name="connection.password">XXXXXX</property>
<property
name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property
name="dialect">org.hibernate.dialect.MySQLDialect</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"/>
<mapping resource="activitystream.hbm.xml"/>
</session-factory>
</hibernate-configuration>
---------------------------------------------------------
Error messages state there is still a problem:
---------------------------------------------------------
javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error number 3 in 0: Could
not initialize main XWiki context
Wrapped Exception: Error number 3001 in 3: Cannot load class
com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from param
xwiki.store.migration.manager.class
Wrapped Exception: Error number 0 in 3: Exception while hibernate execute
Wrapped Exception: Could not create a DBCP pool. There is an error in the hibernate
configuration file, please review it.
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:129)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:152)
com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68)
org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:218)
org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)
---------------------------------------------------------
Is the error strictly a syntax error or could there be
something wrong when connecting to the mysql db that
I could check out?
I can manually login to mysql as root; I have created
an xwiki database but no tables; I created an xwiki
user but am using root for testing to eliminate privs
as a variable in my prolems.
7:28 p.m.
Would it be worthwhile for me to use the newest
release of XWiki that was just announced? Or even
to use the developmental branch instead? Is there
a chance either of these might fix (or at least
make obvious) my problem?
4 Aug
4 Aug
4:44 p.m.
Hi Dale,
I had a similar error 'Could not create a DBCP pool' when I first installed
XEM on a Suse linux box, while all the rest seemed OK.
So I tried to look inside Tomcat installation: open .../conf/server.xml and
go to the line that starts with
<Connector port="8080" protocol ="HTTP/1.1" .....
Comment all this section.
Immediately after starts a section that is commented by default that starts
witn the line
<Connector executor="tomcatThreadPool"
Make this section live and add as suggested somewhere in the tutorial the
line
URIEncoding="UTF-8"
Restart everything.
It worked for me, even if I don't really know why (I am not a programmer or
Java/Tomcat guru).
Hope that can help you, too
Angelo
--
View this message in context:
http://xwiki.475771.n2.nabble.com/Installing-XWiki-on-Ubuntu-Natty-tp664582…
Sent from the XWiki- Users mailing list archive at Nabble.com.
5:38 p.m.
On Thu, Aug 04, 2011 at 07:44:41AM -0700, AngeloG wrote:
Hi Dale,
I had a similar error 'Could not create a DBCP pool' when I first installed
XEM on a Suse linux box, while all the rest seemed OK.
So I tried to look inside Tomcat installation: open .../conf/server.xml and
go to the line that starts with
<Connector port="8080" protocol ="HTTP/1.1" .....
Comment all this section.
Immediately after starts a section that is commented by default that starts
witn the line
<Connector executor="tomcatThreadPool"
Make this section live and add as suggested somewhere in the tutorial the
line
URIEncoding="UTF-8"
Restart everything.
It worked for me, even if I don't really know why (I am not a programmer or
Java/Tomcat guru).
Hope that can help you, too
Angelo
I did the following:
<!-- DMA20110804 Commented out as suggested by AngeloG-->
<!-- A "Connector" represents an endpoint by which requests are received
and responses are returned. Documentation at :
Java HTTP Connector: /docs/config/http.html (blocking & non-blocking)
Java AJP Connector: /docs/config/ajp.html
APR (HTTP/AJP) Connector: /docs/apr.html
Define a non-SSL HTTP/1.1 Connector on port 8080
<Connector port="8080" protocol="HTTP/1.1"
connectionTimeout="20000"
URIEncoding="UTF-8"
redirectPort="8443" />
-->
<!-- A "Connector" using the shared thread pool-->
<!-- DMA20110804 Uncommented and added URIEncoding as suggested by AngeloG-->
<Connector executor="tomcatThreadPool"
port="8080" protocol="HTTP/1.1"
connectionTimeout="20000"
URIEncoding="UTF-8"
redirectPort="8443" />
Rebooted the VM even, But I still get:
javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error number 3 in 0: Could
not initialize main XWiki context
Wrapped Exception: Error number 3001 in 3: Cannot load class
com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from param
xwiki.store.migration.manager.class
Wrapped Exception: Error number 0 in 3: Exception while hibernate execute
Wrapped Exception: Could not create a DBCP pool. There is an error in the hibernate
configuration file, please review it.
6 Aug
6 Aug
6:31 p.m.
I guess everyone on this thread who has tried to help
has run dry of ideas as to why it is not working for me.
4887
days inactive
4891
days old
17 comments
6 participants
participants (6)
-
AngeloG -
Bindul Bhowmik -
Dale Amon -
Guillaume Fenollar -
Sergiu Dumitriu -
Vincent Massol