In previous version of the openfire (3.9.3, 4.1.2) It is possible have command line access via sqltool.jar when the openfire server is down. (https://confluence.atlassian.com/bamkb/how-to-access-embedded-hsql-database-via-command-line-847749291.html)
With Openfire 4.5.2, using same tool It seems that the connection to the openfire DB with “sa” user fails. On the other hand it is possible to view embedded database using embedded-db-viewer.sh with “sa” user.