Tuesday, September 15, 2015

firefox chrome ERR_SSL_WEAK_SERVER_EPHEMERAL_DH_KEY

Cannot access the application through the Chrome Browser. The message indicates it's a problem with the BMS server. The following message comes up:
 
 Server has a weak ephemeral Diffie-Hellman public key
 
 ERR_SSL_WEAK_SERVER_EPHEMERAL_DH_KEY
 Hide details
 This error can occur when connecting to a secure (HTTPS) server. It means that the server is trying to set up a secure connection but, due to a disastrous misconfiguration, the connection wouldn't be secure at all!

Solution:

Open Server.xml file in tomcat conf folder and Add the below line:-

ciphers="TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256,TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA,
   TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384,TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA,TLS_ECDHE_RSA_WITH_RC4_128_SHA,
   TLS_RSA_WITH_AES_128_CBC_SHA256,TLS_RSA_WITH_AES_128_CBC_SHA,TLS_RSA_WITH_AES_256_CBC_SHA256,
   TLS_RSA_WITH_AES_256_CBC_SHA,SSL_RSA_WITH_RC4_128_SHA"

InSide

<Connector port="443" maxThreads="200" scheme="https" secure="true" SSLEnabled="true" keystoreFile="XXX" keystorePass="XXX" keystoreType="PKCS12"  clientAuth="false" sslProtocol="TLS" "ADD CIPHERS HERE"  />

Restart Tomcat Server..  |||||

Thursday, May 14, 2015

GPT To MBR Conversion -> Windows 7 and Ubuntu

This is the problem if windows 8 is not uninstalled properly, there is a chance of leaving back some installation files in the drives. This will disable users to detect drives formatted using windows or ubuntu installation disks.

Problems will be as -
1) Windows 7 installed but not allowing Ubuntu installation.
2) Ubuntu will not detect formatted drives, windows installation drives and shows to re-format the complete hard disk by showing it as one complete hard disk size.
3) Either Windows or Ubuntu will be installed but not dual operating system.
4) The disk is of format GPT and will not allow reinstallation.

Solution for this is to clean the hard disk.

1) Insert Windows installation CD or bootable USB.
2) Navigate up to formatting disk drives.
3) When format is not allowed, come to install windows screen (1st screen in the process).
4) Press "shift F10 (or) fn F10" buttons.
5) Command Line (cmd) window opens up.
6) Enter the following commands -
      sources > diskpart
      DISKPART > list
      DISKPART > select disk 0 [The disk where you want to install OS].
      Disk 0 is now the selected disk.
      DISKPART > clean
7) Close the cmd window.
8) Continue installation process.

Monday, January 12, 2015

OpenClinica Audit Related Tables

select audit_log_event_type_id from audit_log_event_type where name = 'Study Event signed';

select * from event_crf where event_crf_id = 1227;

select * from audit_log_event where entity_id = 945 and audit_log_event_type_id = 31;

select * from user_account where user_id  in (select user_id from audit_log_event where entity_id = 945 and audit_log_event_type_id = 31) ;

select user_name from user_account where user_id  in
        (select user_id from audit_log_event
            where
            entity_id = (select study_event_id from event_crf where event_crf_id = 1227)
            and
            audit_log_event_type_id = (select audit_log_event_type_id from audit_log_event_type where audit_log_event_type_id = 8)
        );

Friday, January 2, 2015

Pentaho DB's


DB Names:

1) vertica

2) http://www.microstrategy.com