How to configure SSL connection with MongoDB plugin 1.0.0

 

Provided steps for create SSL connection using MongoDB 1.0.0 Plugin

Install MongoDB server 3.4 and Open SSL.
 
  From MongoDB Side:
      
    Two Way SSL:  
      1. Craete ssl.conf file and add as:
        # SSL options
        sslMode = requireSSL # do not permit non-SSL connections
        sslPEMKeyFile = openssl\bin\mogodb.pem # PEM key file containing the private key of the server
        sslPEMKeyPassword = password # password (to decrypt private key)
        sslCAFile = openssl\bin\clientMongo.pem # PEM file containing CA certificate
    
      2. On Server execute:  mongod.exe --dbpath "<mongo_tempfile_path>" -f <sslconf path>\ssl.conf
       
      3. On client Execute Client:  mongo --ssl --sslCAFile <openssl\bin>\mongodb-cert.crt --sslPEMKeyFile <openssl\bin>\clientMongo.pem --sslPEMKeyPassword password
        
    
   One Way SSL:
       1.  Craete ssl.conf file and add as:
            # SSL options
            sslMode = requireSSL # do not permit non-SSL connections
            sslPEMKeyFile = openssl\bin\mogodb.pem # PEM key file containing the private key of the server
            sslPEMKeyPassword = password # password (to decrypt private key)
            #sslCAFile = openssl\bin\clientMongo.pem # PEM file containing CA certificate
      
      2. On Server execute:  mongod.exe --dbpath "<mongo_tempfile_path>" -f <sslconf path>\ssl.conf
         
      3. On client Execute Client:  mongo --ssl --sslCAFile <openssl\bin>\mongodb-cert.crt
        
 
  From BW Side:
      
      Start the MongoDB Server using : mongod.exe --dbpath "<mongo_tempfile_path>" -f <sslconf path>\ssl.conf
       
       1.Create BW project.
       2.Create Trusted certificate Folder(certs) as:
          Import Trusted Certificate.
       3..Create Identity activity and configure as:
          Type:  Certificate/Private
          Certificate URL: file://<openssl/bin>/monclient-cert.crt
          Key URL        : file://<openssl/bin>/monclient-cert.key
          Password       : password
          Apply it.      
        
       4. Create MongoDB Connection and select Security.
       5. Select Use SSL and configure it as:
           Trusted Certificate Folder : /certs/.folder
           Identity:  Leave it blank.  # If Identity selected it is two way connection else one way connection.
        
       6. click on "Test Connection", connection is successfull.   
           
     7.For more details use attached BW project in mongodb.rar