If your intent to use OAuth with Trino, you must ensure your Trino URL indicates that a token will be passed to the driver.
Where an access token is obtained by our support of OpenID from whatever IDP, and the claims the IDP adds to the token are those Trino expects to see etc.
Your Trino version must be 376 or above due to defects they had.
https://www.ibm.com/docs/en/cognos-analytics/11.2.0?topic=details-connections-that-support-jwt-authentication
Assuming you have correctly configured (server side) trino re jwt and user mapping from the tokens is receives etc.
Plus as applicable your trino rules json file grants the users access to the catalogs in trino and so forth.
https://trino.io/docs/current/security/jwt.html?highlight=jwt
------------------------------
NIGEL CAMPBELL
------------------------------
Original Message:
Sent: Tue April 11, 2023 04:52 PM
From: Dhanush
Subject: Cognos connection with Trino
Hi Mark.
Thanks for your response.
We were able to establish connection. Instead of trying through oAuth authentication, we enabled one user to login through credentials and configured it in datsource. We were successful.
We are planning to follow up with Starburst/Cognos for oAuth authentication.
Thanks for your response.
Thanks!
Thanks!
Dhanush
------------------------------
Dhanush
Original Message:
Sent: Fri April 07, 2023 09:08 AM
From: Mark Fry
Subject: Cognos connection with Trino
I don't have access to Trino at all, unfortunately, so there's nothing I can test/check. Have you opened a ticket with IBM Support?
Cheers!
MF.
------------------------------
Mark Fry
Technical Consultant
Original Message:
Sent: Fri April 07, 2023 08:20 AM
From: Dhanush
Subject: Cognos connection with Trino
Hi Mark,
Thanks for your response.
Initially we tried with user email id where authentication happens through oAuth but then have switched to user without special character and getting the same error. Any lead on where could be the issue?
We do not have access to starburst cluster, And connection from DB client (DBeaver) is working.
Please let us know if any other steps have to be taken care.
Thanks!
------------------------------
Dhanush
Original Message:
Sent: Wed April 05, 2023 09:31 AM
From: Mark Fry
Subject: Cognos connection with Trino
Hi,
I found this technote which details one cause of the error when trying to connect to Trino:
https://www.ibm.com/support/pages/msrgen0071-internal-error-getting-catalogs-and-schemas-0
Have you checked to see if there are any special characters in the username?
Cheers!
MF.
------------------------------
Mark Fry
Technical Consultant
Original Message:
Sent: Wed April 05, 2023 06:42 AM
From: Dhanush
Subject: Cognos connection with Trino
Hi Team,
Has anyone tried connecting Cognos with Starburst or Trino? Inspite of providing username/password, we are not able to load the schema definition, we are getting an error "MSR_GEN_0071 Internal error getting catalogs and schemas for: XXXXX".
We have Starburst deployed in GCP but do not have much control on Starburst cluster.
Please share your experience in creating data source connection to Trino/Startburst.
Thanks!
------------------------------
Dhanush
------------------------------