Thank you for the suggestion. Yes, I am trying to set up XEM. I ultimately will need to run a farm of wikis. I have not yet tried installing the basic XE and then manually setting up virtual wikis, because I would prefer to use the built-in management tools if possible.
I changed the xwiki.cfg file to reflect my database name, but the error stays exactly the same. Any other ideas? Thanks, aaron On Tue, Aug 2, 2011 at 7:12 AM, Sergiu Dumitriu <ser...@xwiki.com> wrote: > On 2011-08-01 12:41 AM, "Ashtar Communications" < > ashtarcommunicati...@gmail.com> wrote: >> >> Hi, >> >> I am trying to get XEM set up and am running into an HTTP 500 error >> that I am unsure how to resolve. I originally went through the XEM >> installation tutorial without any results, and thought the problem was >> related to port configuration. My hosting provider said that my tomcat >> instance was running on port 9001 and could not be changed. Now, >> connecting to host.com:9001/xwiki brings up the following: >> >> HTTP Status 500 - >> type Exception report >> message >> description The server encountered an internal error () that prevented >> it from fulfilling this request. >> >> exception >> javax.servlet.ServletException: 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:627) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:729) >> 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:627) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:729) >> 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) >> >> I have double-checked my hibernate cfg file and think it looks >> correct. I have commented out the default configuration and have this: >> >> <property > name="connection.url">jdbc:mysql://localhost/xwiki?useServerPrepStmts=false&useUnicode=true&characterEncoding=UTF-8&sessionVariables=sql_mode=''</property> >> <property name="connection.username">user_xwiki</property> >> <property name="connection.password">password1*</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"/> >> >> My database username is user_xwiki instead of xwiki - I cannot change >> this, but could it be the problem? I am able to manually connect to > > Are you trying to use XEM at this point? Or virtual wikis in any way? If > this is the case, the name of the main database is not taken from that file, > but is specified as a setting in xwiki.cfg > > Also, just to make sure, you did add the mysql-connector jar to the libs, > right? > >> mysql using SSH and the username/password in the hibernate cfg, and >> have granted that user all permissions in my control panel. >> >> Poking around the archives, I also saw errors related to the hosts >> file bringing up 500 errors. My hosts file is: >> >> 127.0.0.1 hornet localhost.localdomain localhost >> >> I do not have permissions to edit the hosts file, but my error is >> different from those which were resolved by changing it. >> >> Any ideas? >> >> Thank you, >> >> aaron >> _______________________________________________ >> users mailing list >> users@xwiki.org >> http://lists.xwiki.org/mailman/listinfo/users > _______________________________________________ > users mailing list > users@xwiki.org > http://lists.xwiki.org/mailman/listinfo/users > _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users