Ignore the "kokopu". The exception should actually be *Host ''192.168.1.8' is not allowed to connect to this MySQL server. *I had *1**92.168.1.8 kokopu.ddns.net <http://kokopu.ddns.net> kokopu* in /etc/hosts (in the jail) for no good reason.
On 7 February 2017 at 16:32, Oliver Angélil <molofi...@gmail.com> wrote: > 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> > -- *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>
