Thanks Sergiu,

Seems I had misunderstood the "replace the matching properties with the
following ones" in the xwiki mysql installation instructions. I think I
have done this part correctly now. Unfortunately I have encountered another
exception (pasted below).

I am guessing the following is the problem: message from server: *"Host
'kokopu.ddns.net <http://kokopu.ddns.net>' is not allowed to connect to
this MySQL server". *

I'm doing this on FreeBSD. The main host is "kokopu" (192.168.1.7) and the
entire xwiki installation is in a FreeBSD jail (192.168.1.8).

Oliver

*type* Exception report

*message* *com.xpn.xwiki.XWikiException: Error number 11007 in 0: Failed to
extract Entity Resource Reference from URL
[http://192.168.1.8:8080/xwiki-enterprise-web-8.4.4/bin/view/Main/
<http://192.168.1.8:8080/xwiki-enterprise-web-8.4.4/bin/view/Main/>]*

*description* *The server encountered an internal error that prevented it
from fulfilling this request.*

*exception*

javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error
number 11007 in 0: Failed to extract Entity Resource Reference from
URL [http://192.168.1.8:8080/xwiki-enterprise-web-8.4.4/bin/view/Main/]
        
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:520)
        
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:427)
        
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
        org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
        org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
        com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:112)
        
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:127)
        org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
        
org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63)
        
org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208)
        
org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111)
        
org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:136)

*root cause*

com.xpn.xwiki.XWikiException: Error number 11007 in 0: Failed to
extract Entity Resource Reference from URL
[http://192.168.1.8:8080/xwiki-enterprise-web-8.4.4/bin/view/Main/]
        com.xpn.xwiki.XWiki.initializeResourceFromURL(XWiki.java:926)
        com.xpn.xwiki.XWiki.getXWiki(XWiki.java:793)
        com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:255)
        com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:210)
        
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
        
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
        org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
        org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
        com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:112)
        
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:127)
        org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
        
org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63)
        
org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208)
        
org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111)
        
org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:136)

*root cause*

java.lang.RuntimeException: Failed to locate wiki descriptor for alias
[192.168.1.8]
        
org.xwiki.url.internal.standard.AbstractWikiReferenceExtractor.getWikiDescriptorByAlias(AbstractWikiReferenceExtractor.java:80)
        
org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.resolveDomainBasedWikiReference(DomainWikiReferenceExtractor.java:61)
        
org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.extract(DomainWikiReferenceExtractor.java:47)
        
org.xwiki.url.internal.standard.entity.BinEntityResourceReferenceResolver.extractWikiReference(BinEntityResourceReferenceResolver.java:51)
        
org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:92)
        
org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:51)
        
org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:61)
        
org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:47)
        
org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:65)
        
org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:43)
        
org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:93)
        
org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:48)
        com.xpn.xwiki.XWiki.initializeResourceFromURL(XWiki.java:922)
        com.xpn.xwiki.XWiki.getXWiki(XWiki.java:793)
        com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:255)
        com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:210)
        
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
        
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
        org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
        org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
        com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:112)
        
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:127)
        org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
        
org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63)
        
org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208)
        
org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111)
        
org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:136)

*root cause*

org.xwiki.wiki.manager.WikiManagerException: Failed to locate
XWiki.XWikiServerClass document for wiki alias [192.168.1.8]
        
org.xwiki.wiki.internal.descriptor.document.DefaultWikiDescriptorDocumentHelper.findXWikiServerClassDocumentReference(DefaultWikiDescriptorDocumentHelper.java:128)
        
org.xwiki.wiki.internal.descriptor.document.DefaultWikiDescriptorDocumentHelper.findXWikiServerClassDocument(DefaultWikiDescriptorDocumentHelper.java:140)
        
org.xwiki.wiki.internal.descriptor.DefaultWikiDescriptorManager.getByAlias(DefaultWikiDescriptorManager.java:146)
        
