New Install Error Tomcat + MySQL

Hi,

ive recently installed xwiki in a virtual machine but am getting http 500 error with java connection errors. Ive pasted the log here. Can you guys help me on this?

exception



root cause

java.net.SocketException: Keine Berechtigung (connect failed)
java.net.PlainSocketImpl.socketConnect(Native Method)
java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
java.net.Socket.connect(Socket.java:607)
java.net.Socket.connect(Socket.java:556)
java.net.Socket.(Socket.java:452)
java.net.Socket.(Socket.java:262)
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:257)
com.mysql.jdbc.MysqlIO.(MysqlIO.java:294)
com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2333)
com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2370)
com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2154)
com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:792)
com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)
sun.reflect.GeneratedConstructorAccessor222.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:411)
com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:260)
org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2326)
org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2312)
org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2045)
org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1528)
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:214)
com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:587)
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:891)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:351)
com.xpn.xwiki.XWiki.getDocument(XWiki.java:2045)
com.xpn.xwiki.XWiki.getDocument(XWiki.java:2107)
com.xpn.xwiki.XWiki.getXClass(XWiki.java:6558)
com.xpn.xwiki.XWiki.getClass(XWiki.java:6571)
com.xpn.xwiki.doc.DefaultDocumentAccessBridge.isPropertyCustomMapped(DefaultDocumentAccessBridge.java:540)
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:296)
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:147)
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:992)
com.xpn.xwiki.XWiki.getXWiki(XWiki.java:857)
com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:258)
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:624)
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:112)
org.xwiki.wysiwyg.filter.ConversionFilter.doFilter(ConversionFilter.java:109)
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:134)

In Details:

  • mysql 5.7.28
  • tomcat 7
  • mysql jdbc - mysql-connector-java-5.1.28.jar
  • mysql user and password is xwiki -> tested with mysql -p -u xwiki
  • i deactivated firewalld daemon

am I missing something?

Hi everyone,

ive figured it out…

that was my own error. I installed mysql DB again from scratch and created the DB and user xwiki again like the instructions said, reloaded tomcat and xwiki app.

ill close this request.