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 <ashtarcommunications(a)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
<ashtarcommunications(a)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 <sergiu(a)xwiki.com>
wrote:
> On 2011-08-01 12:41 AM, "Ashtar
Communications" <
> ashtarcommunications(a)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(a)xwiki.org
>>
http://lists.xwiki.org/mailman/listinfo/users
> _______________________________________________
> users mailing list
> users(a)xwiki.org
>
http://lists.xwiki.org/mailman/listinfo/users
>
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
--
Guillaume Fenollar
XWiki SysAdmin
_______________________________________________
users mailing list
users(a)xwiki.org