I’m fairly familiar with XMPP/Jabber, and have setup Openfire/Spark in another organization in the not so distant past. Recently I started at new company, and they have a widely used Openfire/Spark implemenation, but no one in IT seems to know the admin login — as the last admin just up and walked off last fall.
I believe this implementation is using the embedded-db / hsqldb.
I took a look at the contents of the …/embedded-db/openfire.script and grep’d for “admin” and I can see instances of OFUSERS VALUES (with admin.authorizedJIDs), but none of those work, and the passwords are encrypted anyways. I do see a ldap.Admin that points back to an Openfire account sitting in AD (and it shows a password in plaintext) but this doesnt work either.
so I’m wondering:
how do I get into the HSQLDB – especially if I dont have the credentials? I know mysql has some password recovery mechanisms.
is there anyway to get an account added as admin in Openfire? seems like an existing account would have to be added as admin, rather than creating a new one? I saw that you can modify the …/conf/openfire.xml file, but this doesnt look like its even being used… it looks like the default file.
Any help or suggestions is greatly appreciated.