Error connecting to the openfire 4.2.2 console

wanzeler · March 16, 2018, 6:32pm

Can someone help me?

HTTP ERROR 500

Problem accessing /index.jsp. Reason:

Server Error

Caused by:

javax.servlet.ServletException: java.lang.NoClassDefFoundError: Could not initialize class org.jivesoftware.openfire.http.HttpBindManager
at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:905)
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:834)
at org.jivesoftware.openfire.admin.index_jsp._jspService(index_jsp.java:636)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:812)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669)
at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)
at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:73)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:49)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
at org.jivesoftware.admin.PluginFilter.doFilter(PluginFilter.java:226)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:215)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)
at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:110)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
at org.eclipse.jetty.server.Server.handle(Server.java:499)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:544)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NoClassDefFoundError: Could not initialize class org.jivesoftware.openfire.http.HttpBindManager
at org.jivesoftware.openfire.admin.index_jsp._jspService(index_jsp.java:164)
… 34 more
Caused by:

java.lang.NoClassDefFoundError: Could not initialize class org.jivesoftware.openfire.http.HttpBindManager
at org.jivesoftware.openfire.admin.index_jsp._jspService(index_jsp.java:164)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:812)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669)
at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)
at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:73)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:49)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
at org.jivesoftware.admin.PluginFilter.doFilter(PluginFilter.java:226)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:215)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)
at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:110)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
at org.eclipse.jetty.server.Server.handle(Server.java:499)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:544)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
at java.lang.Thread.run(Unknown Source)
Powered by Jetty://

Peter_Linden · March 21, 2018, 3:06pm

Hey
I have the exact same problem.
for me it is a new installation.
and I use mysql 5 on a linux machine.
and openfire 4.2.2 running on a windows 10 machine

hopefully someone can help us further
Greetings: Peter

wroot · March 21, 2018, 7:10pm

Peter, on Windows 10 do you run it as a service as it installs by default or have you stopped/disabled the service and run it manually with the launcher? If you have stopped the service, then you should run the launcher with Run as administrator option (even if you are logged as admin). If the service is running, you shouldn’t run the launcher and just can go to http://server:9090 remotely or http://localhost:9090 on the server itself.

Peter_Linden · March 22, 2018, 6:50am

Hey
I start it manually.
to be on the safe side, I started windows 10 again so that I could check whether the web interface is available without manually starting it.
and if I do not start manually, I do not have a web interface.
however, the restart has caused the web interface to be manually unavailable.
I also get the following error message in the launcher at the manual start menu.

Mijava.langEs.csxeptionInInitializerError
	at org.jivesoftware.openfire.privacy.PrivacyListManager.<init>(PrivacyListManager.java:37)
	at roing database schema for opgenfire. Attem.pitjivseong oft install...
Shutting down. Unloadin gwtallla oaded plugisrn...
e.openfire.privacy.PrivacyListManager.<clinit>(PrivacyListManager.java:34)
	at org.jivesoftware.openfire.handler.IQPrivacyHandler.<init>(IQPrivacyHandler.java:49)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at java.lang.Class.newInstance(Unknown Source)
	at org.jivesoftware.openfire.XMPPServer.loadModule(XMPPServer.java:647)
	at org.jivesoftware.openfire.XMPPServer.loadModules(XMPPServer.java:618)
	at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:546)
	at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:163)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at java.lang.Class.newInstance(Unknown Source)
	at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:102)
	at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:53)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at com.exe4j.runtime.LauncherEngine.launch(LauncherEngine.java:81)
	at com.exe4j.runtime.WinLauncher.main(WinLauncher.java:94)
	at com.install4j.runtime.launcher.WinLauncher.main(WinLauncher.java:25)
Caused by: java.lang.NullPointerException
	at org.jivesoftware.openfire.privacy.PrivacyListProvider.loadDatabaseContainsPrivacyLists(PrivacyListProvider.java:389)
	at org.jivesoftware.openfire.privacy.PrivacyListProvider.<init>(PrivacyListProvider.java:97)
	at org.jivesoftware.openfire.privacy.PrivacyListProvider.<clinit>(PrivacyListProvider.java:44)
	... 26 more
Server halted

Greetings: Peter

wroot · March 22, 2018, 7:42am

I suggest uninstalling it and installing again. I would also suggest to leave service enabled and running and trying to connect to web interface without the launcher. If you leave service checkbox enabled on the last page of the setup, it opens a browser pointing to the web interface automatically.

