Adding or deleting admin accounts to Openfire

After a standard installation using the xmpp.domain example.com you will have one admin. The admin permissions are stored in the database in the OFPROPERTY table: “admin.authorizedJIDs”="admin@example.com". If you want to add or remove an admin you can either use the web UI and

  • change the system property “admin.authorizedJIDs” (separate multiple admins with a comma “,”).
  • change the user properties and select “Is Administrator?”.

Or you stop Openfire and edit either the database with SQL commands

DELETE FROM OFPROPERTY WHERE NAME='admin.authorizedJIDs';
INSERT INTO OFPROPERTY VALUES('admin.authorizedJIDs','admin@example-com,new@example.com');
COMMIT;

or add

<?xml version="1.0" encoding="UTF-8"?>
<jive>
    ...
    <admin>
        <authorizedJIDs>admin@example.com, new@example.com</authorizedJIDs>
    </admin>
    ...

to conf/openfire.xml and start Openfire again.

2 Likes

It saved me a million years

It really works…

Precise and extremely useful

But what sets their passwords? I still cannot log into the console. Somehow the admin needs to be entered into ofUser