[GitHub] [airflow] danielmorales72 commented on issue #16313: cryptography.fernet.InvalidToken when attempting to access connections

["danielmorales72 (via GitHub)" <gi...@apache.org>]

danielmorales72 commented on issue #16313:
URL: https://github.com/apache/airflow/issues/16313#issuecomment-1411852217

   @morningcloud I hit this issue after my Airflow helm update. I resolved it today without loosing any history data or whatever. The point is that you need to delete all of your existing airflow connections
   
   1. You will find them by looking at the PostgreSQL RDS
   
   ```
   airflow db shell
   SELECT conn_id FROM connection;
   ```
   2. Then iterate over them and delete, I used some bash for that
   
   ```
   #!/bin/bash
   
   declare -a arr=("airflow_db" "aws_default" "azure_batch_default" "azure_container_instances_default" "azure_cosmos_default" "azure_data_explorer_default" "azure_data_lake_default" "cassandra_default" "databricks_default" "dingding_default" "druid_broker_default" "druid_ingest_default" "elasticsearch_default" "emr_default" "facebook_default" "fs_default" "google_cloud_default" "hive_cli_default" "hiveserver2_default" "http_default" "kubernetes_default" "kylin_default" "livy_default" "local_mysql" "metastore_default" "mongo_default" "mssql_default" "mysql_default" "opsgenie_default" "pig_cli_default" "pinot_admin_default" "pinot_broker_default" "postgres_default" "presto_default" "qubole_default" "redis_default" "segment_default" "sftp_default" "spark_default" "sqlite_default" "sqoop_default" "ssh_default" "tableau_default" "vertica_default" "wasb_default" "webhdfs_default" "yandexcloud_default" "azure_default" "drill_default")
   
   for i in "${arr[@]}"
   do
       airflow connections delete ${i}
   done
   ```
   
   3. In my case 4 connections where not deleted with bash and I had to connect to RDS directly and delete them from the table
   
   ```
   airflow db shell
   SELECT * FROM connection;
   DELETE FROM connection WHERE id = <id from above>;
   ```
   
   After that my connections list was empty and I could visit the GUI or check in CLI. I just added the databricks connection back
   `airflow connections add ..` as it was the only connection we were using.
   
   
   
   
   
   


-- 
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: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org