3 Aug
2011
3 Aug
'11
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.