- Shut down Openfire
- As the Windows Administrator,
C:\Program Files (x86)\Openfire\embedded-db\openfire.script
- Change the line that looks something like this
INSERT INTO OFUSER VALUES('admin',NULL,'<hex string>', 'Administrator','admin','0','0')
INSERT INTO OFUSER VALUES('admin','<new password>',NULL, 'Administrator','admin','0','0')
- Save the file, exit the editor
- Restart Openfire
Maybe this is just me but...well...I'd actually rather not deal with that alternative so I'm assuming that this is Openfire's problem problem and not mine.
OK, so for the upteenth time*, I lost the admin password on my Openfire installation. Openfire is like the most user friendly XMPP server out there...that I know of...and I know of like 2 others so this one must be really, like, user friendly. Anyhow, so I lost my admin login...again...and I tried to figure out how I could change that password without having to reinstall Openfire.
This applies to the Windows installation with an embedded database. If you are using a real operating system and a real database, you probably don't have this problem. If you do then it's because of you...not me.**
At any rate, if you're really unfortunate (read, me), then you are running on the the very interesting and very secure operating system that is Microsoft Vista. In that case, you may find that Openfire is squatting in the following directory:
Yes, it uses that font rather than courier. Really.
What's more, the embedded database lives in
Note that Vista took out the blank in just about everywhere except for the programs directory.
This makes it more secure.
I mean, why else would they have done it?
At this point, a stand-up comic would make an observation about how they recently had a child and wait politely for the audience to applaud. The idea is to get the audience on your side by a) pointing out that you recently had a child and b) that you have been without sleep and c) are running Microsoft Vista and d) are on the edge and e) that not applauding could very well push you over the edge and f) whatever.
Now then, the embedded database does everything in memory except that it loads everything at startup. Actually, I'm not sure if that's what it does at all, but it looks that way; and, since I'm the sort of person who forgets their admin login at the drop of a hat, I'm obviously the sort of person that you should listen to.***
* = which is, by the way, not because of me.
** = this has been verified by ltsllc.com. Which is affiliated with me. So therefore it's probably not objective.
*** = if you believe this and have a lot of money to waste on consultants, please contact me.
**** = if you believe or even if you don't, but you are willing to pay this amount for at least a year and you don't expect to get anything useful out of it, please contact me.*****
***** = P.S. to the previous note, you are also required to actually have that much money and be willing to give it to me in advance before contacting me.
****** = except that you leave off the exclamation point. See, there really is a reason to pay me lots of money.
******* = except you were probably able to spell "italics" correctly on the first try. Teacher's pet.
******** = see points above about giving me lots of money.
********* = does anyone else actually read footnotes?