powered by Jive Software

Database could not be accessed

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.(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.(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

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?

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?

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.

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

org.jivesoftware.database.EmbeddedConnectionProvider

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

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.

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?

All files are important, though the main data is in the script file. No, the system won’t recreate it. One would have to rerun the setup to create new one. I think it is better to just restore the whole wildfire folder.