Tjyylli

I'm trying to connect push data from MySQL to elasticsearch using logstash over SSL.
Elasticsearch and mysql resides on IBM cloud.
logstash config file set up is

input {

    jdbc {

        jdbc_validate_connection => true

        jdbc_connection_string => "jdbc:mysql://<host>:<port>/<schema>?autoReconnect=true&useSSL=false"

        jdbc_user => "test"

        jdbc_password => "pwd"

        jdbc_driver_library => "D:/mysql-connector-java-8.0.12/mysql-connector-java-8.0.12.jar"

        jdbc_driver_class => "Java::com.mysql.cj.jdbc.Driver"

        jdbc_paging_enabled => true

        jdbc_page_size => 25000

        type => "location"

        statement => "SELECT  ENTITY_NAME,

                            SECONDARY_ENTITY_NAME,

                                KEYWORD,

                                DESCRIPTION,

                                LATITUDE,

                                LONGITUDE,

                                MAP_URL,

                                SHORT_URL,

                                REF_URL,

                                LANGUAGES                           

                                FROM LOCATION"

    }



}

filter{

            mutate{

                rename => {

                "entity_name" => "ENTITY_NAME"

                "secondary_entity_name" => "SECONDARY_ENTITY_NAME"

                "keyword" => "KEYWORD"

                "description" => "DESCRIPTION"              

                "map_url" =>"MAP_URL"

                "short_url" => "SHORT_URL"

                "ref_url" =>"REF_URL"

                "languages"=>"LANGUAGES"



                 }







        }

        if [latitude] and [longitude]!="" {

        mutate {

            rename => {

                "latitude" => "[LAT_LON][lat]"

                "longitude" => "[LAT_LON][lon]"

            }

        }

    }











}       

output {

    elasticsearch {

        action=>"index" 

        hosts=>["https://<id>:<pwd>@<hostname>:<pot>/"]

        index=>"test_location"

        document_type=>"%{type}"

        ssl=>true

        ssl_certificate_verification=>true

        cacert=>"D:/Data/Logstash-ES-6.5-Mapping/ca_logstash.cer"

    }

    stdout {}

}

I am getting error as

[ERROR][logstash.pipeline ] Error registering plugin
{:pipeline_id=>"main",
:plugin=>"#", :error=>"No
certificate data found", :thread=>"#"}

I know it is not able to get certificate data. tried giving exact path, that is also not working?

Is the configuration setting correct?