Peter_Linden · March 23, 2018, 10:35am

1101/5000
1 java installed
2 openfire server ge download
3 setup is started
4 walk through and everything is late as it stood with standard settings
5 configuration wizard started
5.1 language: chosen Dutch
5.2 server settings:
domain: jabber.jenp.net
server host name (fqdn): DESKTOP-4TT8UA5
otherwise leave server settings as they are by default
5.3 leave data source on default database connection
data source set on mysqk
and put the settings right (data I am not going to put down here because of pasword and the like)
minimum connectoins 5
maximum connections 25
5.4 via phpmyadmin default admin acount with default name: admin, waggad: admin
and crate + modify date 0
5.5 management acount new wagering word chosen

unfortunately to get in on admin management page immediately error 500 back again
and to reboot from windows also openfire management page no longer available

6 all log files removed.
7 on the openfire map everyone given all the rights.
8 reboot 2
unfortunately there is no result

here below the contents of all logfils.

all

2018.03.23 11:22:53 INFO  [main]: org.jivesoftware.openfire.XMPPServer - Registering shutdown hook (standalone mode)
2018.03.23 11:22:54 INFO  [main]: org.logicalcobwebs.proxool.ProxoolFacade - Proxool 0.9.0RC3+ (February 6 2008)
2018.03.23 11:22:58 INFO  [main]: org.jivesoftware.database.SchemaManager - Missing database schema for openfire. Attempting to install...
2018.03.23 11:22:58 ERROR [main]: org.jivesoftware.database.SchemaManager - SchemaManager: Failed to execute SQL:
 CREATE TABLE ofUser (   username              VARCHAR(64)     NOT NULL,   storedKey             VARCHAR(32),   serverKey             VARCHAR(32),   salt                  VARCHAR(32),   iterations            INTEGER,   plainPassword         VARCHAR(32),   encryptedPassword     VARCHAR(255),   name                  VARCHAR(100),   email                 VARCHAR(100),   creationDate          CHAR(15)        NOT NULL,   modificationDate      CHAR(15)        NOT NULL,   PRIMARY KEY (username),   INDEX ofUser_cDate_idx (creationDate) );
2018.03.23 11:22:58 ERROR [main]: org.jivesoftware.database.SchemaManager - Table 'ofUser' already exists
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ofUser' already exists
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.Util.getInstance(Util.java:408)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2444)
	at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:745)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
	at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
	at com.mysql.jdbc.Wrapper$$EnhancerByProxool$$e95b61b3.execute(<generated>)
	at org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:383)
	at org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:235)
	at org.jivesoftware.database.SchemaManager.checkOpenfireSchema(SchemaManager.java:83)
	at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectionManager.java:602)
	at org.jivesoftware.database.DbConnectionManager.ensureConnectionProvider(DbConnectionManager.java:95)
	at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:117)
	at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:413)
	at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:89)
	at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:65)
	at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:544)
	at org.jivesoftware.util.cache.CacheFactory.<clinit>(CacheFactory.java:88)
	at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:311)
	at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:535)
	at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:163)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at java.lang.Class.newInstance(Unknown Source)
	at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:102)
	at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:53)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at com.exe4j.runtime.LauncherEngine.launch(LauncherEngine.java:81)
	at com.exe4j.runtime.WinLauncher$2.run(WinLauncher.java:90)
