Help with Resetting Admin Account

Openfire Openfire Support
1

Hi Forum - I have inherited a domain which is using Wildfire 2.6.0. The previous admin attempted to have the userlisting link to our AD domain, but it doesn’‘t appear to be working properly. I can log in to the web admin console with my own user account, but I don’'t have admin rights to add/remove/change user accounts.

What I want to do is either grant my account the admin rights or to reset the admin account. I have logged in to the database via MySql and have found the jive tables where i see the “jiveuser” table with an administrator account. I have tried to change the administrator password there but still can’'t login with that particular account.

I’'m more of a network admin, dealing with switches and servers and am rather green when it comes to this side of the I.T./I.S. world. I am already expecting some responses with “2.6!!! dood upgrade!”, but in the meantime, all I need to be able to do is administer our existing user database.

Any help is greatly appreciated.

~MrMarty

2

Hi MrMarty,

please check conf/wildfire.xml to make sure whether you are connecting to LDAP/AD or not.

If you do then you can’'t change the user settings using Openfire as it uses a read-only account for LDAP.

I think that Wildfire stores AD users in the database only for roster management, so changing a password there is quite useless.

As you did grant admin to yourself using conf/wildfire.xml you have admin rights and should be able to change user passwords if you are using the database and not LDAP as the user provider.

You should also see some logs in logs/error.log if you try to change the password.

LG

3

Thanks LG. Well, To try and make it easier (or more complicated) I included the /chat/winfire.xml file below. I removed the password from the listing, just so it doesn’'t confuse us. Also, I logged in as my user user account (marty) and attempted to “delete a user” and copied the error below the winfire.xml listing. Thanks again for your help. I sincerely appreciate it.

Wildfire.xml file:

  • <![CDATA[ (&(member=)(objectClass=group))

]]>

My error after trying to delete a user:

Exception:

java.lang.UnsupportedOperationException: User provider is read-only.

at org.jivesoftware.wildfire.user.UserManager.deleteUser(UserManager.java:135)

at org.jivesoftware.wildfire.admin.user_002ddelete_jsp._jspService(user_002ddelete _jsp.java:90)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)

at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:830)

at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:11 8)

at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)

at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:43)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)

at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingF ilter.java:41)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)

at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:98)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)

at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler. java:471)

at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1530)

at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.ja va:633)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)

at org.mortbay.http.HttpServer.service(HttpServer.java:909)

at org.mortbay.http.HttpConnection.service(HttpConnection.java:816)

at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:982)

at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)

at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)

at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)

at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)

4

Hi MrMarty,

so you are using LDAP which is read-only for Openfire, a “User provider is read-only.” exception is fine. If you want to change something for a user you may use Windows AD tool.

I expect that your AD does not have a user “cn=admin, ou= goups, …” so you may never be able to login using “admin”.

LG

5

After I posted all that, I looked back and realized we were using LDAP and that makes sense. So maybe I’‘m looking at a different problem. scratches head All this started because as I have created new users and disabled old user accounts, the Pandion listing doesn’‘t update properly. I was under the impression that it was because I had to admin the Wildfire server, but now, I’'m a bit stuck.

6

Would it matter that what you’'ve got there is this:

My apologies if this is a dumb question – I’‘m not sure if the order matters for that kind of thing. I’'ve just started trying to install it myself and am running up against my own problems.