Sorry, forgot: Yes, I did install the mysql jar in the lib directory.
aaron On Tue, Aug 2, 2011 at 11:40 AM, Ashtar Communications <ashtarcommunicati...@gmail.com> wrote: > 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