org.xwiki.url.internal.standard.AbstractWikiReferenceExtractor.getWikiDescriptorByAlias(AbstractWikiReferenceExtractor.java:78)
        
org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.resolveDomainBasedWikiReference(DomainWikiReferenceExtractor.java:61)
        
org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.extract(DomainWikiReferenceExtractor.java:47)
        
org.xwiki.url.internal.standard.entity.BinEntityResourceReferenceResolver.extractWikiReference(BinEntityResourceReferenceResolver.java:51)
        
org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:92)
        
org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:51)
        
org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:61)
        
org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:47)
        
org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:65)
        
org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:43)
        
org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:93)
        
org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:48)
        com.xpn.xwiki.XWiki.initializeResourceFromURL(XWiki.java:922)
        com.xpn.xwiki.XWiki.getXWiki(XWiki.java:793)
        com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:255)
        com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:210)
        
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
        
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
        org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
        org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
        com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:112)
        
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:127)
        org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
        
org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63)
        
org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208)
        
org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111)
        
org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:136)

*root cause*

org.xwiki.query.QueryException: Exception while translating [where
doc.object(XWiki.XWikiServerClass).server = :wikiAlias and doc.name
like 'XWikiServer%'] XWQL query to the [hql] language. Query statement
= [where doc.object(XWiki.XWikiServerClass).server = :wikiAlias and
doc.name like 'XWikiServer%']
        
org.xwiki.query.xwql.internal.XWQLQueryExecutor.execute(XWQLQueryExecutor.java:130)
        
org.xwiki.query.internal.DefaultQueryExecutorManager.execute(DefaultQueryExecutorManager.java:72)
        org.xwiki.query.internal.DefaultQuery.execute(DefaultQuery.java:287)
        
org.xwiki.wiki.internal.descriptor.document.DefaultWikiDescriptorDocumentHelper.findXWikiServerClassDocumentReference(DefaultWikiDescriptorDocumentHelper.java:121)
        
org.xwiki.wiki.internal.descriptor.document.DefaultWikiDescriptorDocumentHelper.findXWikiServerClassDocument(DefaultWikiDescriptorDocumentHelper.java:140)
        
org.xwiki.wiki.internal.descriptor.DefaultWikiDescriptorManager.getByAlias(DefaultWikiDescriptorManager.java:146)
        
org.xwiki.url.internal.standard.AbstractWikiReferenceExtractor.getWikiDescriptorByAlias(AbstractWikiReferenceExtractor.java:78)
        
org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.resolveDomainBasedWikiReference(DomainWikiReferenceExtractor.java:61)
        
org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.extract(DomainWikiReferenceExtractor.java:47)
        
org.xwiki.url.internal.standard.entity.BinEntityResourceReferenceResolver.extractWikiReference(BinEntityResourceReferenceResolver.java:51)
        
org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:92)
        
org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:51)
        
org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:61)
        
org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:47)
        
org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:65)
        
org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:43)
        
org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:93)
        
org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:48)
        com.xpn.xwiki.XWiki.initializeResourceFromURL(XWiki.java:922)
        com.xpn.xwiki.XWiki.getXWiki(XWiki.java:793)
        com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:255)
        com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:210)
        
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
        
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
        org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
        org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
        com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:112)
        
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:127)
        org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
        
org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63)
        
org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208)
        
org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111)
        
org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:136)

*root cause*

com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while
reading document [xwiki:XWiki.XWikiServerClass]
        
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:996)
        
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:280)
        com.xpn.xwiki.XWiki.getDocument(XWiki.java:1811)
        com.xpn.xwiki.XWiki.getDocument(XWiki.java:1864)
        com.xpn.xwiki.XWiki.getXClass(XWiki.java:6065)
        com.xpn.xwiki.XWiki.getClass(XWiki.java:6078)
        
com.xpn.xwiki.doc.DefaultDocumentAccessBridge.isPropertyCustomMapped(DefaultDocumentAccessBridge.java:497)
        
