The Auditing tab is now missing after rebooting the server. No changes made to OF. I did, however, browse the database using MySQL Workbench 8.0 CE. I was looking to see how to run search queries but made no changes to the tables that I know of. I am NOT a SQL dba but I would like to know how to fix the following error I captured from the OF server logs…
2025.03.14 11:32:52 ERROR [TaskEngine-pool-202]: org.jivesoftware.openfire.audit.spi.AuditorImpl - Internal server error
java.lang.NullPointerException: null
at org.jivesoftware.openfire.audit.spi.AuditorImpl.createAuditFile(AuditorImpl.java:351) ~[xmppserver-4.7.5.jar:4.7.5]
at org.jivesoftware.openfire.audit.spi.AuditorImpl.prepareAuditFile(AuditorImpl.java:216) ~[xmppserver-4.7.5.jar:4.7.5]
at org.jivesoftware.openfire.audit.spi.AuditorImpl.saveQueuedPackets(AuditorImpl.java:399) ~[xmppserver-4.7.5.jar:4.7.5]
at org.jivesoftware.openfire.audit.spi.AuditorImpl.access$200(AuditorImpl.java:56) ~[xmppserver-4.7.5.jar:4.7.5]
at org.jivesoftware.openfire.audit.spi.AuditorImpl$SaveQueuedPacketsTask.run(AuditorImpl.java:386) [xmppserver-4.7.5.jar:4.7.5]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_202]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_202]
Any assistance is greatly appreciated.