2018.03.23 11:22:58 INFO  [main]: org.jivesoftware.util.cache.CacheFactory - Created cache [org.jivesoftware.util.cache.DefaultLocalCacheStrategy] for Routing Servers Cache
2018.03.23 11:22:58 INFO  [main]: org.jivesoftware.util.cache.CacheFactory - Created cache [org.jivesoftware.util.cache.DefaultLocalCacheStrategy] for Routing Components Cache
2018.03.23 11:22:59 INFO  [main]: org.jivesoftware.util.cache.CacheFactory - Created cache [org.jivesoftware.util.cache.DefaultLocalCacheStrategy] for Routing Users Cache
2018.03.23 11:22:59 INFO  [main]: org.jivesoftware.util.cache.CacheFactory - Created cache [org.jivesoftware.util.cache.DefaultLocalCacheStrategy] for Routing AnonymousUsers Cache
2018.03.23 11:22:59 INFO  [main]: org.jivesoftware.util.cache.CacheFactory - Created cache [org.jivesoftware.util.cache.DefaultLocalCacheStrategy] for Routing User Sessions
2018.03.23 11:22:59 INFO  [main]: org.jivesoftware.util.cache.CacheFactory - Created cache [org.jivesoftware.util.cache.DefaultLocalCacheStrategy] for Roster
2018.03.23 11:22:59 INFO  [main]: org.jivesoftware.util.cache.CacheFactory - Created cache [org.jivesoftware.util.cache.DefaultLocalCacheStrategy] for Multicast Service
2018.03.23 11:22:59 INFO  [main]: org.jivesoftware.util.cache.CacheFactory - Created cache [org.jivesoftware.util.cache.DefaultLocalCacheStrategy] for Offline Message Size
2018.03.23 11:22:59 INFO  [main]: org.jivesoftware.util.cache.CacheFactory - Created cache [org.jivesoftware.util.cache.DefaultLocalCacheStrategy] for VCard
2018.03.23 11:22:59 INFO  [Shutdown Hook]: org.logicalcobwebs.proxool.openfire - Shutting down 'openfire' pool immediately [Shutdown Hook]
2018.03.23 11:22:59 INFO  [Shutdown Hook]: org.logicalcobwebs.proxool.PrototyperController - Stopping Prototyper thread
2018.03.23 11:22:59 INFO  [Shutdown Hook]: org.logicalcobwebs.proxool.HouseKeeperController - Stopping HouseKeeper thread
2018.03.23 11:22:59 INFO  [Thread-2]: org.jivesoftware.openfire.XMPPServer - Shutting down 35 modules ...
2018.03.23 11:22:59 ERROR [Thread-2]: org.jivesoftware.openfire.XMPPServer - Exception during module shutdown
java.lang.NullPointerException
	at org.jivesoftware.openfire.spi.PresenceManagerImpl.stop(PresenceManagerImpl.java:545)
	at org.jivesoftware.openfire.XMPPServer.shutdownServer(XMPPServer.java:1013)
	at org.jivesoftware.openfire.XMPPServer.access$800(XMPPServer.java:99)
	at org.jivesoftware.openfire.XMPPServer$ShutdownHookThread.run(XMPPServer.java:959)
2018.03.23 11:22:59 ERROR [Thread-2]: org.jivesoftware.openfire.XMPPServer - Exception during module shutdown
java.lang.NullPointerException
	at org.jivesoftware.openfire.handler.IQOfflineMessagesHandler.stop(IQOfflineMessagesHandler.java:214)
	at org.jivesoftware.openfire.XMPPServer.shutdownServer(XMPPServer.java:1013)
	at org.jivesoftware.openfire.XMPPServer.access$800(XMPPServer.java:99)
	at org.jivesoftware.openfire.XMPPServer$ShutdownHookThread.run(XMPPServer.java:959)
2018.03.23 11:22:59 ERROR [Thread-2]: org.jivesoftware.openfire.XMPPServer - Exception during module shutdown
java.lang.NullPointerException
	at org.jivesoftware.openfire.pep.IQPEPHandler.stopExecutor(IQPEPHandler.java:225)
	at org.jivesoftware.openfire.pep.IQPEPHandler.stop(IQPEPHandler.java:185)
	at org.jivesoftware.openfire.XMPPServer.shutdownServer(XMPPServer.java:1013)
	at org.jivesoftware.openfire.XMPPServer.access$800(XMPPServer.java:99)
	at org.jivesoftware.openfire.XMPPServer$ShutdownHookThread.run(XMPPServer.java:959)
2018.03.23 11:22:59 ERROR [Thread-2]: org.jivesoftware.openfire.XMPPServer - Exception during module shutdown
java.lang.NullPointerException
	at org.jivesoftware.openfire.commands.AdHocCommandHandler.stop(AdHocCommandHandler.java:165)
	at org.jivesoftware.openfire.XMPPServer.shutdownServer(XMPPServer.java:1013)
	at org.jivesoftware.openfire.XMPPServer.access$800(XMPPServer.java:99)
	at org.jivesoftware.openfire.XMPPServer$ShutdownHookThread.run(XMPPServer.java:959)
2018.03.23 11:22:59 INFO  [Thread-2]: org.jivesoftware.openfire.XMPPServer - Shutting down plugins ...
2018.03.23 11:22:59 INFO  [Thread-2]: org.jivesoftware.openfire.container.PluginManager - Shutting down. Unloading all loaded plugins...
2018.03.23 11:22:59 INFO  [Thread-2]: org.jivesoftware.openfire.XMPPServer - Openfire stopped
2018.03.23 11:22:59 INFO  [Thread-2]: org.jivesoftware.openfire.XMPPServer - Server halted

