Yep, When I connect with: xxx.xxx.xxx.xxx:9001/xwiki
I just get a 404. Changing it back to the domain name, I get the same 500 error. Connecting to my IP:9001 brings up my Tomcat administration page just fine - so I can verify that the servlet is running on that port at that IP. I have the following file in my xwiki/WEB-INF/lib directory: mysql-connector-java-5.1.17-bin.jar Very confusing... aaron On Tue, Aug 2, 2011 at 11:52 AM, Guillaume Fenollar <guillaume.fenol...@xwiki.com> wrote: > Hi aaron, > > It seems to be a mysql-java-connector issue. Since you're sure to have added > the mysql-java-connector.jar file in xwiki/WEB-INF/lib, I barely understand > what is happening. Can you try to access the wiki using the ip address > instead of name? > > Guillaume > > 2011/8/2 Ashtar Communications <ashtarcommunicati...@gmail.com> > >> 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 >> > > > > -- > Guillaume Fenollar > XWiki SysAdmin > _______________________________________________ > 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
