[xwiki-users] XWIKI Enterprise Installation Issues
Hello All: I am running into issues with setting up xwiki enterprise platform on my network. Basically it starts and loads to 100% and not much else I am thinking it's a configuration issue with something I have left out. Here is what I am using for xwiki. Win2012R2 SQL2012 Tomcat/JDBC/JTDS Is their a definitive install guide for using windows/sql server? The stuff I have come across isn't as specific as I would like to see. Any thoughts would be much appreciated and would be happy to post java output from tomcat. -- View this message in context: http://xwiki.475771.n2.nabble.com/XWIKI-Enterprise-Installation-Issues-tp759... Sent from the XWiki- Users mailing list archive at Nabble.com.
Hi, unfortunately I have no experience with running XWiki on the given DB/OS combination, so here are only a few generic thoughts? - in the webapps/xwiki/WEB-INF/classes/log4j.xml is the config for the logs, there might be some stuff in the logs to read - if the server is seemingly "endlessly busy", try to get a stack trace [Actually the first thing XWiki does on the initial startup is to create the initial search index - that might take a moment ...] - come to think of it, are the database tables created? If not, then certainly the connection to the DB fails. Finally, while I have never been able to reproduce it, I have heard reports in one case that XWiki shows similar symptoms when started on a server with very restrictive firewall settings, where attempts of XWiki to connect to the outside have been simply dropped. XWiki has been working, but has been excessively slow. However I did not even get a stack trace from that case, so I am not sure if the firewall or whatever caused that behaviour. Clemens
Hello All:
I am running into issues with setting up xwiki enterprise platform on my network. Basically it starts and loads to 100% and not much else I am thinking it's a configuration issue with something I have left out.
Here is what I am using for xwiki.
Win2012R2 SQL2012 Tomcat/JDBC/JTDS
Is their a definitive install guide for using windows/sql server? The stuff I have come across isn't as specific as I would like to see.
Any thoughts would be much appreciated and would be happy to post java output from tomcat.
-- View this message in context: http://xwiki.475771.n2.nabble.com/XWIKI-Enterprise-Installation-Issues-tp759... Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
mit freundlichen Grüßen Clemens Klein-Robbenhaar -- Clemens Klein-Robbenhaar Software Development EsPresto AG Breite Str. 30-31 10178 Berlin/Germany Tel: +49.(0)30.90 226.763 Fax: +49.(0)30.90 226.760 robbenhaar@espresto.com HRB 77554 B - Berlin-Charlottenburg Vorstand: Maya Biersack, Peter Biersack Vorsitzender des Aufsichtsrats: Dipl.-Wirtsch.-Ing. Winfried Weber Zertifiziert nach ISO 9001:2008
On Tue, Oct 21, 2014 at 8:53 AM, Clemens Klein-Robbenhaar <c.robbenhaar@espresto.com> wrote:
Hi,
unfortunately I have no experience with running XWiki on the given DB/OS combination, so here are only a few generic thoughts?
- in the webapps/xwiki/WEB-INF/classes/log4j.xml is the config for the logs, there might be some stuff in the logs to read
webapps/xwiki/WEB-INF/classes/logback.xml
- if the server is seemingly "endlessly busy", try to get a stack trace [Actually the first thing XWiki does on the initial startup is to create the initial search index - that might take a moment ...] - come to think of it, are the database tables created? If not, then certainly the connection to the DB fails.
Finally, while I have never been able to reproduce it, I have heard reports in one case that XWiki shows similar symptoms when started on a server with very restrictive firewall settings, where attempts of XWiki to connect to the outside have been simply dropped. XWiki has been working, but has been excessively slow. However I did not even get a stack trace from that case, so I am not sure if the firewall or whatever caused that behaviour.
Clemens
Hello All:
I am running into issues with setting up xwiki enterprise platform on my network. Basically it starts and loads to 100% and not much else I am thinking it's a configuration issue with something I have left out.
Here is what I am using for xwiki.
Win2012R2 SQL2012 Tomcat/JDBC/JTDS
Is their a definitive install guide for using windows/sql server? The stuff I have come across isn't as specific as I would like to see.
Any thoughts would be much appreciated and would be happy to post java output from tomcat.
-- View this message in context: http://xwiki.475771.n2.nabble.com/XWIKI-Enterprise-Installation-Issues-tp759... Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
mit freundlichen Grüßen Clemens Klein-Robbenhaar
-- Clemens Klein-Robbenhaar Software Development EsPresto AG Breite Str. 30-31 10178 Berlin/Germany Tel: +49.(0)30.90 226.763 Fax: +49.(0)30.90 226.760 robbenhaar@espresto.com
HRB 77554 B - Berlin-Charlottenburg Vorstand: Maya Biersack, Peter Biersack Vorsitzender des Aufsichtsrats: Dipl.-Wirtsch.-Ing. Winfried Weber Zertifiziert nach ISO 9001:2008 _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne
I'm still having a devil of a time with getting xwiki up/running. I now have the following errors. I've added local/domain/dbase accounts using "xwiki" user account. --------------------------------------------------------------------------------------------------- XWiki initialization failed ! Login failed for user 'xwiki'. class org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Login failed for user 'xwiki'.) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) at com.xpn.xwiki.store.DBCPConnectionProvider.configure(DBCPConnectionProvider.java:197) at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:143) at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:84) at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:459) at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:90) at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870) at com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibernateBaseStore.java:253) at com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:682) at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:827) at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:291) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1305) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1352) at com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:779) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:739) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:660) at com.xpn.xwiki.XWiki.<init>(XWiki.java:649) at com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:115) at org.xwiki.job.internal.AbstractJob.runInContext(AbstractJob.java:209) at org.xwiki.job.internal.AbstractJob.run(AbstractJob.java:192) at java.lang.Thread.run(Thread.java:745) Caused by: class java.sql.SQLException: Login failed for user 'xwiki'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421) at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:632) at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:371) at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) at com.xpn.xwiki.store.DBCPConnectionProvider.configure(DBCPConnectionProvider.java:197) at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:143) at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:84) at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:459) at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:90) at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870) at com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibernateBaseStore.java:253) at com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:682) at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:827) at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:291) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1305) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1352) at com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:779) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:739) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:660) at com.xpn.xwiki.XWiki.<init>(XWiki.java:649) at com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:115) at org.xwiki.job.internal.AbstractJob.runInContext(AbstractJob.java:209) at org.xwiki.job.internal.AbstractJob.run(AbstractJob.java:192) at java.lang.Thread.run(Thread.java:745) Login failed for user 'xwiki'. class com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while reading document [xwiki:XWiki.WikiMacroParameterClass] at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:958) at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:291) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1305) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1352) at com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:779) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:739) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:660) at com.xpn.xwiki.XWiki.<init>(XWiki.java:649) at com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:115) at org.xwiki.job.internal.AbstractJob.runInContext(AbstractJob.java:209) at org.xwiki.job.internal.AbstractJob.run(AbstractJob.java:192) at java.lang.Thread.run(Thread.java:745) Caused by: class org.hibernate.HibernateException: Could not create a DBCP pool. There is an error in the hibernate configuration file, please review it. at com.xpn.xwiki.store.DBCPConnectionProvider.configure(DBCPConnectionProvider.java:215) at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:143) at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:84) at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:459) at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:90) at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870) at com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibernateBaseStore.java:253) at com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:682) at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:827) at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:291) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1305) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1352) at com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:779) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:739) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:660) at com.xpn.xwiki.XWiki.<init>(XWiki.java:649) at com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:115) at org.xwiki.job.internal.AbstractJob.runInContext(AbstractJob.java:209) at org.xwiki.job.internal.AbstractJob.run(AbstractJob.java:192) at java.lang.Thread.run(Thread.java:745) Caused by: class org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Login failed for user 'xwiki'.) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) at com.xpn.xwiki.store.DBCPConnectionProvider.configure(DBCPConnectionProvider.java:197) at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:143) at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:84) at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:459) at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:90) at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870) at com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibernateBaseStore.java:253) at com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:682) at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:827) at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:291) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1305) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1352) at com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:779) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:739) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:660) at com.xpn.xwiki.XWiki.<init>(XWiki.java:649) at com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:115) at org.xwiki.job.internal.AbstractJob.runInContext(AbstractJob.java:209) at org.xwiki.job.internal.AbstractJob.run(AbstractJob.java:192) at java.lang.Thread.run(Thread.java:745) Caused by: class java.sql.SQLException: Login failed for user 'xwiki'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421) at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:632) at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:371) at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) at com.xpn.xwiki.store.DBCPConnectionProvider.configure(DBCPConnectionProvider.java:197) at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:143) at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:84) at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:459) at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:90) at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870) at com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibernateBaseStore.java:253) at com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:682) at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:827) at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:291) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1305) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1352) at com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:779) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:739) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:660) at com.xpn.xwiki.XWiki.<init>(XWiki.java:649) at com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:115) at org.xwiki.job.internal.AbstractJob.runInContext(AbstractJob.java:209) at org.xwiki.job.internal.AbstractJob.run(AbstractJob.java:192) at java.lang.Thread.run(Thread.java:745) -- View this message in context: http://xwiki.475771.n2.nabble.com/XWIKI-Enterprise-Installation-Issues-tp759... Sent from the XWiki- Users mailing list archive at Nabble.com.
Here is my hibernate.cfg.xml file" <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN" "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory> <property name="show_sql">false</property> <property name="use_outer_join">true</property> <property name="connection.pool_size">2</property> <property name="statement_cache.size">2</property> <property name="jdbc.use_scrollable_resultset">false</property> <property name="dbcp.defaultAutoCommit">false</property> <property name="dbcp.maxActive">50</property> <property name="dbcp.maxIdle">5</property> <property name="dbcp.maxWait">30000</property> <property name="dbcp.whenExhaustedAction">1</property> <property name="dbcp.ps.whenExhaustedAction">1</property> <property name="dbcp.ps.maxWait">120000</property> <property name="dbcp.ps.maxIdle">20</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="connection.url">jdbc:jtds:sqlserver://dxwsql001.mgt.com:1433/xwiki;</property> <property name="connection.username">xwiki</property> <property name="connection.password">Password12</property> <property name="hibernate.default_schema">dbo</property> <property name="connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property> <property name="dialect">hibernate.dialect.SQLServerDialect</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="dialect">org.hibernate.dialect.SQLServerDialect</property> <property name="connection.pool_size">2</property> <property name="statement_cache.size">2</property> <mapping resource="xwiki.mssql.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> <mapping resource="instance.hbm.xml"/> </session-factory> </hibernate-configuration> -- View this message in context: http://xwiki.475771.n2.nabble.com/XWIKI-Enterprise-Installation-Issues-tp759... Sent from the XWiki- Users mailing list archive at Nabble.com.
participants (3)
-
Clemens Klein-Robbenhaar -
Thomas Mortagne -
wolfmav