org.xwiki.query.xwql.internal.QueryContext$PropertyInfo.isCustomMapped(QueryContext.java:153)
        
org.xwiki.query.xwql.internal.QueryContext$ObjectInfo.isCustomMapped(QueryContext.java:122)
        
org.xwiki.query.xwql.internal.hql.ObjectPrinter.print(ObjectPrinter.java:37)
        org.xwiki.query.xwql.internal.hql.Printer.print(Printer.java:70)
        
org.xwiki.query.xwql.internal.hql.XWQLtoHQLTranslator.translate(XWQLtoHQLTranslator.java:61)
        
org.xwiki.query.xwql.internal.XWQLQueryExecutor.execute(XWQLQueryExecutor.java:97)
        
org.xwiki.query.internal.DefaultQueryExecutorManager.execute(DefaultQueryExecutorManager.java:72)
        org.xwiki.query.internal.DefaultQuery.execute(DefaultQuery.java:287)
        
org.xwiki.wiki.internal.descriptor.document.DefaultWikiDescriptorDocumentHelper.findXWikiServerClassDocumentReference(DefaultWikiDescriptorDocumentHelper.java:121)
        
org.xwiki.wiki.internal.descriptor.document.DefaultWikiDescriptorDocumentHelper.findXWikiServerClassDocument(DefaultWikiDescriptorDocumentHelper.java:140)
        
org.xwiki.wiki.internal.descriptor.DefaultWikiDescriptorManager.getByAlias(DefaultWikiDescriptorManager.java:146)
        
org.xwiki.url.internal.standard.AbstractWikiReferenceExtractor.getWikiDescriptorByAlias(AbstractWikiReferenceExtractor.java:78)
        
org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.resolveDomainBasedWikiReference(DomainWikiReferenceExtractor.java:61)
        
org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.extract(DomainWikiReferenceExtractor.java:47)
        
org.xwiki.url.internal.standard.entity.BinEntityResourceReferenceResolver.extractWikiReference(BinEntityResourceReferenceResolver.java:51)
        
org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:92)
        
org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:51)
        
org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:61)
        
org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:47)
        
org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:65)
        
org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:43)
        
org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:93)
        
org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:48)
        com.xpn.xwiki.XWiki.initializeResourceFromURL(XWiki.java:922)
        com.xpn.xwiki.XWiki.getXWiki(XWiki.java:793)
        com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:255)
        com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:210)
        
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
        
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
        org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
        org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
        com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:112)
        
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:127)
        org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
        
org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63)
        
org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208)
        
org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111)
        
org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:136)

*root cause*

org.hibernate.HibernateException: Could not create a DBCP pool. There
is an error in the Hibernate configuration file, please review it.
        
com.xpn.xwiki.store.DBCPConnectionProvider.configure(DBCPConnectionProvider.java:232)
        
org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:143)
        
org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:84)
        
org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:459)
        org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:90)
        
org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863)
        org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859)
        
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870)
        
com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibernateBaseStore.java:259)
        
com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:703)
        
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:861)
        
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:280)
        com.xpn.xwiki.XWiki.getDocument(XWiki.java:1811)
        com.xpn.xwiki.XWiki.getDocument(XWiki.java:1864)
        com.xpn.xwiki.XWiki.getXClass(XWiki.java:6065)
        com.xpn.xwiki.XWiki.getClass(XWiki.java:6078)
        
com.xpn.xwiki.doc.DefaultDocumentAccessBridge.isPropertyCustomMapped(DefaultDocumentAccessBridge.java:497)
        
org.xwiki.query.xwql.internal.QueryContext$PropertyInfo.isCustomMapped(QueryContext.java:153)
        
org.xwiki.query.xwql.internal.QueryContext$ObjectInfo.isCustomMapped(QueryContext.java:122)
        
org.xwiki.query.xwql.internal.hql.ObjectPrinter.print(ObjectPrinter.java:37)
        org.xwiki.query.xwql.internal.hql.Printer.print(Printer.java:70)
        
