mysql - Unable to query Presto database using Dbvisuallizer- Error Executing Query

Question

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 .

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? . Any suggestion is appreciated . Thanks

question from:https://stackoverflow.com/questions/66066169/unable-to-query-presto-database-using-dbvisuallizer-error-executing-query

Answer 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.