0

We are trying to connect to presto using Dbvisualizer . and execute some queries . Catlog we are using is mysql .

  • Presto is installed in the linux server . presto cli is working fine in the linux . Started presto in linux .
  • Mysql is also installed in the linux machine . We are able to access mysql in windows using Dbvisualizer.
  • Created a mysql connector catalog for Presto. Successful in querying data of mysql using Presto-cli as presto --server localhost:8080 --catalog mysql --schema tutorials

DBvisualizer is installed in the Windows machine . I'm able to access mysql and execute queries . Presto also connected in Dbvisualizer . But we are unable to query data . When we try to run a query . It is giving us Error Executing Query .

enter image description here

There is not much information available online , We dont know what we are missing here , Can Someone explain me the way to do this . We need to execute queries from windows machine . we also tried from java code using jdbc jar . same exception

Added the Screenshot of Config.properties of the Presto Installation . Any property more to be added here? enter image description here . Any suggestion is appreciated . Thanks

Tarun teja
  • 59
  • 3
  • 7
  • Before I start diving in, Tarun, your ip address is showing still at the top of the image. Can you update the image to cover it? – Brian Olsen Feb 05 '21 at 16:07
  • What type of authentication are you using for your Presto cluster? – Brian Olsen Feb 05 '21 at 16:15
  • Hi Brain Olsen , Thanks for pointing out the visible ip .There are two ways i have tried connecting to Presto . 1.https://www.tutorialspoint.com/apache_presto/apache_presto_jdbc_interface.htm. 2.Using Dbvisualizer , using presto database driver in the dbvisualizer to connect . If you are talking about installing Password Authenticator in the Presto instance https://prestodb.io/docs/current/develop/password-authenticator.html . I have not installed it . – Tarun teja Feb 08 '21 at 05:38

1 Answers1

1

It seems like you haven't installed any way to authenticate to use Presto. The authentication that exists on your MySQL instance is not used to authenticate users that access your Presto cluster.

There is a critical security vulnerability in Presto where "authenticated users can bypass authorization checks by directly accessing internal APIs". This has only been resolved in the Trino (formerly PrestoSQL) distribution so I recommend you use Trino if you plan on running a secured cluster in production.

Your options on Trino are, LDAP authenticator, Password authenticator, and Kerberos authenticator (don't recommend unless you already use Kerberos). Configure these first before trying to use SSL/TLS on your server.

You can also find help you with any further questions for setting up a secure cluster on the Trino slack channel.

Brian Olsen
  • 935
  • 6
  • 17