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 <[email protected]> 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 <[email protected]> wrote:
On 2011-08-01 12:41 AM, "Ashtar Communications" < [email protected]> 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users