9 Replies Latest reply on Aug 14, 2017 8:08 AM by wroot

    Unknown Connection Error

    Chris

      I can login to Spark from the workstation that has the server on it with no problem.  However whenever I attempt to login from another workstation on the same network it gives me "Unknown Connection Error."  The log is below.  However I have all of the same settings as the one that works.

       

      Aug 10, 2017 12:45:44 PM org.jivesoftware.spark.util.log.Log warning

      WARNING: Exception in Login:

      org.jivesoftware.smack.SmackException$ConnectionException: The following addresses failed: 'dcroot.gosy.com:8222' failed because java.net.ConnectException: Connection timed out: connect

      at org.jivesoftware.smack.SmackException$ConnectionException.from(SmackException.j ava:255)

      at org.jivesoftware.smack.tcp.XMPPTCPConnection.connectUsingConfiguration(XMPPTCPC onnection.java:612)

      at org.jivesoftware.smack.tcp.XMPPTCPConnection.connectInternal(XMPPTCPConnection. java:850)

      at org.jivesoftware.smack.AbstractXMPPConnection.connect(AbstractXMPPConnection.ja va:364)

      at org.jivesoftware.LoginDialog$LoginPanel.login(LoginDialog.java:1107)

      at org.jivesoftware.LoginDialog$LoginPanel.access$900(LoginDialog.java:335)

      at org.jivesoftware.LoginDialog$LoginPanel$3.construct(LoginDialog.java:894)

      at org.jivesoftware.spark.util.SwingWorker.lambda$new$1(SwingWorker.java:138)

      at java.lang.Thread.run(Unknown Source)

        • Re: Unknown Connection Error
          wroot

          Connection times out. Either a networking issue or a firewall. Btw, do you really have the port on 8222? By default it is 5222.

            • Re: Unknown Connection Error
              McLaren Matt

              Hi

               

              Maybe that's why they're having a problem connecting, the port has been changed, prior to the port used by the clients.

              • Re: Unknown Connection Error
                Chris

                Good morning,

                 

                I don't have any problems with the network other than with this application.  I've also added Spark to the "allow apps through firewall" on each workstation that I've attempted this on (so far I'm up to three). 

                 

                As for the port, I had to switch it off the default as that had something else on it that would have been more of a pain to reconfigure than this would be.

                  • Re: Unknown Connection Error
                    wroot

                    I get that dcroot.gosy.com is the name of the server hosting Openfire. On Admin Console'e first page what is the value of XMPP Domain?

                      • Re: Unknown Connection Error
                        Chris

                        I switched that to see if it was routing but when it's gosy.com (which is what the XMPP Domain is) it changes nothing.  It still times out.

                          • Re: Unknown Connection Error
                            wroot

                            If your xmpp domain is gosy.com, this is the only thing you should put in Spark. Is gosy.com resolvable in your network (is in your DNS)? Can you ping it by gosy.com name? If not, you can try a workaround. Put gosy.com as domain in Spark, then go to Advanced menu and put IP of the server into Host field.

                              • Re: Unknown Connection Error
                                Chris

                                Yes it's the DNS. Pinging gives times<1ms  TTL=128.  Domain is not gosy.com and the Host is 127.0.01:9090.  Error is now "Can't connect to server: invalis name or server is not reachable."

                                 

                                2017.08.14 08:23:17 hsqldb.db..ENGINE - could not reopen database

                                org.hsqldb.HsqlException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@c69e02e3[file =C:\Program Files (x86)\Openfire\embedded-db\openfire.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2017-08-14 12:23:16 heartbeat - read: -22 ms.

                                at org.hsqldb.error.Error.error(Unknown Source)

                                at org.hsqldb.error.Error.error(Unknown Source)

                                at org.hsqldb.persist.LockFile.newLockFileLock(Unknown Source)

                                at org.hsqldb.persist.Logger.acquireLock(Unknown Source)

                                at org.hsqldb.persist.Logger.open(Unknown Source)

                                at org.hsqldb.Database.reopen(Unknown Source)

                                at org.hsqldb.Database.open(Unknown Source)

                                at org.hsqldb.DatabaseManager.getDatabase(Unknown Source)

                                at org.hsqldb.DatabaseManager.newSession(Unknown Source)

                                at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)

                                at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)

                                at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)

                                at java.sql.DriverManager.getConnection(Unknown Source)

                                at java.sql.DriverManager.getConnection(Unknown Source)

                                at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)

                                at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)

                                at org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:211 )

                                at org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89)

                                at java.sql.DriverManager.getConnection(Unknown Source)

                                at java.sql.DriverManager.getConnection(Unknown Source)

                                at org.jivesoftware.database.EmbeddedConnectionProvider.getConnection(EmbeddedConn ectionProvider.java:64)

                                at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:129)

                                at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:357)

                                at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:88)

                                at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:66)

                                at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:548)

                                at org.jivesoftware.util.cache.CacheFactory.<clinit>(CacheFactory.java:94)

                                at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:311)

                                at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:415)

                                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:105)

                                at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:56)

                                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:65)

                                at com.exe4j.runtime.WinLauncher.main(WinLauncher.java:101)

                                at com.install4j.runtime.launcher.WinLauncher.main(WinLauncher.java:26)

                                  • Re: Unknown Connection Error
                                    wroot

                                    This is confusing. If it is in the DNS, why you say it's not the domain? It should be the domain of Openfire, if you want to use gosy.com as domain in Spark. Unless you are confusing this with Windows/AD domain. That's a different thing. I don't get either why you mention the localhost IP address (127.0.0.1:9090). You can use this to login to Admin Console on the server itself. Otherwise this is of no use to you. Lastly, the error you have posted is the usual error when one tries to run Openfire a few times (e.g. it is already running as a service and one runs the launcher also, then the two processes can't share one database and the database lock acquisition failure error occurs).

                                     

                                    1. If you have Openfire already running as a service. Do not even touch the launcher. It is already running, no need to use the launcher.

                                    2. Make screenshot of the first page of Admin Console, so we can see is it really true that gosy.com is your XMPP domain.