openfire admin 복구 방법.

1. openfire 설치방법
2. openfire db 설치

openfire console 암호 복구 방법

1. DB에 서버에 접속을 합니다.
제가 사용하고 있는 database는 postgres을 사용하고 있습니다.

postgres@tingcobell:~> psql openfire

openfire=# select * from ofuser ;
 username | plainpassword |                        encryptedpassword                         |     name      |        email         |  creationdate   | modificationdate
----------+---------------+------------------------------------------------------------------+---------------+----------------------+-----------------+------------------
 admin    |               | 7a36d7a36d7a36d7a36d7a36d7a36d7a36d7a36d7a36d | Administrator | tingcobell@xxxx.co.kr | 001282181976484 | 0
(1 row)

openfire=# update ofuser set plainpassword='1234', encryptedPassword=null where username='admin';
UPDATE 1
openfire=# select * from ofuser ;
 username | plainpassword | encryptedpassword |     name      |        email         |  creationdate   | modificationdate
----------+---------------+-------------------+---------------+----------------------+-----------------+------------------
 admin    | 1234          |                   | Administrator | tingcobell@krg.co.kr | 001282181976484 | 0
(1 row)