Announcement

Collapse

NextGen (Mirth) Connect 3.10.0 Released!

NextGen (Mirth) Connect 3.10.0 is now available as an appliance update and on our GitHub page. This release includes better SQL Server database support, security improvements through fixes and library updates, and improvements for the Advanced Clustering plugin with a focus on improving performance of many of the tasks that are carried out on a frequent interval. See the release notes for the list of fixes and updates.

Download | See What's New | Upgrade Guide | Release Notes

For discussion on this release, see this thread.
See more
See less

Mirth Admin Password Recovery

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Mirth Admin Password Recovery

    How do I go about recovering a lost mirth admin password?

  • #2
    Re:Mirth Admin Password Recovery

    I am assuming I can use derbytools to connect to the built-in mirth database. I do a

    java -cp derbytools.jar org.apache.derby.tools.ij to get into the ij menu. I then type connect 'jdbc:derby:'; to make a connection, however, I get a message stating

    ERROR 08001: No suitable driver

    I then typed

    driver 'org.apache.derby.jdbc';

    and then got an

    IJ ERROR: Could not locate class org.apache.derby.jdbc

    Can anyone give me direction on the necessary driver to use and the connect string that I need to make?

    Comment


    • #3
      Re:Mirth Admin Password Recovery

      I was able to resolve my issue. I simply had to set my Java classpath to recognize the derby jar files and then issue the command

      connect 'jdbc:derby:/path-to-mirth/mirthdb';

      Then I was able to query the necessary tables.

      Comment


      • #4
        Re:Mirth Admin Password Recovery

        Thanks for the info on how you resolved this!

        Just a note - the next release of Mirth includes encrypted passwords, so this method might not work. (You could still login to the db and reset it, but you would not be able to recover it).
        Chris Lang

        Comment


        • #5
          Re:Mirth Admin Password Recovery

          I installed 1.5 over 1.4 and now I cannot login with admin admin anymore. Should I have uninstalled 1.4 first (after save all channels ) ??

          Comment


          • #6
            Re:Mirth Admin Password Recovery

            I installed 1.5 over 1.4 and now I cannot login with admin admin anymore. Should I have uninstalled 1.4 first (after save all channels ) ??
            I'm running derby, I also installed in a new directory. I know that the admin password is encrypted (derby-database.sql) but what is the decrypted value ?

            Are there any tools to verify the database ??

            Code:
            INFO   | jvm 1    | 2007/05/30 12:29:17 | WARN  2007-05-30 12:29:17,245 [SslListener0-1] org.mortbay.jetty.context.Mirth Server: /users: 
            INFO   | jvm 1    | 2007/05/30 12:29:17 | java.lang.NullPointerException
            INFO   | jvm 1    | 2007/05/30 12:29:17 | 	at com.webreach.mirth.server.servlets.UserServlet.login(UserServlet.java:104)
            INFO   | jvm 1    | 2007/05/30 12:29:17 | 	at com.webreach.mirth.server.servlets.UserServlet.doPost(UserServlet.java:62)
            INFO   | jvm 1    | 2007/05/30 12:29:17 | 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:616)
            INFO   | jvm 1    | 2007/05/30 12:29:17 | 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
            INFO   | jvm 1    | 2007/05/30 12:29:17 | 	at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
            INFO   | jvm 1    | 2007/05/30 12:29:17 | 	at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830)
            INFO   | jvm 1    | 2007/05/30 12:29:17 | 	at com.osmoticweb.gzipfilter.GZIP2WayFilter.doFilter(GZIP2WayFilter.java:54)
            INFO   | jvm 1    | 2007/05/30 12:29:17 | 	at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
            INFO   | jvm 1    | 2007/05/30 12:29:17 | 	at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471)
            INFO   | jvm 1    | 2007/05/30 12:29:17 | 	at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
            INFO   | jvm 1    | 2007/05/30 12:29:17 | 	at org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
            INFO   | jvm 1    | 2007/05/30 12:29:17 | 	at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633)
            INFO   | jvm 1    | 2007/05/30 12:29:17 | 	at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
            INFO   | jvm 1    | 2007/05/30 12:29:17 | 	at org.mortbay.http.HttpServer.service(HttpServer.java:909)
            INFO   | jvm 1    | 2007/05/30 12:29:17 | 	at org.mortbay.http.HttpConnection.service(HttpConnection.java:816)
            INFO   | jvm 1    | 2007/05/30 12:29:17 | 	at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:982)
            INFO   | jvm 1    | 2007/05/30 12:29:17 | 	at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)
            INFO   | jvm 1    | 2007/05/30 12:29:17 | 	at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
            INFO   | jvm 1    | 2007/05/30 12:29:17 | 	at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
            INFO   | jvm 1    | 2007/05/30 12:29:17 | 	at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
            SERVER STARTUP

            Mirth 1.5.0.2272 (May 24, 2007) server successfully started: Wed May 30 12:44:18
            CEST 2007
            This product includes software developed by SymphonySoft Limited (http://www.sym
            phonysoft.com) and its contributors.
            Running Java 1.5.0_07 on Windows XP (5.1, x86)


            Post edited by: huubvandemortel, at: 05/30/2007 03:42

            Post edited by: huubvandemortel, at: 05/30/2007 03:46

            Post edited by: huubvandemortel, at: 05/30/2007 03:51

            Comment


            • #7
              Re:Mirth Admin Password Recovery

              I somehow managed to lock myself out after the first time using Mirth, and it took me a half an hour to figure out how to reset the admin password so I thought I would leave instructions here for the next hapless soul like me.

              Note: I am using a Windows server with Mirth 1.7 and the default install path.

              1. First stop the Mirth server using the server manager, then open a command prompt using Start -> Run -> CMD.exe

              2. Browse to the Program Files->Mirth->lib folder

              3. Type: java -cp derbytools.jar;derby.jar org.apache.derby.tools.ij

              ij> connect 'jdbc:derby:c:/program files/Mirth/Mirthdb';
              ij> update person set password = 'NdgB6ojoGb/uFa5amMEyBNG16mE=', salt='Np+FZYzu4M0=' where username = 'admin';
              ij> exit;

              4. You can now start the Mirth server and login using admin as the password.

              Enjoy!

              --
              Greg Bray
              IT Manager
              OQ Measures LLC

              Post edited by: gbrayut, at: 06/26/2008 16:58

              Comment

              Working...
              X