Cannot connect to trino engine and no useful error...
# ask-questions
f
Cannot connect to trino engine and no useful error message
1
and no log tells the error details, anyone can help?
f
are you able to connect to trino from command line?
w
Hi @future-printer-83389 ! Any success with Trino connection?
@fresh-football-47124 we also have issue with creating Data Source for TrinoDb. I'm getting
Access Denied: User abtests cannot impersonate user growthbook
while trying to create Trino connection. Snd I do have access with same user from same network (checked by running simple python script with sql query) where we run GrowthBook. Any idea or helpful resources? Is there particular log file that we may check for a more detailed error? Thanks
f
let me see if our team has a test connection for this
thankyou 1
w
@fresh-football-47124 if you guys might point me to the code point where the connection is created it would be helpful too. Thank you
f
f
Hi @fresh-football-47124 , I cannot connect to Trino from command line due to certificate error, the Trino is controlled by partner team, and I'd like to know whether it's the same error from growthbook. Is there any switch to open more useful log to locate the error?
f
there isnt anything particularly special we do
I think we let you add a certificate, no?
Its on our list to investage this this week, we'll try to reproduce it
f
I tried add the server's cert to trust but still failed by using command line. Partner team just provide Trino sdk rather than data interface. It's a bit difficult to work with them. I have to lock it's the Trino instance problem. Please notice me if you have progress. Thanks!
h
Hi all, this is the client we use to connect to Trino: https://www.npmjs.com/package/presto-client We are able to connect to our test database using this client. Can you try removing
https://
from your host name?
thankyou 1
f
Hi @helpful-application-7107 , I tried but failed also. Is there any way to know what error happened, because there's no log and message tells the error details.
w
@fresh-football-47124 @helpful-application-7107 in our case the issue is due to hardcoded
basic_auth
https://github.com/growthbook/growthbook/blob/main/packages/back-end/src/integrations/Presto.ts#L35
user
and
source
. It would be nice if this is configurable via UI. E.g. to have ability to avoid basic auth and set our own user and source. Thank you
h
Hmmm, can you help me understand? the
basic_auth
user and password are what you set in the UI. Is the problem that the top level
user
is not configurable?
w
yes, we do not need basic_auth (limit access in another way), but need top level user and source to be configurable for proper routing.
f
hi everyone - we've been working on some updates to the code to support more auth methods (including no auth)
👍 1
you can follow along here - https://github.com/growthbook/growthbook/pull/2720 - and if you were able to help us test it, that would be great
w
@fresh-football-47124 thanks a lot! Will test it.
t
@fresh-football-47124...would it be possible to share the docker image for this...need to test this in self hosted environment
h
Hi Saqib, we just landed the PR.
You can test it out with the latest deployment.
👍 1