Any other ideas? I'm at a total loss... aaron
On Tue, Aug 2, 2011 at 12:14 PM, Ashtar Communications <ashtarcommunicati...@gmail.com> wrote: > 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