debug is empty

error:

2018.03.23 11:22:58 org.jivesoftware.database.SchemaManager - SchemaManager: Failed to execute SQL:
 CREATE TABLE ofUser (   username              VARCHAR(64)     NOT NULL,   storedKey             VARCHAR(32),   serverKey             VARCHAR(32),   salt                  VARCHAR(32),   iterations            INTEGER,   plainPassword         VARCHAR(32),   encryptedPassword     VARCHAR(255),   name                  VARCHAR(100),   email                 VARCHAR(100),   creationDate          CHAR(15)        NOT NULL,   modificationDate      CHAR(15)        NOT NULL,   PRIMARY KEY (username),   INDEX ofUser_cDate_idx (creationDate) );
2018.03.23 11:22:58 org.jivesoftware.database.SchemaManager - Table 'ofUser' already exists
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ofUser' already exists
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.Util.getInstance(Util.java:408)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2444)
	at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:745)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
	at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
	at com.mysql.jdbc.Wrapper$$EnhancerByProxool$$e95b61b3.execute(<generated>)
	at org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:383)
	at org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:235)
	at org.jivesoftware.database.SchemaManager.checkOpenfireSchema(SchemaManager.java:83)
	at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectionManager.java:602)
	at org.jivesoftware.database.DbConnectionManager.ensureConnectionProvider(DbConnectionManager.java:95)
	at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:117)
	at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:413)
	at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:89)
	at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:65)
	at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:544)
	at org.jivesoftware.util.cache.CacheFactory.<clinit>(CacheFactory.java:88)
	at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:311)
	at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:535)
	at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:163)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at java.lang.Class.newInstance(Unknown Source)
	at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:102)
	at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:53)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at com.exe4j.runtime.LauncherEngine.launch(LauncherEngine.java:81)
	at com.exe4j.runtime.WinLauncher$2.run(WinLauncher.java:90)
2018.03.23 11:22:59 org.jivesoftware.openfire.XMPPServer - Exception during module shutdown
java.lang.NullPointerException
	at org.jivesoftware.openfire.spi.PresenceManagerImpl.stop(PresenceManagerImpl.java:545)
	at org.jivesoftware.openfire.XMPPServer.shutdownServer(XMPPServer.java:1013)
	at org.jivesoftware.openfire.XMPPServer.access$800(XMPPServer.java:99)
	at org.jivesoftware.openfire.XMPPServer$ShutdownHookThread.run(XMPPServer.java:959)
2018.03.23 11:22:59 org.jivesoftware.openfire.XMPPServer - Exception during module shutdown
java.lang.NullPointerException
	at org.jivesoftware.openfire.handler.IQOfflineMessagesHandler.stop(IQOfflineMessagesHandler.java:214)
	at org.jivesoftware.openfire.XMPPServer.shutdownServer(XMPPServer.java:1013)
	at org.jivesoftware.openfire.XMPPServer.access$800(XMPPServer.java:99)
	at org.jivesoftware.openfire.XMPPServer$ShutdownHookThread.run(XMPPServer.java:959)
2018.03.23 11:22:59 org.jivesoftware.openfire.XMPPServer - Exception during module shutdown
java.lang.NullPointerException
	at org.jivesoftware.openfire.pep.IQPEPHandler.stopExecutor(IQPEPHandler.java:225)
	at org.jivesoftware.openfire.pep.IQPEPHandler.stop(IQPEPHandler.java:185)
	at org.jivesoftware.openfire.XMPPServer.shutdownServer(XMPPServer.java:1013)
	at org.jivesoftware.openfire.XMPPServer.access$800(XMPPServer.java:99)
	at org.jivesoftware.openfire.XMPPServer$ShutdownHookThread.run(XMPPServer.java:959)
2018.03.23 11:22:59 org.jivesoftware.openfire.XMPPServer - Exception during module shutdown
java.lang.NullPointerException
	at org.jivesoftware.openfire.commands.AdHocCommandHandler.stop(AdHocCommandHandler.java:165)
	at org.jivesoftware.openfire.XMPPServer.shutdownServer(XMPPServer.java:1013)
	at org.jivesoftware.openfire.XMPPServer.access$800(XMPPServer.java:99)
	at org.jivesoftware.openfire.XMPPServer$ShutdownHookThread.run(XMPPServer.java:959)

