musicmuthu commented on issue #20960: URL: https://github.com/apache/superset/issues/20960#issuecomment-1398068915
@justineyster i have tried to connect the trino using certificate connection but it' still point to password authentication. i tried from both versions superset 2.0.0 and 2.0.1 **trino://admin:[email protected]:30999/dna?verify=/vault/secrets/admin.pem** also the ca certificate also placed in ROOT Certificate path If i try from trino.jar from my linux local machine i'm able to login using certificate but not from superset my client certificate already there in superset and ca certificate loaded into the superset my superset_config for certificate auth changes is below: from typing import Any, Callable, Dict, List, Optional, Type from trino.auth import Authentication ALLOWED_EXTRA_AUTHENTICATIONS: Dict[str, Dict[str, Callable[..., Any]]] = { "trino": { "custom_auth": 'certificate' }, } SSL_CERT_FILE = "/vault/secrets/adfs.pem /usr/local/lib/python3.8/site-packages/certifi/cacert.pem" SSL_CERT_PATH = "/etc/ssl/certs" SSL_CERT_DIR = "/usr/local/lib/python3.8/site-packages/certifi" can you please point out where i did the mistakes. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
