How do I go about recovering a lost mirth admin password?
Announcement
Collapse
No announcement yet.
Mirth Admin Password Recovery
Collapse
X
-
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?
-
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
-
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)
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
-
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
Comment