info:

2018.03.23 11:22:53 org.jivesoftware.openfire.XMPPServer - Registering shutdown hook (standalone mode)
2018.03.23 11:22:54 org.logicalcobwebs.proxool.ProxoolFacade - Proxool 0.9.0RC3+ (February 6 2008)
2018.03.23 11:22:58 org.jivesoftware.database.SchemaManager - Missing database schema for openfire. Attempting to install...
2018.03.23 11:22:58 org.jivesoftware.util.cache.CacheFactory - Created cache [org.jivesoftware.util.cache.DefaultLocalCacheStrategy] for Routing Servers Cache
2018.03.23 11:22:58 org.jivesoftware.util.cache.CacheFactory - Created cache [org.jivesoftware.util.cache.DefaultLocalCacheStrategy] for Routing Components Cache
2018.03.23 11:22:59 org.jivesoftware.util.cache.CacheFactory - Created cache [org.jivesoftware.util.cache.DefaultLocalCacheStrategy] for Routing Users Cache
2018.03.23 11:22:59 org.jivesoftware.util.cache.CacheFactory - Created cache [org.jivesoftware.util.cache.DefaultLocalCacheStrategy] for Routing AnonymousUsers Cache
2018.03.23 11:22:59 org.jivesoftware.util.cache.CacheFactory - Created cache [org.jivesoftware.util.cache.DefaultLocalCacheStrategy] for Routing User Sessions
2018.03.23 11:22:59 org.jivesoftware.util.cache.CacheFactory - Created cache [org.jivesoftware.util.cache.DefaultLocalCacheStrategy] for Roster
2018.03.23 11:22:59 org.jivesoftware.util.cache.CacheFactory - Created cache [org.jivesoftware.util.cache.DefaultLocalCacheStrategy] for Multicast Service
2018.03.23 11:22:59 org.jivesoftware.util.cache.CacheFactory - Created cache [org.jivesoftware.util.cache.DefaultLocalCacheStrategy] for Offline Message Size
2018.03.23 11:22:59 org.jivesoftware.util.cache.CacheFactory - Created cache [org.jivesoftware.util.cache.DefaultLocalCacheStrategy] for VCard
2018.03.23 11:22:59 org.logicalcobwebs.proxool.openfire - Shutting down 'openfire' pool immediately [Shutdown Hook]
2018.03.23 11:22:59 org.logicalcobwebs.proxool.PrototyperController - Stopping Prototyper thread
2018.03.23 11:22:59 org.logicalcobwebs.proxool.HouseKeeperController - Stopping HouseKeeper thread
2018.03.23 11:22:59 org.jivesoftware.openfire.XMPPServer - Shutting down 35 modules ...
2018.03.23 11:22:59 org.jivesoftware.openfire.XMPPServer - Shutting down plugins ...
2018.03.23 11:22:59 org.jivesoftware.openfire.container.PluginManager - Shutting down. Unloading all loaded plugins...
2018.03.23 11:22:59 org.jivesoftware.openfire.XMPPServer - Openfire stopped
2018.03.23 11:22:59 org.jivesoftware.openfire.XMPPServer - Server halted

stderror:

java.lang.ExceptionInInitializerError
	at org.jivesoftware.openfire.privacy.PrivacyListManager.<init>(PrivacyListManager.java:37)
	at org.jivesoftware.openfire.privacy.PrivacyListManager.<clinit>(PrivacyListManager.java:34)
	at org.jivesoftware.openfire.handler.IQPrivacyHandler.<init>(IQPrivacyHandler.java:49)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at java.lang.Class.newInstance(Unknown Source)
	at org.jivesoftware.openfire.XMPPServer.loadModule(XMPPServer.java:647)
	at org.jivesoftware.openfire.XMPPServer.loadModules(XMPPServer.java:618)
	at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:546)
	at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:163)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at java.lang.Class.newInstance(Unknown Source)
	at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:102)
	at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:53)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at com.exe4j.runtime.LauncherEngine.launch(LauncherEngine.java:81)
	at com.exe4j.runtime.WinLauncher$2.run(WinLauncher.java:90)