org.xwiki.query.xwql.internal.hql.XWQLtoHQLTranslator.translate(XWQLtoHQLTranslator.java:61)
        
org.xwiki.query.xwql.internal.XWQLQueryExecutor.execute(XWQLQueryExecutor.java:97)
        
org.xwiki.query.internal.DefaultQueryExecutorManager.execute(DefaultQueryExecutorManager.java:72)
        org.xwiki.query.internal.DefaultQuery.execute(DefaultQuery.java:287)
        
org.xwiki.wiki.internal.descriptor.document.DefaultWikiDescriptorDocumentHelper.findXWikiServerClassDocumentReference(DefaultWikiDescriptorDocumentHelper.java:121)
        
org.xwiki.wiki.internal.descriptor.document.DefaultWikiDescriptorDocumentHelper.findXWikiServerClassDocument(DefaultWikiDescriptorDocumentHelper.java:140)
        
org.xwiki.wiki.internal.descriptor.DefaultWikiDescriptorManager.getByAlias(DefaultWikiDescriptorManager.java:146)
        
org.xwiki.url.internal.standard.AbstractWikiReferenceExtractor.getWikiDescriptorByAlias(AbstractWikiReferenceExtractor.java:78)
        
org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.resolveDomainBasedWikiReference(DomainWikiReferenceExtractor.java:61)
        
org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.extract(DomainWikiReferenceExtractor.java:47)
        
org.xwiki.url.internal.standard.entity.BinEntityResourceReferenceResolver.extractWikiReference(BinEntityResourceReferenceResolver.java:51)
        
org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:92)
        
org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:51)
        
org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:61)
        
org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:47)
        
org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:65)
        
org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:43)
        
org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:93)
        
org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:48)
        com.xpn.xwiki.XWiki.initializeResourceFromURL(XWiki.java:922)
        com.xpn.xwiki.XWiki.getXWiki(XWiki.java:793)
        com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:255)
        com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:210)
        
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
        
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
        org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
        org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
        com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:112)
        
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:127)
        org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
        
org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63)
        
org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208)
        
org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111)
        
org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:136)

*root cause*

java.sql.SQLException: Cannot create PoolableConnectionFactory (null,
message from server: "Host 'kokopu.ddns.net' is not allowed to connect
to this MySQL server")
        
org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2294)
        
org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2039)
        
org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533)
        
com.xpn.xwiki.store.DBCPConnectionProvider.configure(DBCPConnectionProvider.java:215)
        
org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:143)
        
org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:84)
        
org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:459)
        org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:90)
        
org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863)
        org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859)
        
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870)
        
com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibernateBaseStore.java:259)
        
com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:703)
        
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:861)
        
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:280)
        com.xpn.xwiki.XWiki.getDocument(XWiki.java:1811)
        com.xpn.xwiki.XWiki.getDocument(XWiki.java:1864)
        com.xpn.xwiki.XWiki.getXClass(XWiki.java:6065)
        com.xpn.xwiki.XWiki.getClass(XWiki.java:6078)
        
com.xpn.xwiki.doc.DefaultDocumentAccessBridge.isPropertyCustomMapped(DefaultDocumentAccessBridge.java:497)
        
org.xwiki.query.xwql.internal.QueryContext$PropertyInfo.isCustomMapped(QueryContext.java:153)
        
org.xwiki.query.xwql.internal.QueryContext$ObjectInfo.isCustomMapped(QueryContext.java:122)
        
org.xwiki.query.xwql.internal.hql.ObjectPrinter.print(ObjectPrinter.java:37)
        org.xwiki.query.xwql.internal.hql.Printer.print(Printer.java:70)
        
org.xwiki.query.xwql.internal.hql.XWQLtoHQLTranslator.translate(XWQLtoHQLTranslator.java:61)
        
org.xwiki.query.xwql.internal.XWQLQueryExecutor.execute(XWQLQueryExecutor.java:97)
        
