17 Replies Latest reply on Oct 5, 2007 11:29 AM by Aznidin

    Can't Logon To Admin Console On More Than One Cluster Nodes At A Time

    Aznidin

      I'm running 2 cluster nodes. Login on to the admin console on one node will cancel the login session of the other admin console on the other node. Is this correct?

        • Re: Can't Logon To Admin Console On More Than One Cluster Nodes At A Time
          Gaston Dombiak

          Hmm, that shouldn't happen. Logins to the admin console are totally local (i.e. unrelated in a cluster). Do you see any error in the log files? Are you using LDAP to store the users? Info on how to reproduce this would be great.

           

          Thanks,

           

            -- Gato

            • Re: Can't Logon To Admin Console On More Than One Cluster Nodes At A Time
              Aznidin

              Hey Gato,

               

               

               

              I'm accessing the admin console through NAT. Access to 9091 will go to 9091 of one node, and 9090 to 9090 of the other node. I open 2 browsers, one for each node. Both browsers point to "Server->Clustering" pages. I refresh one of them, then refresh the other... alternately refreshing one after another. I have to login on every refresh.

               

              2007.10.05 06:05:30 [com.jivesoftware.openfire.enterprise.stats.RrdSqlBackend.exists(RrdSqlBackend.java:190)] Error while accessing information in database: java.sql.SQLException: Table 'openfire.entRRDs' doesn't exist
              2007.10.05 06:05:30 [com.jivesoftware.openfire.enterprise.stats.StatsEngine$SampleTask.run(StatsEngine.java:359)] Error sampling for statistic sessions
              java.io.FileNotFoundException: Could not open sessions [non existent]
              at org.jrobin.core.RrdDb.<init>(Unknown Source)
              at org.jrobin.core.RrdDb.<init>(Unknown Source)
              at com.jivesoftware.openfire.enterprise.stats.StatsEngine$SampleTask.run(StatsEngine.java:323)
              at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
              at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
              at java.util.concurrent.FutureTask.run(Unknown Source)
              at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
              at java.lang.Thread.run(Unknown Source)
              2007.10.05 06:05:30 [com.jivesoftware.openfire.enterprise.stats.RrdSqlBackend.exists(RrdSqlBackend.java:190)] Error while accessing information in database: java.sql.SQLException: Table 'openfire.entRRDs' doesn't exist
              2007.10.05 06:05:30 [com.jivesoftware.openfire.enterprise.stats.StatsEngine$SampleTask.run(StatsEngine.java:359)] Error sampling for statistic server_bytes_in
              java.io.FileNotFoundException: Could not open server_bytes [non existent]
              at org.jrobin.core.RrdDb.<init>(Unknown Source)
              at org.jrobin.core.RrdDb.<init>(Unknown Source)
              at com.jivesoftware.openfire.enterprise.stats.StatsEngine$SampleTask.run(StatsEngine.java:323)
              at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
              at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
              at java.util.concurrent.FutureTask.run(Unknown Source)
              at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
              at java.lang.Thread.run(Unknown Source)
              2007.10.05 06:05:30 [com.jivesoftware.openfire.enterprise.stats.RrdSqlBackend.exists(RrdSqlBackend.java:190)] Error while accessing information in database: java.sql.SQLException: Table 'openfire.entRRDs' doesn't exist
              2007.10.05 06:05:30 [com.jivesoftware.openfire.enterprise.stats.StatsEngine$SampleTask.run(StatsEngine.java:359)] Error sampling for statistic conversations
              java.io.FileNotFoundException: Could not open conversations [non existent]
              at org.jrobin.core.RrdDb.<init>(Unknown Source)
              at org.jrobin.core.RrdDb.<init>(Unknown Source)
              at com.jivesoftware.openfire.enterprise.stats.StatsEngine$SampleTask.run(StatsEngine.java:323)
              at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
              at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
              at java.util.concurrent.FutureTask.run(Unknown Source)
              at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
              at java.lang.Thread.run(Unknown Source)
              2007.10.05 06:05:30 [com.jivesoftware.openfire.enterprise.stats.RrdSqlBackend.exists(RrdSqlBackend.java:190)] Error while accessing information in database: java.sql.SQLException: Table 'openfire.entRRDs' doesn't exist
              2007.10.05 06:05:30 [com.jivesoftware.openfire.enterprise.stats.StatsEngine$SampleTask.run(StatsEngine.java:359)] Error sampling for statistic muc_occupants
              java.io.FileNotFoundException: Could not open muc_occupants [non existent]
              at org.jrobin.core.RrdDb.<init>(Unknown Source)
              at org.jrobin.core.RrdDb.<init>(Unknown Source)
              at com.jivesoftware.openfire.enterprise.stats.StatsEngine$SampleTask.run(StatsEngine.java:323)
              at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
              at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
              at java.util.concurrent.FutureTask.run(Unknown Source)
              at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
              at java.lang.Thread.run(Unknown Source)
              

               

              No, I don't use LDAP.

                • Re: Can't Logon To Admin Console On More Than One Cluster Nodes At A Time
                  Gaston Dombiak

                  Hey Aznidin,

                   

                  I also use to connect to each node and refresh the page to see the load on each node but that does not forces to to log in for each refresh. Could it be that the NAT has something to do with it? Do you see the same problem even when navigating the admin console or only in the cluster page?

                   

                  BTW, the error log shows that the DB does not have the entRRDs table. How was your DB created? Did you create it from scratch or is this an upgrade from a 3.3.* installation? And which database and version are you using?

                   

                  Thanks,

                   

                  -- Gato

                    • Re: Can't Logon To Admin Console On More Than One Cluster Nodes At A Time
                      Aznidin

                      I also use to connect to each node and refresh the page to see the load on each node but that does not forces to to log in for each refresh. Could it be that the NAT has something to do with it? Do you see the same problem even when navigating the admin console or only in the cluster page?

                      Navigations also produce the same behavior. I have to relogin. However, it doesn't seem to have direct relation to the error messages. I'll check on this one later and try to reproduce again. Probably some side effect of the missing db table.

                       

                      BTW, the error log shows that the DB does not have the entRRDs table. How was your DB created? Did you create it from scratch or is this an upgrade from a 3.3.* installation? And which database and version are you using?

                      It was a fresh install and for that I used the script in /opt/openfire/resources/database/openfire_mysql.sql. That script doesn't have entRRDs.

                        • Re: Can't Logon To Admin Console On More Than One Cluster Nodes At A Time
                          Gaston Dombiak
                          aznidin wrote:

                          BTW, the error log shows that the DB does not have the entRRDs table. How was your DB created? Did you create it from scratch or is this an upgrade from a 3.3.* installation? And which database and version are you using?

                          It was a fresh install and for that I used the script in /opt/openfire/resources/database/openfire_mysql.sql. That script doesn't have entRRDs.

                           

                          That's right. The open source version does not define that table. That table is created and used by the Enterprise plugin. Could you check the script located in openfire\plugins\enterprise\database? You should find there the enterprise_mysql.sql file that defines the entRRDs table. That script also adds a new row to the jiveVersion table with value 'enterprise' and 9.

                           

                          Thanks,

                           

                            -- Gato