[xwiki-users] Installing XWiki on Ubuntu Natty
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
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 <[email protected]>
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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Guillaume Fenollar XWiki SysAdmin
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#HInstalling... 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 <[email protected]> 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
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).
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 <[email protected]>
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).
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Guillaume Fenollar XWiki SysAdmin
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!
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
[snip]
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
On Tue, Aug 02, 2011 at 10:38:37PM +0200, Vincent Massol wrote:
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
[snip]
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.
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
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 <[email protected]>
On Tue, Aug 02, 2011 at 10:38:37PM +0200, Vincent Massol wrote:
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
[snip]
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.
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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Guillaume Fenollar XWiki SysAdmin
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?
On 08/02/2011 05:49 PM, Dale Amon wrote:
On Tue, Aug 02, 2011 at 10:38:37PM +0200, Vincent Massol wrote:
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
[snip]
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.
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='$
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).
<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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Sergiu Dumitriu http://purl.org/net/sergiu/
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*)". -------------------------------------------------------------------------
On Aug 3, 2011, at 3:26 PM, Dale Amon wrote:
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*)".
This means the order of the xml elements is wrong in the file. You can check its DTD or its schema. Thanks -Vincent
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.
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?
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-tp6645828... Sent from the XWiki- Users mailing list archive at Nabble.com.
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.
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.
participants (6)
-
AngeloG -
Bindul Bhowmik -
Dale Amon -
Guillaume Fenollar -
Sergiu Dumitriu -
Vincent Massol