# Logstash not able to connect to presto using logstash

**URL:** <https://discuss.elastic.co/t/logstash-not-able-to-connect-to-presto-using-logstash/176368>\
**Category:** Logstash\
**Created:** [April 11, 2019, 9:35am UTC](https://discuss.elastic.co/t/logstash-not-able-to-connect-to-presto-using-logstash/176368 "2019-04-11T09:35:06Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![yasin\_mohammed](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yasin_mohammed/32/64406_2.png) [@yasin\_mohammed](https://discuss.elastic.co/u/yasin_mohammed)\
**Post date:** [April 11, 2019, 9:35am UTC](https://discuss.elastic.co/t/logstash-not-able-to-connect-to-presto-using-logstash/176368/1 "2019-04-11T09:35:06Z")

</div>

Hi...

We have a cassandra database from where we were fetching data and it used to work properly. Now we are asked to connect to presto sitting on top of cassandra. After changing the driver class and path to presto I keep getting the no suitable driver found. I also added the driver to logstash-core/lib/jar. The issue still persists.

Sample of logstash conf below

> ```
> jdbc{
> # mysql jdbc connection string to our backup databse
> jdbc_connection_string => "jdbc:pretso://10.113.213.167:8081/cassandra/db"
> 
> # the user we wish to excute our statement as
> jdbc_user => "elk_user"
> jdbc_password => "Zsw2@Mji9@elk"
> 
> # the path to our downloaded jdbc driver
> jdbc_driver_library => "/usr/share/logstash/logstash-core/lib/jars/presto-jdbc-0.218.jar"
> 
> # the name of the driver class for mysql
> jdbc_driver_class => "com.facebook.presto.jdbc.PrestoDriver"
> 
> # the control statement
> #record_last_run=>true
> #type => "product"
> statement => "SELECT * FROM db.performance where time_stamp > '2019-03-27T00:00:00' AND time_stamp < '2019-03-28T00:00:00' ALLOW Filtering"
> 
> ```

Error Message

> [ERROR] 2019-04-11 10:22:45.714 [[main]\<jdbc] jdbc - Unable to connect to database. Tried 1 times {:error\_message=\>"Java::JavaSql::SQLException: No suitable driver found for  
> jdbc:pretso://10.113.213.167:8081/cassandra/imi\_datamartdb"}  
> [ERROR] 2019-04-11 10:22:45.760 [[main]\<jdbc] pipeline - A plugin had an unrecoverable error. Will restart this plugin.  
> Pipeline\_id:main

---

<div class="post-metadata">

**Author:** ![guyboertje](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/guyboertje/32/31592_2.png) [@guyboertje](https://discuss.elastic.co/u/guyboertje)\
**Post date:** [April 11, 2019, 12:09pm UTC](https://discuss.elastic.co/t/logstash-not-able-to-connect-to-presto-using-logstash/176368/2 "2019-04-11T12:09:05Z")

</div>

Is it `pretso` or `presto`?

---

<div class="post-metadata">

**Author:** ![yasin\_mohammed](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yasin_mohammed/32/64406_2.png) [@yasin\_mohammed](https://discuss.elastic.co/u/yasin_mohammed)\
**Post date:** [April 11, 2019, 12:47pm UTC](https://discuss.elastic.co/t/logstash-not-able-to-connect-to-presto-using-logstash/176368/3 "2019-04-11T12:47:03Z")

</div>

Damn....Missed a simple typo. Thanks for pointing it out.

---

<div class="post-metadata">

**Author:** ![guyboertje](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/guyboertje/32/31592_2.png) [@guyboertje](https://discuss.elastic.co/u/guyboertje)\
**Post date:** [April 11, 2019, 12:49pm UTC](https://discuss.elastic.co/t/logstash-not-able-to-connect-to-presto-using-logstash/176368/4 "2019-04-11T12:49:26Z")

</div>

Presto looks interesting.

I'd be interested to hear how you get on with it. Please feedback progress and success.

---

<div class="post-metadata">

**Author:** ![yasin\_mohammed](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yasin_mohammed/32/64406_2.png) [@yasin\_mohammed](https://discuss.elastic.co/u/yasin_mohammed)\
**Post date:** [April 12, 2019, 8:31am UTC](https://discuss.elastic.co/t/logstash-not-able-to-connect-to-presto-using-logstash/176368/5 "2019-04-12T08:31:57Z")

</div>

Sure.....I am now having trouble with certificates looks like I need to add certificates to jdbc connection.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [May 10, 2019, 8:36am UTC](https://discuss.elastic.co/t/logstash-not-able-to-connect-to-presto-using-logstash/176368/6 "2019-05-10T08:36:14Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.