initialization-actions icon indicating copy to clipboard operation
initialization-actions copied to clipboard

Fixing cloud-sql-proxy.sh

Open xby-G opened this issue 1 year ago • 1 comments

Fix the script to adopt two scenarios:

  1. No source list file needs to be updated
  2. Multiple source list files need to be updated

xby-G avatar Jun 02 '24 20:06 xby-G

/gcbrun

kuldeepkk-dev avatar Jun 26 '24 13:06 kuldeepkk-dev

That looks like a good idea

cjac avatar Jul 19 '24 18:07 cjac

Tested manually in:

  • 2.2-debian12 ✅
  • 2.1-debian11 ✅
  • 2.0-debian10 ✅
  • 1.5-debian10 ✅
  • 2.2-rocky9 ✅
  • 2.1-rocky8 ✅
  • 2.0-rocky8 ✅

I used these metadata to configure hive:

    --initialization-actions "${INIT_ACTIONS_ROOT}/cloud-sql-proxy/cloud-sql-proxy.sh" \
    --properties "hive:hive.metastore.warehouse.dir=gs://${HIVE_DATA_BUCKET}/hive-warehouse" \
    --metadata "hive-metastore-instance=${PROJECT_ID}:${REGION}:${HIVE_INSTANCE_NAME}" \
    --metadata "db-hive-password-uri=gs://${BUCKET}/dataproc-initialization-actions/mysql_hive_password.encrypted" \
    --metadata "kms-key-uri=projects/${PROJECT_ID}/locations/global/keyRings/KEYRING/cryptoKeys/KEYNAME" \

cjac avatar Jul 19 '24 20:07 cjac