org.xwiki.query.internal.DefaultQueryExecutorManager.execute(DefaultQueryExecutorManager.java:72)
        org.xwiki.query.internal.DefaultQuery.execute(DefaultQuery.java:287)
        
org.xwiki.wiki.internal.descriptor.document.DefaultWikiDescriptorDocumentHelper.findXWikiServerClassDocumentReference(DefaultWikiDescriptorDocumentHelper.java:121)
        
org.xwiki.wiki.internal.descriptor.document.DefaultWikiDescriptorDocumentHelper.findXWikiServerClassDocument(DefaultWikiDescriptorDocumentHelper.java:140)
        
org.xwiki.wiki.internal.descriptor.DefaultWikiDescriptorManager.getByAlias(DefaultWikiDescriptorManager.java:146)
        
org.xwiki.url.internal.standard.AbstractWikiReferenceExtractor.getWikiDescriptorByAlias(AbstractWikiReferenceExtractor.java:78)
        
org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.resolveDomainBasedWikiReference(DomainWikiReferenceExtractor.java:61)
        
org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.extract(DomainWikiReferenceExtractor.java:47)
        
org.xwiki.url.internal.standard.entity.BinEntityResourceReferenceResolver.extractWikiReference(BinEntityResourceReferenceResolver.java:51)
        
org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:92)
        
org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:51)
        
org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:61)
        
org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:47)
        
org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:65)
        
org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:43)
        
org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:93)
        
org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:48)
        com.xpn.xwiki.XWiki.initializeResourceFromURL(XWiki.java:922)
        com.xpn.xwiki.XWiki.getXWiki(XWiki.java:793)
        com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:255)
        com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:210)
        
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
        
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
        org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
        org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
        com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:112)
        
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:127)
        org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
        
org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63)
        
org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208)
        
org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111)
        
org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:136)

*root cause*

java.sql.SQLException: null,  message from server: "Host
'kokopu.ddns.net' is not allowed to connect to this MySQL server"
        com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
        com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)
        com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)
        com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1040)
        com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2253)
        
com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2284)
        com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2083)
        com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806)
        com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
        sun.reflect.GeneratedConstructorAccessor67.newInstance(Unknown Source)
        
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        java.lang.reflect.Constructor.newInstance(Constructor.java:423)
        com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
        com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410)
        
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328)
        
org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39)
        
org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:256)
        
org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2304)
        
org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2290)
        
org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2039)
        
org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533)
        
com.xpn.xwiki.store.DBCPConnectionProvider.configure(DBCPConnectionProvider.java:215)
        
org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:143)
        
org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:84)
        
org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:459)
        org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:90)
        
org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863)
        org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859)
        
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870)
        
com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibernateBaseStore.java:259)
        
com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:703)
        
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:861)
        
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:280)
        com.xpn.xwiki.XWiki.getDocument(XWiki.java:1811)
        com.xpn.xwiki.XWiki.getDocument(XWiki.java:1864)
        com.xpn.xwiki.XWiki.getXClass(XWiki.java:6065)
        com.xpn.xwiki.XWiki.getClass(XWiki.java:6078)
        
com.xpn.xwiki.doc.DefaultDocumentAccessBridge.isPropertyCustomMapped(DefaultDocumentAccessBridge.java:497)
        
org.xwiki.query.xwql.internal.QueryContext$PropertyInfo.isCustomMapped(QueryContext.java:153)
        
org.xwiki.query.xwql.internal.QueryContext$ObjectInfo.isCustomMapped(QueryContext.java:122)
        
org.xwiki.query.xwql.internal.hql.ObjectPrinter.print(ObjectPrinter.java:37)
        org.xwiki.query.xwql.internal.hql.Printer.print(Printer.java:70)
        
org.xwiki.query.xwql.internal.hql.XWQLtoHQLTranslator.translate(XWQLtoHQLTranslator.java:61)
        
org.xwiki.query.xwql.internal.XWQLQueryExecutor.execute(XWQLQueryExecutor.java:97)
        