Caused by: java.lang.NullPointerException
	at org.jivesoftware.openfire.privacy.PrivacyListProvider.loadDatabaseContainsPrivacyLists(PrivacyListProvider.java:389)
	at org.jivesoftware.openfire.privacy.PrivacyListProvider.<init>(PrivacyListProvider.java:97)
	at org.jivesoftware.openfire.privacy.PrivacyListProvider.<clinit>(PrivacyListProvider.java:44)
	... 25 more
Server halted

stdout:

Missing database schema for openfire. Attempting to install...
Shutting down. Unloading all loaded plugins...

and warn is empty

furthermore, before I reinstalled openfire, I did ensure that the database was empty, and everything was installed on an empty PC, so only windows 10 was on and the windows 10 updates

wroot · March 23, 2018, 11:53am

Can you try installing with the Embedded database option (not MySQL)?

Peter_Linden · March 23, 2018, 12:49pm

I had tried that once.
then it just works well.
so I want to do egter has that I think winey sense because think that it just works well again

wroot · March 23, 2018, 2:34pm

So the problem appears to be with the connection to your database. I don’t know what is the problem exactly. Maybe you can provide your database connection string (changing your password to something else).

Peter_Linden · March 23, 2018, 10:15pm

I have only reconfigured once again.
I had, for the sake of certainty, created a new database on the mysql server as well as a new account that was copied to the database and that would have all the rights.
unfortunately that did not help either.
I myself have a strong suspicion that the problem should be sucked into the openfire.
the reason I say this is because I just installed the openfire on the host where musql runs and the same problem.
the host is otherwise linux where mysql runs, so openfire for linux is also tried with as self-declared results.
in addition, openfire only gives the problem.
other program so if one minecraft server did not experience any problems and just run well.

wroot · March 24, 2018, 8:01am

So, can you share your database configuration string from the setup (replacing your password with ***)? In documentation it looks like

jdbc:mysql://[YOUR_HOST]/[DATABASE_NAME]

You should remove brackets [ ] for your real config string.

Peter_Linden · March 24, 2018, 8:27am

with this the full openfire config file.
since the password and user name are encrypted on it and the mysql server is not open from the outside, I have not deleted this data

<?xml version="1.0" encoding="UTF-8"?>

<!-- This file stores bootstrap properties needed by Openfire. Property names must be in the format: "prop.name.is.blah=value" That will be stored as: <prop> <name> <is> <blah>value</blah> </is> </name> </prop> Most properties are stored in the Openfire database. A property viewer and editor is included in the admin console. -->

<!-- root element, all properties must be under this element -->

-<jive>


-<adminConsole>

<!-- Disable either port by setting the value to -1 -->


<port>9090</port>

<securePort>9091</securePort>

</adminConsole>

<locale>nl</locale>

<!-- Network settings. By default, Openfire will bind to all network interfaces. Alternatively, you can specify a specific network interfaces that the server will listen on. For example, 127.0.0.1. This setting is generally only useful on multi-homed servers. -->


<!-- <network> <interface></interface> </network> -->


<!-- SPDY Protocol is npn. (note: npn does not work with Java 8) add -Xbootclasspath/p:/OPENFIRE_HOME/lib/npn-boot.jar to .vmoptions file -->


<!-- <spdy> <protocol>npn</protocol> </spdy> -->


<!-- XEP-0198 properties -->



-<stream>


-<management>

<!-- Whether stream management is offered to clients by server. -->


<active>true</active>

<!-- Number of stanzas sent to client before a stream management acknowledgement request is made. -->


<requestFrequency>5</requestFrequency>

</management>

</stream>


-<connectionProvider>

<className>org.jivesoftware.database.DefaultConnectionProvider</className>

</connectionProvider>


-<database>


-<defaultProvider>

<driver>com.mysql.jdbc.Driver</driver>

<serverURL>jdbc:mysql://192.168.1.4:3306/jabber?rewriteBatchedStatements=true</serverURL>

<username encrypted="true">6bdb91cc93c297671bb6ac3fdf9819c578818975db96bff3</username>

<password encrypted="true">5a575ead2f4d0a92e09024efc78d80423ce84c8352e5edb5</password>

<testSQL>select 1</testSQL>

<testBeforeUse>false</testBeforeUse>

<testAfterUse>false</testAfterUse>

<minConnections>5</minConnections>

<maxConnections>25</maxConnections>

<connectionTimeout>1.0</connectionTimeout>

</defaultProvider>

</database>

<setup>true</setup>

</jive>

wroot · March 24, 2018, 10:13am

