OK, installed MSSQL 2019 Express, Created database called Openfire, ran MSSQL script from install directory. Worked through installing openfire 4.6 and did run into problems with trying to use windows authentication during setup. So in the middle of the setup I created an SQL user using SQL authentication and that seemed to let me get based the database install screen, so thought things were going pretty good.
Well finished AD integrations, etc… got things up and running, Installed a few plugin’s, and when I installed the Monitoring plugin (archive) all thing seemed to go OK there.
But, i have no messages being saved (can’t search and find any).
When I look at the logs it complains that the ofMessageArchive table is not in the database. Sure enough looking at the database it is not there.
So, where do I go from here to get message archiving to work. I’ve got everything else pretty much working