Problem when connecting to Trino error object object

[norrova]

Problem

I'm trying to connect Cube.js to Trino, but I'm getting an error and I can't see the full details of it. Is there a way to access the full error message?

The trace mode is activated

[igorlukanin]

@norrova Are you getting the same error on the latest version of Cube?

[norrova]

Hello @igorlukanin,

I'm using the "latest" image from yesterday https://hub.docker.com/r/cubejs/cube/tags — was a fix produced today ?

It seems like this might be coming from somewhere like the Trino driver or something similar, but it’s hard to debug since everything is deployed, on a Kubernetes architecture.

For now, I’m trying to connect via HTTP.

Is there a way to test the connection to Trino through an endpoint to get a clearer, more concrete understanding of the issue?

Also, how should I configure Trino to communicate over HTTPS? Which variables or parameters do I need to enable? The documentation doesn’t seem very clear for me.

Thank you for your help.
Have a great day.

[igorlukanin]

Hi @norrova,

I think you're missing the CUBEJS_DB_PRESTO_CATALOG environment variable.

I've just tried running Trino with this config:

services:
  trino:
    image: trinodb/trino
    ports:
      - 8080:8080
    restart: unless-stopped

  cube_api:
    restart: always
    image: cubejs/cube:latest
    ports:
      - 4000:4000
    environment:
      - CUBEJS_DB_TYPE=trino
      - CUBEJS_DB_HOST=trino
      - CUBEJS_DB_PORT=8080
      - CUBEJS_DB_USER=trino
      - CUBEJS_DB_PASS=
      - CUBEJS_DB_PRESTO_CATALOG=tpch
      - CUBEJS_DEV_MODE=true
      - CUBEJS_API_SECRET=SECRET
    volumes:
      - .:/cube/conf
    depends_on:
      - trino

Worked like a charm for me:

[igorlukanin]

Please feel free to reopen if this is not fixed for you.