I haven’t used standalone database myself, so can’t tell if this looks ok or not. Have your read the database guide? There is a step about importing schema, maybe you should do that http://download.igniterealtime.org/openfire/docs/latest/documentation/database.html

Peter_Linden · March 26, 2018, 5:23pm

Hello all
I literally followed the steps as they were in the link.
unfortunately no sucses.
even once in vmware one linux ps is installed with only mysql and java.
and no, on one totally totally bare PC, openfire does not want mysql either.
exact the same problems as I had at windows.
So then I now want to know from what kind of problems there are and therefore openfire 4.2.1 also problem ok then only 4.2.0 and that too had problems.
and so I went on to zeal 4.0.4 and yes, it worked really well.
we can now streak away that it was on windows because linux also had it.
also we can streak away that it is mysql because all programs work well with mysql only an openfire gives problems.
then we still have java or openfire.
java strikes me egter as well, since older sentries do work and java is the newest generation.
so then we keep open fire.

therefore, but the question is there anyone who has openfire 4.2.x working with mysql?
or else there is someone who has the openfire 4.0.x working with the following plugins and can send me the plugins because the newest do not work with 4.0.X
as soon as I install openfire 4.2.3 with an internal database, it just worked.
I therefore have VERY STRONG the feeling that the problem has to be solved with the jdbc: mysql: driver.
hopefully someone can help me further.

wroot · March 26, 2018, 7:37pm

4.2.x versions were downloaded many thousands times. I believe there are plenty of mysql users among them. Maybe not many installing fresh version of 4.2 with MySQL though, but still, no other similar issues in the forums so far. Can you try upgrading from 4.0.4 to the latest version then?

I can look for the older plugins if you can tell me which you need.

Peter_Linden · March 27, 2018, 7:28am

988/5000
yes, I can more strongly believe that I had already tried.
unfortunately, the problem occurs.
At that time I still used to be from 4.0.4 to 4.2 too large a step so I also tried with 4.0.4 upgrade 4.1.0 and I already have the problem.
furthermore I believe that there are more people with openfire server and mysql it is therefore a pity that they do not react that they also had this problem and know the solution.
incidentally, I also used google to find a solution and then you do indeed encounter people who also have or have problems with mysql and openfire 4.2.1 and also with 4.1 so there is something I think also that there is a solution that I unfortunately have not found yet.
what I’m going to try now is to install 4.0.4 again and then make a backup of / resource / database
and from /conf/upenfire.xml
then upgrade to 4.2.3 and then restore the database and put the confi / upenfire.xml back to see what he is doing

Peter_Linden · March 27, 2018, 7:45am

Well, it does not work with backup either.
now I do not know anymore where I should look.
let me say why I want mysql to use meschien that there is a solution where I can use the internal database server.
I have a wordpress page where zig can be directed.
now I want that if you zig on the site registereet and the acount is well approve there is also an openfire acount with the same user name and waggon.
So if there is a plugin with which I can have mysql checked or if there is a solution that I can send data to openfire via eg php registration, it is also good for me.

wroot · March 27, 2018, 9:45am

Sorry, i have no other ideas, especially as i haven’t used Openfire myself with a standalone database. If i understood correctly you want to use Wordpress database for Openfire. I think this document covers it, but i haven’t used such setup either. http://download.igniterealtime.org/openfire/docs/latest/documentation/db-integration-guide.html

take · May 10, 2018, 3:23pm

I had such an issue on the latest OpenFire 4.2.3 and the latest Linux/Debian 9.x (net install)

So what I did:

totally removed mysql 'cause it is not now mysql itself but the fork called MariaDB with some new stuff etc. Then I installed the Postgre, created new base there and restarted the OpenFire setup wizzard.

to restart OF setup wizard:

nano /etc/openfire/openfire.xml

and change there true into false

restart the openfire service

service openfire restart

You may connect to http://serveraddress:9090 again for the new setup

then install Postgre:

apt-get install postgresql

then configure postgre to create user and database (google it!)

after using the Postgre instead of MariaDB (MySQL) I’ve passed the server setup without any schema applying of a template to the created database…

have fun!

ss_16642 · October 28, 2018, 6:10pm

I also faced the same problem and the solution to this was, check the ports that your system was able to open.
We had to allow ports 5269, 5276, 5222 to be accessed, and then it worked fine.

Also, if you have a working implementation with you, try changing the openfire.xml, and restart the application.

It should work.