Mirth Admin Password Recovery

[jglucky]

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

[jglucky]

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?

[jglucky]

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.

[chrisl]

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).

[huubvandemortel]

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 ) ??

[huubvandemortel]

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 ??

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

[gbrayut]

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