web stats
Unable to login to Administrator with 3.0.2 running on MySQL in Unix/Linux - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 04-21-2014, 12:24 AM
dzilberman dzilberman is offline
OBX.2 Kenobi
 
Join Date: Sep 2013
Location: San Francisco, CA
Posts: 71
dzilberman is on a distinguished road
Default Unable to login to Administrator with 3.0.2 running on MySQL in Unix/Linux

EDIT (by Nick Rupley):
  • This is due to the default case sensitivity settings of MySQL running on Unix environments. An issue has been created for it: MIRTH-3247. As a workaround, you can do this:
    Code:
    CREATE VIEW channel AS SELECT * FROM CHANNEL;

Hi Mirth team,

I was very excited to learn about Mirth 3.0.2 coming out and upgraded our Dev environment (hosted in AWS cloud) from 3.0.1 to that version while keeping the mirth.properties and other files in the ./conf folder intact (installer did).

The server starts up and has a few Channel deployment errors (pls see attached log file) but does show the message of it listening on ports 9080 and 9443 (both forwarded to outside world from AWS)

Quote:
...
INFO 2014-04-21 00:05:12,556 [Thread-2] com.mirth.connect.server.Mirth: Mirth Connect 3.0.2.7140 (Built on April 15, 2014) server successfully started.
INFO 2014-04-21 00:05:12,556 [Thread-2] com.mirth.connect.server.Mirth: This product was developed by Mirth Corporation (http://www.mirthcorp.com) and its contributors (c)2005-2014.
INFO 2014-04-21 00:05:12,556 [Thread-2] com.mirth.connect.server.Mirth: Running Java HotSpot(TM) 64-Bit Server VM 1.7.0_51 on Linux (2.6.32-358.el6.x86_64, amd64), mysql, with charset UTF-8.
INFO 2014-04-21 00:05:12,558 [Thread-2] com.mirth.connect.server.Mirth: Web server running at http://172.31.16.10:9080/ and https://172.31.16.10:9443/
Unfortunately, I can no longer login to either Web UI or MirthConnect Java client even after resetting default "admin/admin" credentials in my MySQL DB, PERSON_PASSWORD table:

UPDATE PERSON_PASSWORD SET PASSWORD = 'YzKZIAnbQ5m+3llggrZvNtf5fg69yX7pAplfYg0Dngn/fESH93OktQ==' WHERE PERSON_ID = 1

I have attached the mirth.properties and fragment of mirth.log files. Would really appreciate someone's quick response as our Mirth Dev environment is completely down since last Friday!

thanks,
Dan Z.
Attached Images
File Type: jpg MIrthConnect302_login_error.jpg (39.3 KB, 21 views)
Attached Files
File Type: txt mirth_302_upgraded.properties.TXT (1.7 KB, 16 views)
File Type: txt mirth_302_startup_channelerr.log.TXT (26.5 KB, 11 views)

Last edited by narupley; 04-23-2014 at 04:39 PM.
Reply With Quote
  #2  
Old 04-21-2014, 12:26 AM
dzilberman dzilberman is offline
OBX.2 Kenobi
 
Join Date: Sep 2013
Location: San Francisco, CA
Posts: 71
dzilberman is on a distinguished road
Default

Java info:
java version "1.7.0_51"
Java(TM) SE Runtime Environment (build 1.7.0_51-b13)
Java HotSpot(TM) 64-Bit Server VM (build 24.51-b03, mixed mode)
Reply With Quote
  #3  
Old 04-21-2014, 07:56 AM
narupley's Avatar
narupley narupley is online now
Mirth Employee
 
Join Date: Oct 2010
Posts: 7,126
narupley is on a distinguished road
Default

The login error you're seeing does not indicate a user authentication error. It indicates that you don't have connectivity to that IP/port in the first place. Can you reach the 9080 launch page of your server in a web browser? Can you access the web dashboard (click on "Access Secure Site" on the launch page)? And can you telnet to 9443 from your local machine?

Regarding this error:

Code:
ERROR 2014-04-20 23:53:17,520 [Thread-2] com.mirth.connect.server.transformers.JavaScriptFilterTransformer: Filter/Transformer error
java.lang.Exception: com.mirth.connect.server.MirthJavascriptTransformerException:
SCRIPT SOURCE:  646a252d-0038-4e53-977e-d633667e2ddd
SOURCE CODE:
27: tmp = new XML(template);
28: function doFilter() { phase[0] = 'filter'; return true; }function doTransform() { phase[0] = 'transformer'; logger = Packages.org.apache.log4j.Logger.getLogger(phase[0]);
29:
30:
31: var mapping;try { mapping = tmp['web:accountRequest']; }catch (e) { logger.error(e);  mapping = '';}connectorMap.put('accountRequest', validate( mapping , tmp['web:accountRequest']['web:AccountId'], new Array()));
32: var mapping;try { mapping = FileUtil.encode(new java.lang.String(msg['Patient']').getBytes('UTF-8')); }catch (e) { logger.error(e);  mapping = '';}connectorMap.put('patientInfoEncoded', validate( mapping , '', new Array()));
33: var mapping;try { mapping = msg['Credentials']['partnerName'].toString(); }catch (e) { logger.error(e);  mapping = '';}channelMap.put('partnerName', validate( mapping , 'newcropdemo', new Array()));
34: var mapping;try { mapping = msg['Credentials']['name'].toString(); }catch (e) { logger.error(e);  mapping = '';}channelMap.put('name', validate( mapping , 'demo', new Array()));
35: var mapping;try { mapping = msg['Credentials']['password'].toString(); }catch (e) { logger.error(e);  mapping = '';}channelMap.put('password', validate( mapping , 'demo', new Array()));
36: var mapping;try { mapping = msg['Credentials']['productName'].toString(); }catch (e) { logger.error(e);  mapping = '';}channelMap.put('productName', validate( mapping , 'SuperDuperSoftware', new Array()));
LINE NUMBER:    32
LINE SOURCE:    var mapping;try { mapping = FileUtil.encode(new java.lang.String(msg['Patient']').getBytes('UTF-8')); }catch (e) { logger.error(e);  mapping = '';}connectorMap.put('patientInfoEncoded', validate( mapping , '', new Array()));
DETAILS:        missing ) after argument list

        at com.mirth.connect.server.util.javascript.JavaScriptUtil.compileAndAddScript(JavaScriptUtil.java:610)
        at com.mirth.connect.server.transformers.JavaScriptFilterTransformer.initialize(JavaScriptFilterTransformer.java:68)
        at com.mirth.connect.server.transformers.JavaScriptFilterTransformer.<init>(JavaScriptFilterTransformer.java:56)
        at com.mirth.connect.server.controllers.DonkeyEngineController.createFilterTransformerExecutor(DonkeyEngineController.java:804)
        at com.mirth.connect.server.controllers.DonkeyEngineController.convertToDonkeyChannel(DonkeyEngineController.java:591)
        at com.mirth.connect.server.controllers.DonkeyEngineController.deployChannel(DonkeyEngineController.java:210)
        at com.mirth.connect.server.controllers.DonkeyEngineController.deployChannels(DonkeyEngineController.java:189)
        at com.mirth.connect.server.controllers.DonkeyEngineController.redeployAllChannels(DonkeyEngineController.java:328)
        at com.mirth.connect.server.Mirth.startup(Mirth.java:270)
        at com.mirth.connect.server.Mirth.run(Mirth.java:154)
Caused by: com.mirth.connect.server.MirthJavascriptTransformerException:
SCRIPT SOURCE:  646a252d-0038-4e53-977e-d633667e2ddd
SOURCE CODE:
27: tmp = new XML(template);
28: function doFilter() { phase[0] = 'filter'; return true; }function doTransform() { phase[0] = 'transformer'; logger = Packages.org.apache.log4j.Logger.getLogger(phase[0]);
29:
30:
31: var mapping;try { mapping = tmp['web:accountRequest']; }catch (e) { logger.error(e);  mapping = '';}connectorMap.put('accountRequest', validate( mapping , tmp['web:accountRequest']['web:AccountId'], new Array()));
32: var mapping;try { mapping = FileUtil.encode(new java.lang.String(msg['Patient']').getBytes('UTF-8')); }catch (e) { logger.error(e);  mapping = '';}connectorMap.put('patientInfoEncoded', validate( mapping , '', new Array()));
33: var mapping;try { mapping = msg['Credentials']['partnerName'].toString(); }catch (e) { logger.error(e);  mapping = '';}channelMap.put('partnerName', validate( mapping , 'newcropdemo', new Array()));
34: var mapping;try { mapping = msg['Credentials']['name'].toString(); }catch (e) { logger.error(e);  mapping = '';}channelMap.put('name', validate( mapping , 'demo', new Array()));
35: var mapping;try { mapping = msg['Credentials']['password'].toString(); }catch (e) { logger.error(e);  mapping = '';}channelMap.put('password', validate( mapping , 'demo', new Array()));
36: var mapping;try { mapping = msg['Credentials']['productName'].toString(); }catch (e) { logger.error(e);  mapping = '';}channelMap.put('productName', validate( mapping , 'SuperDuperSoftware', new Array()));
LINE NUMBER:    32
LINE SOURCE:    var mapping;try { mapping = FileUtil.encode(new java.lang.String(msg['Patient']').getBytes('UTF-8')); }catch (e) { logger.error(e);  mapping = '';}connectorMap.put('patientInfoEncoded', validate( mapping , '', new Array()));
DETAILS:        missing ) after argument list

        at com.mirth.connect.server.util.javascript.JavaScriptUtil.compileAndAddScript(JavaScriptUtil.java:609)
        ... 9 more
That's occurring because you have a syntax error in your transformer (highlighted in red).
__________________
Step 1: JAVA CACHE...DID YOU CLEAR ...wait, ding dong the witch is dead?

Nicholas Rupley
Work: 949-237-6069
Always include what Mirth Connect version you're working with. Also include (if applicable) the code you're using and full stacktraces for errors (use CODE tags). Posting your entire channel is helpful as well; make sure to scrub any PHI/passwords first.


- How do I foo?
- You just bar.
Reply With Quote
  #4  
Old 04-21-2014, 10:44 AM
dzilberman dzilberman is offline
OBX.2 Kenobi
 
Join Date: Sep 2013
Location: San Francisco, CA
Posts: 71
dzilberman is on a distinguished road
Default

Thanks Nick for getting back to me.
I can certainly see the secured Web UI login page:

https://mirthconnect-dev-375423265.u...n/Index.action

(which is a forward of the AWS server's instance that shows in the mirth.log file: https://172.31.16.10:9443) - pls see attached screenshot as well. If you hav a sec, please try logging in as "admin/admin" - I have reset the password in PERSON_PASSWORD

I cannot launch the JNLP link b/c of security restrictions of my current location, but it also works for direct Internet connection:

http://mirthconnect-dev-375423265.us...webstart.jnlp?

Understood about transformer syntax error (extra ') but that shouldn't prevent logging in to Web and MirthConnect Java clients, correct? Please suggest other areas I can look at. I think there are other users that complain about inability to authenticate into Java client after upgrade to 3.0.2?

thanks!
Dan Z
Attached Images
File Type: jpg Invalid_Credentials_3.0.2.jpg (91.6 KB, 9 views)

Last edited by dzilberman; 04-21-2014 at 10:46 AM. Reason: Added screenshot
Reply With Quote
  #5  
Old 04-21-2014, 11:16 AM
narupley's Avatar
narupley narupley is online now
Mirth Employee
 
Join Date: Oct 2010
Posts: 7,126
narupley is on a distinguished road
Default

It looks like the server is still starting. Did you just recently restart? And is there anything new in the server log?
__________________
Step 1: JAVA CACHE...DID YOU CLEAR ...wait, ding dong the witch is dead?

Nicholas Rupley
Work: 949-237-6069
Always include what Mirth Connect version you're working with. Also include (if applicable) the code you're using and full stacktraces for errors (use CODE tags). Posting your entire channel is helpful as well; make sure to scrub any PHI/passwords first.


- How do I foo?
- You just bar.
Reply With Quote
  #6  
Old 04-21-2014, 11:43 AM
dzilberman dzilberman is offline
OBX.2 Kenobi
 
Join Date: Sep 2013
Location: San Francisco, CA
Posts: 71
dzilberman is on a distinguished road
Default

No, I have restarted it last night. I unfortunately won't be able to access the MIRTH.LOG until late this afternoon PST, but certainly remember that the last 2 lines in it after a few restarts I performed yesterday and AFTER failed Web UI logins were still:

Quote:
INFO 2014-04-20 23:53:48,996 [Thread-2] com.mirth.connect.server.Mirth: Running Java HotSpot(TM) 64-Bit Server VM 1.7.0_51 on Linux (2.6.32-358.el6.x86_64, amd64), mysql, with charset UTF-8.
INFO 2014-04-20 23:53:48,998 [Thread-2] com.mirth.connect.server.Mirth: Web server running at http://172.31.16.10:9080/ and https://172.31.16.10:9443/
Is there any additional LOG file that will be able to give me more info perhaps? I have placed a few external JARs into custom-lib folder (xom.jar, some Jason support library jar) - but these should not affect login process either just like transformer errors should not, right?

thanks Nick.

Dan Z
Reply With Quote
Reply

Tags
3.0.1, 3.0.2, login failure

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 02:29 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Mirth Corporation