Mark Ashworth

Designing applications, writing, photography and reading


Mark P Ashworth

Sending email to Gmail in Apache Camel

Setting up Gmail

All of the advise that most site provide is that you should allow less secure access to your Gmail account during the testing and then turn this setting off again afterwards.

Gmail 2-Step Verification

What I have found to work better is to enable 2-Step verification on your Gmail account and then to generate an App Password for the application instead of using the email account password.

App Password

Browse to the Sign-in and security section of the Gmail account and under the 2-Step Verification you’ll find the App Password section.

2017-05-03 Gmail Security Settings

After confirming your password, all the App Password are displayed and a link to generate a new App Password. The App Password will be used later instead of the email account password.

2017-05-03 Gmail App Password

Importing the Gmail certificate into the Java Keystore

I could only find two methods to retrieve the Google Gmail certificate, one being OpenSSL and the other being Python. Now my development machine is Windows and I did not want to go through the pain of setting up Cygwin only to execute one command so I instead opted for the Python approach. As a side note, I wanted to find a pure Java solution but to date have found none.


import smtplib
import ssl

connection = smtplib.SMTP()

f1=open('./gmail.pem', 'w+')
print >> f1, ssl.DER_cert_to_PEM_cert(connection.sock.getpeercert(binary_form=True))

The preceding code connects to and saves the certificate in the PEM Base64 encoding.


To be honest there are enough sources on the net on how to use OpenSSL to retrieve a certificate, so I will not polute the net with yet another.

Creating the certificate keystore

keytool -keystore cacerts.jks -importcert -alias gmail -file gmail.pem
keytool -list -keystore cacerts.jks

I guess the commands are pretty self explanatory, since the first performs the actual creation of the cacerts.jks file with the certificate gmail.pem being aliased by the name gmail. The second command lists the certificates within the cacerts.jks file.

Providing the SSL Context Parameters


In the define the properties for the location and the password for the keystore. A neat feature of Spring Boot is that the password can be overwritten by providing a environment variable THREESIXTY_KEYSTORE_PASSWORD which will keep the actual password away from prying eyes or opt for HashCorp Vault to keep this.

# Keystore


Next provide the creation of the SSLContextParameters object from the keystore location and password for Apache Camel.

   public SSLContextParameters sslContextParameters(
          @Value("threesixty.keystore.location") final String location,
      @Value("threesixty.keystore.password") final String password) {

       KeyStoreParameters store = new KeyStoreParameters();

       TrustManagersParameters trust = new TrustManagersParameters();

    SSLContextParameters parameters = new SSLContextParameters();

    return parameters;

Configuring a route to deliver a file to email

The route polls the directory for files and then enriches the exchange with a header field that will contain the attachment (i.e. the file itself) and then routes the file to the email smtps endpoint which will use the file as the body and as an attachment.

                 .routeDescription("Deliver file to Gmail")
                 .bean(new AttachmentProcessor())
                 .to("<Gmail Email Address>&password=<App Password>&");


public class AttachmentProcessor implements Processor {
    public void process(Exchange exchange) {

        try {
            byte[] file = exchange.getIn().getBody(byte[].class);
            String fileName = exchange.getIn().getHeader("CamelFileName", String.class);
            String path = exchange.getIn().getHeader("CamelFileAbsolutePath", String.class);
            String mimeType = Files.probeContentType(Paths.get(path));

            exchange.getIn().setHeader("mimeType", mimeType);
            exchange.getIn().addAttachment(fileName, new DataHandler(new ByteArrayDataSource(file, mimeType)));
        } catch (Exception e) {

A review of JavaScript drawing libraries for flowcharts, Gantt charts and timelines

Dr James Bayley


I manage my projects using my own ElephantPM project management methodology. This is a similar in many ways to PRINCE2 but is greatly simplified so that it is suitable for use by smaller organisations.

My needs

ElephantPM divides the Start-up stage into an analysis step and a planning step. During the analysis step it is necessary to create several diagrams,

  • A mind map showing the output of the Discovery Workshop
  • An “org chart” showing the breakdown of the project into Business Deliverables
  • A flow chart showing the order in which Business Deliverables should be made
  • A diagram showing the relationship between stages and the production of Business Deliverables

During the planning step it is necessary to produce

  • Gantt Charts showing the Project Schedule and Stage Schedules

Current solution

Over the years I have used various tools to produce these charts but I have now settled on Freemind and Microsoft Project 2010.

View original post 1,313 more words

Compute the RANK() for a group of records

Say for example that you have a table with transactions and you would like to index the records from 1…n on each supplier id and potentially at the same time do this in transaction date sequence.

Continue reading “Compute the RANK() for a group of records”

Three Sixty Material Design

Using the Material Design Bootstrap for the new version of ThreeSixty to conceptualize the design possible to make the user of the application easier for users. Have a look at and if you have any ideas those would be welcomed 🙂


To generate a logo of a Font Awesome Icon is real simple using the Logo Generator at MDB.

Below is the Three Sixty logo on the new proof on concept implementation based upon Google’s Material Design with the help of
2016-03-02 Pathfinder example logo

The first version released of the ThreeSixty web application to streamline the 360 review process for managers and employees.

Demo available at

Code available on GitHub

Stanley Plane for Christmas ;-)


Courage is not simply one of the virtues, but the form of every virtue at the testing point. C. S. Lewis

Maven support in WebLogic & JDeveloper 12.1.2

The following post by   details how to get the Maven Sync plugin by Oracle to push the Weblogic artifacts to Artifactory.

I used the procedure to upload the artifacts to Sonatype Nexus.

Blog at

Up ↑