org.xwiki.query.internal.DefaultQueryExecutorManager.execute(DefaultQueryExecutorManager.java:72)
        org.xwiki.query.internal.DefaultQuery.execute(DefaultQuery.java:287)
        
org.xwiki.wiki.internal.descriptor.document.DefaultWikiDescriptorDocumentHelper.findXWikiServerClassDocumentReference(DefaultWikiDescriptorDocumentHelper.java:121)
        
org.xwiki.wiki.internal.descriptor.document.DefaultWikiDescriptorDocumentHelper.findXWikiServerClassDocument(DefaultWikiDescriptorDocumentHelper.java:140)
        
org.xwiki.wiki.internal.descriptor.DefaultWikiDescriptorManager.getByAlias(DefaultWikiDescriptorManager.java:146)
        
org.xwiki.url.internal.standard.AbstractWikiReferenceExtractor.getWikiDescriptorByAlias(AbstractWikiReferenceExtractor.java:78)
        
org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.resolveDomainBasedWikiReference(DomainWikiReferenceExtractor.java:61)
        
org.xwiki.url.internal.standard.DomainWikiReferenceExtractor.extract(DomainWikiReferenceExtractor.java:47)
        
org.xwiki.url.internal.standard.entity.BinEntityResourceReferenceResolver.extractWikiReference(BinEntityResourceReferenceResolver.java:51)
        
org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:92)
        
org.xwiki.url.internal.standard.entity.AbstractEntityResourceReferenceResolver.resolve(AbstractEntityResourceReferenceResolver.java:51)
        
org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:61)
        
org.xwiki.url.internal.GenericResourceReferenceResolver.resolve(GenericResourceReferenceResolver.java:47)
        
org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:65)
        
org.xwiki.url.internal.standard.StandardExtendedURLResourceReferenceResolver.resolve(StandardExtendedURLResourceReferenceResolver.java:43)
        
org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:93)
        
org.xwiki.url.internal.DefaultResourceReferenceResolver.resolve(DefaultResourceReferenceResolver.java:48)
        com.xpn.xwiki.XWiki.initializeResourceFromURL(XWiki.java:922)
        com.xpn.xwiki.XWiki.getXWiki(XWiki.java:793)
        com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:255)
        com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:210)
        
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
        
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
        org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
        org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
        com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:112)
        
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:127)
        org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
        
org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63)
        
org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208)
        
org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111)
        
org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:136)

*note* *The full stack trace of the root cause is available in the Apache
Tomcat/8.0.39 logs.*


On 7 February 2017 at 15:29, Sergiu Dumitriu <ser...@xwiki.org> wrote:

> On 02/06/2017 09:26 PM, Oliver Angélil wrote:
> > The full exception report is pasted below.
> >
> > I've followed the tomcat
> > <http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomcat>
> >  and mysql
> > <http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMySQL>
> > installation
> > instructions. I can see the tomcat homepage when navigating to h
> > ttp://192.168.1.8:8080/ in my browser, however
> > http://192.168.1.8:8080/xwiki-enterprise-web-8.4.4/bin/view/Main
> results in
> > the error attached.
>
> The root cause:
>
> > *root cause*
> >
> > org.xml.sax.SAXParseException; lineNumber: 237; columnNumber: 21; The
> > content of element type "session-factory" must match
> > "(property*,mapping*,(class-cache|collection-cache)*,event*,listener*)".
>
> Indicates that the hibernate.cfg.xml file is malformed, make sure you
> uncommented the mysql configuration properly, and you commented the
> default connection.
>
> --
> Sergiu Dumitriu
> http://purl.org/net/sergiu/
>



-- 
*Oliver Marc Angélil*
PhD Candidate at the University of New South Wales, Australia
*http://web.maths.unsw.edu.au/~oangelil/oliver/page_oliver.html*
<http://web.maths.unsw.edu.au/~oangelil/oliver/page_oliver.html>

Reply via email to