7 Replies Latest reply on Sep 20, 2017 8:17 PM by wroot

    Database could not be accessed

    Samuel

      Hello,

       

      I need help, since 2 days ago all my users cannot login to wildfire using pandion. I also cannot access web admin console.

      When I check the error log it because the database cannot be accessed.

       

      -------------------------------------------------------------------------------- ------------------------------------------------------

      2017.09.19 14:51:56 [org.jivesoftware.wildfire.XMPPServer.verifyDataSource(XMPPServer.java:620)

      ] Database could not be accessed

      java.lang.NullPointerException

          at org.jivesoftware.wildfire.XMPPServer.verifyDataSource(XMPPServer.java:610)

          at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:369)

          at org.jivesoftware.wildfire.XMPPServer.<init>(XMPPServer.java:147)

          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.newInstance0(Unknown Source)

          at java.lang.Class.newInstance(Unknown Source)

          at org.jivesoftware.wildfire.starter.ServerStarter.start(ServerStarter.java:93)

          at org.jivesoftware.wildfire.starter.ServerStarter.main(ServerStarter.java:49)

          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(Unknown Source)

          at com.exe4j.runtime.WinLauncher.main(Unknown Source)

      2017.09.19 14:51:56 [org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:405)

      ]

      java.lang.IllegalArgumentException: java.lang.NullPointerException

          at org.jivesoftware.wildfire.XMPPServer.verifyDataSource(XMPPServer.java:621)

          at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:369)

          at org.jivesoftware.wildfire.XMPPServer.<init>(XMPPServer.java:147)

          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.newInstance0(Unknown Source)

          at java.lang.Class.newInstance(Unknown Source)

          at org.jivesoftware.wildfire.starter.ServerStarter.start(ServerStarter.java:93)

          at org.jivesoftware.wildfire.starter.ServerStarter.main(ServerStarter.java:49)

          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(Unknown Source)

          at com.exe4j.runtime.WinLauncher.main(Unknown Source)

      Caused by: java.lang.NullPointerException

          at org.jivesoftware.wildfire.XMPPServer.verifyDataSource(XMPPServer.java:610)

          ... 16 more

      -------------------------------------------------------------------------------- ------------------------------------------------------

       

      Thank You.

      Samuel

        • Re: Database could not be accessed
          wroot

          What database are you using? Can you connect to that database with the same user using other means/tools (not with Wildfire)?

           

          Btw, Wildfire? That is super old. What version are you even using?

            • Re: Database could not be accessed
              Samuel

              wildfire version 3.1.1

              I don't know what database is used and where is the location of the database.

              where can i check what database used?

                • Re: Database could not be accessed
                  wroot

                  Stop Wildfire, go to installation folder and check if there is embedded-db folder and if it has files inside. If so, then you use internal database and you can try deleting lck file if there is one, then start Wildfire again. You can also check /conf/wildfire.xml (if i remember correctly what was the name of that file back then.. now it is called openfire.xml, it can also be named conf.xml or something similar), you can open it and check the database connection string, which should tell you what database is in use and maybe even where it is located.

                    • Re: Database could not be accessed
                      Samuel

                      Yes, there is a folder named embedded-db and there are 3 files wildfire.log, wildfire.properties, wildfire.script and i didn't find lck file in it.

                       

                      Yes, i also found file wildfire.xml in conf folder and when i opened the file there is connection string

                       

                      <connectionProvider>

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

                      </connectionProvider>

                       

                      Is there something wrong with the db connection string or maybe problem with database?

                        • Re: Database could not be accessed
                          wroot

                          That error doesn't say much to me. I guessed maybe that's the left over lck file issue, but you haven't found one. So i don't have any ideas. The connection string looks fine. Try thinking what have changed two days ago. Maybe you have backup that you can restore.

                            • Re: Database could not be accessed
                              Samuel

                              database locate in embedded-db folder right, which one is the database file?, is it wildfire.log, wildfire.properties, or wildfire.script? Will the system recreate database file after i rename the old one?

                               

                              If i have the backup, which folder do i have to restore? Do i have to restore all wildfire folder or just embedded-db folder?