Hello, my openfire server was running without any problem before move to redhat enterprise linux 5. I installed openfire 3.7 on RHEL and working fine. But now I can’t login to admin console as a admin. General users are able to login through spark messenger. I googled and tried all of advices but no luck.
/etc/inid.d/openfire stop
DELETE FROM OFPROPERTY WHERE NAME=‘admin.authorizedJIDs’;
INSERT INTO OFPROPERTY VALUES(‘admin.authorizedJIDs’,‘admin@example-com’);
COMMIT;
/etc/inid.d/openfire start
/etc/init.d/openfire stop
<?xml version="1.0" encoding="UTF-8"?>…
<authorizedJIDs>admin@example.com</authorizedJIDs>
…
/etc/inid.d/openfire start
/etc/init.d/openfire stop
update ofUser set plainPassword=‘something’, encryptedPassword=null where username=‘admin’
/etc/init.d/openfire start
My openfire.xml file permission is like :
[root@sparkftp openfire]# ls -ld /opt/openfire/conf/openfire.xml
-rw-r–r-- 1 daemon daemon 1808 Jun 6 20:04 /opt/openfire/conf/openfire.xml
I use root as a username for the connection to mysql database and gave it all privilidges too.
When I try to login to admin console as a admin it gives me error like:
Login failed: make sure your username and password are correct and that you’re an admin or moderator.
What should I do now? Please help me.
Thank you.
openfire logs.rar.zip (58607 Bytes)