powered by Jive Software

Exporting sql / usernames / groups & PW's

Hi Everyone,

I’m hoping there is an easy way to do this. I manage a server with about 400 users on it.

v3.6.4 windows 2003 server / mysql DB

The server has been upgraded and patched and upgraded and patched… recently a lot of errors have cropped up but to make things easy I’m ready to nuke the install and start over, however I’d like to export the users and passwords and groups they belong to and reinsert them into the DB… is this possible or would it be easier to recreate everything…

The errors that show up look like this:

Aug 31, 2009 4:30:03 PM org.jivesoftware.webchat.util.WebLog logError
WARNING: Error in web client
java.lang.NullPointerException
at com.jivesoftware.smack.workgroup.user.Workgroup.(Unknown Source)
at org.jivesoftware.webchat.actions.WorkgroupStatus.getWorkgroup(WorkgroupStatus.j ava:294)
at org.jivesoftware.webchat.actions.WorkgroupStatus.isOnline(WorkgroupStatus.java: 170)
at org.jivesoftware.webclient.jsp.start_jsp._jspService(start_jsp.java:79)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1093)
at org.jivesoftware.webchat.SetCharacterEncodingFilter.doFilter(SetCharacterEncodi ngFilter.java:45)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)
at org.jivesoftware.webchat.SetupFilter.doFilter(SetupFilter.java:92)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:726)